custom query erlydb

Ruud

unread,

Apr 7, 2009, 10:04:24 AM4/7/09

to erlyweb

Hi,
Is it possible to do a custom query with erlydb?
Or make a query like
SELECT tag,SUM(weight),channel_id FROM tag GROUP BY channel_id,tag;
regards, Ruud

Buggaboo

unread,

Apr 7, 2009, 2:52:32 PM4/7/09

to erlyweb

See this example:
http://www.google.com/codesearch?q=esql+package%3Ahttp%3A%2F%2Ferlywog\.googlecode\.com&origq=esql&btnG=Search+Trunk

See this previous discussion:
http://markmail.org/message/3pu4nthehzuuamen

See this blog entry:
http://yarivsblog.com/articles/2006/09/16/introducing-erlsql-easy-expression-and-generation-of-sql-statements-in-erlang/

Ruud

unread,

Apr 8, 2009, 7:24:15 AM4/8/09

to erlyweb

Thanx,
But doing a SUM in the SELECT tag,SUM(weight) ... query is not
possible
regards, Ruud

On Apr 7, 8:52 pm, Buggaboo <buggas...@gmail.com> wrote:
> See this example:http://www.google.com/codesearch?q=esql+package%3Ahttp%3A%2F%2Ferlywog\.googlecode\.com&origq=esql&btnG=Search+Trunk
>
> See this previous discussion:http://markmail.org/message/3pu4nthehzuuamen
>

> See this blog entry:http://yarivsblog.com/articles/2006/09/16/introducing-erlsql-easy-exp...

Yariv Sadan

unread,

Apr 9, 2009, 8:36:33 PM4/9/09

to erl...@googlegroups.com

Check out the erlydb_mysql module. It should have the 'q' and 'q2' functions.

Reply all

Reply to author

Forward