[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