Re: Checking If A Row Has Been Returned

Posted 05 March 2005 - 07:24 AM

I am trying to find out if there are no rows returned. The first option gives me an error, I am using connecting do the database using this code:
if (!$conn = new COM("ADODB.Connection"))
exit("Unable to create an ADODB connection"); could this be why?

Re: Checking If A Row Has Been Returned

Re: Checking If A Row Has Been Returned

Posted 05 March 2005 - 09:10 AM

It's really better to use inherent sql and related php object members when you can...check out this example of a DSNless connection with php - for full code, goto JuicyStudio, that's where this example is from:

Re: Checking If A Row Has Been Returned

Posted 05 March 2005 - 10:05 AM

The error (which is staring to get really annoying now) is:

Warning: main(): PropGet() failed: Exception occurred. Source: ADODB.Field Description: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. in e:\webareas\hr112\easyfly\pages\results.php on line 263

Line 263 is where the first variable containing data from the database is printed.