Re: cfindex is taking forever - and one more question

2015-04-13 Thread Les Mizzell
I've optimized things as much as I could by building a number of collections and limiting each to a specific doc type. Next question!! I'm trying to return a few sentences from each doc with the search term highlighted. So, I use "ContextPassages" like below. However, very rarely is #search

RE: cfindex is taking forever

2015-04-09 Thread Kevin Parker
lto:lesm...@bellsouth.net] Sent: Thursday, 9 April 2015 8:23 AM To: cf-talk Subject: cfindex is taking forever I'm working on building a search interface for a "document depo" on a site. The document folder has files going all the way back to 2005, and includes a number of 10+ meg

Re: cfindex is taking forever

2015-04-08 Thread Byron Mann
Not in front of a computer right now, but there is an option in the CFcollection tag to list or get a collection details (something like that). Pretty sure that gives you the record or document count and maybe even size . I think that is accessible while indexing is happening. You could possibly

Re: cfindex is taking forever

2015-04-08 Thread Les Mizzell
> That doesn't actually sound unreasonable, but it might be useful to > come up with a document count more specific than "very large". Approx 3000 documents - around 3 gb of data ... it's still running from what I can tell. ~

Re: cfindex is taking forever

2015-04-08 Thread Russ Michaels
you also have to take your disk iops into consideration. If you are on a VPS then this will give you much slower disk performance, especially if its not SSD, and actions like this can take a lot longer. On Wed, Apr 8, 2015 at 11:32 PM, Les Mizzell wrote: > > > I'm going to forget about it and

Re: cfindex is taking forever

2015-04-08 Thread Dave Watts
> The collection was created successfully as far as I can tell. However, > indexing has been running (or at least the wheel on my browser is still > turning) for almost 3 hours now. I'm going to forget about it and go mow > my grass and see what's happening when I finish. > > I'm thinking though .

Re: cfindex is taking forever

2015-04-08 Thread Les Mizzell
> I'm going to forget about it and go mow my grass and see what's happening when I finish. Well crap, somebody stole my lawnmower. This is why we can't have nice things ~| Order the Adobe Coldfusion Anthology now! http://

cfindex is taking forever

2015-04-08 Thread Les Mizzell
I'm working on building a search interface for a "document depo" on a site. The document folder has files going all the way back to 2005, and includes a number of 10+ meg pdf files, a few that are over 20 megs, countless Word and Excel files, Power Point presentations I don't have access

Re: Weird issue with SOLR and cfindex - it won't index more than 10k rows

2013-02-27 Thread Edward Chanter
Thanks for the insight James, I will definitely try that out. On 26 February 2013 23:40, James Mc wrote: > > The 10k records entry is only for autocommit which means that as soon as > your collections reaches 10k uncommitted docs it will commit them and then > start queuing up more. > > What c

Re: Weird issue with SOLR and cfindex - it won't index more than 10k rows

2013-02-26 Thread James Mc
The 10k records entry is only for autocommit which means that as soon as your collections reaches 10k uncommitted docs it will commit them and then start queuing up more. What could be happening is that you have more than 10k but less than 20k documents which would leave these documents uncom

Re: Weird issue with SOLR and cfindex - it won't index more than 10k rows

2013-02-26 Thread Edward Chanter
I did more digging into the Solr config XML for my collection, and found this in the updateHandler: 1 That seems to allow me to index more documents. Solr ended up not being able to do what I needed so I've used SQL full-text indexing instead. Just wanted to ask again

Weird issue with SOLR and cfindex - it won't index more than 10k rows

2013-02-25 Thread Edward Chanter
I'm trying to create a searchable index of database content using SOLR. It's a really simple implementation. The problem is that it won't let me index more that 10,000 rows of data. I can do 10k no problemo but as soon as I try to increase the number I get an HTTP 500 error from IIS, not CF, which

cfindex varity collection issue

2012-04-17 Thread Keith McGee
I am purging the collections and then updating them. I am indexing two directories using the same code with the exception of the directories and categoriee tree, ect. I understand it should take longer at the directory is 5x larger, im thinking it should take 30 - 40 min. Not 2 hours. First

CFINDEX and Encoding

2011-02-08 Thread Robert Nurse
Hi All, I've got a verity collection that I load periodically. Some of the data contains Unicode (English) characters. When they're retrieved and displayed, I get "?" and other odd characters. Would using language="unicode" on the

RE: Curious problem with CFINDEX

2010-11-02 Thread Jason Fisher
02, 2010 7:52 AM To: "cf-talk" Subject: RE: Curious problem with CFINDEX That is what I was going to say also, but I'm not sure if this is the case, it has been a long time since I used cfindex as I have always found it has no speed benefit over database queries, but If you chec

RE: Curious problem with CFINDEX

2010-11-02 Thread Russ Michaels
That is what I was going to say also, but I'm not sure if this is the case, it has been a long time since I used cfindex as I have always found it has no speed benefit over database queries, but If you check the cfdocs they seem to imply that you can index multiple types in the same colle

re: Curious problem with CFINDEX

2010-11-02 Thread Jason Fisher
: "cf-talk" Subject: Curious problem with CFINDEX Be grateful for some insight if anyone can help please. Have a CFINDEX script (FILE) that when run on its own against the test site correctly indexes 1 document. Have a CFINDEX script (CUSTOM) that when run on its own against the test databa

Curious problem with CFINDEX

2010-11-01 Thread Kevin Parker
Be grateful for some insight if anyone can help please. Have a CFINDEX script (FILE) that when run on its own against the test site correctly indexes 1 document. Have a CFINDEX script (CUSTOM) that when run on its own against the test database correctly indexes 5 rows. But when I run both

Re: Verity and CFINDEX missing rows

2009-04-27 Thread Dave Watts
I do the query to extract the records and then CFINDEX populates > the Verity collection from that query. > > The problem is that some records are not appearing in searches. > > An analysis of the problem reveals these symptoms. The body of the record > that constitutes the body in C

Verity and CFINDEX missing rows

2009-04-27 Thread Kevin Parker
. I have set up Verity to index the contents of a database - sounds simple enough - I do the query to extract the records and then CFINDEX populates the Verity collection from that query. The problem is that some records are not appearing in searches. An analysis of the problem reveals these

cfindex error "General failure. (-2)"

2008-07-31 Thread Brian Yager
I get the error "General failure. (-2)" when I run a simple collection. Here is the tag Now, I have several other scheduled tasks that are the exact same code just a different collection. They work fine. This one doesn't. The tasks do not overlap either. Can anyone give me some direction

Re: CFZIP and CFINDEX

2007-10-25 Thread Raymond Camden
One thing to not forget (I'm sure you know this), in CF7, Adobe did a major update of the embedded Verity engine, so it would surprise me if it didn't work in the past. On 10/25/07, Dave Watts <[EMAIL PROTECTED]> wrote: > > That's not what I see here. I used cfzip to create a zip. I > > included t

RE: CFZIP and CFINDEX

2007-10-25 Thread Dave Watts
> That's not what I see here. I used cfzip to create a zip. I > included the zip in a collection. When I searched against the > collection, Verity found a match in my zip. I had problems indexing zip files with Verity in the past; I shouldn't have assumed they were never fixed. Dave Watts, CTO,

Re: CFZIP and CFINDEX

2007-10-24 Thread Raymond Camden
That's not what I see here. I used cfzip to create a zip. I included the zip in a collection. When I searched against the collection, Verity found a match in my zip. On 10/24/07, Dave Watts <[EMAIL PROTECTED]> wrote: > > Using CFINDEX, will Verity index supported document t

Re: CFZIP and CFINDEX

2007-10-24 Thread Raymond Camden
On 10/24/07, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > In the latest of my series of most likely unanswerable Verity questions, I > have a question: > > Using CFINDEX, will Verity index supported document types in a Zip archive > that is created using CFZIP? Since CFZIP

RE: CFZIP and CFINDEX

2007-10-24 Thread Dave Watts
> Using CFINDEX, will Verity index supported document types in > a Zip archive that is created using CFZIP? No. 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 Washing

CFZIP and CFINDEX

2007-10-24 Thread Pete Ruckelshaus
In the latest of my series of most likely unanswerable Verity questions, I have a question: Using CFINDEX, will Verity index supported document types in a Zip archive that is created using CFZIP? Followup, loosely related question, is there any undocumented CFZIP functionality that will allow me

RE: MX6.1 cfindex custom2 max length?

2007-02-24 Thread Dave Phillips
out MX7. If someone has it and wants to test it and post it here for the archives, that would probably be nice to anyone else running across this issue. Dave -Original Message- Sent: Friday, February 23, 2007 9:00 AM To: CF-Talk Subject: MX6.1 cfindex custom2 max length? Does anyone kn

MX6.1 cfindex custom2 max length?

2007-02-23 Thread Dave Phillips
Does anyone know what the limit of length of a custom2 field in CFINDEX is? I'm running into what appears to be 2,047 characters, but I want to confirm (especially be able to find in docs if I can). I can't find it specified anywhere. Than

Re: cfindex

2007-02-14 Thread Michael Beins
It does ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVN

Re: cfindex

2007-02-14 Thread Tom Chiverton
On Wednesday 14 Feb 2007, Michael Beins wrote: > and then when running the cfindex action=update I'm using the UNC qualified > path (\\[server name\[path]\[name of collection]. I get a collection does > not exist error. Any Ideas or Thoughts? Can the user CF is running as ac

cfindex

2007-02-14 Thread Michael Beins
I am trying to run the cfindex tag on a collection that is on a different cf server then where the code is running. All the documentation I see says for the collection attribute but the name of the collection or the fully qualified path. I'm using the default path when creating the colle

Re: UNC collection path for cfindex

2007-02-13 Thread Michael Beins
Our Network admin says it is already running that way. Any other ideas? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14

Re: UNC collection path for cfindex

2007-02-13 Thread Albert Bussolino
On 2/13/07, Michael Beins <[EMAIL PROTECTED]> wrote: > I have code that allows users to upload new files. And when uploaded I have > that file >added >to the collection. Is it possible to index a collection > that is on a different server the >code >executing. Michael, you need to run the CF s

UNC collection path for cfindex

2007-02-13 Thread Michael Beins
I have code that allows users to upload new files. And when uploaded I have that file added to the collection. Is it possible to index a collection that is on a different server the code executing. Ex: Server 1 has the upload code, and you are uploading to the file/files to Server 2 where

CFLOCK around CFINDEX and CFSEARCH ???

2006-11-30 Thread Dave Phillips
Hi, on MX 6.1, do we need to put a CFLOCK around CFINDEX and CFSEARCH? I've read in some places we do, and in other places we don't. Can anyone confirm? We are having alot of CF restarts and are wondering if this is the issue (we do NOT currently have any CFLOCKS and we do

Re: cfindex type=file question

2006-10-13 Thread Jim Wright
Sixten Otto wrote: > > The information that the modification is needed is cleverly concealed > in a single sentence in the livedocs (and probably also the dead tree > version); see under "Field Searches": > http://livedocs.macromedia.com/coldfusion/7/htmldocs/1327.htm > > Then scroll down to

Re: cfindex type=file question

2006-10-12 Thread Sixten Otto
Jim Wright wrote: >That's what I was going for...I'm trying to test this out right now, but >so far, I'm not even getting results for exact matches...what was that >config file setting you changed? The information that the modification is needed is cleverly concealed in a single sentence in the

Re: cfindex type=file question

2006-10-12 Thread Jim Wright
Sixten Otto wrote: > If you're asking, "can I do field searches that still benefit from > the stemming, etc. that Verity applies to regular search words?" > then... I'm not sure. For example, if you put a set of keywords in > custom2, and wanted to do something like: cf_custom2:important > cf_cust

Re: cfindex type=file question

2006-10-12 Thread Sixten Otto
>Does using this syntax actually do a "search" of the custom1 field, or >just filter on exact matches? I'm not sure I understand exactly the distinction you're trying to draw, but I'll answer what I think your question might be. As I've written those examples (with the backticks around the stri

Re: cfindex type=file question

2006-10-12 Thread Jim Wright
> project requirements cf_custom1:`application/msword` > annual report cf_custom1:`application/pdf` > design templates cf_custom1:`text/html` Does using this syntax actually do a "search" of the custom1 field, or just filter on exact matches? ~~~

Re: cfindex type=file question

2006-10-12 Thread Sixten Otto
ments cf_custom1:`application/msword` annual report cf_custom1:`application/pdf` design templates cf_custom1:`text/html` You can do this with ANY field in the Verity index, not just the cf_* fields. (And there's a LOT of data in those indices. Including the category information you specify in

Re: cfindex type=file question

2006-10-12 Thread Jim Wright
loathe wrote: > Query of queries? > QoQ can be very effective when combining a Verity search with a database query...allowing you to output more than just the data that verity has indexed, but still keep the order intact. But in this case there would be a search that results in something like

RE: cfindex type=file question

2006-10-12 Thread Dave Watts
> The problem with this method is that you cannot effectively > sort your results according to the Verity "score". The > results from each collection would have their own score, and > I don't think it would be as simple as combining scores from > each matching result. It's certainly not a per

RE: cfindex type=file question

2006-10-12 Thread loathe
Query of queries? > -Original Message- > From: Jim Wright [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 12, 2006 2:35 PM > To: CF-Talk > Subject: Re: cfindex type=file question > > Dave Watts wrote: > > > > I don't think this is directly po

Re: cfindex type=file question

2006-10-12 Thread Jim Wright
Dave Watts wrote: > > I don't think this is directly possible. However, there's no reason why you > couldn't index your files and your database content separately. Then, when > someone searches, have them query both collections, and go through the > results and match your database entries to your

Re: cfindex type=file question

2006-10-12 Thread Jim Wright
Sixten Otto wrote: > > That's not the case. (Certainly not in MX7, but I don't think it was true in > earlier CF/Verity versions, either.) > > Our content management system uses the custom fields extensively when > indexing both database content and physical files. They're pretty much the > on

Re: cfindex type=file question

2006-10-12 Thread Sixten Otto
>> Have you checked out the custom1 to custom4 parameters of the >> tag? They might do what you want to do. > >They only work when you index database content. When you index filesystem >content, they're unavailable. That's not the case. (Certainly not in MX7, but I don't think it was true in e

RE: cfindex type=file question

2006-10-12 Thread Dan G. Switzer, II
Dave, >Does anyone know if there is a way to index additional "searchable" content >when indexing a file with the file in the database. When I index these files, I want to be able to >index the "content" of the file along with the "description" so that if a >person types in a part of the "descrip

RE: cfindex type=file question

2006-10-12 Thread Dave Watts
> Does anyone know if there is a way to index additional > "searchable" content when indexing a file with type="file> ?? > > Basically, I have files that are indexed, and we have a > "description" for the file in the database. When I index > these files, I want to be able to index the "conten

RE: cfindex type=file question

2006-10-12 Thread Dave Watts
> Have you checked out the custom1 to custom4 parameters of the > tag? They might do what you want to do. They only work when you index database content. When you index filesystem content, they're unavailable. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provi

RE: cfindex type=file question

2006-10-12 Thread Ian Skinner
Have you checked out the custom1 to custom4 parameters of the tag? They might do what you want to do. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run

cfindex type=file question

2006-10-12 Thread Dave Phillips
Hi all, Does anyone know if there is a way to index additional "searchable" content when indexing a file with http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256541 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subs

Re: CFIndex type=custom body

2006-08-02 Thread Jim Wright
> > I've already read that, but wanted to get a simpler translation. Does the > body tag tell the indexing which columns to include? I need a yes or not > answer and if no, what does it do. > Yes. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~

Re: CFIndex type=custom body

2006-08-02 Thread Tom Donovan
>Can someone please verify this for me. When using the cfindex tag and the >attribute >type=custom, the body attribute in the cfindex tag is used to list the columns >you want >included in the index? > >Thanks. > >D I've already read that, but wanted to get a si

Re: CFIndex type=custom body

2006-08-02 Thread Cutter (CFRelated)
.macromedia.com/coldfusion/6.1/htmldocs/tags-p64.htm#wp1100286 Cutter ___ http://blog.cutterscrossing.com [EMAIL PROTECTED] wrote: > Can someone please verify this for me. When using the cfindex tag and the > attribute > type=custom, the body attribute in the cfindex tag

CFIndex type=custom body

2006-08-02 Thread coldfusion . developer
Can someone please verify this for me. When using the cfindex tag and the attribute type=custom, the body attribute in the cfindex tag is used to list the columns you want included in the index? Thanks. D ~| Introducing the

RE: Referencing filenames in cfindex

2005-10-22 Thread Adrian Lynch
The file name should be in the query returned from cfindex. It might be fully qualified so treat it as a list and extract it. Could be wrong though! :OI Ade -Original Message- From: Lilly Spa [mailto:[EMAIL PROTECTED] Sent: 23 October 2005 01:42 To: CF-Talk Subject: Referencing

Referencing filenames in cfindex

2005-10-22 Thread Lilly Spa
I'm trying to run a cfindex on the files in a directory. Here's my syntax: This is one of three collections that I would like have use the same references such as custom1, custom2, etc. The only glitch I'm running into is with custom2. I would like that to be the filename.

Re: CFINDEX - how to add/update a single record in an existing collection?

2005-08-24 Thread Pete Ruckelshaus
Boy, it's just my day for search-related questions. I'm seeing something weird here and want to know if this is normal. I'm creating an index from a database query. The collection contains about 14k records, and the initial collection size (immediately upon creation) is about 79MB. Optimizing t

RE: CFINDEX - how to add/update a single record in an existing collection?

2005-08-24 Thread Dave.Phillips
ery day if you're only refreshing once a day. Dave -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 12:54 PM To: CF-Talk Subject: Re: CFINDEX - how to add/update a single record in an existing collection? I ended up taking Dave'

Re: CFINDEX - how to add/update a single record in an existing collection?

2005-08-24 Thread Pete Ruckelshaus
I ended up taking Dave's query for a single record approach because it simplified a number of things. Because of the nature of the app, I update some of the data one column at a time, but it still needs to be indexed immediately. I have a CFC with an updateCollection method that I just pass a col

RE: CFINDEX - how to add/update a single record in an existing collection?

2005-08-22 Thread Dave.Phillips
Yes, I agree. I only used this as an example since he said he already had his query info for one record. At least that was my understanding of his dilemma. The main point, Pete, that Ray & I are both trying to make is that your CFINDEX can be exactly the same whether your query has return

Re: CFINDEX - how to add/update a single record in an existing collection?

2005-08-19 Thread Pete Ruckelshaus
Well, since I know that I have had my LiveDocs edited or removed before, I don't put a lot of creedence in them, and I certainly wasn't impressed when I was notified of what was going on. And, no, my entries weren't inflammatory or derogatory. Pete ~~~

Re: CFINDEX - how to add/update a single record in an existing collection?

2005-08-19 Thread Raymond Camden
ld just execute a CFQUERY that would return that one record, > and as long as your KEY is the same, issue your cfindex just like you would > if you were indexing a query with 1,000 records. > > > select [your fields] > from [your table] > wher

Re: CFINDEX - how to add/update a single record in an existing collection?

2005-08-19 Thread S . Isaac Dealey
> PS Is it time to create an "Undocumented CF" web site? If > there's > enough interest and enough content, I'm willing to start > this as a > project...I just know that between things like > cfcollection (and > related tags), cfdocument, cfchart, and more that there's > a lot of > stuff that Macr

Re: CFINDEX - how to add/update a single record in an existing collection?

2005-08-19 Thread Raymond Camden
Yes, it would work. (or should work - yell at me if it doesnt) On 8/19/05, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > Sometimes, no, make that usually, Macromedia's documentation for CF > just barely scratches the surface. > > I have an existing collection that is populated from a query. The

RE: CFINDEX - how to add/update a single record in an existing collection?

2005-08-19 Thread Dave.Phillips
Pete, Actually, you would just execute a CFQUERY that would return that one record, and as long as your KEY is the same, issue your cfindex just like you would if you were indexing a query with 1,000 records. select [your fields] from [your table] where [your

Re: cfindex/cfsearch help with dates

2005-08-19 Thread Pete Ruckelshaus
Here's what I do. I file this under the category "elegant hack". The content that I want to index resides in a table. To over-simplify, the table contains a numeric identifier (key), text and date fields. I create a collection that indexes just text search terms (i.e. just the text fields). I

CFINDEX - how to add/update a single record in an existing collection?

2005-08-19 Thread Pete Ruckelshaus
Sometimes, no, make that usually, Macromedia's documentation for CF just barely scratches the surface. I have an existing collection that is populated from a query. The data returned from this query gets updated quite often. In order to allow accurate searches, I would like to add (for new recor

RE: cfindex/cfsearch help with dates

2005-08-19 Thread Dave.Phillips
pied, and by using the pipes, I can properly identify the date now. Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 9:46 AM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates Actually, you can use the CUSTOM1 field instead. The

Re: cfindex/cfsearch help with dates

2005-08-19 Thread Raymond Camden
like that? > > I'm going to try something like this. I'll let you know how it works... > > Dave > > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Friday, August 19, 2005 9:46 AM > To: CF-Talk > Subject: Re: cfind

RE: cfindex/cfsearch help with dates

2005-08-19 Thread Dave.Phillips
u know how it works... Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 9:46 AM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates Actually, you can use the CUSTOM1 field instead. The only difference

Re: cfindex/cfsearch help with dates

2005-08-19 Thread Raymond Camden
ation anyway for other projects I do (I have MX > 7 on my own servers). > > Thanks! > > Dave > > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Friday, August 19, 2005 8:56 AM > To: CF-Talk > Subject: Re: cfindex/cfsearch help wi

RE: cfindex/cfsearch help with dates

2005-08-19 Thread Dave.Phillips
August 19, 2005 8:56 AM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates CFMX7 dramatically improved the Verity support within CFMX. One of the new features is categories. So consider the follow example - you index your content daily. For content where the data is older than 7 days, you

RE: cfindex/cfsearch help with dates

2005-08-19 Thread Russ Michaels
Bucket anyone :-) -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 19 August 2005 13:56 To: CF-Talk Subject: Re: cfindex/cfsearch help with dates CFMX7 dramatically improved the Verity support within CFMX. One of the new features is categories. So consider the

Re: cfindex/cfsearch help with dates

2005-08-19 Thread Raymond Camden
> From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 18, 2005 6:12 PM > To: CF-Talk > Subject: Re: cfindex/cfsearch help with dates > > > How often do you index your data? If you do it daily, you could easily > use a category called "Last7Days&quo

RE: cfindex/cfsearch help with dates

2005-08-19 Thread Dave.Phillips
ould extend the index job time which is already at almost 2 hours. I'll be working on the QofQ today. Thanks, Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 6:12 PM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates Ho

Re: cfindex/cfsearch help with dates

2005-08-18 Thread Raymond Camden
it work. > > Thanks! > > Dave > > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 18, 2005 5:35 PM > To: CF-Talk > Subject: Re: cfindex/cfsearch help with dates > > > Another option you may want to consid

RE: cfindex/cfsearch help with dates

2005-08-18 Thread Dave.Phillips
within the last 7 days, so I'll just use the QofQ to make it work. Thanks! Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 5:35 PM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates Another option you may want to co

Re: cfindex/cfsearch help with dates

2005-08-18 Thread Raymond Camden
nal Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 18, 2005 5:14 PM > To: CF-Talk > Subject: Re: cfindex/cfsearch help with dates > > > After rereading your post, I believe the doc is referring to the > i

RE: cfindex/cfsearch help with dates

2005-08-18 Thread Dave.Phillips
amden [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 5:14 PM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates After rereading your post, I believe the doc is referring to the indexing of files, like Word docs, that have a date property. I don't believe you can do

Re: cfindex/cfsearch help with dates

2005-08-18 Thread Raymond Camden
e, theoretically I could return a query with a date I want > to search by, and when I do my cfindex, I would specify it like this? > > collection="collection" > action="update" > type="custom" > key

Re: cfindex/cfsearch help with dates

2005-08-18 Thread Raymond Camden
gt; > "if a document field named DATE is defined, you can search for documents > dated prior to and including December 31, 1999 by entering DATE <= 12-31-99 > in your search." > > Now, if this is true, theoretically I could return a query with a date I want &

cfindex/cfsearch help with dates

2005-08-18 Thread Dave.Phillips
s true, theoretically I could return a query with a date I want to search by, and when I do my cfindex, I would specify it like this? Then, when I search on this index, i could say search for: "stuff AND DATE >= 01-01-05" This would return only the documents which have a 'da

Re: cfindex issue? (Solved - Possible bug?)

2005-08-16 Thread Raymond Camden
> My concern, and wondering about whether there is a potential bug in CFINDEX > or not, is why did CF drop the last 48 records of the original query instead > of dropping the 48 duplicate keys? The 48 duplicates were included in my > CFSEARCH results, so they were added to the

RE: cfindex issue?

2005-08-16 Thread Gaulin, Mark
Is it possible that the key field in your data is not unique? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 9:30 AM To: CF-Talk Subject: cfindex issue? Hi, I have a query that I index. The query returns 2,481 records. When I

RE: cfindex issue? (Solved - Possible bug?)

2005-08-16 Thread Dave.Phillips
Well, I determined that in my case below, I had 48 records that were duplicate keys. By making all my keys unique, I ended up with the desired result. My concern, and wondering about whether there is a potential bug in CFINDEX or not, is why did CF drop the last 48 records of the original

cfindex issue?

2005-08-16 Thread Dave.Phillips
s from the original query result set are not found in the search result set. Any ideas as to what might be causing this? This is the first time I've encountered this inconsistency. My query looks like this: select key, body, title, custom1 from table my cfindex looks lik

RE: CFIndex for Verity quit working - Needs Attention by Macromedia!

2002-10-22 Thread Mark Leder
This is really interesting. I've got about 16,500 records, and about a 11 mb file now. What's REALLY puzzling is that it may not matter that I'm indexing from SQL2000 db or from MS Access - it didn't work either way. Yep, my index is empty - it doesn't seem to get o

RE: CFIndex for Verity quit working - Needs Attention by Macromedia!

2002-10-22 Thread Angel Stewart
ex. I used CFDUMP to output a CFSEARCH resulset run right after the index to test what it contained...and it was empty. -Gel -Original Message- From: Mark Leder [mailto:mel@;markleder.com] There is another Access db with only about 75 records and four fields in each record. Using

RE: CFIndex for Verity quit working - Needs Attention by Macromedia!

2002-10-22 Thread Mark Leder
Good question - I'll check. Thanks, Mark -Original Message- From: Al Musella, DPM [mailto:musella@;virtualtrials.com] Sent: Tuesday, October 22, 2002 3:53 PM To: CF-Talk Subject: RE: CFIndex for Verity quit working - Needs Attention by Macromedia! Is it possible that there

RE: CFIndex for Verity quit working - Needs Attention by Macromedia!

2002-10-22 Thread Mark Leder
There is another Access db with only about 75 records and four fields in each record. Using the same CFIndex tag (different collection), it continues to work properly. Two days ago, I tried the db in question using using record sizes of 25, 100, 500, 1000, 2500 and 5000. All were indexed by the

RE: CFIndex for Verity quit working - Needs Attention by Macromedia!

2002-10-22 Thread Al Musella, DPM
Is it possible that there isn't enough free disk space? > > > > > > The problem is, the CF index has quit working on this database. I > > have > > > not changed a single line of code. The CFQUERY prior to the > > CFINDEX > >

RE: CFIndex for Verity quit working - Needs Attention by Macromed ia!

2002-10-22 Thread Dave Watts
> Continues to be vexing. Deleted and recreated the > collection several times. Checked and repaired db > for corruption. Changed the name of collection and > reran. Upsized the data to SQL 2000, created a > collection and did a CFIndex. All without effect. > > Now I&

RE: CFIndex for Verity quit working - Needs Attention by Macromedia!

2002-10-22 Thread Mark Leder
Continues to be vexing. Deleted and recreated the collection several times. Checked and repaired db for corruption. Changed the name of collection and reran. Upsized the data to SQL 2000, created a collection and did a CFIndex. All without effect. Now I've got MM and the ISP talking. Goi

Re: CFIndex for Verity quit working - Needs Attention by Macromedia!

2002-10-22 Thread Richard Meredith-Hardy
I had a problem something like this with a verity collection based on a DB with about 50,000 records which occasionally falls over after about 10,000 alterations (despite daily optimizations). A CFINDEX action = "PURGE" followed by a CFINDEX action = "REFRESH" usually fixes it

RE: CFIndex for Verity quit working - Needs Attention by Macromedia!

2002-10-21 Thread Paris Lundis
t; <[EMAIL PROTECTED]> Date: Mon, 21 Oct 2002 13:13:39 -0400 Subject: RE: CFIndex for Verity quit working - Needs Attention by Macromedia! > I know nothing of the product but do recall a CF developer on another > list raving about dtSearch as a replacement for the version of Verity > p

RE: CFIndex for Verity quit working - Needs Attention by Macromedia!

2002-10-21 Thread Ken Wilson
] Sent: Monday, October 21, 2002 12:51 PM To: CF-Talk Subject: RE: CFIndex for Verity quit working - Needs Attention by Macromedia! Is it possible you are trying to index a recordset over 250,000 records? The following is paraphrased from a Verity publication detailing the Macromedia OEM agreement

RE: CFIndex for Verity quit working - Needs Attention by Macromedia!

2002-10-21 Thread Trey Rouse
> -Original Message- > From: Mark Leder [mailto:mel@;markleder.com] > Sent: Sunday, October 20, 2002 1:16 AM > To: CF-Talk > Subject: CFIndex for Verity quit working > > Hi everyone, > > My client has an MS Access 2002 db which is periodically uploaded to the

  1   2   >