#1
  1. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Apr 2001
    Posts
    910
    Rep Power
    0

    Help with insert


    I have the below code:
    PHP Code:
    <% Response.CacheControl="no-cache"
       
    Response.AddHeader "Pragma","no-cache"
       
    Response.Expires=0
    %> 

    <!-- 
    #include file="top.asp" -->
    <%
       
    sql="insert into news (headline, body) values('$headline', '$body');"
       
    set rs=conn.execute(sql)      

             
     
      
    count=0


    %> 
    and I get the following error why?
    Error Type:
    Microsoft JET Database Engine (0x80004005)
    Operation must use an updateable query.
    /news/news_post.asp, line 9

    Tim
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Location
    Canada - Egypt
    Posts
    60
    Rep Power
    12

    More info would be helpful


    What kind of database is it ?
    Are you able to do any other insertions anywhere else?
    What is the structure of the table that u r trying to insert into?
    How did u make the connection to the database?
    I hope this is of any help to anyone.

    Yassoor
    http://www.WebsitesCreation.ca

IMN logo majestic logo threadwatch logo seochat tools logo