I believe it is version 2.6 -----Original Message----- From: Kwang Suh [mailto:ksuh@;shaw.ca] Sent: Friday, October 18, 2002 3:04 PM To: CF-Talk Subject: RE: cfstoredproc behavior
Do you know what version of MDAC is on the server? > -----Original Message----- > From: Andy Clary [mailto:aclary@;teleplanwireless.com] > Sent: Friday, October 18, 2002 2:08 PM > To: CF-Talk > Subject: RE: cfstoredproc behavior > > > Isaac, > Thanks for the info, and to the previous poster - the > CF_SQL_TIMESTAMP date > type didn't help any. > > The parameters aren't in the same order as in the stored procedure, but is > there any way to get around this "feature". That sounds like a severe > limitation of the tag. I'd rather not have to put the parameters > in order, > that is what the dbvarname attribute is for. Does this happen > all the time > or is there a way to reproduce this behavior? > > Otherwise, I'll just stick to the cfquery implementation. > > Andy > > -----Original Message----- > From: S. Isaac Dealey [mailto:info@;turnkey.to] > Sent: Friday, October 18, 2002 11:42 AM > To: CF-Talk > Subject: Re: cfstoredproc behavior > > > My only real suggestion here is to make sure that the cfprocparam tags in > your output are in _exactly_ the same order as they are declared in your > stored procedure declaration. I realize that it shouldn't matter, since > they're named with the dbvarname attribute, however, there's an > undocumented > "feature" in cfstoredproc/cfprocparam which causes it to completely ignore > the parameter names. This could especially be an issue with your > <cfoutput> > at the end of your <cfstoredproc> call if there are any > parameters missing, > or if they aren't in exactly the same order. <!--- I've dealt > with this hell > a lot recently. ---> > > > hth > > S. Isaac Dealey > Certified Advanced ColdFusion 5 Developer > > www.turnkey.to > 954-776-0046 > > > I have a dynamic query that I was trying to use the <cfstoredproc> tag > > with, > > but all I kept getting was the generic "Unknown data access" > error. So I > > re-wrote it with <cfquery> and it works fine, but I can't see any > > difference > > in the two. Can anyone here see why the <cfstoredproc> version wouldn't > > work? > > > <cfstoredproc> version (unknown data access error): > > > <cfstoredproc procedure="sp_web_cf_softrevs_insert_update" > > datasource="#request.app_vars.warranty_dsn#"> > > <cfprocparam type="In" dbvarname="@row_id" > > cfsqltype="CF_SQL_INTEGER" value="#form.row_id#"/> > > <cfprocparam type="In" dbvarname="@mfg" cfsqltype="CF_SQL_VARCHAR" > > value="#form.mfg#"/> > > <cfprocparam type="In" dbvarname="@tech_type" > > cfsqltype="CF_SQL_VARCHAR" value="#form.tech_type#"/> > > <cfprocparam type="In" dbvarname="@begdate" cfsqltype="CF_SQL_DATE" > > value="#form.begdate#"/> > > <cfprocparam type="In" dbvarname="@enddate" cfsqltype="CF_SQL_DATE" > > value="#form.enddate#"/> > > <cfprocparam type="In" dbvarname="@notes" cfsqltype="CF_SQL_VARCHAR" > > value="#form.notes#"/> > > <cfoutput query="qColumns"> > > <cfprocparam > > type="In" > > dbvarname="@#col_sql_name#" > > cfsqltype="#CFSQLType(col_type)#" > > value="#StructFind(form, col_sql_name)#" > > maxlength="#col_length#" > > /> > > </cfoutput> > > </cfstoredproc> > > > > <cfquery> version (works): > > > <cfquery name="qSoftrevInsertUpdate" > > datasource="#request.app_vars.warranty_dsn#"> > > sp_web_cf_softrevs_insert_update > > @row_id = <cfqueryparam cfsqltype="CF_SQL_INTEGER" > > value="#form.row_id#"/>, > > @mfg = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" > > value="#form.mfg#"/>, > > @tech_type = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" > > value="#form.tech_type#"/>, > > @begdate = <cfqueryparam cfsqltype="CF_SQL_DATE" > > value="#form.begdate#"/>, > > @enddate = <cfqueryparam cfsqltype="CF_SQL_DATE" > > value="#form.enddate#"/>, > > @notes = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" > > value="#form.notes#"/>, > > <cfloop query="qColumns"> > > <cfoutput>@#col_sql_name#=</cfoutput> > > <cfqueryparam > > cfsqltype="#CFSQLType(col_type)#" > > maxlength="#col_length#" > > value="#StructFind(form, col_sql_name)#" > > /> > > <cfif CompareNoCase(qColumns.CurrentRow, > > qColumns.RecordCount)>,</cfif> > > </cfloop> > > </cfquery> > > > The qColumns query contains a list of dynamic columns that appear or > > dissapear on the form based on mfg. CFSQLType is a udf I wrote that > > returns > > the cold fusion cfsqltype given a SQL Server data type. > > > This is running on Win2k, CF5, SQL Server 2000 with all of the latest > > patches. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm