You can also do an insert based on another table
INSERT INTO tableA (value1,value2)
SELECT <cfqueryparam value="#form.value#">,value2
FROM tableB
Jason Cronk
[EMAIL PROTECTED]
[EMAIL PROTECTED]
on.com To: [email protected]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: [CFCDev] gateway
CFCs [spam]
one.org
07/14/2005 01:00
PM
Please respond to
CFCDev
How else can you do "bulk" insert/updates without doing a loop over a
SQL Insert/Update statement?
Tom
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Nando
Sent: Thursday, July 14, 2005 12:29 AM
To: [email protected]
Subject: RE: [CFCDev] gateway CFCs
>I think the problem we might be encountering is trying to map
everything we
do to a defined Pattern.
Hmmm ... you know, if i had an app that did a lot of bulk updating and
within the architecture, the DB handling object seemed like it just
didn't
fit in as either a DAO or a Gateway, i'd be willing to try making it an
object in it's own right. Gridway, Grateway, GAO, an MDAO - at least i
could
try it and see if it fell into place nicely.
It's My App - TM :)
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of
the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
CFCDev is supported by New Atlanta, makers of BlueDragon
http://www.newatlanta.com/products/bluedragon/index.cfm
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of
the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
CFCDev is supported by New Atlanta, makers of BlueDragon
http://www.newatlanta.com/products/bluedragon/index.cfm
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of the
email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
CFCDev is supported by New Atlanta, makers of BlueDragon
http://www.newatlanta.com/products/bluedragon/index.cfm
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
