[ic] sql question...

[Cameron B. Prince]

You might try something like this instead:

		[query
		list=1
		st=db
		sql=|
		select * from area
		|
		]
		[sql-param name]
		[/query]

I am not so sure you will be able to embed the second query using results
from the first. If it doesn't work, you should be able to set a scratch with
the first query that is read by the second though.

Good luck,

Cameron

-----Original Message-----
From: interchange-users-admin@minivend.com
[mailto:interchange-users-admin@minivend.com]On Behalf Of Paul Stearns
Sent: Saturday, November 25, 2000 4:33 PM
To: interchange-users@minivend.com
Subject: [ic] sql question...


I am trying something quite simple and it doesn't work.

What am I doing wrong?

The html;

=====================
[sql list
    select * from area
    ]
[sql_data area name]<br>
[sql list
    select * from cat where cat.sel like '%[sql_data area code]%'
]
[sql_data cat name]<br>
[/sql]
[/sql]
=====================
The results;
=====================
Straight Boxes
[sql list select * from cat where cat.sel like '%1002%' ]
[/sql] Special Assortments
[sql list select * from cat where cat.sel like '%1004%' ]
[/sql] Specials
[sql list select * from cat where cat.sel like '%9%' ]
[/sql] Clubs
[sql list select * from cat where cat.sel like '%1006%' ]
[/sql] Combo Boxes
[sql list select * from cat where cat.sel like '%1003%' ]
[/sql]
======================

I think that I've done everything right, I don't get an error in the
error.log. If I make a syntactical booboo I get an error in error.log.

Paul


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