I have a problem! the following code does not work:
<cfset ID = url.ID>
<cfquery name="test" datasource="UfICourses" username="administrator"
password="administrator">
SELECT * FROM corskeys WHERE ID = #ID#
</cfquery>
the datasource definitely exists, the username and password are definitely
right, and the SQL table definitely exists with 550,000 recs in it. The
value of #ID# is an integer which is the data type of the field ID.
I get the following error message:
CMemoryException: unknown cause
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (7:1) to (7:95).
This code runs fine in ISQL. I have also tried hard-codeing in a value for
ID but that doesn't work either. I have also tried converting it to an SP
but, although the SP works ok, CF produces the same error.
Any ideas?
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
------------------------------------------------------------------
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
