OT: what is the max number of tables SQl 7.0 can handle?
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 [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
