RE: Verity Collection CF 9.0.1
Hi there. I haven't had that exact problem, but we have used verity a lot over the years. One thing that is typically helpful is looking at the various log files. Verity seems to have a lot of log files but here are some that I have noted over the years (note - these paths are from CF7 but perhaps they are similar in CF9): \CFusionMX7\verity\Data\services\ColdFusionK2_server1\log\status.log \CFusionMX7\verity\Data\services\ColdFusionK2_server1\diag\diag.log \CFusionMX7\verity\Data\services\ColdFusionK2_indexserver1\log\staus.log \CFusionMX7\verity\Data\services\ColdFusionK2_indexserver1\log\diag.log \CFusionMX7\verity\Data\host\log\audit.log \CFusionMX7\verity\Data\host\log\status.log Here is one from CF9 that I have used recently: E:\ColdFusion9\verity\Data\services\ColdFusionK2_indexserver1\log\status.log Hope that helps! Nick > -Original Message- > From: mikey graziano [mailto:mikey.grazi...@us.army.mil] > Sent: Monday, July 11, 2011 5:39 AM > To: cf-talk > Subject: Verity Collection CF 9.0.1 > > > In the ColdFusion Collection, I 'm trying to create a verity > collection. When I create the new collection it completes without > errors, but does not show up in the list of collections within my CF > Administrator. If I try to create it again, it tells me that the > collection already exists, but it still does not appear in the > administrator. I don't see any issues in the exception, application, or > server logs. Any suggestions on how to troubleshoot this issue? > > > ~| 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:346183 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Verity Collection CF 9.0.1
In the ColdFusion Collection, I 'm trying to create a verity collection. When I create the new collection it completes without errors, but does not show up in the list of collections within my CF Administrator. If I try to create it again, it tells me that the collection already exists, but it still does not appear in the administrator. I don't see any issues in the exception, application, or server logs. Any suggestions on how to troubleshoot this issue? ~| 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:346174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Verity Collection Coldfusion 9.0.1
In the ColdFusion Collection, I 'm trying to create a verity collection. When I create the new collection it completes without errors, but does not show up in the list of collections within my CF Administrator. If I try to create it again, it tells me that the collection already exists, but it still does not appear in the administrator. I don't see any issues in the exception, application, or server logs. Any suggestions on how to troubleshoot this issue? ~| 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:346173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Verity collection
I'm using cold fusion 8 enterprise, I have 34 collections and a couple of them are will not return correctly. here are two collection rmlicgpdsenglish 345 1,637 Mar 24 2011 1:55 PM english No rmlicgpdsfrench 174 1,163 Mar 24 2011 1:55 PM french No if you run this query; it will return the 174 french files if you run this query; this will also return the 174 french files This also happens with a couple more of the collections, I have deleted and recreated the collections,renamed the query, tried different types, any suggestions ~| 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:343251 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Updating a Verity Collection on a remote UNIX server
> It depends on how you catch the error. You may have to look in the > CFCATCH scope instead. If you have a Verity exception, you will be > able to read Verity-specific exception keys from the CFCATCH > structure. I'll take a look at that part Dave. Thanks for the input, appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320832 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updating a Verity Collection on a remote UNIX server
> Is there a reason why I can't seem to output error.diagnostics, > error.remoteAddress or > error.httpreferer when an error happens? I imagine it's because they don't > exist but I want > to add these values to either a cflog entry or email myself in my error > detail page. The > error.diagnostics is what I'm really looking for to examine my Verity > problems. It depends on how you catch the error. You may have to look in the CFCATCH scope instead. If you have a Verity exception, you will be able to read Verity-specific exception keys from the CFCATCH structure. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320830 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Updating a Verity Collection on a remote UNIX server
> Yes, if you catch and handle errors yourself, they won't be logged. > It's up to your error handler to log them. > Is there a reason why I can't seem to output error.diagnostics, error.remoteAddress or error.httpreferer when an error happens? I imagine it's because they don't exist but I want to add these values to either a cflog entry or email myself in my error detail page. The error.diagnostics is what I'm really looking for to examine my Verity problems. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320827 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Updating a Verity Collection on a remote UNIX server
> Strangely enough, they haven't been written to in some time. I'm using a > error catch page > in the CF Admin (Missing Template Handler & Site-Wide Error Handler) and in > that file I > email myself if error is defined. Would this cause the application.log & > exception.log files > to stop being used? I can't imagine it would but the time the logs stopped > being updated is > around the time I put in the error catch page. Yes, if you catch and handle errors yourself, they won't be logged. It's up to your error handler to log them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320826 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updating a Verity Collection on a remote UNIX server
> On Friday 20 Mar 2009, Joe None wrote: > > second or two and then nothing. What log file in UNIX should I be > looking > > in for this? > > CF's log files are always in the same place- cfroot/logs/*log > Strangely enough, they haven't been written to in some time. I'm using a error catch page in the CF Admin (Missing Template Handler & Site-Wide Error Handler) and in that file I email myself if error is defined. Would this cause the application.log & exception.log files to stop being used? I can't imagine it would but the time the logs stopped being updated is around the time I put in the error catch page. I have plans on setting up a virtual machine with Linux/Apache/CF so I can troubleshoot without having the limited access I do. But for now I'd like to get this Verity update working. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320824 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updating a Verity Collection on a remote UNIX server
Unless, of course, you have a custom install and they reside in a different location. ;-) On Mon, Mar 23, 2009 at 4:16 AM, Tom Chiverton wrote: > > CF's log files are always in the same place- cfroot/logs/*log > > -- > Tom Chiverton > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320823 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updating a Verity Collection on a remote UNIX server
On Friday 20 Mar 2009, Joe None wrote: > second or two and then nothing. What log file in UNIX should I be looking > in for this? CF's log files are always in the same place- cfroot/logs/*log -- Tom Chiverton Helping to dramatically orchestrate edge-of-your-seat distributed sticky infrastructures as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320822 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Updating a Verity Collection on a remote UNIX server
Hello, I've had a Verity Collection created on a UNIX server and because I don't have access to the CF Admin, I have to update the collection through code. Here's what I have so far (that doesn't seem to be working). I'm not seeing any error but its not refreshing either, just taking a second or two and then nothing. What log file in UNIX should I be looking in for this? I do have access to the server files so if I know where to look for an error, I can go from there. Thnx ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320775 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Verity Collection Corruption
I'm encounting 'vague' Verity-errors in an application that uses Verity alot. See earlier message: "I hava a couple of collections on a CF8-machine. Since a couple of months I regularly get the message "Error opening a workspace.: com.verity.organize.WorkSpaceOpenException: All available workers are allocated to open workspaces. Increase ODK Sync Threads to allow more active workspaces. [K2IdxErr_TooManyOpenWorkSpaces]". Most of the time an optimize collection does the trick and everything is back to normal; sometimes only a CF Search Service restart helps. I have tried to fiddle with the Verity-setting (although nog really fool-proof) of the ODK Sync Threads but kept getting this error. I don't have a clue what's creating this...Anyone had this before? Cant find anything on this errormessage. " I did re-enter the cflock exclusive on every update ad cflock readonly on all read-operations using the same cflock name for each collection. Uptonow the mentioned error has not returned...(knock on wood)...so for the moment I'm sticking to it. Bart ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Verity Collection Corruption
> What about if I'm doing updates. Do I need to lock my cfindex or is > CF8 smart enough to not try to concurrently update the collection if 2 > (or more) users hit the update button at the same time? My understanding is that Verity K2 is smart enough to handle that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Verity Collection Corruption
Dave, What about if I'm doing updates. Do I need to lock my cfindex or is CF8 smart enough to not try to concurrently update the collection if 2 (or more) users hit the update button at the same time? -Phi On Feb 3, 2009, at 8:00 AM, cf-talk wrote: > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318901 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Verity Collection Corruption
> I have a verity question. If I am actively updating Verity with > updates (cfindex action="update) and someone is searching the > collection as well, will that corrupt the collection? Do I need to > use cflock anytime I do an update? We've been having collection > corruptions and I'm trying to pinpoint all possibilities where it > might corrupt the collection. The current version of Verity should not have that problem. Older versions did, and the way I avoided that problem was to use two collections for the same set of data, and index one while allowing searches against the other. But again, I doubt that's the problem with Verity K2. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318656 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Verity Collection Corruption
Hi everyone, I have a verity question. If I am actively updating Verity with updates (cfindex action="update) and someone is searching the collection as well, will that corrupt the collection? Do I need to use cflock anytime I do an update? We've been having collection corruptions and I'm trying to pinpoint all possibilities where it might corrupt the collection. -Phi ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318632 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Verity Collection "Unable to create temporary file "
sounds like the user the CF server runs as needs write access to the Verity temp directory. I don't know what that directory is, but you should be able to find our from the dogs for you platform. cheers, barneyb On 8/30/08, Mike Kear <[EMAIL PROTECTED]> wrote: > I have a verity search faciaility on one of my sites, and we recently > moved the site to a new server box.Now, when i go to refresh the > indexes I get the following error: > > "Unable to create temporary file" > > And the error is pointing to the line containint the CFINDEX tag . > > I guess this is something to do with the permissions, but i'm not sure > what is needed - I had no such problem setting the search up on my dev > machine, nor on the previous box. I managed to use CFINDEX to delete > the collections, and to create them again programmatically, but this > error occurs when i go to populate the collections with data. > > What do i need to do ?(or perhaps i should ask, what do i need to > ask my Sysadmin to do?) > > -- > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311848 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Verity Collection "Unable to create temporary file "
I have a verity search faciaility on one of my sites, and we recently moved the site to a new server box.Now, when i go to refresh the indexes I get the following error: "Unable to create temporary file" And the error is pointing to the line containint the CFINDEX tag . I guess this is something to do with the permissions, but i'm not sure what is needed - I had no such problem setting the search up on my dev machine, nor on the previous box. I managed to use CFINDEX to delete the collections, and to create them again programmatically, but this error occurs when i go to populate the collections with data. What do i need to do ?(or perhaps i should ask, what do i need to ask my Sysadmin to do?) -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311847 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Verity Collection "Unable to create temporary file "
I have a verity search faciaility on one of my sites, and we recently moved the site to a new server box.Now, when i go to refresh the indexes I get the following error: "Unable to create temporary file" And the error is pointing to the line containint the CFINDEX tag . I guess this is something to do with the permissions, but i'm not sure what is needed - I had no such problem setting the search up on my dev machine, nor on the previous box. I managed to use CFINDEX to delete the collections, and to create them again programmatically, but this error occurs when i go to populate the collections with data. What do i need to do ?(or perhaps i should ask, what do i need to ask my Sysadmin to do?) -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311705 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How do I export a verity collection?
I hate verity, for so many reasons. Mostly because it's a pain to administer. I'm setting up some CF8 instances for our customers to start testing on, but I'm again having issues moving verity collections. Is there some secret that I'm missing when exporting verity collections? It looks like the CAR file save correctly, and it starts to restore correctly, but then it fails. Matthew Williams Geodesic GraFX ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307983 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query-based Verity collection with Ctegories?
I'm a bit late returning to this thread. You said that when you assigned cats, it assigned them to ALL the records in the collection. It looks as if when you pass a query to a collection, it does assign the cats to all the rows. So in order to assign different cats per row, you would need to run multiple CFINDEXes. You would NOT need multiple collections. So I'd simply do N queries based on category and add the data like so. If this was covered already in the thread, sorry - responding uqickly. On Mon, Apr 7, 2008 at 6:54 AM, Dominic Watson <[EMAIL PROTECTED]> wrote: > > > > However... the qoq started complaining about comparing integers to > > strings... I guess Verity search returns all data as strings... > > I had to CAST image_id column in db query as CHAR, and it started > > working... But... it that right? Should it be like that? > > I am worried that casting a column as char, and then comparing string > > values in the qoq might actually bring in a big overhead and make it > > slower than doing an IN () comparisson... Any thoughts? > -- === Raymond Camden, Camden Media Email : [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302872 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query-based Verity collection with Ctegories?
> > However... the qoq started complaining about comparing integers to > strings... I guess Verity search returns all data as strings... > I had to CAST image_id column in db query as CHAR, and it started > working... But... it that right? Should it be like that? > I am worried that casting a column as char, and then comparing string > values in the qoq might actually bring in a big overhead and make it > slower than doing an IN () comparisson... Any thoughts? That's odd, I've not had that problem, damn QoQ! Also, if you are wanting to maintain the order of the verity results the QoQ may still be neccessary / useful. Doing a DB select with the IN() clause will ignore the verity order. Sorry I can't help with the casting. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302836 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query-based Verity collection with Ctegories?
Thanks, Dominic, However... the qoq started complaining about comparing integers to strings... I guess Verity search returns all data as strings... I had to CAST image_id column in db query as CHAR, and it started working... But... it that right? Should it be like that? I am worried that casting a column as char, and then comparing string values in the qoq might actually bring in a big overhead and make it slower than doing an IN () comparisson... Any thoughts? Thanks, Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Dominic Watson wrote: >> for some reason your approach with filtering verity results with a qoq >> gives me an error: >> > > > Oh yeh, you must put it in square brackets as CF sees it as a keyword even > thought it is prefixed. Forgot about that. > > > SELECT * > FROM vSearch, dbSearch > WHERE vSearch.[key] = dbSearch.image_id > > > Dom > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302824 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query-based Verity collection with Ctegories?
> > for some reason your approach with filtering verity results with a qoq > gives me an error: Oh yeh, you must put it in square brackets as CF sees it as a keyword even thought it is prefixed. Forgot about that. SELECT * FROM vSearch, dbSearch WHERE vSearch.[key] = dbSearch.image_id Dom -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302807 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query-based Verity collection with Ctegories?
hi Dominic, for some reason your approach with filtering verity results with a qoq gives me an error: Query Of Queries syntax error. Encountered "vSearch key. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, my qoq is: SELECT * FROM vSearch, dbSearch WHERE vSearch.key = dbSearch.image_id if i switch the columns in the WHERE clause around (WHERE dbSearch.image_id = vSearch.key), i get error: Query Of Queries syntax error. Encountered "KEY. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, Unrecognized character in operand, the qoq syntax is fine, as it works fine with any other qoq... is it due to one query being Verity resultset? any ideas? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Dominic Watson wrote: > I second that. I have just done something similar although I found that when > lots of results were returned by the verity search, something like this far > out performed using an 'IN (keyList)' statement (even when the second query > returned a huge number of results): > > > "qVerityResults"> > > > *SELECT* * *FROM* tableX *WHERE* filters = #theFilters# > > > > *SELECT* qVerityResults.*, qDBFilterResults.* > *FROM* qVerityResults, qDBFilterResults > *WHERE* qVerityResults.*key* = qDBFilterResults.tableXId > > HTH > > Dominic > > > On 02/04/2008, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > >> I use Verity often (including in an education-oriented document management >> project that I'm working on), but have avoided categories...probably >> because >> of the lack of good documentation on their use. >> >> What I do is index documents with Verity, and have the [key] be the PK in >> a >> documents table in my database. I will then create any other tables that >> I >> need to further describe or categorize the data and use that to "refine" >> my >> verity search by excluding records as needed with an in/not in statement >> in >> my SQL. That's a very, very boiled down description of the approach I >> take, >> there does tend to be a lot more going on... >> >> Pete >> >> >> >> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302804 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query-based Verity collection with Ctegories?
Thanks Dominic, Good points. On to testing! Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Dominic Watson wrote: >> If your approach really outperforms the basic recommended IN () >> filtering, that's the way forward i guess! >> > > > I'd say do some tests with and without it with different numbers of > preliminary results from the verity search. There's very little difference > in the code; just an extra clause in the db query that filters out items not > in the verity results. You could even only include the clause if there is a > number of verity results below some threshold. I.e. > > > * SELECT* * *FROM* tableX *WHERE* filters = #theFilters# > > AND tableXId IN ( value="#ValueList(qVerityResults.key)#" list="true">) > > > > Of course, you'd only want to do this if you found that it performed better > with the IN () for a low number of preliminary results and performed worse > with the IN () for a higher number of preliminary results. Just fine tuning > really. > > > Dominic > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query-based Verity collection with Ctegories?
> > If your approach really outperforms the basic recommended IN () > filtering, that's the way forward i guess! I'd say do some tests with and without it with different numbers of preliminary results from the verity search. There's very little difference in the code; just an extra clause in the db query that filters out items not in the verity results. You could even only include the clause if there is a number of verity results below some threshold. I.e. * SELECT* * *FROM* tableX *WHERE* filters = #theFilters# AND tableXId IN () Of course, you'd only want to do this if you found that it performed better with the IN () for a low number of preliminary results and performed worse with the IN () for a higher number of preliminary results. Just fine tuning really. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302684 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query-based Verity collection with Ctegories?
oh, forgot to ask another question! can, and if yes then how, categoryTree argument be used with a db query-based collection? What's the advantage of defining categoryTree over not defining it? again, there is scarce info available on the subject... If a Verity-indexed photo is assigned facets->categories->keywords, and a category is defined for the assigned keywords, will categoryTree argument hold the parent facet and category for a keyword? how can that be used then in search or search results? thanks, Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Raymond Camden wrote: > On Tue, Apr 1, 2008 at 1:36 AM, Azadi Saryev <[EMAIL PROTECTED]> wrote: > >> 1) does a database query-based Verity collection support Categories? or >> is it supported only for document/directory based collections? >> > > Yes. Remember, to Verity, a collection is a collection. It doesn't > matter what 'seeds' it, whether you seed it with physical files, > database records, or peanut butter and chocolate. > > > >> 2) i am creating a collection and search interface for a multi-faceted >> photo database, where each photo has multiple facets, categories and >> keywords assigned to it. >> while i can create a collection that combines all the >> facets/categories/keywords in the collection's body (together with title >> and description), i think it will work better with facets and categories >> stored as collection/photo categories... >> > > Agreed. > > >> any thoughts/suggestions? >> > > Have you read the CF/Verity docs, specifically those covering how to > use categories? It is covered and you should begin there. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query-based Verity collection with Ctegories?
Pete, thanks for your insight. That's the way I was going to go initially, before I started wondering if I could use categories in a db query-based collection and if they will allow me to search photos of specific category only. As I said in answers to Dominic's and Ray's posts, categories do work, but not the way I thought they would... I guess I will g the usual way of doing full-text search with Verity and then filtering the db query resultset, which returns a lot more photo data than a Verity collection holds, with results returned from Verity search. I like Dominic's way of doing the filtering, which seems to outperform the IN/NOT IN () filtering... Cheers, Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Pete Ruckelshaus wrote: > I use Verity often (including in an education-oriented document management > project that I'm working on), but have avoided categories...probably because > of the lack of good documentation on their use. > > What I do is index documents with Verity, and have the [key] be the PK in a > documents table in my database. I will then create any other tables that I > need to further describe or categorize the data and use that to "refine" my > verity search by excluding records as needed with an in/not in statement in > my SQL. That's a very, very boiled down description of the approach I take, > there does tend to be a lot more going on... > > Pete > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302681 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query-based Verity collection with Ctegories?
Hi Ray, I appreciate your dropping in on the thread - love your blog! My doubt about support of categories for a db query-based collection was due to the lack of info on the subject. I did since find one direct reference on the subject in the CF8 Developers Guide. However, the categories in a collection do not work as I thought they would - they do not 'sort' the items in a collection by category, instead selected categories are just assigned to all items in a collection. So to be able to allow a user to search photos in selected categories only, i will have to create a separate collection for each category and then search multiple collections... Did I get that right? At least my tests have shown that that's how it works... Another question I thought you may be able to clarify for me: the Verity limit of 125,000 indexed documents on CF8 Standard - is that a limit per collection or for all collections combined? If it is a combined limit then I can easily run over it having multiple collections for each photo facet, category and keyword... Thanks, Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Raymond Camden wrote: > On Tue, Apr 1, 2008 at 1:36 AM, Azadi Saryev <[EMAIL PROTECTED]> wrote: > >> 1) does a database query-based Verity collection support Categories? or >> is it supported only for document/directory based collections? >> > > Yes. Remember, to Verity, a collection is a collection. It doesn't > matter what 'seeds' it, whether you seed it with physical files, > database records, or peanut butter and chocolate. > > > >> 2) i am creating a collection and search interface for a multi-faceted >> photo database, where each photo has multiple facets, categories and >> keywords assigned to it. >> while i can create a collection that combines all the >> facets/categories/keywords in the collection's body (together with title >> and description), i think it will work better with facets and categories >> stored as collection/photo categories... >> > > Agreed. > > >> any thoughts/suggestions? >> > > Have you read the CF/Verity docs, specifically those covering how to > use categories? It is covered and you should begin there. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query-based Verity collection with Ctegories?
Dominic, thanks for your tip. It looks interesting... So you basically perform a full-text search using Verity, and search for other 'filters' using db, and then filter the db-based search to return only results matched by Verity search, avoiding the IN () comparison. Did I get that right? That looks like the solution for me, as I will have to return a lot more data about each photo that a Verity collection can index... I have tried using Categories in a collection, and though categories are supported for db query-based collection, they do not work the way I though they would... Short of creating a separate collection for each possible facet-category-keyword combination, I can't achieve what I wanted with them... I thought having my b query group the records by, say, facet, and then having all facets listed as categories in the collection would 'sort' the collection by facets, but instead all the photos were assigned all the categories in the collection... If your approach really outperforms the basic recommended IN () filtering, that's the way forward i guess! Thanks for your input! Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Dominic Watson wrote: > I second that. I have just done something similar although I found that when > lots of results were returned by the verity search, something like this far > out performed using an 'IN (keyList)' statement (even when the second query > returned a huge number of results): > > > "qVerityResults"> > > > *SELECT* * *FROM* tableX *WHERE* filters = #theFilters# > > > > *SELECT* qVerityResults.*, qDBFilterResults.* > *FROM* qVerityResults, qDBFilterResults > *WHERE* qVerityResults.*key* = qDBFilterResults.tableXId > > HTH > > Dominic > > > On 02/04/2008, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > >> I use Verity often (including in an education-oriented document management >> project that I'm working on), but have avoided categories...probably >> because >> of the lack of good documentation on their use. >> >> What I do is index documents with Verity, and have the [key] be the PK in >> a >> documents table in my database. I will then create any other tables that >> I >> need to further describe or categorize the data and use that to "refine" >> my >> verity search by excluding records as needed with an in/not in statement >> in >> my SQL. That's a very, very boiled down description of the approach I >> take, >> there does tend to be a lot more going on... >> >> Pete >> >> >> >> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302679 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query-based Verity collection with Ctegories?
On Tue, Apr 1, 2008 at 1:36 AM, Azadi Saryev <[EMAIL PROTECTED]> wrote: > 1) does a database query-based Verity collection support Categories? or > is it supported only for document/directory based collections? Yes. Remember, to Verity, a collection is a collection. It doesn't matter what 'seeds' it, whether you seed it with physical files, database records, or peanut butter and chocolate. > 2) i am creating a collection and search interface for a multi-faceted > photo database, where each photo has multiple facets, categories and > keywords assigned to it. > while i can create a collection that combines all the > facets/categories/keywords in the collection's body (together with title > and description), i think it will work better with facets and categories > stored as collection/photo categories... Agreed. > > any thoughts/suggestions? Have you read the CF/Verity docs, specifically those covering how to use categories? It is covered and you should begin there. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302478 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query-based Verity collection with Ctegories?
I second that. I have just done something similar although I found that when lots of results were returned by the verity search, something like this far out performed using an 'IN (keyList)' statement (even when the second query returned a huge number of results): *SELECT* * *FROM* tableX *WHERE* filters = #theFilters# *SELECT* qVerityResults.*, qDBFilterResults.* *FROM* qVerityResults, qDBFilterResults *WHERE* qVerityResults.*key* = qDBFilterResults.tableXId HTH Dominic On 02/04/2008, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > I use Verity often (including in an education-oriented document management > project that I'm working on), but have avoided categories...probably > because > of the lack of good documentation on their use. > > What I do is index documents with Verity, and have the [key] be the PK in > a > documents table in my database. I will then create any other tables that > I > need to further describe or categorize the data and use that to "refine" > my > verity search by excluding records as needed with an in/not in statement > in > my SQL. That's a very, very boiled down description of the approach I > take, > there does tend to be a lot more going on... > > Pete > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query-based Verity collection with Ctegories?
I use Verity often (including in an education-oriented document management project that I'm working on), but have avoided categories...probably because of the lack of good documentation on their use. What I do is index documents with Verity, and have the [key] be the PK in a documents table in my database. I will then create any other tables that I need to further describe or categorize the data and use that to "refine" my verity search by excluding records as needed with an in/not in statement in my SQL. That's a very, very boiled down description of the approach I take, there does tend to be a lot more going on... Pete ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query-based Verity collection with Ctegories?
i guess nobody uses Verity? :) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
query-based Verity collection with Ctegories?
1) does a database query-based Verity collection support Categories? or is it supported only for document/directory based collections? 2) i am creating a collection and search interface for a multi-faceted photo database, where each photo has multiple facets, categories and keywords assigned to it. while i can create a collection that combines all the facets/categories/keywords in the collection's body (together with title and description), i think it will work better with facets and categories stored as collection/photo categories... i am using custom fields to store photo properties, photographer name and pre-set galleries a photo is assigned to, which takes up all 4 allowed custom fields... maybe someone has done something like this before and can share the insight?... here's the collection index code: the facets, cats, keywords and galleries are comma-delimited lists of each photo's facets, cats, keywords, galleries and their respective descriptions [created with mysql's group_concat() function - gotta love that thing!] for the prupose of being searchable for user-entered search phrase. any thoughts/suggestions? tia, -- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302409 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to Create a Verity Collection
I had the same issue, and for me it was the permissions problem. When I tried to create the collection the first time it gave me the same error you had, however it did create the directory I had setup for the Path. I compared that directory to the other collection directories and all the other collections had permissions of drwxr-xr-x (chmod 755), however this new collection had drwxr--r-- (chmod 744). I ran the command "chmod 755" on that directory, then went back to the CF Administrator and successfully created the collection. I'm not sure why it doesn't work correctly, since I use to be able to create collections without this problem. I've done several software upgrades to the server since the last collection creation, so my guess is that one of those upgrades jacked this up. I guess I'll live with it, until I (or someone) else comes across the real solution to this issue. > [CFMX 7 Multi-Server on Ubuntu Linux] > > I'm trying to create a collection from the CF Admin, but I'm getting: > > Unable to create collection testMe. > Unable to create collection testme. > An error occurred while creating the collection: com.verity.api. > administration.ConfigurationException: Fail to create the index. > (-6220) > > I'm not sure where to go from here... > > Thanks, > Jamie ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292451 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Complex Verity collection...
Since I seem to be on a string of questions that don't seem to have any answers from the list, I have found a solution for this problem. Hopefully, it will be useful to someone else, as it took me the better part of a day of brainstorming to come up with this solution. To recap, the problem is that I have two Verity collections, one for document data, the other for database data. If a document exists, it can also have a record in the database, but a record in the database doesn't necessarily have a document associated with it. The problem is that there are going to be duplicate results where a record exists in both collections. The solution (with code): First, index a document: Note that I set a value in "custom1" that is the PK of the documents table Now, index a database query: SELECT * FROM tblLessons WHERE intLessonID = 1 This is a test table, so there's only one record in it, with an ID of 1, which is also the value for "custom1" Now, search both collections: Since it's possible for a search term to show up in the document collection that doesn't show up in the database (and vice-versa), I created a list of custom1 values from the document collection to make sure there were no duplicate custom1 values in the final result: Now, using a UNION inside a Query of Queries, create a unified resultset that doesn't have any duplicate custom1 values: SELECT [custom1], [category], [key], [score], [size], [summary], [title], [type], [url] FROM search_doc UNION SELECT [custom1], [category], [key], [score], [size], [summary], [title], [type], [url] FROM search WHERE custom1 NOT IN () And that's it. Keep in mind that this is test code and has hardcoded values where there would normally be variables, and things like that, but this solved my original problem. From this resultset, I can create a result page that will link to the document's database page, which will also contain a link to the physical document itself. I hope this helps somebody out there, and I hope the code wasn't too difficult to follow. Considering the tortured path that this issue had me traveling down, I'm surprised at how simple the end solution actually is. Thanks Pete On 10/5/07, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > I'm building a document management application where I want to be able to > index BOTH binary document data (word, excel, powerpoint, rtf, PDF, > etc.) AND database data in the same collection; simply, a user can upload a > document, and when they upload the document, they can also save a variety of > data (title, author, keywords, etc.) to a related database table. However, > not all of the records in the database will have corresponding files (all > files will have database records). > > The issue is that when indexing database content, you generally use the PK > for the table as the "key" field in the collection when you use an "update" > action on the cfindex. However, when documenting files, the key gets set as > the physical file location that was indexed. This means that if I were to > add both document and database content to a collection, all of the document > records would have duplicate records (the database portion). I would like > to avoid this. > > Has anyone dealt with this problem, and if so, how did you proceed? What > I am thinking of doing is actually having two collections, a "temp" > collection that indexes ONLY the files, and the "real" collection that > indexes the databse; when a new record is created, I create the DB record in > the index from a DB resultset, then I index the file in the temp collection, > then I retrieve that files' record from the temp collection and update the > DB collection using the database primary key. Any flaws in this approach? > > Thanks > > Pete > ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290476 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Complex Verity collection...
I'm building a document management application where I want to be able to index BOTH binary document data (word, excel, powerpoint, rtf, PDF, etc.) AND database data in the same collection; simply, a user can upload a document, and when they upload the document, they can also save a variety of data (title, author, keywords, etc.) to a related database table. However, not all of the records in the database will have corresponding files (all files will have database records). The issue is that when indexing database content, you generally use the PK for the table as the "key" field in the collection when you use an "update" action on the cfindex. However, when documenting files, the key gets set as the physical file location that was indexed. This means that if I were to add both document and database content to a collection, all of the document records would have duplicate records (the database portion). I would like to avoid this. Has anyone dealt with this problem, and if so, how did you proceed? What I am thinking of doing is actually having two collections, a "temp" collection that indexes ONLY the files, and the "real" collection that indexes the databse; when a new record is created, I create the DB record in the index from a DB resultset, then I index the file in the temp collection, then I retrieve that files' record from the temp collection and update the DB collection using the database primary key. Any flaws in this approach? Thanks Pete ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Unable to Create a Verity Collection
[CFMX 7 Multi-Server on Ubuntu Linux] I'm trying to create a collection from the CF Admin, but I'm getting: Unable to create collection testMe. Unable to create collection testme. An error occurred while creating the collection: com.verity.api.administration.ConfigurationException: Fail to create the index. (-6220) I'm not sure where to go from here... Thanks, Jamie ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Extract document properties for verity collection
Is there a way to pull the title, category, and keyword fields from the properties of a document, and update a verity collection (storing the category associated with the document automatically) or store them along with the location in to a database? ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278735 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Exclude pages from Verity collection
I am extremely new to Verity searching - today is literally my first day. So there may be more graceful ways to solve this conundrum, but here's what I have... I have subdirectories called 'admin' and 'includes' that I do not want showing up in search results, so at the top of the search results page, I have: Seems to work great. Good luck, Josh Knopp AMS, Inc. >Hi all, > >I have just started to play with Verity on CF 4.52 (I have used htdig >before). I am not big fan of pages in the templates directory, as well as >custom tags being indexed. > >Is there a tag or, is it possble to use robots.txt, to exclude >pages/templates? > >I tried > >...but it didn't work. > >Any tips are welcome. Oh, by the way, this is what I used for the indexing: > >KEY="c:\htdocs\website" >ACTION="REFRESH" >TYPE="PATH" >URLPATH="http://www.website.com"; >EXTENSIONS=".htm, .html, .cfm, .pdf" >RECURSE="Yes" >LANGUAGE="English"> ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274035 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cannot Remove Verity Collection!
Well its early and Im not functioning 100% lol, I have cracked the problem, If you go into Admin Server: Start > Programs > Administrative Tools > Computer Management Look under Shared Folders > Open Files Cheers Jose On 11/10/06, Jose Diaz <[EMAIL PROTECTED]> wrote: > > Hello All, > > I have a verity collection which I have deleted via cfAdministrator, the > collection appears to be removed but when I check the file structure the > folders still remain, I have tried to manually remove the folder which has > worked in the past. > > However I keep getting a 'cannot delete file 0004.ddd' that this file > is still being used by another process. I have topped cf and the k2Server > service just incase either was still connected to it. > > Unfortunatly I still cannot remove the file, can anybody help? Why does > cfAdministrator not remove this directory structure when the cfAdministrator > shows it has been removed. > > Thanks in advance > > Jose Diaz > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259871 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Cannot Remove Verity Collection!
Hello All, I have a verity collection which I have deleted via cfAdministrator, the collection appears to be removed but when I check the file structure the folders still remain, I have tried to manually remove the folder which has worked in the past. However I keep getting a 'cannot delete file 0004.ddd' that this file is still being used by another process. I have topped cf and the k2Server service just incase either was still connected to it. Unfortunatly I still cannot remove the file, can anybody help? Why does cfAdministrator not remove this directory structure when the cfAdministrator shows it has been removed. Thanks in advance Jose Diaz ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259870 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Errors when adding a verity collection
No one else has run into this error? I'm just about to drop $500 for support from Macromedia but I'd really rather not if I don't have to. >I've just got CFMX7.1 installed on a fresh RedHat Enterprise 4 setup. > >When I go to add a verity collection, I get this error: > >Unable to create collection test. >Unable to create collection test. >An error occurred while creating the collection: >com.verity.api.administration.ConfigurationException: Failed to retrieve >style path. (-6044) > >I've checked and the style path does exist and is readable and writeable >by nobody (the user k2admin is running as). > >Any ideas? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232454 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Errors when adding a verity collection
I've just got CFMX7.1 installed on a fresh RedHat Enterprise 4 setup. When I go to add a verity collection, I get this error: Unable to create collection test. Unable to create collection test. An error occurred while creating the collection: com.verity.api.administration.ConfigurationException: Failed to retrieve style path. (-6044) I've checked and the style path does exist and is readable and writeable by nobody (the user k2admin is running as). Any ideas? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232190 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Detecting if a Verity Collection Exists in CFMX7...
It would be a hack, but check to see if the named collection's directory exists in your collection repository? You could also do something like do a cfcolleciton action="list" in your application.cfc's onApplicationStart and dump the query structure into the application scope, then do a QoQ when needed to see if the query exists. Just remember to add a record to that query object if you add a new collection. Pete On 1/12/06, Dan G. Switzer, II <[EMAIL PROTECTED]> wrote: > >admin API perhaps? > > It seems as if the admin may use the command. > I've got 64 collections on my box and this tag takes like 20 seconds to run. > It takes forever for the admin page to load. > > I looked on CFLIB.org for an existing UDF and found one, but it uses the > action as well--which takes way to long to run. > > What I did was re-write the UDF to the code at the bottom of this message. > What this code does is attempt to use to search a collection. > If an error is thrown that has the string "does not exist" then I return > false, otherwise the function returns true. > > This seems to runs much more efficiently in my tests. > > -Dan > > hint="This returns a yes/no value that checks for the existence of a named > collection."> > > > > > > > >name="SearchItems" >collection="#arguments.collection#" >type="explicit" >criteria="" >/> > > > > > > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229471 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Detecting if a Verity Collection Exists in CFMX7...
>admin API perhaps? It seems as if the admin may use the command. I've got 64 collections on my box and this tag takes like 20 seconds to run. It takes forever for the admin page to load. I looked on CFLIB.org for an existing UDF and found one, but it uses the action as well--which takes way to long to run. What I did was re-write the UDF to the code at the bottom of this message. What this code does is attempt to use to search a collection. If an error is thrown that has the string "does not exist" then I return false, otherwise the function returns true. This seems to runs much more efficiently in my tests. -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229375 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Detecting if a Verity Collection Exists in CFMX7...
admin API perhaps? john. On 1/12/06, Dan G. Switzer, II <[EMAIL PROTECTED]> wrote: > I'm need to detect if a collection exists and if it doesn't, then I need to > create the collection. > > In previous versions of CF, if you performed the action="create" /> on a collection it would throw an error. This meant you > could just wrap the code in a cftry and than use a cfcatch to skip > processing. > > In CFMX7 they've added a to retrieve all the > collections which you can use to see if a collection exists. The problem is, > is taking 20+ seconds to run--which is way too long. > > Is there a faster way to determine if a collection exists? I know I could > check for the directory, but this doesn't really confirm if the collection > is actually registered. > > -Dan > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229340 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Detecting if a Verity Collection Exists in CFMX7...
I'm need to detect if a collection exists and if it doesn't, then I need to create the collection. In previous versions of CF, if you performed the on a collection it would throw an error. This meant you could just wrap the code in a cftry and than use a cfcatch to skip processing. In CFMX7 they've added a to retrieve all the collections which you can use to see if a collection exists. The problem is, is taking 20+ seconds to run--which is way too long. Is there a faster way to determine if a collection exists? I know I could check for the directory, but this doesn't really confirm if the collection is actually registered. -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229329 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
error creating verity collection
Hi I get this error creating a verity collection in MX7 with hot fix 3 & windows XP An error occurred while creating the collection: com.verity.api.administration.ConfigurationException: Failed to retrieve style path. (-6044) Has anyone had this before or know what to do about it? Ta Seamus Seamus Campbell Boldacious WebDesign http://www.boldacious.com [EMAIL PROTECTED] ph 02 6297 4883 mob 0410 609 267 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213266 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Unable to create Verity Collection
nope, but I'm getting it now too! have tried uninstalled verity and reinstalling but no joy! On 4/15/05, Paul Wilson <[EMAIL PROTECTED]> wrote: > Every time I try and create a Verity Collection I get the following > error. > > Unable to create collection test. > Unable to create collection test. > An error occurred while creating the collection: > com.verity.api.administration.ConfigurationException: Failed to retrieve > style path. (-6044) > > I get the same error in the CFAdmin and using cfcollection > > Has anyone seen this before? > > using CFMX 7 Developer edition > > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209561 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Unable to create Verity Collection
Every time I try and create a Verity Collection I get the following error. Unable to create collection test. Unable to create collection test. An error occurred while creating the collection: com.verity.api.administration.ConfigurationException: Failed to retrieve style path. (-6044) I get the same error in the CFAdmin and using cfcollection Has anyone seen this before? using CFMX 7 Developer edition ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202956 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Verity Collection
gt; > > > > > > > > > And assuming I have found the information you looking for this would be the > > cfindex guess. > > > > > > > > SELECT itemName, itemDescription, itemKeywords, itemID, > > itemThumbnail, itemListPrice, itemLeaseNumber > > FROM tblItem, tblkItemStatus > > WHERE tblItem.itemStatusID = tblkItemStatus.itemStatusID > > AND tblkItemStatus.itemStatusMainID = 2 > > > > > > > > > collection="itemCollection" > > action="refresh" > > type="custom" > > body="itemName, itemDescription, itemKeywords, itemLeaseNumber" > > custom1="itemThumbnail" > > custom2="itemListPrice" > > key="itemID" > > title="itemName" > > query="getItems"> > > > subject="COLLECTION INDEXING" server="#MAIL_SERVER#"> > > FINISHED INDEXING THE ITEM QUERY > > > > > > > > > > > > > subject="COLLECTION INDEXING" server="#MAIL_SERVER#"> > > FINISHED OPTIMIZING THE ITEM COLLECTION > > > > > > > > > > > > At 02:29 PM 11/17/2004, you wrote: > > >can you post your cfindex tag code? oh, and your cfsearch code too. > > > > > >Doug > > > > > >On Wed, 17 Nov 2004 14:00:34 -0700, Jason Smith > > ><[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > Anyone out there real familiar with verity collections, I'm having > trouble > > > > getting one to index correctly. I'll give us many details as > possible if I > > > > left anything out just let me know. > > > > > > > > The server is a Coldfusion 6.1MX on a windows 2003 server. Now > myself I'm > > > > very new to cold fusion and just trying to learn more. I have setup > a few > > > > sites for customers but this is the first site that uses a verity > > > collection. > > > > > > > > Now on to the problem I have read a few resources that all point to > > > > creating the verity collection and then index the collection. Well > I called > > > > the previous hosting company they moved from to get the exact settings > > > > however the indexing of verity collections if not written down doesn't > > > > appear to be retrievable. So this is where I am stuck I have the > collection > > > > created. > > > > > > > > name itemcollection > > > > mapped yes > > > > online yes > > > > external no > > > > language english > > > > path c:\inetpub\mysite\admin\verity\collections\itemcollection > > > > > > > > Now for the indexing this is the problem I run into I'm assuming it > should > > > > be indexing the search directory since that is where all the items have > > > > created detail pages. File extensions since looking in that > directory there > > > > are mainly html pages with 2 cfm pages I'm assuming html pages are > the only > > > > things I want to index. > > > > > > > > path c:\inetpub\mysite\search > > > > return url http://www.mysite.com/search > > > > > > > > After I let it index the files and I go to the test search engine > and run a > > > > search the results are wrong, first off you can search for anything > and get > > > > a return of 100+ matches which is the company name not a product. Then > > > > checking the link of the result found I come across another problem. > > > > > > > > > > > > http://www.mysite.com/search/itemDetail_C:/Inetpub/mysite/search/itemSearch.html.html > > > > > > > > Every result has this as the url which obviously isn't correct. > > > > > > > > I have spent a few hours reviewing forums and reading posts, book > > > > information different things so far I have yet to find a fix for > this so if > > > > anyone can help I would greatly appreciate it. > > > > > > > > Jason Smith > > > > > > > > __ NOD32 1.924 (20041117) Information __ > > > > > > > > This message was checked by NOD32 antivirus system. > > > > http://www.nod32.com > > > > > > > > Web Your Business Inc., - located in Loveland, Colorado; serving > the World! > > > > http://www.webyourbusiness.com/ - & - > http://www.aaabusinesshosting.com/ > > > > Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655 > > > > > > > > > > > > > > > > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184762 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Verity Collection
custom2="itemListPrice" > key="itemID" > title="itemName" > query="getItems"> > subject="COLLECTION INDEXING" server="#MAIL_SERVER#"> > FINISHED INDEXING THE ITEM QUERY > > > > > > subject="COLLECTION INDEXING" server="#MAIL_SERVER#"> > FINISHED OPTIMIZING THE ITEM COLLECTION > > > > > > At 02:29 PM 11/17/2004, you wrote: > >can you post your cfindex tag code? oh, and your cfsearch code too. > > > >Doug > > > >On Wed, 17 Nov 2004 14:00:34 -0700, Jason Smith > ><[EMAIL PROTECTED]> wrote: > > > > > > > > > Anyone out there real familiar with verity collections, I'm having trouble > > > getting one to index correctly. I'll give us many details as possible if I > > > left anything out just let me know. > > > > > > The server is a Coldfusion 6.1MX on a windows 2003 server. Now myself I'm > > > very new to cold fusion and just trying to learn more. I have setup a few > > > sites for customers but this is the first site that uses a verity > > collection. > > > > > > Now on to the problem I have read a few resources that all point to > > > creating the verity collection and then index the collection. Well I > > > called > > > the previous hosting company they moved from to get the exact settings > > > however the indexing of verity collections if not written down doesn't > > > appear to be retrievable. So this is where I am stuck I have the > > > collection > > > created. > > > > > > name itemcollection > > > mapped yes > > > online yes > > > external no > > > language english > > > path c:\inetpub\mysite\admin\verity\collections\itemcollection > > > > > > Now for the indexing this is the problem I run into I'm assuming it should > > > be indexing the search directory since that is where all the items have > > > created detail pages. File extensions since looking in that directory > > > there > > > are mainly html pages with 2 cfm pages I'm assuming html pages are the > > > only > > > things I want to index. > > > > > > path c:\inetpub\mysite\search > > > return url http://www.mysite.com/search > > > > > > After I let it index the files and I go to the test search engine and run > > > a > > > search the results are wrong, first off you can search for anything and > > > get > > > a return of 100+ matches which is the company name not a product. Then > > > checking the link of the result found I come across another problem. > > > > > > > > http://www.mysite.com/search/itemDetail_C:/Inetpub/mysite/search/itemSearch.html.html > > > > > > Every result has this as the url which obviously isn't correct. > > > > > > I have spent a few hours reviewing forums and reading posts, book > > > information different things so far I have yet to find a fix for this so > > > if > > > anyone can help I would greatly appreciate it. > > > > > > Jason Smith > > > > > > __ NOD32 1.924 (20041117) Information __ > > > > > > This message was checked by NOD32 antivirus system. > > > http://www.nod32.com > > > > > > Web Your Business Inc., - located in Loveland, Colorado; serving the > > > World! > > > http://www.webyourbusiness.com/ - & - http://www.aaabusinesshosting.com/ > > > Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655 > > > > > > > > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184694 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Verity Collection
The original developer of this web site made a serious mess, I'm still looking for certain files to make changes I personally have never seen a web site with so many useless files in so many locations but as I said I'm new to cold fusion so if you can point me in the direction of what file is most likely to contain the information you need it would help tremendously. Now like I said I have done some things with different cold fusion sites however this is the first cf application I have seen that does not use a global file for anything it would appear he puts all code in every file. Plain and simple the entire application needs a rewrite but I'm really not sure where all strings are that you might need to see. As far as I can tell this is the search info you might be looking for. EXACT MATCHES FOR '#UCASE(exactSearch)#'. #mySearchQuery.recordCount# Matching Items ]*>", "", "ALL")> #exactSearch#", "ALL")> #iCount#. #MySearchQuery.Title# #DollarFormat(mySearchQuery.custom2)# #searchSummary# (#Round(score * 100)#% Match) THERE WERE NO EXACT MATCHES FOR '#UCASE(exactSearch)#'. And assuming I have found the information you looking for this would be the cfindex guess. SELECT itemName, itemDescription, itemKeywords, itemID, itemThumbnail, itemListPrice, itemLeaseNumber FROM tblItem, tblkItemStatus WHERE tblItem.itemStatusID = tblkItemStatus.itemStatusID AND tblkItemStatus.itemStatusMainID = 2 FINISHED INDEXING THE ITEM QUERY FINISHED OPTIMIZING THE ITEM COLLECTION At 02:29 PM 11/17/2004, you wrote: >can you post your cfindex tag code? oh, and your cfsearch code too. > >Doug > >On Wed, 17 Nov 2004 14:00:34 -0700, Jason Smith ><[EMAIL PROTECTED]> wrote: > > > > > > Anyone out there real familiar with verity collections, I'm having trouble > > getting one to index correctly. I'll give us many details as possible if I > > left anything out just let me know. > > > > The server is a Coldfusion 6.1MX on a windows 2003 server. Now myself I'm > > very new to cold fusion and just trying to learn more. I have setup a few > > sites for customers but this is the first site that uses a verity > collection. > > > > Now on to the problem I have read a few resources that all point to > > creating the verity collection and then index the collection. Well I called > > the previous hosting company they moved from to get the exact settings > > however the indexing of verity collections if not written down doesn't > > appear to be retrievable. So this is where I am stuck I have the collection > > created. > > > > name itemcollection > > mapped yes > > online yes > > external no > > language english > > path c:\inetpub\mysite\admin\verity\collections\itemcollection > > > > Now for the indexing this is the problem I run into I'm assuming it should > > be indexing the search directory since that is where all the items have > > created detail pages. File extensions since looking in that directory there > > are mainly html pages with 2 cfm pages I'm assuming html pages are the only > > things I want to index. > > > > path c:\inetpub\mysite\search > > return url http://www.mysite.com/search > > > > After I let it index the files and I go to the test search engine and run a > > search the results are wrong, first off you can search for anything and get > > a return of 100+ matches which is the company name not a product. Then > > checking the link of the result found I come across another problem. > > > > > http://www.mysite.com/search/itemDetail_C:/Inetpub/mysite/search/itemSearch.html.html > > > > Every result has this as the url which obviously isn't correct. > > > > I have spent a few hours reviewi
Re: Verity Collection
can you post your cfindex tag code? oh, and your cfsearch code too. Doug On Wed, 17 Nov 2004 14:00:34 -0700, Jason Smith <[EMAIL PROTECTED]> wrote: > > > Anyone out there real familiar with verity collections, I'm having trouble > getting one to index correctly. I'll give us many details as possible if I > left anything out just let me know. > > The server is a Coldfusion 6.1MX on a windows 2003 server. Now myself I'm > very new to cold fusion and just trying to learn more. I have setup a few > sites for customers but this is the first site that uses a verity collection. > > Now on to the problem I have read a few resources that all point to > creating the verity collection and then index the collection. Well I called > the previous hosting company they moved from to get the exact settings > however the indexing of verity collections if not written down doesn't > appear to be retrievable. So this is where I am stuck I have the collection > created. > > name itemcollection > mapped yes > online yes > external no > language english > path c:\inetpub\mysite\admin\verity\collections\itemcollection > > Now for the indexing this is the problem I run into I'm assuming it should > be indexing the search directory since that is where all the items have > created detail pages. File extensions since looking in that directory there > are mainly html pages with 2 cfm pages I'm assuming html pages are the only > things I want to index. > > path c:\inetpub\mysite\search > return url http://www.mysite.com/search > > After I let it index the files and I go to the test search engine and run a > search the results are wrong, first off you can search for anything and get > a return of 100+ matches which is the company name not a product. Then > checking the link of the result found I come across another problem. > > http://www.mysite.com/search/itemDetail_C:/Inetpub/mysite/search/itemSearch.html.html > > Every result has this as the url which obviously isn't correct. > > I have spent a few hours reviewing forums and reading posts, book > information different things so far I have yet to find a fix for this so if > anyone can help I would greatly appreciate it. > > Jason Smith > > __ NOD32 1.924 (20041117) Information __ > > This message was checked by NOD32 antivirus system. > http://www.nod32.com > > Web Your Business Inc., - located in Loveland, Colorado; serving the World! > http://www.webyourbusiness.com/ - & - http://www.aaabusinesshosting.com/ > Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655 > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184670 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Verity Collection
Anyone out there real familiar with verity collections, I'm having trouble getting one to index correctly. I'll give us many details as possible if I left anything out just let me know. The server is a Coldfusion 6.1MX on a windows 2003 server. Now myself I'm very new to cold fusion and just trying to learn more. I have setup a few sites for customers but this is the first site that uses a verity collection. Now on to the problem I have read a few resources that all point to creating the verity collection and then index the collection. Well I called the previous hosting company they moved from to get the exact settings however the indexing of verity collections if not written down doesn't appear to be retrievable. So this is where I am stuck I have the collection created. name itemcollection mapped yes online yes external no language english path c:\inetpub\mysite\admin\verity\collections\itemcollection Now for the indexing this is the problem I run into I'm assuming it should be indexing the search directory since that is where all the items have created detail pages. File extensions since looking in that directory there are mainly html pages with 2 cfm pages I'm assuming html pages are the only things I want to index. path c:\inetpub\mysite\search return url http://www.mysite.com/search After I let it index the files and I go to the test search engine and run a search the results are wrong, first off you can search for anything and get a return of 100+ matches which is the company name not a product. Then checking the link of the result found I come across another problem. http://www.mysite.com/search/itemDetail_C:/Inetpub/mysite/search/itemSearch.html.html Every result has this as the url which obviously isn't correct. I have spent a few hours reviewing forums and reading posts, book information different things so far I have yet to find a fix for this so if anyone can help I would greatly appreciate it. Jason Smith __ NOD32 1.924 (20041117) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com Web Your Business Inc., - located in Loveland, Colorado; serving the World! http://www.webyourbusiness.com/ - & - http://www.aaabusinesshosting.com/ Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184662 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Deleting a Verity Collection (K2-Related Problem)
> I use cfexecute to run a script that stops the k2 service, > then use cf to delete the collection, and then use another > script to restart the service. It sucks but it works most of > the time (but not 100%). If it's a K2 collection, there's probably a command-line tool to let you delete the collection. Unfortunately, I'm not fully familiar with all the command-line tools that come with K2, but you might want to poke around in the appropriate directory to see what's there. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Deleting a Verity Collection (K2-Related Problem)
I use cfexecute to run a script that stops the k2 service, then use cf to delete the collection, and then use another script to restart the service. It sucks but it works most of the time (but not 100%). Mark -Original Message- From: Chris Berg [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 10:18 AM To: CF-Talk Subject: Re: Deleting a Verity Collection (K2-Related Problem) I can delete the directory manually on the server without rebooting it or stopping the service, but I am unable to delete it programmatically, this is where my problem lies. I need to be able to delete the collection programmatically with no backend intervention. Thanks for the ideas. This makes me think about the lock file. In the collection a file named collectn.lck exists...but when I delete it manually, the collection still throws an error when I try to delete it via . Any more ideas? Thanks again. Chris >I've not used K2, but... > >In Verity on Windows, I've seen problems where a file gets locked by a >CF thread and then is never released. Therefore, it can't be deleted. >Rebooting the box fixes it for me, though there may be a less drastic >solution. > >Once you've unlocked the file, you can delete the files manually (since >the registration should have been removed). > >--Ben > >Chris Berg wrote: > >> _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Deleting a Verity Collection (K2-Related Problem)
Was the collection created programmatically? I'm guessing it was, but it never hurts to ask --Ben Chris Berg wrote: > I can delete the directory manually on the server without rebooting it > or stopping the service, but I am unable to delete it programmatically, > this is where my problem lies. I need to be able to delete the > collection programmatically with no backend intervention. > > Thanks for the ideas. This makes me think about the lock file. In the > collection a file named collectn.lck exists...but when I delete it > manually, the collection still throws an error when I try to delete it > via . > > Any more ideas? Thanks again. > > Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Deleting a Verity Collection (K2-Related Problem)
I can delete the directory manually on the server without rebooting it or stopping the service, but I am unable to delete it programmatically, this is where my problem lies. I need to be able to delete the collection programmatically with no backend intervention. Thanks for the ideas. This makes me think about the lock file. In the collection a file named collectn.lck exists...but when I delete it manually, the collection still throws an error when I try to delete it via . Any more ideas? Thanks again. Chris >I've not used K2, but... > >In Verity on Windows, I've seen problems where a file gets locked by a >CF thread and then is never released. Therefore, it can't be deleted. >Rebooting the box fixes it for me, though there may be a less drastic >solution. > >Once you've unlocked the file, you can delete the files manually (since >the registration should have been removed). > >--Ben > >Chris Berg wrote: > >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Deleting a Verity Collection (K2-Related Problem)
I can delete the directory manually on the server without rebooting it or stopping the service, but I am unable to delete it programmatically, this is where my problem lies. I need to be able to delete the collection programmatically with no backend intervention. Thanks for the ideas. This makes me think about the lock file. In the collection a file named collectn.lck exists...but when I delete it manually, the collection still throws an error when I try to delete it via . Any more ideas? Thanks again. Chris >I've not used K2, but... > >In Verity on Windows, I've seen problems where a file gets locked by a >CF thread and then is never released. Therefore, it can't be deleted. >Rebooting the box fixes it for me, though there may be a less drastic >solution. > >Once you've unlocked the file, you can delete the files manually (since >the registration should have been removed). > >--Ben > >Chris Berg wrote: > >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Deleting a Verity Collection (K2-Related Problem)
Try stopping both K2 and the Cold Fusion Application service. -Original Message- From: Chris Berg [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 9:48 AM To: CF-Talk Subject: Deleting a Verity Collection (K2-Related Problem) Hello, I am having a problem deleting a collection via . This collection was created by CF and is not external to it. It has an entry in the K2server.ini file for Verity K2, but when I go to run the delete, I get an error: Could not delete the contents of the collection directory [C:\KMS_Verity\KMS_VTC\VTC_UC\custom]. I have no idea why. I am stopping the K2 Service first, but it still fails. Here is the code from my fbx_switch: The relevant entries would a act_AA_K2Entry.cfm, which removes the collection entries from K2server.ini, the K2ServiceControl function call, and the file act_AA_DeleteCollection. Any ideas as to why I cannot delete? TIA for any help. Chris _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Deleting a Verity Collection (K2-Related Problem)
I've not used K2, but... In Verity on Windows, I've seen problems where a file gets locked by a CF thread and then is never released. Therefore, it can't be deleted. Rebooting the box fixes it for me, though there may be a less drastic solution. Once you've unlocked the file, you can delete the files manually (since the registration should have been removed). --Ben Chris Berg wrote: > Hello, > > I am having a problem deleting a collection via . This > collection was created by CF and is not external to it. It has an entry > in the K2server.ini file for Verity K2, but when I go to run the delete, > I get an error: Could not delete the contents of the collection > directory [C:\KMS_Verity\KMS_VTC\VTC_UC\custom]. > > I have no idea why. I am stopping the K2 Service first, but it still > fails. Here is the code from my fbx_switch: > > > > > > > > > > > > > > The relevant entries would a act_AA_K2Entry.cfm, which removes the > collection entries from K2server.ini, the K2ServiceControl function > call, and the file act_AA_DeleteCollection. > > Any ideas as to why I cannot delete? > > TIA for any help. > > Chris > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Deleting a Verity Collection (K2-Related Problem)
Hello, I am having a problem deleting a collection via . This collection was created by CF and is not external to it. It has an entry in the K2server.ini file for Verity K2, but when I go to run the delete, I get an error: Could not delete the contents of the collection directory [C:\KMS_Verity\KMS_VTC\VTC_UC\custom]. I have no idea why. I am stopping the K2 Service first, but it still fails. Here is the code from my fbx_switch: The relevant entries would a act_AA_K2Entry.cfm, which removes the collection entries from K2server.ini, the K2ServiceControl function call, and the file act_AA_DeleteCollection. Any ideas as to why I cannot delete? TIA for any help. Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Index Verity Collection - cannot load style.ddd
Your first problem was following ANYTHING I said. =) This .ddd file needs to be in a couple of places. It needs to be in your collection folder. If you are using a CFCOLLECTION created collection, it is probably needed in the collection root\files\styles subfolder. If it is an exteranally created collection that you are calling with the external switch, it should be in the collection root\styles folder It also needs to be in your cf default folder, so that new collections also pick it up when created. (Probably in both the root\styles and root\files\styles (This is normally found in cfusionMX\lib\common\style and cfusionmx\lib\common\style\files) If you are not using CFCOLLECTION to create your collections, but instead are using the sdk (vspider or walker or mkvdk) it must be in the folder specified on the command line call that creates the collection. If you are sure it is in all the places it should be, can you send me the error you are getting, and the call you are making to get it? Jerry Johnson >>> [EMAIL PROTECTED] 05/11/04 06:30PM >>> I'm also having this problem. I followed what Jerry said: I had already created the collection so I made sure the style.ddd file was in cfusionmx\verity\collections\COLLECTIONNAME\file\style it wasn't there, but it was in cfusionmx\verity\collections\COLLECTIONNAME\style well, now it's in both, but I'm still getting the same error. Any thoughts? Thanks in advance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Index Verity Collection - cannot load style.ddd
I'm also having this problem. I followed what Jerry said: I had already created the collection so I made sure the style.ddd file was in cfusionmx\verity\collections\COLLECTIONNAME\file\style it wasn't there, but it was in cfusionmx\verity\collections\COLLECTIONNAME\style well, now it's in both, but I'm still getting the same error. Any thoughts? Thanks in advance. --Tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Index Verity Collection - cannot load style.ddd
I'm indexing using the cfindex tag... There is a style.ddd in the default directory(cfusionmx\lib\common\style and cfusionmx\lib\common\style\file) and all the commom files get copied to the collections style folder when I create a new collection. The style.ddd is the original and looks like this: # $Id: style.ddd,v 2.10 1998/06/30 18:10:35 georgep Exp $ # Copyright (C) 1987-1996 Verity, Inc. # # Document Dataset Descriptor # # DO NOT add user fields to this file - add them to style.ufl # which is included at the end of this file. $control: 1 $include style.prm $subst: 1 descriptor: /collection = yes { # Header information for partition management data-table: _df /num-records = 1 /max-records = 1 { worm: _DBVERSION text fixwidth: _DDDSTAMP 4 date varwidth: _DOCIDX _dv fixwidth: _DOCIDX_OF 4 unsigned-integer fixwidth: _DOCIDX_SZ 3 unsigned-integer fixwidth: _PARTDESC 32 text constant: _FtrCfg text "${DOC-FEATURES:}" constant: _SumCfg text "${DOC-SUMMARIES:}" fixwidth: _SPARE1 16 text fixwidth: _SPARE2 4 signed-integer } # Required internal fields per document data-table: _df /offset = 64 { autoval: _STYLE sirepath fixwidth: _DOCID 4 unsigned-integer fixwidth: _SECURITY 4 unsigned-integer /minmax = yes fixwidth: _INDEX_DATE 4 date /minmax = yes } $ifdef DOC-FEATURES # Optional feature vector per document data-table: _dg { varwidth: VDKFEATURES _dh /_implied_size } $endif $ifdef DOC-SUMMARIES # Optional generated summary per document data-table: _di { varwidth: VDKSUMMARY _dj /_implied_size } $endif data-table: _dk { dispatch: DOC varwidth: DOC_FN _dl } # [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Index Verity Collection - cannot load style.ddd
How are you creating the index? Are you using the cold fusion cfindex tag, or are you using the vdkmk utility? (Or vspider or other indexer?) I am asking this because this will tell me where to have you look for the verity style files. If you are using cfmx and the cfindex tag, and are creating a new colection, it will grab the default styles and use them to create the new collection. the styles should be in: cfusionmx\lib\common\style and cfusionmx\lib\common\style\file If you have already created the collection, the style files will be stored where the collection itself lives. If you are using the defaults, this will be in cfusionmx\verity\collections\COLLECTIONNAME\file\style Check to make sure you have a style.ddd file in each of the above folders. If not, you need to put one in there. HTH Jerry Johnson >>> [EMAIL PROTECTED] 03/11/04 03:43PM >>> Hi, I'm trying to index a collection but I'm getting the error: Error E3-0036 (VDK): Cannot load style.ddd schema (document catalog) in collection :\cfusionmx\verity\collections\querySearchB8CA8333-E07D-D6CD-BD0AC50D3F301B9 4\custom I've googled all around but I couldn't find anything... Verity support team says that "Verity does not have access to the exact integration format, therefore your request for further information regarding the specifics must go to the application vendor" any ideas? _ Fabio Nunes - NAVITA Diretor de Engenharia de Software Fone: 55 48 225-5396 Celular: 55 48 9119-9918 http://www.navita.com.br [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Index Verity Collection - cannot load style.ddd
Hi, I'm trying to index a collection but I'm getting the error: Error E3-0036 (VDK): Cannot load style.ddd schema (document catalog) in collection :\cfusionmx\verity\collections\querySearchB8CA8333-E07D-D6CD-BD0AC50D3F301B9 4\custom I've googled all around but I couldn't find anything... Verity support team says that "Verity does not have access to the exact integration format, therefore your request for further information regarding the specifics must go to the application vendor" any ideas? _ Fabio Nunes - NAVITA Diretor de Engenharia de Software Fone: 55 48 225-5396 Celular: 55 48 9119-9918 http://www.navita.com.br [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Why Can't I Delete a Verity Collection
[CF5, VerityK2, Win2K] When a Verity collection gets corrupted, sometimes it's quite hard to delete the collection directory from c:\cfusion\verity\collections. It claims that the directory is in use by another process. Which process is using this directory? I've stopped the CF Application Service and tried to delete. Same with the Verity K2 service. I've also tried deleting the collection using the CF Admin and CFCOLLECTION delete tag. I've killed all vspider jobs. I've even deleted the collection's registry entry. So, what can I do to reliably delete a corrupted collection, short of a reboot? Thanks, Jamie P.S. Is there any way in windows to see who or which process is tying up a file? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Verity collection
title="Titlee" query="qryActive" body="What do you want to search on" custom1="Whatever else you what to return" custom2="One more return variable"> -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 8:57 AM To: CF-Talk Subject: CF Verity collection Anyone out there have CF code that updates a Verity collection. I would like to run it manually occasionally and have it update all my collections. When I go through the Admin it takes too long and it seems that it I have to delete the collection and then re-instate it in order for it to display the updated pages I added to our web server. Thanks. Roberto HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF Verity collection
Anyone out there have CF code that updates a Verity collection. I would like to run it manually occasionally and have it update all my collections. When I go through the Admin it takes too long and it seems that it I have to delete the collection and then re-instate it in order for it to display the updated pages I added to our web server. Thanks. Roberto HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cf 5 verity collection question
does anyone know if verity can index mp3 files? I've tried adding .mp3 in , but it only indexes the .doc. What am I doing wrong? Thanks! - Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cf 5 verity collection question
I'm pretty sure mp3 is NOT a format Verity (at least the version in CF) supports. However, you can find _numerous_ Java classes out there that parse mp3s files. Do what I did - parse em all and store the results in a db. That's how I found out I have over 700 hours of music. -shudder- === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Xavier Vanvlasselaer [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 05, 2003 3:22 PM > To: CF-Talk > Subject: cf 5 verity collection question > > > does anyone know if verity can index mp3 files? I've tried > adding .mp3 in , > but it only indexes the .doc. What am I doing wrong? > > Thanks! > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: updating large verity collection
A good start would be to view the estimated execution plan in query analyzer... It'll show which index you're using on that query... Chances are it's not the right query. Make sure it isn't doing a table scan... That's usually what slows it down... -Original Message- From: Jared Clinton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 4:21 PM To: CF-Talk Subject: RE: updating large verity collection The query is probably running slowly because you dont have the appropriate indexes defined and applied. Look up how to manage indexes correctly in sql server books online, its worthwhile. -Jared Clinton. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 22 January 2003 11:09 AM To: CF-Talk Subject: updating large verity collection So how do you guys handle updating very large collections? >From a query (I'm using MSSQL Server). CF 5.0 As I understand it, I can update incrementally, without overwriting the previous updates, but I'm not sure how to do it. CFQUERY has a Maxrows attribute, but apparently not a startrow/endrow pair. I thought I would try something like this: SELECT ARCHIVE_ID blah, blah, blah, FROM table WHERE ARCHIVE_ID BETWEEN 1 and 1 i.e. "between #form.startrow# and #form.endrow# But in query analyizer, this query takes FOREVER to run. What are my other options? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: updating large verity collection
Okay, Then get 2000 rows, use the cfindex tag with action=update query=my2000rows then do a cflocation to the same script starting at row 2001 remember to exclusively lock all access to the verity collection while you are updating it, because not doing so will cause it to corrupt. Does this help? -Jared Clinton. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 22 January 2003 12:15 PM To: CF-Talk Subject: RE: updating large verity collection Look, it's tuned, it's optimized, it's indexed. I'm not asking how to run this query better ... I'm asking for other options. If I want, I can select 2,000 rows (5 seconds to run this query) at a time with this query, but that's rather ridiculous to contemplate when this database reaches 100,000 rows (though before then I'll probably need to break thing up into separate collections). I need something that can update Verity 10,000 rows at a time (or hell, maybe even only 5,000 rows), at least. Surely, somebody has dealt with this problem before and has some suggestions. H. > -Original Message- > From: Jared Clinton [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, January 21, 2003 4:59 PM > To: CF-Talk > Subject: RE: updating large verity collection > > Try using the index tuning wizard (you can find it in query analyzer), or > if > you have a DBA ask them for some advice. > Reduce the number of columns returned to minimum neccesary. > > > -Original Message- > From: Owens, Howard [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 22 January 2003 11:45 AM > To: CF-Talk > Subject: RE: updating large verity collection > > > I have an index on the column ... the query is still taking more than > minute > (I never let it run longer, cause there's no point) to run. I'm not > surprised, it looks like an expensive query since it is, as I understand > it, like running 10,000 different one-item look ups. > > So I still need an answer -- and I'm looking every where on the Web for it > to ... how do I break up the update of my verity collection update into > managable chunks? > > H. > > > > > -Original Message- > > From: Jared Clinton [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, January 21, 2003 4:21 PM > > To: CF-Talk > > Subject:RE: updating large verity collection > > > > The query is probably running slowly because you dont have the > appropriate > > indexes defined and applied. > > > > Look up how to manage indexes correctly in sql server books online, its > > worthwhile. > > > > -Jared Clinton. > > > > -Original Message- > > From: Owens, Howard [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, 22 January 2003 11:09 AM > > To: CF-Talk > > Subject: updating large verity collection > > > > > > So how do you guys handle updating very large collections? > > > > From a query (I'm using MSSQL Server). > > > > CF 5.0 > > > > As I understand it, I can update incrementally, without overwriting the > > previous updates, but I'm not sure how to do it. > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: updating large verity collection
Look, it's tuned, it's optimized, it's indexed. I'm not asking how to run this query better ... I'm asking for other options. If I want, I can select 2,000 rows (5 seconds to run this query) at a time with this query, but that's rather ridiculous to contemplate when this database reaches 100,000 rows (though before then I'll probably need to break thing up into separate collections). I need something that can update Verity 10,000 rows at a time (or hell, maybe even only 5,000 rows), at least. Surely, somebody has dealt with this problem before and has some suggestions. H. > -Original Message- > From: Jared Clinton [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, January 21, 2003 4:59 PM > To: CF-Talk > Subject: RE: updating large verity collection > > Try using the index tuning wizard (you can find it in query analyzer), or > if > you have a DBA ask them for some advice. > Reduce the number of columns returned to minimum neccesary. > > > -Original Message- > From: Owens, Howard [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 22 January 2003 11:45 AM > To: CF-Talk > Subject: RE: updating large verity collection > > > I have an index on the column ... the query is still taking more than > minute > (I never let it run longer, cause there's no point) to run. I'm not > surprised, it looks like an expensive query since it is, as I understand > it, like running 10,000 different one-item look ups. > > So I still need an answer -- and I'm looking every where on the Web for it > to ... how do I break up the update of my verity collection update into > managable chunks? > > H. > > > > > -Original Message- > > From: Jared Clinton [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, January 21, 2003 4:21 PM > > To: CF-Talk > > Subject:RE: updating large verity collection > > > > The query is probably running slowly because you dont have the > appropriate > > indexes defined and applied. > > > > Look up how to manage indexes correctly in sql server books online, its > > worthwhile. > > > > -Jared Clinton. > > > > -Original Message- > > From: Owens, Howard [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, 22 January 2003 11:09 AM > > To: CF-Talk > > Subject: updating large verity collection > > > > > > So how do you guys handle updating very large collections? > > > > From a query (I'm using MSSQL Server). > > > > CF 5.0 > > > > As I understand it, I can update incrementally, without overwriting the > > previous updates, but I'm not sure how to do it. > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: updating large verity collection
Try using the index tuning wizard (you can find it in query analyzer), or if you have a DBA ask them for some advice. Reduce the number of columns returned to minimum neccesary. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 22 January 2003 11:45 AM To: CF-Talk Subject: RE: updating large verity collection I have an index on the column ... the query is still taking more than minute (I never let it run longer, cause there's no point) to run. I'm not surprised, it looks like an expensive query since it is, as I understand it, like running 10,000 different one-item look ups. So I still need an answer -- and I'm looking every where on the Web for it to ... how do I break up the update of my verity collection update into managable chunks? H. > -Original Message- > From: Jared Clinton [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, January 21, 2003 4:21 PM > To: CF-Talk > Subject: RE: updating large verity collection > > The query is probably running slowly because you dont have the appropriate > indexes defined and applied. > > Look up how to manage indexes correctly in sql server books online, its > worthwhile. > > -Jared Clinton. > > -Original Message- > From: Owens, Howard [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 22 January 2003 11:09 AM > To: CF-Talk > Subject: updating large verity collection > > > So how do you guys handle updating very large collections? > > From a query (I'm using MSSQL Server). > > CF 5.0 > > As I understand it, I can update incrementally, without overwriting the > previous updates, but I'm not sure how to do it. > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: updating large verity collection
I have an index on the column ... the query is still taking more than minute (I never let it run longer, cause there's no point) to run. I'm not surprised, it looks like an expensive query since it is, as I understand it, like running 10,000 different one-item look ups. So I still need an answer -- and I'm looking every where on the Web for it to ... how do I break up the update of my verity collection update into managable chunks? H. > -Original Message- > From: Jared Clinton [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, January 21, 2003 4:21 PM > To: CF-Talk > Subject: RE: updating large verity collection > > The query is probably running slowly because you dont have the appropriate > indexes defined and applied. > > Look up how to manage indexes correctly in sql server books online, its > worthwhile. > > -Jared Clinton. > > -Original Message- > From: Owens, Howard [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 22 January 2003 11:09 AM > To: CF-Talk > Subject: updating large verity collection > > > So how do you guys handle updating very large collections? > > From a query (I'm using MSSQL Server). > > CF 5.0 > > As I understand it, I can update incrementally, without overwriting the > previous updates, but I'm not sure how to do it. > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: updating large verity collection
The query is probably running slowly because you dont have the appropriate indexes defined and applied. Look up how to manage indexes correctly in sql server books online, its worthwhile. -Jared Clinton. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 22 January 2003 11:09 AM To: CF-Talk Subject: updating large verity collection So how do you guys handle updating very large collections? >From a query (I'm using MSSQL Server). CF 5.0 As I understand it, I can update incrementally, without overwriting the previous updates, but I'm not sure how to do it. CFQUERY has a Maxrows attribute, but apparently not a startrow/endrow pair. I thought I would try something like this: SELECT ARCHIVE_ID blah, blah, blah, FROM table WHERE ARCHIVE_ID BETWEEN 1 and 1 i.e. "between #form.startrow# and #form.endrow# But in query analyizer, this query takes FOREVER to run. What are my other options? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
updating large verity collection
So how do you guys handle updating very large collections? >From a query (I'm using MSSQL Server). CF 5.0 As I understand it, I can update incrementally, without overwriting the previous updates, but I'm not sure how to do it. CFQUERY has a Maxrows attribute, but apparently not a startrow/endrow pair. I thought I would try something like this: SELECT ARCHIVE_ID blah, blah, blah, FROM table WHERE ARCHIVE_ID BETWEEN 1 and 1 i.e. "between #form.startrow# and #form.endrow# But in query analyizer, this query takes FOREVER to run. What are my other options? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Ommiting specified pages from Verity Collection
you're using the k2 engine? -- jon -Original Message- From: Simon Jablonski [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 2:54 AM To: CF-Talk Subject: Ommiting specified pages from Verity Collection Is there some documentation somewhere that explains how to get Verity to index other meta tags that aren't indexed by default? I'm trying to accomplish two things: 1. I really need to be able to exclude pages from a Verity index...I've found out that the META Robots tag doesn't seem to have any effect. I've seen a few workarounds, but none are what you'd call "good" or "standard"...I'd prefer not to hammer a custom workaround into a very large site in the event that another search engine is used down the road, and also when other engines index the site, a more standard method would be preferred so that the same thing would work for more than one engine...although Verity is most important to this right now... 2. These sites use a standard set of meta tags, one that specifies the language...it would be nice to have Verity index only pages of the proper language, but I can't seem to figure out how to do this... I've seen lots of reference to style.* files, but no documentation or real help on what to do here...is there some sort of step by step reference to do this? I find it amazing that this isn't written anywhere I can find it, this must be a common problem...and by searching just these forums, its clear that it is, but with very little concrete help... Thanks, Simon __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Ommiting specified pages from Verity Collection
Is there some documentation somewhere that explains how to get Verity to index other meta tags that aren't indexed by default? I'm trying to accomplish two things: 1. I really need to be able to exclude pages from a Verity index...I've found out that the META Robots tag doesn't seem to have any effect. I've seen a few workarounds, but none are what you'd call "good" or "standard"...I'd prefer not to hammer a custom workaround into a very large site in the event that another search engine is used down the road, and also when other engines index the site, a more standard method would be preferred so that the same thing would work for more than one engine...although Verity is most important to this right now... 2. These sites use a standard set of meta tags, one that specifies the language...it would be nice to have Verity index only pages of the proper language, but I can't seem to figure out how to do this... I've seen lots of reference to style.* files, but no documentation or real help on what to do here...is there some sort of step by step reference to do this? I find it amazing that this isn't written anywhere I can find it, this must be a common problem...and by searching just these forums, its clear that it is, but with very little concrete help... Thanks, Simon __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Ommiting specified pages from Verity Collection
This is a multi-part message in MIME format. --=_NextPart_000_000E_01C24CAA.DCC90CB0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Is there some documentation somewhere that explains how to get Verity to index other meta tags that aren't indexed by default? I'm trying to accomplish two things: 1. I really need to be able to exclude pages from a Verity index...I've found out that the META Robots tag doesn't seem to have any effect. I've seen a few workarounds, but none are what you'd call "good" or "standard"...I'd prefer not to hammer a custom workaround into a very large site in the event that another search engine is used down the road, and also when other engines index the site, a more standard method would be preferred so that the same thing would work for more than one engine...although Verity is most important to this right now... 2. These sites use a standard set of meta tags, one that specifies the language...it would be nice to have Verity index only pages of the proper language, but I can't seem to figure out how to do this... I've seen lots of reference to style.* files, but no documentation or real help on what to do here...is there some sort of step by step reference to do this? I find it amazing that this isn't written anywhere I can find it, this must be a common problem...and by searching just these forums, its clear that it is, but with very little concrete help... Thanks, Simon --=_NextPart_000_000E_01C24CAA.DCC90CB0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable http://www.w3.org/TR/REC-html40";> cid:[EMAIL PROTECTED]";> Is there some documentation = somewhere that explains how to get Verity to index other meta tags that aren't indexed by default? I'm trying to accomplish two things: 1. I really need to be able to exclude pages from a Verity index...I've = found out that the META Robots tag doesn't seem to have any effect. I've seen = a few workarounds, but none are what you'd call "good" or "standard"...I'd prefer not to hammer a custom workaround into = a very large site in the event that another search engine is used down the = road, and also when other engines index the site, a more standard method would be preferred so that the same thing would work for more than one = engine...although Verity is most important to this right now... 2. These sites use a standard set of meta = tags, one that specifies the language...it would be nice to have Verity index only = pages of the proper language, but I can't seem to figure out how to do = this... I've seen lots of reference to style.* files, but no documentation or = real help on what to do here...is there some sort of step by step reference to do = this? I find it amazing that this isn't written anywhere I can find it, this = must be a common problem...and by searching just these forums, its clear that it is, but with very little concrete = help... Thanks, Simon= --=_NextPart_000_000E_01C24CAA.DCC90CB0-- FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Exclude pages from Verity collection
I tried that, but Verity (at least with 4.5.2) seems to ignore it. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Exclude pages from Verity collection
Al Musella, DPM wrote: >I may do things the hard way, but the approach I take is to put a > comment in the files that I do not want indexed, like: > > Then, when indexing them, I use cffile to list the files in the > directories, and cfhttp to read them. I look for that comment, and if not > there, add them to a database, which is then indexed. This solves the > problem of indexing the second page of a form, my header and footer files, > lets me index pages that are made up of multiple included pages or dynamic > text, and lets me get the page's title - which I set with a cfset > pagetitle='' before I include the header.. how about __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Exclude pages from Verity collection
I may do things the hard way, but the approach I take is to put a comment in the files that I do not want indexed, like: Then, when indexing them, I use cffile to list the files in the directories, and cfhttp to read them. I look for that comment, and if not there, add them to a database, which is then indexed. This solves the problem of indexing the second page of a form, my header and footer files, lets me index pages that are made up of multiple included pages or dynamic text, and lets me get the page's title - which I set with a cfset pagetitle='' before I include the header.. Al At 03:30 PM 8/14/2002 +0200, you wrote: >Hi all, > >I have just started to play with Verity on CF 4.52 (I have used htdig >before). I am not big fan of pages in the templates directory, as well as >custom tags being indexed. > >Is there a tag or, is it possble to use robots.txt, to exclude >pages/templates? > >I tried > >..but it didn't work. > >Any tips are welcome. Oh, by the way, this is what I used for the indexing: > > KEY="c:\htdocs\website" > ACTION="REFRESH" > TYPE="PATH" > URLPATH="http://www.website.com"; > EXTENSIONS=".htm, .html, .cfm, .pdf" > RECURSE="Yes" > LANGUAGE="English"> > > > > > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Exclude pages from Verity collection
Hi all, I have just started to play with Verity on CF 4.52 (I have used htdig before). I am not big fan of pages in the templates directory, as well as custom tags being indexed. Is there a tag or, is it possble to use robots.txt, to exclude pages/templates? I tried ..but it didn't work. Any tips are welcome. Oh, by the way, this is what I used for the indexing: http://www.website.com"; EXTENSIONS=".htm, .html, .cfm, .pdf" RECURSE="Yes" LANGUAGE="English"> __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Verity Collection ERROR
Brian Simpson wrote: > I have several Verity Collections on one CF server. > > All are working fine execpt one. When ever I try and do anything (Repair, > Optimize, Purge or Delete) with this collection I get the following error: > > I have started and stopped the server several time and still get this error. > > When I try and Index the colection, I get this: > There was an error indexing this collection. > Please verify that path D:\WebSite\htdocs\CA is correct. > > > Does anyone know how to fix this? Delete it by hand and recreate. You should be able to delete the directory created at the point where you set the collection up. Next, go into the registry and delete all references to that collection. It is somewhere below HKLM\Software\Allaire\ColdFusion\CurrentVersion\ You should be able to recreate the collection now. Jochem __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity Collection ERROR
I have several Verity Collections on one CF server. All are working fine execpt one. When ever I try and do anything (Repair, Optimize, Purge or Delete) with this collection I get the following error: I have started and stopped the server several time and still get this error. When I try and Index the colection, I get this: There was an error indexing this collection. Please verify that path D:\WebSite\htdocs\CA is correct. Does anyone know how to fix this? Brian Error Occurred While Processing Request Error Diagnostic InformationError creating Verity File collection. Error # -31 [ffe1] VdkCollectionOpen Date/Time: 02/21/02 13:37:19 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98; T312461) Remote Address: 207.229.56.1 HTTP Referrer: http://www.netmatrix.com/CFIDE/administrator/collections/verity.cfm __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: integrated result set from 2 different verity collection types
I recently have apllied the same scenario of two collections. (File and Content) Please review the following code and evaluate if this can help you. (NOTE: the collections are also documented by a database architecture; hence, the example here provides the utilization of both collections and their respective database tables) SELECT dv.FileID FID, nullContentID, d.startdateStartDate, d.title title, d.status status, i.identifiersection, nullmapping, dt.description docType, dv.size size, dt.img img FROM docversion dv, documents d, doctypes dt, identifiers i WHERE dv.FileID IN (#fileList#) AND d.status < '100' AND d.docid = dv.docid AND dt.doctypeID = d.doctypeID AND d.identifierid = i.identifierid UNION ALL SELECT nullFID, c.contentidContentID, c.startdateStartDate, c.title title, c.status status, i.identifier section, i.mapping mapping, nulldocType, nullsize, nullimg FROM ContentItems c, ContentIdentifiers ci, identifiers i WHERE c.status < '100' AND c.contentid IN (#ResultList#) AND c.contentid = ci.contentid AND ci.identifierid = i.identifierid ORDER BY StartDate asc, title StartDate desc, title section, startdate desc section desc, startdate desc StartDate desc, title Title Section Section Date Date #currentrow# #title# « archived » #docType# [#ROUND(ksize)# KB] #section# #DateFormat(startdate, fdate) # #currentrow# #title# « archived » #section# #DateFormat(startdate, fdate)# Good Luck, Robert Mann Senior Web Specialist Kaiser Permanente Drug Information __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: integrated result set from 2 different verity collection types
> > > The CFSearch tag can have a comma separated list of collection names Be warned though, it has a limit on this - I think it's either 32 or 64 collections Also, CFSearch gets stuck if the result set it too large - it causes an error Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 F: +44 (0)20 8686 7911 An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: integrated result set from 2 different verity collection types
The CFSearch tag can have a comma separated list of collection names C. Hatton Humphrey > -Original Message- > From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 08, 2002 12:59 PM > To: CF-Talk > Subject: integrated result set from 2 different verity collection types > > > I have a database collection and a file collection, how does one go about > getting an integrated result-set from a single search? Surely this is > something somebody has done before. I was thinking of running two searches > and then populating a single array with the results. Then outputting the > links so that file results point to the file, and db results point to the > page that displays the content. Is there a more effective way? > > Adam. > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
integrated result set from 2 different verity collection types
I have a database collection and a file collection, how does one go about getting an integrated result-set from a single search? Surely this is something somebody has done before. I was thinking of running two searches and then populating a single array with the results. Then outputting the links so that file results point to the file, and db results point to the page that displays the content. Is there a more effective way? Adam. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating Verity Collection without Administrator
> Can someone tell me how to create/index verity collection > with multiple languages. I did create collection using > verity administrator..but you can select only one language. > How to create collection without using verity administrator? You can create collections programmatically using the CFCOLLECTION tag. However, I don't think you can use more than one language with the same collection. This makes sense, if you think about it - the choice of a language will affect how Verity works with the contents of the index. If you need to use different languages, create different collections. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Creating Verity Collection without Administrator
Hi, Can someone tell me how to create/index verity collection with multiple languages. I did create collection using verity administrator..but you can select only one language. How to create collection without using verity administrator? Thanks Khalid __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Excluding a directory from a Verity Collection
There is a tag from the tag gallery called cf_pathindex that does exactly what you want to do. i.e. exclude the Frontpage Extensions directory from being indexed. Doesn't require manipulating the useraccounts. - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 08, 2001 1:13 AM Subject: RE: Excluding a directory from a Verity Collection > Have thought of a possible way around this (haven't tried it yet though). > > As I'm running the page which indexes the directory structure as a scheduled > task, I could create a local user on the server, with "deny" access to the > directory I don't want to index, then use this username and password to run > the scheduled task. > > Alex > > > -Original Message- > > From: Dave Watts [SMTP:[EMAIL PROTECTED]] > > Sent: 07 November 2001 17:45 > > To: CF-Talk > > Subject: RE: Excluding a directory from a Verity Collection > > > > > Does anyone know if there's a way to exclude a directory > > > from being indexed, if it is in the directory tree below > > > the "directory path" specified for the collection? > > > > There's no way to do this directly. You can use a custom tag to index only > > the directories you specify, and have that custom tag recurse as needed. > > There's probably one on the developers' exchange for this. > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > voice: (202) 797-5496 > > fax: (202) 797-5444 > > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists