Professional Web Applications Themes

Fields missing in query - Coldfusion Database Access

I am having an odd problem. I have a table in MSSQL named Residential. In this table I have 32 fields (all of which I use) for some reason all of a sudden I was unable to access the field ResidentialPartOID when using CFquery with CFQUERYParam. Doing so Cold Fusion 7 tells me that the field ResidentialPartOID does not exist. I run the same query in query yzer and it works fine (replacing the CFQUERY params with actualy values I type in). I can see the field ResidentialPartOID in the results. On an odd shot, I renamed the table to ...

  1. #1

    Default Fields missing in query

    I am having an odd problem.

    I have a table in MSSQL named Residential. In this table I have 32 fields (all
    of which I use) for some reason all of a sudden I was unable to access the
    field ResidentialPartOID when using CFquery with CFQUERYParam.

    Doing so Cold Fusion 7 tells me that the field ResidentialPartOID does not
    exist.

    I run the same query in query yzer and it works fine (replacing the
    CFQUERY params with actualy values I type in). I can see the field
    ResidentialPartOID in the results.

    On an odd shot, I renamed the table to ResidentialTest. Voila! Ye olde query
    works fine and I can access the ResidentailPartOID field just fine in Cold
    Fusion.

    I rename the table back to Residential... and the query fails again.

    Obviously this must be something in my database causing this... any idea what?

    I know that when using CFQueryParam it tells ColdFusion to access the data in
    a more efficient method... but what that method is... I do not know.

    Anyone have any suggestions, comments, etc?

    Robert10 Guest

  2. #2

    Default Re: Fields missing in query

    Ooooooook.... not exactly sure what was wrong (If anyone knows I would love to
    know) but I fixed it.

    I simply dropped the table, did a DB shrink. and then reimported the data.

    The query seems to be working correctly now as expected.

    However I would like to know what caused this behavior in the first place.

    Robert10 Guest

Similar Threads

  1. font missing shows during printing of forms fields
    By nilayare@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 0
    Last Post: October 9th, 10:44 AM
  2. Query of Query Missing Some Data
    By g1zm0guy in forum Coldfusion Database Access
    Replies: 7
    Last Post: January 17th, 09:30 AM
  3. Missing something in this query
    By quiero mas in forum Coldfusion Database Access
    Replies: 5
    Last Post: November 28th, 05:03 AM
  4. CFGRID missing form fields
    By RockiesFan in forum Macromedia ColdFusion
    Replies: 0
    Last Post: April 8th, 06:43 PM
  5. CAML Query: Multiple Query Fields Issue
    By Jon F. in forum ASP.NET Web Services
    Replies: 0
    Last Post: May 12th, 08:19 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