prepared statement with labkey SQL?

LabKey Support Forum (Inactive)
prepared statement with labkey SQL? Ben Bimber  2011-08-29 16:22
Status: Closed
 
hi robert,

since read security is controlled on the server independent of the SQL statement, and since labkey SQL can't update/delete I think the security concern is that high.

however, if you above example is really that straightforward, i think you probably want to do this using filters, not by writing a SQL statement. it would be roughly like:

LABKEY.ext.Store({
queryName: 'person',
schemaName: 'yourSchemaName',
filterArray: [
    LABKEY.Filter.create('firstname', firstName, LABKEY.Filter.Types.EQUAL),
    LABKEY.Filter.create('age', age, LABKEY.Filter.Types.GREATER_THAN_OR_EQUAL)
]

that's off memory, so there's probably typos.