![]() Topic awaiting preservation: SQL problem (ASP) (Page 1 of 1) |
|
---|---|
Paranoid (IV) Inmate From: NZ |
![]() Hi, guys. How are you? Please help me. code: sql = "SELECT WineryName, Name, Region, Price, Star, Vintage, Classic, Screw, AirNZ, Cuisine FROM Winery INNER JOIN"
|
Paranoid (IV) Inmate From: France |
![]() Hiroki: |
Paranoid (IV) Inmate From: NZ |
![]() Hi, Poi. Thank you for your reply. quote:
code: <%Do Until Not rs.EOF AND recct >= maxrecs%>
|
Obsessive-Compulsive (I) Inmate From: Frederick, MD, USA |
![]() The code that checks whether the recordset is empty is fine, but the rest of it gets executed either way. You have to put the actual display in an else section. If not it's going to display that nothing was found then try to access the recordset anyway. |
Paranoid (IV) Inmate From: NZ |
![]() Hi, BikerSoft. Welcome to Ozoneasylum and many many thanks for your reply. code: SELECT * FROM Winery WHERE Wine_Winery.Price < 30 AND Winery.WineryName = ''
code: SELECT * FROM Winery WHERE Wine_Winery.Price < 30
code: <!-- This is main sql statement -->
|
Paranoid (IV) Inmate From: NZ |
![]() Hi, guys. code: If Request("winery")= "1" then
|
Paranoid (IV) Inmate From: NZ |
![]() Hi, Poi. Really thanks for telling me that. |