[thelist] SQL Question
Roger Ly
rogerly at bareviking.com
Thu Jun 27 18:18:01 CDT 2002
Thanks Ben and Judah for your quick responses...
I was able to get the information I needed using both queries. (I was just
trying to get general Netscape 4.x usage based on logins to our site to see if
we can move to a more CSS-based design... it comes up to be around 3.79% of
logins with a Windows browser yesterday.. Obviously +/- a little based on
spoofed UserAgents, etc.)
>BTW, you'll probably want to add a primary key column on your table, since
>the userID/userAgent combination won't be unique.
Yeah, actually I do have a sessionID column in the table, I just omitted the
other extraneous columns so I wouldn't confuse people by giving more information
than is necessary.
Roger
More information about the thelist
mailing list