Thanks Alan,
That small change was the problem.

On Thursday, 8 January 2015 16:07:52 UTC+2, Alan Williamson wrote:
>
>  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