Hi,
1)Try with Cint and see if it is working. It shouldn't
be a problem, but you never know with ASP.
2)Try each condition individually and check if it is
working. Then you can filter out the problem.
My wild guess is, if there is no record present and it
is checking for the OR condition which then compares a
null value with the DateAdd value, it is throwing this
exception.
Ramalakshmi.
--- professorw999 <[EMAIL PROTECTED]> wrote:
> Sorry about the re-post all. DateContacted is a
> date field in
> Access. The error being returned is "error
> '80020009'".
>
>
> Here is the original post again:
>
> I've got an error in the date portion of the line
> below I can't
> figure out. To protect from spam, we have a contact
> form that we
> only want to allow submissions to go through if a
> record does not
> exist for the user or if the date in the
> DateContacted field is more
> than 90 days ago.
>
> Anyone know the fix?
>
> IF objRS.EOF OR objRS("DateContacted") < DateAdd
> ("d", -90, Date)
> THEN
>
> Response.Write "Your submission has been sent."
>
> Thanks,
> PW
>
>
>
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
