Developer forum

Forum » Development » Parameter based search

Parameter based search

E-mail notifications

Reply
Posted on 14/07/2009 10:23:33

 

I cannot use greater than and lesser than in the same URL. Iam I not supposed to do than. It should be a rather normal search.

 

I want to find a product with a price grater than 0 and less than 100 and a name LIKE An

 

This is my URL:

 

Default.aspx?eComSearch=1

&ProductName=An

&ProductName_Type=0

&ProductPrice=0

&ProductPrice_Type=5

&ProductPrice=100

&ProductPrice_Type=4

 

Why does this fail ?

An error occured while attaching module (Dynamicweb.Frontend.Content)
System.Data.SqlClient.SqlException: Error converting data type varchar to float.


Replies

 
Posted on 14/07/2009 11:29:08
Reply
abl@norriq.dk wrote:

 

I cannot use greater than and lesser than in the same URL. Iam I not supposed to do than. It should be a rather normal search.

 

I want to find a product with a price grater than 0 and less than 100 and a name LIKE An

 

This is my URL:

 

Default.aspx?eComSearch=1

&ProductName=An

&ProductName_Type=0

&ProductPrice=0

&ProductPrice_Type=5

&ProductPrice=100

&ProductPrice_Type=4

 

Why does this fail ?

An error occured while attaching module (Dynamicweb.Frontend.Content)
System.Data.SqlClient.SqlException: Error converting data type varchar to float.


 

It's not currently possible to do a search where you supply two different compare types for the same field. I have added this as a feature request.

 

You must be logged in to post in the forum