On Jan 23, 2006, at 7:44 AM, David Bovill wrote:
Thanks for the help!
NB - AFAIK PostGres and quoting goes like this - think it is the
same for standard SQP? Single quotes for text values and double
quotes for Table Names - if you don't have funny character, spaces
or reserved words in the table names you do not need to quote them
- but single quotes for table names is a no-no.
You are right, the SQL standard does specify double quote. MySQL on
the other hand prefers the ` character (numToChar(96)). It will only
accept double quotes if ANSI_QUOTES is enabled on the database
server. Valentina 1.x, on the other hand (which is not SQL92
compliant), will accept single quotes around a table name.
--
Trevor DeVore
Blue Mango Multimedia
[EMAIL PROTECTED]
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
