ASP page from Access

jarcat · Sep 19, 2001

I have used the "export to" option in Access to take my query across to an ASP page in my web. The query page appears as does the results page, however when you preview in a browser and enter criteria in the query, no results come back. Checking the same in Access and all works fine. I am using a test environment with Personal Web Server on a local machine.
Any help or suggestions would be greatly appreciated.
Thanks

shaddow · Sep 20, 2001

Please place your code to see what is the problem... ________
George, M

jarcat · Sep 20, 2001

Thanks for the review:
The copy is here:
Any help much appreciated.
Rgds

<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;charset=windows-1252">
<TITLE>res details Query</TITLE>
</HEAD>
<BODY>
<%
If IsObject(Session("ian.dsn_conn&quot

) Then
Set conn = Session("ian.dsn_conn&quot

Else
Set conn = Server.CreateObject("ADODB.Connection&quot

conn.open "ian.dsn","",""
Set Session("ian.dsn_conn&quot

= conn
End If
%>
<%
If IsObject(Session("res_details_Query_rs&quot

) Then
Set rs = Session("res_details_Query_rs&quot

Else
sql = "SELECT [res details].[masterfile], [res details].[reservation ID], [res details].[first name], [res details].[last name], [res details].[event], [res details].[performance], [res details].[date], [res details].[time], [res details].[section], [res details].[seat], [res details].[price], [res details].[row] FROM [res details] WHERE ((([res details].[masterfile])=" & Request.QueryString("" & Request.QueryString("[Enter &quot

& "Ma&quot

& "sterfile:]) And (([res details].[reservation ID])=" & Request.QueryString("[Enter &quot

& "res id:])) "
Set rs = Server.CreateObject("ADODB.Recordset&quot

rs.Open sql, conn, 3, 3
If rs.eof Then
rs.AddNew
End If
Set Session("res_details_Query_rs&quot

= rs
End If
%>
<TABLE BORDER=1 BGCOLOR=#ffffff CELLSPACING=0><CAPTION>res details Query</CAPTION>

<THEAD>
<TR>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 >masterfile</TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 >reservation ID</TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 >first name</TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 >last name</TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 >event</TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 >performance</TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 >date</TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 >time</TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 >section</TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 >seat</TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 >price</TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 >row</TH>

</TR>
</THEAD>
<TBODY>
<%
On Error Resume Next
rs.MoveFirst
do while Not rs.eof
%>
<TR VALIGN=TOP>
<TD BORDERCOLOR=#c0c0c0 ALIGN=RIGHT><%=Server.HTMLEncode(rs.Fields("masterfile&quot

.Value)%> </TD>
<TD BORDERCOLOR=#c0c0c0 ALIGN=RIGHT><%=Server.HTMLEncode(rs.Fields("reservation ID&quot

.Value)%> </TD>
<TD BORDERCOLOR=#c0c0c0 ><%=Server.HTMLEncode(rs.Fields("first name&quot

.Value)%> </TD>
<TD BORDERCOLOR=#c0c0c0 ><%=Server.HTMLEncode(rs.Fields("last name&quot

.Value)%> </TD>
<TD BORDERCOLOR=#c0c0c0 ><%=Server.HTMLEncode(rs.Fields("event&quot

.Value)%> </TD>
<TD BORDERCOLOR=#c0c0c0 ><%=Server.HTMLEncode(rs.Fields("performance&quot

.Value)%> </TD>
<TD BORDERCOLOR=#c0c0c0 ALIGN=RIGHT><%=Server.HTMLEncode(rs.Fields("date&quot

.Value)%> </TD>
<TD BORDERCOLOR=#c0c0c0 ALIGN=RIGHT><%=Server.HTMLEncode(rs.Fields("time&quot

.Value)%> </TD>
<TD BORDERCOLOR=#c0c0c0 ><%=Server.HTMLEncode(rs.Fields("section&quot

.Value)%> </TD>
<TD BORDERCOLOR=#c0c0c0 ALIGN=RIGHT><%=Server.HTMLEncode(rs.Fields("seat&quot

.Value)%> </TD>
<TD BORDERCOLOR=#c0c0c0 ALIGN=RIGHT><%=Server.HTMLEncode(rs.Fields("price&quot

.Value)%> </TD>
<TD BORDERCOLOR=#c0c0c0 ><%=Server.HTMLEncode(rs.Fields("row&quot

.Value)%> </TD>

</TR>
<%
rs.MoveNext
loop%>
</TBODY>
<TFOOT></TFOOT>
</TABLE>
</BODY>
</HTML>

shaddow · Sep 25, 2001

Have u printed out the sql string, to see if is ok? ________
George, M

link9 · Sep 25, 2001

When you say, "Preview in browser"... that makes it sound suspiciously like previewing it directly from your design software, which will not work...

You said you are using PWS, but are you typing in the address to look at the page like:

http://localhost/dirPath/page.asp

???

where 'dirPath' is the share name that you set up in PWS and 'page.asp' is the name of your file.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

ASP page from Access

jarcat

IS-IT--Management

shaddow

Programmer

jarcat

IS-IT--Management

shaddow

Programmer

link9

Programmer

Similar threads

Part and Inventory Search

Sponsor