Professional Web Applications Themes

cfquery - Macromedia ColdFusion

I am trying to use debug in a query and it is a no go(should show at bottom of page). the query is working because I am getting recordcounts. Then only thing that has changed is our hosting company switched from 5.0 to MX. Does this not work anymore in MX/ They have looked on their end and everything looks good. Here is the simply query: <cfquery name="update" datasource="sbh" debug> Select * From Categories </cfquery>...

  1. #1

    Default cfquery

    I am trying to use debug in a query and it is a no go(should show at bottom of
    page). the query is working because I am getting recordcounts.
    Then only thing that has changed is our hosting company switched from 5.0 to
    MX. Does this not work anymore in MX/ They have looked on their end and
    everything looks good. Here is the simply query:


    <cfquery name="update" datasource="sbh" debug>
    Select *
    From Categories
    </cfquery>

    ducman Guest

  2. #2

    Default Re: cfquery

    Hi

    i think they may forgotten to check the debug settings in the CFMX server.?

    vkunirs Guest

  3. #3

    Default cfquery

    is there any way of adding an additional field (that does not actually exist in
    the tables) when i make a query. what is happening is that i have a couple of
    queries that are all joined up into one large query and I would like to include
    an additional field that would let me know from which one of the tables the
    data is comming from. something like this:

    cfquery name="thequery"....
    ... get data from table A...

    cfquery name="thequery"....
    ... get data from table B...

    and i would like a new var to exist "whichtable" so that when i loop through
    my query result si know which table the data came from

    _mvm Guest

  4. #4

    Default Re: cfquery

    > cfquery name="thequery".... 
    through 


    First query:
    SELECT "table1" AS table_name, tableA.*
    FROM tableA

    Second:
    SELECT "table2" AS table_name, tableB.*
    FROM tableB

    --
    <mack />



    Neculai Guest

Similar Threads

  1. cfquery bug...still?
    By jlerath in forum Coldfusion Server Administration
    Replies: 2
    Last Post: November 30th, 06:06 PM
  2. CFQuery issue
    By colesc8 in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: September 9th, 03:47 PM
  3. Output from Cfquery
    By mike in forum Coldfusion Database Access
    Replies: 0
    Last Post: March 29th, 04:52 PM
  4. need help with cfquery
    By mkauspe in forum Coldfusion Database Access
    Replies: 3
    Last Post: March 24th, 11:11 PM
  5. CFQUERY with IF THEN ELSE
    By mike2004 in forum Coldfusion Database Access
    Replies: 10
    Last Post: March 4th, 03:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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