Home » U++ Library support » U++ SQL » Count error
|
Re: Count error [message #17593 is a reply to message #17592] |
Thu, 21 August 2008 19:49 |
captainc
Messages: 278 Registered: December 2006 Location: New Jersey, USA
|
Experienced Member |
|
|
If you use an Aggregate Function like Count(), you have to specify an Aggregate grouping using something like GroupBy()
SQL*Select(ITEM_ID,ITEM_TITLE,ITEM_AUTHOR,Count(Select(SqlAll()).From(FILES).Where(FILE_ITEM_ID == ITEM_ID && IS_DOWNLOADED == true)),
Count(Select(SqlAll()).From(FILES).Where(FILE_ITEM_ID == ITEM_ID))).GroupBy(ITEM_ID,ITEM_TITLE,ITEM_AUTHOR);
This is an SQL requirement, not U++...
|
|
|
|
Re: Count error [message #17616 is a reply to message #17613] |
Fri, 22 August 2008 15:29 |
captainc
Messages: 278 Registered: December 2006 Location: New Jersey, USA
|
Experienced Member |
|
|
Your going to have to break that statement up and figure out where the error is happening. I can't simply tell from that information, but I have a feeling it is because you are using the SQL object and haven't assigned a database or something like that.
[Updated on: Fri, 22 August 2008 15:30] Report message to a moderator
|
|
|
|
|
Goto Forum:
Current Time: Wed May 15 05:21:32 CEST 2024
Total time taken to generate the page: 0.01928 seconds
|