Thanks for your reply.
Can i use temporary tables in CF9? I never use this before.
I try this:
<cfquery name="tempTable" datasource="#application.str_dsn#">
create table #tempIDS (myID int);
insert into #tempIDS (myID)
I am getting error "Invalid CFML construct"
The invalide construct error is because of the # in the temp table syntax, so you'll need to double that up.
The problem with your attempt to mix it with QofQ is that you cannot mix a db query and a QofQ query - they get processed by totally different systems. You are going to need to take the temp table route, so that you can replace the list of IDs in the WHERE clause of the SELECT statement with a subquery that gets the IDs out of the temp table. If using a #temp table does work then you will need to create an actual table and then drop it when you're done.
Thanks for you reply and help.
I try the double ## and now I am getting error: ORA-00911: invalid character.
I cannot use real table because my online user doesn't have create or delete permissions.
Anyone use temp tables in CF9 and oracle 11g?