abramadams / dao Goto Github PK

hi @abramadams ,

linq.run() returns absolutely nothing.

I debugged on dao.read() and inserted a dump before the return (dump(LOCAL[arguments.name])) and it returns the query result correctly.

it seems like a problem when the call to the linq.run() function.
Could it be a problem with Lucee 5.3.8.206 version?

thanks,
Ivan

Looks like you've made some adjustments to the develop branch. Would it be ok to clone that branch to get those fixes? Any reason they weren't merged to master?

This seems like a very cool project and was going to try to pop it into my Coldbox application. Any reason not to? I saw your disclaimer, but it seems like for using the basic DAO stuff this will be very useful to allow me to write complex queries in script without all the oddities of ACF script queries.

Thanks!

Linq join syntax separator should be space not comma.
// build the query criteria

    var query = request.dao.from( from="eventLog", joins=,joins=[
{
    type="left",
    table="table1"
    columns="...",
    on="..."                
}, {
    type="left",
    table="table2",
    columns="...",
    on="..."
}]).run();

This throws an error

When using DAO.read() with a return type of "array" and the sql being executed includes columns from joined tables the returned array of structs does not contain all columns in the query. It only includes the Columns from the primary table (the "from" table).

This only happens in Adobe ColdFusion; Lucee does not experience the same issue.