By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,635 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,635 IT Pros & Developers. It's quick & easy.

Problem with an .asp page displaying data based on a form field value.

P: n/a
I'm hoping someone can help me with a small issue.

I have an asp page that displays informaton from an Access database.
I want to create a form that allows users to display only data that
matches their search criteria.

I have made many forms like this in Front Page with the Database
results wizard, but I want to manually code it.

Here is the code I use to display the data from a database.

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "driver={Microsoft Access Driver (*.mdb)};;DBQ=\\****\****
\DatabaseName.mdb;"
mySQL="SELECT * FROM DatabaseTableName WHERE (TableFieldName =
'FieldValue') ORDER BY TableFieldName ASC"
Set RS = Conn.Execute(mySQL)
If RS.EOF and RS.BOF Then
Response.Write("<font face=""verdana"" size=""2""><p>No records
returned.</p>")

Else

Response.Write "<table><tr>"
Response.Write "<td><b>Table Field Name</b></td>"
Response.Write "</tr>"

Do While Not RS.EOF

Response.Write "<tr>"
Response.Write "<td>"&RS("FieldValue")&"</td>"
Response.Write "</tr>"

RS.MoveNext
Loop
End If

Response.Write "</table>"

RS.Close
Conn.Close
Set RS = Nothing
Set Conn = Nothing
%>

What I want to do is add a form like the one below that user can use
to determine the "field value" that is displayed.

<p><form METHOD="POST" ACTION="WebPageName.asp"><input
NAME="FormField" VALUE="<%=Request("FormFieldValue")%>"
size="24">&nbsp;<input TYPE="submit" value="Search!"></form></p>

So if they type in "Smith" they get all entries that have a field
value of Smith

I'm not sure how to write the query so it looks at the form for the
value it uses to display information.

Any code examples would help me a great deal as I seem to be close,
but I cannot "connect" to two elements.

Thanks for taking the time to read all of this, and for any assiatance
you can offer.

Feb 14 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I think you want something like this:

mySQL="SELECT * FROM DatabaseTableName WHERE (TableFieldName='" &
Request.Form("FieldValue") & "') ORDER BY TableFieldName ASC"

It's a single quote followed by doublequotes after TableFieldName=, and
doublequotes followed by a single quote before the ORDER BY
"Brave" <br*********@yahoo.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...
I'm hoping someone can help me with a small issue.

I have an asp page that displays informaton from an Access database.
I want to create a form that allows users to display only data that
matches their search criteria.

I have made many forms like this in Front Page with the Database
results wizard, but I want to manually code it.

Here is the code I use to display the data from a database.

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "driver={Microsoft Access Driver (*.mdb)};;DBQ=\\****\****
\DatabaseName.mdb;"
mySQL="SELECT * FROM DatabaseTableName WHERE (TableFieldName =
'FieldValue') ORDER BY TableFieldName ASC"
Set RS = Conn.Execute(mySQL)
If RS.EOF and RS.BOF Then
Response.Write("<font face=""verdana"" size=""2""><p>No records
returned.</p>")

Else

Response.Write "<table><tr>"
Response.Write "<td><b>Table Field Name</b></td>"
Response.Write "</tr>"

Do While Not RS.EOF

Response.Write "<tr>"
Response.Write "<td>"&RS("FieldValue")&"</td>"
Response.Write "</tr>"

RS.MoveNext
Loop
End If

Response.Write "</table>"

RS.Close
Conn.Close
Set RS = Nothing
Set Conn = Nothing
%>

What I want to do is add a form like the one below that user can use
to determine the "field value" that is displayed.

<p><form METHOD="POST" ACTION="WebPageName.asp"><input
NAME="FormField" VALUE="<%=Request("FormFieldValue")%>"
size="24">&nbsp;<input TYPE="submit" value="Search!"></form></p>

So if they type in "Smith" they get all entries that have a field
value of Smith

I'm not sure how to write the query so it looks at the form for the
value it uses to display information.

Any code examples would help me a great deal as I seem to be close,
but I cannot "connect" to two elements.

Thanks for taking the time to read all of this, and for any assiatance
you can offer.

Feb 16 '07 #2

P: n/a
On Feb 16, 1:33 am, "Patrick" <nos...@nowhere.comwrote:
I think you want something like this:

mySQL="SELECT * FROM DatabaseTableName WHERE (TableFieldName='" &
Request.Form("FieldValue") & "') ORDER BY TableFieldName ASC"

It's a single quote followed by doublequotes after TableFieldName=, and
doublequotes followed by a single quote before the ORDER BY

"Brave" <bravespl...@yahoo.comwrote in message

news:11**********************@a75g2000cwd.googlegr oups.com...
I'm hoping someone can help me with a small issue.
I have an asp page that displays informaton from an Access database.
I want to create a form that allows users to display only data that
matches their search criteria.
I have made many forms like this in Front Page with the Database
results wizard, but I want to manually code it.
Here is the code I use to display the data from a database.
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "driver={Microsoft Access Driver (*.mdb)};;DBQ=\\****\****
\DatabaseName.mdb;"
mySQL="SELECT * FROM DatabaseTableName WHERE (TableFieldName =
'FieldValue') ORDER BY TableFieldName ASC"
Set RS = Conn.Execute(mySQL)
If RS.EOF and RS.BOF Then
Response.Write("<font face=""verdana"" size=""2""><p>No records
returned.</p>")
Else
Response.Write "<table><tr>"
Response.Write "<td><b>Table Field Name</b></td>"
Response.Write "</tr>"
Do While Not RS.EOF
Response.Write "<tr>"
Response.Write "<td>"&RS("FieldValue")&"</td>"
Response.Write "</tr>"
RS.MoveNext
Loop
End If
Response.Write "</table>"
RS.Close
Conn.Close
Set RS = Nothing
Set Conn = Nothing
%>
What I want to do is add a form like the one below that user can use
to determine the "field value" that is displayed.
<p><form METHOD="POST" ACTION="WebPageName.asp"><input
NAME="FormField" VALUE="<%=Request("FormFieldValue")%>"
size="24">&nbsp;<input TYPE="submit" value="Search!"></form></p>
So if they type in "Smith" they get all entries that have a field
value of Smith
I'm not sure how to write the query so it looks at the form for the
value it uses to display information.
Any code examples would help me a great deal as I seem to be close,
but I cannot "connect" to two elements.
Thanks for taking the time to read all of this, and for any assiatance
you can offer.- Hide quoted text -

- Show quoted text -
Thanks so much. I will give it a try.

Feb 16 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.