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

' symbol in names

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

X-Man
  
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
  #2  
Old 05-11-2005, 07:37 AM
  ETInteractive.com's Avatar 
ETInteractive.com ETInteractive.com is offline
 

X-Adept
  
Join Date: Dec 2002
Posts: 747
 

Default

O''Reily

mysql>
INSERT INTO articles (title) VALUES ('John O''Hara''s nightmare');
__________________
ETInteractive.com
X-Cart 3.5.x
Reply With Quote
Reply
   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 09:42 PM.

   

 
X-Cart forums © 2001-2020