Re: PDF merge works once, then fails
Okay, I think there is a bug using cfpdfparam nested within cfpdf action="merge". I pulled the cfpdfparams out, opting instead for a comma-separated list in the Source attribute, and it works. This works: Null pointer after a single iteration: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295798 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
PDF merge works once, then fails
I am trying to merge two separate PDF files into a single two-page file. I'm doing this as part of a loop of 125 records. And I'm losing my mind. The cfpdf merge works one time--the first time--and then returns NullPointerException. It doesn't matter which record I handle first--if I start at record 1, record 2 fails. If I start at record 2 it works but record 3 fails. If I start at record 50 it works but record 51 fails, and on and on. What would cause a nullpointerexception in this case? My code is obviously checking out--it does what it should the first time--and I have no idea what to try next. I'm puzzled. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295796 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Homesite enhancement project?
> For each snippet you can assign a set trigger trigger characters such as > "cff" for a snippet that inserts a cffunction block. When you type that > trigger followed by ctrl+i it will insert the snippet and prompt you for > any custom snippet variables in the snippet. You can configure a > different shortcut to use instead of ctrl+i. That's something I could probably adapt to... Are there plans to adopt assignable keyboard shortcuts in future versions, or will these trigger characters be the only available functionality long term? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190342 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Homesite enhancement project?
I was ready to make the switch from HS+ to CFE until I saw an enhancement request on Tigris that led me to believe you can't assign your own keyboard shortcuts to tags and snippets. That alone was enough for me to snuggle back up with Homesite+... On Thu, 13 Jan 2005 17:23:21 -0400, Stan Winchester <[EMAIL PROTECTED]> wrote: > I would like to be able to right click on tags to open a tag editor like > in HS. > > It would be nice if HS/CF Studio snippets could be imported. > > >Hi Robert, > > > >Can you give some more details on what would need to mature in cfeclipse > >before you would switch to it? > > > >Spike > > > >Robert Munn wrote: > >> > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190337 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: John Dowdell Wants to Know What's Wrong with Macromedia
Speaking of RIA/Flex, has anybody here experimented much with Laszlo? I'm curious to see how it will stack up. http://www.laszlosystems.com/developers/ -Paul On Wed, 12 Jan 2005 14:24:29 +0100, RADEMAKERS Tanguy <[EMAIL PROTECTED]> wrote: > Here in Europe it's 14,000 EUR = ~18,000 USD. At that price it would be > worth physically going to the US to buy a copy, except then i guess MM > wouldn't support it. That kind of pricing policy sticks in my throat. > > /t > > > >-Original Message- > >From: Calvin Ward [mailto:[EMAIL PROTECTED] > >Sent: Tuesday, January 11, 2005 8:53 PM > >To: CF-Talk > >Subject: RE: John Dowdell Wants to Know What's Wrong with Macromedia > > > >I disagree on pricing for Flex... 12,000 per server for > >presentation layer > >only is nuts! > > > >-Original Message- > >From: Adrocknaphobia [mailto:[EMAIL PROTECTED] > >Sent: Tuesday, January 11, 2005 2:34 PM > >To: CF-Talk > >Subject: Re: John Dowdell Wants to Know What's Wrong with Macromedia > > > [snip] > >Flex is priced just right, and when all you kids started ranting about > >the cost, they allowed you to get developer version for free. > [snip] > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190080 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Revised Thread - Uploading CSV and Validation
If you're using SQL Server, you can create a DTS package then call it from CF. I couldn't believe the difference in speed when I switched to DTS. (If you need to use CF to validate the incoming data, use DTS to populate a temp table, CF to pull it out and insert the validated data into its permanent home. I'd wager still much quicker than using a loop over cffile contents, though I'd be curious to know if you wind up trying both...) On Mon, 10 Jan 2005 17:36:09 -0500, Ken <[EMAIL PROTECTED]> wrote: > Hi. I want to enable the user to upload a csv file, then the data > should be validated against pre-defined criteria for different columns > in the csv file. Once that is done, I want to write the validated > rows from the csv file to the DB. > > Please help. > > Thanks, > Ken > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189866 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Authorize.net
I've used Authorizenet a few times. Here's a test script that is a bit dated - I think it'll still work as is but they may have made some minor changes in the past year... https://secure.authorize.net/gateway/transact.dll"; METHOD="POST" RESOLVEURL="no"> On Thu, 6 Jan 2005 11:50:56 -0500, Ryan Mannion <[EMAIL PROTECTED]> wrote: > Has anyone used authorize.net for thier payment processing gateway? > > I sent an email asking about how the control would work. I've only > used Verisign Pay Flow Pro in the past. This is thier response. > > "This is the flow of control for AIM: > - The customer submits the order form on your web site. > - This form will post into a script on your server. > > This script must do the following: > - Make a Direct Socket Connection to our Transact.DLL using SSL. > - Submit the transaction details. - Transact.DLL processes the transaction and > generates the results. > - The results are returned directly to the script that created the connection. > - Generate the receipt page using the results of the transaction that were > returned." > > How would I make a direct socket connection to thier transact.dll > using SSL? I know how to install and configure the SSL cert, but how > would I make a Direct Socket Connection in Cold Fusion? > > Any suggestions would be welcomed! > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189547 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: US Weather from NWS (was RE: CF-Tag Weather for UK (London)?)
For US weather I've had decent luck with this weather service. (it
does tend to be a bit slow the first call, occasionally timing out.
But I suspect that's my fault, not theirs.)
http://www.ejse.com/WeatherService/Service.asmx?WSDL";>
On Wed, 5 Jan 2005 10:09:28 -0600, Russel Madere
<[EMAIL PROTECTED]> wrote:
> I'm afraid I'm going to have to go back to trying to do a screen scrape
> of the forecast. But the blamed thing is fairly confusing.
>
> I might just need to stick with the current observations without the
> forecast. The NWS has a good XML feed for that and CFHTTP seems to work
> fine.
>
> Russel Madere
> Webmaster
> 504.832.9835
> SunShine Pages by EATEL
> www.sunshinepages.com
>
> -Original Message-
> From: Jeff Garza [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 05, 2005 9:52 AM
> To: CF-Talk
> Subject: Re: US Weather from NWS (was RE: CF-Tag Weather for UK
> (London)?)
>
> I've had no luck whatsoever either. Glad you got through to the NWS
> webmaster.
>
> If you find a resolution, please let me know!
>
> Cheers,
>
> Jeff Garza
>
> - Original Message -
> From: "Russel Madere" <[EMAIL PROTECTED]>
> To: "CF-Talk"
> Sent: Wednesday, January 05, 2005 8:44 AM
> Subject: US Weather from NWS (was RE: CF-Tag Weather for UK (London)?)
>
> > Has anyone had luck access in the US National Weather Service? I have
> > tried this code (some of the sloppiness here is trying to find the
> > error):
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >ws = CreateObject("webservice",
> > "http://www.nws.noaa.gov/forecasts/xml/DWMLgen/wsdl/ndfdXML.wsdl";);
> > aString = ws.NDFDgen(parameters);
> >
> >
> >
> >
> >
> > And get this error:
> >
> > Web service operation "NDFDgen" with parameters
> >
> {{LATITUDE={38.9936},LONGITUDE={-77.0224},PARAMETERS={{WAVEH={true},TEMP
> >
> ={true},WDIR={true},SNOW={true},WX={true},ICONS={true},DEW={true},POP12=
> >
> {true},MINT={true},SKY={true},WSPD={true},MAXT={true},QPF={true},}},ENDT
> >
> IME={2005-01-01T00:00:00},PRODUCT={glance},STARTTIME={2004-01-01T00:00:0
> > 0},}} could not be found.
> > The error occurred on line 30.
> >
> > Line 30 is my call of the web service function. I have spoken with
> the
> > NWS web master and was told that the problem is with ColdFusion's http
> > calling method. The NWS uses Akami as the backbone and requires HTTP
> > 1.1 calls. I think this is BS, but still need help.
> >
> > Russel Madere
> > Webmaster
> > 504.832.9835
> > SunShine Pages by EATEL
> > www.sunshinepages.com
> >
> >
> [snip]
>
>
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189425
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
session timeouts per user
I have some users of our extranet that use the tools throughout the day from within our network. To make their day simpler I expire the sessions every 8 hours so they only log in once regardless of how long it's been since they used the tools. Now I have a request to allow access for select customers externally. The varying permissions are no problem, but I'd like to expire their sessions after 30 minutes rather than 8 hours. Is there a good way to set the session timeout depending on the permissions of the user who logged in? -Paul ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189418 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: query optimization
> > Did the execution plan change? Nope, no change in the execution plan between the two queries you sent. (Hopefully these books I ordered will cover the execution plan stuff so I can learn to make heads or tails of what it's telling me!) -Paul ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: query optimization
> Yes. It also reminds me why I dislike the graphical execution > plans from MS SQL Server :-) How does one get a view other than the graphical representation? I poked around a bit but didn't know what to look for... > It looks like eliminating some rows earlier may help here: I implemented your latest version of the query and it actually returned in the same amount of time as your version previous, to the second. But, it is a huge improvement over the way it was when you began offering help, for which I'm grateful. It seems my best permanent solution will be to create a separate db and use DTS to bring the data I need for my reports into a more concise, report-friendly structure, and with your improvements in place the current system will be workable while I work on implementing that. Thanks for helping me learn a few things about sql! -Paul ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189152 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: query optimization
>(Which join type is hidden behind the popup?) Sorry I left that covered up this time... Look here: http://www.redmondinc.com/sos/exe_plan.gif Is that sufficient? >Can you give me the recordcount of the following queries: > SELECT DISTINCT proj_code, cust_job_num, cust_code, order_code > FROM ordr; -- 712 rows > SELECT DISTINCT tkt_code, tkt_date, truck_code, po, > truck_net_wgt, hler_code, order_code > FROM tick; -- 4724 rows > SELECT DISTINCT prod_descr, order_code > FROM ordl; -- 705 rows That's probably what you were asking for in your first message; sorry I misunderstood... thanks! -paul ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189079 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: query optimization
> I think that is still rather long. Can you update the execution > plan and index pages if you need it to go even faster? You're right, it is still too long. And it turns out it's taking about 15 seconds on average, even slower than I thought. I updated the execution plan scrshot and the indexes as well. (I did add the index to all three applicable tables.) The link again is http:www.redmondinc.com/sos/index.html I had never seen your technique of using what looks like a subquery in the join segment of a query - I'm guessing further optimization is available using another one of those? In fact when I learn how to do that I bet I can apply similar tricks to most of my reports and really speed things up all across the app. The funny thing is, our company is so new to modern technology, people were buying me drinks just for getting them the data, even when hung the db server for 90 seconds. Maybe if I really get things humming they'll buy me a new car or something... (I have 2 sql books en route, by the way... "I'm not a slacker, I'm doin' the work. I'm babystepping.") Thanks again for your time and advice. -Paul ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189057 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: query optimization
That is a huge improvement! The execution time is lower than 10 seconds now - that's amazing. For clarification, when I set up the index all I did was give it a name and tell it which column to index, then pressed OK. Nothing more to it? Do I need to do anything to tell the db to create the index, or does it just do that when I name it? That was really quite helpful, thanks again for your help. > > The delay is in the Sort/Distinct Sort step. The reason for that > step is that you have specified a DISTINCT in your query. If you > don't need that DISTINCT, remove it :-) > If you do need that DISTINCT, we are going to put it in another > place. Duplicate rows can only be the result of an inner join if > one or both of the source tables of that join have duplicate > rows. So if we move that DISTINCT to the table with the duplicate > rows and filter them out there, we don't have to do the distinct > later when the number of records has multiplied. > > So suppose the duplicate rows originate from the ordr table, try > the code below (adjust if the duplicates come from another table): > SELECT DISTINCT > t.tkt_code, > t.tkt_date, > t.truck_code, > t.po, > t.truck_net_wgt, > t.hler_code, > o.proj_code, > o.cust_job_num, > o.cust_code, > o.order_code, > k.curr_driv_empl_code, > l.prod_descr > FROM > tick t > INNER JOIN > (SELECT DISTINCT > proj_code, > cust_job_num, > cust_code, > order_code >FROM ordr > ) o > ON t.order_code = o.order_code INNER JOIN > truc k > ON t.truck_code = k.truck_code INNER JOIN > ordl l > ON t.order_code = l.order_code > WHERE (t.tkt_date BETWEEN '#arguments.start_date#' AND > '#arguments.end_date#') > > BTW, this was the reason for the question "How many of these rows > are relevant for the final result?". Obviously you can remove > rows from your tables without affecting the outcome of this > query. How many rows can you NOT remove without changing the > outcome? (Don't do that, strictly an exercise of the mind.) > > The other thing I noticed was that you don't have indexes on the > order_code field in the tick, ordr and ordl tables. Since you > join on this field, having it indexed might help by itself, and > if you get a merge join the outcome will be pre-ordered reducing > the work for the sort step. > > Jochem > ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189038 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: query optimization
Great, thanks for the additional info. Looking at the execution plan it's plain to see where the delay is, but I don't know what to do about it. So here goes. Here's a link to the query, execution plan, rows per table, and indexes. http://www.redmondinc.net/sos/ Thanks a billion for taking a look at this; I have much to learn. -Paul On Thu, 30 Dec 2004 21:59:28 +0100, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Paul Malan wrote: > >> > >>- the execution plan > > http://www.sql-server-performance.com/query_execution_plan_analysis.asp > > If you use on of the text options just send it to the list, if > you use a graphical option you need to make a screenshot and > upload it somewhere (the list doesn't allow attachments). > > > >>- table statistics for all 4 tables (rows and selectivity) > > How many rows are there in each table? > How many of these rows are relevant for the final result? > > > >>- table schema for all 4 tables (including indexes) > > What fields are there in each table (+ datatype)? > Which indexes does your table have? > > Jochem ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189030 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: query optimization
Do you mean to run a huge query every hour (or every n hours) to capture all data regardless of date, customer, or hauler? That would be potentially huge - over time many many tens of thousands of records. Is it feasible to store that giant recordset in memory? I hadn't considered that... Thanks for the reply. On Thu, 30 Dec 2004 15:22:57 -0500, Troy Murray <[EMAIL PROTECTED]> wrote: > Paul, > > How often does this data change? Depending on your version of CF, and > if the data changes say once every hour, how about creating a query to > cache this data and then use the above query to query that query. > > Just a quick thought. > > -t > > > On Thu, 30 Dec 2004 13:20:52 -0700, Paul <[EMAIL PROTECTED]> wrote: > > A little background first. > > > > My company loads about 100 semi-trucks each day with product extracted from > > our mine. We use 3rd party software to track the trucks, weights, invoices, > > etc., but the software has miserable reporting capabilities. Luckily the > > backend for this software is MSSQL Server so I can easily tie in across our > > intranet using CF, but unfortunately it is a terribly designed database so > > it's quite painful. My ability to modify the db directly is quite limited, > > but I suspect some of you may know tricks that might help speed things up. > > > > I have created a report that gathers data from four tables, accepting input > > to filter results by date, customer code, and/or hauler code. If no > > customer or hauler is selected, the query returns roughly 750 records for a > > one-week span. The trouble is, it takes nearly 90 seconds to query the > > data, during which time the processor spikes from approx. 2% to 100%, where > > it remains until the recordset is returned. The query is below - it seems > > pretty simple to me, but I'd sure appreciate any insight more experienced db > > people might offer me. > > > > select distinct t.tkt_code, t.tkt_date, t.truck_code, t.po, t.truck_net_wgt, > > t.hler_code, > > > > o.proj_code, o.cust_job_num, o.cust_code, o.order_code, > > k.curr_driv_empl_code, l.prod_descr > > > > from tick t inner join ordr o on t.order_code = o.order_code > > > > inner join truc k on t.truck_code = k.truck_code > > > > inner join ordl l on t.order_code = l.order_code > > > > where (t.tkt_date between '#arguments.start_date#' and > > '#arguments.end_date#') > > > > > > > > and t.hler_code = '#arguments.hauler_code#' > > > > > > > > > > > > and o.cust_code = '#arguments.cust_code#' > > > > > > > > > > ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189021 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: query optimization
See, I knew I wasn't familiar enough with SQL Server... What is the best way for me to gather the three items you've outlined below? If it can be obtained through enterprise mgr I can get it for you, I just know very little about "real" DBA tasks and fancy phrases like "execution plan." Hopefully my inexperience can be overcome and I can learn something valuable... Thanks for your response. - > Can you show us: > - the execution plan > - table statistics for all 4 tables (rows and selectivity) > - table schema for all 4 tables (including indexes) > > Jochem > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189019 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: AW: IgniteFusion anyone?
Unfortunately, Damien, Ryan is correct. As of BlueDragon 6.2, SSL connections will not be allowed to pass through the BD engine. This has come to light in the past weeks on New Atlanta's BlueDragon list. > The restrictions on the free version are regarding redistribution, i.e. > you're not allowed to. Beyond that it is somewhat feature limited but > only regarding high-end things like Java integration. > > Also, why wouldn't it support SSL? Your web server handles the HTTPS > session and passes the data back/forth to the CFML engine, the engine > doesn't have to care whether it is SSL or not. > > -- > Damien McKenna - Web Developer - [EMAIL PROTECTED] > The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 > #include > > > > -Original Message- > > From: Ryan Jones [mailto:[EMAIL PROTECTED] > > Sent: Thursday, December 16, 2004 10:54 AM > > To: CF-Talk > > Subject: Re: AW: IgniteFusion anyone? > > > > > Have you tried BlueDragon? They are, by far, the best and most > > > compatible. > > > > > > > I have tried Bluedragon and loved it. But, despite being > > "free", you are not allowed to use Bluedragon Server to run a > > website that is going to sell any kind of products. And it > > doesn't support SSL anyway. > > > > > > ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187917 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
