Same problem...CMemoryException: unknown cause...need help

2002-01-15 Thread Jay Callaghan
I still don't know why it is doing this. I mean, it works fine on my system when I test it locally. Here is the error: CMemoryException: unknown cause PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY),

When Comparing two tables how do I.....

2002-01-11 Thread Jay Callaghan
Ok, I got the Union thing down pat and working 100%. Now I got 4 columns with related information that needs to be added together, then display the Top 10. To summarize what i am wanting to do. I got 2 tables with the same field types/names. I want to be able to connect to the two, add up the 4

CMemoryException: unknown cause (( HELP!! ))

2002-01-04 Thread Jay Callaghan
I am using the Microsoft Jet Engine to connect to the database and I get this error.: CMemoryException: unknown cause PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag I had this before and I re-created the database and it worked fine. I have since re-created this database 5 times and still

Re: Problem with percentages

2001-11-26 Thread Jay Callaghan
Well I have done it differently,but here is an idea May have to create a field for 1,2,3,4 and 5 (such as Opt1Count, Opt2Count, etc). Increment the field by one when the user submits the survey. Percentage: What I would do is: CFSET Num1Percent=#Evaluate((Opt1Count/Q1y)*100)# CFSET

Importing fields / info from Excel Spreadsheet to CF DB??

2001-11-15 Thread Jay Callaghan
Hey there, I know that it would be easy to just create a new table through MS Access and do it that way, but I need to know if there is a while to do it through Cold Fusion coding? I would like to run a cold fusion page that will access an Excel file and import the information from that sheet to