> From: [EMAIL PROTECTED] > Perhaps I'm approaching this from the wrong angle. Here's my need: I need > to send any number of single field values to SQL Server so that several > queries can act upon those values. I was originally thinking a temp table > but if there's a way I could pass a list of values to a stored procedure, > that'd suffice. Generally, I have queries that use the list of values passed > like so: > > select * > from MySQLTable a1 > inner join SomeOtherRelatedTables b1 > on a1.key = b1.key > where a1.cKeyField in (list of values passed from client app) > > Is there a way to pass this list of values and have it easily usable inside > an SQL statement as opposed to using temp tables like I tried initially? The > problem, to repeat, is that multiple users might kick off the process with > different criteria, so they can't use the same temp tables at the same time.
Are you mixing MySQL & SQL Server in this request? Or are you just getting your list of values from SQL Server back to VFP, and then passing from VFP to MySQL? _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
