RE: [PHP-DB] Re: Newbie: odbc_prepare & parameters

Does fldFlight contain the character "?" If it does, you must use: WHERE fldFlight='?' Are you using ? as a wildcard? -----Original Message----- From: Michael J. Eisner [mailto:michael.eisner@utanet.at] Sent: Thursday, October 18, 2001 12:53 PM To: php-db@lists.php.net Subject: [PHP-DB] Re: Newbie: odbc_prepare & parameters 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" <michael.eisner@utanet.at> schrieb im Newsbeitrag news:20011018163048.66887.qmail@pb1.pair.com... > 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: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net