I created an app using Access and Mssql7.
it works perfect on it but i need to get it to run on Postgresql and Mysql.
The problem im having is that everytime i try to run an insert from a text
field or file into the database
and the text field contains a backslash it fails..
i have tried doing:
replacenocase(string,"\","\\","ALL");
and it seems to work fine until i run into a text that has '\'
(quote-backslash-quote)
then my query fails.. it looks something like this..
Inser into table (column) values('''\''')
it gives me a parse error..
is there a simple way of fixing this? a tag maybe?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
