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=lists&body=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=lists&body=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=lists&body=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: > > > password="administrator"> > SELECT * FROM corskeys WHERE ID = #ID# > > > 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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFQUERY/CFSTOREDPROC error
I have a problem! the following code does not work: SELECT * FROM corskeys WHERE ID = #ID# 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.