syntax error in Netscape only?

<i><b>Originally posted by : Jeff S. (jeffs@fanmedia.com)</b></i><br />I've written what I thought to be a perfectly serviceable SQL statement. The code executes perfectly in Explorer but I get a syntax error in Netscape. Huh? ASP is server-side, is it not? The browser shouldn't matter. Has anyone else ever encountered this problem?<br />

<i><b>Originally posted by : steve</b></i><br />post your code please. yes asp is server side but how html is read netscape from IE.<br /><br /><br />------------<br />Jeff S. at 3/20/2000 12:24:10 AM<br /><br />I've written what I thought to be a perfectly serviceable SQL statement. The code executes perfectly in Explorer but I get a syntax error in Netscape. Huh? ASP is server-side, is it not? The browser shouldn't matter. Has anyone else ever encountered this problem?<br />

<i><b>Originally posted by : Jeff S. (jeffs@fanmedia.com)</b></i><br />Hello Steve, thanks in advance for any help. Here's the SQL statement. The app is a corporate intranet. The statement grabs employee info, then grabs security info from another table, then grabs the site ID from another table; using a previously set up session variable for employee ID.<br /><br />SQLQuery = "SELECT p.int_KeyID, p.str_lname, p.str_fname, p.int_fk_DeptID, p.str_phone, "<br />SQLQuery = SQLQuery & "p.str_phoneext, p.str_email, p.str_logon, p.str_Password, "<br />SQLQuery = SQLQuery & "ss.int_SecurityLevel "<br />SQLQuery = SQLQuery & "FROM hr.dbo.tbl_people p "<br />SQLQuery = SQLQuery & "INNER JOIN hr.dbo.tbl_PeopleSiteSecurity ss "<br />SQLQuery = SQLQuery & "ON p.int_KeyID = ss.int_PeopleKeyID "<br />SQLQuery = SQLQuery & "INNER JOIN hr.dbo.tbl_Site s "<br />SQLQuery = SQLQuery & "ON ss.int_SiteKeyID = s.int_KeyID "<br />SQLQuery = SQLQuery & "WHERE p.int_KeyID = " & Session("ITKeyID")<br />SQLQuery = SQLQuery & " AND (s.int_Site) = 0 "<br />SQLQuery = SQLQuery & " AND (p.str_Password) = '" & Pwd & "' "<br /><br /><br />------------<br />steve at 3/20/2000 10:12:14 AM<br /><br />post your code please. yes asp is server side but how html is read netscape from IE.<br /><br /><br />------------<br />Jeff S. at 3/20/2000 12:24:10 AM<br /><br />I've written what I thought to be a perfectly serviceable SQL statement. The code executes perfectly in Explorer but I get a syntax error in Netscape. Huh? ASP is server-side, is it not? The browser shouldn't matter. Has anyone else ever encountered this problem?<br />

<i><b>Originally posted by : </b></i><br />Where is the code that displays your results? <br /><br /><br />------------<br />Jeff S. at 3/20/2000 10:19:57 AM<br /><br />Hello Steve, thanks in advance for any help. Here's the SQL statement. The app is a corporate intranet. The statement grabs employee info, then grabs security info from another table, then grabs the site ID from another table; using a previously set up session variable for employee ID.<br /><br />SQLQuery = "SELECT p.int_KeyID, p.str_lname, p.str_fname, p.int_fk_DeptID, p.str_phone, "<br />SQLQuery = SQLQuery & "p.str_phoneext, p.str_email, p.str_logon, p.str_Password, "<br />SQLQuery = SQLQuery & "ss.int_SecurityLevel "<br />SQLQuery = SQLQuery & "FROM hr.dbo.tbl_people p "<br />SQLQuery = SQLQuery & "INNER JOIN hr.dbo.tbl_PeopleSiteSecurity ss "<br />SQLQuery = SQLQuery & "ON p.int_KeyID = ss.int_PeopleKeyID "<br />SQLQuery = SQLQuery & "INNER JOIN hr.dbo.tbl_Site s "<br />SQLQuery = SQLQuery & "ON ss.int_SiteKeyID = s.int_KeyID "<br />SQLQuery = SQLQuery & "WHERE p.int_KeyID = " & Session("ITKeyID")<br />SQLQuery = SQLQuery & " AND (s.int_Site) = 0 "<br />SQLQuery = SQLQuery & " AND (p.str_Password) = '" & Pwd & "' "<br /><br /><br />------------<br />steve at 3/20/2000 10:12:14 AM<br /><br />post your code please. yes asp is server side but how html is read netscape from IE.<br /><br /><br />------------<br />Jeff S. at 3/20/2000 12:24:10 AM<br /><br />I've written what I thought to be a perfectly serviceable SQL statement. The code executes perfectly in Explorer but I get a syntax error in Netscape. Huh? ASP is server-side, is it not? The browser shouldn't matter. Has anyone else ever encountered this problem?<br />