Hey folks, let me just start off by saying this: "I REALLY HATE MICROSOFT ACCESS."
there, I feel better now.
Ok, heres the situation. I'm working on a flight data QA tool for my work. Unfortunately, the raw data is stored in MS access and I have to pull from that data. Everything is going fine and dandy except for this
$flightcounter = 0;
while($flightcounter < $max2){
$query = "SELECT Lattitude, Longitude FROM Positions where MsgDateTime > $ontime[$flightcounter] AND MsgDateTime < $offtime[$flightcounter] AND UnitId = '$tail[$flightcounter]'";
$rs = $db_connection->execute($query);
$lat = $rs->Fields('Lattitude');
$long = $rs->Fields('Longitude');
$counter = 0;
while (!$rs->EOF) {
echo( $lat->value . " - ");
echo($long->value . "<br>\n");
$rs->MoveNext();
}
$flightcounter++;
}
which returns the following error:
Warning: (null)(): Invoke() failed: Exception occurred. Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null) in C:\Inetpub\outerlink\scripts\calculate.php on line 271
Fatal error: Call to a member function on a non-object in C:\Inetpub\outerlink\scripts\calculate.php on line 273
It seems that Access is saying my number going in is too big (Unix Epoch Seconds, i.e. number of seconds since 1970, which is what access stores its date/time values in) so now I'm stuck. Any ideas on how to get around this stupid, idiotic, moronic, Microsoftian error?
Thanks.
