[ic] sql question...

[Paul Stearns <pauls@compuace.com>]

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