Radicore Forum: Framework » Screen/Report

Home » RADICORE development » Framework » Screen/Report - calculated/concat fields

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

Re: Screen/Report - calculated/concat fields [message #5598 is a reply to message #5597]

Fri, 03 June 2016 04:50

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

Senior Member

You can certainly use a function such as CONCAT() in a SELECT statement, but in your example you have placed it after the FROM clause instead of before, which produces an invalid query.

You could always combine two or more fields into a single field within your PHP code, such as in the _cm_post_getData() method.

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

Report message to a moderator

[Message index]

		Screen/Report - calculated/concat fields By: htManager on Thu, 02 June 2016 11:55
		Re: Screen/Report - calculated/concat fields By: AJM on Fri, 03 June 2016 04:50

Previous Topic:	Task ID/Script ID
Next Topic:	Convert date ccyy-mm-dd to dd.mm.ccyy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Jul 06 03:04:49 EDT 2025

Total time taken to generate the page: 0.04025 seconds