Skip to main content
Inspiring
January 9, 2009
Question

Basic query - cfoutput is incorrect. Please help.

  • January 9, 2009
  • 14 replies
  • 1597 views
The query result when run directly on SQLyog is 3, but this displays as 1 everytime. What the heck am I missing?

Thanks -CaddyX
    This topic has been closed for replies.

    14 replies

    Inspiring
    January 9, 2009
    <cfdump var="#get_div.division#">

    Result is 1
    Inspiring
    January 9, 2009
    quote:

    Originally posted by: Bagger Vance
    <cfdump var="#get_div.division#">

    Result is 1

    that's not cfdumping the query.
    This is cfdumping the query.
    <cfdump var="#get_div#">

    The relevent piece of information you might get is how many rows the query returned. Outputting or dumping a query.field will only return 1 row, either the 1st or last, I forget.
    Inspiring
    January 9, 2009
    Thanks. It looks like one row with a result of 1.







    Inspiring
    January 9, 2009
    What do you see when you cfdump the query?
    Inspiring
    January 9, 2009
    Positive. 100%
    Participating Frequently
    January 9, 2009
    Are you positive that you are connecting to the same database?