[thelist] RE: updating a record?
rudy
r937 at interlog.com
Sun Oct 13 08:30:01 CDT 2002
>> do you really want to update the counter on more than one row at a time?
>
>Actually, the table that this is querying has zip code as the primary key.
nevertheless, the query can still return multiple rows
for example,
where zipcode like '%9021%'
will return not only 90210 through 90219 but also 19021, 29021,39021...
where zipcode like '%9%'
will surely return more than can comfortably be shown on one web page
in this latter case, i sincerely doubt you will want all selected rows to
have their counter updated
if you want to return only one row at a time, use an equality comparison,
not a LIKE comparison with wildcards, i.e.
where zipcode = '90210'
rudy
More information about the thelist
mailing list