database retrieve problem

Steve Davis <>
Mon Mar 29 02:07:49 CEST 2010


file:///C:/Erlang-R13B-04/doc/getting_started/seq_prog.html#id2252713

On Mar 28, 3:25 pm, NavaTux <> wrote:
> here [Result]=[{23,_,_,56}].   // grouply displaying a full row by the
> variable
>
> how to seperate each field by a seperate variable that need to be
> printed in shell
>
> On Mar 29, 12:23 am, Ryan Huffman <> wrote:
>
>
>
>
>
> > As far as I can tell, wf:flash() is expecting a valid nitrogen element, but
> > it isn't finding one.  You need to convert the Results tuple into a string
> > before passing it into wf:flash().
>
> > Ryan
>
> > 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.
> > > 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:


More information about the erlang-questions mailing list