On Fri, Jul 12, 2002 at 04:37:32PM -0400, Shane Landrum wrote:
I'm writing some DTML to create a SQL query which uses the IN keyword. I need to select a set of records with a particular set of record IDs, like so:
SELECT * FROM tablename WHERE id IN (42,27,83);
If this particular snippet doesn't *have* to be DTML, try the following: ## Script (Python) "foosql" ##bind container=container ##bind context=context ##bind namespace= ##bind script=script ##bind subpath=traverse_subpath ##parameters=idlist ##title= ## return 'SELECT * FROM tablename WHERE id IN (%s)' % str(idlist) If passed a string argument of '42,27,83' (without quotes if you use the test tab), it returns: SELECT * FROM tablename WHERE id IN (42,27,83) If you want to pass in the parentheses in the arguments, just remove them from the return line in the script. -- Mike Renfro / R&D Engineer, Center for Manufacturing Research, 931 372-3601 / Tennessee Technological University -- renfro@tntech.edu