Re: [PHP-DB] Microsoft Access PHP

2002-07-05 Thread Maureen
If you are putting this in a web page, I assume you are putting quotes around the select statement. If so, are you escaping the quotes around Colour and Imaging Institute by putting \Colour and Imaging Institute\ instead (or using single quotes instead of double quotes)? If not, that may be

Re: [PHP-DB] Microsoft Access PHP

2002-07-05 Thread Maureen
Correction on that, I removed the wrong parentheses: SELECT ExamPapers.EPaperID, ExamPapers.EPapersText, ExamPapers.[Title of Paper], ExamPapers.Course, ExamPapers.School, ExamPapers.Year, ExamPapers.Jan/Summer], ExamPapers.[Module Code], ExamPapers.Stage, ExamPapers.[Storage Location],

[PHP-DB] Microsoft Access PHP

2002-07-04 Thread Daniel J Owen-Mcgee
Hi, I'm gleaning microsoft SQL from queries within a MS Access database, for insertion into my PHP pages. This has been working fine but the example below just refuses to work, SELECT ExamPapers.EPaperID, ExamPapers.EPapersText, ExamPapers.[Title of Paper], ExamPapers.Course,

Re: [PHP-DB] Microsoft Access PHP

2002-07-04 Thread George Pitcher
Just a thought. Try putting quotes around the 'True'. George (no expert - not even a novice - yet) - Original Message - From: Daniel J Owen-Mcgee [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 04, 2002 2:29 PM Subject: [PHP-DB] Microsoft Access PHP Hi, I'm gleaning