RE: What *NOT* to do to screw up my google rankings...

2006-11-16 Thread Patrick Thomlinson
The 301 shouldn't, in theory, hurt your rankings.  The part to watch out
for is that Google has a tendency to index the new page and not remove
the old one so you end up with problems going to Supplemental Results.  

The best way to do what you are doing is to redirect products from one
manufacturer or another small grouping and see what happens before you
redirect your entire product line.  That way if there is going to be a
problem you can back out of it before you've totally committed yourself.

Patrick Thomlinson
Thomlinson Consulting
Certified Advanced CFMX Developer

-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 09, 2006 5:47 AM
To: CF-Talk
Subject: Re: What *NOT* to do to screw up my google rankings...

>redirects will kill your rankings!!

Bryan,

Even a 301 redirect like was suggested? 

Thanks much!

Will



~|
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:260637
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Where Date Statement in MySQL

2006-11-05 Thread Patrick Thomlinson
My bad.  That works in SQL Server I guess.

-Original Message-
From: Patrick Thomlinson [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 05, 2006 8:53 AM
To: CF-Talk
Subject: RE: Where Date Statement in MySQL

Try changing the "!=" in your query to "<>"

-Original Message-
From: Cornel Ivanescu [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 05, 2006 7:36 AM
To: CF-Talk
Subject: Re: Where Date Statement in MySQL

Tried multiple combinations of createOBDCdate() and CFQUERYPARAM with
CF_SQL_VARCHAR and it still does not work...I am missing something
elementary...removed the between clause and replaced it with 2
statements <= and >= 



   

SELECT * FROM tbl_picks
Where LEFT(tbl_picks.Pick_SKU,4) != "" and tbl_picks.Pick_SKU !=
"FREE"
and and ("LEFT(tbl_picks.Pick_SKU,10)" >= #createODBCDate(startdate)#
and "LEFT(tbl_picks.Pick_SKU,10)" <= #createODBCDate(enddate)#)
 

The Pick_SKU the first 10 char are the DATE 2006-11-03 followed by the
event and it is a string of up to 16 characters. Someone mentioned using
Convert() on the sql side and  I am wondering if you can give me an
example...since everytime I tried it gave me an error.

Any other ideas?
Cornel
 





~|
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:259217
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Where Date Statement in MySQL

2006-11-05 Thread Patrick Thomlinson
Try changing the "!=" in your query to "<>"

-Original Message-
From: Cornel Ivanescu [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 05, 2006 7:36 AM
To: CF-Talk
Subject: Re: Where Date Statement in MySQL

Tried multiple combinations of createOBDCdate() and CFQUERYPARAM with
CF_SQL_VARCHAR and it still does not work...I am missing something
elementary...removed the between clause and replaced it with 2
statements <= and >= 



   

SELECT * FROM tbl_picks
Where LEFT(tbl_picks.Pick_SKU,4) != "" and tbl_picks.Pick_SKU !=
"FREE"
and and ("LEFT(tbl_picks.Pick_SKU,10)" >= #createODBCDate(startdate)#
and "LEFT(tbl_picks.Pick_SKU,10)" <= #createODBCDate(enddate)#)
 

The Pick_SKU the first 10 char are the DATE 2006-11-03 followed by the
event and it is a string of up to 16 characters. Someone mentioned using
Convert() on the sql side and  I am wondering if you can give me an
example...since everytime I tried it gave me an error.

Any other ideas?
Cornel
 



~|
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:259216
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4