BrenB
2008-03-27 17:50:09 UTC
I need help forming a query.
Although I'm more comfortable with SQL type queries, my server is not
setup to use the OLEDB provider, so, I'm using the ixsso object
instead.
The Index Server property that I'm querying is Filename.
Embedded within all the Filenames is an Invoice Number and a Project
Number. The Filename has a pattern something like this:
PPPPPP_GG_DDDDDDDD_IIIIIIII.pdf
Where P = Project Number, G = Invoice Group, D = Date, and I = Invoice
Number
This query below works, and it returns all PDF documents in the Index
Server catalog for a given project number:
#Filename = 123456*.pdf
I tried adding a phrase for the invoice number, but this query didn't
work.
#Filename = 123456*.pdf and #Filename = *23232323*
Thank you for your help.
Bren
Although I'm more comfortable with SQL type queries, my server is not
setup to use the OLEDB provider, so, I'm using the ixsso object
instead.
The Index Server property that I'm querying is Filename.
Embedded within all the Filenames is an Invoice Number and a Project
Number. The Filename has a pattern something like this:
PPPPPP_GG_DDDDDDDD_IIIIIIII.pdf
Where P = Project Number, G = Invoice Group, D = Date, and I = Invoice
Number
This query below works, and it returns all PDF documents in the Index
Server catalog for a given project number:
#Filename = 123456*.pdf
I tried adding a phrase for the invoice number, but this query didn't
work.
#Filename = 123456*.pdf and #Filename = *23232323*
Thank you for your help.
Bren