symcox
|
Posted: 12/24/2003, 7:10 PM |
|
Hi all,
i have 3 tables,
1)product
2)company
3)productcatagory
in product table,i have forign keys to company table and productcatagory table.as companyID and productcategoryID.
i wanna make a search.
user can search product table by companyname or categoryname.i have made a result grid my CCS using visual query builder.
how can i achieve the search?.i have tried a lot with VQB.but i could'nr found a solution.
so seeking expert help.
plz ..it's urgent for me.
|
|
|
mmm
|
Posted: 12/25/2003, 10:13 AM |
|
|
|
|
mkmind
|
Posted: 12/26/2003, 2:22 AM |
|
Hello.
What do you mean whit archiv the search?
You will save the search string from the URL with the parameters of the variabels?
Else it is a easy search and grid with CCS.
In search 2 Listboxes with Companynames and Categorynames and in the Grid where = CompanyID eval(=) yourCompanyID / URL ; AND CategoryID eval(=) yourCategoryID / URL
That´s it.
|
|
|
mkmind
|
Posted: 12/27/2003, 12:30 AM |
|
HEY
"""""plz ..it's urgent for me. """"""""""""""""""
hehehe
And NOW!!!!!!!!!!!!!!!!!!!!!!
Come ON..................................
|
|
|
symcox
|
Posted: 12/29/2003, 11:31 PM |
|
Quote : HEY
"""""plz ..it's urgent for me. """"""""""""""""""
hehehe
And NOW!!!!!!!!!!!!!!!!!!!!!!
Come ON..................................
Hi mkmind,..it was urgent for me ..i tried a lot and i switched to someother areas in my project in these days.
i hav tried ur solution but
the listbox is only for sorting,.i mean when a person selects CompanyName and doing a search,the search grid searches all 3 tables and giving all results sorted by comoanyname.
but that's not solving my problom.
i need search results which only listing products with only that companyname..is it possible?
|
|
|
Nicole
Posts: 586
|
Posted: 01/06/2004, 5:11 AM |
|
Symcox,
First of all I think you should create the sql query which returns all the fields you want to be listed on the results grid.
Create the query in the query analyzer first and experiment with the WHERE conditions to make sure that you get the expected results. I believe that you can search on company_id, category_id OR company_name, category_name using like search.
When you find out this information you can create grid&search using Grid builder. Or modify the existing forms:
- add necessary search fields (textbox or listbox) to the search form
- create relevant WHERE conditions under Grid’s datasource.
_________________
Regards,
Nicole |
|
|
|