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 ?
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...
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...
Hi
I got 4 tables in a DataSet , All 4 tables have same columns ( 2 columns - Field and Value ) . I want to appeand the records of rest 3 tables into 1st table.
Any one has idea ?
Hi Jennifer,
Thnks for you reply. And again I got my problem fixed as soon as I got ur reply. :):)
Actually I was not using the inbuilt functionality of Grid as you suggested in ur reply.
I have an update button and am doing multi line editing.
I have formed a 2 column Grid one column...
Hi Jennifer...
see below problem and if u can help me in that...
I am using DataGrid with two columns, one column is read only having label inside and second column having text box inside. ( am using Template column ).
Both columns are bind to data columns ( see the code below ).
But the...
Hi
I am using DataGrid with two columns, one column is read only having label inside and second column having text box inside. ( am using Template column ).
Both columns are bind to data columns ( see the code below ).
But the problem am facing is when am updating values in second column i.e...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.