>> > DBVarName doesn't sound right either then, because I'm >> > not >> > trying to match anything in the database. Just trying >> > to pass >> > a variable which is declared in the sp. The variable I >> > declare >> > doesn't have to be the same as any column name in the >> > db. >> >> Yes... though that's not what dbvarname was designed to >> match... >> dbvarname was designed to match the name of the stored >> procedure >> parameter.
> Actually, I think you are both saying the same thing, > although "parameter" > is the correct term, not "variable". My interpretation from reading it was that he was thinking dbvarname would take say... <cfprocparam dbvarname="contractid" value="#cid#"> and match that value against a "contractid" column in a table somewhere... so that's why I thought it needed clarification -- though I could certainly have misread it. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207291 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
