using LIKE with WILDCARD

[Phil Stewart]

Hi Support,

Can you please advise how can I specify %?% where ? can exist anywhere in the search string.

eg. select * from filea where fieldA = '%?%'

thankyou.

[[support], _]

Phil,  

On the field descriptor for "fieldA" specify the WildcardPrependedField as shown here:

This field class automatically prepends a % to whatever the user enters effectively letting you search for a string anywhere in a field. 

NOTE:  You can also specify a DEFAULT value for the user using this syntax:

Select * from x.y  where FIELDA LIKE ?{%}      

% will be placed in the user entry.  

--
You received this message because you are subscribed to the Google
Groups "Web Object Wizard Community PlanetJ" group.
To post to this group, send email to web-obje...@googlegroups.com
To unsubscribe from this group, send email to
web-object-wiz...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web-object-wizard?hl=en?hl=en
To add features to your CE software, visit PlanetJ at www.planetjavainc.com/products
---
You received this message because you are subscribed to the Google Groups "Web Object Wizard Community PlanetJ" group.
To unsubscribe from this group and stop receiving emails from it, send an email to web-object-wiz...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Phil Stewart]

Thankyou.

sent from my mobile