I try this code but it give following error

Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'EoF'
/alart/triggered.asp, line 18


getInfo = conn.execute(sql)
If NOT getInfo.EoF then // line 18

other property method can use here ?

regards.

Mateen

;;;other property method can use here?

Use what ever method you usually use to get records from a data store.
Getting records:
sql = "SELECT id FROM tblName WHERE birthDate = " & (date()+3) & ";"
Execute query:
getInfo = conn.execute(sql)
Is there records:
If NOT getInfo.EoF then

Hard code some date in there I think you will find it works.

Wind is your friend
Matt

Hi all, some help needed help again.

How is it possible to change the select statement, where I want the warning to be set to 3 mths instead to 3 days?

Hope someone can help me respond asap. Thanks!

I hope you are using sql server.
If so please use the following code
sql = "SELECT id FROM tblName WHERE month(birthDate) = month(getdate());"

OR if it is MS ACCESS
sql = "SELECT ID FROM tbl_tblName WHERE month(birthDate) = month(now);"

I would use the dateAdd function:
"Returns a date to which a specified time interval has been added"
<%
'----------cut n paste start------------------
dim todayPlusThreeMonths
todayPlusThreeMonths = DateAdd("m", 3, date())
response.write todayPlusThreeMonths
'----------cut n paste finish-----------------
%>

Wind is your friend
Matt

Just forgot to add "3" to your sql.

sql = "SELECT id FROM tblName WHERE month(birthDate) = month(getdate())+ 3;"

OR if it is MS ACCESS
sql = "SELECT ID FROM tbl_tblName WHERE month(birthDate) = month(now)+ 3;"

Thank you all so much for responding to my post. I managed to get the alert to work and printed out on the page. One last thing,
How do i format the text if let's say

<%Response.Write MonthName(Month(DATE))%>

I wanna print the Month out in Capital letters instead of small letters? How so i solve it?

And if I wanna print out ONLY the current month in my Access database which is in DateTime data type, how do i select? Sorry for the trouble.

Cheers,
Hayley

You are welcome:

Using th uCase function:
Response.Write uCase(MonthName(Month(DATE)))

sql = "Select month(dateTypeFieldName) FROM ...."

Wind is your friend
Matt