Okay got the query here with cfcatch.sql too (it's the same thing):
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_id2011/11/10 nitish pandey <[email protected]> > 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 > -- -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
