MySQL newbie syntax question

Hello - I'm trying to learn some of the syntaxing for mysql. I know access real well, and I'm just trying to learn the minor differences. I'm trying to have WWF check for a value in the database (an expiration date), and I created an ASP page to open up the database, but I'm getting the following error:
Microsoft VBScript runtime error '800a01a8'

Object required: ''

It's pointing to the line where I open the database:

    'Query the database
    rsCommon.Open strSQL, adoCon

So obviously something isn't set right. I used the dbconnection(everything is set fine inthsi file as the board runs) include file on this page, and have the following code:

GID = "5" ' just set for sample purposes

        strSQL = "SELECT " & strDbTable & "Author.* " & _
    "FROM " & strDbTable & "Author" & strDBNoLock & " " & _
    "WHERE " & strDbTable & "Author.Author_ID = " & GID & ";"

       
    'Query the database
    rsCommon.Open strSQL, adoCon   
       
    If NOT rsCommon.EOF Then
       
        'Grab users group ID
        ID = rsCommon("Group_ID")

Is this an incorrect way to just get all the fields from this specific Author_ID? Is there something else I need to set with the connection first ( I have to add the closing part of the code of course)? Help is really appreciated. Thanks.

your SQL string seems correct.

Though it is very rare, sometimes a corrupted database cause this problem.

WebWiz-Bruce wrote: The part strDBNoLock is only used for SQL Server databases.

Bruce isn't wwf use different values for strDBNoLock and strDBRowLock according to strDatabaseType variable value?

WebWiz-Bruce wrote: The part strDBNoLock is only used for SQL Server databases.

Freadkdaddy, as Bruce said, it is only used for SQL Server databases.

However there is another variable which controls the value of "strDBNoLock". This variable "strDatabaseType". When you set strDatabaseType = "mySQL" in database/database_connection.asp off WWF installation, strDBNoLock becomes an empty variable with no value. So, it is all the same using the variable or not. But make sure you have a trailing space in your SQL syntax after these variables.