Parameter Search Using Form Variable

[sbrenier]

I have a connection to the SQL Server 2000 database and a data set made up a a
collection of personnel records. I set up the data set with a parameter, which
is a text field on a form. I want the user to be able to submit all or part of
a name and retrieve the matching records.

I have a results table set up on my form but when I attempt to view the
results in my browser, the results area does not show.

I cannot determine whether the form variable is not passing to the query or
whether some other condition blocks the display of the retrieved
records.:confused;

[Nathon Jones]

Hi,

Some suggestions:

1) Check to see whether you are using POST or GET as the method in your
form. If one isn't working, try the other.
2) On the results table/page, make sure that you are requesting a Form
Variable rather than a QueryString
Request.Form("namefield") rather than Request.QueryString("namefield")
3) Kinda obvious, but make sure that you are searching for a name that you
know exists in your database!
4) On your results page, set up a Show If Empty and Show If Not Empty
behaviour, with a specific message in each. That way, you'll know if the
results are basically "none" or if it IS finding results but just isn't
displaying them (would narrow down your issue if nothing else).
5) Your select statement should read similar to:
SELECT * FROM tablename WHERE namefield LIKE '%varName%'

varName % Request.Form("namefield")

Hope this helps. Just some ideas really.
Nath.

"sbrenier" <webforumsuser@macromedia.com> wrote in message
news:d3jv82$nlp$1@forums.macromedia.com...

>I have a connection to the SQL Server 2000 database and a data set made up
>a a
> collection of personnel records. I set up the data set with a parameter,
> which
> is a text field on a form. I want the user to be able to submit all or
> part of
> a name and retrieve the matching records.
>
> I have a results table set up on my form but when I attempt to view the
> results in my browser, the results area does not show.
>
> I cannot determine whether the form variable is not passing to the query
> or
> whether some other condition blocks the display of the retrieved
> records.:confused;
>