hi,
Need help here.
<cfquery datasource="#Application.datasource#" name="polist" >
select * from spofs_po_sku, spofs_po, spofs_vendor where
spofs_po_sku.po_id = spofs_po.id and spofs_vendor.id = spofs_po.vendor_id
<cfif isdefined("arguments.date_from")> and po_date >= {d
'#arguments.date_from#'} and po_date <= {d '#arguments.date_to#'} </cfif>
order by po_id
</cfquery>
Gives General SQL error.
The query (copy pasted because i think we don't grab the SQL into cfcatch
in OBD) into the <cfcatch> block is
select * from spofs_po_sku, spofs_po, spofs_vendor where spofs_po_sku.po_id
= spofs_po.id and spofs_vendor.id = spofs_po.vendor_id and po_date >= {d
'2000/9/20'} and po_date <= {d '2020/9/9'} order by po_id
And it runs!
Thanks,
Nitish
2011/11/10 Alan Williamson (aw2.0 cloud experts) <[email protected]>
> ORM is missing from OpenBD too though and there are no plans to integrate
> either.
>
> Which is also now true of Flash Remoting and Flex access in light of the
> recent news from Adobe.
>
> As for New Atlanta ... I can't speak to their release schedule or updates.
> Drop them an email and ask.
>
>
> nitish pandey wrote:
>
>> My team turned it down because ORM was missing :(
>>
>
> --
> official tag/function reference: http://openbd.org/manual/
> mailing list -
> http://groups.google.com/**group/openbd?hl=en<http://groups.google.com/group/openbd?hl=en>
>
--
-Nitish
"Faith is a free Option"
http://www.forcesofindia.com/profiles/np
--
official tag/function reference: http://openbd.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
