Results of update in CFQUERY

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Re: Results of update in CFQUERY

    And what about delete? Seems like delete does not return anything neither.
    supportcenter Guest

  2. Similar Questions and Discussions

    1. Cfquery Update Syntax Suddenly bad???
      The following code has been working for 2yrs or so; And suddenly I get the following error; Error Executing Database Query. Syntax error in...
    2. CFQuery displaying old results?
      No matter what i try, my cfquery is displaying old results. I've tried inserting cachedwithin="#createtimespan(0,0,0,0)#" into the cfquery, but it...
    3. MS Access UPDATE not updating with cfquery
      Three columns will update (GolaCalls, GoalContacts, and GoalAppts). However, the two columns FirstName and LastName remain unchanged even if there...
    4. CFQUERY - Calling results from one to supply inputs foranother
      Here's my code... ------------------------------------ <cfquery name="Recordset1" datasource="DB1"> SELECT * FROM dbo.tbl_Main LEFT JOIN...
    5. Error executing a cfquery update statement. PLEASE HELP
      I have been over and over this. I am trying to update a simple table. I took this script from the same server using a different DSN. I keep...
  3. #2

    Default Re: Results of update in CFQUERY

    It's similar to UPDATE just convert DELETE query to SELECT and run before deleting.
    CF_Oracle Guest

  4. #3

    Default Re: Results of update in CFQUERY

    If you're using sql server you might be able to use something like @@ROWCOUNT with a SET NOCOUNT ON statement to return the number of rows affected by an update or delete operation.
    mxstu 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