[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