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 #1090 is a reply to message #1089]

Sat, 08 September 2007 13:34

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

Senior Member

Trying to use a SELECT statement inside a CONCAT(..) is causing the problem. The framework has routines which unpacks the SELECT statement to see if any of its component parts need to be qualified, then it repacks then back together again. Unfortunately it appears that your mixture of SELECT and CONCAT is causing the unpacking and repacking to become confused.

You should try using a JOIN to get the columns from the related tables, then use those column names inside the CONCAT(..).

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 12:03:27 EST 2024

Total time taken to generate the page: 0.00897 seconds