Hi folks,
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.
TIA,
Mark
Mark Wimer, Bird Point Count Database
American Bird Conservancy, c/o
USGS-Patuxent Wildlife Research Center
12100 Beech Forest Road, Laurel, MD 20708-4038
Ph: 301-497-5596 Email: [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
