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
CF-Server
derekwork