Muuppet
08-06-2003, 04:52 AM
I need some guidance please.
I have a form that can search database fields (part of the software setup, I cant' change these or how the search form works).
The two fields I can search on are (eg) 'name' and 'info' in a user profile. These fields search the database and returns the correct results. The users can put any text in their 'info' box, up to about 25k of free text.
I want to, however, have the ability to search on different types of 'info'. So, instead of just two text boxes of free search called 'name' and 'info' I want to have the ability for some drop-down lists as well. The form would look like;
-----------
Name: 'name' textbox
Keyword: 'info' textbox
Speciality: drop-down list with pre-defined text, which also searches the 'info' perameter.
-----------
The thing is, the script is not set to accept this kind of submit action (two fields in to one perameter does not fit!!).
Is there an 'action' or javascript ro anything that can merge these two 'keyword.info' and 'speciality.info' into one search string before submission to the script??
IE;
Name: 'David' (submit.name(David))
Keyword: 'UK' (submit.info(UK))
Speciality: 'HTML' (submit.info(HTML))
searches on 'name.David' and 'info.('UK'+'HTML')'
????
I have a form that can search database fields (part of the software setup, I cant' change these or how the search form works).
The two fields I can search on are (eg) 'name' and 'info' in a user profile. These fields search the database and returns the correct results. The users can put any text in their 'info' box, up to about 25k of free text.
I want to, however, have the ability to search on different types of 'info'. So, instead of just two text boxes of free search called 'name' and 'info' I want to have the ability for some drop-down lists as well. The form would look like;
-----------
Name: 'name' textbox
Keyword: 'info' textbox
Speciality: drop-down list with pre-defined text, which also searches the 'info' perameter.
-----------
The thing is, the script is not set to accept this kind of submit action (two fields in to one perameter does not fit!!).
Is there an 'action' or javascript ro anything that can merge these two 'keyword.info' and 'speciality.info' into one search string before submission to the script??
IE;
Name: 'David' (submit.name(David))
Keyword: 'UK' (submit.info(UK))
Speciality: 'HTML' (submit.info(HTML))
searches on 'name.David' and 'info.('UK'+'HTML')'
????