One note on this. You CAN use 2 DB's but NOT 2 DATASOURCE.
To do this both DB's must be on the same database server. And one of
the datasource logins must have access to both databases. Change one
of the statement to use 3 part table naming.
"databasename.tableowner.tablename" I have made example changes
below. If they are on different servers and you have distributed
transactions setup you could use 4 part table name and add server name
to the 3 part name. Hope this helps
Daniel D.
<cfquery name="insertcredit" datasource="#variables.search_localB4U#">
INSERT INTO creditcards
(c_name, c_address, comments)
VALUES
( <cfqueryparam cfsqltype="cf_sql_varchar"
value="#memento.NameOnCard#" />,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#memento.address#" />,
<cfqueryparam cfsqltype="cf_sql_varchar" value="Buy
Search Credits" />
)
</cfquery>
<!--- update credit limit for searching of DB's --->
<cfquery name="updateCreditLimit"
datasource="#variables.search_localB4U#">
UPDATE DBNAME.DBO.ABC
SET BN= #creditLimit#,
role_id = 7 WHERE MAIN_ID = #UserID#
</cfquery>
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email
to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev'
in the message of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported
by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
