Just a guess, but try a value other than ID, as it is often a reserved word
and may cause problems.
Jim
----- Original Message -----
From: "Andy Ewings" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, September 26, 2000 1:01 PM
Subject: CFQUERY/CFSTOREDPROC error
> 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.
------------------------------------------------------------------------------
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.
