Be grateful if another set of eyes can spot why this has been causing me
grief all day - I think I've been looking at it too long is part of the
problem.
Have created 2 Verity collections (CF8) - one for data and one for docs.
Data one works fine.
No matter what I do the doccount for the document one is still zero. It's a
funny thing because I run the same script on another site (just different
table names) and it works fine. I've run the query on its own and it
correctly returns my two test rows but when I query the collection DOCCOUNT
is 0 and status reports 0 inserts. I've been dumping index_Docs as well and
that confirms two rows in the database. The collection is PURGED before any
other scripts run. I've confirmed that Application.TheDocumentPath has a
trailing \ as well. index_Docs.DocumentLibraryFileLocation is the file name.
<CFQUERY NAME="index_Docs" datasource="DSNAME"
username="USERNAME"
password="PASSWORD">
SELECT DocumentLibraryFileLocation, DocumentIsMember, Document_StateID,
DocumentLibraryTitle
FROM mydoclibrarytablename
WHERE (DocumentLibraryFileLocation <> '') AND
(DocumentLibraryAvailable = 1)
</CFQUERY>
<cfloop query="index_Docs">
<cfindex action="UPDATE"
collection="#Application.TheDocumentCollection#"
key="#Application.TheDocumentPath##index_Docs.DocumentLibraryFileLocation#"
type="FILE"
title="#index_Docs.DocumentLibraryTitle#"
urlpath="#Application.TheDocumentURL#"
extensions="pdf,ppt,xls,doc,rtf,txt,pps,docx"
custom1="#index_Docs.Document_StateID#"
custom2="false"
custom3="#index_Docs.DocumentIsMember#"
custom4=""
status="DocLibrary">
</cfloop>
Thank you!
++++++++++
Kevin Parker
Advanced Imaging
e: webmas...@advancedimaging.com.au
w: www.advancedimaging.com.au
m: 0418 815 527
++++++++++
http://au.linkedin.com/in/krparker
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349348
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
