Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

updating a Text field with a String having " inside

Status
Not open for further replies.
DilipKS

DilipKS

Programmer
Mar 8, 2004
30
CH
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 ?
 
Sort by date Sort by votes
Got it worked ..
UPDATE dbo.SystemExceptions SET OriginalMessage = '<Execution><Account>BZ</Account><SecurityID IDSource="RIC">OML.L</SecurityID></Execution>' WHERE ExcpMsgID=83
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AM_WG
  • Locked
  • Question
Need help with SQL query to update a Micros report
Replies
0
Views
663
AM_WG
AM_WG
raphael75
  • Locked
  • Question
trying to call Sybase stored procedure with parameters from PHP
Replies
0
Views
360
raphael75
raphael75
yelizavetayr
  • Locked
  • Question
Sybase/Infomaker field dependency
Replies
0
Views
394
yelizavetayr
yelizavetayr
raphael75
  • Locked
  • Question
installation errors on AWS Linux AMI
Replies
1
Views
408
raphael75
raphael75
stropiccioli
  • Locked
  • Question
Sybase PB12.5 and oracle 11g &quot;Oracle library OCI.DLL could not be loaded&quot;
Replies
0
Views
375
stropiccioli
stropiccioli

Part and Inventory Search

Sponsor

Back
Top