I thank you Ramalakshmi,
when i checked that query in access "designer view",I found that i shouldn't
use '(single quote)to number data type and for check box (yes/no)value in that
"Update query".
Thank you much for helping me.
God bless!
Ramalakshmi Ramadas <[EMAIL PROTECTED]> wrote:
Try this:
strSQL = copy your code inside con.execute() to this
And then Response.write(strSQL) Response.end
Execute the sql in access/sql and find out the error.
Ramalakshmi.
--- samson kumar <[EMAIL PROTECTED]> wrote:
>
> 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]
>
>
>
>
>
__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
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 the Yahoo! Terms of Service.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
