|
Blue Forest http://www.lslnet.com at 8:28 on August 25, 2006
 Replace the replacement
Conn.execute ( "update SePu_Class set class=replace (" 1,2,3,4,5,6 "," 3 "," ") where id=1")
Lack of surprise ")," but do not see where the problem ah
Class=replace ( "1,2,3,4,5,6", "3", "") is not wrong |
| Lane expressions like you ", to use 'off |
Replace function is among the quotation marks you, try this :
Conn.execute ( "update SePu_Class set class=replace (" "1,2,3,4,5,6", "", "3", "", ") where id=1")
|
Look at the basic knowledge of SQL bars.
Look at what the word boundaries symbols, characters word boundaries symbols.
Single Primer
Update. . Set xxx=replace ( 'xxxbb' and 'C', '') where |
| 'Replace ( "1,2,3,4,5,6", "3", ") where id=1' mistake |
|
