[ic] search match begin of a string

Ed LaFrance interchange-users@interchange.redhat.com
Fri Feb 22 10:37:01 2002


At 01:22 PM 2/22/2002 +0100, you wrote:
>hello,
>I was lookinf in the ML archive nd doesn't find a solution for a search.
>I like to find records on wich one field begin with a letter and ONLY the
>beginning.
>Then I try
>
>[loop list="A..Z" ranges=1]
>[loop-code]
>[loop prefix=alpha
>         search="
>         fi=artiste
>         co=yes
>         se=[loop-code]
>         bs=1
>         "][alpha-data artiste nomartiste]<br>
>[/loop]
>[/loop]
>
>and it does work because it returns results with the letter anywher in the
>field.
>
>Can anybody help me ????
>
>Merci par avance

You need to specify a search field (sf)! This may not work, but did you try:

[loop prefix=alpha
         search="
         fi=artiste
         st=db
         co=yes
         sf=name_of_field
         se=[loop-code]
         op=rm
         bs=1
         "][alpha-data artiste nomartiste]<br>
[/loop]

- Ed L.

===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================