hello,
Please i want to display the result of a select SQL query using katalon studio
hello,
Please i want to display the result of a select SQL query using katalon studio
i have successfully connected to my sql server, but i can’t see the results of my query executed in the console
i want to see the result
so, switch to the console tab. it is named ‘Console’
in the console , i get only “true” not the database records !!
my script;
Sql sql = Sql.newInstance(dbConnString, dbUsername, dbPassword, dbDriver) // already defined values
String queryResult = sql.execute(‘SELECT * FROM Users’)
System.out.println(queryResult);
so.
this is the value your query method returns. what else did you want from it?
you can do
queryResult = 'whatever i like to print because i don't like what the query say'
before the print.
problem solved