A view cannot have parameters. You need to make a stored procedure for that. If for some reason you can't, you can use a UDF and pass in a value to that, but that is not the correct usage for a UDF.
David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: KNOWLTON, JUSTIN J (SWBT) Good Morning Everyone, I need to see if it is possible to pass a variable from a CF page to a server through a SQL statement that can then be used in a "Where" statment in a view. Does anyone know if this can be done and how? Thanks, Justin Knowlton ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
