Having a ' symbol in Names (1 Viewer)

bloody_football

Registered User.
Local time
Tomorrow, 06:05
Joined
Sep 8, 2004
Messages
70
I have thousands of cards in my database. If the name of the card has the ' symbol in it (e.g Aladdin's Ring) then the database returns an error because it beleives the ' in the name is an instruction.

Any way around this?

James
 

Kodo

"The Shoe"
Local time
Today, 15:05
Joined
Jan 20, 2004
Messages
707
you must replace the single apostrophe with two. For instance: if I had a variable (LastName) that held the value "O'Reily" and I used this variable in an insert statement, then it would throw an error. What you need to do is this:

LastName=replace(LastName,"'","''")
 

Users who are viewing this thread

Top Bottom