Query of Queries on query New type query

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

  1. #1

    Default Query of Queries on query New type query

    In CF5 we have a page that creates a query, using queryNew and querySetCell and
    the like, we then used dbtype="query" and gave it's name so we could use query
    of queries to sort it. We just tried this in 7 and it blows up saing
    datasource "blah" could not be found. Is this a BUG in 7 or were we taking
    advantage of a BUG in 5

    david_h Guest

  2. Similar Questions and Discussions

    1. Need Help with Query of Queries
      I have the query "almost" there but I'm not sure exactly how to accomplish this. I need all recrods meeting the criteria from the AppliedLicense...
    2. Query of Queries
      I think that we're using 5 on both environments (not checked that though - they shouldn't be different anyway)... It seems that i've fixed it......
    3. Query of Query Vs Queries
      This is a theorical question (or maybe some of you have experiencied. Actually, I have a script that "queries of query" in cfmx as following: q1...
    4. query of queries with avg()
      cfmx 6.1 when i use avg() in a query of queries it rounds the results (actually rounds results down)...so i'm wondering if i am doing this...
    5. Query of Queries in 7.0
      I am running MX 6.1 and was wondering of the QofQ problem still exists (in the new version, 7.0) where CF tries to guess at the column datatype...
  3. #2

    Default Re: Query of Queries on query New type query

    Queries of queries shouldn't have a datasource value.

    JR

    jonwrob Guest

  4. #3

    Default Re: Query of Queries on query New type query

    Ok, then it's a BUG in cf5 because that worked. Thanks
    david_h 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