Re: Bluehost.com
We have used them for a couple sites. Always had good customer service and up time. On Thu, May 8, 2014 at 2:33 PM, Phillip Vector vec...@mostdeadlygame.comwrote: http://www.bluehost.com/vps Anyone use these guys (or have used them)? How are they? ~| 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:358589 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join Woes
I guess it could be both. While some part numbers can fit multiple years, makes, and models of a vehicle others just fit one. The top 200 are our best selling radiators. In theory, i want to hit the master table, pull out all the information on the radiator based on the part number being supplied from the top 200. Here is a query with all the fields from the Master table, and the Top 200 table has nothing but a part number: SELECT GriffinDataRevised.PartNumber, GriffinDataRevised.Make, GriffinDataRevised.Model, GriffinDataRevised.Year, GriffinDataRevised.Engine, GriffinDataRevised.Edition, GriffinDataRevised.TransCooler, GriffinDataRevised.OilCooler, GriffinDataRevised.HorsePower, GriffinDataRevised.Comments, GriffinDataRevised.Outlets, GriffinDataRevised.TubeSize, GriffinDataRevised.Rows, GriffinDataRevised.CoreSize, GriffinDataRevised.Revision FROM GriffinDataRevised INNER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.part_number WHERE GriffinDataRevised.PartNumber = Top200.part_number ORDER BY Make DESC Does that help? Thank you so much for bearing with me. On another not, the query that brought back 98 results may have been working right, i found another 78 records in another table for race car radiators, i'm almost guessing that the last few are in another table that would make the total 200 records. But i'm now getting an error that the part_number field is ambiguous. Ugh Thank you! On Tue, Feb 1, 2011 at 1:47 PM, Ian Skinner h...@ilsweb.com wrote: On 2/1/2011 10:22 AM, Aaron Renfroe wrote: Hello Ian and thank you! But my query was still running wrong, correct? Not necessarily, maybe your data is wrong. You may need to provide some more description on what data is in each of these tables and how you are trying to utilize it before we can help much more. IS there a ONE TO ONE or a ONE TO MANY relationship between Top200 and GriffinDataRevised? If ONE TO MANY, do you not want all the record from the MANY side? IF not all the records, which record of the MANY is the one that you want? ~| 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:341797 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join Woes
Thank you! I will research the UNION Clause. You have been a great help! On Tue, Feb 1, 2011 at 3:13 PM, Ian Skinner h...@ilsweb.com wrote: On 2/1/2011 11:35 AM, Aaron M Renfroe wrote: On another note, the query that brought back 98 results may have been working right, i found another 78 records in another table for race car radiators, i'm almost guessing that the last few are in another table that would make the total 200 records. Then you are probably looking at three SELECT statements to return all the desired data for the record set. My first choice would probably to do all three SELECTS in a single query with a UNION clause to combine them into one record set. But this is not the only option available. ~| 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:341800 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Permanent Redirect (301)???
I'm not sure, i have both addr's on google's webmaster tools, but they show different stats, CTR, Bounce Rates etc. between the www. and the non www. On Tue, Jan 18, 2011 at 4:23 PM, Che Vilnonis ch...@asitv.com wrote: I believe Google's webmaster tools has the option to treat www and non-www traffic as the same? ~Che -Original Message- From: Aaron Renfroe [mailto:mossma...@gmail.com] Sent: Tuesday, January 18, 2011 4:07 PM To: cf-talk Subject: CF Permanent Redirect (301)??? Hello Everyone! I've been optimizing my site and checking it in google's webmaster tools, fixing it all to be a SEO sensation (LOL). I keep getting the advice to use a permenant redirect from my www.griffinrad.com to griffinrad.com. Here is what its saying to do: .cfheader statuscode=301 statustext=Moved permanently .cfheader name=Location value=http://www.new-url.com; My issue is i only have the one site (griffinrad.com), there is no old or new site that i'm redirecting. I'm just trying to get the people that put www before the url. When i look at my CTR and traffic, the WWW is hurting bad, but the non www url is doing well. How do i use this option? Do i really just put it at the top of all my pages and tell it to re-direct back to its self? That doesn't make allot of sense... Thank you in advance! Aaron P.S. Has anyone used http://websitegrader.com/ by HubSpot? I was curious of the validity of the information and advice. ~| 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:340990 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Permanent Redirect (301)???
Would i place that in my application.cfm or at the top of my pages? On Tue, Jan 18, 2011 at 4:35 PM, Robert Harrison rob...@austin-williams.com wrote: I believe Google's webmaster tools has the option to treat www and non-www traffic as the same? Actually Google dislikes you using both and it will hurt SEO rankings. We use the www version only, but you could easily alter this routine to go the other way. This is tested... cfset rootip=http://www.mysite.com; cfif Find( www.,cgi.http_host) is false cfset jump=#rootip# cfset jump=#jump##cgi.request_uri# cfif trim(cgi.query_string) is not cfset jump=#jump#?#cgi.query_string# /cfif cflocation url=#jump# addToken=no statusCode=301 /cfif Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| 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:340997 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: br instead of br /
Can't you do a simple search and replace after your done editing? I'm not familiar with fckeditor but it should have some type of replace feature. On Mon, Nov 29, 2010 at 4:35 PM, Matt Quackenbush quackfu...@gmail.comwrote: Cool beans, Terry. Glad you found what you needed. And thanks for posting back. I'm sure someone else will indeed find it useful. ~| 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:339591 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfdirectory -- Element ROWCOUNT is undefined in MYFILELIST.
That was it Thanks!!! On Wed, Nov 17, 2010 at 10:15 AM, wrote: Hi, Try recordCount instead of rowCount. ~| 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:339311 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
