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
------------------------ 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/
