Syntax error using date()

Results 1 to 4 of 4

Thread: Syntax error using date()

  1. #1
    Trish Guest

    Default Syntax error using date()

    I am getting the error: Syntax error (missing operator) in query expression &#039Ordertmp.CUR_DATE LT 3/15/00&#039. <BR><BR>My code is as follows:<BR>"DELETE * FROM Ordertmp WHERE Ordertmp.CUR_DATE LT " & CUR_DATE & ""<BR><BR>Will someone please tell me why I&#039m getting this error? <BR>Thanks in advance!<BR>Trish

  2. #2
    Jason Miller Guest

    Default RE: Syntax error using date()

    Try replacing "LT" (that looks like "less than") with a "&#060;". You&#039ll also want to enclose the date variable with #s, as such:<BR><BR>where cur_date &#060; #" & CUR_DATE & "#"<BR><BR>HiH.

  3. #3
    Trish Guest

    Default Thanks Jason

    That did the trick. Thanks again.

  4. #4
    Trish Guest

    Default Say, Jason, would you have a minute??????

    Would you happen to know why I am continually getting a System Resource Exceeded error when testing my ASP pages? I have tried closing my Record Sets, but that caused many other problems, so I took all that code out. I am closing all my databaseconnections and setting them back to "nothing".<BR><BR>I&#039m getting tired of rebooting 15 times a day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts