Hi all,
sorry, there was a mistake:
> $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."#";
should read
FROM tblBookings WHERE fldFlight = ? AND fldBookDate =#".$EngDatum."#";
^^^^^^
there should the parameter be used.
Michael Eisner
"Michael J. Eisner" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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]
