Re: Re: Newbie: odbc_prepare & parameters

Andrew, you mean to activate the ODBC-Tracing of the OperatingSystem? When I activate this, nothing is being logged. OS is WIN2000 Prof. Database: ACCESS 2000 Diver: normal MS ODBC-Driver of WIN2000 Michael "Andrew Hill" <ahill@openlinksw.com> schrieb im Newsbeitrag news:NDBBKFNCBCHANEGAKONKCEJFKHAA.ahill@openlinksw.com... > 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 > > > > > > > >