I've never had a problem with <cfquery> but I have noticed that if I
<cflocation> directly after I drop a <cfcookie>, it doesnt set the
cookie.
Jon
Ken Wilson wrote:
>
> I'm getting a few random reports of data loss on an Intranet site and need
> to get some input on things I might investigate. I'm unable to replicate the
> problem myself and users that report problems can't replicate it for me when
> I'm on-site with them.
>
> Here's the setup:
>
> NT4 Server SP5
> CF Server Pro v4.5.1
> Access 2000 (yes I know, problem #1)
> Potential browsers include Netscape v4.6 and IE v5.01
>
> The app is very lightly used averaging 30-40 unique users per day and rarely
> more than 4 active sessions at any given time...max I've ever seen is 7.
>
> The page in question contains a few text fields, various radio button fields
> and a dozen or so TEXTAREA fields for free-form comments. When users submit
> the page it updates the database and does a CFLOCATION to return them to
> their homepage. The few problem reports I've gotten have all been
> specifically about the Comment fields not containing any data when they
> retrieve the form to continue editing it.
>
> A couple of things I'm wondering are:
>
> What, if any, size limit exists within the MS ODBC drivers for Access. I
> thought I recalled there being a limit on the amount of data that can be
> passed through the ODBC driver but my own tests have shown no total loss of
> data when submitting large amounts of text (65,000+). In that case I just
> see truncated data in the TEXTAREA fields but not a complete loss of data.
>
> Having scrtached my head all afternoon I'm now wondering if there's a
> problem with doing a CFQUERY to Update the database and immediately doing a
> CFLOCATION? Any chance that the Update is simply not being processed? In
> particular, if an Update were queued due to database connection limits set
> in CF Admin would CF Server continue processing the page and execute the
> CFLOCATION, dropping the Update all together?
>
> Any other ideas on things I might investigate? All suggestions are
> appreciated.
>
> Thanks,
>
> Ken
>
> ------------------------------------------------------------------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Jon Boehnker
[EMAIL PROTECTED]
-><-
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.