RE: cfinput question...
Did you get anywhere with this? Ade -Original Message- From: Charles Heizer [mailto:[EMAIL PROTECTED] Sent: 24 February 2005 00:52 To: CF-Talk Subject: cfinput question... Hello, I'm trying to use the cfinput tag with a type of checkbox. The issue I'm having is that it won't let me use the same name more than once. Example --- cfinput type=Checkbox name=ZSTOP0001 label=Win 2000 value=WIN2K checked=#vCheckWIN2KOpt# cfinput type=Checkbox name=ZSTOP0001 label=Win XP value=WINXP checked=#vCheckWINXPOpt# Now, if I use this code my flash form will not come up, but if I use a regular input tag it works fine. Can someone tell me if this is not allowed or if I¹m doing something wrong? Thanks, - Charles PS: I¹m using CFMX 7 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 22/02/2005 ~| 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:196278 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: cfinput question...
Why don't you try radio button instead of checkbox? ~ Hello, I'm trying to use the cfinput tag with a type of checkbox. The issue I'm having is that it won't let me use the same name more than once. ~| 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:196279 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
cfscheduler and javascript
when you schedule an event w/in cfadmin does it actually load the .cfm template? I have a template that when it loads the form it is automatically submitted (JavaScript Body onload submit)IF I run the template manually the page works fine, however, as a schedule task nothing happens BTW the form if accessed from another link allows the user to manually submit the form that is why it is in a form in the first place Thanks ~| 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:196280 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: cfscheduler and javascript
It will not trigger JS no -Original Message- From: Kristen Winsor [mailto:[EMAIL PROTECTED] Sent: 24 February 2005 11:40 To: CF-Talk Subject: cfscheduler and javascript when you schedule an event w/in cfadmin does it actually load the .cfm template? I have a template that when it loads the form it is automatically submitted (JavaScript Body onload submit)IF I run the template manually the page works fine, however, as a schedule task nothing happens BTW the form if accessed from another link allows the user to manually submit the form that is why it is in a form in the first place Thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196281 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
guide to upgrading 6.1 to 7
I'm looking for a guide to upgrading from 6.1 to 7 on the MM site and coming up with nothing. Does anyone know if such a thing exists? Cheers Bert ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196282 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: serialize cfc
Wow, that's a pretty sad oversight on the part of Macromedia. Basically, if you use any session-based CFCs you are forced to use sticky sessions. And even that doesn't help at all for failover. They added a lot of nice stuff in 7.0, but they also dropped the ball on several things and this is one of them. On Wed, 23 Feb 2005 21:17:01 -0800, Barney Boisvert [EMAIL PROTECTED] wrote: CF7, like CF6, only supports session replication for non-CFC data. CFCs will not replicate. http://livedocs.macromedia.com/coldfusion/7/htmldocs/1774.htm Check point 17. Session vars can replicate, but CFC's can't. It's worded in a very poor way, but i'm guessing session vars is assumed to only include non-object data. cheers, barneyb On Wed, 23 Feb 2005 21:07:34 -0500, Brian Kotek [EMAIL PROTECTED] wrote: Barney I haven't tried it, but are you saying that CFMX7 does *not* allow for replication of session-scoped CFC instances? Or are you saying that it does? Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196283 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: CF7 won't run under IIS, wont install - business almost shut down for 2 days now.
I feel bad that I'm entering this thread so late - but I usually do. My apologies. First off, I'm not MM blashing here - I've always found their products to be quite good. However, since they deal with software - they can suffer the bugs, etc. Since I'm a one person consultant like you, I didn't get to participate with the beta testing of Blackstone. That was pretty disappointing to me that I had to wait so long. Mike, I had problems with getting CFMX7 installed on WinXPPro with Apache 2.0. I downloaded the installer on the Monday that it came out (like 1am). I must of had bad luck. It rendered my computer, well - I had 10 hours of troubleshooting to get it up again. For the life of me, quite a few things when wrong. 1. Windows Restore Points No matter how many I tried, none of them helped or worked 2. Antivirus I use Trend Micro PC-cillin Internet Suite 2005 on my dev machine. This broke - I later found out it was the secondary cause of gettting my computer back. 3. JRUN Once I did get my machine back, I couldn't get JRUN to play nice with Apache. JRUN gobbled memory like crazy for about 10 minutes and then I would get java.lang.OutOfMemory errors. I played with the maxPerm size and all the posts made by Sargeway regarding JRUn going crazy with memory. I ended up getting CFMX7 running only in stand-alone with it's own builtin webserver. I wish I could I get it running with Apache...but that's another day... Best, ...peter P.s. I'll try to post more later when I have time. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196284 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: CF7 won't run under IIS, wont install - business almost shut down for 2 days now.
Hey Peter, If you need help on getting MX up and running with Apache let me know...jeez I have done it enough times! N -Original Message- From: Peter Farrell [mailto:[EMAIL PROTECTED] Sent: 24 February 2005 13:00 To: CF-Talk Subject: Re: CF7 won't run under IIS, wont install - business almost shut down for 2 days now. I feel bad that I'm entering this thread so late - but I usually do. My apologies. First off, I'm not MM blashing here - I've always found their products to be quite good. However, since they deal with software - they can suffer the bugs, etc. Since I'm a one person consultant like you, I didn't get to participate with the beta testing of Blackstone. That was pretty disappointing to me that I had to wait so long. Mike, I had problems with getting CFMX7 installed on WinXPPro with Apache 2.0. I downloaded the installer on the Monday that it came out (like 1am). I must of had bad luck. It rendered my computer, well - I had 10 hours of troubleshooting to get it up again. For the life of me, quite a few things when wrong. 1. Windows Restore Points No matter how many I tried, none of them helped or worked 2. Antivirus I use Trend Micro PC-cillin Internet Suite 2005 on my dev machine. This broke - I later found out it was the secondary cause of gettting my computer back. 3. JRUN Once I did get my machine back, I couldn't get JRUN to play nice with Apache. JRUN gobbled memory like crazy for about 10 minutes and then I would get java.lang.OutOfMemory errors. I played with the maxPerm size and all the posts made by Sargeway regarding JRUn going crazy with memory. I ended up getting CFMX7 running only in stand-alone with it's own builtin webserver. I wish I could I get it running with Apache...but that's another day... Best, ...peter P.s. I'll try to post more later when I have time. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196285 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: CF7 won't run under IIS, wont install - business almost shut down for 2 days now.
From: Peter Farrell [mailto:[EMAIL PROTECTED] Mike, I had problems with getting CFMX7 installed on WinXPPro with Apache 2.0. I downloaded the installer on the Monday that it came out (like 1am). I must of had bad luck. It rendered my computer, well - I had 10 hours of troubleshooting to get it up again. For the life of me, quite a few things when wrong. I have installed CFMX 7 on a variety of mahcines now under a variety of configurations and have only had one problem. Perhaps this is your issue. Our local dev boxes (desktop machines) are loaded with all kinds of software. There are processes running in the background that we don't even know about. The average XP user has ALL the default services running, etc. The key to getting around one XP install for me was to shut down all programs, all unnecessary services, clear the event logs, etc. Reboot. Reinstall. Check the error logs and event logs. All was good. Perhaps the people having so many problems have not shut down all the things running which are not necessary to get CFMX 7 installed! Close down IM, Email, Homesite, etc.. Usually I ignore the Please close down all running programs.. blah blah blah when installing new stuff, but when I do ignore it and the installation goes awry I always start there. Anyway, just something to think about. Good luck. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196286 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: Reason to *not* store lots of data in Application scope?
What? How is it not? You write static files vs using the application scope. Depending on the application and environment static files would be as fast if not faster than using the application scope. And you don't have to worry about corruption of the memory or making a mistake in your logic to store the data in the application. -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 23, 2005 5:20 PM To: CF-Talk Subject: Re: Reason to *not* store lots of data in Application scope? If Damien is talking about storing the articles in the application scope I would write them to disk and include them. And then just update them as needed instead of storing them to memory. Not nearly as fast as putting it in application scope. -Adam ~| 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:196288 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
CFInclude
Is there anyway to use cfinclude to point to a .cfm file on a different website? Or am I stuck with cfhttp? I'm using CFMX 6.1. Thanks, Mark ~| 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:196287 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-SQL matching
I will give this a try, thanks for all your help and good luck with the car.
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 23, 2005 5:41 PM
To: CF-Talk
Subject: RE: OT-SQL matching
Try runnng this:
CREATE TABLE #table1 (
LName VARCHAR(100),
FName VARCHAR(100),
City VARCHAR(100)
)
CREATE TABLE #table2 (
LName VARCHAR(100),
FName VARCHAR(100),
City VARCHAR(100)
)
INSERT INTO #table1 ( LName, FName, City ) VALUES ( 'DOE JR', 'JOHN',
'PHOENIX' )
INSERT INTO #table1 ( LName, FName, City ) VALUES ( 'GATES', 'BILL',
'REDMOND' )
INSERT INTO #table1 ( LName, FName, City ) VALUES ( 'GORE III', 'AL',
'BACKWOODS' )
INSERT INTO #table1 ( LName, FName, City ) VALUES ( 'BRADSHAW', 'TERRY',
'HOUSTON' )
INSERT INTO #table2 ( LName, FName, City ) VALUES ( 'DOE', 'JOHN',
'PHOENIX' )
INSERT INTO #table2 ( LName, FName, City ) VALUES ( 'GATES', 'BILL',
'REDMOND' )
INSERT INTO #table2 ( LName, FName, City ) VALUES ( 'GORE', 'AL',
'BACKWOODS' )
INSERT INTO #table2 ( LName, FName, City ) VALUES ( 'BRADSAW', 'TERRY',
'HOUSTON' )
SELECT t1.*, t2.*
FROM #table1 t1
INNER JOIN #table2 t2 ON (
t1.LName = t2.LName OR SUBSTRING(t1.LName, 1, CHARINDEX(' ', t1.LName))
LIKE t2.LName
)
It looks like it's doing the right thing, joining on last name in spite or
the suffix.
Ade
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: 23 February 2005 22:58
To: CF-Talk
Subject: RE: OT-SQL matching
hm not sure unless I give it a try.
Here is my revised SQL, I got rid of the substring on the last name and went
with matching the first three letters
SELECT
n.[last name] as lastname,x.perlname,
n.[first name] as firstname,x.perfname,
n.[street 1],x.addrline1,n.city,n.state ,x.city,x.state
FROM NEW_STUDENTS n, EAA_CHECK x
WHERE LEFT(n.[first name],1) = left(x.perfname,1)
AND n.city =x.city
AND n.state = x.state
AND LEFT(n.[street 1],3)= left(x.addrline1, 3)
AND LEFT(n.[last name],3) = left(x.perlname,3)
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 22/02/2005
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196289
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
OT: IIS Users and Groups.
Hello all. I'm an old Netscape iPlanet guy and I am new to IIS 6.0/Windows Security and have a simple question. I posted this question on an IIS forum and got no response. :( Say I have two websites: www.abc.com and www.xyz.com. Both of these websites have an admin directory that I want password protect and have users authenticate against. User #1 needs to administer www.abc.com/admin and User #2 needs to administer www.xyz.com/admin. There is a also a super-user who needs to be able to administer *both* admin directories. So, I know I need to create Users and I need to create Groups. I have done this but I am not sure if I did it correctly. - For some reason, User #1 has access to both www.abc.com/admin AND www.xyz.com/admin and vice-versa for User #2. This cannot happen and I don't know how to fix it. - Also, how do I create the super-user and have him/her be able to administer either web site? What is the proper way to create users? To create groups? Could some one tell me what I am doing wrong? Or even better, could someone point me to an *online tutorial* or *resource* on this somewhere on the Internet? Thanks in advance... Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196290 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: CFInclude
no, because CFHTTP is an HTTP request so the file is processed by the CF server so the raw CFM won't be available john. On Thu, 24 Feb 2005 09:28:39 -0500, Mark Leder [EMAIL PROTECTED] wrote: Is there anyway to use cfinclude to point to a .cfm file on a different website? Or am I stuck with cfhttp? I'm using CFMX 6.1. Thanks, Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196291 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: cfif eq varchar issue in MX
I am not sure where this inconsistency comes from. Is the space between General Information a cause? Depends if they are only blank character, or if there the two parts are in two separate lines. Depending on the way the code was entered, you may actually have the equivalent of - General Information - General chr(13) chr(10) Information - General chr(13) chr(10) Information - GeneralInformation They will all look the same in your editor, but not by CF in a CFIF -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196292 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: THIS scope
Mostly because if you're looking for a field, you're not going to look in the methods section of the class docs, even if the field is actually a method, as you proposed. Just a differentiation between state and behaviour that you'd sacrifice. If I knew the data was in that class (or should be) I would definately check the methods if I didn't see it listed in the fields... For that matter, I always check the methods for what I need first before looking for fields as I consider this a best practice since a method provides encapsulation that a field doesn't, and when a method is created initially there's no need to modify code referencing the method if it's later determined that there are conditions in which a different value should be returned. So no I wouldn't lose anything. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com ~| 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:196293 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: THIS scope
I still fail to understand why it's considered messy / nasty. If you let the 'final' part of 'public static final' weigh in slightly, then Isaac's proposal kind of gives you static. Because it's a method not a variable, there is only one instance (so it's a class thing), you can't change it like a non-final variable. It's messy and nasty, which is why I prefer to just use a variable in the 'this' scope. cheers, barneyb On Wed, 23 Feb 2005 17:04:35 -0500, Joe Rinehart [EMAIL PROTECTED] wrote: That doesn't really cover static, though - what makes a static member static is that it belongs to the type instead of one instance of a type. I.e.: InstanceOne.StaticVar = 1 InstanceTwo.StaticVar = 2 !--- Would show 2 if we had statics --- cfoutput#InstanceOne.StaticVar#/cfoutput s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com ~| 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:196294 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: LDAP question
Glad I could help. What LDAP directory are you using? Active Directory or something else? In AD, if there is a user, you should get the CN as you requested. It should never be empty. If there is no user, you will get an empty query. Try using attributes=* and see if you get anything back. Using * for testing is fine, but I don't recommend using it for real work. First, it brings back too much data, including binary voicemail recordings, (if you have Cisco Call Manager, for example) and it only brings back one value in a multi-value field such as memberOf. Again, I'm using AD and these things work for me. Now that I look at your code a bit more, you need to specify the filter attribute such as: filter=sAMAccountName=#userName# (Again, this is AD.) That is, if the same username for the credentials is the same for the CN you wish to retrieve. By not specifying a filter, you are asking for all kinds of stuff. One of those stuff probably doesn't have a CN or, at least, doesn't support returning the CN. M!ke -Original Message- From: Victor Moore [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 23, 2005 9:56 PM To: CF-Talk Subject: Re: LDAP question Modifying the start attribute to Mike's format worked. Hurray!!! So in may case this works: cfldap action=query name=getUser start=dc=companyName, dc=com scope=SUBTREE maxrows=1 server=#serverIP# attributes=cn username=#userName# password=#userPassword# port=389 If the user exists will return a query. Unfortunately it's all the time an empty query, regarding what I put in the attributes list. For the time being I am OK but I would like very much to be able to return some info and not just verify that the user exists. Thanks Mike Victor ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196295 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: Reason to *not* store lots of data in Application scope?
On Thu, 24 Feb 2005 09:24:49 -0500, Bryan F. Hogan [EMAIL PROTECTED] wrote: What? How is it not? You write static files vs using the application scope. Depending on the application and environment static files would be as fast if not faster than using the application scope. And you don't have to worry about corruption of the memory or making a mistake in your logic to store the data in the application. I think the implicit point is that memory (e.g. application scope) is faster than I/O from the disk (e.g a file) -- and considering that *read* would be the far more frequent step than *write*, anything in memory should be faster. But considering how many layers of caching are under the hood (webserver, appserver, os, disk controller) the difference between explicitly storing in memory and simply using a file is probably moot for many of the articles. I'd bet letting the various components (severs, os, etc) manage caching (and thus memory) is probably going to result in better overall results than manually managing it (by putting things in application scope) unless you're doing a lot of performance tuning. It would be a shame, for example, to use up a lot of memory with application scope variables and starve the web server, app server, and database as the site/data scales larger. While I'm not advocating it, running purely with database queries makes nearly as much sense (at least, up to a point) -- since both ColdFusion and the database are caching the disk-based data into memory. Using included files and having Apache/etc do the caching is analogous. In both cases, the servers are going to try and minimize disk i/o, so you'll end up with data in memory most of the time anyhow. This thread is really turning into a discussion about the basic tradeoff of relying on generic algorithms provided by the software stack to optimize the amount of data in memory vs specific tuning and optimization steps that are application specific... If Damien is talking about storing the articles in the application scope I would write them to disk and include them. And then just update them as needed instead of storing them to memory. Not nearly as fast as putting it in application scope. -Adam ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196296 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: Reason to *not* store lots of data in Application scope?
I think the implicit point is that memory (e.g. application scope) is faster than I/O from the disk (e.g a file) -- and considering that *read* would be the far more frequent step than *write*, anything in memory should be faster. I agree if you're using cffile or using cfinclude or the like. What I'm talking about is writing static files such as an html article. You only write and update the file in your admin. Unless you have a herd of people working on the file at once than there are few I/O processes that need to be done. While I'm not advocating it, running purely with database queries makes nearly as much sense (at least, up to a point) -- since both ColdFusion and the database are caching the disk-based data into memory. Using included files and having Apache/etc do the caching is analogous. In both cases, the servers are going to try and minimize disk i/o, so you'll end up with data in memory most of the time anyhow. This is all fine except for large applications with many articles. For example I have an Intranet for lawyers that has 600,000 articles. There is no way I'm going to query the db every time one of those articles are accessed. First because they are long-winded and second because they are accessed frequently. This thread is really turning into a discussion about the basic tradeoff of relying on generic algorithms provided by the software stack to optimize the amount of data in memory vs specific tuning and optimization steps that are application specific... Agreed, it's a nice discussion to have every once and awhile. ~| 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:196297 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: LDAP question
Hi Mike, That's the funny part. If the userID and password I provide exists on the AD, then I get back an empty query, regarding what attributes I request in the attributes field. If the user doesn't exists then I get an error: Inappropriate authentication. If I add * for attributes get an error: An error has occurred while trying to execute query :Unprocessed Continuation Reference(s). One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server The customer is using the Windows 2003 Server active directory. I think it's a setup or permission issue on the AD server. As I said, for the time being I am OK because if I get back a query (even empty) I assume the user exists if not then the user does not. I am sure that in the future they will want more things to be done so I would like to know what are my possibilities. It's obvious that people are using it and get the proper info back, so I think it's related to their setup. Unfortunately I don't know enough about AD to be able to debug and from their point everything is OK. Thanks again Victor On Thu, 24 Feb 2005 09:04:30 -0600, Dawson, Michael [EMAIL PROTECTED] wrote: Glad I could help. What LDAP directory are you using? Active Directory or something else? In AD, if there is a user, you should get the CN as you requested. It should never be empty. If there is no user, you will get an empty query. Try using attributes=* and see if you get anything back. Using * for testing is fine, but I don't recommend using it for real work. First, it brings back too much data, including binary voicemail recordings, (if you have Cisco Call Manager, for example) and it only brings back one value in a multi-value field such as memberOf. Again, I'm using AD and these things work for me. Now that I look at your code a bit more, you need to specify the filter attribute such as: filter=sAMAccountName=#userName# (Again, this is AD.) That is, if the same username for the credentials is the same for the CN you wish to retrieve. By not specifying a filter, you are asking for all kinds of stuff. One of those stuff probably doesn't have a CN or, at least, doesn't support returning the CN. M!ke -Original Message- From: Victor Moore [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 23, 2005 9:56 PM To: CF-Talk Subject: Re: LDAP question Modifying the start attribute to Mike's format worked. Hurray!!! So in may case this works: cfldap action=query name=getUser start=dc=companyName, dc=com scope=SUBTREE maxrows=1 server=#serverIP# attributes=cn username=#userName# password=#userPassword# port=389 If the user exists will return a query. Unfortunately it's all the time an empty query, regarding what I put in the attributes list. For the time being I am OK but I would like very much to be able to return some info and not just verify that the user exists. Thanks Mike Victor ~| 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:196298 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-SQL matching
Okay I go something to work so my orginal question is taken care of. However I
have another question that deals with this sort of thing. I am now looking at
another datasource that I am going to have to match on at somepoint later but
they have a single name field where a persons name is one field and is LASTNAME
FIRSTNAME, MIDDLE SUFFIX (LITTLE DONALD V or LITTLE DONALD VICTOR or LITTLE
DONALD Victor JR).
I am simply querying out the information that I need and putting it in a
holding table. But while I am doing this I want to extract the LAST and FIRST
names and store them in their seperate columns in the holding the table. I can
get the last name and I can get the first name but along with the first name I
get the middle name and suffix as well. By the way this is a data file provided
by the FAA. Here is what I am doing lease the INTO statement.
SELECT
SUBSTRING([name], 1, CHARINDEX(' ', [name])) AS lastname,
SUBSTRING([name], CHARINDEX(' ',[name])+1,LEN([name])) as firstname ,
street,street2,city,state,[zip code] as zip
FROM master
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196299
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: LDAP question
You might try using the LDAP Browser utility at www.ldapbrowser.com. They have a freeware ldap browser that may help find the problem. Also, I would just use a generic account for the username and password. Preferably those of a domain admin. Then see what happens. If it works at that point, start backing off to a user account that has few permissions. If the domain admin account can't access any attributes, you have a different problem. M!ke -Original Message- From: Victor Moore [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 9:30 AM To: CF-Talk Subject: Re: LDAP question Hi Mike, That's the funny part. If the userID and password I provide exists on the AD, then I get back an empty query, regarding what attributes I request in the attributes field. If the user doesn't exists then I get an error: Inappropriate authentication. If I add * for attributes get an error: An error has occurred while trying to execute query :Unprocessed Continuation Reference(s). One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server The customer is using the Windows 2003 Server active directory. I think it's a setup or permission issue on the AD server. As I said, for the time being I am OK because if I get back a query (even empty) I assume the user exists if not then the user does not. I am sure that in the future they will want more things to be done so I would like to know what are my possibilities. It's obvious that people are using it and get the proper info back, so I think it's related to their setup. Unfortunately I don't know enough about AD to be able to debug and from their point everything is OK. Thanks again Victor On Thu, 24 Feb 2005 09:04:30 -0600, Dawson, Michael [EMAIL PROTECTED] wrote: Glad I could help. What LDAP directory are you using? Active Directory or something else? In AD, if there is a user, you should get the CN as you requested. It should never be empty. If there is no user, you will get an empty query. Try using attributes=* and see if you get anything back. Using * for testing is fine, but I don't recommend using it for real work. First, it brings back too much data, including binary voicemail recordings, (if you have Cisco Call Manager, for example) and it only brings back one value in a multi-value field such as memberOf. Again, I'm using AD and these things work for me. Now that I look at your code a bit more, you need to specify the filter attribute such as: filter=sAMAccountName=#userName# (Again, this is AD.) That is, if the same username for the credentials is the same for the CN you wish to retrieve. By not specifying a filter, you are asking for all kinds of stuff. One of those stuff probably doesn't have a CN or, at least, doesn't support returning the CN. M!ke -Original Message- From: Victor Moore [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 23, 2005 9:56 PM To: CF-Talk Subject: Re: LDAP question Modifying the start attribute to Mike's format worked. Hurray!!! So in may case this works: cfldap action=query name=getUser start=dc=companyName, dc=com scope=SUBTREE maxrows=1 server=#serverIP# attributes=cn username=#userName# password=#userPassword# port=389 If the user exists will return a query. Unfortunately it's all the time an empty query, regarding what I put in the attributes list. For the time being I am OK but I would like very much to be able to return some info and not just verify that the user exists. Thanks Mike Victor ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196300 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: LDAP question
BTW, if their domain admin won't give you an account with domain admin permissions, you can easily create a form where they can enter their credentials, to be used for the LDAP connection, and have it mail any output to you. -Original Message- From: Victor Moore [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 9:30 AM To: CF-Talk Subject: Re: LDAP question Hi Mike, That's the funny part. If the userID and password I provide exists on the AD, then I get back an empty query, regarding what attributes I request in the attributes field. If the user doesn't exists then I get an error: Inappropriate authentication. If I add * for attributes get an error: An error has occurred while trying to execute query :Unprocessed Continuation Reference(s). One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server The customer is using the Windows 2003 Server active directory. I think it's a setup or permission issue on the AD server. As I said, for the time being I am OK because if I get back a query (even empty) I assume the user exists if not then the user does not. I am sure that in the future they will want more things to be done so I would like to know what are my possibilities. It's obvious that people are using it and get the proper info back, so I think it's related to their setup. Unfortunately I don't know enough about AD to be able to debug and from their point everything is OK. Thanks again Victor On Thu, 24 Feb 2005 09:04:30 -0600, Dawson, Michael [EMAIL PROTECTED] wrote: Glad I could help. What LDAP directory are you using? Active Directory or something else? In AD, if there is a user, you should get the CN as you requested. It should never be empty. If there is no user, you will get an empty query. Try using attributes=* and see if you get anything back. Using * for testing is fine, but I don't recommend using it for real work. First, it brings back too much data, including binary voicemail recordings, (if you have Cisco Call Manager, for example) and it only brings back one value in a multi-value field such as memberOf. Again, I'm using AD and these things work for me. Now that I look at your code a bit more, you need to specify the filter attribute such as: filter=sAMAccountName=#userName# (Again, this is AD.) That is, if the same username for the credentials is the same for the CN you wish to retrieve. By not specifying a filter, you are asking for all kinds of stuff. One of those stuff probably doesn't have a CN or, at least, doesn't support returning the CN. M!ke -Original Message- From: Victor Moore [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 23, 2005 9:56 PM To: CF-Talk Subject: Re: LDAP question Modifying the start attribute to Mike's format worked. Hurray!!! So in may case this works: cfldap action=query name=getUser start=dc=companyName, dc=com scope=SUBTREE maxrows=1 server=#serverIP# attributes=cn username=#userName# password=#userPassword# port=389 If the user exists will return a query. Unfortunately it's all the time an empty query, regarding what I put in the attributes list. For the time being I am OK but I would like very much to be able to return some info and not just verify that the user exists. Thanks Mike Victor ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196301 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-SQL matching
Will the last name always be first in the column? In the samples below, is
the person's first name DONALD, and then last names LITTLE, LITTLE VICTOR
and LITTLE Victor?
LITTLE DONALD V
LITTLE DONALD VICTOR
LITTLE DONALD Victor JR
Ade
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:37
To: CF-Talk
Subject: RE: OT-SQL matching
Okay I go something to work so my orginal question is taken care of. However
I have another question that deals with this sort of thing. I am now looking
at another datasource that I am going to have to match on at somepoint later
but they have a single name field where a persons name is one field and is
LASTNAME FIRSTNAME, MIDDLE SUFFIX (LITTLE DONALD V or LITTLE DONALD VICTOR
or LITTLE DONALD Victor JR).
I am simply querying out the information that I need and putting it in a
holding table. But while I am doing this I want to extract the LAST and
FIRST names and store them in their seperate columns in the holding the
table. I can get the last name and I can get the first name but along with
the first name I get the middle name and suffix as well. By the way this is
a data file provided by the FAA. Here is what I am doing lease the INTO
statement.
SELECT
SUBSTRING([name], 1, CHARINDEX(' ', [name])) AS lastname,
SUBSTRING([name], CHARINDEX(' ',[name])+1,LEN([name])) as firstname ,
street,street2,city,state,[zip code] as zip
FROM master
~|
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:196302
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: SPAM: RE: SPAM: RE: A Little OT
I'm not sure what was asked for in this thread (may be search engine submission or finding linking partners)...but A friend of mine is an SEO company owner and has done work most recently for some Time Warner siteshe says submit to directory sites first instead of the search engines. The logic here is that the directory site is already indexedand when your site shows up in the directory, your site is found and indexed. If you submit to the engine directly (like Google), you can wait months before getting indexed. Now for finding linking partners... If you want to find other sites with similar subject matter to your own with specific Google page ranks that are willing to accept a link back to your sitecheck out an app called PR Prowler (just Google it). I haven't used it yet, but one of my buddies staff swears by the thing. It ultimately doesn't do anything you couldn't do manually...but it does it WAY WAY faster than you ever could. Anyways...hopefully I added something useful ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Kay Smoljak [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, February 23, 2005 4:22 PM Subject: Re: SPAM: RE: SPAM: RE: A Little OT On Wed, 23 Feb 2005 13:54:57 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Thanks for the info. Do you know of a good piece of software for automatic submissions? How often is too often to submit? David, You don't need to submit at all, and you most DEFINITELY don't want to use automatic submission software. One good link is enough to get your site spidered by Google, MSN and Yahoo. Once you're in, your ranking is determined by a number of factors (text, incoming links etc) but the number of times it has been submitted is not one of those factors. -- Kay Smoljak http://kay.smoljak.com/ ~| 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:196303 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-SQL matching
In fact I think you're on to a hiding to nothing...
I don't think you can make any reasonable assumptions about what is a
middle name and what is a suffix. In the before samples VICTOR could be a
suffix.
Maybe I'm not understanding it all but I don't think you'll be able to do
this with 100% accuracy.
Ade
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:49
To: CF-Talk
Subject: RE: OT-SQL matching
Will the last name always be first in the column? In the samples below, is
the person's first name DONALD, and then last names LITTLE, LITTLE VICTOR
and LITTLE Victor?
LITTLE DONALD V
LITTLE DONALD VICTOR
LITTLE DONALD Victor JR
Ade
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:37
To: CF-Talk
Subject: RE: OT-SQL matching
Okay I go something to work so my orginal question is taken care of. However
I have another question that deals with this sort of thing. I am now looking
at another datasource that I am going to have to match on at somepoint later
but they have a single name field where a persons name is one field and is
LASTNAME FIRSTNAME, MIDDLE SUFFIX (LITTLE DONALD V or LITTLE DONALD VICTOR
or LITTLE DONALD Victor JR).
I am simply querying out the information that I need and putting it in a
holding table. But while I am doing this I want to extract the LAST and
FIRST names and store them in their seperate columns in the holding the
table. I can get the last name and I can get the first name but along with
the first name I get the middle name and suffix as well. By the way this is
a data file provided by the FAA. Here is what I am doing lease the INTO
statement.
SELECT
SUBSTRING([name], 1, CHARINDEX(' ', [name])) AS lastname,
SUBSTRING([name], CHARINDEX(' ',[name])+1,LEN([name])) as firstname ,
street,street2,city,state,[zip code] as zip
FROM master
~|
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:196304
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-SQL matching
It is always
LASTNAME FIRSTNAME then ..
LITTLE DONALD Victor JR
So I just want
LASTNAME = LITTLE
FIRSTNAME = DONALD
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 24, 2005 9:55 AM
To: CF-Talk
Subject: RE: OT-SQL matching
In fact I think you're on to a hiding to nothing...
. I don't think you can make any reasonable assumptions about what is a
middle name and what is a suffix. In the before samples VICTOR could be a
suffix.
Maybe I'm not understanding it all but I don't think you'll be able to do
this with 100% accuracy.
Ade
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:49
To: CF-Talk
Subject: RE: OT-SQL matching
Will the last name always be first in the column? In the samples below, is
the person's first name DONALD, and then last names LITTLE, LITTLE VICTOR
and LITTLE Victor?
LITTLE DONALD V
LITTLE DONALD VICTOR
LITTLE DONALD Victor JR
Ade
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:37
To: CF-Talk
Subject: RE: OT-SQL matching
Okay I go something to work so my orginal question is taken care of. However
I have another question that deals with this sort of thing. I am now looking
at another datasource that I am going to have to match on at somepoint later
but they have a single name field where a persons name is one field and is
LASTNAME FIRSTNAME, MIDDLE SUFFIX (LITTLE DONALD V or LITTLE DONALD VICTOR
or LITTLE DONALD Victor JR).
I am simply querying out the information that I need and putting it in a
holding table. But while I am doing this I want to extract the LAST and
FIRST names and store them in their seperate columns in the holding the
table. I can get the last name and I can get the first name but along with
the first name I get the middle name and suffix as well. By the way this is
a data file provided by the FAA. Here is what I am doing lease the INTO
statement.
SELECT
SUBSTRING([name], 1, CHARINDEX(' ', [name])) AS lastname,
SUBSTRING([name], CHARINDEX(' ',[name])+1,LEN([name])) as firstname ,
street,street2,city,state,[zip code] as zip
FROM master
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196305
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
Pro/Con Moving from MSSQL to MySQL
We are in the early stages of *thinking* about moving away from MS SQL server and moving to MySQL. Can anyone give me a quick pro / con points for doing this or not doing this? We have about 60 Databases set up on on a server that gets low traffic. Few thousand users per day. Mostly we use the database as a data storage. We have only a few stored procedures that probably really don't need to be Stored Procedures. The heaviest load we ever put on the SQL server is a few report admin pages where we use SQL to sum and count various stats about the users answers. I know that we will have to rewrite anything that we have used MSSQL functions and MSSQL SQL commands. Thanks, Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com http://www.vividmedia.com/ 608.270.9770 ~| 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:196306 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: Reason to *not* store lots of data in Application scope?
On Thu, 24 Feb 2005 10:25:14 -0500, Bryan F. Hogan [EMAIL PROTECTED] wrote: While I'm not advocating it, running purely with database queries makes nearly as much sense (at least, up to a point) -- since both ColdFusion and the database are caching the disk-based data into memory. Using included files and having Apache/etc do the caching is analogous. In both cases, the servers are going to try and minimize disk i/o, so you'll end up with data in memory most of the time anyhow. This is all fine except for large applications with many articles. For example I have an Intranet for lawyers that has 600,000 articles. There is no way I'm going to query the db every time one of those articles are accessed. First because they are long-winded and second because they are accessed frequently. Actually, I think you missed part of the point. Regardless of whether the article is data in a database or a text file sitting on a disk, the amount of disk I/O to get those blocks into memory is the same order of magnitude (db page size and fragmentation vs os block size and fragmentation probably plays a role, but still should be same order of magnitude). Plus your query is probably only going to the app server (ColdFusion's query cache) or to the database's memory (cached database pages) and not the disk directly if it's a frequently used item -- frequent use is exactly why relying on the inherent caching in the lower-level components is useful! The database option requires a little more *processor* overhead (for the database and the app server) but the slow step is the disk i/o. And that difference may be moot if you're using some sort of compression on the web server (e.g. mod_deflate, mod_gzip, or the IIS equivalent filters) which also requires overhead If either your web server cache or your database cache (or you app server cache for that matter) can hold the entire collection, the point is pretty moot about where it lives -- though I'd personally go for the disk files. Legal documents -- maybe 4MB each? 2.5 GB of memory puts a big dent in that and isn't very expensive, relatively speaking. So to be safe, a server with 4 GB of RAM could run the collection (or at least the hottest part of the collection) in main memory -- regardless of whether it's web server, app server, or database server. My real vote would probably be RAM disk with Apache to serve it up... or MySQL 4.1 with the query cache set to the size of the database :) Plus I'd make sure to use the meta headers on the resulting pages to prevent duplicate downloads. Of course there is a hit if you have to completely rebuild the collection (catastrophic disk failure on web server) but that's probably on the order of a database restore. Of course I like playing with 10-100GB MySQL data warehouses, so I'm biased :) -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196307 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: Pro/Con Moving from MSSQL to MySQL
Mark W. Breneman wrote: We are in the early stages of *thinking* about moving away from MS SQL server and moving to MySQL. Why? What do you hope to gain from this move? Jochem ~| 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:196308 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: Pro/Con Moving from MSSQL to MySQL
I can give you two good reasons. LiveJournal and Wikipedia. In the past couple of months both of these websites went down due to power issues in their coloco facilities. It took a bit of effort to bring both of these sites back up because the database was in an inconsistent state. Both sites lost data. I would not trust anything of value in MySql. toru On Thu, 24 Feb 2005 17:06:50 +0100, Jochem van Dieten [EMAIL PROTECTED] wrote: Mark W. Breneman wrote: We are in the early stages of *thinking* about moving away from MS SQL server and moving to MySQL. Why? What do you hope to gain from this move? Jochem ~| 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:196309 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: Pro/Con Moving from MSSQL to MySQL
On Thu, 24 Feb 2005 10:04:22 -0600, Mark W. Breneman [EMAIL PROTECTED] wrote: We are in the early stages of *thinking* about moving away from MS SQL server and moving to MySQL. Can anyone give me a quick pro / con points for doing this or not doing this? I'm a big MySQL fan, and a long-time MS-SQL developer/admin so I've done a lot of work stradling both camps. I'd give you one fundamental piece of advice: Don't do it just because MySQL is free (as in beer) Yeah, there's an order of magnitude difference in cost (MS-SQL unlimited is 5k/proc; MySQL is 500/server if you license it, which is optional for most folks). But unless you're running *lots* of processors, the savings are minimal. Pros/cons are a little hard to do unless without reference to specific needs, but based on the scenario you have below (lots of read, little write) MyISAM tables are probably faster than MS-SQL, and you can run the app on more operating systems. And it's cheaper on the backup and staging side since you don't have to pay MS rates for those licenses. We have about 60 Databases set up on on a server that gets low traffic. Few thousand users per day. Mostly we use the database as a data storage. We have only a few stored procedures that probably really don't need to be Stored Procedures. The heaviest load we ever put on the SQL server is a few report admin pages where we use SQL to sum and count various stats about the users answers. MySQL is plenty powerful enough, though it benefits a lot more from tuning than MS-SQL does in my experience -- both of those tools provide similar *query* tuning options, but MySQL has hundreds of options that can be tweaked to provider fine-grained control on tuning the server while MS-SQL basically does a lot of self-tuning. I know that we will have to rewrite anything that we have used MSSQL functions and MSSQL SQL commands. Less than you think needs rewritten -- MySQL has lots of common MS-SQL (and Oracle, etc) commands built-in or aliased to the native MySQL functions. The only difference in very common SQL off the top of my head is the non-standard way Microsoft does queries with a rowlimit -- MySQL uses SELECT xx LIMIT N etc instead of SELECT TOP N xx like MS-SQL. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| 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:196310 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: Pro/Con Moving from MSSQL to MySQL
Yeah, I thought that question might come up... We are configing a new windows 2000 webserver server and the owner walked up and just asked out of the blue what if we install MySql and not MSSQL. (and no this was not a Dilbert Pointy haired Boss sorta moment.) We have talked about moving to a non Windows platform for our production servers in the future. And since MSSQL only runs on windows we would need to move to another database platform. We are still in the very early stages of mapping out our tech plan for what OS platforms we want to use in production. So, nothing is set in stone just yet. I am primarily just doing research now, so I thought I would ask people who have worked with MySQL and have good and bad experiences. Thanks, Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 10:07 AM To: CF-Talk Subject: Re: Pro/Con Moving from MSSQL to MySQL Mark W. Breneman wrote: We are in the early stages of *thinking* about moving away from MS SQL server and moving to MySQL. Why? What do you hope to gain from this move? Jochem ~| 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:196311 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: Pro/Con Moving from MSSQL to MySQL
Another point to consider is in MySQL you can not use A default date field to be auto-populated as you can in MS-SQL using the NOW() function. I had to modify my code to accommodate that function. But for the most part I rather enjoy MySQL. -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 11:19 AM To: CF-Talk Subject: Re: Pro/Con Moving from MSSQL to MySQL On Thu, 24 Feb 2005 10:04:22 -0600, Mark W. Breneman [EMAIL PROTECTED] wrote: We are in the early stages of *thinking* about moving away from MS SQL server and moving to MySQL. Can anyone give me a quick pro / con points for doing this or not doing this? I'm a big MySQL fan, and a long-time MS-SQL developer/admin so I've done a lot of work stradling both camps. I'd give you one fundamental piece of advice: Don't do it just because MySQL is free (as in beer) Yeah, there's an order of magnitude difference in cost (MS-SQL unlimited is 5k/proc; MySQL is 500/server if you license it, which is optional for most folks). But unless you're running *lots* of processors, the savings are minimal. Pros/cons are a little hard to do unless without reference to specific needs, but based on the scenario you have below (lots of read, little write) MyISAM tables are probably faster than MS-SQL, and you can run the app on more operating systems. And it's cheaper on the backup and staging side since you don't have to pay MS rates for those licenses. We have about 60 Databases set up on on a server that gets low traffic. Few thousand users per day. Mostly we use the database as a data storage. We have only a few stored procedures that probably really don't need to be Stored Procedures. The heaviest load we ever put on the SQL server is a few report admin pages where we use SQL to sum and count various stats about the users answers. MySQL is plenty powerful enough, though it benefits a lot more from tuning than MS-SQL does in my experience -- both of those tools provide similar *query* tuning options, but MySQL has hundreds of options that can be tweaked to provider fine-grained control on tuning the server while MS-SQL basically does a lot of self-tuning. I know that we will have to rewrite anything that we have used MSSQL functions and MSSQL SQL commands. Less than you think needs rewritten -- MySQL has lots of common MS-SQL (and Oracle, etc) commands built-in or aliased to the native MySQL functions. The only difference in very common SQL off the top of my head is the non-standard way Microsoft does queries with a rowlimit -- MySQL uses SELECT xx LIMIT N etc instead of SELECT TOP N xx like MS-SQL. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| 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:196312 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: Pro/Con Moving from MSSQL to MySQL
Well, whatever you think of Microsoft, SQL Server is far far better then mySQL will ever be (cost aside that is!). -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: 24 February 2005 16:27 To: CF-Talk Subject: RE: Pro/Con Moving from MSSQL to MySQL Yeah, I thought that question might come up... We are configing a new windows 2000 webserver server and the owner walked up and just asked out of the blue what if we install MySql and not MSSQL. (and no this was not a Dilbert Pointy haired Boss sorta moment.) We have talked about moving to a non Windows platform for our production servers in the future. And since MSSQL only runs on windows we would need to move to another database platform. We are still in the very early stages of mapping out our tech plan for what OS platforms we want to use in production. So, nothing is set in stone just yet. I am primarily just doing research now, so I thought I would ask people who have worked with MySQL and have good and bad experiences. Thanks, Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 10:07 AM To: CF-Talk Subject: Re: Pro/Con Moving from MSSQL to MySQL Mark W. Breneman wrote: We are in the early stages of *thinking* about moving away from MS SQL server and moving to MySQL. Why? What do you hope to gain from this move? Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196313 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: Pro/Con Moving from MSSQL to MySQL
NOW()? Surely you mean GETDATE()? -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: 24 February 2005 16:26 To: CF-Talk Subject: RE: Pro/Con Moving from MSSQL to MySQL Another point to consider is in MySQL you can not use A default date field to be auto-populated as you can in MS-SQL using the NOW() function. I had to modify my code to accommodate that function. But for the most part I rather enjoy MySQL. -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 11:19 AM To: CF-Talk Subject: Re: Pro/Con Moving from MSSQL to MySQL On Thu, 24 Feb 2005 10:04:22 -0600, Mark W. Breneman [EMAIL PROTECTED] wrote: We are in the early stages of *thinking* about moving away from MS SQL server and moving to MySQL. Can anyone give me a quick pro / con points for doing this or not doing this? I'm a big MySQL fan, and a long-time MS-SQL developer/admin so I've done a lot of work stradling both camps. I'd give you one fundamental piece of advice: Don't do it just because MySQL is free (as in beer) Yeah, there's an order of magnitude difference in cost (MS-SQL unlimited is 5k/proc; MySQL is 500/server if you license it, which is optional for most folks). But unless you're running *lots* of processors, the savings are minimal. Pros/cons are a little hard to do unless without reference to specific needs, but based on the scenario you have below (lots of read, little write) MyISAM tables are probably faster than MS-SQL, and you can run the app on more operating systems. And it's cheaper on the backup and staging side since you don't have to pay MS rates for those licenses. We have about 60 Databases set up on on a server that gets low traffic. Few thousand users per day. Mostly we use the database as a data storage. We have only a few stored procedures that probably really don't need to be Stored Procedures. The heaviest load we ever put on the SQL server is a few report admin pages where we use SQL to sum and count various stats about the users answers. MySQL is plenty powerful enough, though it benefits a lot more from tuning than MS-SQL does in my experience -- both of those tools provide similar *query* tuning options, but MySQL has hundreds of options that can be tweaked to provider fine-grained control on tuning the server while MS-SQL basically does a lot of self-tuning. I know that we will have to rewrite anything that we have used MSSQL functions and MSSQL SQL commands. Less than you think needs rewritten -- MySQL has lots of common MS-SQL (and Oracle, etc) commands built-in or aliased to the native MySQL functions. The only difference in very common SQL off the top of my head is the non-standard way Microsoft does queries with a rowlimit -- MySQL uses SELECT xx LIMIT N etc instead of SELECT TOP N xx like MS-SQL. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196314 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: Pro/Con Moving from MSSQL to MySQL
Mark W. Breneman wrote: We are configing a new windows 2000 webserver server and the owner walked up and just asked out of the blue what if we install MySql and not MSSQL. (and no this was not a Dilbert Pointy haired Boss sorta moment.) We have talked about moving to a non Windows platform for our production servers in the future. And since MSSQL only runs on windows we would need to move to another database platform. So am I to understand the poin is not moving to MySQL, but moving away from MS SQL Server to something that also runs on unix? Because in that case MySQL is just one of the many options. Jochem ~| 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:196315 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: Pro/Con Moving from MSSQL to MySQL
That's a ridiculous thing to say without at least qualifying it. MySQL is a far better tool for me than MSSQL because as a developer I often need to be able to destroy an existing database and replace it with a backed up version. With MySQL I can do that in a matter of a couple of seconds from the command line, or from a batch file. With MSSQL I need to open up Enterprise manager and run the restore database backup function praying that CFMX has dropped any existing connections because if it hasn't I'll have to go stop that before doing the restore. There's no doubt that there are times where MSSQL is a better fit, but blythely assuming that it's always the case is naive at best. Spike Robertson-Ravo, Neil (RX) wrote: Well, whatever you think of Microsoft, SQL Server is far far better then mySQL will ever be (cost aside that is!). -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: 24 February 2005 16:27 To: CF-Talk Subject: RE: Pro/Con Moving from MSSQL to MySQL Yeah, I thought that question might come up... We are configing a new windows 2000 webserver server and the owner walked up and just asked out of the blue what if we install MySql and not MSSQL. (and no this was not a Dilbert Pointy haired Boss sorta moment.) We have talked about moving to a non Windows platform for our production servers in the future. And since MSSQL only runs on windows we would need to move to another database platform. We are still in the very early stages of mapping out our tech plan for what OS platforms we want to use in production. So, nothing is set in stone just yet. I am primarily just doing research now, so I thought I would ask people who have worked with MySQL and have good and bad experiences. Thanks, Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 10:07 AM To: CF-Talk Subject: Re: Pro/Con Moving from MSSQL to MySQL Mark W. Breneman wrote: We are in the early stages of *thinking* about moving away from MS SQL server and moving to MySQL. Why? What do you hope to gain from this move? Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196316 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: CF7 won't run under IIS, wont install - business almost shut down for 2 days now.
No, I doubt the it was because of other programs. I always shut down just about everything - habit from the good old DOS days (except we didn't have services_. I would have even done it in Safe Mode if I could have. Actually, one of the problems was when CFMX7 installed itself - on restart - some of the critical services wouldn't even start (like RPC). I barely had anything running when I installed. It tried anything to get CFMX7 running - the only thing I could get running without crashes was putting CFMX7 on stand-alone with the built-in server. ~| 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:196319 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: Reason to *not* store lots of data in Application scope?
Actually, I think you missed part of the point. Regardless of whether the article is data in a database or a text file sitting on a disk, the amount of disk I/O to get those blocks into memory is the same order of magnitude (db page size and fragmentation vs os block size and fragmentation probably plays a role, but still should be same order of magnitude). I agree, then you have the overhead of processing through CF and the additional I/O that it has to do if you were to go the db query application cache, etc. Plus your query is probably only going to the app server (ColdFusion's query cache) or to the database's memory (cached database pages) and not the disk directly if it's a frequently used item -- frequent use is exactly why relying on the inherent caching in the lower-level components is useful! With Static Publishing you don't have to worry about the coupling of the files to the db if the db were to die, you don't have to worry about the extra overhead that CF has to do. Actually CF I believe uses static publishing itself. Why send a file through the engine, have it access the db, and then be cached by your server? That's silly IMO, do it once and update as needed instead of basically updating everytime it is accessed, whether you are using application caching or not. With Static Publishing your killing a couple of needless steps and you get the same performance if not better and less to worry about. The database option requires a little more *processor* overhead (for the database and the app server) but the slow step is the disk i/o. And that difference may be moot if you're using some sort of compression on the web server (e.g. mod_deflate, mod_gzip, or the IIS equivalent filters) which also requires overhead If either your web server cache or your database cache (or you app server cache for that matter) can hold the entire collection, the point is pretty moot about where it lives -- though I'd personally go for the disk files. I agree Legal documents -- maybe 4MB each? 2.5 GB of memory puts a big dent in that and isn't very expensive, relatively speaking. So to be safe, a server with 4 GB of RAM could run the collection (or at least the hottest part of the collection) in main memory -- regardless of whether it's web server, app server, or database server. Again I agree, however I disagree that it _should_ be done this way. It can be done, but there is more to worry about if something goes wrong. If for example the machine you've got all of this data in memory on dies, you have to go through the overhead of building the data again which sucks on many levels. My real vote would probably be RAM disk with Apache to serve it up... or MySQL 4.1 with the query cache set to the size of the database :) Plus I'd make sure to use the meta headers on the resulting pages to prevent duplicate downloads. Of course there is a hit if you have to completely rebuild the collection (catastrophic disk failure on web server) but that's probably on the order of a database restore. I agree, but depending on your setup that can be a real PITA. Of course I like playing with 10-100GB MySQL data warehouses, so I'm biased :) Have fun. ;-) Say a 10M index and static files seems to me to be better than 100GB of data. ;-) -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| 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:196318 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: Pro/Con Moving from MSSQL to MySQL
If I am not mistaken in that is a new feature in MySql 4.1. We just dealt with this issue for a client that wanted to run their CFMX/MSSQL site on a Mac Blue Dragon/MySQL server. If I recall correctly in 4.1 you can control how the auto-populated date field works. We have two date fields in each table, recorddate and recordupdateddate. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 10:26 AM To: CF-Talk Subject: RE: Pro/Con Moving from MSSQL to MySQL Another point to consider is in MySQL you can not use A default date field to be auto-populated as you can in MS-SQL using the NOW() function. I had to modify my code to accommodate that function. But for the most part I rather enjoy MySQL. -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 11:19 AM To: CF-Talk Subject: Re: Pro/Con Moving from MSSQL to MySQL On Thu, 24 Feb 2005 10:04:22 -0600, Mark W. Breneman [EMAIL PROTECTED] wrote: We are in the early stages of *thinking* about moving away from MS SQL server and moving to MySQL. Can anyone give me a quick pro / con points for doing this or not doing this? I'm a big MySQL fan, and a long-time MS-SQL developer/admin so I've done a lot of work stradling both camps. I'd give you one fundamental piece of advice: Don't do it just because MySQL is free (as in beer) Yeah, there's an order of magnitude difference in cost (MS-SQL unlimited is 5k/proc; MySQL is 500/server if you license it, which is optional for most folks). But unless you're running *lots* of processors, the savings are minimal. Pros/cons are a little hard to do unless without reference to specific needs, but based on the scenario you have below (lots of read, little write) MyISAM tables are probably faster than MS-SQL, and you can run the app on more operating systems. And it's cheaper on the backup and staging side since you don't have to pay MS rates for those licenses. We have about 60 Databases set up on on a server that gets low traffic. Few thousand users per day. Mostly we use the database as a data storage. We have only a few stored procedures that probably really don't need to be Stored Procedures. The heaviest load we ever put on the SQL server is a few report admin pages where we use SQL to sum and count various stats about the users answers. MySQL is plenty powerful enough, though it benefits a lot more from tuning than MS-SQL does in my experience -- both of those tools provide similar *query* tuning options, but MySQL has hundreds of options that can be tweaked to provider fine-grained control on tuning the server while MS-SQL basically does a lot of self-tuning. I know that we will have to rewrite anything that we have used MSSQL functions and MSSQL SQL commands. Less than you think needs rewritten -- MySQL has lots of common MS-SQL (and Oracle, etc) commands built-in or aliased to the native MySQL functions. The only difference in very common SQL off the top of my head is the non-standard way Microsoft does queries with a rowlimit -- MySQL uses SELECT xx LIMIT N etc instead of SELECT TOP N xx like MS-SQL. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| 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:196318 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: Pro/Con Moving from MSSQL to MySQL
Well whichever, MySQL does not have that functionality. I wish it did. But still, I do enjoy using MySQL rather than MS-SQL. But that is my personal choice -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 11:25 AM To: CF-Talk Subject: RE: Pro/Con Moving from MSSQL to MySQL NOW()? Surely you mean GETDATE()? -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: 24 February 2005 16:26 To: CF-Talk Subject: RE: Pro/Con Moving from MSSQL to MySQL Another point to consider is in MySQL you can not use A default date field to be auto-populated as you can in MS-SQL using the NOW() function. I had to modify my code to accommodate that function. But for the most part I rather enjoy MySQL. -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 11:19 AM To: CF-Talk Subject: Re: Pro/Con Moving from MSSQL to MySQL On Thu, 24 Feb 2005 10:04:22 -0600, Mark W. Breneman [EMAIL PROTECTED] wrote: We are in the early stages of *thinking* about moving away from MS SQL server and moving to MySQL. Can anyone give me a quick pro / con points for doing this or not doing this? I'm a big MySQL fan, and a long-time MS-SQL developer/admin so I've done a lot of work stradling both camps. I'd give you one fundamental piece of advice: Don't do it just because MySQL is free (as in beer) Yeah, there's an order of magnitude difference in cost (MS-SQL unlimited is 5k/proc; MySQL is 500/server if you license it, which is optional for most folks). But unless you're running *lots* of processors, the savings are minimal. Pros/cons are a little hard to do unless without reference to specific needs, but based on the scenario you have below (lots of read, little write) MyISAM tables are probably faster than MS-SQL, and you can run the app on more operating systems. And it's cheaper on the backup and staging side since you don't have to pay MS rates for those licenses. We have about 60 Databases set up on on a server that gets low traffic. Few thousand users per day. Mostly we use the database as a data storage. We have only a few stored procedures that probably really don't need to be Stored Procedures. The heaviest load we ever put on the SQL server is a few report admin pages where we use SQL to sum and count various stats about the users answers. MySQL is plenty powerful enough, though it benefits a lot more from tuning than MS-SQL does in my experience -- both of those tools provide similar *query* tuning options, but MySQL has hundreds of options that can be tweaked to provider fine-grained control on tuning the server while MS-SQL basically does a lot of self-tuning. I know that we will have to rewrite anything that we have used MSSQL functions and MSSQL SQL commands. Less than you think needs rewritten -- MySQL has lots of common MS-SQL (and Oracle, etc) commands built-in or aliased to the native MySQL functions. The only difference in very common SQL off the top of my head is the non-standard way Microsoft does queries with a rowlimit -- MySQL uses SELECT xx LIMIT N etc instead of SELECT TOP N xx like MS-SQL. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| 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:196320 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-SQL matching
My bad, I misunderstood.
Run this and wack in some more sample data to see if it works
CREATE TABLE #temp ( Names VARCHAR(100) )
INSERT INTO #temp ( Names ) VALUES ( 'LITTLE DONALD V' )
INSERT INTO #temp ( Names ) VALUES ( 'LITTLE DONALD VICTOR' )
INSERT INTO #temp ( Names ) VALUES ( 'LITTLE DONALD Victor JR' )
SELECT
'::' + SUBSTRING(Names, 1, CHARINDEX(' ', Names, 1) - 1) + '::'
'FirstName',
'::' + SUBSTRING(Names, CHARINDEX(' ', Names, 1) + 1, CHARINDEX(' ',
Names,
CHARINDEX(' ', Names, 1)) - 1) + '::' 'LastName'
FROM #temp
DROP TABLE #temp
I've put :: on either side to make sure no white space is being returned
along with the name.
Ade
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:56
To: CF-Talk
Subject: RE: OT-SQL matching
It is always
LASTNAME FIRSTNAME then ..
LITTLE DONALD Victor JR
So I just want
LASTNAME = LITTLE
FIRSTNAME = DONALD
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 24, 2005 9:55 AM
To: CF-Talk
Subject: RE: OT-SQL matching
In fact I think you're on to a hiding to nothing...
.. I don't think you can make any reasonable assumptions about what is a
middle name and what is a suffix. In the before samples VICTOR could be a
suffix.
Maybe I'm not understanding it all but I don't think you'll be able to do
this with 100% accuracy.
Ade
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:49
To: CF-Talk
Subject: RE: OT-SQL matching
Will the last name always be first in the column? In the samples below, is
the person's first name DONALD, and then last names LITTLE, LITTLE VICTOR
and LITTLE Victor?
LITTLE DONALD V
LITTLE DONALD VICTOR
LITTLE DONALD Victor JR
Ade
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:37
To: CF-Talk
Subject: RE: OT-SQL matching
Okay I go something to work so my orginal question is taken care of. However
I have another question that deals with this sort of thing. I am now looking
at another datasource that I am going to have to match on at somepoint later
but they have a single name field where a persons name is one field and is
LASTNAME FIRSTNAME, MIDDLE SUFFIX (LITTLE DONALD V or LITTLE DONALD VICTOR
or LITTLE DONALD Victor JR).
I am simply querying out the information that I need and putting it in a
holding table. But while I am doing this I want to extract the LAST and
FIRST names and store them in their seperate columns in the holding the
table. I can get the last name and I can get the first name but along with
the first name I get the middle name and suffix as well. By the way this is
a data file provided by the FAA. Here is what I am doing lease the INTO
statement.
SELECT
SUBSTRING([name], 1, CHARINDEX(' ', [name])) AS lastname,
SUBSTRING([name], CHARINDEX(' ',[name])+1,LEN([name])) as firstname ,
street,street2,city,state,[zip code] as zip
FROM master
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196321
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: Pro/Con Moving from MSSQL to MySQL
On Thu, 24 Feb 2005 10:15:34 -0600, toru okada [EMAIL PROTECTED] wrote: I can give you two good reasons. LiveJournal and Wikipedia. In the past couple of months both of these websites went down due to power issues in their coloco facilities. It took a bit of effort to bring both of these sites back up because the database was in an inconsistent state. Both sites lost data. I would not trust anything of value in MySql. Wow, what a load of FUD. Neither LiveJournal nor Wikipedia blame the outages on MySQL. For example, the livejournal developer blogged the details of what happened here -- http://www.livejournal.com/community/lj_dev/670215.html. Note that the core problem was that someone TURNED OFF THE POWER TO THE WHOLE COLO. Read through the details, they had hardware issues and configuration issues that they discovered as part of the process. And they only talk about the slow rebuild of the MyISAM indexes, which is a known tradeoff for large MyISAM tables (note also that they're running most of their tables in Innodb instead). I'm less familar w/ what went on with Wikipedia, but Jochem has a post in the thread here http://lists.mysql.com/mysql/180389 which is related to a possible underlying issue in the fsync() implementation in the 2.6 linux kernel (several online sites have mentioned that Wikipedia makes lots of use of the Fedora Core, which is a tradeoff between new features -- and related possibilty of bugs -- and stability/support of a RedHat Enterprise or Suse). Painting with broad strokes without a lot of information isn't real useful. Here's some more FUD... OH MY GOD! THERE ARE WORMS THAT CAN HIT SQL SERVER. Why would I ever trust my data to MS-SQL?!?!?!?? Of course you can trust MS-SQL -- it's a great database. I'd ask what kind of idiot leaves port 1433 open on a MS-SQL server in the first place (due to the number of infections with the various worms, apparently a lot)? The issue LiveJournal had with the disk cache for example, would likely have affected MS-SQL just as readily as MySQL. How about some counter examples about organizations that get a lot of value out of MySQL: Yahoo! (financial particularly, but also travel and others); Sabre (for clearing airline reservations); Cox Cable (for their customer data warehouse) Los Alamos (for terabytes of data) and yes, both Wikipedia and LiveJournal too -- read what they're saying before you write MySQL off because of a post on Slashdot... -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196323 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: Pro/Con Moving from MSSQL to MySQL
OK Spike ;-), I will certainly say it is a sweeping statement but based on experience it is far far better. I am not sure you mean about destroying a DB and restoring? With SQL Server it is certainly far better to totally avoid using Enterprise Manager as it is evil, I will give you that - stick to QAand/or other backup tools such as Red-Gate tools to restore DB's in a few mins, OR take periodic detach db snaps which you can attach in a matter of seconds via QA. -Original Message- From: Spike [mailto:[EMAIL PROTECTED] Sent: 24 February 2005 16:34 To: CF-Talk Subject: Re: Pro/Con Moving from MSSQL to MySQL That's a ridiculous thing to say without at least qualifying it. MySQL is a far better tool for me than MSSQL because as a developer I often need to be able to destroy an existing database and replace it with a backed up version. With MySQL I can do that in a matter of a couple of seconds from the command line, or from a batch file. With MSSQL I need to open up Enterprise manager and run the restore database backup function praying that CFMX has dropped any existing connections because if it hasn't I'll have to go stop that before doing the restore. There's no doubt that there are times where MSSQL is a better fit, but blythely assuming that it's always the case is naive at best. Spike Robertson-Ravo, Neil (RX) wrote: Well, whatever you think of Microsoft, SQL Server is far far better then mySQL will ever be (cost aside that is!). -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: 24 February 2005 16:27 To: CF-Talk Subject: RE: Pro/Con Moving from MSSQL to MySQL Yeah, I thought that question might come up... We are configing a new windows 2000 webserver server and the owner walked up and just asked out of the blue what if we install MySql and not MSSQL. (and no this was not a Dilbert Pointy haired Boss sorta moment.) We have talked about moving to a non Windows platform for our production servers in the future. And since MSSQL only runs on windows we would need to move to another database platform. We are still in the very early stages of mapping out our tech plan for what OS platforms we want to use in production. So, nothing is set in stone just yet. I am primarily just doing research now, so I thought I would ask people who have worked with MySQL and have good and bad experiences. Thanks, Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 10:07 AM To: CF-Talk Subject: Re: Pro/Con Moving from MSSQL to MySQL Mark W. Breneman wrote: We are in the early stages of *thinking* about moving away from MS SQL server and moving to MySQL. Why? What do you hope to gain from this move? Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196322 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-SQL matching
I will give it a try. I wnet ahead and did it in two steps and got the data I
want but to get it all in one would be what I would like.
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 24, 2005 10:44 AM
To: CF-Talk
Subject: RE: OT-SQL matching
My bad, I misunderstood.
Run this and wack in some more sample data to see if it works
CREATE TABLE #temp ( Names VARCHAR(100) )
INSERT INTO #temp ( Names ) VALUES ( 'LITTLE DONALD V' )
INSERT INTO #temp ( Names ) VALUES ( 'LITTLE DONALD VICTOR' )
INSERT INTO #temp ( Names ) VALUES ( 'LITTLE DONALD Victor JR' )
SELECT
'::' + SUBSTRING(Names, 1, CHARINDEX(' ', Names, 1) - 1) + '::'
'FirstName',
'::' + SUBSTRING(Names, CHARINDEX(' ', Names, 1) + 1, CHARINDEX(' ',
Names,
CHARINDEX(' ', Names, 1)) - 1) + '::' 'LastName'
FROM #temp
DROP TABLE #temp
I've put :: on either side to make sure no white space is being returned
along with the name.
Ade
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:56
To: CF-Talk
Subject: RE: OT-SQL matching
It is always
LASTNAME FIRSTNAME then ..
LITTLE DONALD Victor JR
So I just want
LASTNAME = LITTLE
FIRSTNAME = DONALD
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 24, 2005 9:55 AM
To: CF-Talk
Subject: RE: OT-SQL matching
In fact I think you're on to a hiding to nothing...
... I don't think you can make any reasonable assumptions about what is a
middle name and what is a suffix. In the before samples VICTOR could be a
suffix.
Maybe I'm not understanding it all but I don't think you'll be able to do
this with 100% accuracy.
Ade
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:49
To: CF-Talk
Subject: RE: OT-SQL matching
Will the last name always be first in the column? In the samples below, is
the person's first name DONALD, and then last names LITTLE, LITTLE VICTOR
and LITTLE Victor?
LITTLE DONALD V
LITTLE DONALD VICTOR
LITTLE DONALD Victor JR
Ade
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:37
To: CF-Talk
Subject: RE: OT-SQL matching
Okay I go something to work so my orginal question is taken care of. However
I have another question that deals with this sort of thing. I am now looking
at another datasource that I am going to have to match on at somepoint later
but they have a single name field where a persons name is one field and is
LASTNAME FIRSTNAME, MIDDLE SUFFIX (LITTLE DONALD V or LITTLE DONALD VICTOR
or LITTLE DONALD Victor JR).
I am simply querying out the information that I need and putting it in a
holding table. But while I am doing this I want to extract the LAST and
FIRST names and store them in their seperate columns in the holding the
table. I can get the last name and I can get the first name but along with
the first name I get the middle name and suffix as well. By the way this is
a data file provided by the FAA. Here is what I am doing lease the INTO
statement.
SELECT
SUBSTRING([name], 1, CHARINDEX(' ', [name])) AS lastname,
SUBSTRING([name], CHARINDEX(' ',[name])+1,LEN([name])) as firstname ,
street,street2,city,state,[zip code] as zip
FROM master
~|
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:196326
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: Pro/Con Moving from MSSQL to MySQL
One is the obvious question of, have you thought of PostgreSQL? It is much more feature rich than MySQL and is now also a native Windows app with version 8 (previously it wasn't, at least as standard). -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196324 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: Pro/Con Moving from MSSQL to MySQL
toru okada wrote: I can give you two good reasons. LiveJournal and Wikipedia. They are not reasons to stay away from MySQL, just examples of misconfigured systems and bad behaving OS'es. What might be a reason is that the default configuration of MySQL offers no data integrity protection in case of power failures. By default MySQL uses MyISAM tables which are not even transactional. When you use InnoDB tables MySQL will make the right calls to the OS to protect your data, but it is very common for OS'es to foobar, both Linux and Windows (just go to the Disk Manager in Windows and read the warning about write-back caching and dataloss). I can think of many reasons not to trust MySQL to protect my data, ranging from sloppy foreign keys to crazy NOT NULL implementations, but power outages are not one of them. You just have to take the right precautions (you did pull the plug out of a running disksystem a few times while doing acceptance tests, didn't you?). Jochem ~| 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:196325 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: THIS scope
That doesn't really cover static, though - what makes a static member static is that it belongs to the type instead of one instance of a type. I.e.: InstanceOne.StaticVar = 1 InstanceTwo.StaticVar = 2 !--- Would show 2 if we had statics --- cfoutput#InstanceOne.StaticVar#/cfoutput Application.cfc - onapplicationstart cfset server.myStaticClass = CreateObject(component,mystaticclass) then reference the information as server.myStaticClass.getStaticVar(); there ya go. It's not _technically_ a static class, but it's as close as CF offers. In retrospect I believe the cfinvoke tag will allow you to execute a method of a CFC without invoking the CFC, so I take back what I said before about the server scope CFC being the closest thing to static... Retain the method, and use this to return the public static final variable: cfinvoke component=my.component.path method=getStaticVar returnVariable=staticvar Yea, it's longer syntax... The price paid for being fastidious I guess... :) OR cffunction name=invoke cfargument name=component required=true cfargument name=method type=string required=true cfargument name=argumentCollection type=struct default=#structnew()# cfset var rtn = cfinvoke component=#component# method=#method# returnVariable=rtn argumentCollection=#argumentCollection# cfreturn rtn /cffunction cfset static = invoke(my.component.path,getStaticVar) s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196327 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: Pro/Con Moving from MSSQL to MySQL
On Thu, 24 Feb 2005 08:33:40 -0800, Spike [EMAIL PROTECTED] wrote: That's a ridiculous thing to say without at least qualifying it. Agreed. No better than blithely saying MySQL rules because it's open source :) MySQL is a far better tool for me than MSSQL because as a developer I often need to be able to destroy an existing database and replace it with a backed up version. With MySQL I can do that in a matter of a couple of seconds from the command line, or from a batch file. With MSSQL I need to open up Enterprise manager and run the restore database backup function praying that CFMX has dropped any existing connections because if it hasn't I'll have to go stop that before doing the restore. Actually, that's not fair at all. You can use T-SQL and the osql command line just as effectively, though it takes more steps and isn't as intuitive since MS has forced you to think GUI. It takes a similar amount of steps to restore a database through the MySQL Administrator GUI too if you can at all (so used to command line I haven't checked...) There's no doubt that there are times where MSSQL is a better fit, but blythely assuming that it's always the case is naive at best. Agreed. I mean there's PostgreSQL, Firebird, and Derby in the open source arena alone. And in the commercial world there's also Oracle and DB2, which now are pretty price-competative with MS-SQL. Oh, and things like Cache. And Sybase is still around. It's not always a MS-SQL vs MySQL decision and like Spike implies, knowing the problem you're trying to solve is the important part of the process -- not blithely assuming paying for something (or getting it free) makes it better. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| 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:196328 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: Pro/Con Moving from MSSQL to MySQL
On Thu, 24 Feb 2005 11:39:41 -0500, Adkins, Randy [EMAIL PROTECTED] wrote: Well whichever, MySQL does not have that functionality. I wish it did. But still, I do enjoy using MySQL rather than MS-SQL. But that is my personal choice Actually, MySQL has an entire field type for handling timestamps (TIMESTAMP) that autopopulates on create and then optionally again on every update, depending on how you write the query. Of course that makes your code a bit less portable. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 11:25 AM To: CF-Talk Subject: RE: Pro/Con Moving from MSSQL to MySQL NOW()? Surely you mean GETDATE()? -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: 24 February 2005 16:26 To: CF-Talk Subject: RE: Pro/Con Moving from MSSQL to MySQL Another point to consider is in MySQL you can not use A default date field to be auto-populated as you can in MS-SQL using the NOW() function. I had to modify my code to accommodate that function. But for the most part I rather enjoy MySQL. -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 11:19 AM To: CF-Talk Subject: Re: Pro/Con Moving from MSSQL to MySQL On Thu, 24 Feb 2005 10:04:22 -0600, Mark W. Breneman [EMAIL PROTECTED] wrote: We are in the early stages of *thinking* about moving away from MS SQL server and moving to MySQL. Can anyone give me a quick pro / con points for doing this or not doing this? I'm a big MySQL fan, and a long-time MS-SQL developer/admin so I've done a lot of work stradling both camps. I'd give you one fundamental piece of advice: Don't do it just because MySQL is free (as in beer) Yeah, there's an order of magnitude difference in cost (MS-SQL unlimited is 5k/proc; MySQL is 500/server if you license it, which is optional for most folks). But unless you're running *lots* of processors, the savings are minimal. Pros/cons are a little hard to do unless without reference to specific needs, but based on the scenario you have below (lots of read, little write) MyISAM tables are probably faster than MS-SQL, and you can run the app on more operating systems. And it's cheaper on the backup and staging side since you don't have to pay MS rates for those licenses. We have about 60 Databases set up on on a server that gets low traffic. Few thousand users per day. Mostly we use the database as a data storage. We have only a few stored procedures that probably really don't need to be Stored Procedures. The heaviest load we ever put on the SQL server is a few report admin pages where we use SQL to sum and count various stats about the users answers. MySQL is plenty powerful enough, though it benefits a lot more from tuning than MS-SQL does in my experience -- both of those tools provide similar *query* tuning options, but MySQL has hundreds of options that can be tweaked to provider fine-grained control on tuning the server while MS-SQL basically does a lot of self-tuning. I know that we will have to rewrite anything that we have used MSSQL functions and MSSQL SQL commands. Less than you think needs rewritten -- MySQL has lots of common MS-SQL (and Oracle, etc) commands built-in or aliased to the native MySQL functions. The only difference in very common SQL off the top of my head is the non-standard way Microsoft does queries with a rowlimit -- MySQL uses SELECT xx LIMIT N etc instead of SELECT TOP N xx like MS-SQL. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| 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:196329 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: Reason to *not* store lots of data in Application scope?
With Static Publishing you don't have to worry about the coupling of the files to the db if the db were to die, you don't have to worry about the extra overhead that CF has to do. Actually CF I believe uses static publishing itself. Why send a file through the engine, have it access the db, and then be cached by your server? That's silly IMO, do it once and update as needed instead of basically updating everytime it is accessed, whether you are using application caching or not. With Static Publishing your killing a couple of needless steps and you get the same performance if not better and less to worry about. Actually I'm just leaning towards pragmatic. Relying on the database, webserver, and app server to cache everything for me means I don't have to write and maintain code for the application-oriented caching (application-scope data or generated files). At least until there *is* a performance issue. Another gig of memory is cheaper than coding, testing, and maintenance. Though on the other hand, generating static pages from the db could be refactored into a reusable tool for doing same which would also be pragmatic :) Of course I like playing with 10-100GB MySQL data warehouses, so I'm biased :) Say a 10M index and static files seems to me to be better than 100GB of data. ;-) No argument. Especially if you have to back it up. Or try to restore it. Or move it. I mean, it's often easier to ship a harddrive FedEx than copy over a network... -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| 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:196330 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: CF-Talk: Digest every 6 hours
Hi, Thanks for your message. I will be away on vacation Feb 24th - Mar 4th. I will reply to your message on my return. Have a great day! Bryon ~| 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:196331 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: Pro/Con Moving from MSSQL to MySQL
Actually, that's not fair at all. You can use T-SQL and the osql command line just as effectively, though it takes more steps and isn't as intuitive since MS has forced you to think GUI. It takes a similar amount of steps to restore a database through the MySQL Administrator GUI too if you can at all (so used to command line I haven't checked...) Thanks Paul, I wasn't aware that you could do that with MSSQL. Does that allow you to get around those times when CF has still got a DB connection open? The example I gave was just that, an example. There are plenty more such as the ability to dump a database table to an SQL script. That can be handy if you need to send some sample data to another developer. Again, these are things that are handy for a developer. They don't necessarily translate to making it a better DB for live sites, but I still stand by my point that there are times when MySQL will work better for you and times when it won't. The same applies to other options like Hibernate, Prevayler, PostgreSQL, Cloudbase, Oracle etc. Spike -- Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org ~| 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:196332 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: Pro/Con Moving from MSSQL to MySQL
Another point to consider is in MySQL you can not use A default date field to be auto-populated as you can in MS-SQL using the NOW() function. GETDATE() -- NOW() Is Access... or does MySQL use now() also? s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196334 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: Pro/Con Moving from MSSQL to MySQL
Mark W. Breneman wrote: We are configing a new windows 2000 webserver server and the owner walked up and just asked out of the blue what if we install MySql and not MSSQL. (and no this was not a Dilbert Pointy haired Boss sorta moment.) We have talked about moving to a non Windows platform for our production servers in the future. And since MSSQL only runs on windows we would need to move to another database platform. So am I to understand the poin is not moving to MySQL, but moving away from MS SQL Server to something that also runs on unix? Because in that case MySQL is just one of the many options. Jochem Heh... I hadn't read the original post as thoroughly, and Jochem brings up the most important point that the rest of us missed. Given the choice, I would probably investigate PostgreSQL more thoroughly. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196336 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: Pro/Con Moving from MSSQL to MySQL
Damien McKenna wrote: One is the obvious question of, have you thought of PostgreSQL? It is much more feature rich than MySQL and is now also a native Windows app with version 8 (previously it wasn't, at least as standard). Hey, you stole my line! There are a number of other alternatives to consider, just in the free Open Source arena there is Firebird, Ingress, Derby and PostgreSQL (and then I am skipping a few off the less prevalent ones). All have their pro's and cons, but personally I like PostgreSQL a lot. Like Damien said it is much more feature rich then MySQL, and you can use that to make a migration easier. For instance, instead of replacing the MS getDate() idiosyncracy with the MySQL Now() idiosyncracy in all of your CF code, you can just leave your CF code alone and define a getDate() function in PostgreSQL that returns the current timestamp. One function, instead of all your CF code. Jochem ~| 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:196338 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: Pro/Con Moving from MSSQL to MySQL
I know that we will have to rewrite anything that we have used MSSQL functions and MSSQL SQL commands. Less than you think needs rewritten -- MySQL has lots of common MS-SQL (and Oracle, etc) commands built-in or aliased to the native MySQL functions. The only difference in very common SQL off the top of my head is the non-standard way Microsoft does queries with a rowlimit -- MySQL uses SELECT xx LIMIT N etc instead of SELECT TOP N xx like MS-SQL. Don't you still lose the ability to use views, stored procedures, triggers and custom functions with the latest versions of MySQL? I think most applications wouldn't suffer from the lack of procedures, triggers or functions, but the lack of views is what I find personally frustrating more than the rest. Although I still like stored procedures for certain tasks and very occasionally a function or trigger. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com ~| 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:196333 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: Pro/Con Moving from MSSQL to MySQL
On Thu, 24 Feb 2005 17:45:01 +0100, Jochem van Dieten [EMAIL PROTECTED] wrote: They are not reasons to stay away from MySQL, just examples of misconfigured systems and bad behaving OS'es. sorry jochem, i am going to have to resepectfully disagree with you here. This would not happen with a fully ACID compliant database. Not the hack that MySql has done to make this happen. I am not saying MySql doesn't have its place with the database market, just that I would never use it for data that was important to a buisness. the D in ACID is for durability. which guarantess that if anything happens irregardless of misconfigured systems and bad behaving OS'es that the database will keep track of the current state. I do not think this is FUD by anymeans. I do not think that LiveJournal nor Wikipedia can say that their databases where left in consistent states on restart. A very simple task for an ACID database toru ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196335 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: Pro/Con Moving from MSSQL to MySQL
The example I gave was just that, an example. There are plenty more such as the ability to dump a database table to an SQL script. That can be handy if you need to send some sample data to another developer. There's a 3rd party GUI tool called SqlYob (I think) for MySQL that handles a lot of these types of things. It's probably not the only one -- and I still found the interface a bit strange/fidgety, but it worked. :) s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196341 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-SQL matching
Eric
You can use this UDF too
CREATE FUNCTION dbo.getLastName(@fullname varchar(200))
RETURNS varchar(50)
AS
begin
Set @fullname = substring(@fullname,Charindex(' ',@fullname) + 1
,len(@fullname))
Set @fullname = substring(@fullname,1 ,charindex( ' ', @fullname ))
return @fullname
END
On Thu, 24 Feb 2005 10:43:04 -0600, Eric Creese [EMAIL PROTECTED] wrote:
I will give it a try. I wnet ahead and did it in two steps and got the data I
want but to get it all in one would be what I would like.
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 24, 2005 10:44 AM
To: CF-Talk
Subject: RE: OT-SQL matching
My bad, I misunderstood.
Run this and wack in some more sample data to see if it works
CREATE TABLE #temp ( Names VARCHAR(100) )
INSERT INTO #temp ( Names ) VALUES ( 'LITTLE DONALD V' )
INSERT INTO #temp ( Names ) VALUES ( 'LITTLE DONALD VICTOR' )
INSERT INTO #temp ( Names ) VALUES ( 'LITTLE DONALD Victor JR' )
SELECT
'::' + SUBSTRING(Names, 1, CHARINDEX(' ', Names, 1) - 1) + '::'
'FirstName',
'::' + SUBSTRING(Names, CHARINDEX(' ', Names, 1) + 1, CHARINDEX(' ',
Names,
CHARINDEX(' ', Names, 1)) - 1) + '::' 'LastName'
FROM #temp
DROP TABLE #temp
I've put :: on either side to make sure no white space is being returned
along with the name.
Ade
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:56
To: CF-Talk
Subject: RE: OT-SQL matching
It is always
LASTNAME FIRSTNAME then ..
LITTLE DONALD Victor JR
So I just want
LASTNAME = LITTLE
FIRSTNAME = DONALD
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 24, 2005 9:55 AM
To: CF-Talk
Subject: RE: OT-SQL matching
In fact I think you're on to a hiding to nothing...
... I don't think you can make any reasonable assumptions about what is a
middle name and what is a suffix. In the before samples VICTOR could be a
suffix.
Maybe I'm not understanding it all but I don't think you'll be able to do
this with 100% accuracy.
Ade
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:49
To: CF-Talk
Subject: RE: OT-SQL matching
Will the last name always be first in the column? In the samples below, is
the person's first name DONALD, and then last names LITTLE, LITTLE VICTOR
and LITTLE Victor?
LITTLE DONALD V
LITTLE DONALD VICTOR
LITTLE DONALD Victor JR
Ade
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:37
To: CF-Talk
Subject: RE: OT-SQL matching
Okay I go something to work so my orginal question is taken care of. However
I have another question that deals with this sort of thing. I am now looking
at another datasource that I am going to have to match on at somepoint later
but they have a single name field where a persons name is one field and is
LASTNAME FIRSTNAME, MIDDLE SUFFIX (LITTLE DONALD V or LITTLE DONALD VICTOR
or LITTLE DONALD Victor JR).
I am simply querying out the information that I need and putting it in a
holding table. But while I am doing this I want to extract the LAST and
FIRST names and store them in their seperate columns in the holding the
table. I can get the last name and I can get the first name but along with
the first name I get the middle name and suffix as well. By the way this is
a data file provided by the FAA. Here is what I am doing lease the INTO
statement.
SELECT
SUBSTRING([name], 1, CHARINDEX(' ', [name])) AS lastname,
SUBSTRING([name], CHARINDEX(' ',[name])+1,LEN([name])) as firstname ,
street,street2,city,state,[zip code] as zip
FROM master
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196340
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: Pro/Con Moving from MSSQL to MySQL
On Thu, 24 Feb 2005 11:43:28 -0500, John Paul Ashenfelter [EMAIL PROTECTED] wrote: Wow, what a load of FUD. Neither LiveJournal nor Wikipedia blame the outages on MySQL. Nor did I say that. What I said is that because of the power failure their databases where left in a inconsistement state.which by the way is not FUD, it is a fact. toru ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196339 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: Pro/Con Moving from MSSQL to MySQL
On Thu, 24 Feb 2005 11:39:41 -0500, Adkins, Randy [EMAIL PROTECTED] wrote: Well whichever, MySQL does not have that functionality. I wish it did. But still, I do enjoy using MySQL rather than MS-SQL. But that is my personal choice Actually, MySQL has an entire field type for handling timestamps (TIMESTAMP) that autopopulates on create and then optionally again on every update, depending on how you write the query. Of course that makes your code a bit less portable. Iirc timestamp is the official standard name for date/time data types in SQL databases... MS SQL is abberant in using the name datetime or smalldatetime. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196337 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: CF7 won't run under IIS, wont install - business almost shut down for 2 days now.
It's not that I couldn't get it to play with Apache. I did get CF parse cfm files and apache to serve them. That wasn't the problem. It was the java.lang.OutOfMemory errors that were the problem. JRUN would eat up it's entire memory allocation (512MB) within 5 minutes and this is on a dev machine. This was happening with only one or two requests and with code known to work from a production server (6.1). As I said before, I played with the jvm arguments (blog posting from sargeway.com). After one request, you could like in the task manager and just the MB's being eaten up. ~| 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:196342 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: Pro/Con Moving from MSSQL to MySQL
Adkins, Randy wrote: Another point to consider is in MySQL you can not use A default date field to be auto-populated as you can in MS-SQL using the NOW() function. I had to modify my code to accommodate that function. But for the most part I rather enjoy MySQL. But OTOH, there's the incredibly useful LAST_INSERT_ID() function. K. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196345 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: Pro/Con Moving from MSSQL to MySQL
toru okada wrote: On Thu, 24 Feb 2005 17:45:01 +0100, Jochem van Dieten [EMAIL PROTECTED] wrote: They are not reasons to stay away from MySQL, just examples of misconfigured systems and bad behaving OS'es. sorry jochem, i am going to have to resepectfully disagree with you here. This would not happen with a fully ACID compliant database. MySQL *is* ACID, as long as you use the right kind of table handler. InnoDB and BDB tables a completely safe. MyISAM tables are not, but are faster. The choice of which you use is a trade-off. So yes, this is FUD. And worse still because your error has been pointed out and you persist in spreading it. K. - Who's coming to like Firebird/InterBase, and quite likes SQL Server. ~| 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:196343 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: Pro/Con Moving from MSSQL to MySQL
I think you mean SQLYog, I've used it quite a bit in the past and it's very handy if you aren't a command line junkie, or can't remember the specific syntax of a command. Spike S. Isaac Dealey wrote: The example I gave was just that, an example. There are plenty more such as the ability to dump a database table to an SQL script. That can be handy if you need to send some sample data to another developer. There's a 3rd party GUI tool called SqlYob (I think) for MySQL that handles a lot of these types of things. It's probably not the only one -- and I still found the interface a bit strange/fidgety, but it worked. :) s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com ~| 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:196344 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: serialize cfc
Yeah, I hear that. I suspect that more clusters use session affinity than you suspect, and just accept that failover scenarios aren't as good. The server cluster we built a couple years ago doesn't use session affinity (an intentional design characteristic), but we're finding that there are more reasons to have it than to avoid it, so we're in the process of switching. Which isn't to say that CFC replication wouldn't be nice to have, but I'd say raw CFC serialization would be a bigger boon. cheers, barneyb On Thu, 24 Feb 2005 08:41:50 -0500, Brian Kotek [EMAIL PROTECTED] wrote: Wow, that's a pretty sad oversight on the part of Macromedia. Basically, if you use any session-based CFCs you are forced to use sticky sessions. And even that doesn't help at all for failover. They added a lot of nice stuff in 7.0, but they also dropped the ball on several things and this is one of them. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196346 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: Pro/Con Moving from MSSQL to MySQL
toru okada wrote: On Thu, 24 Feb 2005 17:45:01 +0100, Jochem van Dieten wrote: They are not reasons to stay away from MySQL, just examples of misconfigured systems and bad behaving OS'es. sorry jochem, i am going to have to resepectfully disagree with you here. This would not happen with a fully ACID compliant database. Even fully ACID compliant depend on the OS they run on. The Single Unix Specification is very specific about the behaviour of fsync(). If a program calls fsync() on a file, the OS has to guarantee the file is written to durable storage and should block until that condition is met. If the OS is unable to do so then the OS should return an error. If the OS lets itself be fooled by the write-back cache of a RAID controller or a harddisk, the OS is to blame, not the program that calls fsync(). Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196349 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-SQL matching
thanks
-Original Message-
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 24, 2005 11:12 AM
To: CF-Talk
Subject: Re: OT-SQL matching
Eric
You can use this UDF too
CREATE FUNCTION dbo.getLastName(@fullname varchar(200))
RETURNS varchar(50)
AS
begin
Set @fullname = substring(@fullname,Charindex(' ',@fullname) + 1
,len(@fullname))
Set @fullname = substring(@fullname,1 ,charindex( ' ', @fullname ))
return @fullname
END
On Thu, 24 Feb 2005 10:43:04 -0600, Eric Creese [EMAIL PROTECTED] wrote:
I will give it a try. I wnet ahead and did it in two steps and got the data I
want but to get it all in one would be what I would like.
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 24, 2005 10:44 AM
To: CF-Talk
Subject: RE: OT-SQL matching
My bad, I misunderstood.
Run this and wack in some more sample data to see if it works
CREATE TABLE #temp ( Names VARCHAR(100) )
INSERT INTO #temp ( Names ) VALUES ( 'LITTLE DONALD V' )
INSERT INTO #temp ( Names ) VALUES ( 'LITTLE DONALD VICTOR' )
INSERT INTO #temp ( Names ) VALUES ( 'LITTLE DONALD Victor JR' )
SELECT
'::' + SUBSTRING(Names, 1, CHARINDEX(' ', Names, 1) - 1) + '::'
'FirstName',
'::' + SUBSTRING(Names, CHARINDEX(' ', Names, 1) + 1, CHARINDEX(' ',
Names,
CHARINDEX(' ', Names, 1)) - 1) + '::' 'LastName'
FROM #temp
DROP TABLE #temp
I've put :: on either side to make sure no white space is being returned
along with the name.
Ade
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:56
To: CF-Talk
Subject: RE: OT-SQL matching
It is always
LASTNAME FIRSTNAME then ..
LITTLE DONALD Victor JR
So I just want
LASTNAME = LITTLE
FIRSTNAME = DONALD
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 24, 2005 9:55 AM
To: CF-Talk
Subject: RE: OT-SQL matching
In fact I think you're on to a hiding to nothing...
... I don't think you can make any reasonable assumptions about what is a
middle name and what is a suffix. In the before samples VICTOR could be a
suffix.
Maybe I'm not understanding it all but I don't think you'll be able to do
this with 100% accuracy.
Ade
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:49
To: CF-Talk
Subject: RE: OT-SQL matching
Will the last name always be first in the column? In the samples below, is
the person's first name DONALD, and then last names LITTLE, LITTLE VICTOR
and LITTLE Victor?
LITTLE DONALD V
LITTLE DONALD VICTOR
LITTLE DONALD Victor JR
Ade
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 15:37
To: CF-Talk
Subject: RE: OT-SQL matching
Okay I go something to work so my orginal question is taken care of. However
I have another question that deals with this sort of thing. I am now looking
at another datasource that I am going to have to match on at somepoint later
but they have a single name field where a persons name is one field and is
LASTNAME FIRSTNAME, MIDDLE SUFFIX (LITTLE DONALD V or LITTLE DONALD VICTOR
or LITTLE DONALD Victor JR).
I am simply querying out the information that I need and putting it in a
holding table. But while I am doing this I want to extract the LAST and
FIRST names and store them in their seperate columns in the holding the
table. I can get the last name and I can get the first name but along with
the first name I get the middle name and suffix as well. By the way this is
a data file provided by the FAA. Here is what I am doing lease the INTO
statement.
SELECT
SUBSTRING([name], 1, CHARINDEX(' ', [name])) AS lastname,
SUBSTRING([name], CHARINDEX(' ',[name])+1,LEN([name])) as firstname ,
street,street2,city,state,[zip code] as zip
FROM master
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196348
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: Pro/Con Moving from MSSQL to MySQL
One is the obvious question of, have you thought of PostgreSQL? It is much more feature rich than MySQL and is now also a native Windows app with version 8 (previously it wasn't, at least as standard). -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h Oh sweet... The last time I looked it seemed like their windows port was way off in the distance, like dreams of taking a shuttle-ride to Mars for vacation. I've just never really got the time or the money to set up a 2nd machine at home (yes, I know about vpc) to try and test with PostgreSQL but now that the windows port is available, I'll probably see about testing the onTap framework with it like I wanted to a while back. It already supports MS SQL, MySQL, Oracle and MS Access. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com ~| 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:196347 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: Pro/Con Moving from MSSQL to MySQL
Jochem van Dieten wrote: Damien McKenna wrote: One is the obvious question of, have you thought of PostgreSQL? It is much more feature rich than MySQL and is now also a native Windows app with version 8 (previously it wasn't, at least as standard). Hey, you stole my line! There are a number of other alternatives to consider, just in the free Open Source arena there is Firebird, Ingress, Derby and PostgreSQL (and then I am skipping a few off the less prevalent ones). All have their pro's and cons, but personally I like PostgreSQL a lot. Like Damien said it is much more feature rich then MySQL, and you can use that to make a migration easier. For instance, instead of replacing the MS getDate() idiosyncracy with the MySQL Now() idiosyncracy in all of your CF code, you can just leave your CF code alone and define a getDate() function in PostgreSQL that returns the current timestamp. One function, instead of all your CF code. Jochem I'm going to have to agree completely here. Vivio has had a lot of experience converting MS SQL server databases to PostgreSQL databases - and we have nothing but good things to say about PostgreSQL. If you don't want to use MySQL because it doesn't have the advanced SQL features you want, then note that PostgreSQL does. If you don't want to use MySQL because of it's slightly restrictive license, then note that PostgreSQL is released under the BSD license - which means you can pretty much do whatever you want to with it just as long as you keep the copyrights in tact. (Edit it, resell it, include it in your apps, etc etc etc.) PostgreSQL is *awesome* and it's the first database I'd recommend to MS SQL database users as a cost-effective, efficient, and cross-platform alternative. -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| 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:196350 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: Pro/Con Moving from MSSQL to MySQL
Keith Gaughan wrote: Adkins, Randy wrote: Another point to consider is in MySQL you can not use A default date field to be auto-populated as you can in MS-SQL using the NOW() function. I had to modify my code to accommodate that function. But for the most part I rather enjoy MySQL. But OTOH, there's the incredibly useful LAST_INSERT_ID() function. K. PostgreSQL has a rather nifty Serial datatype, which is functionally the same as AutoNumber. ;) /shameless postgresql plug -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196351 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: Pro/Con Moving from MSSQL to MySQL
I used the windows version of PostgreSQL on a pretty big project last year. The deployment was on *nix, but I was developing on Windows. The only gotcha I ran into was that the pid file sometimes got left behind if PostgreSQL terminated unexpectedly. That resulted in me not being able to start the PostgreSQL service. The first couple of times that happened I ended up reinstalling PostgreSQL, but the third time I decide to find out exactly what was causing the issue. From what I remember the file is postmaster.pid and is in the data sub-directory of the postgreSQL install. Deleting the file solves the problem. I'm not sure if that issue is fixed in the latest release of the windows install, but I thought I'd save you the pain if it isn't ;) Spike S. Isaac Dealey wrote: One is the obvious question of, have you thought of PostgreSQL? It is much more feature rich than MySQL and is now also a native Windows app with version 8 (previously it wasn't, at least as standard). -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h Oh sweet... The last time I looked it seemed like their windows port was way off in the distance, like dreams of taking a shuttle-ride to Mars for vacation. I've just never really got the time or the money to set up a 2nd machine at home (yes, I know about vpc) to try and test with PostgreSQL but now that the windows port is available, I'll probably see about testing the onTap framework with it like I wanted to a while back. It already supports MS SQL, MySQL, Oracle and MS Access. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com ~| 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:196352 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
Trying to optimize some code
Hi all, I have an include for a dynamic side menu and there is a lot of data in the menus. There is 3 level of menus and hte guy who programmed it made loops inside of loops with different queries. I'm looking for a way to optimize this since it's taking 1000 ms to load. I looked at the cache options but it's not really an option since the color of the menu change from a variable in the url. The code looks somthing like this : query menu loop over menu query submenu for this menu if there is submenu loop over sub menu query subsubmenu for this submenu if there is subsubmenu loop over subsubmenu Any ideas? Thanks Pat ~| 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:196353 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: Trying to optimize some code
I'd try and cache the menu, and use to URL var to specify a different stylesheet for the colors. -Adam On Thu, 24 Feb 2005 12:45:54 -0500, CFDEV [EMAIL PROTECTED] wrote: Hi all, I have an include for a dynamic side menu and there is a lot of data in the menus. There is 3 level of menus and hte guy who programmed it made loops inside of loops with different queries. I'm looking for a way to optimize this since it's taking 1000 ms to load. I looked at the cache options but it's not really an option since the color of the menu change from a variable in the url. The code looks somthing like this : query menu loop over menu query submenu for this menu if there is submenu loop over sub menu query subsubmenu for this submenu if there is subsubmenu loop over subsubmenu Any ideas? Thanks Pat ~| 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:196354 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-SQL matching
thanks ~| 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:196355 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
mySQL to PostGreSQL on Windows (was Pro/Con Moving from MSSQL to MySQL)
A week or so ago I peeked at the PostGreSQL web site and looked over their Windows port. All of the Experimental and total rewrite and not fully tested messages convinced me to keep waiting, as my needs are for full production. But from the sound of it some of you out there have bitten the bullet, so I ask: What are the quirks in PostGreSQL insofar as what you write for your cfquery statements? Field type idiosyncracies? Whats its memory footprint like compared to other platforms? Whats it take to get PostGresSQL into CF 6.1 (and I assume 7) as a jdbc resource? Looked at CF's odbc xml config files a few seeks back when I config'd a SeeFusion trial. Looks like there are hooks in there for PostGres already. I use mySQL primarily in production, although I have clients using MS SQL and work in it a fair bit every day. The code I write has to *always* port interchangeably between these two platforms, as well as Access and Oracle, so I don't get fancy with *any* platform's functions. Just SQL propped up with CF if I need it. What I'm doing is exploring a)whether I can support the platform at this stage without reinventing the wheel and b) whether I can move to it myself for my own hosting needs. Cheers, -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196356 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: Trying to optimize some code
CFDEV wrote: I have an include for a dynamic side menu and there is a lot of data in the menus. There is 3 level of menus and hte guy who programmed it made loops inside of loops with different queries. I'm looking for a way to optimize this since it's taking 1000 ms to load. I looked at the cache options but it's not really an option since the color of the menu change from a variable in the url. The color is something you could put in a stylesheet. Then the query and the HTML for the menu is the same all the time, you just include a few lines of different CSS with each page. query menu loop over menu query submenu for this menu if there is submenu loop over sub menu query subsubmenu for this submenu if there is subsubmenu loop over subsubmenu This looks like something you could do in one query using outer joins. Jochem ~| 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:196358 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: Pro/Con Moving from MSSQL to MySQL
Jochem van Dieten wrote: free Open Source arena there is Firebird, Ingress, Derby and derby? well lets see what hani has to say about it: http://www.jroller.com/page/fate/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196357 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: Trying to optimize some code
Well the color is to highlight the menu for which page we are in at the moment and this is determined by a url variable... Pat -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: February 24, 2005 13:07 To: CF-Talk Subject: Re: Trying to optimize some code CFDEV wrote: I have an include for a dynamic side menu and there is a lot of data in the menus. There is 3 level of menus and hte guy who programmed it made loops inside of loops with different queries. I'm looking for a way to optimize this since it's taking 1000 ms to load. I looked at the cache options but it's not really an option since the color of the menu change from a variable in the url. The color is something you could put in a stylesheet. Then the query and the HTML for the menu is the same all the time, you just include a few lines of different CSS with each page. query menu loop over menu query submenu for this menu if there is submenu loop over sub menu query subsubmenu for this submenu if there is subsubmenu loop over subsubmenu This looks like something you could do in one query using outer joins. Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196359 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: Trying to optimize some code
Any ideas? I use only one query, one loop on the query with grouping, and a recursive Custom Tag. Pretty fast indeed, but not really trivial. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196360 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: jrun.dll on J2EE
The file version of my jrun.dll is 4.0.3.19147. It's not working for .cfm files (.jsp files seem OK) on IIS5.1/JRun4/CFMX7. Can anyone tell me if this is the correct version for CF7? I guess maybe not, since it was created by the wsconfig tool which is part of JRun4 which pre-dates CF7. If not, where in the CF7 J2EE download - or elsewhere - can I find the new one? Judging from the info Steven Erat sent Mike Kear, the dlls have not changed so I don't understand why JRun can't handle CFM requests from IIS. I'm going to repeat my original post on this with a few extra details in case anyone knows (Steven?) : IIS 5.1 on Windows XP Pro. CF running in J2EE mode on top of JRun4. Befor installing CF7 I decided to re-install JRun. That went fine. I downloaded the J2EE version of CF 7 installed the cfusion server in JRun. That's also fine. I can run CF apps and JSPs/servlets via the JRun web server with no problem. Also, IIS is serving HTML, ASP and Perl with no problems. Now, to connect CF up to IIS. I ran the JRun Web Server Config Tool and connected the cfusion server to the web site in IIS. I see in IIS that the JRunScripts virtual dir has been created and the jrun.dll has appeared, and the mappings for jsp, cfm, cfc etc have been created. Now when I hit a .jsp page that's located under wwwroot, it works. So IIS is obviously managing to hold *some* kind of conversation with the cfusion server via jrun.dll. However, when I try to hit a .cfm page that's located under wwwroot I get Cannot find server or DNS error. Or sometimes, it just hangs. Why would JSPs work but CFMs not? My wsconfig log file looks like this 2005-02-23 14:31:34 jrISAPI[init:1220] JRun 4.0 (Build 84683) JRun ISAPI Extension - Sep 2 2004 07:21:07 2005-02-23 14:31:34 jrISAPI[init:1220] JRun ISAPI Extension DLL Attaching 2005-02-23 14:31:34 jrISAPI[init:1220] JRun 4.0 (Build 84683) JRun ISAPI Filter - Sep 2 2004 07:21:09 2005-02-23 14:31:35 jrISAPI[init:1220] JRun ISAPI Extension DLL Detaching (FreeLibrary) 2005-02-23 14:31:39 jrISAPI[init:1220] JRun 4.0 (Build 84683) JRun ISAPI Extension - Sep 2 2004 07:21:07 2005-02-23 14:31:39 jrISAPI[init:1220] JRun ISAPI Extension DLL Attaching 2005-02-23 14:31:39 jrISAPI[init:1220] JRun 4.0 (Build 84683) JRun ISAPI Filter - Sep 2 2004 07:21:09 2005-02-23 14:33:51 jrISAPI[filter:1220] jrSend failed[2216]: 10054 Connection reset by peer 2005-02-23 14:42:08 jrISAPI[filter:1220] jrSend failed[2216]: 10054 Connection reset by peer 2005-02-23 14:57:54 jrISAPI[filter:1220] jrRecv failed[2216]: 10053 Connection aborted My jrun.ini file looks like this verbose=false scriptpath=/JRunScripts/jrun.dll serverstore=C:/JRun4/lib/wsconfig/2/jrunserver.store bootstrap=127.0.0.1:51002 apialloc=false ssl=false ignoresuffixmap=true #errorurl=optionally redirect to this URL on errors #proxyretryinterval=number of seconds to wait before trying to reconnect to unreachable clustered server #connecttimeout=number of seconds to wait on a socket connect to a jrun server #recvtimeout=number of seconds to wait on a socket receive to a jrun server #sendtimeout=number of seconds to wait on a socket send to a jrun server 51002 is the correct proxy port for the cfusion server. My wsconfig.properties file is: #JRun/ColdFusion MX Web Server Configuration File #Wed Feb 23 14:31:34 GMT 2005 2=IIS,1,true, 2.srv=localhost,cfusion 2.cfmx=true,null My jrunserver.store file just contains proxyservers= Any ideas? Thanks Nick ~| 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:196361 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: cfinput question...
No, I did find that this is only the case when the form type is flash. I think it a bug. - Charles On 2/24/05 4:20 AM, Adrian Lynch [EMAIL PROTECTED] wrote: Did you get anywhere with this? Ade -Original Message- From: Charles Heizer [mailto:[EMAIL PROTECTED] Sent: 24 February 2005 00:52 To: CF-Talk Subject: cfinput question... Hello, I'm trying to use the cfinput tag with a type of checkbox. The issue I'm having is that it won't let me use the same name more than once. Example --- cfinput type=Checkbox name=ZSTOP0001 label=Win 2000 value=WIN2K checked=#vCheckWIN2KOpt# cfinput type=Checkbox name=ZSTOP0001 label=Win XP value=WINXP checked=#vCheckWINXPOpt# Now, if I use this code my flash form will not come up, but if I use a regular input tag it works fine. Can someone tell me if this is not allowed or if I¹m doing something wrong? Thanks, - Charles PS: I¹m using CFMX 7 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 22/02/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196362 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: Trying to optimize some code
CFDEV wrote:
Well the color is to highlight the menu for which page we are in at the
moment and this is determined by a url variable...
That is no problem. Consider the folowing menu:
cfoutput
style type=text/css
ul.menu li.#url.page# {background-color: navy;}
/style
/cfoutput
ul id=menu
li id=homea href=/Home/li
li id=productsa href=/Products/li
li id=servicesa href=/Services/li
li id=contacta href=/Contact/li
/ul
The menu is still the same, all you change is which item is
highlighted.
Jochem
~|
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:196363
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: cfinput question...
I need to allow the user to select multiple items. - Charles On 2/24/05 3:25 AM, Tarantor [EMAIL PROTECTED] wrote: Why don't you try radio button instead of checkbox? ~ Hello, I'm trying to use the cfinput tag with a type of checkbox. The issue I'm having is that it won't let me use the same name more than once. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196364 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: guide to upgrading 6.1 to 7
Bert said: I'm looking for a guide to upgrading from 6.1 to 7 on the MM site and coming up with nothing. Does anyone know if such a thing exists? Cheers You mean something like this? http://download.macromedia.com/pub/documentation/en/coldfusion/mx7/cfmx7_mig rating.pdf George [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196365 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
CFDocument
Ok, I am trying to do something that I would think would be very easy. And I
guess I am just a little slow today, but I figure out how i would do this.
I have query of scores and employee names. I would like to have a header and
footer and the body looped over per dept. I also have column headings that I
would like at the top of each page. I also would like for the page break to
the next page without placing the header on the second page, but place the
column headings on the second/third pages on so on. When a new department is
looped over place the header and column headings and loop over the dept data.
With a footer on each page.
Here is the code:
cfdocument format=pdf overwrite=Yes pagetype=letter
orientation=portrait unit=in encryption=none fontembed=Yes
backgroundvisible=No
CFOUTPUT query=SelectEmployees
cfdocumentsection margintop=.01
cfdocumentitem type=header
TABLE width=100% border=0 cellspacing=0 cellpadding=0
TR align=center
TD colspan=5nbsp;/TD
/TR
TR align=center
TD colspan=5STRONGDIV align=center#TestName#/DIV/STRONG/TD
/TR
TR align=center
TD colspan=5STRONGDIV align=center#Form.ReportType#
Report/DIV/STRONG/TD
/TR
TR align=center
TD colspan=5DIV
align=center#DateFormat(NOW(),mm/dd/)#/DIV/TD
/TR
TR
TD colspan=5STRONGEntity:/STRONG
#SelectEmployees.EntityName#/TD
/TR
TR
TD colspan=5STRONGDEPT##/STRONG #SelectEmployees.DeptNumber# -
#SelectEmployees.DeptName#/TD
/TR
/cfdocumentitem
cfdocumentitem type=footer
cfoutputdiv align=rightPage #cfdocument.currentpagenumber# of
#cfdocument.totalpagecount#/div/cfoutput
/cfdocumentitem
TR
TDBHire Date/B/TD
TDBEmployee:/B/TD
TDBName/B/TD
TDcfif Form.ReportType EQ Passed OR Form.ReportType EQ
Acknowledgements PassedBClass Date/Bcfelsenbsp;/cfif/TD
TDnbsp;/TD
/TR
CFSET Request.TotalNumberEmp = Request.TotalNumberEmp +1
TR bgcolor=###IIF(SelectEmployees.CURRENTROW MOD 2, DE ('FF'), DE
('F1F0E4'))#
TD#DateFormat(HireDate,mm/dd/)#/TD
TD#EmployeeID#/TD
TD#EMP_FNAME# #EMP_LNAME#/TD
TDcfif Form.ReportType EQ Passed OR Form.ReportType EQ
Acknowledgements
Passed#DateFormat(DateTaken,mm/dd/)#cfelsenbsp;/cfif/TD
TDnbsp;/TD
/TR
/TABLE
/cfdocumentsection
/CFOUTPUT
/cfdocument
This does not seem to work at all and not even very close.
Any help would be great.
~|
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:196366
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: cfinput question...
On Wed, 23 Feb 2005 16:52:26 -0800, Charles Heizer [EMAIL PROTECTED] wrote: I'm trying to use the cfinput tag with a type of checkbox. The issue I'm having is that it won't let me use the same name more than once. That's correct. Each field must have a unique name. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 48, yes 48, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196367 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
bugs URL
Hi, Does anyone know the URL of listing of all the known bugs in ColdFusion MX. -- Umer Farooq Octadyne Systems +1 (519) 489-1119 voice +1 (519) 635-2795 mobile +1 (530) 326-3586 fax WEB SOLUTIONS FOR NON-PROFIT ORGANIZATION: http://www.Non-ProfitSites.biz WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| 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:196368 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: Pro/Con Moving from MSSQL to MySQL
ah. Sterile and dispassionate. This guy needs to learn how to express himself. :D -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196369 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: cfinput question...
Do you know why that is, since a regular input checkbox field does not have to be unique it's only when I use the format type as flash? Thanks, - Charles On 2/24/05 10:42 AM, Sean Corfield [EMAIL PROTECTED] wrote: On Wed, 23 Feb 2005 16:52:26 -0800, Charles Heizer [EMAIL PROTECTED] wrote: I'm trying to use the cfinput tag with a type of checkbox. The issue I'm having is that it won't let me use the same name more than once. That's correct. Each field must have a unique name. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196370 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: serialize cfc
(If you're annoyed by BlueDragon product plugs please stop reading now). If serialization of CFCs is critical for you, this feature is supported by BlueDragon 6.1, and the soon-to-be-released BlueDragon 6.2. This means that with BlueDragon you can: - Put CFCs into the J2EE Session scope and have them automatically replicated across a cluster of J2EE servers. - Put CFCs into the Client scope. (In fact, unlike CFMX, BlueDragon allows you to put *any* complex CFML variable into the Client scope without resorting to WDDX). http://www.newatlanta.com/products/bluedragon/index.cfm Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Thursday, February 24, 2005 8:42 AM To: CF-Talk Subject: Re: serialize cfc Wow, that's a pretty sad oversight on the part of Macromedia. Basically, if you use any session-based CFCs you are forced to use sticky sessions. And even that doesn't help at all for failover. They added a lot of nice stuff in 7.0, but they also dropped the ball on several things and this is one of them. On Wed, 23 Feb 2005 21:17:01 -0800, Barney Boisvert [EMAIL PROTECTED] wrote: CF7, like CF6, only supports session replication for non-CFC data. CFCs will not replicate. http://livedocs.macromedia.com/coldfusion/7/htmldocs/1774.htm Check point 17. Session vars can replicate, but CFC's can't. It's worded in a very poor way, but i'm guessing session vars is assumed to only include non-object data. cheers, barneyb On Wed, 23 Feb 2005 21:07:34 -0500, Brian Kotek [EMAIL PROTECTED] wrote: Barney I haven't tried it, but are you saying that CFMX7 does *not* allow for replication of session-scoped CFC instances? Or are you saying that it does? Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196371 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: cfinput question...
Well Flash has a Client-side state where as HTML doesn't. HTML simple aggregates all inputs with the same name when its submitted. Flash already knows they are different controls and since you can bind data to a specific checkbox then they would have to be enforced as unique. Brendan Charles Heizer wrote: Do you know why that is, since a regular input checkbox field does not have to be unique it's only when I use the format type as flash? Thanks, - Charles On 2/24/05 10:42 AM, Sean Corfield [EMAIL PROTECTED] wrote: On Wed, 23 Feb 2005 16:52:26 -0800, Charles Heizer [EMAIL PROTECTED] wrote: I'm trying to use the cfinput tag with a type of checkbox. The issue I'm having is that it won't let me use the same name more than once. That's correct. Each field must have a unique name. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196372 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: Reason to *not* store lots of data in Application scope?
I've found static publishing to a .html file to be a real boon insofar as resources are concerned. Cuts CF and the db clean out of the picture, although as has been said this does nothing for disk i/o. This can create problems, though, if you need to keep users' sessions alive, since they are not hitting .cfm pages anymore. I more or less bandaged this over by publishing to static .cfm pages. i.e. totally static .html content still, but with the .cfm extension to keep CF in the picture at least a little. Solved the problem but I was never happy with doing it. The real bear is creating a seamless publishing mechanism so non-tech users don't know they are creating static content in the first place. Once thats done its pretty smooth sailing. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| 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:196373 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: Reason to *not* store lots of data in Application scope?
I'd be less worried about the speed of serving or ram usage as I would how long the X minutes between reloads is. Re-grabbing several MB of data from a database is going to make your site speed crawl while it happens, not to mention you'd need to carefully cflock the application scope writes to ensure your content was coherent - so it'd all be single-threaded as well. Overall I agree with the people who are suggesting static publishing, since a static HTML page is probably as fast as a cf page coming out of the application scope. As a hybrid solution, or if securing pages is needed, consider publishing the static pages outside the web root and using a CF page and getPageContext().include() - which doesn't have CF parse the include if it's a static type (iirc). Kam -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 23, 2005 1:58 PM To: CF-Talk Subject: Reason to *not* store lots of data in Application scope? I'm working on a rewrite of the events/news schedule for our company's website and was thinking of storing all of the data in the Application scope to be reloaded every X minutes. My question is whether it would be bad from a scaling or resource usage point-of-view to do this? I would probably be storing a few megabytes of data, not a huge amount IMHO. Thanks. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196374 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: bugs URL
There isn't one. MM keeps that private. However, if you have specific questions, they're usually pretty good about sharing relevant info. cheers, barneyb On Thu, 24 Feb 2005 13:45:24 -0500, Umer Farooq [EMAIL PROTECTED] wrote: Hi, Does anyone know the URL of listing of all the known bugs in ColdFusion MX. -- Umer Farooq Octadyne Systems +1 (519) 489-1119 voice +1 (519) 635-2795 mobile +1 (530) 326-3586 fax -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| 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:196375 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: Pro/Con Moving from MSSQL to MySQL
Paul Hastings wrote: Jochem van Dieten wrote: free Open Source arena there is Firebird, Ingress, Derby and derby? well lets see what hani has to say about it: http://www.jroller.com/page/fate/ The line about it being 01:30 probably explains most :-) But for some serious research into the good and bad of Java based databases: http://citeseer.ist.psu.edu/shah01java.html Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196376 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: bugs URL
On Thu, 24 Feb 2005 13:45:24 -0500, Umer Farooq [EMAIL PROTECTED] wrote: Hi, Does anyone know the URL of listing of all the known bugs in ColdFusion MX. There isn't one in the sense that there's no searchable bug base. I *think* there's a Known Issues document somewhere on Macromedia's site, but a quick search only yields documents that haven't been updated in 2 years. Regards, Dave. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196377 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
