Search code examples
coldfusioncfquery

<cfquery> not retrieving DATA

I am unable to retrieve any data from my cfquery. Same query when i run in sql developer i get the result.

Any reason why ?

Hi all, thanks for the responses. Sorry, it was my fault. It was a data issue. I was retrieving uncommited data from CF.

Solution

  • You can also build the query in CFEclipse, test it and then paste the query in your CFQuery tag.

    Also check how you have put the query name in the CFoutput tag, so many times I've put #queryname# instead of queryname in cfoutput.