ASP question?

Phailak · Apr 22, 2001

Hail,

I just started to use ASP. I'm used to VB so this is what I want to do. When a user clicks on a button, I want to write a response on the page by retrieving data from a table. I figured out how to retrieve the data with the following:

<%
sql="select * from Players"
Set OBJdbConnection = Server.CreateObject("ADODB.Connection&quot

OBJdbConnection.Open "Glad"
Set RS=OBJdbConnection.Execute(sql)
%>
<%=RS("Password&quot

%>
<%
OBJdbConnection.Close
%>

But what I don't understand is how can I launch this when the user clicks on my button??? I tried to put the above script into the following:

<SCRIPT LANGUAGE=VBScript RUNAT=Server>
<%
sql="select * from Players"
Set OBJdbConnection = Server.CreateObject("ADODB.Connection&quot

OBJdbConnection.Open "Glad"
Set RS=OBJdbConnection.Execute(sql)
%>
<%=RS("Password&quot

%>
<%
OBJdbConnection.Close
%>
End Sub
</SCRIPT>

Now I know that is wrong, but can someone maybe point me in the right direction?

Phailak

foxbox · Apr 23, 2001

Put this in a file called tt.asp and run it:

<%@ Language=VBScript %>
<%
dim sql, conn, cName
Response.Write "<html><form name=frmTT method=post action=tt.asp>"
if Request.Form("btnOne&quot

<> "" then
sql = "select top 1 password from players"
Set Conn = Server.CreateObject("ADODB.Connection&quot

Conn.Open "<type your connection string;>"
Set rs = Server.CreateObject("ADODB.Recordset&quot

rs.Open sql, Conn
if not rs.EOF then
cName = rs(0)
else
cName = "No records in database"
end if
rs.Close
conn.Close
set conn = nothing
set rs = nothing
end if
Response.Write "<input type=submit name=btnOne value=ClickMe><br><br>"
Response.Write cName & "</form></html>"
%>

this is just one way of doing it!

br
Gerard
(-:

Better a known bug then a new release.

Phailak · Apr 23, 2001

Doesn't work, I get following error:

Microsoft VBScript compilation error '800a03ea'

Syntax error

/ASPSamp/Gladiators/tt.asp, line 4

Response.Write "<html><form name=frmTT method=post
---------------^

It's probably just syntax error...

Phailak

foxbox · Apr 23, 2001

i hope

action=tt.asp>"

is not on a seperate line?the complete response.write line did not fit on the narrow Tek-Tips screen, so it was wrapped.

A multiline statement would be:

Response.Write "<html><form name=frmTT " &_
"method=post " &_
"action=tt.asp>"

br
Gerard
(-:

Better a known bug then a new release.

Phailak · Apr 23, 2001

Hail,

Hahaha! Ok that was right, let's just keep this between us

)

I guess I'm just not used to the syntax yet, thx a lot though

Phailak

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

ASP question?

Phailak

Programmer

foxbox

Programmer

Phailak

Programmer

foxbox

Programmer

Phailak

Programmer

Similar threads

Part and Inventory Search

Sponsor