Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-08-21 : 00:14:41
|
Mike writes "hi, I am using an access 97 db and asp to run a query on a database. My query selects 7 different recordsets to populate my colums depending on the days of the week. My problem is if one of the records is null my asp script will not run. my code is something like this:-
MySQLSun = "SELECT * FROM roster WHERE (((roster.sheet_date)=#8/13/2000#))" this works and gives me the rows. If the row is empty it will hang. I need to implement some sort of if null to move to the next recordset. I alter the dates on the script to pull down the data for the different days. pls help"
|
|
|
|
|
|
Null values with select query using where