[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