[bexlhoward1]

Hi, I need to find out if a row has been returned, does anyone know how I would do this, I am using Access.

Thanks

Bex.

[bexlhoward1]

This is the line that i need to work with Access rather than mySQL:

if (mysql_num_rows($res)==1) {

Thanks

[bexlhoward1]

I dont think I can use mySQL for an Access database can I?

[Amadeus]

I believe it is odbc_num_rows(). Alternatively, you can run a loop of the the returned recordsets and count them, or even have a separate query to get the count, something like

$count="SELECT count(*) as result FROM (".$myquery.") AS numofrecords ";

[bexlhoward1]

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?

Im not really sure how your second suggestion would work.

Thanks

[Amadeus]

You have to use the odbc_connect() function if you want to use any other odbc functions...it's preferred over the COM objects.

[bexlhoward1]

Im affraid I cant because of restrictions on the server. I have been told I have to use COM.

Does this mean there is no way of finding out if a record has been returned?

[snoj]

isset($query['field_id'])?

[Amadeus]

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:

if (!$conn = new COM("ADODB.Connection"))
        exit("Unable to create an ADODB connection<br>");
    $strConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("\db\search.mdb"); 
    $conn->open($strConn); 
    $strSQL = "SELECT * FROM mytable"; 
    $rs = $conn->execute($strSQL);

Using ADODB style objects and collections, the correct way to check to see if there are any records would be

if($rs->EOF)
{
//there are no records
}
else
{
//there are some records
//number of records can usually be accessed through the $rs->recordset()
}

[bexlhoward1]

Hi, yes this is the way I have set it up. This statement does not work because there are records in the database just no records matching the query. This means I get a horrible error. Any ideas?

Thanks again.

[Amadeus]

The EOF should be catching the fact that no records have been returned...that's it's function. What is the error you're getting? Post it exactly please.

[bexlhoward1]

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.

Thanks.

[Amadeus]

You have to check and see if there are any records before you access a field from that record...as posted above, your code should follow the format below:

if($rs->EOF)
{
\\there is no data...do NOT try and access members...
}
else
{
//there is data...this is the section in which you would access members
}

$rs is the recordset retuned from your query...it will contain either some records or no records...it is based on your query.

[bexlhoward1]

I seem to have this working now! Thank you so much for the help. Wish I could use MySQL, would be so much easier! Thanks.

[cyberscribe]

bexlhoward1, on Mar 5 2005, 10:27 AM, said:

Wish I could use MySQL, would be so much easier!

Yep.