try query="#sqlview#"

another one of those areas that other well-known engines are not terribly consistent with themselves. Drives me mad.

On 08/01/2015 01:44, Gareth La Grange wrote:
Hi

I have Cfspreadsheet working correctly in Adobe CF 9, when moving the code for testing to openbd is fails though.

The error is as follows:
QUERY attribute must be an query object


<cfquery name="SQLVIEW" datasource="GEF2">
SELECT * FROM SQLVIEW
</cfquery>


<cfspreadsheet
        action = "write"
        filename="/tmp/#TheFile#-#DateToday#.xlsx"
*      query="SQLVIEW"*
        sheetname = "Data"
        overwrite="true">


Any ideas what I need to change to get this to work on openbd?


--
--
online documentation: http://openbd.org/manual/
http://groups.google.com/group/openbd?hl=en

--- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to