Ask a Question related to Coldfusion Database Access, Design and Development.
-
spotted dog #1
Oracle problem - escaping "&" in query
I am having an issue with utilizing the escape clause in CF against an Oracle
db. I am trying to select data from a table where the "where" clause uses an
"equal to" text string. Embedded in the text string is an ampersand "&". While
building the query in a SQL tool, TOAD, I used the escape character "\" prior
to the "&" and the select returned 5 rows of data which is correct. When
inserted into CF however, the select returns only 3 rows, leaving off the two
rows that have the matching "&" in them. Is there something in CF that is
parsing the escape character incorrectly perhaps? How would CF look at this?
spotted dog Guest
-
Drag and drop problem with "dragEnabled" and"allowMultipleSelection"
Update 2, if it can help someone: Finally I don't manage the drag and drop by myself using DragManager.doDrag(...). Why? Because doing so if the... -
Problem with Query of Queries and "In" condition
So is there a way to resolve this. I'm having a similar problem with query of queries? -
ColdFusion+cfquery+Oracle+CLOB+"Query of Query"
Error message is: Query Of Queries runtime error. Unsupported SQL type "java.sql.Types.CLOB". My database table: RESMIGAZETEFIHRISTI: ... -
cfgrid inside a <cfoutput query="myQuery" group="GROUP">
Is it possible to use a cfgrid inside a cfoutput with a query and a group. When I try do that I get the following error: INVALID_CHARACTER_ERR:... -
[PHP] Escaping the " ' " character
>I need to print the following: with a slash. http://www.google.com/search?&q=php+single+quote+escape+site%3Aphp.net ... -
Dan Bracuk #2 Re: Oracle problem - escaping "&" in query
If you need a backslash to escape ampersands, use the cold fusion replace function to put it there for you.
Details are in the cfml reference manual. If you don't have one, the internet does.
Dan Bracuk Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
