> I'm using CF 4.0.1 and SQL 7. I've built up a fair sized
> Structure (e.g. up to about 10K) over several data entry pages,
> and want to insert the 30 to 60 rows into my database. So these
> are my options, and I want to do the third one:
>
> 1. CFLOOP through structure in CF, doing insert statements (I
> won't do this: too many db calls from CF).
> 2. Use CF to create a large string, pass that to stored proc,
> parses and
> loop through with inserts. I can do this.
> 3. Create wddx packet, send that to a stored proc somehow.
> This is what I'd like to do.
>
> Any hints, articles, etc on INSERTING xml or Wddx? I know SQL
> can create it, but I'm at a total loss on inserting.
You might want to take a look at a recent SQL Server 2000 presentation by
our own Simon Horwith, which discusses batch inserts/updates using XML. I'm
pretty sure you can do this with SQL Server 7 as well, using an add-on
available from Microsoft. I don't know if you'll be able to use WDDX with
this, though. The presentation is on the Fig Leaf web site; select User
Groups ... CFUG ... Meeting Notes.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
