all about quotes

[Chris Aernoudt]

I guess the same as any other SQL interpreter... all you normally need
to do is to replace ' with ''... (except if the user can input, unless
you don't care about SQL injection attacks...)

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Tim Davis
Sent: donderdag 19 juni 2003 10:14
To: valentina at lists.macserve.net
Subject: all about quotes

Hello everyone,

    I need to get clear on how Valentina handles quotes in SQL 
statements.

1. What is the difference between using single quotes and double quotes 
marks to surround literal strings in SQL statements?

2. What is the best way to escape quotes within, beginning or ending an 
SQL statement's literal string value, with repeating quote marks or the 
"\" character?

3. Are there any other characters in an SQL statement literal string 
values (other than quote marks) which requires escaping with "\" so it 
doesn't mess with interpretation?

Thank you very much!
Tim Davis

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina