[erlang-questions] odbc and mysql

[Attila Rajmund Nohl]

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 <info@REDACTED>:
> 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 ?
>