[thelist] updating a record?

rudy r937 at interlog.com
Sat Oct 12 18:50:01 CDT 2002


> SearchStr = "SELECT cmacount FROM zip_tbl WHERE zipcode
> Like '%" & Replace(zipcode, "'", "''") & "%' "

hi jeremy

sorry, i don't do ASP, however, please note that depending on what the user
enters for the zipcode, the above query may return more than one row

do you really want to update the counter on more than one row at a time?

rudy


> RS.Close
> Set RS = Nothing

sorry, can't help myself, i just find this bit of coding hilarious








More information about the thelist mailing list