can't seem to get ride of the error:
microsoft VBScript compilation (0x800A03F2)
'expected identifier'

line 15 points to the code:

DIM theConn, rs, source, old, new, verify, email, sql, check, compare

any ideas? thx

TL

Tim,

"new" is a reserved word.  I would not use "compare" either.

Larry Woods - MCSD, MCT


> -----Original Message-----
> From: Tim Lyons [mailto:lyno@h...]
> Sent: Wednesday, July 17, 2002 7:00 PM
> To: Access ASP
> Subject: [access_asp] expected identifier
>
>
> can't seem to get ride of the error:
> microsoft VBScript compilation (0x800A03F2)
> 'expected identifier'
>
> line 15 points to the code:
>
> DIM theConn, rs, source, old, new, verify, email, sql,
> check, compare
>
> any ideas? thx
>
> TL
>

This is a multi-part message in MIME format.

------=_NextPart_000_00E2_01C22E4D.DAF4A1E0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Reserved words again :-)

Just like "Date" in your database is going to cause problems (what was 
wrong with "OrderDate" or something a little more descriptive), you 
really shouldn't use language keywords as variables (unless you want to 
be like this: http://mindprod.com/unmain.html )

Dim objConn        ' ADODB.Connection
Dim objRS          ' ADODB.Recordset
Dim strSQL         ' as String (SQL string)
Dim strOldUserName ' as String (old User Name)
Dim strNewUserName ' as String (new User Name)
Dim blnVerify      ' as Boolean (is user verified)
Dim strEmail       ' as String (new User Email addy)
Dim blnCheck       ' as Boolean (...)

you get the idea?

Try:
a) prefixing your variables with a type descriptor. this way, when we 
read your code, we have some idea what all these things are. Secondly, 
you'll neved make the mistake of doing:

    intMyVar =3D CInt(objCheck)

b) putting in something descriptive to describe what your variables 
actuall are for. dteTheDate is useless. dteOrderDate, 
dteBookingStartTime, dteBookingEndTime etc are far more useful.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Tim Lyons" <lyno@h...>
Subject: [access_asp] expected identifier


: can't seem to get ride of the error:
: microsoft VBScript compilation (0x800A03F2)
: 'expected identifier'
:
: line 15 points to the code:
:
: DIM theConn, rs, source, old, new, verify, email, sql, check, compare
:
: any ideas? thx
:
: TL