OraFAQ Forum: Server Administration » Building SQL string and need single quotes

Home » RDBMS Server » Server Administration » Building SQL string and need single quotes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Building SQL string and need single quotes [message #372784]

Fri, 09 March 2001 09:15

Allan Jagos
Messages: 3
Registered: March 2001

Junior Member

I am building a SQL query string which needs to have single quotes aorund a list of items. But SQL is seeing my single quotes and processing them as double single quotes which doesn't work.

<cfset txtDepFile = txtDepFile & "','" & txtFile>

The SQL that gets processed looks like this:
OR ppaDepositions.Attachment in ('Depo1.txt'',''Depo2.txt'',''test.doc')

What cna I do to account for single quotes transforming into double quotes?

Thanks

Report message to a moderator

Previous Topic:	Where Field is Part of a list
Next Topic:	"recover standby database until cancel" in script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 12:19:56 CST 2025