HTML - ASP don't work

[tonterias]

I use the Personal WS under Win98. My asp files work if i put a criteria. If i use html to get the asp file this don't work.

 

[vinodgk]

Hi,<br>If the code had been sent it would have been usefull,<br>anyway..from the html pages,&lt;form name=&quot;zzz&quot; <br>method=&quot;post&quot; action=&quot;../asp/abc.asp&quot;&gt;..should work..<br><br>if the problem persists lemme know..but with the code...<br><br>It works perfect...<br><br>Bye<br>Vinod<br><br>

 

[tonterias]

&lt;HTML&gt;<br>&lt;HEAD&gt;<br>&lt;META HTTP-EQUIV=&quot;Content-Type&quot; CONTENT=&quot;text/html;charset=windows-1252&quot;&gt;<br>&lt;TITLE&gt;localnome&lt;/TITLE&gt;<br>&lt;/HEAD&gt;<br>&lt;BODY&gt;<br>&lt;%<br>If IsObject(Session(&quot;projecto_conn&quot) Then<br>&nbsp;&nbsp;&nbsp;&nbsp;Set conn = Session(&quot;projecto_conn&quot<br>Else<br>&nbsp;&nbsp;&nbsp;&nbsp;Set conn = Server.CreateObject(&quot;ADODB.Connection&quot<br>&nbsp;&nbsp;&nbsp;&nbsp;conn.open &quot;projecto&quot;,&quot;&quot;,&quot;&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;Set Session(&quot;projecto_conn&quot = conn<br>End If<br>%&gt;<br>&lt;%<br>If IsObject(Session(&quot;localnome_rs&quot) Then<br>&nbsp;&nbsp;&nbsp;&nbsp;Set rs = Session(&quot;localnome_rs&quot<br>Else<br>&nbsp;&nbsp;&nbsp;&nbsp;sql = &quot;SELECT Inscricao.Localidade, Inscricao.Nome&nbsp;&nbsp;FROM Inscricao&nbsp;&nbsp;WHERE (((Inscricao.Localidade)=&quot; & Request.QueryString(&quot;[Esco&quot & &quot;lha:]))&nbsp;&nbsp;&nbsp;&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot<br>&nbsp;&nbsp;&nbsp;&nbsp;rs.Open sql, conn, 3, 3<br>&nbsp;&nbsp;&nbsp;&nbsp;If rs.eof Then<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs.AddNew<br>&nbsp;&nbsp;&nbsp;&nbsp;End If<br>&nbsp;&nbsp;&nbsp;&nbsp;Set Session(&quot;localnome_rs&quot = rs<br>End If<br>%&gt;<br>&lt;TABLE BORDER=1 BGCOLOR=#ffffff CELLSPACING=0&gt;&lt;FONT FACE=&quot;Arial&quot; COLOR=#000000&gt;&lt;CAPTION&gt;&lt;B&gt;localnome&lt;/B&gt;&lt;/CAPTION&gt;&lt;/FONT&gt;<br><br>&lt;THEAD&gt;<br>&lt;TR&gt;<br>&lt;TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 &gt;&lt;FONT SIZE=2 FACE=&quot;Arial&quot; COLOR=#000000&gt;Localidade&lt;/FONT&gt;&lt;/TH&gt;<br>&lt;TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 &gt;&lt;FONT SIZE=2 FACE=&quot;Arial&quot; COLOR=#000000&gt;Nome&lt;/FONT&gt;&lt;/TH&gt;<br><br>&lt;/TR&gt;<br>&lt;/THEAD&gt;<br>&lt;TBODY&gt;<br>&lt;%<br>On Error Resume Next<br>rs.MoveFirst<br>do while Not rs.eof<br>&nbsp;%&gt;<br>&lt;TR VALIGN=TOP&gt;<br>&lt;TD BORDERCOLOR=#c0c0c0 &gt;&lt;FONT SIZE=2 FACE=&quot;Arial&quot; COLOR=#000000&gt;&lt;%=Server.HTMLEncode(rs.Fields(&quot;Localidade&quot.Value)%&gt;&lt;BR&gt;&lt;/FONT&gt;&lt;/TD&gt;<br>&lt;TD BORDERCOLOR=#c0c0c0 &gt;&lt;FONT SIZE=2 FACE=&quot;Arial&quot; COLOR=#000000&gt;&lt;%=Server.HTMLEncode(rs.Fields(&quot;Nome&quot.Value)%&gt;&lt;BR&gt;&lt;/FONT&gt;&lt;/TD&gt;<br><br>&lt;/TR&gt;<br>&lt;%<br>rs.MoveNext<br>loop%&gt;<br>&lt;/TBODY&gt;<br>&lt;TFOOT&gt;&lt;/TFOOT&gt;<br>&lt;/TABLE&gt;<br>&lt;/BODY&gt;<br>&lt;/HTML&gt;<br><br><br>THE PROBLEM<br><br>Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br><br>[Microsoft][Controlador Microsoft Access de ODBC] Erro de sintaxe na expressão de consulta '(((Inscricao.Localidade)=ite]))'. <br><br>/localnome1.ASP, line22 <br><br><br>I don't understand.<br><br>Help me Vinod<br><br><br>