| View previous topic :: View next topic |
| Author |
Message |
alex_wright
Joined: 05 Feb 2009
Posts: 1
|
 Posted: Thu Feb 05, 2009 11:25 am Post subject: MySQL Based Services |
 |
|
Hi,
I'm new to making web services, and have been through a lot of tutorials on how to make them, but can't find any comprehensive ones about how to return resultsets from databases or anything similar.
I'd like to have a prebuilt SQL query in an operation, with limited parameter inputs, and return the results as an XML tree structure, for example:
| Code: | <result>
<customer>
<name></name>
...
</customer>
...
</result> |
I've got a resultset from the query, and have tied manipulating it in various ways to get output like that, including:
- returning the resultset as it is
- converting the resultset to a string by adding <>'s and returning that
- converting the resultset to a w3c Document and returning that
- converting the resultset to a String[][] array
The manually created string outputs all on one line and is read as one long result. I'm not too sure why returning a Document or resultset doesn't deploy since the add operation wizard lets you search for return types and they're included in the big list of types 
The String[][] has been the most successful, but the tags are only ever returned as:
| Code: | <result>
<item></item>
<item></item>
...
</result> |
Which isn't too helpful because the tags don't mean anything.
If anyone could point me in the right direction with this, it'd be much appreciated!
Thanks in advance,
Alex. |
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum
|
|
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
