> Your database doesn't contain the data you think it does. Unassigned userId > values are not NULL, but empty strings. By SQLite rules, any string is > compared greater than any number.
Igor, Probably this is not true in this SQLite version: >> I'm running php 5.2 that has sqlite 2.8.17 Pavel On Tue, May 8, 2012 at 10:41 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > On 5/8/2012 9:58 PM, Shorty wrote: >> >> I've got a database that users can request to join the mailing list. >> After they add their name and email address, I'll assign them a userID >> number. >> >> The database looks like this: >> >> recordID userID name email >> 1 1 John j...@somewhere.com >> 2 2 Mike m...@example.com >> 3 3 Bill b...@example.com >> 4 null Steve st...@example.com >> >> this works: >> SELECT max(userID) AS 'highest_userID' FROM maillist WHERE userID <> '' >> then highest_userID is returned with a value of 3 > > > Your database doesn't contain the data you think it does. Unassigned userId > values are not NULL, but empty strings. By SQLite rules, any string is > compared greater than any number. > -- > Igor Tandetnik > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
