--- In [email protected], "Mic" <chigwel...@...> wrote: > > Hi Tracy, > > I bought the $19 FlexCubed FlexSQL, which uses a SWC and a server-side asp > which I place in wwwroot/website. Talked to them and they do not support > procs .... deadline means having to embed while look for proc solution. They > pass the e.g. select statement to their SWC as a string, and my select > statements are basically the proc contents so pretty long - nightmare without > the indents and lines normally associated with sql formatting :-) > > I grabbed the FlexSQLAdmin google code open source - I cannot get it passed > the SharePoint security - been talking to him but he is not "Sharepoint > aware". > > The more I look at SharePoint and asp.net etc the more I appreciate my > attempt to write this app in Flex and embed into SharePoint page :-) I think > probably MS is positioning Silverlight to code RIAs inside SharePoint?
4GuysFromRolla.com has some ASP classic code on their site which will let you run any sql and will format the resulting recordset as xml. I use it to run against an Access database with stored queries. It shouldn't be any different with stored procedures in sql server. I think you can also use SELECT FOR XML in SQLServer to get XML directly out, but I haven't been able to find any examples of consuming that in your page, so I don't know how to use it. HTH; Amy
