I haven't had a chance to mess with it, but if you change your search to do a url to query function that should work. On another matter of Index Server seems for some reason I can not get my index to work. I have it up but it isn't showing any results for words I know are mentioned. Anyone have this problem before? Robert Everland III Web Developer Dixon Ticonderoga -----Original Message----- From: Keith Thornburn [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 11:18 AM To: CF-Talk Subject: RE: Index Server and setting maxRecords no I didn't Any more suggestions? Can the mh (maxhits) property be used somehow? Thanks, Keith -----Original Message----- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: 27 January 2001 00:51 To: CF-Talk Subject: RE: Index Server and setting maxRecords no I didn't Seems it has something to do with query to url function. Gonna play with it some more this weekend. Bob Everland -----Original Message----- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 3:58 PM To: CF-Talk Subject: RE: Index Server and setting maxRecords I did it Ok All it did was take some reading in to MSDN to find it http://msdn.microsoft.com/library/psdk/indexsrv/ixrefobj_7kah.htm add this after myconnection.open /*Max Records */ MyConnection.MaxRecords = 10; Haven't tested it yet as my catalog is reindexing. Robert Everland III Web Developer Dixon Ticonderoga -----Original Message----- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 11:28 AM To: CF-Talk Subject: RE: Index Server and setting maxRecords > I recognise the problems of GETTING ALL the records and then USING SOME of > them and had already tried the 'TOP n FROM' in the SQL statement but Index > Server barfed it back - invalid syntax as it is expecting to find a column > named 'TOP' When you're using TOP, are you specifiying the column fields, or just using "SELECT TOP 10 FROM" - this will confused SQL into thinking that the field "TOP" must be returned Can you try something like SELECT TOP 10 * FROM myTable This should return just the top 10 rows in most flavors of SQL, but some don't handle it I use "TOP 1" an awful lot instead of "COUNT(*)" as this will return if there are any rows in the table and is logarithmically faster than count on large numbers of rows... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ********************************************************************** 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 Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
