Parameter passing query

Nick Halfpenny · Oct 27, 2004

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>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Info</title>
</head>

<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>

Kevin Spencer · Oct 27, 2004

Maybe I'm missing something, but this sure looks like an exact copy (sans
title) of your previous post. That is what is known in newsgroup circles as
double-posting. Tsk, tsk.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living

Nick Halfpenny said:
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>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Info</title>
</head>

<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&p
roptypecode=129&area=200&offers=2&diff_in_weeks=2&voidstart=135&keyretdate=1
35&relettarget=135&actrelet=135&udd15=129&voidaltkey=3&voidsuffix=2&voidtype
=129&eventbi=129&eventbidate=135&eventfcas=129&eventfcasdate=135&eventffl=12
9&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>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="propref,houseno,proadd1,heatcode,bedrooms,proptypecode,area,o
ffers,diff_in_weeks,voidstart,keyretdate,relettarget,actrelet,udd15,voidaltk
ey,voidsuffix,voidtype,eventbi,eventbidate,eventfcas,eventfcasdate,eventffl,
eventffldate,sfacode,freetext"
s-column="houseno" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font

size="-1"><< said:
size="-1">>>" startspan
--><%=FP_FieldVal(fp_rs,"houseno")%></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="propref,houseno,proadd1,heatcode,bedrooms,proptypecode,area,o
ffers,diff_in_weeks,voidstart,keyretdate,relettarget,actrelet,udd15,voidaltk
ey,voidsuffix,voidtype,eventbi,eventbidate,eventfcas,eventfcasdate,eventffl,
eventffldate,sfacode,freetext"
s-column="proadd1" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font

size="-1"><< said:
size="-1">>>" startspan
--><%=FP_FieldVal(fp_rs,"proadd1")%></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="propref,houseno,proadd1,heatcode,bedrooms,proptypecode,area,o
ffers,diff_in_weeks,voidstart,keyretdate,relettarget,actrelet,udd15,voidaltk
ey,voidsuffix,voidtype,eventbi,eventbidate,eventfcas,eventfcasdate,eventffl,
eventffldate,sfacode,freetext"
s-column="heatcode" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font

size="-1"><< said:
size="-1">>>" startspan
--><%=FP_FieldVal(fp_rs,"heatcode")%></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="propref,houseno,proadd1,heatcode,bedrooms,proptypecode,area,o
ffers,diff_in_weeks,voidstart,keyretdate,relettarget,actrelet,udd15,voidaltk
ey,voidsuffix,voidtype,eventbi,eventbidate,eventfcas,eventfcasdate,eventffl,
eventffldate,sfacode,freetext"
s-column="bedrooms" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font

size="-1"><< said:
size="-1">>>" startspan
--><%=FP_FieldVal(fp_rs,"bedrooms")%></td>
<td>
<%=FP_FieldVal(fp_rs,"proptypecode")%></td>
<td>
<%=FP_FieldVal(fp_rs,"area")%></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="propref,houseno,proadd1,heatcode,bedrooms,proptypecode,area,o
ffers,diff_in_weeks,voidstart,keyretdate,relettarget,actrelet,udd15,voidaltk
ey,voidsuffix,voidtype,eventbi,eventbidate,eventfcas,eventfcasdate,eventffl,
eventffldate,sfacode,freetext"
s-column="offers" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font

size="-1"><< said:
size="-1">>>" startspan
--><%=FP_FieldVal(fp_rs,"offers")%></td>
<td>
<%=FP_FieldVal(fp_rs,"diff_in_weeks")%></td>
<td>
</td>
<td>
</td>
<td>
<%=FP_FieldVal(fp_rs,"relettarget")%></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="propref,houseno,proadd1,heatcode,bedrooms,proptypecode,area,o
ffers,diff_in_weeks,voidstart,keyretdate,relettarget,actrelet,udd15,voidaltk
ey,voidsuffix,voidtype,eventbi,eventbidate,eventfcas,eventfcasdate,eventffl,
eventffldate,sfacode,freetext"
s-column="actrelet" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font

size="-1"><< said:
size="-1">>>" startspan
--><%=FP_FieldVal(fp_rs,"actrelet")%></td>
<td>
<%=FP_FieldVal(fp_rs,"udd15")%></td>
<td>
</td>
<td>
</td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="propref,houseno,proadd1,heatcode,bedrooms,proptypecode,area,o
ffers,diff_in_weeks,voidstart,keyretdate,relettarget,actrelet,udd15,voidaltk
ey,voidsuffix,voidtype,eventbi,eventbidate,eventfcas,eventfcasdate,eventffl,
eventffldate,sfacode,freetext"
s-column="voidtype" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font

size="-1"><< said:
size="-1">>>" startspan
--><%=FP_FieldVal(fp_rs,"voidtype")%></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="propref,houseno,proadd1,heatcode,bedrooms,proptypecode,area,o
ffers,diff_in_weeks,voidstart,keyretdate,relettarget,actrelet,udd15,voidaltk
ey,voidsuffix,voidtype,eventbi,eventbidate,eventfcas,eventfcasdate,eventffl,
eventffldate,sfacode,freetext"
s-column="eventbi" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font

size="-1"><< said:
size="-1">>>" startspan
--><%=FP_FieldVal(fp_rs,"eventbi")%></td>
<td>
<%=FP_FieldVal(fp_rs,"eventbidate")%></td>
<td>
</td>
<td>
<%=FP_FieldVal(fp_rs,"eventfcasdate")%></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="propref,houseno,proadd1,heatcode,bedrooms,proptypecode,area,o
ffers,diff_in_weeks,voidstart,keyretdate,relettarget,actrelet,udd15,voidaltk
ey,voidsuffix,voidtype,eventbi,eventbidate,eventfcas,eventfcasdate,eventffl,
eventffldate,sfacode,freetext"
s-column="eventffl" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font

size="-1"><< said:
size="-1">>>" startspan
--><%=FP_FieldVal(fp_rs,"eventffl")%></td>
<td>
<%=FP_FieldVal(fp_rs,"eventffldate")%></td>
<td>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="propref,houseno,proadd1,heatcode,bedrooms,proptypecode,area,o
ffers,diff_in_weeks,voidstart,keyretdate,relettarget,actrelet,udd15,voidaltk
ey,voidsuffix,voidtype,eventbi,eventbidate,eventfcas,eventfcasdate,eventffl,
eventffldate,sfacode,freetext"
s-column="sfacode" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font

Nick Halfpenny · Oct 27, 2004

Thank's Kevin. I posted twice, as the 'notify me of replies' tick box cause
an error when I orginaly posted the question. Perhaps an bug !

Nick Halfpenny · Oct 27, 2004

Hi Kevin,

Definitely a bug Microsoft HTML code. I receive the following error
everytime I tick 'Notify me of replies' !!!!. If I don't tick it, all is OK.

An error occurred while sending your pos
--------------------------------------------------------------------------------

We're sorry, but there was a problem with the system and your post was not
received. The error has been reported to Operations and will be investigated
as soon as possible. Please try again later.

Kevin Spencer · Oct 27, 2004

Ah, well, thank you, Nick, for posting this information. Microsoft DOES read
these newsgroups!

You have done your good deed for the day.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living

Parameter passing within a ASP page	2	Oct 27, 2004
Passing Criteria to webbot Statement	0	Nov 1, 2004
Amending SQL Statements in <!--webbot	0	Oct 28, 2004
ASP webbot	2	Nov 4, 2004
Pass Date Parameter	8	Nov 23, 2004
union query not displaying?	5	Apr 20, 2007
SELECT DISTINCT Query not working	4	Oct 24, 2004

Parameter passing query

Nick Halfpenny

Kevin Spencer

Nick Halfpenny

Nick Halfpenny

Kevin Spencer

Ask a Question

Similar Threads