SQL query

[peter hicks <peter@libation.com>]

Hello list,

The following minivend tag generates a number that I want to use as a
product code in a sql query:

[data base="club" field="product_id" key="er1"]

But when I use this tag in the following query, it generates an error
that says  Bad SQL query selector: 'type=list' for products:

[sql type=list
    query="select * from products where code like '[data base="club"
field="product_id" key="er1"]'
               "]
    [sql-param code] [sql-param title]<BR>
[/sql]


What is the proper way to accomplish this? Thank you in advance!