× If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html

How to get more charachters SQL-WHERE expression?

More
7 years 8 months ago #4017 by rozendale
How to get more charachters SQL-WHERE expression? was created by rozendale
In the Joomla Menu tab I can address a JooDatabase with SQL-WHERE expression, which is working. However, when I put the following SQL and pressing on SAFE the refreshed page shows only the first part of the SQL:

SELECT GrowingSpeed = 'medium'
OR GrowingSpeed = 'slow'
AND AgeFullHarvest >20
AND LifeSpan >100
AND PlantingDistance <1300
AND RowDistance <1300
RootSystem = 'shallow'

Perhaps the SQL-WHERE expression is limited to about 50 characters. How can I change it into 1000 characters?

Thanks in advance,

Please Log in to join the conversation.

More
7 years 8 months ago - 7 years 8 months ago #4018 by Dirk
Replied by Dirk on topic How to get more charachters SQL-WHERE expression?
the sql statement is limited to string size.
~ 64000 Bytes.

So it should be long enough!
There must be another reason why your catalog is not displayed!

Most likely because the sql statement is wrong.
Please do not use SELECT in the statement!
Only OR and AND
(GrowingSpeed = 'medium' OR GrowingSpeed = 'slow')
AND AgeFullHarvest >20
AND LifeSpan >100
AND PlantingDistance <1300
AND RowDistance <1300
RootSystem = 'shallow'
Last edit: 7 years 8 months ago by Dirk.

Please Log in to join the conversation.

More
7 years 8 months ago #4022 by rozendale
Replied by rozendale on topic How to get more charachters SQL-WHERE expression?
Also no < and > syntaxes? I found that the < syntax caused previous problem, while the > syntax is working. And the catalog template already has this code:

<field name="where_statement" type="textarea" default="" rows="5" cols="30" filter="raw" label="SQL-WHERE Statement" description="SQL-WHERE Statement description"/>

Please Log in to join the conversation.

Moderators: Dirk, joest