"Phillip B. Holmes" wrote: > > Yes. > > Here it is: > > <cfquery datasource="yourdb" name="queryname"> > EXEC sp_yoursp > > Put your variables here that you pass to your sp. > > </cfquery>
Thanks Phillip. That method permits me to build up stored procs, and store them in a variable until I am ready to execute them. I don't guess I get return codes, in/out params, and bind vars, but for this particular sp, it's ok. Does anyone know why Macromedia hasn't implemented a pair of functions that would allow you to write tags to a memory datastore and read them back as cfinclude reads from a file? Would the CFX API permit me to write such functions? Please forgive my ignorance, this is my second week working with CF. JT ________________________________________ James Thornton, http://jamesthornton.com ------------------------------------------------------------------------- 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
