| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Must use updateable query - Newbie question - How do I get around this? |
|
From: |
Ross McLanachan |
|
Date: |
5/12/2000 8:17:27 AM |
|
IP: |
192.107.28.13 |
Hi there
I am using the below to write to a guestbook table in Access2000.
########################
Build Insert String
strSQL = "INSERT INTO Guestbook(Name, Email, Date_Entered, URL, IP_Address,
Message)"
strSQL = strSQL & " SELECT "
strSQL = strSQL & "" & Name & " as text1, "
strSQL = strSQL & "" & Email & " as text2, "
strSQL = strSQL & "" & Date() & " as text3, "
strSql = strSQL & "" & URL & " as text4, "
strSql = strsql & "" & IPAddy & " as text5, "
strSQL = strSQL & "" & replace(request("Message"), "", "") & " as text6 "
conn.execute(strSQL)
conn.close
set conn = nothing
#################
It gives me the following error:
Microsoft OLE DB Provider for ODBC Drivers error 80004005
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/cgi-bin/test/rmclanac/savemessage.asp, line 34
=======
Can you please help me? Does anyone know how to get around this problem?
Any help would be much appreciated.
Thanks In Advance
Ross McLanachan |
Follow Up - Re: Must use updateable query - Newbie question - How do I get around this? - Shailesh Lolam 5/15/2000 2:50:18 AM
|
|
|
|
|
|
