CF Newbie and Syntax Error

2000-05-08 Thread Jason Larson
Wondering if someone can help a Newbie out on when to use double quotes and single quotes? Here's my problem, I am trying to call info from a Access Database from two different text fields (EndDate, and ShowDate), into a Sql statement. Here's the code. SELECT * FROM Coupons WHERE "TodaysDate

RE: CF Newbie and Syntax Error

2000-05-08 Thread Tim Cavins
Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Monday, May 08, 2000 10:25 AM To: [EMAIL PROTECTED] Subject: CF Newbie and Syntax Error Wondering if someone can help a Newbie out on when to use double quotes and single quotes? Here's my problem, I am trying to call info from a Access Data

Re: CF Newbie and Syntax Error

2000-05-08 Thread Fred T. Sanders
No quotes or #s around actual table column names as well. Fred - Original Message - From: "Tim Cavins" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 08, 2000 9:32 AM Subject: RE: CF Newbie and Syntax Error > WHERE '#TodaysDate#&