select() function, query
28 views (last 30 days)
Show older comments
Hello together,
for the following select query statement I get an error:
"select Algo_ID from egs_pn_algos where Algo_Version like '%1.0%' and Algo_hyperparameter like '%th:32;min_p_s:0.12;w_s:250%'"
The error is:
Error using database.jdbc.connection/select (line 78)
Invalid SQL statement. Expected a single SQL SELECT statement.
Error in DatabaseHandler/select_query (line 162)
data = select(obj.connection, query_str);
This query worked for me in sql developer.
What am I doing wrong
5 Comments
Ville Saunajoki
on 7 Feb 2023
I encountered the same error message. I had sections of query commented with /* ... */ and by removing those it worked again.
Thanks for the tips.
Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!