Radicore Forum: Bug Reports

Home » RADICORE development » Bug Reports » Where is where

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

Re: Where is where [message #2230 is a reply to message #2229]

Sat, 18 July 2009 04:55

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

Senior Member

You say that you have created a new class with no physical file on the database, so how come you are trying to generate an sql SELECT statement within this class?

If the WHERE string is empty it means that whatever was in it has been filtered out because the field name(s) cannot be found on any table in the FROM clause. I notice that you are using alias names for your table names, but you are not using the 'AS' word in front of the alias name. You should write them as 'tablename AS alias' and not the shortened 'tablename alias'. The framework specifically looks for ' AS ' (case insensitive) in order to identify alias names.

This is documented in Using Parent Relations to construct sql JOINs .

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

Report message to a moderator

[Message index]

		Where is where By: edortizq on Sat, 18 July 2009 04:22
		Re: Where is where By: AJM on Sat, 18 July 2009 04:55
		Re: Where is where By: edortizq on Sat, 18 July 2009 12:15

Previous Topic:	SQL Syntax error
Next Topic:	isnull clause being filtered out of $where with scriptNext()

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Aug 25 20:20:55 EDT 2024

Total time taken to generate the page: 0.01072 seconds