Prev: apagamento
Next: SQL Group By problem
From: Evertjan. on 4 Apr 2010 16:24
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


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
 | 
Pages: 1
Prev: apagamento
Next: SQL Group By problem