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

SUM(price) [message #2677]

Fri, 18 February 2011 08:32

dsstanescu
Messages: 12
Registered: August 2010

Junior Member

Hi,

If I include a SUM operator in one of my php files (want to group by code and the get the total price per code), I will get an error:

...
// customise the SQL SELECT statement
$sql_select = 'code, SUM(price)';
$sql_from = null;
$sql_where = null;
$sql_groupby = 'code';
$sql_having = null;
$sql_orderby = null;
$sql_search_table = null;
...

here is the error:

Fatal Error: Uncaught exception fron DOMException, message = Invalid Character Error (# 256).

Error in line 385 of file 'C:\xampp\htdocs\radicore\includes\error.inc'.

Thanks.
Dan

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: Wed Dec 04 04:24:52 EST 2024

Total time taken to generate the page: 0.01010 seconds