Hi all,
Just a quick question - why would one write an Action page with the
following bit of code for a insert select statement
METHOD A:
Insert into TblCustomer (CustomerId, Forename,Surname, CompanyName)
SELECT tmpTblCustomer.CustomerId, tmpTblCustomer.Forename,
tmpTblCustomer.Surname, tmpTblCustomer.CompanyName
FROM tmpTblCustomer
WHERE tmpTblCustomer.CustomerId = #Variables.intNextPersonID#
As opposed to the following:
METHOD B:
INSERT INTO TblCustomer
SELECT tmpTblCustomer.*
FROM tmpTblCustomer
WHERE tmpTblCustomer.CustomerId = #Variables.intNextPersonID#
A) Is there a performance drain using METHOD B in any db as opossed to using
METHOD B ( using access )
B) Does anyone use METHOD A as opposed to METHOD B and Why ???
Thanx in advance for all your help.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
