I am comparing a created date to a result from a database and am unable to get them to agree. Several drop down boxes provide integer values for month/date/year that insert into the database correctly. Before running the insert, I search the DB for a Date value equal to the value about to be inserted and cannot get the comparison to work correctly.

Code Segments:

var Month = new String (Request.Form("Month"));
var Date = new String (Request.Form("Date"));
var Year = new String (Request.Form("Year"));

var InsertDate = Month + "/" + Date + "/" + Year;

SQL = "INSERT INTO NurseryEvent (EventDate, ServiceID) VALUES ('"
SQL = SQL + InsertDate
SQL = SQL + "', "
SQL = SQL + ServiceDescriptionID
SQL = SQL + ")";

adoConnection.Execute(SQL);

Above code works correctly. When I try to add a Select/check function before the insert command, the comparisons fail:

SQL = "SELECT * FROM NurseryEvent ";
SQL = SQL + " WHERE EventDate = " + InsertDate;

RS = adoConnection.Execute(SQL);

EventDate NEVER seems to equal InsertDate

Help!!??

Rich

__________________
Ego is a faithful friend; He stays with us all the way to the crater.

which db are you using?

Access 2000

Try this then:

SQL = "SELECT * FROM NurseryEvent ";
SQL = SQL + " WHERE EventDate = #" + InsertDate + "#";

That fixed the problem.

So I don't beat my head against the wall for 2 days the next time, what do the # signs mean/do and why did the WHERE statement not work until they were there?

Thanks loads for the help!!!

We use # when comparing dates, simply put its similar like the single quote character that we use when we compare strings.

how would you do the same thing but in SQL2000?

In SQL 2000, you don't have to use # around the date value, just wrap that within single quotes. Cheers!

_________________________
- Vijay G
Strive for Perfection