[erlang-questions] Re: database retrieve problem

Hynek Vychodil <>
Sun Mar 28 21:40:59 CEST 2010


When I get one result, I'm used to write [Result] or [Row] just to not
confuse reader. If I know what is there I write
[{Id,Tamil,English,Maths,Science} = Row]. If I want split tuple I
write Values = tuple_to_list(Row). Readability of code is one of
valuable characteristic of code.

On Sun, Mar 28, 2010 at 12:15 PM, NavaTux <> wrote:
> may i know what i need use instead of using [Results] variable,
>
> ()28> {1,45,55,67,89}                 //whole row
> displaying
>
> yes if i use the variable [Results] meant i am getting the full
> row,but i wanna display a field by field for that what i have to
> declare
>
> please explain friend
>
> let me know how to fetch the results from shell to my webpage
>
> On Mar 28, 11:53 pm, Hynek Vychodil <> wrote:
>> There is raised {badrecord,elementbase} exception in
>> wf_render:render/1 function. Just guess, should not event/1 return
>> some record? wf:flash/1 parameter should be some sort of record?
>> Something other expecting record where wf:flash/1 parameter is passed
>> to? I don't know, look at documentation and if it doesn't there, blame
>> author.
>>
>> I'm just curious, why you consistently write [Results] when there one
>> result row will be binded to Results variable?
>>
>>
>>
>> On Sun, Mar 28, 2010 at 10:33 AM, NavaTux <> wrote:
>> > ya..it displayes in shell,when i wanna to display in my web page i
>> > used to give wf:flash([Results]) it throws the error below,
>>
>> > event(continue) ->
>> >        [Name] = wf:q(no_id),
>> >        Message = wf:f("The Result is~p", [Name]),
>> >        ConnString = "DSN=mysqldb",
>> >        {ok, Conn} = odbc:connect(ConnString, []),
>> >        {selected, _Cols, [Results]} = odbc:sql_query(Conn, "SELECT * FROM
>> > marks where id=1"),
>> >        io:format("~p",[Results]),
>> >        wf:flash([Results]),
>> >  ok;
>>
>> > ()15> {1,45,55,67,89}CAUGHT ERROR: error-
>> > {badrecord,elementbase}
>> > [{wf_render,render,1},
>> >  {wf_render,'-render/1-lc$^0/1-0-',1},
>> >  {element_panel,render,2},
>> >  {wf_render,render,1},
>> >  {wf_render,'-render/1-lc$^0/1-0-',1},
>> >  {wf_render,'-render/1-lc$^0/1-0-',1},
>> >  {element_panel,render,2},
>> >  {wf_render,render,1}]
>>
>> > Here let me know what happened?
>>
>> > On Mar 28, 9:58 pm, Hynek Vychodil <> wrote:
>> >> When I look at your error message and code then I easily can guess,
>> >> that badmatch is on row
>>
>> >> [Results] = odbc:sql_query(Conn, "SELECT * FROM marks where id=1")
>>
>> >> so I look at documentation and bingo! It is. I strongly recommend you
>> >> try code in shell and look what code returns when you don't want read
>> >> documentation. You should try it in shell even have read
>> >> documentation. Above row should be
>>
>> >> {selected, _Cols, [Result]} = odbc:sql_query(Conn, "SELECT * FROM
>> >> marks where id=1")
>>
>> >> or
>>
>> >> {selected, _Cols, Results} = odbc:sql_query(Conn, "SELECT * FROM marks
>> >> where id=1")
>>
>> >> On Sun, Mar 28, 2010 at 9:37 AM, NavaTux <> wrote:
>> >> > I wanna to use the query to retrieve some results from the database,so
>> >> > i used these lines
>>
>> >> > event(continue) ->
>> >> >        [Name] = wf:q(no_id),
>> >> >        Message = wf:f("The Result is~p", [Name]),
>> >> >        ConnString = "DSN=mysqldb",
>> >> >        {ok, Conn} = odbc:connect(ConnString, []),
>> >> >        [Results] = odbc:sql_query(Conn, "SELECT * FROM marks where id=1"),
>> >> >        io:format("~p",[Results]),
>> >> >        wf:flash([Results]),
>> >> >  ok;
>> >> > event(_) -> ok.
>>
>> >> > but i am unable to get the output,Here continue is the postback for
>> >> > button,here what goes wrong?
>>
>> >> > I am getting output in my terminal is
>>
>> >> > =INFO REPORT==== 28-Mar-2010::21:56:22 ===
>> >> > ERROR: error
>> >> > {badmatch,{selected,["id","tamil","english","maths","science"],
>> >> >                    [{1,45,55,67,89}]}}
>> >> > [{web_index,event,1},
>> >> >  {wf_handle_postback,run_module_event,2},
>> >> >  {wf_handle_postback,handle_normal_request,3},
>> >> >  {wf_inets,do,3},
>> >> >  {httpd_response,traverse_modules,2},
>> >> >  {httpd_response,generate_and_send_response,1},
>> >> >  {httpd_request_handler,handle_response,1},
>> >> >  {gen_server,handle_msg,5}]
>>
>> >> > id,tamil,english,maths,science are database fields....
>>
>> >> > please help me
>> >> > as well as i wanna know how to flash the output that i retrieved from
>> >> > the database in my webpage..
>>
>> >> > ________________________________________________________________
>> >> > erlang-questions (at) erlang.org mailing list.
>> >> > Seehttp://www.erlang.org/faq.html
>> >> > To unsubscribe; mailto:
>>
>> >> --
>> >> --Hynek (Pichi) Vychodil
>>
>> >> Analyze your data in minutes. Share your insights instantly. Thrill
>> >> your boss.  Be a data hero!
>> >> Try GoodData now for free:www.gooddata.com
>>
>> >> ________________________________________________________________
>> >> erlang-questions (at) erlang.org mailing list.
>> >> Seehttp://www.erlang.org/faq.html
>> >> To unsubscribe; mailto:
>>
>> > ________________________________________________________________
>> > erlang-questions (at) erlang.org mailing list.
>> > Seehttp://www.erlang.org/faq.html
>> > To unsubscribe; mailto:
>>
>> --
>> --Hynek (Pichi) Vychodil
>>
>> Analyze your data in minutes. Share your insights instantly. Thrill
>> your boss.  Be a data hero!
>> Try GoodData now for free:www.gooddata.com
>>
>> ________________________________________________________________
>> erlang-questions (at) erlang.org mailing list.
>> Seehttp://www.erlang.org/faq.html
>> To unsubscribe; mailto:
>
> ________________________________________________________________
> erlang-questions (at) erlang.org mailing list.
> See http://www.erlang.org/faq.html
> To unsubscribe; mailto:
>
>



-- 
--Hynek (Pichi) Vychodil

Analyze your data in minutes. Share your insights instantly. Thrill
your boss.  Be a data hero!
Try GoodData now for free: www.gooddata.com


More information about the erlang-questions mailing list