UPDATES using command object

Results 1 to 2 of 2

Thread: UPDATES using command object

  1. #1
    Tyoshi Guest

    Default UPDATES using command object

    Does anyone have sample code for performing UPDATES with the command object?<BR><BR>Thanks in advance

  2. #2
    Join Date
    Dec 1969

    Default updates using sql...

    if you&#039re wondering how to do an update it would be something like so:<BR><BR>&#060;%<BR>set dbcn=server.createobject("adodb.connection")<BR>db cn.open "dsn=yourdsn"<BR>sql="update yourtable set yourfield=&#039textvalue&#039,yourfield1=numericva lue where yourfield2=&#039value&#039"<BR>dbcn.execute(sql)<B R>dbcn.close<BR>set dbcn=nothing<BR>%&#062;

Posting Permissions

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