want to search db from data from form...

[tarek316]

Hi,

I want to make a search page to search a specific field in DB. This may be more of a html question but how can I gett the text to search for from the form and then build the quesry string to find what I need? Very stuck on this problem. I have been trying javascript but stil no thing. Thanks.

tarek316

[beverly]

'<input type="text" name="YourFieldName" value="" />

The NAME of the field is the one you will be using in the form input. The case needs to match (YourFieldName <> yourfieldname).

You don't need to build a query string when you use the FORM. Whatever the user types into the field in the browser will be sent (abcxyz, for example) YourFieldName=abcxyz, when the SUBMIT button in the form is clicked.

*more detail*:

'<form method="post" action="...">

'<input type="hidden" name="-db" value="myDatabase" />

'<input type="text" name="myField" value="" />

'<input type="hidden" name="-find" value="" />

'<!-- add a hidden action, so that the user can use the ENTER key to submit -->

'<input type="submit" name="-find" value="FIND" />

'</form>

This is very basic, and does NOT include the action and the other parameters needed to access the database, layout, stylesheet, etc.

Of course, you do not need to specify the -db (database) in FMP7, if you use '<?xslt-cwp-query params="" ?>

[beverly]

'<input type="text" name="YourFieldName" value="" />

The NAME of the field is the one you will be using in the form input. The case needs to match (YourFieldName <> yourfieldname).

You don't need to build a query string when you use the FORM. Whatever the user types into the field in the browser will be sent (abcxyz, for example): YourFieldName=abcxyz, when the SUBMIT button in the form is clicked.

*more detail*:

'<form method="post" action="...">

'<input type="hidden" name="-db" value="myDatabase" />

'<input type="text" name="myField" value="" />

'<input type="hidden" name="-find" value="" />

'<!-- add a hidden action, so that the user can use the ENTER key to submit -->

'<input type="submit" name="-find" value="FIND" />

'</form>

This is very basic, and does NOT include the action and the other parameters needed to access the database, layout, stylesheet, etc.

Of course, you do not need to specify the -db (database) in FMP7, if you use '<?xslt-cwp-query params="" ?>

[beverly]

'<input type="text" name="YourFieldName" value="" />

The NAME of the field is the one you will be using in the form input. The case needs to match (YourFieldName <> yourfieldname).

You don't need to build a query string when you use the FORM. Whatever the user types into the field in the browser will be sent (abcxyz, for example): YourFieldName=abcxyz, when the SUBMIT button in the form is clicked.

*more detail*:

'<form method="post" action="...">

'<input type="hidden" name="-db" value="myDatabase" />

'<input type="text" name="myField" value="" />

'<input type="hidden" name="-find" value="" />

'<!-- add a hidden action, so that the user can use the ENTER key to submit -->

'<input type="submit" name="-find" value="FIND" />

'</form>

This is very basic, and does NOT include the action and the other parameters needed to access the database, layout, stylesheet, etc.

Of course, you do not need to specify the -db (database) in FMP7, if you use '<?xslt-cwp-query params="" ?>