Professional Web Applications Themes

query of queries and large data types - Coldfusion Database Access

I am performing a query of queries against a query the selects a clob value from an Oracle database. When I try to access the clob value in the query of queries I receive the following error message: Query Of Queries runtime error. Failed to get meta_data for columnserver.listItems.Text_Value This is on ColdFusion 7 with Windows 2000. Thanks, Jim...

  1. #1

    Default query of queries and large data types

    I am performing a query of queries against a query the selects a clob value
    from an Oracle database. When I try to access the clob value in the query of
    queries I receive the following error message:

    Query Of Queries runtime error.
    Failed to get meta_data for columnserver.listItems.Text_Value

    This is on ColdFusion 7 with Windows 2000.

    Thanks,
    Jim

    jim1234 Guest

  2. #2

    Default Re: query of queries and large data types

    Apparently ColdFusion 7 query of queries just won't handle and columns larger
    than a certain size. I tried converting the clob value to a char (using
    oracle's to_char) and query of queries still wouldn't take it. The error
    message now is:

    "Bigger type length than Maximum"

    Even though the largest value is only 1027 characters.

    So I guess I'm ed as far as using any of the ColdFusion features for
    caching any data since you can't use cfqueryparam within a cached query either.

    But if anyone has any other insight, it would be appreciated.

    Jim

    jim1234 Guest

Similar Threads

  1. query of quries and large data types
    By jim1234 in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: May 12th, 06:17 PM
  2. Query of Queries on query New type query
    By david_h in forum Coldfusion Database Access
    Replies: 2
    Last Post: May 6th, 08:55 PM
  3. How To Query Large Data/Records ?
    By affiza in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: March 15th, 02:01 AM
  4. DBD::Pg behavior for large queries
    By Chris in forum PostgreSQL / PGSQL
    Replies: 1
    Last Post: January 19th, 11:33 AM
  5. Avoiding large queries...
    By Christopher Stolte in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 12th, 09:48 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