Recent content by DilipKS

I agree when you display it , it doesnt show "\" but when I try to update into DB using below its giving error Original Msg contains string which has "\" wherever double quotes are there . - string strCmdText = "UPDATE system_exceptions SET OriginalMessage = '" + strOriginalMsg + "' WHERE...

I agree when you display it , it doesnt show "\" but when I try to update into DB using below its giving error Original Msg contains string which has "\" wherever double quotes are there . - string strCmdText = "UPDATE system_exceptions SET OriginalMessage = '" + strOriginalMsg + "' WHERE...

Got it worked .. UPDATE dbo.SystemExceptions SET OriginalMessage = '<Execution><Account>BZ</Account><SecurityID IDSource="RIC">OML.L</SecurityID></Execution>' WHERE ExcpMsgID=83

UPDATE dbo.SystemExceptions SET OriginalMessage = "<Execution><Account>BZ</Account><SecurityID IDSource="RIC">OML.L</SecurityID></Execution>" WHERE ExcpMsgID=83 how should I make it work ?

am still struggling....se the exact thing which i want.... http://www.tek-tips.com/viewthread.cfm?SQID=821855&SPID=732&page=1

Hi I got really one frustrating problem and am struggling with it. I got an XML , I just want to read it in a String and need to insert in Database. But the problem is I tried all ways but whenever I read XML into a String , I get \ inserted before every " . e.g. whereever attrib values r...

whats ASA 6.0 ? I tried ur example but it was not working . ??

1) I have a XML msg in a field called OrigMsg in a table in Sybase DB. The xml MSg is a continuous string with XML tags. 2) Reading this field from DB and writing it into an XML i.e. StreamWriter sw = new StreamWriter("C:\\Temp\\Test.xml", false ); sw.Write(strOriginalMsg);sw.Close(); where the...

>>>> Therefore is you wanted to replace the \ there is no need as it is an escape character anyway. I need to replace it because am not printing it or manipulating it..I need to insert this string to Database, its actually a big XML, just for an example i used that string. If I insert this to...

Hi Guys.. ya its limitation that we cant use text or image datatype as parameter in Sybase Stored procedure. So I have dropped the idea of using stored procedure, and using directly "Update" Query SQL . Thnks for ur replys. Cheers Dil

Hi Rob Thnks for reply I have tried this already ..but its not working . I debugged it and can see the output ..string it still same. string r10 = t10.Replace("\\", ""); Have u run this code ?

Hi string t10 = "xftag Source=\"L\">500671"; I want to remove "\" from above string and resultant string shld be "xftag Source="L">500671" I have tried many ways but I am not getting the desired output . One of the ways I tried , pls see below string t10 = "xftag Source=\"L\">500671"...

Hi string t10 = "xftag Source=\"L\">500671"; I want to remove "\" from above string and resultant string shld be "xftag Source="L">500671" I have tried many ways but I am not getting the desired output . One of the ways I tried , pls see below string t10 = "xftag Source=\"L\">500671"...

Hi I am facing this problem. On compiling this stored procdure it says "TEXT or IMAGE datatypes are invalid for paramters or local variable" I have OriginalMessage field which containts big XML and its not possible for me to change its datatype from text to some varchar ...any Hope I can...

hi am trying to get client machine name and the user name on that machine. Any idea ? I am trying to use - System.Net.Dns.GetHostName() or System.Environment.MachineName but i guess they both gives server name ...not client name For User I am using - System.Environment.UserName but it...