insert into (har problemer med ( - ) i E(-)mail )
Jeg er nybegynder inde for asp og er rendt på det problem at je før fejl når jeg indsætter en tekst i kolonnen E-mail.Det regner med det er et let spørgsmål for kendere.
strQ = \"INSERT INTO NavneTabel (Firstname, Lastname, Nickname, Address, PostNo, Celular, Phone, E-mail) VALUES\"
if Request.ServerVariables(\"QUERY_STRING\") <> \"\" Then
\' Retrieving Form Data from QueryString
strFirstname = Trim(Request.QueryString(\"firstname\"))
strLastname = Trim(Request.QueryString(\"lastname\"))
strNickname = Trim(Request.QueryString(\"nickname\"))
strAddress = Trim(Request.QueryString(\"address\"))
strPostNo = Trim(Request.QueryString(\"postno\"))
strCelular = Trim(Request.QueryString(\"cellular\"))
strPhone = Trim(Request.QueryString(\"phone\"))
strEmail = Trim(Request.QueryString(\"email\"))
strQ = strQ&\"(\'\"&strFirstname&\"\',\'\"&strLastname&\"\',\'\"&strNickname&\"\',\'\"&strAddress&\"\',\"&strPostNo&\",\"&strCelular&\",\"&strPhone&\",\'\"&strEmail&\"\' )\"
<form ACTION=\"<%=Request.ServerVariables(\"SCRIPT_NAME\") %>\" METHOD=\"get\">
First name: <INPUT TYPE=\"TEXT\" NAME=\"firstname\"><br>Last name: <INPUT TYPE=\"TEXT\" NAME=\"lastname\"><br>
<p>Nickname <input type=\"text\" name=\"nickname\" size=\"24\"><br>
</p>
<p>Address <input type=\"text\" name=\"address\" size=\"24\"><br>
</p>
<p>Post no <input type=\"text\" name=\"postno\" size=\"24\"><br>
</p>
<p>Phone no <input type=\"text\" name=\"phone\" size=\"24\"><br>
</p>
<p>Cellular <input type=\"text\" name=\"cellular\" size=\"24\"><br>
</p>
<p>E-mail <input type=\"text\" name=\"email\" size=\"24\"><br>
</p>
<p></p>
<p><INPUT TYPE=\"Submit\" NAME=\"submit\" VALUE=\"Submit Form\"><input type=\"reset\"></p>
</form>
