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:[EMAIL PROTECTED]] > Sent: Friday, October 19, 2001 6:27 AM > To: [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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:[EMAIL PROTECTED]] > > > Sent: Thursday, October 18, 2001 1: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] > > > -- 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]