Esbach, Brandon wrote:
> Hmm the list server messes up formatting :(
> Added a bunch of lines to see if that's better
> <%
>
>
> import groovy.sql.Sql;
>
>
> def sendSQL = Sql.newInstance("jdbc:mysql://localhost/myotherdatabase",
> "username-can-be-root",
> "password-goes-here", "com.mysql.jdbc.Driver")
>
>
> sendSQL.eachRow("select * from mytable") {row ->
> println "${row.sessions_guid}"
> }
> %>
Hi,
Prior to trying to understand last Vincent entry, I am trying to make the
sample code to work here.
I have no problem to get single values by using the firstRow method of the sqll
class as here...
11: <%
12: import groovy.sql.Sql;
13: def sendSQLoo =
Sql.newInstance("jdbc:mysql://mire.environmentalchange.net/epec",
"epec_ReadOnly", "epec_ReadOnly", "com.mysql.jdbc.Driver")
14: row_a = sendSQLoo.firstRow("select code from epec.spot")
15: println "Row: code = ${row_a.code}"
16: %>
But I am not able the get an iteration. I've tried...
19: <%
20: import groovy.sql.Sql;
21: println "This is a sample to access ibdona in *localhost*"
22: def sendSQLibd = Sql.newInstance("jdbc:mysql://localhost/ibdona", "root",
"", "com.mysql.jdbc.Driver")
23: sendSQLibd.eachRow("SELECT * FROM ibdona.library_location l") {row
->println "${row.location}"}
24: %>
and
1: <%
2: import groovy.sql.Sql
3: sql = Sql.newInstance("jdbc:mysql://localhost/ibdona", "root", "",
"com.mysql.jdbc.Driver")
4: sql.eachRow("SELECT * FROM ibdona.library_location l", { println it.location
+ " -- ${it.year} --"} );
5: %>
No error messages. Just a white page in the second script or a page with the
static line printed by line 21 for the first one. I'm guessing the query is
successful and the sql instance is correctly created, but for any reason I am
failing when trying to print the iteration. Please, could you help me with this
issue? Thanks!
Best,
Ricardo
--
Ricardo RodrÃguez
Your XEN ICT Team
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users
