Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

' symbol in names

   X-Cart forums > General > General talk
Thread Tools
Old 05-11-2005, 07:18 AM
cotc2001 cotc2001 is offline

Join Date: Feb 2003
Location: Shrewsbury, UK
Posts: 2,351

Default ' symbol in names

Anyone know the answer to this one.

for example if a user has an irish name O'rielly if you try and edit that customers profile you get this error

INVALID SQL: 1064 : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near (and then all the users data)

I know that it's all to do with the ' symbol being used but does anyone know a easy fix for it?
x-cart 4.0.5 (live and heavily modded)
Server: freebsd
Reply With Quote
Old 05-11-2005, 07:37 AM's Avatar is offline

Join Date: Dec 2002
Posts: 747



INSERT INTO articles (title) VALUES ('John O''Hara''s nightmare');
X-Cart 3.5.x
Reply With Quote
   X-Cart forums > General > General talk

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT -8. The time now is 10:14 PM.


X-Cart forums © 2001-2020