|
Subject:
|
Microsoft VBScript compilation (0x800A03EA)
|
|
Posted By:
|
srm_kumar
|
Post Date:
|
11/10/2006 1:50:54 AM
|
hi,
any body can help me?
i'm having problem in my asp code. when i'm executing the update statement, i got the following error:
Microsoft VBScript compilation (0x800A03EA) Syntax error /sonalumni/chkupdtpersonal.asp, line 146, column 10 QryUpdate &= "business_type='" & strTbusiness & "', position='" & strPosition & "', jobspln='" & strSpln & "'," ---------^
due to this problem, i am being stucked last 3 weeks in my program. pls help me to find solution...
thanks & regds, mohan.
|
|
Reply By:
|
dparsons
|
Reply Date:
|
11/10/2006 12:42:15 PM
|
your SQL query is incorrect:
QryUpdate = quryUpdate & "business_type='" & strTbusiness & "', position='" & strPosition & "', jobspln='" & strSpln & "',"
I assume QryUpdate is a variable and not part of your sql statement.
------------------------- I will only tell you how to do it, not do it for you. Unless, of course, you want to hire me to do work for you.
^^Thats my signature
|
|