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
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],
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,
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