database retrieve problem
    NavaTux 
    navaneethanit@REDACTED
       
    Sun Mar 28 18:37:02 CEST 2010
    
    
  
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..
    
    
More information about the erlang-questions
mailing list