Re: Compound "Where"

[GAmoore at aol dot com]

> MY APOLOGIES BUT I HAVE TRIED TO SEND THIS MESSAGE 5 TIMES IN THE PAST TWO HOURS USING EUDORA AND IT KEEPS GIVING EMAIL ERRORS - SO I WILL SEND IT THROUGH AOL.


> >"select * from AllClasses where year = " + popMyear.text  + " AND
> >term = " +  popMterm.text
>
> Well, you're not putting quotes around the term here.


Thanks Joe! That fixed it. The reason I didn't do that was that it worked for the other term (popMyear.text) without quotes even though both are stored as strings (varchars) :

   TableFs = TableFs + "Year          varchar, "          
   TableFs = TableFs + "Term         varchar, "