RE: [ACFUG Discuss] Verity and Blobs
Just looking at all the options. One issue with the current system is a record goes in the database for a file, but is stored as a file on the web server. Unfortunately, we are running a cluster of 2 servers and a file gets uploaded to ONE of the two servers. (They are working on some sync software and currently I don't have the time to write a 'fix') No, there's not a third server out there that I can put files on. I am just looking at options (and reasons not to put files in the database, which I don't like doing either). We are running Oracle. Anyone integrated with Northern Lights search software? That might also be a possibility, but I've never used it before. Thanks, mcg John Mason [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/11/2006 01:32 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject RE: [ACFUG Discuss] Verity and Blobs There are two main uses of verity. 1) Searching files in a directory structure (cfm, pdf, doc, etc) 2) Searching specific text in database sources (like in sourcing items in text or ntext fields) Verity is simply a smaller index database pointing to where the searches are pointing to. Why are they wanted to put the documents into the database? Are they running Sql Server or Oracle to do this? John [EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Friday, August 11, 2006 12:24 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Verity and Blobs hmm.. I'm not sure on that one... in my experience with verity I didn't choose that direction. I just stored the files outside of the web docroot and indexed them normally. I have an aversion to storing files in the db... I would think it would slow verity down a bit pulling all that data from the db. If Verity can't index files that are stored in the db you may have to end up writing a query to dump all the data to the file system and then run your indexer (now that would be painstaking). The livedocs don't really reveal an answer to you question. http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=1303.htm On 8/11/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: We are looking at potentially storing files in the database. I'm not a big fan of that, but it's a possibility. Can Verity index files if they are in the database? Thanks, mcg - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Steven Ross web application interface developer http://www.zerium.com [phone] 404-488-4364 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
[ACFUG Discuss] XML Formatting in CF5 question
Hello everyone, I've got an aggravating situation. We're using CF5 and I'm doing some AJAX interfaces. My problem is, we have international users that have unicode characters such as o acutes and various other flavors of invalid xml characters...Do any of you know of a way either in XML or in CF5 to escape the characters that will cause the XML to be invalid? Also, so you know, the values that are causing problems are attributes and not text values in-between the tags...for instance: person fName="invalidCharacterShowsUpHere" / CDATA won't solve my problem and I'm running out of ideas. Any help would be awesome! Thanks, Allen - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
Re: [ACFUG Discuss] Verity and Blobs
We run Winblows here, its not too hard to use FDS to synch servers up. I have used this before, both boxes need to belong to a domain and all with a DC and AD and that's enough acronyms for now. Another option that might be quicker then fighting with blobs is the event gateway and the filewatcher that comes with CF7provided you have upgraded that is. By the way how are you linking to this file? If using HTTP://.com/file.doc no problem, eh?DKOn 8/14/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Just looking at all the options. One issue with the current system is a record goes in the database for a file, but is stored as a file on the web server. Unfortunately, we are running a cluster of 2 servers and a file gets uploaded to ONE of the two servers. (They are working on some sync software and currently I don't have the time to write a 'fix') No, there's not a third server out there that I can put files on. I am just looking at options (and reasons not to put files in the database, which I don't like doing either). We are running Oracle. Anyone integrated with Northern Lights search software? That might also be a possibility, but I've never used it before. Thanks, mcg John Mason [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/11/2006 01:32 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject RE: [ACFUG Discuss] Verity and Blobs There are two main uses of verity. 1) Searching files in a directory structure (cfm, pdf, doc, etc) 2) Searching specific text in database sources (like in sourcing items in text or ntext fields) Verity is simply a smaller index database pointing to where the searches are pointing to. Why are they wanted to put the documents into the database? Are they running Sql Server or Oracle to do this? John [EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Steven Ross Sent: Friday, August 11, 2006 12:24 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Verity and Blobs hmm.. I'm not sure on that one... in my experience with verity I didn't choose that direction. I just stored the files outside of the web docroot and indexed them normally. I have an aversion to storing files in the db... I would think it would slow verity down a bit pulling all that data from the db. If Verity can't index files that are stored in the db you may have to end up writing a query to dump all the data to the file system and then run your indexer (now that would be painstaking). The livedocs don't really reveal an answer to you question. http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=1303.htm On 8/11/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: We are looking at potentially storing files in the database. I'm not a big fan of that, but it's a possibility. Can Verity index files if they are in the database? Thanks, mcg - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Steven Ross web application interface developer http://www.zerium.com [phone] 404-488-4364 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Douglas Knudsenhttp://www.cubicleman.comthis is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink
Re: re[2]: [ACFUG Discuss] Verity and Blobs
We are hoping to be on 7 by the time this launches. There is more than just Verity collections that need to be up to date. People need to be able to download the files as well (from the application itself). mcg Mischa Uppelschoten ext 10 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/14/2006 12:32 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject re[2]: [ACFUG Discuss] Verity and Blobs A Verity collection is nothing but a bunch of files on disk. Unless you care a lot about adding documents to your collection real time, you could change the upload procedure to always upload to one box, refresh your collections on that box and then copy the collections to the other box. If you're running CFMX7 there's a file monitor gateway that fires an event when a new file is detected somewhere. If not, I guess it depends on the server OS as far as syncing options. /m Just looking at all the options. One issue with the current system is a record goes in the database for a file, but is stored as a file on the web server. Unfortunately, we are running a cluster of 2 servers and a file gets uploaded to ONE of the two servers. (They are working on some sync software and currently I don't have the time to write a 'fix') No, there's not a third server out there that I can put files on. I am just looking at options (and reasons not to put files in the database, which I don't like doing either). We are running Oracle. Anyone integrated with Northern Lights search software? That might also be a possibility, but I've never used it before. Thanks, mcg John Mason [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/11/2006 01:32 PM Please respond to discussion@acfug.org [EMAIL PROTECTED] cc SubjectRE: [ACFUG Discuss] Verity and Blobs There are two main uses of verity. 1)Searching files in a directory structure (cfm, pdf, doc, etc) 2)Searching specific text in database sources (like in sourcing items in text or ntext fields) Verity is simply a smaller index database pointing to where the searches are pointing to. Why are they wanted to put the documents into the database? Are they running Sql Server or Oracle to do this? John [EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Friday, August 11, 2006 12:24 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Verity and Blobs hmm.. I'm not sure on that one... in my experience with verity I didn't choose that direction. I just stored the files outside of the web docroot and indexed them normally. I have an aversion to storing files in the db... I would think it would slow verity down a bit pulling all that data from the db. If Verity can't index files that are stored in the db you may have to end up writing a query to dump all the data to the file system and then run your indexer (now that would be painstaking). The livedocs don't really reveal an answer to you question. http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=1303.htm On 8/11/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: We are looking at potentially storing files in the database. I'm not a big fan of that, but it's a possibility. Can Verity index files if they are in the database? Thanks, mcg - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Steven Ross web application interface developer http://www.zerium.com [phone] 404-488-4364 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - Mischa Uppelschoten The
Re: [ACFUG Discuss] RE: XML Formatting in CF5 question
why not use utf-8? guess it depends on your input formsOn 8/14/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Quick update - just in case anyone else ever runs into this problem. Again, just to restate quickly - say you have a German name with the double dots over the u or you have a spanish name with the ~ over the n or something like that, it was breaking my xml. To fix it I just needed to put this declaration at the top of the xml document: ?xml version=1.0 encoding=iso-8859-1 ? Allen -Original Message-From: Underwood Allen (WJJ1AXU) Sent: Monday, August 14, 2006 12:32 PMTo: 'discussion@acfug.org'Subject: XML Formatting in CF5 question Hello everyone, I've got an aggravating situation. We're using CF5 and I'm doing some AJAX interfaces. My problem is, we have international users that have unicode characters such as o acutes and various other flavors of invalid xml characters...Do any of you know of a way either in XML or in CF5 to escape the characters that will cause the XML to be invalid? Also, so you know, the values that are causing problems are attributes and not text values in-between the tags...for instance: person fName=invalidCharacterShowsUpHere / CDATA won't solve my problem and I'm running out of ideas. Any help would be awesome! Thanks, Allen - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Steven Rossweb application interface developer http://www.zerium.com[phone] 404-488-4364 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] RE: XML Formatting in CF5 question
Yep, actually UTF-8 is the way to go here. The group that supported the older 8859-1 (Latin-1) group has move on. The UTF standards are the newer and more accepted encoding standard. http://en.wikipedia.org/wiki/ISO-8859-1 John [EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Monday, August 14, 2006 4:32 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] RE: XML Formatting in CF5 question why not use utf-8? guess it depends on your input forms On 8/14/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Quick update - just in case anyone else ever runs into this problem. Again, just to restate quickly - say you have a German name with the double dots over the u or you have a spanish name with the ~ over the n or something like that, it was breaking my xml. To fix it I just needed to put this declaration at the top of the xml document: ?xml version=1.0 encoding=iso-8859-1 ? Allen -Original Message- From: Underwood Allen (WJJ1AXU) Sent: Monday, August 14, 2006 12:32 PM To: 'discussion@acfug.org' Subject: XML Formatting in CF5 question Hello everyone, I've got an aggravating situation. We're using CF5 and I'm doing some AJAX interfaces. My problem is, we have international users that have unicode characters such as o acutes and various other flavors of invalid xml characters...Do any of you know of a way either in XML or in CF5 to escape the characters that will cause the XML to be invalid? Also, so you know, the values that are causing problems are attributes and not text values in-between the tags...for instance: person fName=invalidCharacterShowsUpHere / CDATA won't solve my problem and I'm running out of ideas. Any help would be awesome! Thanks, Allen - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Steven Ross web application interface developer http://www.zerium.com [phone] 404-488-4364 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -