Hi all,
i'm really new in php (working on my first project9 and i got the following
situation:
i have a loop going through a result set of an odbc-query. each row of this
loop has to be checked if there is an entry in another table. so as the last
odbc-query is the same for each row except they key-field, i tried to use
the odbc_prepare function and a parameter array. but it doesn't work.
I got no errormessages.
this is how it looks like - and doesn't work:
******
...
...
$sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, fldCaptDuty,
fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, fld_F_Flown
FROM tblBookings WHERE fldFlight = '?' AND fldBookDate =#".$EngDatum."#";
$ergDispatch=odbc_prepare($conDispatch,$sql);
While (odbc_fetch_into($ergRouten, &$datRouten))
...
...
$Para = array($datRouten[0]);
odbc_execute($ergDispatch,$Para);
...
...
*****
The array is filled correctly, but the odbc_execute function doesNn't bring
back any value, but there are definitvly rows where there should be a
result.
Thanks in advance!
Michael J. Eisner
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
