Hi Jan Pieter,
Where does the select statement you quoted (SELECT * FROM qrtprojectenri_auth WHERE comp>=650 AND comp<=650 ORDER BY id LIMIT 20 ) originate? From a trace?
Is that the result of a straightforward Advanced Table module (with 650 originating from a From/To filtering rows in the table)?
Or perhaps you're using a <Filter> on Advanced Find coupled with a comp trigger which is of type Number?
Feel free to attach a sample model.
Regards,
David
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign