|
-
Jun 5th, 2001, 05:43 AM
#1
Thread Starter
Junior Member
error message
please can someone tell me why i'm getting this error message, i've seen this befor but can not remember where!!!
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
Here is my code:
<%
Dim title, music_date, sub_title, LofScore, revised, First_performance, objcon, sqlinsert
Function ChkString(string)
If string = "" Then string = " "
ChkString = Replace(string, "'", "''")
End Function
' Receiving values from Form
title = ChkString(Request.Form("title"))
music_date = ChkString(Request.Form("m_date"))
subt_title = ChkString(Request.Form("sub_title"))
LofScore = ChkString(Request.Form("comments"))
revised = chkstring(request.form("revised"))
first_performance = chkstring(request.form("f_performance"))
set objcon = server.createobject("adodb.connection")
objcon.open "stravinsky"
sqlinsert = "insert into music (title, sub_title, m_date, revised, lofscore, f_performance) values
('" & title & "', '" & sub_title &"', '" & music_date & "', '" & revides & "', '" & lofscore & "',
'" & first_performance & "')"
objcon.execute(sqlinsert)
objcon.close
set objcon = nothing
response.write " the music details have been entered inti the database Thank You"
%>
thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|