> 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 <[email protected]> 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 [email protected] >> 2 2 Mike [email protected] >> 3 3 Bill [email protected] >> 4 null Steve [email protected] >> >> 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
