[erlang-questions] odbc and mysql

Attila Rajmund Nohl <>
Thu Jun 3 16:45:55 CEST 2010


There's obviously a syntax error in the second example, but probably
it's not the one that you're interested in :-) Could you print the
values of Cols1 and Rows1?

2010/6/3, info <>:
> Hi all,
> Do you see why these lines are correct:
>
> SQL1="select Id_Zone from zones  where ( Id_ref= '10' )",
> {selected,Cols1,Rows1}=odbc:sql_query(Ref,SQL1),
>
> But this one ...
> {selected,["Id_Zone"],[{Idz}]=odbc:sql_query(Ref,SQL1),
> ... returns the following message:
> Exception error: no match of right hand side value
> {selected,["Id_Zone"],[{101}]
>
> Are there restrictions with odbc ? columns syntax ? types of data ?
>


More information about the erlang-questions mailing list