Statement did not generate a result set

Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  1. #1

    Default 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

  2. Similar Questions and Discussions

    1. 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...
    2. 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...
    3. Using PHP to generate Acrobat PDF...
      Anyone have experience with it? Anyone of good information where I can do some research on? Thanks...
    4. 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...
    5. 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...
  3. #2

    Default Re: Statement did not generate a result set

    can you send a sample of the SQL string??
    jorgeloyo Guest

  4. #3

    Default 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

  5. #4

    Default Re: Statement did not generate a result set

    Timestamp is normally a reserved word, you might try changing it to something
    else.
    OldCFer Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139