using LIKE with WILDCARD

8 views
Skip to first unread message

Phil Stewart

unread,
Nov 14, 2013, 10:18:10 PM11/14/13
to web-obje...@googlegroups.com
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], _

unread,
Nov 15, 2013, 12:04:14 PM11/15/13
to web-obje...@googlegroups.com, David Habba
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.  

Inline image 1


--
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.

image.png

Phil Stewart

unread,
Nov 15, 2013, 3:14:41 PM11/15/13
to web-obje...@googlegroups.com

Thankyou.

sent from my mobile

image.png
Reply all
Reply to author
Forward
0 new messages