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

Hmm! Sometimes tracing needs to be turned off and then back on. The driver manager in Windows can be buggy. Also, select some drive level file to be safe, like c:/sql.log Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: Michael J. Eisner [mailto:michael.eisner@utanet.at] > Sent: Friday, October 19, 2001 6:27 AM > To: php-db@lists.php.net > Subject: Re: [PHP-DB] 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 > > > > > > > > > > > > > > > > > -- > 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 > > >