Erlang/OTP Forums

Author Message

<  Erlyweb mailing list  ~  Error with Postgres Driver

Guest
Posted: Fri Sep 07, 2007 1:15 am Reply with quote
Guest
Trying out the Postgres support in 0.6.2 and am getting this dump
when I try to exercise list/1

ERROR erlang code crashed:
File: appmod:0
Reason: {function_clause,
[{lists,
foldl,
[#Fun,
[],
{sql_error,
"42601",
"Rbase_yyparse L5868 Fgram.y HUse separate
LIMIT and OFFSET clauses.
MLIMIT #,# syntax is not supported"}]},
{erlydb_psql,get_select_result,2},
{erlydb_base,select,3},
{erlyweb_controller,list,3},
{erlyweb,ewc,2},
{erlyweb,handle_request,6},
{yaws_server,deliver_dyn_part,8},
{yaws_server,aloop,3}]}
Req: {http_request,'GET',{abs_path,"/account_status/list/1"},{1,1}}

This is with Postgres 8.2.4 and Erlyweb 0.6.2 on OS X.

--Kevin

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "erlyweb" group.
To post to this group, send email to erlyweb@googlegroups.com
To unsubscribe from this group, send email to erlyweb-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/erlyweb?hl=en
-~----------~----~----~----~------~----~------~--~---

Post recived from mailinglist
Guest
Posted: Fri Sep 07, 2007 1:17 am Reply with quote
Guest
hi kevin,
For the app to work correctly I had to modify line 309 of the the erlyweb-0.6/src/erlsql/erlsql.erl file.
by :
[<<" LIMIT ">>;, encode(Num),<<;" OFFSET ">>; , encode(Offset)];


This is pretty rough may come up with something cleaner.
Eric
Le 7 sept. 07
Guest
Posted: Fri Sep 07, 2007 12:50 pm Reply with quote
Guest
Thanks for the pointer! I'm up and running.

--Kevin
On Sep 6, 2007, at 9:17 PM, Eric Cestari wrote:

> hi kevin,
>
> For the app to work correctly I had to modify line 309 of the the
> erlyweb-0.6/src/erlsql/erlsql.erl file.
> by :
> [<<" LIMIT ">>;, encode(Num),<<;" OFFSET ">>; , encode(Offset)];
>
> This is pretty rough may come up with something cleaner.
> Eric
> Le 7 sept. 07

Display posts from previous:  

All times are GMT
Page 1 of 1
This forum is locked: you cannot post, reply to, or edit topics.

Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum