Can I see server variables from my client code 1

wf · Jun 20, 2001

I am looking a value from a table in a server code. Then I want to assign this value to a html textbox but I can't.

How can I do that?

This is more or less my code:

<SCRIPT LANGUAGE=vbscript RUNAT=Server>
x = rstrecordset.Fields("fecha_nac&quot

y = rstrecordset.Fields("seg_soc&quot

</SCRIPT>

<BODY>

<IMG SRC="../images/AnimatedImages/aniearth.gif">
<INPUT type="text" id=text3 name=text3 value="<%=y%>">
<P> </P>

</BODY>

foxbox · Jun 20, 2001

Mmmm, did you write all code here? Your page should contain
a sql instruction and database connections.

So something like this:

sql = "Select top 1 fecha_nac,seg_soc FROM MyDbf"
Set Conn = Server.CreateObject("ADODB.Connection&quot

Conn.Open "(connection string)"
Set rs = Server.CreateObject("ADODB.Recordset&quot

rs.Open sql, Conn

response.write "<input type=text name=text3 value='" &_
server.HTMLEncode(rs(1)) & "'>"

br
Gerard

wf · Jun 20, 2001

Yes I have that code and I can assign the value to the variable x. That's ok. The problem is that I don't know how to assign the value to my html textbox, if it is possible.

dianal · Jun 26, 2001

Hello,
<SCRIPT LANGUAGE=vbscript RUNAT=Server>
x = rstrecordset.Fields("fecha_nac&quot

y = rstrecordset.Fields("seg_soc&quot

</SCRIPT>
is a different space than ASP directive <% %>
Although both ar erun at server side you do not have access in ASP part to what you have defined in VBScript part.
Try
<%
x = rstrecordset.Fields("fecha_nac&quot

y = rstrecordset.Fields("seg_soc&quot

%>

and you should be able to see the value of y in ASP directive <%=y%>

Hope this helps.
D.

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!

Can I see server variables from my client code 1

wf

Programmer

foxbox

Programmer

wf

Programmer

dianal

Instructor

Similar threads

Part and Inventory Search

Sponsor