All seems to work fine, I have but one problem: how do you state a "string in a string"? The query I need to execute inputs an XML command to a stored proc, so it looks like<br>resultSet := statement executeQuery: 'OWM2_PARSE('<?xml version="1.0" encoding="UTF-8" ?><OWM2><Query command="list" type="class" id="12" ><Output /></Query></OWM2>')'.<br>
<br>Can't remember what's the equivalent of <br>resultSet := statement executeQuery: 'OWM2_PARSE(/'<?xml
version="1.0" encoding="UTF-8" ?><OWM2><Query
command="list" type="class" id="12" ><Output
/></Query></OWM2>/')'.<br>in smalltalk... <br><br>Very stupid question, I know :(<br>Bčrto<br><br><div class="gmail_quote">2008/6/16 Keith Hodges <<a href="mailto:keith_hodges@yahoo.co.uk">keith_hodges@yahoo.co.uk</a>>:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">Bčrto ëd Sčra wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
A connection for statement is not a problem, since I can pack any number of queries into a single XML statement it's not going to impact on performance ;) I'll try this later this week and let you know if it works.<br>
Thanks<br>
Berto<br>
<br>
</blockquote></div>
Try <a href="http://www.squeaksource.com/MySql" target="_blank">http://www.squeaksource.com/MySql</a> for more recent version of the driver. You don't actually need a new connection for each query, but that is the way that I use it myself.<br>
<br>
There is also some code for using the driver in <a href="http://mc.lukas-renggli.ch/magritteaddons" target="_blank">http://mc.lukas-renggli.ch/magritteaddons</a> package Magritte-RDB<br><font color="#888888">
<br>
Keith<br>
<br>
<br>
<br>
<br>
</font></blockquote></div><br>