Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
crugerenator
Posting Yak Master
126 Posts |
 Posted - 2007-07-02 : 10:01:13
|
| Lets say I have this select statement...SELECT count(c_id)FROM commentsWHERE c_id=#c_id##c_id# is a variable in coldfusion. now, to display the count(c_id) results, what do I do? usually it would just be #c_id#, but with the count() I can't get it to display. Any ideas? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-07-02 : 10:06:11
|
| Not clear what you want. Can you explain with expected output and sample data?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-07-02 : 10:18:21
|
| Do you want to show it in coldfusion?May be you need to have alias name for countSELECT count(c_id) as countingFROM commentsWHERE c_id=#c_id#MadhivananFailing to plan is Planning to fail |
|
|
|
crugerenator
Posting Yak Master
126 Posts |
Posted - 2007-07-02 : 10:21:34
|
| yeah, i figured it out actually. Its been a long long time since i've used sql, forgot that I could do count(c_id) AS recordCountThat solved the problem. Thanks |
|
|
|
|
|
|
count()