your table really should not be 50 fields in size.... I think a normalisation could be implemented.. before you reach the SQL Server limit on row size.
-----Original Message----- From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl] Sent: 04 November 2002 12:59 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Philip Arnold - ASP wrote: > Saying that, if you're building your systems to work on your hardware, > I'd expect you to know the oddities of the RDMS I would expect that too. But experience tells me not many people know how their RDBMS handles the not everyday functionality. > If you want true 100% compaitibility, then sure, use CFQueryParam Again, compatibility was exactly the point I was making. > but if you want to do 50 small inserts in a row, "in a row"? Do you mean updates of one row of a table or subsequent inserts into a table? > sending those requests as separate CFQuery tags is pretty much insane > - building one big TSQL statement with one hit to the database server > is a much better solution Why would that be insane? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
