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

Michael, Have you generated an ODBC trace? You can see what values are being passed into ODBC and where the error is occurring. Also, knowing what driver/database/platform would help :) Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers office:781.273.0900 x 27 mobile:781.608.4217 > -----Original Message----- > From: Michael J. Eisner [mailto:michael.eisner@utanet.at] > Sent: Thursday, October 18, 2001 1: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 > > >