Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
wein #1
Re: 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?
wein 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... -
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... -
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:... -
"regex literal in condition"
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello all, I'm getting an erorr that I don't understand. # My code while gets. break if... -
BSterner #2 Re: Problem with Query of Queries and "In" condition
A workaround would be to output the raw data in your subquery. Not sure what
this would do to performance if the list is large.
<cfquery dbtype="query" name="qryNonCachedCustNos">
SELECT customerId FROM qryCustNos
WHERE customerId NOT IN
(#QuotedValueList(qryCustInfoFromCache.customerId) #);
</cfquery>
BSterner 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
