Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <cfscript>
- hql1 = "
- SELECT NEW MAP(
- h.id AS ID,
- m.id AS MUSICID,
- m.name AS NAME,
- (
- SELECT COUNT( hyundai )
- from hyundai h
- WHERE exists (
- SELECT h.id AS id, m.id AS musicID, m.name AS name
- FROM hyundai h
- JOIN h.music m
- )
- ) AS total
- )
- FROM hyundai h
- JOIN h.music m
- ";
- results = ormExecuteQuery(hql1,{},{ maxResults = 4, offset = 0 });
- writeDump(results);
- </cfscript>
Add Comment
Please, Sign In to add comment