> 1. CFLOOP through structure in CF, doing insert statements (I won't do
> this: too many db calls from CF).
OK, so why not build a string with all of the Insert statements, and then
run the one query - SQL server won't even blink unless it's about 1000
inserts - just remember to separate the SQL commands with a ;
> 2. Use CF to create a large string, pass that to stored proc, parses and
> loop through with inserts. I can do this.
You could do - it'll mean a lot of logic in the Stored Proc, but as long as
you trust your code, then go for it <g>
> 3. Create wddx packet, send that to a stored proc somehow. This
> is what I'd like to do.
If you're sending one packet to a Stored Proc, then it's easy, it's the work
inside the proc that'll be the hard stuff!
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
