Ask a Question related to Coldfusion Database Access, Design and Development.
-
EssexJohn #1
Query of Queries Suddenly Stopped Working
I have pages that have been working for months which use the query of queries
feature in Coldfusion. They've suddenly just stopped working. All report the
same error message -
Error Executing Database Query.
null
The error occurred in
C:\WebSites\IMAP\IMAP\modules\receiving\action\act _Purchase_History.cfm: line 62
Called from C:\WebSites\IMAP\IMAP\modules\receiving\index.cfm: line 63
Called from C:\WebSites\IMAP\IMAP\htdocs\receiving.cfm: line 8
Called from
C:\WebSites\IMAP\IMAP\modules\receiving\action\act _Purchase_History.cfm: line 62
Called from C:\WebSites\IMAP\IMAP\modules\receiving\index.cfm: line 63
Called from C:\WebSites\IMAP\IMAP\htdocs\receiving.cfm: line 8
60 :
61 : <!--- Combined History query --->
62 : <cfquery name="Purchase_History" dbtype="query">
63 : SELECT Deal_List.T_Deal_Header_ID, Deal_List.Purchase_Date,
Deal_List.Goods_ETA_Date,
64 : Vendor_List.strCompanyName, Deal_List.tblPREmployee_ID,
Deal_List.Total_Deal_Cost,
Here is the top four lines of the stack trace -
java.sql.SQLException
at coldfusion.sql.JdbcImpl.getConnection(Unknown Source)
at coldfusion.sql.JdbcImpl.getConnection(Unknown Source)
at coldfusion.sql.SqlImpl.execute(Unknown Source)
at coldfusion.tagext.sql.QueryTag.doEndTag(Unknown Source)
Any ideas why the query of queries feature would just stop working? I was
hoping this was a known problem with a known answer. I'm re-writing pages as
fast as I can to query the database but the application is used to run our
company and is HUGE.
Thanks
EssexJohn Guest
-
#38816 [Opn]: PHP code that was working perfectly recently stopped working.
ID: 38816 User updated by: mtoohee at gmail dot com -Summary: PHP code that was working perfectly recently stopped.... -
CF Server Suddenly Stopped Serving
Hi, all, Let me describe the symptoms, as well as I can remember them. In summary, my test server has stopped ... well ... serving. I get "Cannot... -
Serial column has suddenly stopped working
I have been using a serial column in my most important postgres table for a couple of years. But today it has suddenly started assigning zero... -
ps 6 g4 os9 suddenly stopped menubar display - help!
ps was working fine until several things we added to the computer 0sx, iomega cdrw external drive and canon camera software. i've shut off every... -
SVM (DiskSuite) suddenly stopped working
We have just installed Solaris 9 on an Enterprise 450 and created a DiskSuite mirror containing two stripe/concat metadevices. The mirror works... -
EssexJohn #2
Re: Query of Queries Suddenly Stopped Working
By the way, this is Coldufsion 6.0, not 6.1. We never switched to 6.1 because we found out some pages would have to modified to work and just haven't taken the time to do it yet.
EssexJohn Guest



Reply With Quote

