Radicore Forum: Bug Reports » v 1.35 - Relationship Calculated Field Escaping

Home » RADICORE development » Bug Reports » v 1.35 - Relationship Calculated Field Escaping

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

Re: v 1.35 - Relationship Calculated Field Escaping [message #1326 is a reply to message #1325]

Thu, 01 May 2008 05:15

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

Senior Member

The problem is that your CONCAT function contains double quotes around the space character instead of single quotes. In standard SQL a single-quoted string is taken for a value while a double quoted string is taken as a field name. That is why you get the error message
- unknown column ' ' in 'field list'

Change those double quotes to single quotes, export the table definition, then try running it again. It should not fail this time.

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

Report message to a moderator

[Message index]

		v 1.35 - Relationship Calculated Field Escaping By: ljkbrost on Thu, 01 May 2008 01:22
		Re: v 1.35 - Relationship Calculated Field Escaping By: AJM on Thu, 01 May 2008 05:15
		Re: v 1.35 - Relationship Calculated Field Escaping By: ljkbrost on Thu, 01 May 2008 10:18

Previous Topic:	v 1.35 - Inconsistent SQL files
Next Topic:	v 1.35 - JavaScript functionality

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Dec 01 00:42:57 EST 2024

Total time taken to generate the page: 0.01151 seconds