Its a string - just insert it!
Only prob is, if you're just inserting that, searching for things within it will
be slow...
Dave
[EMAIL PROTECTED] wrote:
>
> 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
