[RESOLVED] A Rs.EOF Question

[Evren Betimen]

CusNameFld = request("CustomerNameField")

SQL = "SELECT Customers FROM Sales WHERE CustomerName = "&CusNameFld&" "

set RS = Server.CreateObject("ADODB.RecordSet")
RS.open SQL , conn , 1 , 3

if not rs.eof then
...Some Code...
end if

...Some HTML code...

if rs.eof then
...(Needed code)... (I want to show all customers)


I want to return CusNameFld variable to assign a value as "0" to show all records on my ASP Page. Is it possible to do?

Thanks in advance,
Greetings

[yamaharuss]

What the heck do you mean by "assign a value as "0"???

[Evren Betimen]

What the heck do you mean by "assign a value as "0"???

...
CusNameFld = "0" (This value shows all customers)

SQL = "SELECT Customers FROM Sales WHERE CustomerName = "&CusNameFld&" "

I don't know how to return variable if rs.eof. I don't want to write code again. Is it possible?

[yamaharuss]

SQL = "SELECT Customers FROM Sales "
If CusNameFld <> "0" then SQL = SQL & "WHERE CustomerName = "&CusNameFld&" "

[Evren Betimen]

Thank you for reply. It works