RE: Unstructured info
Judging from what I've read thus far, I don't think your problem is one of technology, but more one of organization. From the sounds of things, the site IS organized, but not in an efficent manner for the web. You can try looking at it that way, ignore the underlying language (ASP/CF), and see if you can find a better way to organize the data. Once you have decided, then you pick whichever language you need/want to implement that organization. I suspect you might need some database work done - either a new design, or new tables to organize the existing data (kind of a specialized index - but not in the sense of a database index). I doubt that was too helpful, but here's hoping. Shawn Grover -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 9:20 PM To: CF-Talk Subject: RE: Unstructured info Currently it runs using HTML and ASP but I'm looking for alternatives because this is not producing the best results in my view. I hadn't thought of Verity (that's why this list and the people on it are so great) and I don't know if it can provide a solution - maybe someone on the slit can help here. TA ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 12:42 PM To: CF-Talk Subject: RE: Unstructured info Is it running on CF? Isn't this what verity does? I am not sure, I have never used it, but I think you use it for making indexes of sites just like this, I believe that it can even index the db and any document (wprd, txt,pdf) that you have. Check out the studio docs on verity indexes. Hope it helps. Tim -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 11:10 PM To: CF-Talk Subject: RE: Unstructured info If you go to areas like this http://claimassist.workcover.com/TheLaw/thelaw.htm and start drilling down you'll see you get some interesting results that are unpalatable for a web site such as long menus and pages with further menus in them. It gives the impression of being structured because it sits inside a structured site but I suppose a better word to use night have also been variable length. http://claimassist.workcover.com/TheLaw/reg241of1999.htm http://claimassist.workcover.com/TheLaw/appendix.htm Pages like this http://claimassist.workcover.com/TheLaw/5a8ca04.htm probably do lend themselves to being in a database but I don't want to spawn lots of little tables etc within the database. The site has a search http://claimassist.workcover.com/Search/SearchFrameset.htm but sections that are in SQL also have a search http://claimassist.workcover.com/Precis_List/precis_list.htm and there is another section on the way like this so yet another search interface is created. With the whole thing in a database I figure I can reduce it one search interface. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 12:26 PM To: CF-Talk Subject: Re: Unstructured info Not sure if I can help, but if you give us some more information about your unstructured data, some of us may have a few helpful hints. Just give us some details. Paul Giesenhagen QuillDesign Doe anyone know if CF has been used to manage unstructured information. The problem/challenge. http://claimassist.workcover.com - about two thirds is structured and sits in a SQL server database. The rest is not and the result is ugly and difficult to manage and update etc. I'm considering some options but wondered if CF presented any. I want the whole thing in a database ideally. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies
Re: Unstructured info
Not sure if I can help, but if you give us some more information about your unstructured data, some of us may have a few helpful hints. Just give us some details. Paul Giesenhagen QuillDesign Doe anyone know if CF has been used to manage unstructured information. The problem/challenge. http://claimassist.workcover.com - about two thirds is structured and sits in a SQL server database. The rest is not and the result is ugly and difficult to manage and update etc. I'm considering some options but wondered if CF presented any. I want the whole thing in a database ideally. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Unstructured info
I think you have 2 real good options. 1. Parse all the existing static documents then add them to a db. This would be time consuming, and probably not work out all that well. This is the option I would persue if this were my fulltime job. That way you would eventually have all the data structured in the db, and be able to build a noce easily maintained and updated site. 2. Using one of the wysiwyg editors, write something that will allow users to edit the pages through a web interface, then using CFFile write over the old static page with the new static page - This is the option I would persue if this is not your full time job, and it is for a contract. It would give them the ability to edit the pages on the fly, and make your job easier in the short term. My 2 coppers. Tim -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:54 PM To: CF-Talk Subject: Unstructured info Doe anyone know if CF has been used to manage unstructured information. The problem/challenge. http://claimassist.workcover.com - about two thirds is structured and sits in a SQL server database. The rest is not and the result is ugly and difficult to manage and update etc. I'm considering some options but wondered if CF presented any. I want the whole thing in a database ideally. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: Unstructured info
If you go to areas like this http://claimassist.workcover.com/TheLaw/thelaw.htm and start drilling down you'll see you get some interesting results that are unpalatable for a web site such as long menus and pages with further menus in them. It gives the impression of being structured because it sits inside a structured site but I suppose a better word to use night have also been variable length. http://claimassist.workcover.com/TheLaw/reg241of1999.htm http://claimassist.workcover.com/TheLaw/appendix.htm Pages like this http://claimassist.workcover.com/TheLaw/5a8ca04.htm probably do lend themselves to being in a database but I don't want to spawn lots of little tables etc within the database. The site has a search http://claimassist.workcover.com/Search/SearchFrameset.htm but sections that are in SQL also have a search http://claimassist.workcover.com/Precis_List/precis_list.htm and there is another section on the way like this so yet another search interface is created. With the whole thing in a database I figure I can reduce it one search interface. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 12:26 PM To: CF-Talk Subject: Re: Unstructured info Not sure if I can help, but if you give us some more information about your unstructured data, some of us may have a few helpful hints. Just give us some details. Paul Giesenhagen QuillDesign Doe anyone know if CF has been used to manage unstructured information. The problem/challenge. http://claimassist.workcover.com - about two thirds is structured and sits in a SQL server database. The rest is not and the result is ugly and difficult to manage and update etc. I'm considering some options but wondered if CF presented any. I want the whole thing in a database ideally. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Unstructured info
Is it running on CF? Isn't this what verity does? I am not sure, I have never used it, but I think you use it for making indexes of sites just like this, I believe that it can even index the db and any document (wprd, txt,pdf) that you have. Check out the studio docs on verity indexes. Hope it helps. Tim -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 11:10 PM To: CF-Talk Subject: RE: Unstructured info If you go to areas like this http://claimassist.workcover.com/TheLaw/thelaw.htm and start drilling down you'll see you get some interesting results that are unpalatable for a web site such as long menus and pages with further menus in them. It gives the impression of being structured because it sits inside a structured site but I suppose a better word to use night have also been variable length. http://claimassist.workcover.com/TheLaw/reg241of1999.htm http://claimassist.workcover.com/TheLaw/appendix.htm Pages like this http://claimassist.workcover.com/TheLaw/5a8ca04.htm probably do lend themselves to being in a database but I don't want to spawn lots of little tables etc within the database. The site has a search http://claimassist.workcover.com/Search/SearchFrameset.htm but sections that are in SQL also have a search http://claimassist.workcover.com/Precis_List/precis_list.htm and there is another section on the way like this so yet another search interface is created. With the whole thing in a database I figure I can reduce it one search interface. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 12:26 PM To: CF-Talk Subject: Re: Unstructured info Not sure if I can help, but if you give us some more information about your unstructured data, some of us may have a few helpful hints. Just give us some details. Paul Giesenhagen QuillDesign Doe anyone know if CF has been used to manage unstructured information. The problem/challenge. http://claimassist.workcover.com - about two thirds is structured and sits in a SQL server database. The rest is not and the result is ugly and difficult to manage and update etc. I'm considering some options but wondered if CF presented any. I want the whole thing in a database ideally. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. __ 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: Unstructured info
Currently it runs using HTML and ASP but I'm looking for alternatives because this is not producing the best results in my view. I hadn't thought of Verity (that's why this list and the people on it are so great) and I don't know if it can provide a solution - maybe someone on the slit can help here. TA ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 12:42 PM To: CF-Talk Subject: RE: Unstructured info Is it running on CF? Isn't this what verity does? I am not sure, I have never used it, but I think you use it for making indexes of sites just like this, I believe that it can even index the db and any document (wprd, txt,pdf) that you have. Check out the studio docs on verity indexes. Hope it helps. Tim -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 11:10 PM To: CF-Talk Subject: RE: Unstructured info If you go to areas like this http://claimassist.workcover.com/TheLaw/thelaw.htm and start drilling down you'll see you get some interesting results that are unpalatable for a web site such as long menus and pages with further menus in them. It gives the impression of being structured because it sits inside a structured site but I suppose a better word to use night have also been variable length. http://claimassist.workcover.com/TheLaw/reg241of1999.htm http://claimassist.workcover.com/TheLaw/appendix.htm Pages like this http://claimassist.workcover.com/TheLaw/5a8ca04.htm probably do lend themselves to being in a database but I don't want to spawn lots of little tables etc within the database. The site has a search http://claimassist.workcover.com/Search/SearchFrameset.htm but sections that are in SQL also have a search http://claimassist.workcover.com/Precis_List/precis_list.htm and there is another section on the way like this so yet another search interface is created. With the whole thing in a database I figure I can reduce it one search interface. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 12:26 PM To: CF-Talk Subject: Re: Unstructured info Not sure if I can help, but if you give us some more information about your unstructured data, some of us may have a few helpful hints. Just give us some details. Paul Giesenhagen QuillDesign Doe anyone know if CF has been used to manage unstructured information. The problem/challenge. http://claimassist.workcover.com - about two thirds is structured and sits in a SQL server database. The rest is not and the result is ugly and difficult to manage and update etc. I'm considering some options but wondered if CF presented any. I want the whole thing in a database ideally. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. __ 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: Unstructured info
your right - you can join SQL queries from the db and combine them with verity search commands. I have only used verity once however on an existing client site. It manages to index about 10,000 resumes as .doc files - and the search is quite efficient. I abandoned developing verity further when I could not use verity to index, search or reference the MS word page properties. in any event a sample using verity is as so - you write a CFQUERY that grabs the data you want to make searchable and pass it to a CFINDEX. as per Ben Forta's Web App Construct Guide - this indexes that information like individual documents. Then designate which info should be used as filename, title and body CFINDEX QUERY=GetInfo COLLECTION=Resumes KEY=ApplicantID TITLE=Title BODY=ResumeContent ACTION=REFRESH and yes - verity will support quite a few as you mentioned below - even .htm and .html pages, docs and more. jay miller Timothy Heald wrote: Is it running on CF? Isn't this what verity does? I am not sure, I have never used it, but I think you use it for making indexes of sites just like this, I believe that it can even index the db and any document (wprd, txt,pdf) that you have. Check out the studio docs on verity indexes. Hope it helps. Tim -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 11:10 PM To: CF-Talk Subject: RE: Unstructured info If you go to areas like this http://claimassist.workcover.com/TheLaw/thelaw.htm and start drilling down you'll see you get some interesting results that are unpalatable for a web site such as long menus and pages with further menus in them. It gives the impression of being structured because it sits inside a structured site but I suppose a better word to use night have also been variable length. http://claimassist.workcover.com/TheLaw/reg241of1999.htm http://claimassist.workcover.com/TheLaw/appendix.htm Pages like this http://claimassist.workcover.com/TheLaw/5a8ca04.htm probably do lend themselves to being in a database but I don't want to spawn lots of little tables etc within the database. The site has a search http://claimassist.workcover.com/Search/SearchFrameset.htm but sections that are in SQL also have a search http://claimassist.workcover.com/Precis_List/precis_list.htm and there is another section on the way like this so yet another search interface is created. With the whole thing in a database I figure I can reduce it one search interface. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 12:26 PM To: CF-Talk Subject: Re: Unstructured info Not sure if I can help, but if you give us some more information about your unstructured data, some of us may have a few helpful hints. Just give us some details. Paul Giesenhagen QuillDesign Doe anyone know if CF has been used to manage unstructured information. The problem/challenge. http://claimassist.workcover.com - about two thirds is structured and sits in a SQL server database. The rest is not and the result is ugly and difficult to manage and update etc. I'm considering some options but wondered if CF presented any. I want the whole thing in a database ideally. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. __ 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: Unstructured info
I am confused as to what you are trying to do exactly. Are you trying to build an index of content in order to search it? Or are you trying organize sections of content together into a web of links for navigation purposes. Or both? -Matt -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 8:20 PM To: CF-Talk Subject: RE: Unstructured info Currently it runs using HTML and ASP but I'm looking for alternatives because this is not producing the best results in my view. I hadn't thought of Verity (that's why this list and the people on it are so great) and I don't know if it can provide a solution - maybe someone on the slit can help here. TA ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 12:42 PM To: CF-Talk Subject: RE: Unstructured info Is it running on CF? Isn't this what verity does? I am not sure, I have never used it, but I think you use it for making indexes of sites just like this, I believe that it can even index the db and any document (wprd, txt,pdf) that you have. Check out the studio docs on verity indexes. Hope it helps. Tim -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 11:10 PM To: CF-Talk Subject: RE: Unstructured info If you go to areas like this http://claimassist.workcover.com/TheLaw/thelaw.htm and start drilling down you'll see you get some interesting results that are unpalatable for a web site such as long menus and pages with further menus in them. It gives the impression of being structured because it sits inside a structured site but I suppose a better word to use night have also been variable length. http://claimassist.workcover.com/TheLaw/reg241of1999.htm http://claimassist.workcover.com/TheLaw/appendix.htm Pages like this http://claimassist.workcover.com/TheLaw/5a8ca04.htm probably do lend themselves to being in a database but I don't want to spawn lots of little tables etc within the database. The site has a search http://claimassist.workcover.com/Search/SearchFrameset.htm but sections that are in SQL also have a search http://claimassist.workcover.com/Precis_List/precis_list.htm and there is another section on the way like this so yet another search interface is created. With the whole thing in a database I figure I can reduce it one search interface. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 12:26 PM To: CF-Talk Subject: Re: Unstructured info Not sure if I can help, but if you give us some more information about your unstructured data, some of us may have a few helpful hints. Just give us some details. Paul Giesenhagen QuillDesign Doe anyone know if CF has been used to manage unstructured information. The problem/challenge. http://claimassist.workcover.com - about two thirds is structured and sits in a SQL server database. The rest is not and the result is ugly and difficult to manage and update etc. I'm considering some options but wondered if CF presented any. I want the whole thing in a database ideally. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. __ Get the mailserver that powers this list at http://www.coolfusion.com 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
RE: Unstructured info
Both - the ideal situation is the whole think in a database with a single search interface. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 1:43 PM To: CF-Talk Subject: RE: Unstructured info I am confused as to what you are trying to do exactly. Are you trying to build an index of content in order to search it? Or are you trying organize sections of content together into a web of links for navigation purposes. Or both? -Matt -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 8:20 PM To: CF-Talk Subject: RE: Unstructured info Currently it runs using HTML and ASP but I'm looking for alternatives because this is not producing the best results in my view. I hadn't thought of Verity (that's why this list and the people on it are so great) and I don't know if it can provide a solution - maybe someone on the slit can help here. TA ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 12:42 PM To: CF-Talk Subject: RE: Unstructured info Is it running on CF? Isn't this what verity does? I am not sure, I have never used it, but I think you use it for making indexes of sites just like this, I believe that it can even index the db and any document (wprd, txt,pdf) that you have. Check out the studio docs on verity indexes. Hope it helps. Tim -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 11:10 PM To: CF-Talk Subject: RE: Unstructured info If you go to areas like this http://claimassist.workcover.com/TheLaw/thelaw.htm and start drilling down you'll see you get some interesting results that are unpalatable for a web site such as long menus and pages with further menus in them. It gives the impression of being structured because it sits inside a structured site but I suppose a better word to use night have also been variable length. http://claimassist.workcover.com/TheLaw/reg241of1999.htm http://claimassist.workcover.com/TheLaw/appendix.htm Pages like this http://claimassist.workcover.com/TheLaw/5a8ca04.htm probably do lend themselves to being in a database but I don't want to spawn lots of little tables etc within the database. The site has a search http://claimassist.workcover.com/Search/SearchFrameset.htm but sections that are in SQL also have a search http://claimassist.workcover.com/Precis_List/precis_list.htm and there is another section on the way like this so yet another search interface is created. With the whole thing in a database I figure I can reduce it one search interface. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 12:26 PM To: CF-Talk Subject: Re: Unstructured info Not sure if I can help, but if you give us some more information about your unstructured data, some of us may have a few helpful hints. Just give us some details. Paul Giesenhagen QuillDesign Doe anyone know if CF has been used to manage unstructured information. The problem/challenge. http://claimassist.workcover.com - about two thirds is structured and sits in a SQL server database. The rest is not and the result is ugly and difficult to manage and update etc. I'm considering some options but wondered if CF presented any. I want the whole thing in a database ideally. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail
RE: Unstructured info
What you need is a document management system not a relational database. Take a look on the net at some of the features of document management systems and I think you will find them to your likely. -Matt -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 9:30 PM To: CF-Talk Subject: RE: Unstructured info Both - the ideal situation is the whole think in a database with a single search interface. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 1:43 PM To: CF-Talk Subject: RE: Unstructured info I am confused as to what you are trying to do exactly. Are you trying to build an index of content in order to search it? Or are you trying organize sections of content together into a web of links for navigation purposes. Or both? -Matt -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 8:20 PM To: CF-Talk Subject: RE: Unstructured info Currently it runs using HTML and ASP but I'm looking for alternatives because this is not producing the best results in my view. I hadn't thought of Verity (that's why this list and the people on it are so great) and I don't know if it can provide a solution - maybe someone on the slit can help here. TA ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 12:42 PM To: CF-Talk Subject: RE: Unstructured info Is it running on CF? Isn't this what verity does? I am not sure, I have never used it, but I think you use it for making indexes of sites just like this, I believe that it can even index the db and any document (wprd, txt,pdf) that you have. Check out the studio docs on verity indexes. Hope it helps. Tim -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 11:10 PM To: CF-Talk Subject: RE: Unstructured info If you go to areas like this http://claimassist.workcover.com/TheLaw/thelaw.htm and start drilling down you'll see you get some interesting results that are unpalatable for a web site such as long menus and pages with further menus in them. It gives the impression of being structured because it sits inside a structured site but I suppose a better word to use night have also been variable length. http://claimassist.workcover.com/TheLaw/reg241of1999.htm http://claimassist.workcover.com/TheLaw/appendix.htm Pages like this http://claimassist.workcover.com/TheLaw/5a8ca04.htm probably do lend themselves to being in a database but I don't want to spawn lots of little tables etc within the database. The site has a search http://claimassist.workcover.com/Search/SearchFrameset.htm but sections that are in SQL also have a search http://claimassist.workcover.com/Precis_List/precis_list.htm and there is another section on the way like this so yet another search interface is created. With the whole thing in a database I figure I can reduce it one search interface. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 29 May 2002 12:26 PM To: CF-Talk Subject: Re: Unstructured info Not sure if I can help, but if you give us some more information about your unstructured data, some of us may have a few helpful hints. Just give us some details. Paul Giesenhagen QuillDesign Doe anyone know if CF has been used to manage unstructured information. The problem/challenge. http://claimassist.workcover.com - about two thirds is structured and sits in a SQL server database. The rest is not and the result is ugly and difficult to manage and update etc. I'm considering some options but wondered if CF presented any. I want the whole thing in a database ideally. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged
RE: Unstructured info
This may sound like a silly question but I am having a hard time figuring this out. What is the CF equivalent to the VBScript UBound(arrayName,2)? I have been all through the docs and cant find it. Thanks, Dave __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Unstructured info
The function UBound(arrayname, 2) returns the greatest value from the second dimension of the array ArrayName. The closest function in CF to this is ArrayMax(arrayName) but that only returns the greatest value from a one dimensional array. You'll have to copy the values from second dimension of your array to a separate array and then get the ArrayMax of the new array. You might also want to check CFLib.org and see if there is a user defined function that will deal with multi-dimensional arrays. Jeff -Original Message- From: David Jones [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:19 PM To: CF-Talk Subject: RE: Unstructured info This may sound like a silly question but I am having a hard time figuring this out. What is the CF equivalent to the VBScript UBound(arrayName,2)? I have been all through the docs and cant find it. Thanks, Dave __ 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: UBound (was RE: Unstructured info)
In CF multi-dimensional arrays are just nested single-dimensional arrays. Thus you could use the following syntax to get the max value of the second dimension. ArrayMax(arrayName[1]) However, that assumes that there is only a single item in the first dimension. This leads me to the following untested UDF. function UBound(array, dimension) { if(dimension eq 1) return ArrayMax(array); else if(dimension eq 2) { var tmpArray = ArrayNew(1); for(itr = 1; itr lte ArrayLen(array); itr = itr + 1) tmpArray[ArrayLen(tmpArray + 1)] = ArrayMax(array[itr]); return ArrayMax(tmpArray); } else { //someone else can implement this case } } -Matt -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:32 PM To: CF-Talk Subject: RE: Unstructured info The function UBound(arrayname, 2) returns the greatest value from the second dimension of the array ArrayName. The closest function in CF to this is ArrayMax(arrayName) but that only returns the greatest value from a one dimensional array. You'll have to copy the values from second dimension of your array to a separate array and then get the ArrayMax of the new array. You might also want to check CFLib.org and see if there is a user defined function that will deal with multi-dimensional arrays. Jeff -Original Message- From: David Jones [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:19 PM To: CF-Talk Subject: RE: Unstructured info This may sound like a silly question but I am having a hard time figuring this out. What is the CF equivalent to the VBScript UBound(arrayName,2)? I have been all through the docs and cant find it. Thanks, Dave __ Get the mailserver that powers this list at http://www.coolfusion.com 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: UBound (was RE: Unstructured info)
Ok thanks, I'll look into this. Dave -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 1:55 AM To: CF-Talk Subject: RE: UBound (was RE: Unstructured info) In CF multi-dimensional arrays are just nested single-dimensional arrays. Thus you could use the following syntax to get the max value of the second dimension. ArrayMax(arrayName[1]) However, that assumes that there is only a single item in the first dimension. This leads me to the following untested UDF. function UBound(array, dimension) { if(dimension eq 1) return ArrayMax(array); else if(dimension eq 2) { var tmpArray = ArrayNew(1); for(itr = 1; itr lte ArrayLen(array); itr = itr + 1) tmpArray[ArrayLen(tmpArray + 1)] = ArrayMax(array[itr]); return ArrayMax(tmpArray); } else { //someone else can implement this case } } -Matt -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:32 PM To: CF-Talk Subject: RE: Unstructured info The function UBound(arrayname, 2) returns the greatest value from the second dimension of the array ArrayName. The closest function in CF to this is ArrayMax(arrayName) but that only returns the greatest value from a one dimensional array. You'll have to copy the values from second dimension of your array to a separate array and then get the ArrayMax of the new array. You might also want to check CFLib.org and see if there is a user defined function that will deal with multi-dimensional arrays. Jeff -Original Message- From: David Jones [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:19 PM To: CF-Talk Subject: RE: Unstructured info This may sound like a silly question but I am having a hard time figuring this out. What is the CF equivalent to the VBScript UBound(arrayName,2)? I have been all through the docs and cant find it. Thanks, Dave __ Get the mailserver that powers this list at http://www.coolfusion.com 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