Thanks Paul and David,
Paul, the updategram sounds about right, although I'll have to read more in
depth. Wish I had SQL 2000. David, I cannot just insert - although I didn't
specify this in my message originally, I need to insert (non-xml) into
multiple fields, and I don't even know which fields ahead of time. This
latter part had me worried until I remembered the dynamic evalulation
functionality with sp_executesql inside a stored proc.
I'll have to experiment with performance on the NOCOUNT thing and having
SQL do a little parsing work.
Thanks again!
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]
> 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
