RE: Verity w/ Queries
Has anyone had any Verity issues w/ CF 5? I am indexing a Query and the bottom records of my recordset are not being indexed. If I reverse the ORDER BY, then the records that are not being indexed are FOUND. THis seems like a bug... any Ideas? I don't have maxrows specified at all and my query is returning the proper data... seems lost in CFINDEX. Have you tried CFDUMPing out the query before you CFINDEX it? Sometimes the query you're looking at might not quite be what you're expecting Check it's all there first Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Verity w/ Queries
I am experiencing problems with indexing as well - seems like the indexing is having trouble finishing... but when it does - it seems to include all the records. I am having it index 9000 word documents. I am not familair with cfdump though and the verity. Do I need to call that seperately or can I run that call above the indexing commands? jay miller Philip Arnold - ASP wrote: Has anyone had any Verity issues w/ CF 5? I am indexing a Query and the bottom records of my recordset are not being indexed. If I reverse the ORDER BY, then the records that are not being indexed are FOUND. THis seems like a bug... any Ideas? I don't have maxrows specified at all and my query is returning the proper data... seems lost in CFINDEX. Have you tried CFDUMPing out the query before you CFINDEX it? Sometimes the query you're looking at might not quite be what you're expecting Check it's all there first Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ 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: Verity w/ Queries
I am experiencing problems with indexing as well - seems like the indexing is having trouble finishing... but when it does - it seems to include all the records. I am having it index 9000 word documents. I have a tendency of doing a CFSEARCH immediately on a CFINDEX and comparing it to the query, it should return the number of records to be the same I am not familair with cfdump though and the verity. Do I need to call that seperately or can I run that call above the indexing commands? CFDUMP is a standard command in CF5, if you're using CF4.x then download CF_DUMP from the Developers Exchange It allows you to output a variable (query, array, whatever) on the page - I had a problem where it appeared that the CFINDEX was missing things - turned out that the query wasn't returning all of the rows (something in the WHERE statement that was causing the problem) Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ 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