VBScript error - Unterminated string constant

[JohnBates]

OK kiddies, here's an easy one for you pros -

VBScript compilation error '800a0409'
Unterminated strin constant

I'm using Internet Explorer 5.5
here's the sql stmt.....

Many thanks, John


sql = "INSERT INTO SystemsAccessReqs (UserNameL, UserNameF, UserNameMI, UserPhoneW, UserPhoneH, UserFax,
Dept#, JobTitle, NewWS, ExistingWS, NewUser, ExistingUser, Marcam, JDE, WMS, PR, TA, NT, NTRoam, LNotes,
LNotesGroup, ColorLaser, DialUpAccess, Modem, ModelAS400, ModelNT, SerReqComments,
DateSubmitted) VALUES ('" & strNameLast & "', '" & strNameFirst & "', '" & strNameMI & "', '" & strPhoneW & "',
'" & strPhoneH & "', '" & strPhoneFax & "', '" & intDept & "', '" & strJobTitle & "', '" & blnNewWS & "',
'" & blnExWS & "', '" & blnNewUser & "', '" & blnExUser & "', '" & blnMarcam & "', '" & blnJDE & "',
'" & blnWMS & "', '" & blnPR & "', '" & blnTA & "', '" & blnNT & "', '" & blnNTRoam & "', '" & blnLNotes & "',
'" & blnCLaser & "', '" & blnDialUp & "', '" & blnModem & "', '" & strModelAS400 & "', '" & strModelNT & "',
'" & strLNotesGroup & "', '" & strSRComments & "', '" & datCurDate & "');"

 

[MNClimber]

Does one of your variables contain a double quote??

I just ran into that problem with mine...

Mike

 

[FengShui1998]

JohnBates,

I believe you have a variable called "intDept" which is desgnated as an integer. However you have strings around it. This would cause a problem and give you an errant message like the one you received.


fengshui_1998

 

[JohnBates]

Mike - Thanks; I don't THINK I have a double quote anywhere... but after staring at a screen for 20 years, my eyes aren't as good as they used to be

fengshui_1998 - You are probably correct. But how should I refer to int and boolean data types ?

Thanks, John

 

[FengShui1998]

JohnBates,

Remove the single quotes before and after the variable.

'" & strPhoneH & "', '" & strPhoneFax & "', '" & intDept & "', '" &

Should be:

'" & strPhoneH & "', '" & strPhoneFax & "'," & intDept & ", '" &



fengshui_1998

 

[JohnBates]

Thanks fengshui_1998

Your suggestion worked. John