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

Go to topic 40653

Return to index page 124
Return to index page 123
Return to index page 122
Return to index page 121
Return to index page 120
Return to index page 119
Return to index page 118
Return to index page 117
Return to index page 116
Return to index page 115