I once saw something as bizarre as this (e.g. a write to one datasource
wrote to two datasources). This was a pure CF app and turned out
to be not having setup the ODBC connections properly in CF Admin.
I never understood why it wrote to both datasources though but
setting the ODBC stuff and verifying datasources cleared it up as
I vaguely recall.
Rich
----- Original Message -----
From: Peter Alexandrou <[EMAIL PROTECTED]>
To: Spectra-Talk <[EMAIL PROTECTED]>
Sent: Monday, March 19, 2001 8:45 PM
Subject: Using Multiple Datasources
> Hi guys,
>
> I am having a problem in Spectra 1.5. For content promotion between DEV
> and LIVE versions of our site I have proposed that all new content and
> edits to existing content occur in the following manner. A content item
> will be created in a change control datasource and all modifications and
> reviews are made upon this item while the item in the LIVE datasource
> remains untouched. When a change is approved the object in the edit
> datasource is moved over to the live one. This theoretically works.
>
> The problem I am having is that our application is set to use datasource
> cfasite. The edit handler for generic Content saves all data to the dev
> datasource in the code but the data is actually saving to both live and
> dev datasources. I have confirmed this via SQL on the objects table.
>
> Does anyone have any idea why this is happening as it is baffling me.
>
> Many thanks,
> Peter Alexandrou
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
