[rkamarowskiParticipant]

Is anyone else doing this?

[rkamarowskiParticipant]

Thank you.

[rkamarowskiParticipant]

Thank you.

[rkamarowskiParticipant]

The problem is with my provider.

Thanks.

[rkamarowskiParticipant]

So an observableArray can be used with database data? I was told it was for local data only. Perhaps I misunderstood.

[rkamarowskiParticipant]

It’s not even getting that far. If the limit is 100 or above mysqli is not returning any resutls.

Code:

// Connect to the database
$mysqli = mysqli_connect($hostname, $username, $password , $database) or die("Unable to Connect to database" );

$sql="SELECT ";
        $sql .= "VehicleMakeID, ";
        $sql .= "VehicleMakeName ";
        $sql .= "FROM Vehiclemake ";
        $sql .= "WHERE Active = True ";
        $sql .= "ORDER BY VehicleMakeName ";
        $sql .= "LIMIT 0 , 500";

$result=mysqli_query($mysqli, $sql);

while ($row = $result->fetch_array(MYSQL_ASSOC))
    {
   $vehicleMake[] = array(
        "VehicleMakeID" => $row["VehicleMakeID"],
        'VehicleMakeName' => $row["VehicleMakeName"]);
    }

echo json_encode($vehicleMake);

/* close statement */
$result->close();
/* close connection */
$mysqli->close();

[rkamarowskiParticipant]

Anyone?

[Author]

Posts