[thelist] SQL Update Query - Easy

Rob Smith rob.smith at THERMON.com
Wed Jan 26 15:30:31 CST 2005


Doh!

>Video = split(trim(Videos),",")

made absolutely no difference in removing the extra space in front of the
video id.

>RS.Source = "Update tblVideos SET CheckedIn = 1 WHERE Video = '" &
Video(counter) & "'"

to ... '" & trim(Video(counter)) & "'...

made the loop work..

sorry,

Rob


More information about the thelist mailing list