Hi Problems started after I upgraded my Driver from mm.mysql.jdbc-1.2c to mm.mysql-2.0.4-bin.jar, still using MySQL v.3.23.33 on ApacheTomcat (Win2000) where I formerly had the \org\ Driver dir in \classes\ but now have new Driver in \lib\ and haven't unzipped jar. Yes, updated Environ Var'bles pointing to mysql\ dir. 1. New Driver works fine with normal Servlets on normal Database Tables so I assumed everything was OK. 2. New Servlets to new Database Tables produces SQLException Error "Before start of result set" and blank screen from searches to DB, showing no parameters output from new DB. New DB Tables produced since installing new Driver. 3. Tested New Servlets on normal Database Tables and they produce search results OK, no SQLException errors. 4. Have dropped new DB Tables many times and re-input data, starting again, but still same result as point 3. 5. Re-installed old Driver for testing, normal Servlets to normal DB Tables work fine. Slight improvement to new Servlets to new DB Tables: now shows "null" for each respective parameter in Html output instead of a blank screen. I am so stuck. What am I missing? Cheers, Lucy --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
