Can u do this?

Results 1 to 2 of 2

Thread: Can u do this?

  1. #1
    Jim Dale Guest

    Default Can u do this?

    Can you do an update like this, <BR>e.g update everything between field 7 and field 18<BR><BR>Is this kind of update possible or do you have to do the traditional way?<BR>Thanks for your help<BR>

  2. #2
    Jason Miller Guest

    Default RE: Can u do this?

    You just have to be sneaky. the "left(strCols..." bit is to clip the last comma.<BR><BR>for i = x to y<BR> strCols = strCols & objRS(i).name & " = &#039" & arrVals(i) & "&#039, "<BR>next<BR><BR>.execute "update table set " & left(strCols, len(strCols) - 2) & " where ..."<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