|
| |
how I get a recordset that contains only records with Price > $90.00 ?
View related threads:
(in this forum
| in all forums)
|
Logged in as: Guest
|
|
|
lsfphelpls
Posts: 458
Joined: 3/16/2005
Status: offline
 |
how I get a recordset that contains only records with P... - 7/10/2007 15:03:45
ado/sql
how to program
a table has ProductName and Price fields
how I get a recordset that contains only records with Price > $90.00 ?
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: how I get a recordset that contains only records wi... - 7/10/2007 15:21:40
The SQL would look something like:
"SELECT ProductName,Price FROM (tableName) WHERE Price > 90"
but all the other connection stuff can be found here:
http://www.aspfaqs.com/aspfaqs/
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
lsfphelpls
Posts: 458
Joined: 3/16/2005
Status: offline
|
RE: how I get a recordset that contains only records wi... - 7/11/2007 2:50:48
ANOTHER FILTER
THIS can be done ?
strFilter = "'" oRS("UnitsInStok") "'<'" oRS("ReorderLevel") "'"
oRS.Filter = strFilter
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: how I get a recordset that contains only records wi... - 7/11/2007 8:49:26
Yes but if they're numbers don't use the apostrophes.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
