Re: FN-FORUM: SQL / programming Q

date posted 3rd October 2006 21:22

On 3 Oct 2006 20:00:12 -0000, Dai Williams [EMAIL REMOVED] wrote:
> You could try COUNT instead of count, it has never mattered in cases I have
> tried but the mysql documentation does show functions capitalised so it may
> be that your platform requires that? Did you try running the same query
> directly on the database (e.g. using mysql client or phpmyadmin)? I always
> find it pays to distinguish early between genuine SQL errors and code/driver
> issues.
>
I tried the uppercases but with no joy. I've run the query in MySQL
QueryBrowser and it worked. I assumed my recordset properties were OK
as I was not getting the usual Out Of Range error. This is the line
the executes the SQL:

objRec.Open strSQL, objCon, adOpenStatic, adLockReadOnly, adCmdText

Without using my ADO constants include file this translates as:

objRec.Open strSQL, objCon, 3, 1, &H0001

I'm not sure this means anything to PHPers.

Also for some reason I have to use:

objCon.CursorLocation = adUseClient

When using MySQL (not needed if I use MS):

adUseClient is a 3.

I think it's time call it a day. Will let you know how I get on (bet
you can't wait). Anyway thanks a lot. Hopefully I'm doing something
incredibly dumb I can spot tomorrow.

Paul