I studied it for one afternoon and had no clue. I came to the Forum for help and lost my old ID! I registered a new one! =. =!
I want to use javascript regular expressions to extract SQL line expressions in asp code, but I cannot write or write them. You can help me with your work!
To extract the SQL expression in quotation marks
StrSql = "Select * from project354 where ID =" & Request ("id") & and Name = '000000 '"
<Html xmlns = "http://www.w3.org/1999/xhtml"> <pead> <meta http-equiv = "Content-Type" content = "text/html; charset = gb2312 "/> <title> untitled document </title> </pead> <body> <pre class =" code "cols =" 50 "rows =" 10" id = "_ ASPeditor"> <% 'The file name of this tag is tag_354_content.asp Sub tag_354_content () set objRs_tag_354_content = server. createobject ("adodb. recordset ") strSql =" Select * from project354 where ID = "& Request (" id ") &" "objRs_tag_354_content.open strSql, conn, 1, 1, End Sub %> </textarea> <input name = "" type = "button" value = "extract SQL" onclick = "getSqlCode () "/> </body> </ptml>
[Ctrl + A select all Note: If you need to introduce external Js, You need to refresh it to execute]