> Im trying to change a query value using QuerySetCell, it appears to be > working (no error) but when I CFOUTPUT I dont see the new > result...Initially I was using it in the same CFOUTPUT block that my > test used but then thought it needs to be in a different CFOUTPUT > block prior, tried that didnt work. > Turned CACHEDWITHIN off still nothing. This is basically > what I am doing. > > <cfoutput query=myquery> > <cfif trim(myCol) IS ""> > <QuerySetCell(myquery, "myCol", "0" currentrow)> > </cfif> > </cfoutput> > > The QuerySetCell get processed but the "0" does not get set. > Any ideas on how to properly use this?
OK, PLEASE tell me that you haven't got "currentrow" in there without a comma, if so, then that's your problem Also, why has it got < and > around it? Since it's a set command, it should be <cfset QuerySetCell(myquery, "myCol", "0", currentrow)> Anything with just < and > around it, but not <cf will be sent to the browser... Try that, see how it goes Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 F: +44 (0)20 8686 7911 An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** > -----Original Message----- > From: Adrian Cesana [mailto:[EMAIL PROTECTED]] > Sent: 14 February 2002 17:54 > To: CF-Talk > Subject: QuerySetCell > > > > Thanks,Adrian > > > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists