Please Help Out .. Db Problim

Stefan Vorster · Dec 3, 2003

Ok i have a table in a database that looks like this

Id , user , Time
1 test 200312341
2 test 324234234
3 userna 232837872

But i just wanne show on the page

test
userna

How can i do that

Ray at · Dec 3, 2003

select distinct [user] from theTable

Ray at home

Bhaskardeep Khaund · Dec 3, 2003

Hi,

Paste this code into a new asp file. Set you Database Connection(objConn) and put your table names.

<html>
<head><title></title></head>
<body>
<table width="80%" align="center">
<%
Dim id, objRs
id = Trim(Request.Form("id"))
sql = "select * from table_name "
Set objRs = Server.CreateObject("ADODB.Recordset")
objRs.Open sql, objConn
while not objrs.EOF
%>
<tr>
<td><%=objRs("id")%></td>
<td><%=objRs("user")%></td>
<td><%=objRs("time")%></td>
</tr>
<%objrs.MoveNext
Wend
%>
</table>
</body>
</html>
<%Set objRs = Nothing %>

Jeff Cochran · Dec 3, 2003

Ok i have a table in a database that looks like this

Id , user , Time
1 test 200312341
2 test 324234234
3 userna 232837872

But i just wanne show on the page

test
userna

How can i do that

How are you currently showing everything? Either just select the User
column in your SQL query, or when your query returns everything, just
display the user column.

SELECT user FROM table
{Display the whole record set using GetString()}

- or -

SELECT * FROM table
{Display only the User field in a loop}

I prefer the former, you might look at:

http://www.aspfaq.com/show.asp?id=2467

Jeff

Help please	8	Jul 7, 2023
Please, help me.	1	Jun 30, 2021
Code help please	4	May 19, 2023
Hello and Help please :-)	1	Jul 16, 2022
Updating Inventory using First In First out(FIFO)	1	Feb 2, 2023
Help with Paypal Live Transactions	1	May 19, 2023
Function Help	1	Feb 26, 2022
Please help	2	Jul 19, 2022

Please Help Out .. Db Problim

Stefan Vorster

Ray at

Bhaskardeep Khaund

Jeff Cochran

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads