2. ASPRunnerPro General questions
  3. Search by Category
This topic is locked

Search by Category

 		5/11/2008 9:08:46 AM
ASPRunnerPro General questions
S
 simplem author

Resp. Sir
I am new to Asprunner, I am in learning stage of ASPRunner.

I go through some of your sample projects that you provide with the S/W.

My problem is that I want to know that how to make is possible "Search By Category"
I am working on this problem from last few days, I am not getting any clue or solution.

Please help me by telling it Step By Step,beacuse I am just New to ASPRunner.

Kindly provide the code for this.
Please help me ASAP, because I need it Immediately.

Regds

Simple
Sergey Kornilov admin 5/12/2008

You need to explain what "Search by category" means and how it's different from Basic or Advanced search.
S
 		simplem author 5/17/2008

I mean to say As you have catergrosed it in your many samples, like classifieds sample, it is classifieds by :

Search by category

Automotive (1)

Cars (1)

For Sale (2)

Books (2)

Real Estate (1)

Homes (1)
Like this you have categroised in many samples, named as :-

Cars, Real Estate Etc.
Please help me in this regard , because I also need this catergozation, in my project which I am making.
Please help ASAP.

Regds

Simple
Sergey Kornilov admin 5/18/2008

You create a new project using Classifieds templates, proceed to the List page of 'main' table and double click on ListOnLoad event to see the code. Create a similar event in your project and adjust the code to match tables and field names.
PS. If you need an urgent answer contact support team directly supplying your order number.
S
 		sfhussain 8/6/2008

You create a new project using Classifieds templates, proceed to the List page of 'main' table and double click on ListOnLoad event to see the code. Create a similar event in your project and adjust the code to match tables and field names.

PS. If you need an urgent answer contact support team directly supplying your order number.



HI,

I did it but i have a problem that i have single table and i want to search data by field. how can i do that?

TableName: south

FieldName: problem
My code is:

stSQL = "select problem from south group by Problem"

Set data = server.CreateObject("ADODB.Recordset")
data.open stSQL, dbConnection

while not data.eof

problem = replace(data("problem")," ","+")

message = "<a href=""south_list.asp?a=search&value=1&SearchFor=" & problem & "&SearchOption=Contains&SearchField=problem"">" & data("problem") & " (" & data("number") & ")</a>
"

response.write message

data.MoveNext

wend

data.close