Re: Weird issue with SOLR and cfindex - it won't index more than 10k rows
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 uncommitted. Run the following after indexing. and see if that commits the remaining documents. >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 if there's anyone out there who's had experience >with this before > > > > > >On 25 February 2013 15:19, Edward Chanter wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354703 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Web services
The wsdl extension can be disabled by administrators. If that is the case then this feature would have to be enabled to allow web services to be used . This may or may not be the case but it is a possibility. >> Also, make sure that webservices are enabled in the web >> server. IIS I believe defaults to disabled for webservices. > >There is nothing special you need to do in IIS to publish CF web services. > >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 Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Web services
Is your .cfc mapped in your web server confguration ? Also, make sure that webservices are enabled in the web server. IIS I believe defaults to disabled for webservices. >Hi All, > >I am quite new to CF webservices, I am trying an example and when I try to >create a WSDL file I don't get any XML file displayed. I only get the >contents of the CFC file instead. > >Could someone help me in this regard. > >Thanks for your help in advance. ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265001 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: COM object syntax in CF 5
Is this the same server on which the ASP code works? If not is the COM object registered on the new server ? > Hello: > > I ported ASP code below and I am having a problem, > > <% > Dim trans > Set trans = Server.CreateObject ("Paymentech.Transaction") > trans.Type = "CC.Authorize" > trans.Field("MessageType") = "A" > %> > > TO: > #1 > #2 > #3 trans.Type = "CC.Authorize"; > #4 trans.Field("MessageType") = "A"; > #5 > > An I get an error on line 4: > Illegal left hand side of assignment near line 4, column 2. Left hand > side cannot be a function call. > > What is the correct syntax? > Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256402 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Another MSSQL issue, why is DISTINCT so slow?
Sorry about that. Try this SELECT gd.GenreDisplayName, gd.GenreDisplayID FROMProductData.dbo.t_PI_GenresDisplay gd JOINProductData.dbo.t_PI_L_GenresGenresDisplay lggd ON gd.GenreDisplayID = lggd.GenreDisplayID JOINProductData.dbo.t_PI_Genres g ON (lggd.GenreID = g.GenreID) JOINProductData.dbo.t_PI_L_MainGenres lmg ON (g.GenreID= lmg.GenreID) JOINProductData.dbo.t_PI_Main m ON (lmg.ProductID = m.ProductID) WHEREm.checkEdited = 1 ANDm.ProductGroupID = 3 ANDgd.GenreDisplayID != 1 group by gd.GenreDisplayName, gd.GenreDisplayID ORDER BY GenreDisplayName >I am running the following query... > >SELECT DISTINCT gd.GenreDisplayName, gd.GenreDisplayID >FROM ProductData.dbo.t_PI_GenresDisplay gd > JOIN ProductData.dbo.t_PI_L_GenresGenresDisplay lggd ON >(gd.GenreDisplayID = lggd.GenreDisplayID) > JOIN ProductData.dbo.t_PI_GenresgON >(lggd.GenreID = g.GenreID) > JOIN ProductData.dbo.t_PI_L_MainGenres lmg ON (g.GenreID >= lmg.GenreID) > JOIN ProductData.dbo.t_PI_Main mON >(lmg.ProductID = m.ProductID) >WHEREm.checkEdited = 1 > ANDm.ProductGroupID = 3 > ANDgd.GenreDisplayID != 1 >ORDER BY GenreDisplayName > >And it takes 1m 15s to return the 46 rows in the result set. > >If I remove the DISTINCT constraint it returns 2732 rows in under a second. >How can it posibly take so long to remove the duplicates? > >What can I do to speed this up as it is a requirement but 1:15 is >unacceptable. > >-- >Jay ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Another MSSQL issue, why is DISTINCT so slow?
Try this: SELECT DISTINCT gd.GenreDisplayName, gd.GenreDisplayID FROMProductData.dbo.t_PI_GenresDisplay gd JOINProductData.dbo.t_PI_L_GenresGenresDisplay lggd ON gd.GenreDisplayID = lggd.GenreDisplayID JOINProductData.dbo.t_PI_Genres g ON (lggd.GenreID = g.GenreID) JOINProductData.dbo.t_PI_L_MainGenres lmg ON (g.GenreID= lmg.GenreID) JOINProductData.dbo.t_PI_Main m ON (lmg.ProductID = m.ProductID) WHEREm.checkEdited = 1 ANDm.ProductGroupID = 3 ANDgd.GenreDisplayID != 1 group by gd.GenreDisplayName, gd.GenreDisplayID ORDER BY GenreDisplayName >I am running the following query... > >SELECT DISTINCT gd.GenreDisplayName, gd.GenreDisplayID >FROM ProductData.dbo.t_PI_GenresDisplay gd > JOIN ProductData.dbo.t_PI_L_GenresGenresDisplay lggd ON >(gd.GenreDisplayID = lggd.GenreDisplayID) > JOIN ProductData.dbo.t_PI_GenresgON >(lggd.GenreID = g.GenreID) > JOIN ProductData.dbo.t_PI_L_MainGenres lmg ON (g.GenreID >= lmg.GenreID) > JOIN ProductData.dbo.t_PI_Main mON >(lmg.ProductID = m.ProductID) >WHEREm.checkEdited = 1 > ANDm.ProductGroupID = 3 > ANDgd.GenreDisplayID != 1 >ORDER BY GenreDisplayName > >And it takes 1m 15s to return the 46 rows in the result set. > >If I remove the DISTINCT constraint it returns 2732 rows in under a second. >How can it posibly take so long to remove the duplicates? > >What can I do to speed this up as it is a requirement but 1:15 is >unacceptable. > >-- >Jay ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Placing a pointer in cfchart
Actually, you can go the the XML style tab and select all; copy and paste and save that as an xml file in the save it in the /charting/styles/ directory. If for example you name the file "mystyle.xml" , in the cfchart call, specify style="mystyle" and that should apply the style to your chart. >> how do i do it without the .jsp? > >You'll need to read the JSP code and write CF code that does the same thing. >Fortunately, that should be pretty straightforward, since most of the work >will presumably be done by the JAR files. > >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 Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255305 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Placing a pointer in cfchart
There is no need to deploy jsp pages. What specifically is not working ? > hi james, i have followed the instructions in the pdf file that is in > the same directory. But unfortunately it is not running. It says to > setup the server, deploy the relevant directories to the web root. and > then deploy the chart that i generated a sa jsp page. > > when i try to run the page i am getting an error saying 500 translator > wrong case > > i am using cf built in server on my local machine. Should i be putting > a reference to the jsp somewhere, or can i run the jsp on its own in > the browser? > > thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255266 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ajaxcfc install
If you move the ajax.cfc file then you need to change the mapping in your cfc to the match. For example, if Ajax.cfc is in the CustomTag directory under com/mysite/ajax.cfc then you need to change to . If you put it in the root under {webroot}/ajax/ajax.cfc then it should change to and so on. As for the javascript files you include should do the same. _ajaxConfig = {'_cfscriptLocation':'myCFC.cfc', '_jsscriptFolder':'/Global/Javascript/ajaxCFC'}; This mapping means that myCFC.cfc is in the same folder as my calling page and that the javascript files are in the root directory under /Global/Javascript/ajaxCFC. In CF Studio just drag the ajax.js file into your template to get the proper mapping. > I'm sure there is a simple answer to this. I'm trying to get the echo > example loaded on a web site. If i go directly to the > ajaxcfc/examples/echo/index.cfm it works fine. When i try to move the > directory examples to the root i get javascript errors. Specificly > [object Error]. I figure there is a mapping someplace that needs to be > changed, but i can't find it. Anyone have this problem who can offer > me advice? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254828 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Placing a pointer in cfchart
Glad to help guys. One other thing that really helps with this tool is to load live data. Under the XML Model tab, there is a button called "Load From Database." If your datasource is setup as an ODBC Connection, then you can do this jdbc:odbc:MyDataSource with the username and password. Then just drop in your query at the bottom and you are working with real data instead of the default xml. >Yeah, that IS fantastic. Nice tip! > >On 9/25/06, Richard White <[EMAIL PROTECTED]> wrote: >> >> thanks james thats fantastic :) >> ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254244 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Placing a pointer in cfchart
Richard, There is a chart available that does what you want. It is not documented so you'll have to use the chart editor to find it. In {cfxm root}/charting/ there is a file called webcharts.bat Dbl-click this and that will launch a Java-based editor. It may take a while to launch. Once it has launched, click file->New and from the dialog box pick the yellow chart in the middle row on the left. This will give the option of two charts that resemble gauges. Choose one and then modify the properties to adjust colors and so on. If you need help there is a pdf file in the same directory. HTH James McCullough >>On 9/22/06, Richard White <[EMAIL PROTECTED]> wrote: > >thanks for your help, i thought as much. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254131 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4