Hello all,
I am new member.Recently started in ASP.
I got this error when i am trying to update the records..
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
/college/Update.asp, line 71
code is here:
set rs=con.execute(" UPDATE college SET Bachelor='"&
Trim(Request("bachelor"))&"', Diploma='"&Trim(Request("diploma")) &"',
Masters='"&Trim(Request("masters")) &"', Research='"&
Trim(Request("research"))&"', College_Name='"& Trim(Request("collegename"))&"',
add='"& Trim(Request("add"))&"', Zip='"& Trim(Request("zip"))&"', state='"&
Trim(Request("state"))&"', Enrolment='"&Trim(Request("students")) &"',
BGCOed='"&Trim(Request("coltype")) &"', CBH='"&Trim(Request("CBH"))&"',
PBH='"&Trim(Request("PBH"))&"',CGH='"&Trim(Request("CGH"))&"',PGH='"&Trim(Request("PGH"))&"',
status="&Trim(Request("status")) &", ContName1='"&Trim(Request("contname1"))
&"', ContEmail1='"&Trim(Request("contemail1")) &"', ContPhone1=
'"&Trim(Request("contphone1"))&"' where CollegeID=' "
&Trim(Request("collegeid")))&"''"
I am not understanding where i am doing mistake.
Above,BGCOed,CBH,CGH,PBH,PGH are "drop downs"."status" is "check box",other are
"text boxes".
data type of "collegeid" is "(number)/Long Integer" in MS-Access
database."status" datatype is "yes/no",BGCOed,CBH,CGH,PBH,PGH and other too
have data types as "text" .
Pls help me to do update.
Thanks in advance.
~samson.
---------------------------------
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
