Radicore Forum: How To » CONCAT ((SELECT ...),...) Error

Home » RADICORE » How To » CONCAT ((SELECT ...),...) Error

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

Re: CONCAT ((SELECT ...),...) Error [message #1092 is a reply to message #1091]

Sun, 09 September 2007 11:18

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

Senior Member

The default SELECT statement created by Radicore should be as follows:

SELECT instruments.*
FROM instruments
LEFT JOIN instrument_models ON (instrument_models.instrument_model_id = instruments.instrument_model_id)

You need to extend this in your _cm_pre_getdata() method (as shown in http://www.tonymarston.net/php-mysql/infrastructure-faq.html #faq84) so that it becomes as follows:

SELECT instruments.*, CONCAT (instrument_type_name, ' - ',
                              instrument_model_manufacturer, ' ',
                              instrument_model_name) AS instrument_model
FROM instruments
LEFT JOIN instrument_models ON (instrument_models.instrument_model_id = instruments.instrument_model_id)
LEFT JOIN instrument_types ON (instrument_type.instrument_type_id = instrument_models.instrument_type_id)

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

Report message to a moderator

[Message index]

		CONCAT ((SELECT ...),...) Error By: luca on Sat, 08 September 2007 10:56
		Re: CONCAT ((SELECT ...),...) Error By: AJM on Sat, 08 September 2007 13:34
		Re: CONCAT ((SELECT ...),...) Error By: luca on Sun, 09 September 2007 10:26
		Re: CONCAT ((SELECT ...),...) Error By: AJM on Sun, 09 September 2007 11:18
		Re: CONCAT ((SELECT ...),...) Error By: luca on Tue, 11 September 2007 09:53

Previous Topic:	passwords
Next Topic:	Restricting access to user's own record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 24 10:08:31 EST 2024

Total time taken to generate the page: 0.01298 seconds