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 [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
