Cold Fusion invalid character error being thrown.

The attached file is throwing an error:

Error Executing Database Query.  
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character  
 
The error occurred in D:/inetpub/wwwroot/23_Reports/23QueueStatusDetailRpt.cfm: line 28
 
26 : <cfset grandCount = 0>
27 :
28 : <cfquery name="queueData" datasource="#dsn#">
29 : Select
30 :      distinct q.queue_name,

I've attached the cfm file in .txt format

Does anyone see why this is being thrown? Its working in another report with a different query but I can't find why it's being thrown.

Thanks,
query23.txt
QuackdeveloperAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
Get rid of the ending ';'.

It is necessary for SQL tools but not Cold Fusion and other tools

Change:
order by 1,2,3,4,5,6,7,8;

to:
order by 1,2,3,4,5,6,7,8
0
 
slightwv (䄆 Netminder) Commented:
Are you sure you posted the correct file?  I cannot find any difference between it and the working one (queue_status_report_01.txt) in your other question.  Well except the title: <title>24 Queue Status Detail</title>
0
 
QuackdeveloperAuthor Commented:
check that one...sorry. Very little sleep last night trying to figure this out. Due by EOD Friday and I still have to set up the excel version.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
slightwv (䄆 Netminder) Commented:
Check which one?
0
 
QuackdeveloperAuthor Commented:
I deleted the first and uploaded the correct version under the same name...the file that is currently attached.
0
 
QuackdeveloperAuthor Commented:
I believe that fixed it...I have a user account issue preventing the report from running but I feel it will fix it. You're a beautiful person!

Will mark everything on this appropriately as soon as I confirm everything. THANKS!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.