> mike,tom,bob,herb and then the function would loop over the names and
> add the quotes and build a new string tor eturn and use in the IN
> clause. Do you forsee problems with that approach?
If you're talking about a CF user-defined function, I don't think that'll
get you anywhere. You can use ListQualify to wrap single quotes around each
list item. The problem is on the SQL side.
If you're talking about an SQL Server function, it might work if that
function returns a recordset. I know that you can write a function that
returns a table, but I'm not familiar enough with SQL Server functions to
know whether that will work for this.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
