At 04:55 PM 29/12/00 -0800, you wrote: >My subject tag is probably not all that clear. I am passing the whole form >collection through a custom tag to a stored procedure. I pass the form >collection by > <CF_st_trials_insert ATTRIBUTECOLLECTION="#form#"> > >Well, I don't seem to be having a problem with that. It is when I call the >strored procedure and execute it with > > <cfprocparam type="in" cfsqltype=cf_sql_varchar >value="#Attributes.PROT_NO#" dbvarname="@PROT_NO"> > > <cfprocparam type="in" cfsqltype=cf_sql_varchar >value="#Attributes.ELIGIBILITY#" dbvarname="@ELIGIBILITY"> > // this is just an exerpt from the whole code but enough to give you an >example > >What happens is that I do perform the insert without any errors but the >fields get shifted by one in the table. > >For instance when I look at the table the address date is gone and the >address2 field is in the address1 field, the city in the address2, etc. > >Has anyone seen this before? I know a couple ways to fix it but I was >wondering if this has been discussed before. > >Thanks in advance! > >Derek Hamilton > > > ~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. ------------------------------------------------------------------------------ To unsubscribe, send a message to cf-server-request@houseoffusion.com with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com