|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Problem with updating database |
|
From: |
Timo Tuunainen |
|
Date: |
2/25/1999 7:09:10 AM |
|
IP: |
195.148.253.200 |
Could someone tell me what is wromg with the following code? I've tried to get it work
for several hours and I'm pretty fed up with this... Please help me!
Btw. Sorry that those variables are in finnish. I hope it doesn't bother anyone.
<cut>
<%
on error resume next
id = Request.form("id")
yritys = Request.form("yritys")
toimiala = Request.form("toimiala")
osoite = Request.form("osoite")
postinumero = Request.form("postinumero")
toimipaikka = Request.form("toimipaikka")
puhelin = Request.form("puhelin")
fax = Request.form("fax")
www=Request.form("www")
email=Request.form("email")
yhteyshenkilo=Request.form("yhteyshenkilo")
Set Conn = Server.CreateObject("ADODB.Connection")
conn.open "Yritys"
SQLlause = "UPDATE Perus "
SQLlause = SQLlause & "SET Yritys = '" & yritys & "',"
SQLlause = SQLlause & "Toimiala = '" & toimiala & "',"
SQLlause = SQLlause & "Osoite = '" & osoite & "',"
SQLlause = SQLlause & "Postinumero = '" & postinumero & "',"
SQLlause = SQLlause & "Toimipaikka = '" & toimipaikka & "',"
SQLlause = SQLlause & "Puhelin = '" & puhelin & "',"
SQLlause = SQLlause & "FAX = '" & fax & "',"
SQLlause = SQLlause & "WWW = '" & www & "',"
SQLlause = SQLlause & "EMail = '" & email & "',"
SQLlause = SQLlause & "Yhteyshenkilö ='" & yhteyshenkilo & "'"
SQLlause = SQLlause & " WHERE Tunniste=" & id
Set RS = Conn.Execute(SQLlause)
</cut> |
Follow Up - Re: Problem with updating database - Harlan 2/25/1999 9:24:55 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
