is there a way to have index server not return duplicate pages in the results?
right now i am using the ixsso.query object to grab the results
Set oQuery = Server.CreateObject("IXSSO.Query"
oQuery.Catalog = "mycatalog"
sQuery = "@Contents '" & CiRestriction & "'"
sQuery = sQuery & " AND #path *content*"
sQuery = sQuery & " AND NOT #path *img*"
sQuery = sQuery & " AND NOT #path *js*"
sQuery = sQuery & " AND NOT #path *flash*"
sQuery = sQuery & " AND NOT #path *map*"
sQuery = sQuery & " AND NOT #filename *.asa"
sQuery = sQuery & " AND NOT #filename *.css"
sQuery = sQuery & " AND NOT #filename *.js"
sQuery = sQuery & " AND NOT #filename *.swf"
sQuery = sQuery & " AND NOT #filename search*.asp"
sQuery = sQuery & " AND NOT #filename IS NULL"
oQuery.SortBy = "rank[d]"
oQuery.Columns = "vpath, doctitle, FileName, Characterization"
Set rs = Server.CreateObject("ADODB.Recordset"
rs.Open oQuery.CreateRecordSet("nonsequential"
then i loop thru the rs
but some pages show up over and over and over and over.. the same exact page.. anyone know how to elimintate this?
a filter duplicates/group by clause?
thanks
right now i am using the ixsso.query object to grab the results
Set oQuery = Server.CreateObject("IXSSO.Query"
oQuery.Catalog = "mycatalog"
sQuery = "@Contents '" & CiRestriction & "'"
sQuery = sQuery & " AND #path *content*"
sQuery = sQuery & " AND NOT #path *img*"
sQuery = sQuery & " AND NOT #path *js*"
sQuery = sQuery & " AND NOT #path *flash*"
sQuery = sQuery & " AND NOT #path *map*"
sQuery = sQuery & " AND NOT #filename *.asa"
sQuery = sQuery & " AND NOT #filename *.css"
sQuery = sQuery & " AND NOT #filename *.js"
sQuery = sQuery & " AND NOT #filename *.swf"
sQuery = sQuery & " AND NOT #filename search*.asp"
sQuery = sQuery & " AND NOT #filename IS NULL"
oQuery.SortBy = "rank[d]"
oQuery.Columns = "vpath, doctitle, FileName, Characterization"
Set rs = Server.CreateObject("ADODB.Recordset"
rs.Open oQuery.CreateRecordSet("nonsequential"
then i loop thru the rs
but some pages show up over and over and over and over.. the same exact page.. anyone know how to elimintate this?
a filter duplicates/group by clause?
thanks