Dynamic Table not displaying data

Report · Sep 12, 2012

First off, i have searched high and low, and havent been able to find much help.

That said, i have been trying to create a simple search/results page in dream weaver, i am using ASP and sql express. Ive been following the adobe tutorial, and everything works as it says it should, except that when you actually do a search, and hit submit, the results page only shows the dynamic table headings, but no data.

On the results page, when i create the record set, if i test it, the data shows up correctly. However on the page itself, nothing shows up.

Here are some example screen shots:

Report · Sep 12, 2012

The answer is in the code. Screenshots don't help much.

Report · Sep 12, 2012

Results page:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>

<%

Dim rsUserResults__MMColParam

rsUserResults__MMColParam = "1"

If (Request.QueryString("frmUserSearch") <> "") Then

rsUserResults__MMColParam = Request.QueryString("frmUserSearch")

End If

%>

<%

Dim rsUserResults

Dim rsUserResults_cmd

Dim rsUserResults_numRows

Set rsUserResults_cmd = Server.CreateObject ("ADODB.Command")

rsUserResults_cmd.ActiveConnection = MM_netdata_STRING

rsUserResults_cmd.CommandText = "SELECT logonDate FROM dbo.loginInfo WHERE userName = ?"

rsUserResults_cmd.Prepared = true

rsUserResults_cmd.Parameters.Append rsUserResults_cmd.CreateParameter("param1", 200, 1, 50, rsUserResults__MMColParam) ' adVarChar

Set rsUserResults = rsUserResults_cmd.Execute

rsUserResults_numRows = 0

%>

<%

Dim Repeat1__numRows

Dim Repeat1__index

Repeat1__numRows = 10

Repeat1__index = 0

rsUserResults_numRows = rsUserResults_numRows + Repeat1__numRows

%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

<tr>

<td>logonDate</td>

<td>loginTime</td>

<td>computerName</td>

<td>userName</td>

</tr>

<% While ((Repeat1__numRows <> 0) AND (NOT rsUserResults.EOF)) %>

<tr>

</tr>

<%

Repeat1__index=Repeat1__index+1

Repeat1__numRows=Repeat1__numRows-1

rsUserResults.MoveNext()

Wend

%>

</table>

</body>

</html>

<%

rsUserResults.Close()

Set rsUserResults = Nothing

%>

---------------------------------------------------------------------------------

Search page:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

<p>Enter User Name

</p>

<p>

</p>

</form>

</body>

</html>

Report · Sep 12, 2012

You are populating your variable with this querystring value:

Request.QueryString("frmUserSearch"). That's the name of the form, not the form field with the user name.

Your form field is "name="userName"

Change all references in your script from "frmUserSearch" to "userName"

Report · Sep 12, 2012

that was it, as you can tell, this is the first dynamic table ive tried to do, Thank you for the help.

Dynamic Table not displaying data

1 Correct answer