export XML from SQL

August 12, 2006

This is the next thing I need to do for an application I am working on, won’t get to try it until next week but it looks like exactly what I am after, and quite simple! Fingers crossed.

http://www.sqlxml.org/faqs.aspx?faq=29

MozillaActiveX

The Mozilla Active X control worked perfectly as can be seen in the screenshot above, the only problem is that it doesn’t seem to support xml? I opened my wordpress feed in the control and it outputted plain text, not the nested elements as it would if you opened it in firefox for example. This is what I wanted to use it for (xml with a stylesheet) so I think I’ll look for a control that supports this, most likely a Java/Swing combo. Python/ Ruby were close but I have more experience in Java and like using Java Swing GUI components. And having to worry about how the TK or QT frameworks work with each language is proberly not the best way to learn a new language :).

I have been having a play with Ruby and I realling love the language and the pure OO implementation. It is very similar to JADE however I think it has already got more market interest! Especially with the Ruby on Rails framework.

Advertisements

One Response to “export XML from SQL”


  1. […] I managed to try out the stored procedure for exporting the result of an SQL query to XML file that I mentioned in an earlier post. I’m happy to say that it works a treat! I’m quite excited about it and would love to know if there is something similar for mysql now that stored procedures are supported (mysql 5). […]


Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: