RE: Stored Proc Help Needed Please

2004-11-04 Thread Adrian Lynch
around this, there might be a way to get the result from one context to the current on but I'm not sure how. Let us know if you figure out a way. Ade -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: 01 November 2004 22:38 To: CF-Talk Subject: Stored Proc Help Needed

Stored Proc Help Needed Please

2004-11-01 Thread Eric Creese
Ok I am buildin on an issue I solved a few weeks back about dynamically generating the table name varible and using it in the FROM clause of an SQL statement. I am now trying to use this method but also set a varible from the select statement. I keep getting an error telling me I have to