database retrieve problem

NavaTux <>
Tue Mar 30 13:02:44 CEST 2010


friend please i have red that,I think it is not related me,kindly i
noticed my problem regarding retrieval of each field from the mysql
data base to use inside the nitrogen  simply,yet to need the fair one
to show the results,

if you wanna know my fuss elaborately mean i am ready to explain
detaily please inform dude

On Mar 29, 5:07 am, Steve Davis <>
wrote:
> 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:
>
> ________________________________________________________________
> erlang-questions (at) erlang.org mailing list.
> Seehttp://www.erlang.org/faq.html
> To unsubscribe; mailto:


More information about the erlang-questions mailing list