Rad,

Was able to Get this to work in VBScript...
I borrowed some code from - http://www.devx.com/VistaSpecialReport/Article/33767/1763/page/2
 Code:
Set objConnection = CreateObject("ADODB.Connection")
Set objRecordSet = CreateObject("ADODB.Recordset")

objConnection.Open "Provider=Search.CollatorDSO;Extended Properties='Application=Windows';"


sql = "SELECT System.ItemFolderPathDisplay, "
sql = sql & "System.ItemNameDisplay, "
sql = sql & " System.ItemType FROM "
sql = sql & " systemindex WHERE CONTAINS(System.FileName,'%0%')"
sql = sql & " AND System.ItemNameDisplay LIKE '%.doc%'"

objRecordSet.Open sql, objConnection

objRecordSet.MoveFirst
Do Until objRecordset.EOF
text = objRecordset.Fields.Item("System.ItemFolderPathDisplay")
text = text & objRecordset.Fields.Item("System.ItemNameDisplay")
text = text & objRecordset.Fields.Item("System.ItemType")
Wscript.Echo text

objRecordset.MoveNext
Loop


Tried to convert to KiXtart And is Not working..
 Code:
$cn = CreateObject("ADODB.Connection") $cmd = CreateObject("ADODB.Command") $rs = CreateObject("ADODB.RecordSet")
$cn.connectionstring = "Provider=Search.CollatorDSO;Extended Properties='Application=Windows';"
$cn.open
$cmd.activeconnection = $cn $rs.cursortype = 3 $rs.locktype = 3 $rs.activecommand = $cmd
$cmdtxt = "SELECT System.ItemFolderPathDisplay, "
$cmdtxt = $cmdtxt + "System.ItemName, "
$cmdtxt = $cmdtxt + "System.ItemTypeText, "
$cmdtxt = $cmdtxt + "System.Size "
$cmdtxt = $cmdtxt + "FROM SystemIndex "
$cmdtxt = $cmdtxt + "systemindex WHERE CONTAINS(System.FileName,'%0%') "
$cmdtxt = $cmdtxt + "AND System.ItemNameDisplay LIKE '%.doc%'"
$cmd.commandtext = $cmdtxt
$rs.open($cmd)	
$rs.MoveFirst
While Not $rs.eof
	? $rs.fields.item("System.ItemFolderPathDisplay").value 
	? $rs.fields.item("System.ItemName").value 
	? $rs.fields.item("System.ItemTypeText").value
	? $rs.fields.item("System.Size").value
	?
	$rs.moveNext
Loop
$rs.close
$cn.close


HTH,

Kent
_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's