[mv] Search on start of field.

[jimtoro@hoflink.com]

******    message to minivend-users from jimtoro@hoflink.com     ******


Wondering if someone can give a bit of guidance. I am trying to 
do a search of the products database. The search is to see if
the category is "Womens" and if the title field starts with a
letter of the alphabet. I only want records that match Womens
AND start with the first letter of the chosen letter, so I wrote
this:

[page search.0="
        sf=title
        se=A
        bs=yes
        cs=no
        su=yes
        ra=yes
       "
      search.1="
        sf=category
        se=Womens  
       "
       ] A [/page]

But it returns ANY item that has the letter A in the title. Am I using
the "begin string" feature incorrectly or is there something else.
I want to find those records and then return ALL fields so the results
page can manipulate the data for display. If I take out "ra" and put
in "rf=title" then it appears to return no data for the results.html
page.



-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list