Quack
asked on
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_Repo rts/23Queu eStatusDet ailRpt.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
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character
The error occurred in D:/inetpub/wwwroot/23_Repo
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
Are you sure you posted the correct file? I cannot find any difference between it and the working one (queue_status_report_01.tx t) in your other question. Well except the title: <title>24 Queue Status Detail</title>
ASKER
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.
Check which one?
ASKER
I deleted the first and uploaded the correct version under the same name...the file that is currently attached.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!!!
Will mark everything on this appropriately as soon as I confirm everything. THANKS!!!