Begining asp begining

Evertjan. · Apr 4, 2010

Haziq wrote on 05 apr 2010 in microsoft.public.inetserver.asp.general:

How to modyfy rs.Open "SELECT * FROM Customers WHERE
CustomerID=CustomerID",

There is no ASP-code only VBscript-code or Javascript-code on an ASP
platform. Below I will assume ASP-VBS.

" ... WHERE CustomerID=CustomerID" is not very logical,
how would the database enging know what customer it needs to look for?

Try:

sql = "SELECT * FROM tblCustomers WHERE CustomerID = " & CustomerID
response.write sql
response.end
''' Always first debug by writing the sql result string,
''' only if you are happy with that go on with:

set mD = CONNECT.Execute(sql)

if not mD.eof then
'' do what you must if found
else
response.write "No CustomerID "&CustomerID&" exists in tblCustomers"
end if

Haziq · Apr 5, 2010

What wrong with my asp coding ?
How to modyfy rs.Open "SELECT * FROM Customers WHERE CustomerID=CustomerID",
conn.
plz

<html>
<body>

<form method="get" action="testing04b.asp">
Client: <input type="text" name="CustomerID" /><br />
<br />
<input type="submit" value="Submit" />
</form>

</body>
</html>

----------------------------------
testing04b.asp

<html>
<body>

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "C:\Inetpub\wwwroot\iissamples\sdk\asp\database\northwind.mdb"
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT * FROM Customers WHERE CustomerID=CustomerID", conn

response.write(request.querystring("fname"))
response.write(CustomerID)

rs.close
conn.close

%>

</body>
</html>

Problem binding dataset to a repeater	4	Oct 10, 2006
Item cannot be found in the collection corresponding to the requested name or ordinal	2	Nov 9, 2004
Newbie VB.net ASPX question	0	May 2, 2007
Handling Ref. Integ Error?	6	Aug 15, 2003
Strange problem w. missing recordset column (SQL + ASP)	4	Sep 28, 2004
Redirect Problem	0	Sep 19, 2005
Sorting and Paging in the Database	10	May 15, 2007
How to add a button to Modify, delete or add a new record to this code	2	Oct 1, 2005

Begining asp begining

Evertjan.

Haziq

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads