Thank You all for the quick response.

Below is my new query resulting from your ideas

SELECT *

FROM dbo.Monthly_Data

WHERE (date >= 'MMColParam')  AND (date <(dateadd(s,86399, 'MMColParam2')))

And so far it seems to work

The problem is I am using a Calendar java script to let people pick the date, is there a way to add one day to the date that they selected...

Sample data

Company = ABC

dateupdated = 03/12/2006 /*Request for a update was sent on*/

oneday = 1 /*denotes that 5 days ago a request for a updat was sent to this company*/

Completed...

Here is my final code..This works...Let me know if you can see a problem with this...Not too much worry about the mailserver going down or multiply entries being done at...

I am getting a error with this line.

ONSA_NSS.datesent = fn(date),

What I want to do is insert the Date time into this field..what would be the proper command to do this

The above works great ...Thank You...

Can we now take it a couple steps further...

Below is the code with the proper Table names..

CREATE...

Give this link a try...I have tried SQLMail and Cdonts but found this to work the best for me.

http://www.sqldev.net/xp/xpsmtp.htm

This has worked very well for me.

Ok I got the following code to kind of work...Is it proper to use the expressions "<>" or "=>" for does not equal or is equal to or greater than?

 <%...

Thank You very much for your response.

With your input i have come up with the following code...Problem is I keep getting a expected End of Statement error. Basicly if the...

Can you put up a sample of the code you are using?

You are a GENIUS..it works..........and it is such a simple piec of code.

Thank you very much

Here is the problem..I dont know what will be in the XML doc...each one will contain differant information.

The first part of the code "Browser" grabs information from a Mainframe according...

Thank You for your response..This problem has been keeping me up at nights.

Below is the error I get when I try to view the page wit youtr code added.

Below that...