Well - I figured out how to accomplish the same thing in 3 lines of code instead of the 1
<cfset ss = SpreadsheetNew()> <cfset SpreadsheetaddRows(ss,"#MedClaimDat#",2,1)> <cfset SpreadsheetWrite (ss , "C:\webroot\SandBox\test.xls",1)/> On May 13, 2:17 pm, Joe Genshlea <[email protected]> wrote: > Yup...I've tried passing the query object in just about every syntax I > know how > > When I pass it as you suggest OpenBD throws: > The page you were executing caused an internal BlueDragon server error > > I've also tried: > > 1) <cfspreadsheet query=#MedClaimDat# action="WRITE" overwrite="true" > filename="C:\openbd\tomcat\webapps\ROOT\test.xlsx" /> > 2) <cfspreadsheet query="#MedClaimDat#" action="WRITE" > overwrite="true" filename="C:\openbd\tomcat\webapps\ROOT\test.xlsx" /> > 3) <cfspreadsheet query="MedClaimDat" action="WRITE" overwrite="true" > filename="C:\openbd\tomcat\webapps\ROOT\test.xlsx" /> > 4) <cfspreadsheet query=MedClaimDat action="WRITE" overwrite="true" > filename="C:\openbd\tomcat\webapps\ROOT\test.xlsx" /> > > #3 Gives me the query attribute problem and the other 3 give me the > internal BlueDragon server error > > On May 13, 1:42 pm, "Peter J. Farrell" <[email protected]> wrote: > > > > > > > > > Joe Genshlea said the following on 05/13/2011 03:27 PM:> <cfspreadsheet > > query="MedClaimDat" action="WRITE" overwrite="true" > > > filename="C:\openbd\tomcat\webapps\ROOT\test.xlsx" /> > > > Have you tried passing in the query instead of just the query? > > > <cfspreadsheet query="#MedClaimDat#" action="WRITE" overwrite="true" > > filename="C:\openbd\tomcat\webapps\ROOT\test.xlsx" /> > > > -- > > Peter J. Farrell > > [email protected] > > [email protected]http://blog.maestropublishing.com > > Identi.ca / Twitter: @maestrofjp -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
