Re: Searching a Solr colllection using the key value to get a specific file
It's a possibility, but I'd have to retool the app since all 4 custom fields are currently in use. It did dawn on me that I could do a query of queries again the Verity results to pull out the records that are in a particular directory. ~| 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:346258 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Searching a Solr colllection using the key value to get a specific file
OK, so I've figured out the syntax or querying the key field to get a specific record. The criteria looks something like this: criteria='key:D:\\Inetpub\\FoldererName\\FolderName\\FolderName\\Create_View_Delete_Calendar_Groups.doc' *Note that every '\' has been escaped to '\\', you had to do the same with Verity. Now say, I want to add additional criteria like documents that contain the word office, the criteria looks like this: criteria='key:D:\\Inetpub\\FoldererName\\FolderName\\FolderName\\Create_View_Delete_Calendar_Groups.doc AND +office'\ What I really want to do though is limit the search do docments in a specific folder, something like criteria='key:D:\\Inetpub\\FoldererName\\FolderName\\FolderName\\*' I can't seem to get this to work. I've read other posting saying wildcard searches need to be in lower case, and I've used lcase() around the string to force this, but still nothing is returned. It's probalby a syntax issue, but I tried lots of variation with no success. ~| 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:346164 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: code sharing in IIS
We do this all the time, and its also how we create multiple IIS sites bound to their own CF instances to create multiple instances of a website that we then load balance. I've found this the best way to utilize beefy hardware with ColdFusion ~| 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:346108 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Automated File Deployment/Replication
We use a product called Repliweb. It's very fast, and can be used for scheduled file pushes or continuous replication. It will also replicate IIS settings, if you want it to. Its reasonably priced. I think we paid around 4k for 4 nodes including the center source node. We've been very happy with it. ~| 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:346109 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfcatch DB connection failure - for failover
I was able to get the following code to run sucessfully. I took the database offline so CF couldn't connect to it. As a second test, I also changed the server name to an invalid on in the datasource setup, and both scenarios worked. cftry cfquery name=testme datasource=datasource maxrows=10 timeout=2 Select * from testdb /cfquery cfcatch cfquery name=testme datasource=datasource2 maxrows=10 timeout=5 Select * from testdb /cfquery /cfcatch /cftry Hi a bit stuck at the moment, I am trying to implement a DB fail over to a slave database through CF 9. I am using MYSQL as a DB. I have setup datasource in the application.cfc to point to the main db. When i trigger a stop service on the main db - which causes a failed db connection, i'm trying to get CF to change the datasource to the failover database. All that happens is the site keeps trying to connect to the main db without updating the db datasource in the cfcatch. Note: this code below works if i have a syntax error in the query, but not for a DB connection failure. See my code below, which i am putting in the onRequestStart and i have unchecked Maintain Connections in the datasource settings. cftry !--- Test whether the DB this application uses is accessible by getting some data. --- cfquery name=testDB dataSource=#application.primary_datasource# maxrows=2 SELECT id FROM user /cfquery cfcatch type=database cfset application.primary_datasource = failoverdb /cfcatch /cftry I welcome any thoughts and assistance thanks in advance. Bas. ~| 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:346112 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Searching a Solr colllection using the key value to get a specific file
I'm trying to get migrate to solr, but have a question about using the record key in the search critera. With Verity my code looks like this: cfsearch name=getPreDeleteInfo collection=#sttCFG.strCollectionName# type=simple status=info language=english criteria= CF_KEY CONTAINS '#variables.criteria#' The record in the collection looks like: [Record # 1] AUTHOR: casjlr CATEGORY: smm_doclibsecure CATEGORYTREE: Web/ CONTEXT: [empty string] CUSTOM1: office 2003 doc test CUSTOM2: office 2003 doc test CUSTOM3: [empty string] CUSTOM4: Everyone_Intranet KEY: D:\...\Web\Create_View_Delete_Calendar_Groups.doc RANK: 1 RECORDSSEARCHED: 1 SCORE: 0. SIZE: 76288 SUMMARY: Pick members from an Address Bookor Contacts list Create a calendar group based on the calendars that you are viewing Pick members from an Address Book or Contacts list In Calendar, on the Home tab, in the Manage Calendars group, click Calendar Groups, and then click Create New Calendar Group. Create a calendar group based on the calendars that you are viewing In Calendar, on the Home tab, in the Manage Calendars group, click Calendar Groups, and then click Save as New Calendar Group. Add ... TITLE: office 2003 doc test TYPE: application/msword URL: body_emp.cfm?id=xxaction=RetrieveFileref=33fp=/Create_View_Delete_ Calendar_Groups.doc An example of something that doens't work: cfsearch name=test collection=test_solr status=info criteria='key:D*\...\Web\Create_View_Delete_Calendar_Groups.doc' Note: ... is not the actual info (Didn't want to put my server actual path info in a public site) I've tried a number of differnet combinations, but to no avail. Has anyone else successfully written a query like this? Getting at the custom fields works fine. cfsearch name=test collection=prodsite_smm_doclibsecure_solr status=info criteria='custom1:office 2003' brings back the expected results. Any help is appreciated. ~| 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:346080 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Searching a Solr colllection using the key value to get a specific file
I'm trying to get migrate to solr, but have a question about using the record key in the search critera with Verity my code looks like this: cfsearch name=getPreDeleteInfo collection=#sttCFG.strCollectionName# type=simple status=info language=english criteria= CF_KEY CONTAINS '#variables.criteria#' The record in the collection looks like: [Record # 1] AUTHOR: casjlr CATEGORY: smm_doclibsecure CATEGORYTREE: Web/ CONTEXT: [empty string] CUSTOM1: office 2003 doc test CUSTOM2: office 2003 doc test CUSTOM3: [empty string] CUSTOM4: Everyone_Intranet KEY: D:\...\Web\Create_View_Delete_Calendar_Groups.doc RANK: 1 RECORDSSEARCHED: 1 SCORE: 0. SIZE: 76288 SUMMARY: Pick members from an Address Bookor Contacts list Create a calendar group based on the calendars that you are viewing Pick members from an Address Book or Contacts list In Calendar, on the Home tab, in the Manage Calendars group, click Calendar Groups, and then click Create New Calendar Group. Create a calendar group based on the calendars that you are viewing In Calendar, on the Home tab, in the Manage Calendars group, click Calendar Groups, and then click Save as New Calendar Group. Add ... TITLE: office 2003 doc test TYPE: application/msword URL: body_emp.cfm?id=xxaction=RetrieveFileref=33fp=/Create_View_Delete_ Calendar_Groups.doc An example of something that doens't work: cfsearch name=test collection=test_solr status=info criteria='key:D*\...\Web\Create_View_Delete_Calendar_Groups.doc' Note: ... is not the actual info (Didn't want to put my server actual path info in a public site) I've tried a number of differnet combinations, but to no avail. Has anyone else successfully written a query like this? Getting at the custom fields works fine. cfsearch name=test collection=prodsite_smm_doclibsecure_solr status=info criteria='custom1:office 2003' brings back the expected results. Any help is appreciated. ~| 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:346081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Searching a Solr colllection
I'm trying to get migrate to solr, but have a question about using the record key in the search critera With Verity my code looks like this: cfsearch name=getPreDeleteInfo collection=#sttCFG.strCollectionName# type=simple status=info language=english criteria= CF_KEY CONTAINS '#variables.criteria#' The record in the collection looks like: [Record # 1] AUTHOR: casjlr CATEGORY: smm_doclibsecure CATEGORYTREE: Web/ CONTEXT: [empty string] CUSTOM1: office 2003 doc test CUSTOM2: office 2003 doc test CUSTOM3: [empty string] CUSTOM4: Everyone_Intranet KEY: D:\...\Web\Create_View_Delete_Calendar_Groups.doc RANK: 1 RECORDSSEARCHED: 1 SCORE: 0. SIZE: 76288 SUMMARY: Pick members from an Address Bookor Contacts list Create a calendar group based on the calendars that you are viewing Pick members from an Address Book or Contacts list In Calendar, on the Home tab, in the Manage Calendars group, click Calendar Groups, and then click Create New Calendar Group. Create a calendar group based on the calendars that you are viewing In Calendar, on the Home tab, in the Manage Calendars group, click Calendar Groups, and then click Save as New Calendar Group. Add ... TITLE: office 2003 doc test TYPE: application/msword URL: body_emp.cfm?id=xxaction=RetrieveFileref=33fp=/Create_View_Delete_ Calendar_Groups.doc An example of something that doens't work: cfsearch name=test collection=test_solr status=info criteria='key:D*\...\Web\Create_View_Delete_Calendar_Groups.doc' Note: ... is not the actual info (Didn't want to put my server actual path info in a public site) I've tried a number of differnet combinations, but to no avail. Has anyone else successfully written a query like this? Getting at the custom fields works fine. cfsearch name=test collection=prodsite_smm_doclibsecure_solr status=info criteria='custom1:office 2003' brings back the expected results. In the Scheme.xml file I changed the key and URL fields to be indexed=true field name=key type=string indexed=true stored=true required=true / field name=urltype=string indexed=true stored=true required=true / I can do a search on the URL field as long as like put the wildcard * at the end of the search criteria, but I still do not get any results using the key field. Any ideas how now to escape colons : in the path name? cfsearch name=test =#sttCFG.strCollectionName# status=info criteria='url:b*=32356*' Any help is appreciated. ~| 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:346090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Searching a Solr colllection using the key value to get a specific file
Just curious - why would you do a search when you know exactly what you want? On Tue, Jul 5, 2011 at 1:19 PM, eric.da...@vmmc.org eric.da...@vmmc.org eric.da...@vmmc.org wrote: [Record # 1] In this case, I'm trying to get what was indexed so I can present it back to the user who just uploaded a file. ~| 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:346091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Searching a Solr colllection
I apologize for the for the multiple posting. Because of the delay, I thought my posts were being accepted. ~| 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:346092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Searching a Solr colllection using the key value to get a specific file
In the Scheme.xml file I changed the key and URL fields to be indexed=true field name=key type=string indexed=true stored=true required=true / field name=url type=string indexed=true stored=true required=true / I can now do a search on the URL field as long as like put the wildcard * at the end of the search criteria, but I still do not get any results using the key field. Any ideas how now to escape colons : in the path name? cfsearch name=test =#sttCFG.strCollectionName# status=info criteria='url:b*=32356*' ~| 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:346093 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Searching a Solr colllection using the key value to get a specific file
Another reason I need to be able to search against the key field, is that I allow the user to filter the search results by the directory the document is placed into. The only field in the collection that contains this information is the key field. ~| 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:346094 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm