Radicore Forum: Application Development

Home » RADICORE development » Application Development » SUM(price) (how to include SUM in sql_select (if possible...))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: SUM(price) [message #2678 is a reply to message #2677]

Sat, 19 February 2011 05:10

AJM
Messages: 2363
Registered: April 2006
Location: Surrey, UK

Senior Member

You must provide an alias name using 'SUM(price) AS alias' otherwise when it comes to write that column name into the XML document it will barf as 'SUM(price)' contains '(' and ')' which are invalid as element names in XML.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		SUM(price) By: dsstanescu on Fri, 18 February 2011 08:32
		Re: SUM(price) By: AJM on Sat, 19 February 2011 05:10
		Re: SUM(price) By: dsstanescu on Sat, 19 February 2011 06:07

Previous Topic:	USER Management
Next Topic:	Adding SUM() data to screen and report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 03 10:12:51 EST 2024

Total time taken to generate the page: 0.00917 seconds