Re: CFStoredProc out variable

Hi Eric, thanks for your reply I did what you said but it is saying that queryResult is undefined the code i used was cfstoredproc procedure=addOneToOneChildFolder datasource=portexdb cfprocparam type=in cfsqltype=cf_sql_varchar value=Hello null=no cfprocparam type=in

Re: CFStoredProc out variable

CF returns the value of the OUT variable as a regular variable, just like you created it with cfset for example. Try this: cfstoredproc procedure=addOneToOneChildFolder datasource=portdb cfprocparam type=in cfsqltype=cf_sql_varchar value=#url.OneToOneFolder# null=no cfprocparam type=in

RE: CFStoredProc out variable

Hi, i have the following code to call a stored procedure which is stored in mysql. cfstoredproc procedure=addOneToOneChildFolder datasource=portdb cfprocparam type=in cfsqltype=cf_sql_varchar value=#url.OneToOneFolder# null=no cfprocparam type=in cfsqltype=cf_sql_bigint value=1

Re: CFStoredProc out variable

Thanks Dave your a superstar!!! I changed the value to variable and it worked fine :) Thanks again ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now