Parameter passing within a ASP page

From: Nick Halfpenny (NickHalfpenny_at_discussions.microsoft.com)
Date: 10/27/04

Next message: clintonG: "Re: Book Recommendation Please"
Previous message: Nick Halfpenny: "Parameter passing query"
Next in thread: Michael Kintner: "Re: Parameter passing within a ASP page"
Reply: Michael Kintner: "Re: Parameter passing within a ASP page"
Messages sorted by: [ date ] [ thread ]

Date: Wed, 27 Oct 2004 08:27:04 -0700

Hi,

I’ve developed a ASP page that searches a database on our web server. I’ve
created a html form that passes parameters to a SQL statement on the ASP
page. Everything was working well until a few days ago, when the parameter
were still passed to the ASP page, but the data doesn’t seem to reach the SQL
statement.

In the ASP page, I’ve printed the parameter field to the screen so I know
the correct data is there. To investigate my problem, I’ve gone back to
basic’s. I’ve created a new ASP page using the wizard with FrontPage. I
allowed the wizard to create a parameter field that you can input directly on
screen, which then feeds through to the SQL. This all works fine.

I then removed the part of the script the allows you to do the input, and
replaced it with a static field as follows:

<%
Info="3"
response.write Info
%>

Although the data is held in the ‘Info’ field, the SQL statement doesn’t use
it !

Once I go back to passing parameters from a HTML form to a ASP page, the
Info field will be populated by using the request.querystring("Info")
function. I can’t understand why the page works fine if you use a ‘input’ on
the page, but doesn’t work when your passing parameters.

Any help would be appreciated.

Regards,

Nick

I’ve included the full ASP script below:

<html>

<body>

<%
Info="3"
response.write Info
%>

<table width="100%" border="1">
 <thead>
 <tr>
 <td>propref</td>
 <td>houseno</td>
 <td>proadd1</td>
 <td>heatcode</td>
 <td>bedrooms</td>
 <td>proptypecode</td>
 <td>area</td>
 <td>offers</td>
 <td>diff_in_weeks</td>
 <td>voidstart</td>
 <td>keyretdate</td>
 <td>relettarget</td>
 <td>actrelet</td>
 <td>udd15</td>
 <td>voidaltkey</td>
 <td>voidsuffix</td>
 <td>voidtype</td>
 <td>eventbi</td>
 <td>eventbidate</td>
 <td>eventfcas</td>
 <td>eventfcasdate</td>
 <td>eventffl</td>
 <td>eventffldate</td>
 <td>sfacode</td>
 <td>freetext</td>
 </tr>
 </thead>
 <tbody>
 
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Sol_voidlist where bedrooms=::Info::"
fp_sDefault="Info="
fp_sNoRecords="<tr><td colspan=25 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Academy_Live"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&propref=129&houseno=129&proadd1=129&heatcode=129&bedrooms=2&proptypecode=129&area=200&offers=2&diff_in_weeks=2&voidstart=135&keyretdate=135&relettarget=135&actrelet=135&udd15=129&voidaltkey=3&voidsuffix=2&voidtype=129&eventbi=129&eventbidate=135&eventfcas=129&eventfcasdate=135&eventffl=129&eventffldate=135&sfacode=129&freetext=200&"
fp_iDisplayCols=25
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<tr>
 <td>
 <%=FP_FieldVal(fp_rs,"propref")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"houseno")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"proadd1")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"heatcode")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"bedrooms")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"proptypecode")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"area")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"offers")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"diff_in_weeks")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"voidstart")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"keyretdate")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"relettarget")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"actrelet")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"udd15")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"voidaltkey")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"voidsuffix")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"voidtype")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"eventbi")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"eventbidate")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"eventfcas")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"eventfcasdate")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"eventffl")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"eventffldate")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"sfacode")%></td>
 <td>
 <%=FP_FieldVal(fp_rs,"freetext")%></td>
 </tr>
 
</tbody>
</table>

</body>

</html>

Next message: clintonG: "Re: Book Recommendation Please"
Previous message: Nick Halfpenny: "Parameter passing query"
Next in thread: Michael Kintner: "Re: Parameter passing within a ASP page"
Reply: Michael Kintner: "Re: Parameter passing within a ASP page"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Formatierungsproblem
... > Wie soll denn so ein EIN SQL Statement aussehen? ... > IE Schwierigkeiten bei der Darstellung und schlie�lich auch bei der ... ja nie welchen Browser der User hat, wie er diesen konfiguriert hat usw. ... > Ich sollte wirklich versuchen alles mit ASP zu managen. ...
(microsoft.public.de.inetserver.iis.asp)
Re: System.Data.SqlClient.SqlException: Subquery returned more than 1 value.
... I noticed after I posted that the group was .asp not aspnet, ... >> following SQL statement. ... >> INSERT INTO OrderItems (ClientID, ProductID, OrderHeaderID, Quantity, ... >> Dim conn As New System.Data.SqlClient.SqlConnection ...
(microsoft.public.inetserver.asp.db)
RE: Is this correct syntax for OLE DB for ODBC parameter query?
... (Just a brief review of that SQL statement) ... You may have more information from ASP .NET team. ... data showing up in the second list when the page loads or I make a selection ...
(microsoft.public.data.odbc)
Send email from ASP
... from my web site using ASP. ... or third-party) or SMTP server. ... One way to do it could be to set up a html form with fields to hold ... and body) and send it to the service provider. ...
(microsoft.public.inetserver.asp.general)
Re: Random sort via SQL in ASP
... and I will be calling this recordset in a SQL statement from ... randomize from ASP? ... I'd write some code that you can trigger that puts a random ... number in a field (e.g. sortfield as long) in the table. ...
(comp.databases.ms-access)