I am having the damnedest time trying to get the simplest thing to work on an ASP site I am coding.
The page is connecting to a SQL db via DSN, and that is working fine. I tested the Select string in the query analiser, and that works... but response.write won't list the data.
The data is definitely there because i can see it in SQL management studio.
clientdata is the name of the table.
add1 is a name of a field in the table.
I blanked out the DSN info but it is connecting fine.
and asp works fine because
works fine
thoughts?
The page is connecting to a SQL db via DSN, and that is working fine. I tested the Select string in the query analiser, and that works... but response.write won't list the data.
The data is definitely there because i can see it in SQL management studio.
Code:
<%
Connect = "DSN=****;UID=****;PWD=****"
Set rs1 = Server.CreateObject("adodb.recordset")
listall = "select * from clientdata where uid like 2"
rs1.Open listall, Connect, 2, 3
%>
<%= rs1.Fields("add1") %>
clientdata is the name of the table.
add1 is a name of a field in the table.
I blanked out the DSN info but it is connecting fine.
and asp works fine because
Code:
<%= "hello world" %>
thoughts?