想問問大家是怎樣處理SQL中的( ' ) | sql特殊字元
AɥR@ǡC"@ӳܦӳ"ʧ@AsCharacterEscape(r)CҦpbjavascriptpGrꤺݭn]tAObjavascriptONr_аOw]ŸAҥHoӦrN|تܪkC varMyString //ܦr_аO MyString="LetgosResponse" //ϥEscapeCharacter(r)CNOϱu //oӮɭԡAϱuNObiĶAnϱu᭱U@Ӧr@"r"ӳBzAӤOr MyString=LetgosResponse bVBScript]|JDAr̭HjaOOΤU覡BzǡH <% dimMyString MyString="""bVBScript]Oӳ·" Response.writeMyString %> ۦPDzAbSQLyk]O|oتpA̱`X{]OC `kNOreplace()b{N@ӳܦ MyString="LetgosResponse" ...
AɥR@ǡC"@ӳܦӳ" ʧ@As Character Escape(r)CҦpb javascript pGrꤺݭn]tAOb javascript ONr_аOw]ŸAҥHoӦrN|تܪkC
var MyString //ܦr_аO MyString = "Letgos Response" //ϥ Escape Character(r)CNOϱu //oӮɭԡAϱuNObiĶAnϱu᭱U@Ӧr@ "r" ӳBzAӤOr MyString = Letgos Response
b VBScript ]|JDAr̭HjaOOΤU覡BzǡH <% dim MyString MyString = " "" b VBScript ]Oӳ·" Response.write MyString %>
ۦPDzAb SQL yk]O|oتpA̱`X{]OC
`kNO replace() b{N@ӳܦ MyString = "Letgos Response" MyString = Replace(MyString, "", "") MySQL = "select * from MyTable where MyColumn = " & MyString " " adoRs.Open MySQL, adoCn
SQL yk٦@r ESCAPEALڴչLFΦbWBoӨҤlGuAΩ like lyCUOڱq MSSQL ̭XӪdҡC /* ϥ ESCAPE lyҦ ziHjMt@ΦhӯSUΦrrrCҦpAcustomers Ʈw discounts ƪixsFtʤŸ (%) 馩ȡCjMɭYQʤŸrӫDUΦrAh ESCAPE rPhXrCҦpAYӽdҸƮwt@ӦW comment ƦAƦ椤tr 30%CYQX comment Ʀ椤r 30% ƦCAЫw WHERE ly WHERE co...