Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 Error in Registration Page
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

AaronThorne
Starting Member

1 Posts

Posted - 18 June 2001 :  04:58:35  Show Profile
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'M_EMAIL = 'dawn.o'connor@realhealthcare.co.uk''.

/forum/rug/register.asp, line 134


Not being a coder I couldnt find a work around or fix myself.

I can guess that its becuase the email address contains a ' which is causing the error.

This could be a big problem in countries like Ireland :)

Any help or a quick fix would be appreciated

Thanks in advance



Edited by - AaronThorne on 18 June 2001 04:59:42

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 25 June 2001 :  12:08:23  Show Profile  Visit HuwR's Homepage
In Register.asp look for this line

strSql = strSql & ", " & "'" & chkString(Request.Form("Email"),"email") & "'"

and change it to

strSql = strSql & ", " & "'" & chkString(Request.Form("Email"),"SQLString") & "'"

Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07