Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-08 : 07:56:12
|
| vijay kumar writes "If you dont mind could you pls give me a suggestion to solve the problem.In my web portal Im allowing the user to view the information in Excel using HTML object tag. Once user changes the data again the modified data is being sent back to the server in the form of XML and Im storing the data in an XML file inthe server and Im loading this xmlfile into DOM and reading respective nodes to get information and calling various Sql server stored procedures to update respective tables. This is wats happening currently in my portal.Now Im in a plan to do as soon as the modified information is saved in an xmlfile then I would like to write one stored procedure that would open the xml file that is passed as one of the parameter and that stored procuedre would takethe xml file name and loads into xml dom, I wud try to get total XML data as string using .XML method of DOM and the entire data would be passed as parameter to SP_XMLPrepareddocument which inturn helps me and to access all information in the form of rows and columns rather than retrieving value by travelling respective node.Im almost succeeded to achive this. The main problem starts when I try to execute .xml property of DOM object using SO_OAMethod and assigning the total xml data toa varaible and in turn this varaible being used to in SP_XMLPrepareddocument.bcos the xml file size is aroung 200KB and contains 200,000 + characters so Im unable to store the entire info in a variable.Think now you undersand the my problem.Hope I get valuable suggestions from you.Thanks in advance." |
|
|
|
|
|
Data type conversion problem while reading output value