If statement and input 1

[nonprogrammer]

I was wondering if you can do in if statement then input

would it be something like

<% if rsone("a1") = rstwo ("aw1")then input 3 into "as1" end if%>

 

[monksnake]

That's crazy talk there.

What exactly are rsone("a1") and rstwo("aw1")?

<.

 

[nonprogrammer]

rsone("a1") is a field in table umber 1
rstwo("aw1) is a field that gets populated from antother form in table number 2
I am trying to write an asp page that will compare both fields and if both fields are equal then input a specific number into table 2 field as1

 

[DotNetGnat]

something like this:

<% 
if rsone("a1") = rstwo("aw1")then 
dim sql, conn
conn = "your connection string"
sql = "your insert sql query"
conn.execute sql
end if
%>

-DNG

 

[nonprogrammer]

sweet got it thank you so very much !!!!

 

[DotNetGnat]

not a problem...glad to help...

-DNG