RE: CFQUERY/CFSTOREDPROC error
spot on.I figured it out late last night it's either because CF doesn't like a field called text or doesn;t like the data type of that field - ntext (after your mail I'm guessing it's the latter)thanks -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: 27 September 2000 03:01 To: CF-Talk Subject: Re: CFQUERY/CFSTOREDPROC error On Tue, 26 Sep 2000 18:01:08 +0100, Andy Ewings [EMAIL PROTECTED] wrote: 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). I don't know if this applies to you, but last time I got that error it was because the db had fields of type ntext, and CF 4.0 freaked out on that - something to do with unicode i think? But from what I understand that error message is a general "holy sh*t, something's happened" type of error that can have a multitude of causes. Good luck. __ Kay Smoljak - HTML/ColdFusion Developer - PerthWeb Pty Ltd Internet Solutions for your business! Level 9/105 St George's Tc - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007 Visit Perth online! : www.perthweb.com.au -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFQUERY/CFSTOREDPROC error
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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFQUERY/CFSTOREDPROC error
On Tue, 26 Sep 2000 18:01:08 +0100, Andy Ewings [EMAIL PROTECTED] wrote: 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). I don't know if this applies to you, but last time I got that error it was because the db had fields of type ntext, and CF 4.0 freaked out on that - something to do with unicode i think? But from what I understand that error message is a general "holy sh*t, something's happened" type of error that can have a multitude of causes. Good luck. __ Kay Smoljak - HTML/ColdFusion Developer - PerthWeb Pty Ltd Internet Solutions for your business! Level 9/105 St George's Tc - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007 Visit Perth online! : www.perthweb.com.au -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.