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 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

2006-12-27 Thread James Mc
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

2006-12-26 Thread James Mc
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

2006-10-11 Thread James Mc
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?

2006-10-04 Thread James Mc
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?

2006-10-04 Thread James Mc
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

2006-10-03 Thread James Mc
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

2006-10-03 Thread James Mc
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

2006-09-29 Thread James Mc
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

2006-09-26 Thread James Mc
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

2006-09-25 Thread James Mc
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