Results 1 to 2 of 2

Thread: insert

  1. #1
    Join Date
    Dec 1969

    Default insert

    Hi all <BR>I&#039;m doing a simple insert into a access database. here is my code. <BR>&#060;% <BR>company = Trim(Request.Form("addcomp")) <BR>set conn = server.CreateObject("ADODB.Connection") <BR>conn.Open "metro" <BR>sql = "insert into TBLCOMPANY (COMPANY_NAME) values (&#039;"& company &"&#039;)" <BR>conn.Execute sql <BR>%&#062; <BR>but i get an error saying operation must use an updateable query. <BR>Please let me know whwere i have gone wrong. <BR>thx in advance <BR><BR>PS : already had posted n the regular asp question and answers, but didnt get any reply , so posting it here

  2. #2
    Join Date
    Dec 1969

    Default ASPFAQs, category Databases, Errors

    The link to the ASPFAQs is at the top right corner of most every page on this site, including the one you are reading now.<BR><BR>Yes, that FAQ *does* appear in that category.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts