Hi, 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.
A:
Is the query actually being ran?
If you can turn debugging on, does the query show as being executed?
Also when you run the same query do you mean you copy/paste the query from the debugger into sql developer?
Perhaps the same values are not being included (if you are using variables in there)
... being ran? .
charlie
2010-04-29 13:32:49
Yeah, query executed and I tried the same query in sql developer (Though i have replaced the cf variables). What i think now is that might be a caching issue, Because the cfquery which i was executing was trying to retrieve the data from a table that was newly added. All the other queries that are working are fetching results from older tables. Can caching be a problem ?
Somu
2010-04-30 04:24:50
A:
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.
stevo
2010-04-29 13:24:41
Hi it was a silly mistake i was doing. It was a DB issue. I Insered the data and without commiting the changes i was trying to retrieve it from my CF code. Thanks all..
Somu
2010-05-03 12:13:59