Hello Daniel, Try to use a query line like below: WHERE (((ExamPapers.School)=\"Colour and Imaging Institute\") AND ((ExamPapers.[Add to Webpage])=True)); And let us know it it will work
Thursday, July 4, 2002, 5:21:50 PM, you wrote: DJOM> Hi, DJOM> 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, DJOM> SELECT ExamPapers.EPaperID, ExamPapers.EPapersText, ExamPapers.[Title of Paper], ExamPapers.Course, ExamPapers.School, ExamPapers.Year, ExamPapers.[Jan/Summer], ExamPapers.[Module Code], DJOM> ExamPapers.Stage, ExamPapers.[Storage Location], ExamPapers.[Add to Webpage] DJOM> FROM ExamPapers DJOM> WHERE (((ExamPapers.School)="Colour and Imaging Institute") AND ((ExamPapers.[Add to Webpage])=True)); DJOM> I want to pull records from 1 table (ExamPapers). DJOM> The WHERE line is causing problems i.e if I remove it, my php pages actually show. Can anyone see what I'm doing wrong? DJOM> Thanks, DJOM> Daniel Owen-McGee -- Best regards, Latex mailto:[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
