How do you pass parameters to an ASP page

DougP · Jun 20, 2000

here is my code: ------------------------------------------- <%@ Language=VBScript %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <meta name="GENERATOR" content="Microsoft FrontPage 4.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <title>New Page 2</title> </head> <body> <%  Response.Write("These records are pulled from an MS Access database&quot

%> <% Set Conn = Server.CreateObject("ADODB.Connection&quot

Conn.Open "driver=SQL Server;server=<A HREF="

http://universal1.com"

TARGET="_new">

http://universal1.com</A>;uid=Universal1;pwd=ULS1;database=Universal1;" Set

RS = Conn.Execute("SELECT *, STOCK_CODE AS Expr1 FROM [Copy-PartMaster Lite] WHERE (STOCK_CODE LIKE N'40016%')&quot

If Not RS.EOF Then Do Response.Write RS("STOCK_CODE&quot

& " " & RS("DESCRIPTION&quot

Response.Write "" RS.Movenext Loop Until RS.EOF Else msgbox "Empty Baby" End If %> <% do while not RS.eof %> <%= RS(0) %> <% RS.movenext loop%> <% RS.close %> </body> </html> --------------------------- where is has "LIKE N'40016%" I would like to replace this with a variable of some sort like a text box on a WEB page form. When I create a submit button what do I put in it. I am using Front Page 2000 for WEB creation TIA DougP <a href=mailto: dposton@universal1.com> dposton@universal1.com</a> <a href= > </a> Ask me how Bar-codes can help you be more productive.

NickBulka · Jun 20, 2000

Doug,    Here's a link to a forms tutorial: <A HREF="

http://www.learnasp.com/learn/formintro.asp"

TARGET="_new">

http://www.learnasp.com/learn/formintro.asp</A>

nick bulka <a href=mailto: > </a> <a href= > </a>

DougP · Jun 20, 2000

Thanks Nick, DougP <a href=mailto: dposton@universal1.com> dposton@universal1.com</a> <a href= > </a> Ask me how Bar-codes can help you be more productive.

Karl Blessing · Jun 20, 2000

I use this so far, it's part of my Database Navigator (The file one is very similar, only it goes into directories , and so forth showing all the exe/ocx/dll versions) Note how it calls itself, and processes a Form post <%@ Language=VBScript %> <HTML> <HEAD>  <Title>DataBase Navigator</Title>  <Script Language="JavaScript">     </Script> </HEAD> <BODY> <Form name="DSNFrm" action="DSNNav.asp" method="post">  <input type="hidden" name="Path"> </Form> <% set OU = Server.CreateObject("WsUtil.ODBCs&quot

Dim KeyLoop If not IsEmpty(Request.Form("Path&quot

) and Request.Form("Path&quot

<> "Root" then  Dim AllValue  AllValue = OU.getallValName(Request.Form("Path&quot

)  If VarType(AllValue) = vbArray + vbVariant then   %>   <INPUT type="button" value="Back" onclick="Go('Root')">   <Table border=1 width="75%" align=center>   <TH align=center colspan=2 bgcolor=Black> <%=Request.Form("Path&quot

%> </TH>   <TR>    <TD bgcolor=Black align=center> Setting </TD>    <TD bgcolor=Black align=center> Value   </TD>   </TR>   <%   For KeyLoop = 0 to UBound(AllValue)    %>    <TR>     <TD><%=AllValue(KeyLoop,0)%> </TD>     <TD><%=AllValue(KeyLoop,1)%> </TD>    </TR>    <%   next   %></Table><%  end if else  Dim AllDSN  AllDSN = OU.GetAllDSN  If VarType(AllDSN) = vbArray + vbVariant then   %>   <Table border=1 width="75%" align=center>   <TH align=center colspan=2 bgcolor=Black> Root </TH>   <TR>    <TD align=center bgcolor=Black> System DSN Name </TD>    <TD align=center bgcolor=Black> Driver          </TD>   </TR>   <%   For KeyLoop = 0 to UBound(AllDSN)    %>    <TR>     <TD onclick="Go('<%=AllDSN(KeyLoop,0)%>')"><%=AllDSN(KeyLoop, 0)%> </TD>     <TD                                       ><%=AllDSN(KeyLoop, 1)%> </TD>    </TR>    <%   next   %></Table><%  end if end if %> </BODY> </HTML> Karl <a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a> <a href=

http://kb244.8m.com>

</a> Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)

Amiel · Jun 20, 2000

<html> <body> <FORM NAME=theform" ACTION="thecodeabove.asp" method="get">  <PRE>   <Input type ="TEXT" NAME="usersupplieddata" SIZE = 10>  </PRE>   <INPUT TYPE='submit" VALUE="Send Query"> </FORM> </body> </html> in your code above add '... '... dim uservar uservar = request.querystring("usersupplieddata&quot

'... ' you can test usrvar to determine if your want to use ' 'LIKE vs. '=' in the query expression. Conn.Execute("SELECT *, STOCK_CODE AS Expr1 FROM [Copy-PartMaster Lite] WHERE (STOCK_CODE LIKE '" & uservar & "%')&quot

Amiel <a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a> <a href= > </a>

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!

How do you pass parameters to an ASP page

DougP

MIS

NickBulka

Programmer

DougP

MIS

Karl Blessing

Programmer

Amiel

Programmer

Similar threads

Part and Inventory Search

Sponsor