> 1. CFLOOP through structure in CF, doing insert statements (I won't do
> this: too many db calls from CF).
you could loop thru inside just one cfquery remembering to wrap
the whole mess in SET NOCOUNT ON/OFF block.
> 2. Use CF to create a large string, pass that to stored proc, parses and
> loop through with inserts. I can do this.
sql is not too good at this.
> 3. Create wddx packet, send that to a stored proc somehow. This is what
I'd
> like to do.
you're a bit ahead of your time w/this. what you're after is i guess
"updategrams" that kinda work (i know of no production sites
doing this) in sql server 2000. in any case, see this article:
http://msdn.microsoft.com/library/periodic/period00/TheXMLFiles.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
