Query Parameters Not Working 1

[jessedh]

Hello,

I am new to ASP and can't get this to work. I am sure that it is something simple. Additionally, can some explain what the additional parameters in the rs.open line represent?

Thanks,
Jesse

<%@ Language=VBScript %>

<%

Dim conn
Dim rs
Dim strConn
Dim strSQL
Dim appNumb
Dim SQLstr

appNumb = Request.Form(&quot;txtAppNumb&quot

strSQL = &quot;SELECT tbl1Master.* FROM tbl1Master WHERE tbl1Master.[1ApplNumb])=&quot;&quot;&quot;& appNumb & &quot;&quot;&quot;;&quot;

'Create the object. In this case Connection to a database
Set Conn = Server.CreateObject(&quot;ADODB.Connection&quot

'Select the provider
Conn.Provider = &quot;Microsoft.Jet.OLEDB.4.0&quot;

'Select the data source.
Conn.ConnectionString = &quot;Data Source=C:\Inetpub\

http://wwwroot\Jesse_SNM.mdb&quot;

'Open the connection
Conn.Open

'Create a recordset object
Set Rs = Server.CreateObject(&quot;ADODB.Recordset&quot

'Open the recordset with the connection created earlier
Rs.Open strSQL,Conn, 1,3

Response.write rs(0).value
%>

<br><br>

<%
Response.write appNumb
%>

 

[JamesLean]

A shot in the dark, seeing as you haven't actually told us what error you're getting - try changing your SQL line to:

strSQL = "SELECT * FROM tbl1Master WHERE [1ApplNumb] = '" & appNumb & "'"

--James

 

[jessedh]

wow, you guys are awesome that worked!

I was getting an invalid SQL string.

can you tell what those parameters represent?

 

[JamesLean]

Have a look at this guide:

http://www.devguru.com/Technologies/ado/quickref/recordset_open.html

--James