Thanks for the suggestions. I thought that the dbvarname actually did something. My variables were in a different order in the stored proc... So a quick change in order fixed it. Sometimes its just a monday!
Thanks again, Rob On 8/21/07, Hareni Venkatramanan <[EMAIL PROTECTED]> wrote: > > Hi Rob, > > I tried something like this and it worked fine for me: > > Here is my stored proc in sql 2000 which inserts a datetime value into a > table testdate: > > CREATE procedure updatedate > @startdate datetime > as > begin > insert into testdate values (@startdate); > end > > GO > > > And here is the coldfusion code that I used to execute the stored proc: > > <cfset foo = createDateTime(2000, 1 , 1 , 0, 0, 0)> > > <cfstoredproc procedure="updatedate" datasource="testtrigger" > username="sa" password="admin"> > <cfprocparam type="IN" cfsqltype="cf_sql_date" value=#foo#> > </cfstoredproc> > > > This one worked without any hassles. Are you doing anything different > from this? If yes, can you post the code here? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286664 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
