At 12:21 PM -0800 10/30/03, Greg Moore wrote:
-------- The following gives the year correctly but gives ALL values
of term -------
"select * from AllClasses where year = " + popMyear.text + " AND
term = " + popMterm.text
Well, you're not putting quotes around the term here.
-------- The following works
-----------------------------------------------------
"select * from AllClasses where year = " + popMyear.text + " AND
term = 'Fall' "
Here, you've correctly put quotes around the term.
Cheers,
- Joe
--
,------------------------------------------------------------------.
| Joseph J. Strout REAL Software, Inc. |
| joe at realsoftware dot com http://www.realsoftware.com |
`------------------------------------------------------------------'
- - -
Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|