How to reduce duplicate data from a recordset
To reduce duplicate data from a recordset
You can reduce duplication in your data through the use of DISTINCT in your SELECT statement.
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "DSN=tenderproject;UID=tenderproject;PWD=tender"
set rs=Server.CreateObject("ADODB.Recordset")
sqlstr = "SELECT DISTINCT name, expertise from mytable ORDER BY name "
rs.open sqlstr, conn, 1,3
%>
Edited By: Norasyikin Mahmud
© 2001 ISC/Inner Esteem
All rights reserved. All other product names and trademarks are registered properties of their respective owners.
140302