Thunderstone Support Forums

What exactly is allowed in the SQL Query clause? Can you point me to some documentation?

Functions do not seem to be allowed, for example the following gives an error :

StartDate <= DATE('now') AND EndDate > DATE('now')

also IN does not seem to work properly (without an error message) :
LanguageCoE IN ($qpLanguage)

When i pass EN in the search form, that works, but EN,FR does not.

The SQL docs are at http://www.thunderstone.com/site/texisman/

StartDate <= convert('now','date')
If StartDate is a date type the conversion is automatic
StartDate <= 'now'

Strings need to be quoted for IN syntax
LanguageCoE in ('EN','FR')

Or if you want to pass a parameter into IN() then make it a strlst first, e.g.

<sum "%s," $langs>
<$qpLanguage=(convert($ret, 'strlst' ))>
<sql "... Field in ($qpLanguage) ...">

Sorry, my question was not clear.

I was talking about the appliance/webinator admin interface on the search settings page

The alphanumeric tokens allowed in a Parametric Search query are currently "and" "or" "not" "like" "matches" "in" "between", or a Parametric field name defined for that profile. Integer constants and single-quoted strings are allowed too.

You could rewrite your SQL as:

StartDate <= 'now' AND EndDate > 'now'

assuming StartDate is a Date type field.

For the IN query, set separate values for $qpLanguage, e.g. `qpLanguage=EN&qpLanguage=FR' in the query string.