If statment doesn't work, why ?

[Carlos Fernandes]

Why when i awsner N in my if statment it also inserts data in my db ?

insere.asp

<%
....asp code...
%>
<SCRIPT LANGUAGE=VBScript>
nr=inputbox("S/N." )
if ucase(nr)="S" then
document.write "<%Set RS = Server.CreateObject ("ADODB.Recordset")%>"
document.write "<%RS.Open "reuniao", DB, 1,2 %>"
document.write "<%RS.AddNew%>"
document.write "<%RS ("solicitante") = request.form("solicitante")%>"
document.write "<%RS.Update%>" document.write "<%response.write
"Inserted"%>"
else
window.history.back()
end if
</SCRIPT>
<%
....asp code...
%>

Best regards,

Carlos

(e-mail address removed)

 

[Evertjan.]

Carlos Fernandes wrote on 01 mei 2004 in
microsoft.public.inetserver.asp.general:

Why when i awsner N in my if statment it also inserts data in my db ?

ASP code is executed serverside BEFORE the page is sent to the client.
The client cannot execute ASP code.

document.write "<%Set RS = Server.CreateObject ("ADODB.Recordset")%>"

The <% ... %> is executed [serverside, see above], but gives no string in

document.write ""

So it is not a very logical thing to do.