[ic] sql question
Cameron B. Prince
Tue, 31 Oct 2000 19:48:35 -0600
The code that was replaced and commented out below is compatible with SQL,
but not the SQL Statement Module. So if you configured mysql originally, it
would work. But those who use GDBM's would receive an error and the function
The statement module doesn't support functions like count(*), sum(*), etc.
These function fine with MySQL though.
Your message doesn't indicate whether you use GDBM or MySQL. Your query may
be too complex for SQL Statement if you are using GDBMs. If you are using
MySQL, you might try your query from the MySQL prompt. If you get the proper
results there, you should also be able to get them inside Interchange.
[mailto:firstname.lastname@example.org]On Behalf Of
Sent: Tuesday, October 31, 2000 6:28 PM
Subject: [ic] sql question
I'm getting wrong return values when I use a select statement with a logical
AND. What could be the problem?
INPUT VALUE => make=yamaha,model=250,year=1994
RECEIVED the WRONG OUTPUT = yamaha,different model, and all year of 1991.
sq=select * from table where make = '[value make]' and model = '[value
model]' and year = '[value year]'
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>,
If this query is incompatible with SQL, What about HAVING, ORDER BY, SUM are
Part remove from ship_addresses.html
Removed 10/12/00 - Cameron B. Prince
Incompatible with GDBM and SQL::Statement Module
select count(*) from ship_addresses
where username = '[data session username]'
Interchange-users mailing list