Sometimes, it gives you some info after syntax error.
What does it say? Also if you are using access, run
your query in the database and when it fails, usually
the cursor stops at the failing point and you can
identify what is wrong. Also print the sql statement
and check if it has any illegal characters like
quotes(').
Ramalakshmi.
--- Venkatesh Thathathripuram <[EMAIL PROTECTED]>
wrote:
> Hi ,
>
>
> I get a "syntax error in insert into statement"
> error
> when I use the following,
>
> sql = "insert into
>
Merchant(MerchantID,Name,Address1,Address2,City,PinCode,Password)
> values ('" & MMerchantID & "', '" & MName & "', '" &
> Madd1 & "', '" & Madd2 & "', '" & Mcity & "', '" &
> Mpin & "','" & Mpassword & "')"
>
>
> All fields are text and all of them can accept null
> characters. Please help
>
>
>
>
______________________________________________________________________
>
> Post your free ad now! http://personals.yahoo.ca
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
------------------------ 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/
