Hi Rick, no, where the '?' stands should be the value of the parameter given by the odbc_execute function. And this value changes everytime when a new result row of the other query is selected.
Michael "Rick Emery" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 12:53 PM > To: [EMAIL PROTECTED] > 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" <[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] > > -- 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]
