Andy Slocombe
|
| Posted: 11/04/2005, 1:36 PM |
|
I've created an Editable Grid Search and want search results to be limited to exact matches for a password field. Is there an easy way to do this when you setup the grid using a builder, or a way to modify it after the grid is created?
Thanks! Andy.
........................................
Andy Slocombe
Database Developer
Outreach Marketing & Communications
Draper Hall, University of Massachusetts
40 Campus Center Way
Amherst, MA 01003-9244
413.577.3846 / 413.545.5174 fax
andys@outreach.umass.edu
|
|
|
 |
Vasiliy
Posts: 378
|
| Posted: 11/04/2005, 3:00 PM |
|
I assume you are using CCS3.
Go to Visual Query Builder, in the tree (on the left side) find section WHERE, find your password field there. Open password field properties and change "LIKE '% %'" to "equals (=)".
_________________
Vasiliy |
 |
|
Walter Kempees
|
| Posted: 11/04/2005, 3:02 PM |
|
The AFTER method:
Properties of the grid/
Data Source property has [...] press that , takes you to Query Builder
Look at the Where clause
change the
like '%s_keyword%' into = 's_keyword'
yjat's all folks
<AndySlocombe@forum.codecharge (Andy Slocombe)> schreef in bericht
news:2436bd4793e766@news.codecharge.com...
> I've created an Editable Grid Search and want search results to be limited
> to
> exact matches for a password field. Is there an easy way to do this when
> you
> setup the grid using a builder, or a way to modify it after the grid is
> created?
>
> Thanks! Andy.
> .......................................
> Andy Slocombe
> Database Developer
> Outreach Marketing & Communications
> Draper Hall, University of Massachusetts
> 40 Campus Center Way
> Amherst, MA 01003-9244
> 413.577.3846 / 413.545.5174 fax
>andys@outreach.umass.edu
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Andy Slocombe
|
| Posted: 11/07/2005, 11:49 AM |
|
Thank you both. I just upgraded to v.3 and the change was an easy one.
Andy.
.......................................
Andy Slocombe
Database Developer
Outreach Marketing & Communications
Draper Hall, University of Massachusetts
40 Campus Center Way
Amherst, MA 01003-9244
413.577.3846 / 413.545.5174 fax
andys@outreach.umass.edu
|
|
|
|
|
