Query wildcards

[Jelmer Baas]

Xin wrote:
> Try
> 
> &qstring=('[KABELNAAM]'=/^RING.*/')
> 
> Remeber MapServer regular expressions are case sensitive.  To do an case 
> insensitive search, you will need to manually alter the expression to 
> something like:
> 
> &qstring=('[KABELNAAM]'=/^(r|R)(i|I)(n|N)(g|G).*/')

Eek! Is this the easiest way? That's a bit odd, IMHO. I'll try and see 
how far I get.

Hmmm, after some testing, I can't get it to work, at all.

This works:
/beta/scripts/mapserv.exe?mode=itemnquerymap&map=beta/users/nkm/query.map&mapext=93532+463362+93912+463647&mapsize=640+480&layers=TABCAB&qlayer=TABCAB&qitem=KABELNAAM&qstring=/RING1/

This, too:
/beta/scripts/mapserv.exe?mode=itemnquerymap&map=beta/users/nkm/query.map&mapext=93532+463362+93912+463647&mapsize=640+480&layers=TABCAB&qlayer=TABCAB&qstring=('[KABELNAAM]'='RING1')


This, however,
/beta/scripts/mapserv.exe?mode=itemnquerymap&map=beta/users/nkm/query.map&mapext=93532+463362+93912+463647&mapsize=640+480&layers=TABCAB&qlayer=TABCAB&qstring=('[KABELNAAM]'=/^RING.*/')
gives me:
msQueryByAttributes(): Search returned no results. No matching record(s) 
found.
msEvalExpression: Expression parser error. Failed to parse expression
msyyparse(): Expression parser error. syntax error

I tried with quotes around my expression, without, etc. What am I doing 
wrong?

I'm running MapServer 4.6 btw, still waiting for a way to get an Oracle 
Build for Windows or 4.8 :-|


-- 
Jelmer