In fact the query if put into the cfquery block as is (without cfif) it doesn't run from openBD.
Runs in mysql prompt or HeidiSQL query engine. -nitish 2011/11/10 nitish pandey <[email protected]> > 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_id > > 2011/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 > -- -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
