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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Sending private message to user with ' in name		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

MarcelG
Retired Support Moderator

Netherlands
2625 Posts
Posted - 13 February 2004 :  05:36:04  Show Profile  Visit MarcelG's Homepage
I'm having a problem with sending a private message to a user who has an apastrophe (') in his/her name.
I'm getting this error:


Microsoft JET Database Engine error '80040e14' 

Syntax error (missing operator) in query expression 'M_NAME = 'Roland van 't Kruys''. 

/forum/privatesend_info.asp, line 136

Any suggestions ?
portfolio - linkshrinker - oxle - twitter

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 13 February 2004 :  06:02:52  Show Profile
Just run the name through the CheckString() function:
strSql = strSql & " WHERE M_NAME = '" & ChkString(arrNames(i),"SQLString") & "' "
Support Snitz Forums
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts
Posted - 13 February 2004 :  06:14:02  Show Profile  Visit MarcelG's Homepage
Davio, you are my hero of the week
portfolio - linkshrinker - oxle - twitter
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 13 February 2004 :  07:22:00  Show Profile
For the whole week? Wow!!
Support Snitz Forums
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.34 seconds. Powered By: Snitz Forums 2000 Version 3.4.07