Fellow Listers!
All the talk about @@identity encouraged me to ask this question:
Say I:
UPDATE Table2
SET City = 'Oakland'
WHERE ID IN
(SELECT ID FROM MyTable1 WHERE SpecialID = 3)
This is done all within SQL7, and
SELECT ID FROM MyTable1 WHERE SpecialID = 3
is a comma-delimited list of IDs.
How would I do the case where I have Table3
with one column, and I wanted to INSERT the
IDs in it from:
SELECT ID FROM MyTable1 WHERE SpecialID=3
one ID per row, all within SQL7 (no CFAS)?
best, paul
==============================
N: Paul Smith, Web/Database Droid
A: SupportNet, Inc, 3871 Piedmont Ave, Oakland, CA 94611
(There, there, there; there's, there, there....)
P: (510) 763-2358 _o
C: (510) 205-6755 _\<,_
F: (510) 763-2370 (_)/(_)
E: [EMAIL PROTECTED]
W: http://www.support.net
"The sun, with all those planets revolving around it and
dependent on it, can still ripen a bunch of grapes as if
it had nothing else to do." --Galileo
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists