Are you *sure* that the same data is being inserted each time? Your database
should be designed to prevent this.
Are you looking at the data directly in Access, or are you retrieving it via
CF?
And whom did you say you work for?
-David
On Monday, August 27, 2001 2:51 PM, Joshua King [SMTP:[EMAIL PROTECTED]]
wrote:
> Building a simple prototype using MS Access (perhaps the problem starts
here),
> into which I'm inserting data.
>
> The basic problem is that each time the page is requested, the exact same
data
> is inserted. I've got "Show Query Information" enabled in the Admin, so I
> can see that the query is correct each time (i.e. the data *there* is
> accurate). However, the data in the INSERT doesn't match the new record in
> the table.
>
> Is it possible that the driver or DSN is caching my data? I'm at a bit of a
> loss here, so any help is appreciated. Please cc: me on responses as I'm on
> digest.
>
> Thanks,
>
> Josh
> [EMAIL PROTECTED]
>
> ***
> Other (perhaps) relevant info:
> -developing and running server on same system
> -Win2000 Pro
> -Access 2000
> -Access Driver v 4.00.5303.01
> -CF 5.0 & IIS
> -Custom Tag handles data insertion
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
