Re: [mv] Search on start of field.

[Mike Heins <mikeh@minivend.com>]

******    message to minivend-users from Mike Heins <mikeh@minivend.com>     ******

Quoting jimtoro@hoflink.com (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.
> 

This is sort of a bug.

Apparently bs is not included in the parameters parsed in the
array-based search notation. It should work with:

[page search="

	co=yes

	sf=title
	se=A
	bs=yes
	cs=no
	su=yes

	sf=category
	se=Womens  
	cs=yes
	su=no

    "]A[/page]

I will see if I can put bs= in the list of params to be generated
on the array-based search.

-- 
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.8220 fax 7501 <heins@akopia.com>

Be patient. God isn't finished with me yet.  -- unknown
-
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