insert and ' 1

[help120]

I'm having problems inserting info into one of my tables. This is my string.

a1,id,a2,ltptype,a3,question,a4,answer,a5
('', 'test's', 'AssignmentIssues', 'AssignmentIssues teset')

As you can see test's has a ' and it causes an error when trying to insert the info. How can i correct this? Do I need to put // in front of it or some thing?

 

[danielhozac]

Yes, you need to escape the ' with a \, making it \'.

//Daniel