Hi Dian, > Very cool, Shawn! Thanks so much! My pleasure.
> ...any recommendations on a good reference book for all this crap? > I know a lot of it is just learned through time/experience. But I > have a dozen SQL books and, although I haven't read through all of > them, I do use many as references and none have all this stuff > listed so I'd at least know my choices. My first experience with SQL was with Access 2.0, where I literally printed out the entire help file (several hundred pages) on base and read them after work in the barracks. Probably not what most people would consider a fun evening, but I had work to do. ;) Anyway, I think most of the SQL I know was from my need to create fancy queries in Access 2.0, and since it had a rather short SQL string limit I had to find as many ways as possible to shorten the SQL to less than 256 characters. Since I use MySQL for most everything these days I just use the MySQL online library when I need to know how to do something. It's as simple as "mys select" in DQSD: http://dqsd.net/ I've actually created a pretty spiffy function that wraps SQL generation for ASP. Maybe I'll write an article about that for MouseTrax. Regards, Shawn K. Hall http://ReliableAnswers.com/ '// ======================================================== "The reason why worry kills more people than work is that more people worry than work." -- Robert Frost, American poet (1874-1963) ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
