RE: cfinput question...

2005-02-24 Thread Adrian Lynch
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

RE: cfinput question...

2005-02-24 Thread Tarantor
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.

cfscheduler and javascript

2005-02-24 Thread Kristen Winsor
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

RE: cfscheduler and javascript

2005-02-24 Thread Robertson-Ravo, Neil (RX)
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

guide to upgrading 6.1 to 7

2005-02-24 Thread Bert Dawson
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

Re: serialize cfc

2005-02-24 Thread Brian Kotek
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

Re: CF7 won't run under IIS, wont install - business almost shut down for 2 days now.

2005-02-24 Thread Peter Farrell
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

RE: CF7 won't run under IIS, wont install - business almost shut down for 2 days now.

2005-02-24 Thread Robertson-Ravo, Neil (RX)
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 -

RE: CF7 won't run under IIS, wont install - business almost shut down for 2 days now.

2005-02-24 Thread Michael T. Tangorre
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

RE: Reason to *not* store lots of data in Application scope?

2005-02-24 Thread Bryan F. Hogan
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

CFInclude

2005-02-24 Thread Mark Leder
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

RE: OT-SQL matching

2005-02-24 Thread Eric Creese
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

OT: IIS Users and Groups.

2005-02-24 Thread Che Vilnonis
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

Re: CFInclude

2005-02-24 Thread John Beynon
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

Re: cfif eq varchar issue in MX

2005-02-24 Thread Claude Schneegans
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

Re: THIS scope

2005-02-24 Thread S . Isaac Dealey
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

Re: THIS scope

2005-02-24 Thread S . Isaac Dealey
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

RE: LDAP question

2005-02-24 Thread Dawson, Michael
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.

Re: Reason to *not* store lots of data in Application scope?

2005-02-24 Thread John Paul Ashenfelter
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

RE: Reason to *not* store lots of data in Application scope?

2005-02-24 Thread Bryan F. Hogan
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

Re: LDAP question

2005-02-24 Thread Victor Moore
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

RE: OT-SQL matching

2005-02-24 Thread Eric Creese
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

RE: LDAP question

2005-02-24 Thread Dawson, Michael
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,

RE: LDAP question

2005-02-24 Thread Dawson, Michael
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]

RE: OT-SQL matching

2005-02-24 Thread Adrian Lynch
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

Re: SPAM: RE: SPAM: RE: A Little OT

2005-02-24 Thread Bryan Stevenson
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.

RE: OT-SQL matching

2005-02-24 Thread Adrian Lynch
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

RE: OT-SQL matching

2005-02-24 Thread Eric Creese
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

Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Mark W. Breneman
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

Re: Reason to *not* store lots of data in Application scope?

2005-02-24 Thread John Paul Ashenfelter
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Jochem van Dieten
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread toru okada
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread John Paul Ashenfelter
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

RE: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Mark W. Breneman
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

RE: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Adkins, Randy
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

RE: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Robertson-Ravo, Neil (RX)
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

RE: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Robertson-Ravo, Neil (RX)
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Jochem van Dieten
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Spike
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

Re: CF7 won't run under IIS, wont install - business almost shut down for 2 days now.

2005-02-24 Thread Peter Farrell
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 -

RE: Reason to *not* store lots of data in Application scope?

2005-02-24 Thread Bryan F. Hogan
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

RE: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Mark W. Breneman
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

RE: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Adkins, Randy
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

RE: OT-SQL matching

2005-02-24 Thread Adrian Lynch
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread John Paul Ashenfelter
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

RE: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Robertson-Ravo, Neil (RX)
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

RE: OT-SQL matching

2005-02-24 Thread Eric Creese
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

RE: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Damien McKenna
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 -

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Jochem van Dieten
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

Re: THIS scope

2005-02-24 Thread Isaac Dealey
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread John Paul Ashenfelter
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread John Paul Ashenfelter
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

Re: Reason to *not* store lots of data in Application scope?

2005-02-24 Thread John Paul Ashenfelter
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,

Re: CF-Talk: Digest every 6 hours

2005-02-24 Thread Bryon Kelly
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Spike
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

RE: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread S . Isaac Dealey
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread S . Isaac Dealey
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Jochem van Dieten
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread S . Isaac Dealey
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread toru okada
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread S . Isaac Dealey
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

Re: OT-SQL matching

2005-02-24 Thread Qasim Rasheed
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread toru okada
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread S . Isaac Dealey
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

Re: CF7 won't run under IIS, wont install - business almost shut down for 2 days now.

2005-02-24 Thread Peter Farrell
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Keith Gaughan
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Keith Gaughan
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Spike
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

Re: serialize cfc

2005-02-24 Thread Barney Boisvert
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Jochem van Dieten
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

RE: OT-SQL matching

2005-02-24 Thread Eric Creese
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

RE: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread S . Isaac Dealey
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 -

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Jordan Michaels
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Jordan Michaels
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.

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Spike
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

Trying to optimize some code

2005-02-24 Thread CFDEV
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

Re: Trying to optimize some code

2005-02-24 Thread Adrocknaphobia
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

RE: OT-SQL matching

2005-02-24 Thread Eric Creese
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:

mySQL to PostGreSQL on Windows (was Pro/Con Moving from MSSQL to MySQL)

2005-02-24 Thread Matt Robertson
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

Re: Trying to optimize some code

2005-02-24 Thread Jochem van Dieten
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Paul Hastings
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

RE: Trying to optimize some code

2005-02-24 Thread CFDEV
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

Re: Trying to optimize some code

2005-02-24 Thread Claude Schneegans
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

Re: jrun.dll on J2EE

2005-02-24 Thread Nick de Voil
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,

Re: cfinput question...

2005-02-24 Thread Charles Heizer
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

Re: Trying to optimize some code

2005-02-24 Thread Jochem van Dieten
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

Re: cfinput question...

2005-02-24 Thread Charles Heizer
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

RE: guide to upgrading 6.1 to 7

2005-02-24 Thread Earl, George
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

CFDocument

2005-02-24 Thread David Brown
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

Re: cfinput question...

2005-02-24 Thread Sean Corfield
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 --

bugs URL

2005-02-24 Thread Umer Farooq
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:

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Matt Robertson
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

Re: cfinput question...

2005-02-24 Thread Charles Heizer
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:

RE: serialize cfc

2005-02-24 Thread Vince Bonfanti
(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

Re: cfinput question...

2005-02-24 Thread Brendan OHara
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

Re: Reason to *not* store lots of data in Application scope?

2005-02-24 Thread Matt Robertson
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

RE: Reason to *not* store lots of data in Application scope?

2005-02-24 Thread Figy, Kam
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

Re: bugs URL

2005-02-24 Thread Barney Boisvert
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

Re: Pro/Con Moving from MSSQL to MySQL

2005-02-24 Thread Jochem van Dieten
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

Re: bugs URL

2005-02-24 Thread Dave Carabetta
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

  1   2   3   >