[ic] sql question

[MhsapoA@netscape.net]

Hello y'all,

I'm getting wrong return values when I use a select statement with a logical 
AND. What could be the problem?

Table contains:
fields 
make=yamaha,honda,suzuki
model=yamaha->250,350,550
year=250->1991,1992,1993,1994 etc

INPUT VALUE => make=yamaha,model=250,year=1994

RECEIVED the WRONG OUTPUT = yamaha,different model, and all year of 1991.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[loop search="
 ra=yes
 st=db
 sq=select * from table where make = '[value make]' and model = '[value 
model]' and year = '[value year]'
 ml=1000
"]
                make=<font size=2 color=red>[loop-data table make]</font>,
                model=<font size=2 color=red>[loop-data table model]</font>,
                year=<font size=2 color=red>[loop-data table year]</font>,
[/loop]
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

If this query is incompatible with SQL, What about HAVING, ORDER BY, SUM are 
also incompatible?
Part remove from ship_addresses.html
+++++++++++++++++++++++++++++++++++++++++++++++
Removed 10/12/00 - Cameron B. Prince
Incompatible with GDBM and SQL::Statement Module
[query
        list=1
        st=db
        sql=|
                select count(*) from ship_addresses
                where username = '[data session username]'
        |
]
                        [seti addresses][sql-code][/seti]
[/query]
++++++++++++++++++++++++++++++++++++

Thanks,
Mauricio

_______________________________________________
Interchange-users mailing list
Interchange-users@www.minivend.com
http://www.minivend.com/mailman/listinfo/interchange-users