Re: Migrating a DB from MS SQL 2000 into MySQL latest release

[M P]

I second the comment on Navicat. It's intuitive and easy to use and the new 
Premium edition supports MS-SQL as well as MySQL, Postgre, Oracle and SQLite. 
And no, I don't have any affiliation with them, I just love their product :-)

I've converted several databases from MS-SQL to MySQL with no problems 
whatsoever. I now use Navicat exclusively to manage all of my client databases 
and I haven't even had to install the dreaded SQL Enterprise Manager on my new 
system (which makes me extremely happy because I can't stand Enterprise 
Manager).

For backups or transferring to a new server, I think Navicat is MUCH easier and 
more intuitive than Microsoft's built-in tools. Even moving a database from one 
MS-SQL Server to another is just a couple of clicks of the mouse.

With regards to the comment about the type of backup, I actually just schedule 
a nightly sync from my Production DB to a dedicated backup version on the 
Staging Server (or Development Server for clients that don't have a staging 
environment). This way, we actually have a LIVE fail over we can bring online 
almost immediately, while we repair or replace the Production server. I realize 
that might not be an option for all situations (especially really large DBs), 
but it's worked extremely well for me over the years.

I've never seen a MySQL database get corrupted and I've worked with hundreds of 
them (though granted most of them were fairly small).

Just my 2 cents worth.

-Mike


I'm interested in any info.  Pit falls to avoid, best practises, etc.

Many thanks,

Jenny
No virus found in this outgoing message.
Checked by AVG - www.avg.com
Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: 05/08/11
19:34:00 

~|
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:344462
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

ProFlashUpload

[M P]

Anyone familiar with ProFlashUpload? I downloaded it and got it working 
yesterday and it was working fine. Today, it only works in IE. Yesterday I know 
it was working in Firefox, but today, it no longer does. It appears to work (no 
visible errors), but it doesn't actually upload the file.

There's an error log that says something about the session timing out:

The current proFlashUpload session has timed out. Please reload the interface 
and try again. Reference 
'SESSION.ProFlashUpload.vA6935FFAD6679CB9C4A6ACDEB0785179' not found.

But as far as I can tell, the session is properly configured. And again, it 
works fine in IE.

Anyone else seen this? I emailed the developer and he responded that he 
couldn't be bothered to help (which is odd since his website explicitly says to 
email him if you need further help). Normally that would be enough for me to 
simply find another solution, but in this case, it really does seem to be the 
best solution I've found for uploading multiple files at once.

Unless anyone has other suggestions for that as well?

thanks,

Mike 

~|
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:339579
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: moveTo on cfwindow no longer working in CF9?

[M P]

the version of ExtJS/Sencha (js library behind cfwindow) in cf9 is 
different than in cf8, so a method name could have easily been changed 
and is not moveTo() any longer.

try using setPagePosition() method instead of moveTo()

Thanks for the help, I may try SetPosition() or setPagePosition() in the 
future, but I've found another method using alignTo() that is working well 
enough.

The code is below, it repositions the window with respect to a DIV, the name of 
which is passed in the call, along with the Window name to create (though 
obviously you could leave that part out if you're creating your cfwindow on the 
page).

script
function CreatePopin(divName,windowName) {

ColdFusion.Window.create(windowName,'Title','file.htm',{modal:true,height:140,width:200,resizeable:false,draggable:true,refreshOnShow:true});
MyWindow = ColdFusion.Window.getWindowObject(windowName,true);
MyWindow.alignTo(divName,0,0);
}

/script

Thanks again guys,

Mike 

~|
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:338497
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Importing from CSV to a database

[M P]

I agree using something like Navicat to load the data would be a much better 
solution, but if you must use code, then I would parse those table names and 
replace all of the bad characters and spaces before creating the tables.

Special characters and spaces just cause too many problems to even try to use 
in table names. The only non-alphanumeric character I EVER use in a table name 
is an underscore.

Is there some reason you can't rename the tables when they're created to strip 
away the offensive characters?



~|
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:338488
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

tinymce with cfwindow

[M P]

I've been trying to get tinymce to work on a textarea inside a cfwindow, but 
for some reason it doesn't seem to work.

I put a textarea on the main page, and tinymce works just fine on it, but not 
on the one in the cfwindow.

Anyone else seen this issue and know how to get it to work?

Thanks,

Mike 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327975
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Extra leading content in cfhttp.filecontent

[M P]

I have a page that posts form data via cfhttp post and then receives a comma 
separated list of response values. I control both the remote posting code and 
the code that generates the response.

Everything is working perfectly except the first entry of the comma separated 
value list is reporting a length of 508 characters, even though it's only 
displaying a single character, which is a result code (only possible values are 
1, 2 or 3).

So it displays properly as a 1, 2 or 3, but when I try to insert it into a 
database, it says the value is too long. I tried TRIM and it has no effect. 
Through experimentation I've figured out I can use the RIGHT(x,1) function 
(where x is my variable) as a workaround, but every single transaction has over 
500 characters of extra data that I can't seem to remove, or even see. Oddly, 
if I use LEFT(x,1) I get a  which leads me to believe there is some sort of 
hidden code, but if I use LEFT(x,2) or greater, all the way to 507, I don't see 
anything (not even the leading ). Very strange.

I've verified that the responding page is not generating the extra data, I even 
added the the original LEN value as an additional field in the comma separated 
list and it is showing properly as 1. So I have to believe that somehow the 
local cfhttp post is appending the mystery content to cfhttp.filecontent.

Anyone ever seen this before? And more importantly, of course, know how to fix 
it?

Thanks,

Mike


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327414
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Extra leading content in cfhttp.filecontent

[M P]

Ahhh, it was some javascript includes in the header of the index page. I 
switched the process to it's own dedicated page instead of through the main 
index and the phantom data is gone.

And, of course, since the javascript is commented to hide from unsupported 
browsers, it was taking up space, but not displaying in cfhttp.filecontent 
(which I suppose is an unsupported browser).

Thanks Brad, that was very helpful.

-Mike


Are you using CFHTMLHead, CFAjaxProxy, or any other tag that sneaks
content into the header?   Also, does your Application.[cfc|cfm] file
produce any output.

I'm failing to understand why you can't just dump out the
cfhttp.filecontent and look at it.  Hit it in a browser and view source.
 If the first value is  there are probably some script tags or
something getting in the output.

~Brad

I have a page that posts form data via cfhttp post and then receives a
comma separated list of response values. I control both the remote
posting code and the code that generates the response. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327417
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4