Try with single quotes around dtTempDate.
--- professorw999 <[EMAIL PROTECTED]> wrote:
> My mySQL statement below is returning this error:
> "Syntax error (missing operator) in query expression
> 'MfgID = 3629
> AND DateContacted > 12/16/2003 4:12:09 PM'." It
> worked until I
> added the DateContacted > dtTempDate part.
> DateContacted is a date
> field in Access.
>
> Any ideas?
>
> IF Request.QueryString("M") = "6" OR
> Request.QueryString("M") = "9"
> THEN
> intM = Request.QueryString("M")
> ELSE
> intM = "3"
> END IF
>
> intID = Request.Cookies("SRSMemberCookie")("I")
> dtTempDate = DateAdd ("m", -intM, Now())
> mySQL = "SELECT * FROM tblRequests WHERE MfgID = " &
> intID & " AND
> DateContacted > " & dtTempDate & " ORDER BY
> DateContacted DESC"
> Set objRS = Server.CreateObject("ADODB.Recordset")
> objRS.Open mySQL, objConn
>
> Thanks,
> PW
>
>
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/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/
