Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
Chr1ssy #1
Statement did not generate a result set
I am getting an error on ColdFusion MX. The error message is 'Statement did
not generate a result set'. I am getting this when I am trying to update or
insert into a table. I used the same query in my Query Analyszer and the query
ran fine. I also moved to code to ColdFusion 5.0 (using the same database) and
I didn't receive the message. The one form field that could be causing the
issue is including HTML code. But I don't think that is the total reason since
the SQL statement will insert into everyother place. Any help would be great.
Thanks
Chr1ssy Guest
-
Generate XML from CFC...HELP
Can any of you CF experts help me visualize how a CFC needs to look to generate XML? Do I need to use CF tags to create the XML within a query and... -
Using ASP to Generate SQL Select Statement creates unexpected blank spaces
"Kaven Tan" wrote in message news:F2CAE485-4014-40C7-9A52-1007B51B290E@microsoft.com... : I am having a problem removing the blank space that is... -
Using PHP to generate Acrobat PDF...
Anyone have experience with it? Anyone of good information where I can do some research on? Thanks... -
Trying to generate an error
Response.Write CInt("x") Do you have an "On Error Resume Next" in your code? Ray at work "DrewM" <bogus@doesntexist.com> wrote in message... -
php generate thumbnails
Sir, I read in a thread that you mailed some code to generate thumbnails Might I also have a copy ? It's been driving me crazy, all week. Thanks... -
jorgeloyo #2
Re: Statement did not generate a result set
can you send a sample of the SQL string??
jorgeloyo Guest
-
Chr1ssy #3
Re: Statement did not generate a result set
UPDATE Questions SET Section_ID = 417, Format_ID = 5, Question_Admin = 0,
Question_AdminConfirmation = 0, Question_AdminVerbiage = '', DefaultQuestion_ID
= NULL, Question_Edit = 1, Question_Name = 'ACTIVITIES FOR SUNDAY, SEPTEMBER
19, 2004', Question_MinLength = NULL, Question_MaxLength = NULL,
Question_IsRequired = 1, Question_Description = '
', Question_BottomDescription = '
Please select an activity from the drop-down menu. Activity descriptions are
shown below.
', Question_Order = 10, Question_Fee = NULL, Question_Deadline = NULL,
Question_EarlyFee = NULL, Display_ID = NULL, Query_ID = NULL, Timestamp = {ts
'2005-02-17 11:28:06'}, User_ID = 47 WHERE Question_ID = 2555
Chr1ssy Guest
-
OldCFer #4
Re: Statement did not generate a result set
Timestamp is normally a reserved word, you might try changing it to something
else.
OldCFer Guest



Reply With Quote

