Re: advice need on multi-version data model design
Nick Han said: I am more interested in database design help.What I am thinking right now is right after the deadline, before the reviewer making changes, I dup the db schema and back that up, and the current schema will have the current data, including changes made by the reviewer. If there is dispute and I need to compare original version and edited version, I can toggle my variable that has the schema name? I think there is a better way: never update records :-) Instead of updating, insert a new record and timestamp it. If you just show the latest version as the working version in the frontend nobody knows the difference, but you can track all revisions in the background if you want to. (This is the same solution as Barney proposed, but with a slightly different angle on the explanation.) Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Tree (driving me nuts)
All right I am having serious problems trying to get my head around this one, I have made a CFC that traverses through the directory structure and returns a query with the whole directory structure underneath the parent it was given. Then I have made a CFC that is to work with this query and visually recreate the directory structure with HTML ul and li I am almost there, but there is a problem somewhere, which I can't pinpoint. It recreates the directory structure fine as long as the structure is going up once it goes down there is a problem somewhere. Code to run for testing (if anyone is interested in getting this working) cfscript directory = createObject(component, /openAMS_development/frameWork/component/directory); tree = createObject(component, /openAMS_development/frameWork/component/tree); qDirectory = directory.traverse( 'D:\Inetpub\wwwroot\internet\development\openams.com\index\' ); /cfscript cfquery name=q dbtype=query SELECT * FROM qDirectory WHERE [type] = 'Dir' /cfquery cfset myTree = tree.html(q, nothingyet, nothingyet, nothingyet) cfoutput#myTree#/cfoutput directory.cfc * cfcomponentcfsilent cffunction access=public name=create output=false cfargument name=path type=string required=true !--- Remove the trailing slash, if any --- cfif right(arguments.path, 1) IS / cfset arguments.path = mid(arguments.path, 1, len(arguments.path) - 1) /cfif !--- Get the parent path to see if it exists --- cfset pathParent = listDeleteAt(arguments.path, listLen(arguments.path, \), \) cfif directoryExists(pathParent) !--- Make sure the directory does not already exist --- cfif NOT directoryExists(arguments.path) cfdirectory directory=#arguments.path# action=""> cfelse !--- Return message specifying the directory already exists --- /cfif cfelse !--- Return message specifying that the parent directory does not exist --- /cfif /cffunction cffunction access=public name=traverse output=true returntype=query hint=I traverse through the path I am provided with. cfargument name=path type=string required=true default= hint=Fully qualified path to the directory cfargument name=q type=query required=true default=#queryNew(path,level,name,size,type,dateLastModified,attributes,mo de)# cfargument name=i type=numeric required=true default=1 !--- Remove trailing slash if any --- cfscript if ( right(arguments.path, 1) IS \ ) { arguments.path = mid(arguments.path, 1, len(arguments.path) - 1); } if ( arguments.i EQ 1 ) { queryAddRow(q, 1); querySetCell(q, path, listDeleteAt(arguments.path, listLen(arguments.path, \), \)); querySetCell(q, level, 0); querySetCell(q, name, listLast(arguments.path, \)); querySetCell(q, size, 0); querySetCell(q, type, Dir); // got an issue with this date for some reason, need to fix it evaluate(qList i .dateLastModified) querySetCell(q, dateLastModified, ); querySetCell(q, attributes, ); querySetCell(q, mode, ); } /cfscript !--- Retrieve contents of the directory --- cfdirectory directory=#arguments.path# action="" name=qList#i# cfif evaluate(qList i .recordCount) cfloop query=qList#i# cfscript queryAddRow(q, 1); querySetCell(q, path, arguments.path); querySetCell(q, level, i); querySetCell(q, name, evaluate(qList i .name)); querySetCell(q, size, evaluate(qList i .size)); querySetCell(q, type, evaluate(qList i .type)); // got an issue with this date for some reason, need to fix it evaluate(qList i .dateLastModified) querySetCell(q, dateLastModified, ); querySetCell(q, attributes, evaluate(qList i .attributes)); querySetCell(q, mode, evaluate(qList i .mode)); // Only traverse if it is a directory if ( evaluate(qList i .type) IS dir ) { directoryName = evaluate(qList i .name); traverse( arguments.path \ directoryName, arguments.q, i + 1 ); } /cfscript /cfloop /cfif !--- Return the query --- cfreturn q /cffunction /cfsilent/cfcomponent * tree.cfc * cfcomponentcfsilent cffunction access=public name=html output=false returntype=string cfargument name=q type=query required=true cfargument name=display type=string required=true cfargument name=value type=string required=true cfargument name=link type=string required=true cfargument name=previousLevel type=numeric required=true default=1 cfset var string = cfloop query=q cfset string = string createList(arguments.previousLevel, q.level, val(q.level[q.currentRow + 1]), q.name, nothing) cfset arguments.previousLevel = q.level /cfloop cfset string = string /ul cfreturn string /cffunction cffunction access=private name=createList output=false returntype=string cfargument name=previousLevel type=numeric required=true cfargument name=currentLevel type=numeric required=true cfargument name=nextLevel type=numeric required=true cfargument name=value type=string required=true cfargument name=link type=string
RE: Softball/Baseball db app? (Maybe OT)
I created built one of these for my graduate project.Contact me of line and I'll see if I cat find the data structure. Dwayne Cole, MS in MIS, MBA Florida AM University Certified Advanced ColdFusion Developer 850-591-0212 It can truly be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all sound and fury, signifying nothing.The Fifth Discipline - Peter Senge -- Original Message -- From: Burns, John D [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 20 Apr 2004 22:27:20 -0400 I tried doing this and ran into too many variables and it wasn't worth my time so I scrapped it.There are some free sites out there that do some of it (scheduling, wins/losses, etc) and there are some cheap desktop (and even PDA) programs that do it as well.I'm not sure if you'd be able to access the DB to display the info on the web, but just search around and you may get lucky.If you find something nice, please share. John Burns From: Chris Terrebonne [mailto:[EMAIL PROTECTED] Sent: Tue 4/20/2004 11:28 AM To: CF-Talk Subject: Softball/Baseball db app? (Maybe OT) Morning Everyone, I was thinking of putting together a db app that tracks the team information and game schedule/results for my daughter's softball team.Before I started hacking this out, I wanted to see if there was anything pre-rolled for this purpose.Anyone done this before? Thanks in advance, and my apologies if this is OT. Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Locking Records!
Hell Everybody, I really need someone's help. I'm working on a cf application with a sql backend. This is an IT Logs database system. I am working on the front end for the support desk. A support desk user can view a log, add a new log or update a log. My query is specific to viewing and updating a log. The log information is pulled from the logs table. Now then, a user can associate one or more assets to a log. The asset information is in the asset table. The asset info pop-up window pops up when the user hits on the 'asset' button from the view logs page. This is how the tables are linked. Each log has a unique log_id. Each asset has a unique asset_id. This asset_id is stored in the log table in the asset_id column. If a user changes the asset information for a particular asset, all logs that are associated with this asset display the modified asset information. Is it possible to lock a record, so that another user can not edit delete this until you are finished with it. He should however be allowed to view the record. Can somebody please suggest different ways to go about doing this? Some sample code would also be helpful Best regards, cfcoder __ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Locking Records!
just add another column to the table, call it locked of type BIT and 1 is locked and 0 is unlocked Taco Fleur Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Wednesday, 21 April 2004 9:18 PM To: CF-Talk Subject: Locking Records! Hell Everybody, I really need someone's help. I'm working on a cf application with a sql backend. This is an IT Logs database system. I am working on the front end for the support desk. A support desk user can view a log, add a new log or update a log. My query is specific to viewing and updating a log. The log information is pulled from the logs table. Now then, a user can associate one or more assets to a log. The asset information is in the asset table. The asset info pop-up window pops up when the user hits on the 'asset' button from the view logs page. This is how the tables are linked. Each log has a unique log_id. Each asset has a unique asset_id. This asset_id is stored in the log table in the asset_id column. If a user changes the asset information for a particular asset, all logs that are associated with this asset display the modified asset information. Is it possible to lock a record, so that another user can not edit delete this until you are finished with it. He should however be allowed to view the record. Can somebody please suggest different ways to go about doing this? Some sample code would also be helpful Best regards, cfcoder __ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Locking Records!
another method I seen on the list better to use some sort of username rather than just a bit column to indicate a lock... also a timestamp that the record was last modified then you can do a scan every twenty minutes and if it has not been updated in 20 minutes you can assume that the user is no longer looking at the record and you can unlock it for others to use [ also let's you inform your user's who has actually locked the record ] -- David -Original Message- From: Taco Fleur Sent: 21 April 2004 12:29 To: CF-Talk Subject: RE: Locking Records! just add another column to the table, call it locked of type BIT and 1 is locked and 0 is unlocked Taco Fleur Tell me and I will forget Show me and I will remember Teach me and I will learn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Locking Records!
thanks for your tips. I'll try this and get back to you. just add another column to the table, call it locked of type BIT and 1 is locked and 0 is unlocked Taco Fleur Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Wednesday, 21 April 2004 9:18 PM To: CF-Talk Subject: Locking Records! Hell Everybody, I really need someone's help. I'm working on a cf application with a sql backend. This is an IT Logs database system. I am working on the front end for the support desk. A support desk user can view a log, add a new log or update a log. My query is specific to viewing and updating a log. The log information is pulled from the logs table. Now then, a user can associate one or more assets to a log. The asset information is in the asset table. The asset info pop-up window pops up when the user hits on the 'asset' button from the view logs page. This is how the tables are linked. Each log has a unique log_id. Each asset has a unique asset_id. This asset_id is stored in the log table in the asset_id column. If a user changes the asset information for a particular asset, all logs that are associated with this asset display the modified asset information. Is it possible to lock a record, so that another user can not edit delete this until you are finished with it. He should however be allowed to view the record. Can somebody please suggest different ways to go about doing this? Some sample code would also be helpful Best regards, cfcoder __ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX for sale
I work for a non-profit senior care facility that has been trying to figure out how to come up with the cost of purchasing 6.1. Donating it to us would be a great compromise, wouldn't it??? -Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SMTP
There is a post SP 4 bug that can cause IIS services to hang (including SMTP).I don't know if that's your issue but here is the KB: http://support.microsoft.com/default.aspx?scid=kb;en-us;819019 The patch is only available from MS tech support, but I found it online here. http://www.pubforum.net/postsp4.htm Be careful when you run it - there is probably a reason it's only available from tech support g. Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 5:01 PM To: CF-Talk Subject: SMTP Ok I hae a bunch of mail sitting in my Spool folder. I have bounced IIS and the SMTP server several times. These emails were originally in my Undelivered folder cause SMTP was not started when these emails should have been ran. I just ran an email off the server to another email acount using a form on one of my sites and I received it successfully. I copied all the undelivered emails and paced them in the spool folder but they are not being sent. Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX Service Packs
OK its gripe time Just about to run an upgrade on a ColdFusion 5 set of servers in a test environment and I must say that back in the days of Allaire we used to get Service Packs with nice rolled up packaged of ALL hotfixes and Security updates but now I have to trawl through the MM site to get all ELEVEN hotfix updates in Zip format and THEN goto the security site to get all of those as well.now I am going to be upgrading 3 or 4 servers here dont you think that a service pack would make this a whole lot easier... bring back Allaire Service Packs...none of this hotfix unless its critical and it can wait till another pack This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF Coding Contest Results
For those who are interested, I put together the results from the coding contest and put everyone's source code up that competed.Here is the link: http://adserver2.alfred.edu/kevin/cfcontest/index.cfm My code finished first in three of the five tests and Nathan Mische's finished first in the other two.The best display award went to Steve Nelson for his t-rex style output (IE only). I will send out another message when I put together something for the next contest in the next few weeks. Enjoy. Kevin. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX for sale
Why not go with the freely available version of BlueDragon. Then you wouldn't have to worry about cost at all. -Matt On Apr 21, 2004, at 8:36 AM, Claremont, Timothy wrote: I work for a non-profit senior care facility that has been trying to figure out how to come up with the cost of purchasing 6.1. Donating it to us would be a great compromise, wouldn't it??? -Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Coding Contest Results
My code finished first in three of the five tests and Nathan Mische's finished first in the other two.The best display award went to Steve Nelson for his t-rex style output (IE only). You won?!... What a SHAM, of course you won, you were the judge!!! j/k Steve Nelson's kicks butt.. Way cool! Now would be a good time to let everyone know about topcfcoder.com no? The site will feature CF coding contest each month with prizes and such... Just a little something fun for the coders. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX for sale
I was just about to say that. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 8:55 AM To: CF-Talk Subject: Re: CFMX for sale Why not go with the freely available version of BlueDragon. Then you wouldn't have to worry about cost at all. -Matt On Apr 21, 2004, at 8:36 AM, Claremont, Timothy wrote: I work for a non-profit senior care facility that has been trying to figure out how to come up with the cost of purchasing 6.1. Donating it to us would be a great compromise, wouldn't it??? -Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Coding Contest Results
Seems like you have FAR to much time on your hands... ;-) _ From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED] Sent: 21 April 2004 13:50 To: CF-Talk Subject: CF Coding Contest Results For those who are interested, I put together the results from the coding contest and put everyone's source code up that competed.Here is the link: http://adserver2.alfred.edu/kevin/cfcontest/index.cfm My code finished first in three of the five tests and Nathan Mische's finished first in the other two.The best display award went to Steve Nelson for his t-rex style output (IE only). I will send out another message when I put together something for the next contest in the next few weeks. Enjoy. Kevin. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX Service Packs
My rant of long standing is that Macromedia has never gotten it together with installers or updates.I know they are aware of the problem, because they continually are hearing about it. The very simplest (and cheapest) software applications as well as the majors,have one-step installers written when updates are released.I even did this for years when I was working in a DoD facility developing software and the contractor I worked for had far less resources available than a giant such as MM. We all know that Macromedia has licenses for InstallShield (the most popular) and InstallAnywhere, but we are at a loss as to why they do not utilize this to install their updates. Doug - Original Message - OK its gripe time Just about to run an upgrade on a ColdFusion 5 set of servers in a test environment and I must say that back in the days of Allaire we used to get Service Packs with nice rolled up packaged of ALL hotfixes and Security updates but now I have to trawl through the MM site to get all ELEVEN hotfix updates in Zip format and THEN goto the security site to get all of those as well.now I am going to be upgrading 3 or 4 servers here dont you think that a service pack would make this a whole lot easier... bring back Allaire Service Packs...none of this hotfix unless its critical and it can wait till another pack [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX for sale
Tim, Sounds to me like you need BlueDragon. -adam -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 12:36 PM To: 'CF-Talk' Subject: RE: CFMX for sale I work for a non-profit senior care facility that has been trying to figure out how to come up with the cost of purchasing 6.1. Donating it to us would be a great compromise, wouldn't it??? -Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX for sale
I agree with Adam.I understand the intent of NFR, but if I own something (a car, a TV, a software package) I don't see why I can't pass it on to someone else for the value they're willing to give me?If the CFUG is that bent on making sure the person they give it to canuse it, they should have a signature sheet or something that the winner has to sign saying they'll actually use it.I could understand if someone somehow got 50 NFR copies and opened a store, but if you have one and want to get rid of it, I don't see the problem.That's free enterprise right? John -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 5:37 PM To: CF-Talk Subject: Re: CFMX for sale NFR = not for _resale_ if it wasn't sold to begin with then its not being _resold_ (are you saying you've never had an illegal copy of any software?... ever?) -adam -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 09:10 PM To: 'CF-Talk' Subject: RE: CFMX for sale If its OK to violate the license agreement and sell a NFR copy, while we're at it lets hijack that busload of nuns and ransom them off.The church has plenty of money, right?Nobody gets hurt; well, really. I mean, if you can rationalize away a little illegality, why not rationalize away something bigger?Illegal is illegal, right?So why stop at the small stuff? -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX for sale
Just put it on ebay and end this thread already -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 9:39 AM To: CF-Talk Subject: RE: CFMX for sale I agree with Adam.I understand the intent of NFR, but if I own something (a car, a TV, a software package) I don't see why I can't pass it on to someone else for the value they're willing to give me? If the CFUG is that bent on making sure the person they give it to can use it, they should have a signature sheet or something that the winner has to sign saying they'll actually use it.I could understand if someone somehow got 50 NFR copies and opened a store, but if you have one and want to get rid of it, I don't see the problem.That's free enterprise right? John -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 5:37 PM To: CF-Talk Subject: Re: CFMX for sale NFR = not for _resale_ if it wasn't sold to begin with then its not being _resold_ (are you saying you've never had an illegal copy of any software?... ever?) -adam -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 09:10 PM To: 'CF-Talk' Subject: RE: CFMX for sale If its OK to violate the license agreement and sell a NFR copy, while we're at it lets hijack that busload of nuns and ransom them off.The church has plenty of money, right?Nobody gets hurt; well, really. I mean, if you can rationalize away a little illegality, why not rationalize away something bigger?Illegal is illegal, right? So why stop at the small stuff? -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Is it a bug or not a bug?
Because (20 and true) returns true, so (true and 20) should return true. Barney Boisvert wrote: If you agree that 20 is true, then you implicitly agree that 20 is a boolean value.With that, how can you argue that 20 is not a valid result from a boolean _expression_? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Users getting wrong information
Kelly, How are you using cookies to keep track of users? Are you storing token and id in assoication with session vars? If this is a session mishmatch, try turning on 'Use UUID for cftoken' through the CFIDE Under 'Settings'. This seem to do the trick for me when I've run into this problem. Speaking of which, why would you ever _not_ want to use UUIDs? Anyone? -adam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 11:23 PM To: 'CF-Talk' Subject: Users getting wrong information I have a website that people can login, take a quiz, view their status, etc...I use cookies to keep track of the users. There is one company that when people from there login, they are seeing other peoples information from that company. Does this have something to do with a proxy server being used? They are all using their own computers. Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
FCKeditor Upload/Browse
I'm working on setting up the terrific FCKeditor, and was curious if anyone had already built an image uploader and/or a image browser to go along with this editor. If so, are you willing to share? I'd hate to recode my own if one already has been done! Thanks in advance! Jake [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Sending lots of mail
I know this discussion came up before about how many emails can be sent *reliably* using cfmail in CFMX 6.1.I'm curious what the numbers are on that and then also what is out there that people would recommend for doing mail-outs that are too big for CF.I'm thinking that I want to use CF to give some Admin controls to users for formatting an email and then sending to their list.Some of the lists for clients are upwards of 2,000+ members. I'm thinking CF could probably handle one client at a time doing this, but in the odd situation where two people are on at once trying it, I'm afraid CF will choke.Is there some kind of software (preferrably cheap or free) that can actually handle the mailing part in the background without slowing down CF?Let me know. John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX for sale
Yeah i know this is off topic, but I want to wrap up. If said winner used the server to develop a system for a client, would it be wrong to bill the client for the price of server (considering they would have paid it regardless?). Either way, the server isnt for development only, so someone will make money off it regardless the avenue. -adam -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 01:38 PM To: 'CF-Talk' Subject: RE: CFMX for sale I agree with Adam.I understand the intent of NFR, but if I own something (a car, a TV, a software package) I don't see why I can't pass it on to someone else for the value they're willing to give me?If the CFUG is that bent on making sure the person they give it to canuse it, they should have a signature sheet or something that the winner has to sign saying they'll actually use it.I could understand if someone somehow got 50 NFR copies and opened a store, but if you have one and want to get rid of it, I don't see the problem.That's free enterprise right? John -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 5:37 PM To: CF-Talk Subject: Re: CFMX for sale NFR = not for _resale_ if it wasn't sold to begin with then its not being _resold_ (are you saying you've never had an illegal copy of any software?... ever?) -adam -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 09:10 PM To: 'CF-Talk' Subject: RE: CFMX for sale If its OK to violate the license agreement and sell a NFR copy, while we're at it lets hijack that busload of nuns and ransom them off.The church has plenty of money, right?Nobody gets hurt; well, really. I mean, if you can rationalize away a little illegality, why not rationalize away something bigger?Illegal is illegal, right?So why stop at the small stuff? -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Activity Logging Options
I am writing an intranet app in a medical environment. As such, I need/want to track accesses to the data, client records, etc. What I am wondering is what is the most effective logging from both a security persepctive and a performance angle. Management sees the need to log as much activity as possible. This would mean logging the username (obtained with CGI variables), the date, the time, the page visited, as well as variables such as ClientNumber or ClientName to know whose record was viewed, etc. Also, was the record modified on this visit, WHAT was modified, etc. etc. As much as I would like a textbook answer, any references to case studies, etc would be appreciated! Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Users getting wrong information
use cookies to keep track of the users. There is one company that when people from there login, they are seeing other peoples information from that company. I know you said that they are all using their own computers... but we had issues where the network storage of profiles was getting mixed up and people were overwriting each others cookies (was a line of public access computers that helpdesk had set up to all use the same network account) thus CF was serving the session vars to the wrong people... dunno if it's any help tho :-/ -- David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX Service Packs
its insance and its driving me insane...! _ From: Doug White [mailto:[EMAIL PROTECTED] Sent: 21 April 2004 14:13 To: CF-Talk Subject: Re: CFMX Service Packs My rant of long standing is that Macromedia has never gotten it together with installers or updates.I know they are aware of the problem, because they continually are hearing about it. The very simplest (and cheapest) software applications as well as the majors,have one-step installers written when updates are released.I even did this for years when I was working in a DoD facility developing software and the contractor I worked for had far less resources available than a giant such as MM. We all know that Macromedia has licenses for InstallShield (the most popular) and InstallAnywhere, but we are at a loss as to why they do not utilize this to install their updates. Doug - Original Message - OK its gripe time Just about to run an upgrade on a ColdFusion 5 set of servers in a test environment and I must say that back in the days of Allaire we used to get Service Packs with nice rolled up packaged of ALL hotfixes and Security updates but now I have to trawl through the MM site to get all ELEVEN hotfix updates in Zip format and THEN goto the security site to get all of those as well.now I am going to be upgrading 3 or 4 servers here dont you think that a service pack would make this a whole lot easier... bring back Allaire Service Packs...none of this hotfix unless its critical and it can wait till another pack _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
BlueDragon in production?
I am looking at BlueDragon and would like to know who is using it for their production apps.Can you offer a brief evaluation?Stable?Fast?Any incompatibilites other than the unsupported tags mentioned in the docs?We are currently using CF5/Win2K/IIS/Oracle with client variables in a load-balanced environment.We want the equivalent, so I guess we would be looking at BD 3 for now. In short, do you trust BlueDragon for your production apps? Thanks, Chris -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 9:36 AM To: CF-Talk Subject: Re: CFMX for sale Tim, Sounds to me like you need BlueDragon. -adam -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 12:36 PM To: 'CF-Talk' Subject: RE: CFMX for sale I work for a non-profit senior care facility that has been trying to figure out how to come up with the cost of purchasing 6.1. Donating it to us would be a great compromise, wouldn't it??? -Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX for sale
If said winner used the server to develop where is the said winner, haven't heard a peep since started this thread... do you think she was scared off? :-) -- David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX for sale
I understand the intent of NFR, but if I own something (a car, a TV, a software package) I don't see why I can't pass it on to someone else for the value they're willing to give me? If you purchase commercial software, you typically don't actually own the software you purchase. You license it, and you're supposed to abide by the terms of that license, no matter how silly they may seem. Admittedly, there haven't been a lot of court cases that cover shrinkwrap licenses, so this may change in the future, but that's how it is right now. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sending lots of mail
Is there some kind of software (preferrably cheap or free) that can actually handle the mailing part in the background without slowing down CF? We've written a mailing-list-manager type app here which allows the user to send combined plain text/HTML emails to an opt-in mailing list.All creation of mails etc is handled by ColdFusion but the actual sending is done using a perl script run as a cron job. Doing it this way takes lots of load off the server and speeds up the process (the user doesn't have to wait for 10s of thousands of mails to be sent - can you imagine the requesttimeout setting on that?!), and even means we can generate the mail from one server (the CF/web server) and send it from another (a dedicated mailing server). Tim. -- --- CF_CodingContest mode=judging newentries=false Maze Solver - http://tech.badpen.com/cfcontest/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: BlueDragon in production?
Oops.Forgot to mention we use CF5 Enterprise (for the Oracle Native drivers). Chris -Original Message- From: Lofback, Chris Sent: Wednesday, April 21, 2004 9:52 AM To: '[EMAIL PROTECTED]' Subject: BlueDragon in production? I am looking at BlueDragon and would like to know who is using it for their production apps.Can you offer a brief evaluation?Stable?Fast?Any incompatibilites other than the unsupported tags mentioned in the docs?We are currently using CF5/Win2K/IIS/Oracle with client variables in a load-balanced environment.We want the equivalent, so I guess we would be looking at BD 3 for now. In short, do you trust BlueDragon for your production apps? Thanks, Chris -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 9:36 AM To: CF-Talk Subject: Re: CFMX for sale Tim, Sounds to me like you need BlueDragon. -adam -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 12:36 PM To: 'CF-Talk' Subject: RE: CFMX for sale I work for a non-profit senior care facility that has been trying to figure out how to come up with the cost of purchasing 6.1. Donating it to us would be a great compromise, wouldn't it??? -Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX for sale
where is the said winner, haven't heard a peep since started this thread... do you think she was scared off? Probably hanging out on the cf-community list waiting for everyone to continue the discussion over there like Mike D requested. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX for sale
Probably hanging out on the cf-community list waiting for everyone to continue the discussion over there like Mike D requested. :-)Nice one!Over and out from me -- David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: BlueDragon in production?
Oops.Forgot to mention we use CF5 Enterprise (for the Oracle Native drivers). One thing you might run into, whether you migrate from CF 5 to BlueDragon or to MX, is that you'll be using JDBC drivers to connect to Oracle, and there are often little differences between how they work and how your current driver works. You'll simply have to test your applications to discover these things. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ot: xslt beginners guide?
Well... over on cf-ot I posted this on Saturday (I know, need to get a life) so I'll post here in the hope of getting a response :-) Anybody recommend any good forums for XSL/XSLT beginners? Books and all recommendations welcome. Got a loan of the XSLT Cookbook from Or'Reilly*** and that proving to be a help (Well good http://www.oreilly.com/catalog/xsltckbk/) Also http://www.zvon.org/ is proving invaluable. -- David *** Rob of the Rohanclan.. you know your Treebeard project gets a nod in it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sending lots of mail
Tim, I'm not very familiar with perl at all.I'm getting ready to move to a dedicated Windows server.Is this something I could do from there? That was one thing I thought about as well was the requesttimeout and the time the user would have to sit there while the CF page processed all of those mails (unless I created a CF Schedule event or something to do the mail).How much control do you have over the outgoing mail if you did it in perl?I know I need to do the usual spam avoidance techniques and headers to make sure it gets to the person.Any info, resources or direction you could give would be great! John -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 9:49 AM To: CF-Talk Subject: RE: Sending lots of mail Is there some kind of software (preferrably cheap or free) that can actually handle the mailing part in the background without slowing down CF? We've written a mailing-list-manager type app here which allows the user to send combined plain text/HTML emails to an opt-in mailing list.All creation of mails etc is handled by ColdFusion but the actual sending is done using a perl script run as a cron job. Doing it this way takes lots of load off the server and speeds up the process (the user doesn't have to wait for 10s of thousands of mails to be sent - can you imagine the requesttimeout setting on that?!), and even means we can generate the mail from one server (the CF/web server) and send it from another (a dedicated mailing server). Tim. -- --- CF_CodingContest mode=judging newentries=false Maze Solver - http://tech.badpen.com/cfcontest/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: xslt beginners guide?
Anybody recommend any good forums for XSL/XSLT beginners? Check out this link on the left hand side... http://www.w3schools.com/ Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: BlueDragon in production?
We are using CFMX Enterprise for some internal apps and the Oracle drivers work without a hitch. So do you use BlueDragon for any of your production apps?If so, how do you like it? Chris -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:09 AM To: CF-Talk Subject: RE: BlueDragon in production? Oops.Forgot to mention we use CF5 Enterprise (for the Oracle Native drivers). One thing you might run into, whether you migrate from CF 5 to BlueDragon or to MX, is that you'll be using JDBC drivers to connect to Oracle, and there are often little differences between how they work and how your current driver works. You'll simply have to test your applications to discover these things. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SMTP
Copy them out of the spool folder and back in one at a time. -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 5:01 PM To: CF-Talk Subject: SMTP Ok I hae a bunch of mail sitting in my Spool folder. I have bounced IIS and the SMTP server several times. These emails were originally in my Undelivered folder cause SMTP was not started when these emails should have been ran. I just ran an email off the server to another email acount using a form on one of my sites and I received it successfully. I copied all the undelivered emails and paced them in the spool folder but they are not being sent. Any ideas? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: xslt beginners guide?
Anybody recommend any good forums for XSL/XSLT beginners? Books and all recommendations welcome. I have a Wrox book by Michael Kay, who knows a thing or two about XSLT. There used to be a related forum on wrox.com which Michael was on, so you could always get an answer if your question was interesting enough. Not sure if it's still there. I wouldn't say the book makes XSLT exactly easy to understand, but I think that's because XSLT just isn't very easy to understand ;-) Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sending lots of mail
John, currently we have CF sending out 20k+ emails per day. (Usually within a one hour timeframe). The setup I inherited is all on one box. The site shows delayed responses during this mailing, however it's not too bad. I think the majority of the spped issues have to with bad coding. I'm currently working on a new setup whereas the emails will be sent from a CFserver dedicated to email only. -Adam -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 01:45 PM To: 'CF-Talk' Subject: Sending lots of mail I know this discussion came up before about how many emails can be sent *reliably* using cfmail in CFMX 6.1.I'm curious what the numbers are on that and then also what is out there that people would recommend for doing mail-outs that are too big for CF.I'm thinking that I want to use CF to give some Admin controls to users for formatting an email and then sending to their list.Some of the lists for clients are upwards of 2,000+ members. I'm thinking CF could probably handle one client at a time doing this, but in the odd situation where two people are on at once trying it, I'm afraid CF will choke.Is there some kind of software (preferrably cheap or free) that can actually handle the mailing part in the background without slowing down CF?Let me know. John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: xslt beginners guide?
Thanks for getting back to me... sorry, I don't think I've worded it very well I've went through the simple tutorials on w3schools, also on zvon.org... I've got a grasp of the really basic stuff with the basic examples given. I'm at the stage where I've got a XML schema and I wanna be able to do what zvon.org does so I don't need to care what platform the user is coming to the pages on... but I've hit a brick wall... Guess I was looking for the XSLT version of this list :-) -- David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: BlueDragon in production?
We are using CFMX Enterprise for some internal apps and the Oracle drivers work without a hitch. Good. You'll want to perform the same sort of testing with BlueDragon, as I'm guessing it uses a different set of JDBC drivers. In the event that you have any problems with those drivers, or the ones that come with CFMX for that matter, you can always use Oracle's own JDBC drivers instead. So do you use BlueDragon for any of your production apps? If so, how do you like it? Currently, none of our clients are using BlueDragon. I run it on my laptop, and I like it, but I haven't worked with it in any kind of production environment yet. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sending lots of mail
Adam, Good idea. Any ideas for a way around the waiting while the thousands of emails are sent by a user?Or are yours done through a scheduled task? Also, any idea on performace issues etc with doing it as cfmail query= vs. cfoutput query=cfmail/cfoutput?I'm guessing the first is better but I'd be interested to hear of any other information. John -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:15 AM To: CF-Talk Subject: Re: Sending lots of mail John, currently we have CF sending out 20k+ emails per day. (Usually within a one hour timeframe). The setup I inherited is all on one box. The site shows delayed responses during this mailing, however it's not too bad. I think the majority of the spped issues have to with bad coding. I'm currently working on a new setup whereas the emails will be sent from a CFserver dedicated to email only. -Adam -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 01:45 PM To: 'CF-Talk' Subject: Sending lots of mail I know this discussion came up before about how many emails can be sent *reliably* using cfmail in CFMX 6.1.I'm curious what the numbers are on that and then also what is out there that people would recommend for doing mail-outs that are too big for CF.I'm thinking that I want to use CF to give some Admin controls to users for formatting an email and then sending to their list.Some of the lists for clients are upwards of 2,000+ members. I'm thinking CF could probably handle one client at a time doing this, but in the odd situation where two people are on at once trying it, I'm afraid CF will choke.Is there some kind of software (preferrably cheap or free) that can actually handle the mailing part in the background without slowing down CF?Let me know. John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sending lots of mail
Why not leave CF out of the mail picture entirely, as far as mail list is concerned.Instead us a list server that provides for an opt-in./ opt-out like most of the world uses? With a list server, all you do is send an email to the list, and the server will distribute it tothe subscribers..The email server software maintains the address list. You will use much less server resources this way. Doug == We can get rid of spam on your domain! , Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == - Original Message I know this discussion came up before about how many emails can be sent *reliably* using cfmail in CFMX 6.1.I'm curious what the numbers are on that and then also what is out there that people would recommend for doing mail-outs that are too big for CF.I'm thinking that I want to use CF to give some Admin controls to users for formatting an email and then sending to their list.Some of the lists for clients are upwards of 2,000+ members. I'm thinking CF could probably handle one client at a time doing this, but in the odd situation where two people are on at once trying it, I'm afraid CF will choke.Is there some kind of software (preferrably cheap or free) that can actually handle the mailing part in the background without slowing down CF?Let me know. John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
FREE BD vs. $$$$ CF
The free BD vs CF comes down to politics in our organization. It was a struggle to get my employer to warm up to CF 4.5. I literally had to formally donate my copy, make an effective application, then beg for forgiveness instead of asking for permission. Slowly but surely, there were converts. Moving to 6.1 at this point means the cost of an upgrade ($600 or so). Moving to the free BD means a hard sell to management that we should make use of a product that is free. And, with the ironic comedy worthy of a Dilbert cartoon, management is quite steadfast in the opinion that taking a huge gamble with the sanctity of our data with a company like Macromedia at a cost of $600 is more prudent than the free route with the lesser known New Atlanta. The humor is that 4.5 (the version I demonstated with) was an Allaire product. New Atlanta vs Allaire, in the medical arena, is not exactly the makings of a big draw prizefight. Now, I could go through a long educational process that explains the pros and cons of going with a Macromedia vs a New Atlanta, but the $600 savings gets eaten away really quick by the time I prepare a presentation, bang my head on the walls of my cubicle, make enemies in IS for being a rebel, spend $$$ on Tylenol, etc. So, as painful as it might be for an organization such as ours to pony up the $600 for a CF upgrade, the relative cost of going with New Atlanta is not worth it. The name Macromedia garners enough recognition from management and the IT staff where they are at least willing to let me get the product onto the network. I can't afford to give up that credibility at the cost of $600. Is this a jab on my part against New Atlanta? Not at all. I am merely illustrating why, in MY CASE, $600 for CF is cheaper than $0 for BlueDragon. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: xslt beginners guide?
I wouldn't say the book makes XSLT exactly easy to understand, but I think that's because XSLT just isn't very easy to understand ;-) That's exactly what I'm running into... just don't know enough to make the leaps required at the moment... but ah'll keep trying :-) Cheers -- David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sending lots of mail
I send out about 30,000 emails every morning for the BlueEar.com web site. I created scheduled tasks that compiles the newsletters and then creates a scheduled task that runs every few minutes and grabs 500 subscribers at a time for a given subscription (BlueEar.com has multiple subscription Options). After the list of subscribers have all been ran it resets the Sent Status for each subscriber and deletes the Scheduled Task. I have ran it this way on CF5 for the last few years and just in the last few weeks on CFMX without any problems. I am thinking of bumping it up to 700 and maybe 1000 subscribers at once. Rick -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 6:46 AM To: CF-Talk Subject: Sending lots of mail I know this discussion came up before about how many emails can be sent *reliably* using cfmail in CFMX 6.1.I'm curious what the numbers are on that and then also what is out there that people would recommend for doing mail-outs that are too big for CF.I'm thinking that I want to use CF to give some Admin controls to users for formatting an email and then sending to their list.Some of the lists for clients are upwards of 2,000+ members. I'm thinking CF could probably handle one client at a time doing this, but in the odd situation where two people are on at once trying it, I'm afraid CF will choke.Is there some kind of software (preferrably cheap or free) that can actually handle the mailing part in the background without slowing down CF?Let me know. John _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ot: xslt beginners guide?
On Wed, 2004-04-21 at 07:07, [EMAIL PROTECTED] wrote: Anybody recommend any good forums for XSL/XSLT beginners? Books and all recommendations welcome. Got a loan of the XSLT Cookbook from Or'Reilly*** and that proving to be a help (Well good http://www.oreilly.com/catalog/xsltckbk/) Also http://www.zvon.org/ is proving invaluable. *** Rob of the Rohanclan.. you know your Treebeard project gets a nod in it? It does?! Nah, I had no idea ... hitting book store tonight ... http://www.mulberrytech.com/xsl/xsl-list/ That list is where the big dogs hang out - most any author of an XSLT book and/or XSLT parser is on that list. They are often helpful if you ask your questions correctly (i.e. in the hacker way - I think Jochem posted the how-to-ask link a couple times). Cheers, and thanks for the information -- Rob [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL Cursor Output in CF?
Is there a way to get SQL Cursor output in ColdFusion? It doesn't appear to be available in the Query Scope. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: AOL email/spam handling...
Does AOL still require you to be in their address book to receive emails? Or was this just a vile rumor?We're trying to figure out a small email list and make sure we don't exclude AOL members...poor SOBs. Is there any good documentation out there on how to handle this? Or any secret tricks? Tyler S FYI: it's an opt-in ListServ, no p0rn, [EMAIL PROTECTED] (1 or 2), [EMAIL PROTECTED], etc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sending lots of mail
Rick, I do the same thing for my onlysimchas.com email lists. I have it set to send 500 mails every 3 minutes, which is safe. Last time I bumped it up, I actually ended up causing the CF Mail Spool delivery thread to die, causing all mail outbound from the site to sit in the spool forever. Just a head's up, so be careful, as I don't know what caused that.. -dov _ From: cfhelp [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:38 AM To: CF-Talk Subject: RE: Sending lots of mail I send out about 30,000 emails every morning for the BlueEar.com web site. I created scheduled tasks that compiles the newsletters and then creates a scheduled task that runs every few minutes and grabs 500 subscribers at a time for a given subscription (BlueEar.com has multiple subscription Options). After the list of subscribers have all been ran it resets the Sent Status for each subscriber and deletes the Scheduled Task. I have ran it this way on CF5 for the last few years and just in the last few weeks on CFMX without any problems. I am thinking of bumping it up to 700 and maybe 1000 subscribers at once. Rick -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 6:46 AM To: CF-Talk Subject: Sending lots of mail I know this discussion came up before about how many emails can be sent *reliably* using cfmail in CFMX 6.1.I'm curious what the numbers are on that and then also what is out there that people would recommend for doing mail-outs that are too big for CF.I'm thinking that I want to use CF to give some Admin controls to users for formatting an email and then sending to their list.Some of the lists for clients are upwards of 2,000+ members. I'm thinking CF could probably handle one client at a time doing this, but in the odd situation where two people are on at once trying it, I'm afraid CF will choke.Is there some kind of software (preferrably cheap or free) that can actually handle the mailing part in the background without slowing down CF?Let me know. John _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Users getting wrong information
Quite possibly.We had the same problem with proxy servers at a couple of different companies. We used this: !---Nocache setting--- CFHEADER NAME=Expires VALUE=0 CFHEADER NAME=Pragma VALUE=no-cache CFHEADER NAME=cache-control VALUE=no-cache, no-store, must-revalidate to prevent them from caching.I'm not certianit will work in all cases, but it worked in all of *our* cases.As always, YMMV. --Ben Doom [EMAIL PROTECTED] wrote: I have a website that people can login, take a quiz, view their status, etc...I use cookies to keep track of the users. There is one company that when people from there login, they are seeing other peoples information from that company. Does this have something to do with a proxy server being used? They are all using their own computers. Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: FCKeditor Upload/Browse
I had to put my reading glasses on to make sure i was reading the product name correctly. How do you pronounce it??? I'm working on setting up the terrific FCKeditor, and was curious if anyone had already built an image uploader and/or a image browser to go along with this editor. If so, are you willing to share? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [OT] MySQL is really free?
According to MySQL (because I contacted them with a similar question): Free use for those who never copy, modify or distribute. As long as you never distribute (internally or externally) the MySQL Software in any way, you are free to use it for powering your application, irrespective of whether your application is under GPL license or not. (from MySQL Open Source License, http://www.mysql.com/products/licensing/opensource-license.html) If all you are doing is running web applications of some sort from your server using Blue Dragon, and use MySQL as the backend database, and do not distribute any MySQL software to a user (i.e., client drivers), then you do not have to pay for MySQL OR release your web app. under the GPL.A further clarification from a representative at MySQL: If you did not include our drivers or libraries, you have not[sic] monetary obligation to us... It's a somewhat fine line that you have to watch with MySQL depending on what you're doing, but if you are really concerned, contact MySQL and ask them, [EMAIL PROTECTED] I did read that they are working on clarifying their licensing details, since a lot of people get confused by the whole open-source/GPL requirements vs. how they are using the software. Cheers! -milner -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Sunday, April 18, 2004 10:12 AM To: CF-Talk Subject: [OT] MySQL is really free? Hi all pls answer this question: if we're install BlueDragon apps and MySQL in our client box, is need to pay that license for MySQL? Or is possible to use MySQL without license? MySQL is really free? Thnx for your time. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: FREE BD vs. $$$$ CF
This isn't all that odd. in my case the problem is similar, but comes from another end.My (very large) company won't consider either product because their both too cheap - and so (goes the management opinion) are not fit for enterprise use. We're not allowed to use open source software for the same reasons: free means no support' (which is bogus) and poor quality compared to enterprise vendors. Now wait for the punchline.What did this company decide to standardize on? What tool meets their criteria? IBM WebSphere on IBM Apache.So we end up spending many, MANY thousands of dollars on essentially branded open source software.(Which, has an aside, is so difficult to configure and learn that we've yet to produce any applications significantly better than our legacy CF 4.5 apps). Jim Davis _ From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:29 AM To: CF-Talk Subject: FREE BD vs. CF The free BD vs CF comes down to politics in our organization. It was a struggle to get my employer to warm up to CF 4.5. I literally had to formally donate my copy, make an effective application, then beg for forgiveness instead of asking for permission. Slowly but surely, there were converts. Moving to 6.1 at this point means the cost of an upgrade ($600 or so). Moving to the free BD means a hard sell to management that we should make use of a product that is free. And, with the ironic comedy worthy of a Dilbert cartoon, management is quite steadfast in the opinion that taking a huge gamble with the sanctity of our data with a company like Macromedia at a cost of $600 is more prudent than the free route with the lesser known New Atlanta. The humor is that 4.5 (the version I demonstated with) was an Allaire product. New Atlanta vs Allaire, in the medical arena, is not exactly the makings of a big draw prizefight. Now, I could go through a long educational process that explains the pros and cons of going with a Macromedia vs a New Atlanta, but the $600 savings gets eaten away really quick by the time I prepare a presentation, bang my head on the walls of my cubicle, make enemies in IS for being a rebel, spend $$$ on Tylenol, etc. So, as painful as it might be for an organization such as ours to pony up the $600 for a CF upgrade, the relative cost of going with New Atlanta is not worth it. The name Macromedia garners enough recognition from management and the IT staff where they are at least willing to let me get the product onto the network. I can't afford to give up that credibility at the cost of $600. Is this a jab on my part against New Atlanta? Not at all. I am merely illustrating why, in MY CASE, $600 for CF is cheaper than $0 for BlueDragon. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: xslt beginners guide?
It does?! Nah, I had no idea ... hitting book store tonight ... Yeah... mentions the commercial ones then gives a nod to yours... I could dig out the page no if needed :-) Cheers for the link to the list... looks like exactly what I was looking for.Thanks for your help. -- David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Cursor Output in CF?
On Wednesday 21 Apr 2004 15:33 pm, Jeff Small wrote: Is there a way to get SQL Cursor output in ColdFusion? Yup, but possibly only from stored procedures. What CF version ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: AOL email/spam handling...
.poor SOBs. I am one of them :-)... I don't grumble with a pretty good broadband connection that stays up forever. Serious question tho...One benefit is that I can at least test my apps on an AOL browser... how do you do that if you are not a member of AOL? Is there another way of doing this? Anyway, haven't used the AOL client for months (other than testing) and just connect directly through a DUN but from memory you can recieve emails from anyone... (up to AOL 9 anyways) -- David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX for sale
Either way, the server isnt for development only, so someone will make money off it regardless the avenue. Yes the NFR copies (raffled at CFUGs) are for commercial development and product demos only...NOT hosting live commercial sites. Susan didn't have an NFR copy...case closed Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Adrocknaphobia To: CF-Talk Sent: Wednesday, April 21, 2004 6:47 AM Subject: Re: CFMX for sale Yeah i know this is off topic, but I want to wrap up. If said winner used the server to develop a system for a client, would it be wrong to bill the client for the price of server (considering they would have paid it regardless?). Either way, the server isnt for development only, so someone will make money off it regardless the avenue. -adam -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 01:38 PM To: 'CF-Talk' Subject: RE: CFMX for sale I agree with Adam.I understand the intent of NFR, but if I own something (a car, a TV, a software package) I don't see why I can't pass it on to someone else for the value they're willing to give me?If the CFUG is that bent on making sure the person they give it to canuse it, they should have a signature sheet or something that the winner has to sign saying they'll actually use it.I could understand if someone somehow got 50 NFR copies and opened a store, but if you have one and want to get rid of it, I don't see the problem.That's free enterprise right? John -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 5:37 PM To: CF-Talk Subject: Re: CFMX for sale NFR = not for _resale_ if it wasn't sold to begin with then its not being _resold_ (are you saying you've never had an illegal copy of any software?... ever?) -adam -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 09:10 PM To: 'CF-Talk' Subject: RE: CFMX for sale If its OK to violate the license agreement and sell a NFR copy, while we're at it lets hijack that busload of nuns and ransom them off.The church has plenty of money, right?Nobody gets hurt; well, really. I mean, if you can rationalize away a little illegality, why not rationalize away something bigger?Illegal is illegal, right?So why stop at the small stuff? -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: FREE BD vs. $$$$ CF
On Apr 21, 2004, at 7:48 AM, Jim Davis wrote: This isn't all that odd. in my case the problem is similar, but comes from another end. My (very large) company won't consider either product because their both too cheap - and so (goes the management opinion) are not fit for enterprise use. I used to work for IBM Data Processing Division and many IBM products were (rumored to be) priced this way (high) because they had a perceived greater worth. One specific product comes to mind, CICS. This was a back-end terminal to MaimFrame CPU (no network) information system. It was a good system, but nowhere near the capability, power, ease-of-use, etc. of CFMX. Work was essentially completed on the product in the 1980's and it went into maintenance mode (no new development) The last I heard the number of users of the CICS (MaimFrame DOS) version was over 30,000 users. The average cost to IBM customers was $3,000 per month You do the math! Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
HTML works with CCS
hi all this problem has nothing to do with coldfusion but I know some of you may help me out. I try to have page layout with styles CCS. in CCS file has #bg {position:} #content{} #navigation{} in html has div id=navigation /div div id=bg /div div id=content ... /div It works in my delopment mashine but not in product mashine.I have win2k pro in development mashine and win2k server in product. Is there anything I need to do with win2k server to make it works? Thanks John __ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sending lots of mail
Each email we send is dynamic per a user's settings and options. If it was static across the board I'd agree with you completely. -adam -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 02:22 PM To: 'CF-Talk' Subject: Re: Sending lots of mail Why not leave CF out of the mail picture entirely, as far as mail list is concerned.Instead us a list server that provides for an opt-in./ opt-out like most of the world uses? With a list server, all you do is send an email to the list, and the server will distribute it tothe subscribers..The email server software maintains the address list. You will use much less server resources this way. Doug == We can get rid of spam on your domain! , Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == - Original Message I know this discussion came up before about how many emails can be sent *reliably* using cfmail in CFMX 6.1.I'm curious what the numbers are on that and then also what is out there that people would recommend for doing mail-outs that are too big for CF.I'm thinking that I want to use CF to give some Admin controls to users for formatting an email and then sending to their list.Some of the lists for clients are upwards of 2,000+ members. I'm thinking CF could probably handle one client at a time doing this, but in the odd situation where two people are on at once trying it, I'm afraid CF will choke.Is there some kind of software (preferrably cheap or free) that can actually handle the mailing part in the background without slowing down CF?Let me know. John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: HTML works with CCS
I'm afraid that's not enough information to get a concrete answer. It could any number of things. I would suggest checking out some CSS specific resources. Most notably the resource page at csszengarden.com and the css-discuss email list: http://www.mezzoblue.com/zengarden/resources/ http://www.mezzoblue.com/zengarden/resources/ http://www.css-discuss.org/mailman/listinfo/css-d/ http://www.css-discuss.org/mailman/listinfo/css-d/ -Original Message- From: John Ho [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:24 AM To: CF-Talk Subject: HTML works with CCS hi all this problem has nothing to do with coldfusion but I know some of you may help me out. I try to have page layout with styles CCS. in CCS file has #bg {position:} #content{} #navigation{} in html has div id=navigation /div div id=bg /div div id=content ... /div It works in my delopment mashine but not in product mashine.I have win2k pro in development mashine and win2k server in product. Is there anything I need to do with win2k server to make it works? Thanks John __ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Locking Records!
Just setting a binary lock value in the table will lock it for everybody, including the person who owns the lock and is allowed to edit it. My cms uses an application-scoped 2d array that holds the record's primary key, the user ID of the person 'owning' the lock and a timestamp value. Your CF code needs to be able to set the lock (i.e. add to the array) when desired, break it when the user leaves (remove from the array), update the timestamp and let another user in if the lock has 'expired' after a period of inactivity you decide upon.I also have a separate 'who's on' app that also lets an admin break locks as they see fit. A bunch of files and stuff is involved in putting something like this together, but it is absolutely slick when its in place.I've been meaning to write it up as a generic howto and post it on my site.I'll try to get it done today. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Activity Logging Options
What is management going to do with the logs? If used for, problem resolution, historical information periodic reporting, etc. this is essentially a low-use log and you could log a lot of information using almost any logging facility. If, however, management wants immediate access to the logs for status monitoring, use analysis, etc.This is a high-use log and I would consider logging everything to a separate log database. (maybe on a separate db server). The db approach allows maximum flexibility and surprising little logging overhead (most of the activity will be inserts). I developed a system for one client that would log each time a record appeared in a drill-down of search-results, and when a record was selected for review.This system only logged counts (updated the log records) but was surprisingly efficient. Finally, it is likely that the next major versions of OSes will have the native file systems based on databases -- so you will be ahead of the game. HTH Dick On Apr 21, 2004, at 6:48 AM, Claremont, Timothy wrote: I am writing an intranet app in a medical environment. As such, I need/want to track accesses to the data, client records, etc. What I am wondering is what is the most effective logging from both a security persepctive and a performance angle. Management sees the need to log as much activity as possible. This would mean logging the username (obtained with CGI variables), the date, the time, the page visited, as well as variables such as ClientNumber or ClientName to know whose record was viewed, etc. Also, was the record modified on this visit, WHAT was modified, etc. etc. As much as I would like a textbook answer, any references to case studies, etc would be appreciated! Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
best CF host for 20 dollars a month
who does everyone think is the best CF host for 20 dollars a month. im hoping to get sql server access as well as host multiple domains (and create sub domains). thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sending lots of mail
At a previous job, we had a system set up where we created a .txt file with header information and such on it as well as a space for an SQL statement to grab the names of the people to send to.We'd then feed the .txt into some special mail program by making a terminal connection and pasting the text.There was also an option to send the txt from a trusted email address and it would process the rest.I'm just not sure what the software was called but something along those lines would be great for me.Then, I could manage the emails and lists through CF as well as the specific list that an email was supposed to go out to and then I could pass a single file over to the other server for processing. Anyone know of something like that? John -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 11:26 AM To: CF-Talk Subject: Re: Sending lots of mail Each email we send is dynamic per a user's settings and options. If it was static across the board I'd agree with you completely. -adam -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 02:22 PM To: 'CF-Talk' Subject: Re: Sending lots of mail Why not leave CF out of the mail picture entirely, as far as mail list is concerned.Instead us a list server that provides for an opt-in./ opt-out like most of the world uses? With a list server, all you do is send an email to the list, and the server will distribute it tothe subscribers..The email server software maintains the address list. You will use much less server resources this way. Doug == We can get rid of spam on your domain! , Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == - Original Message I know this discussion came up before about how many emails can be sent *reliably* using cfmail in CFMX 6.1.I'm curious what the numbers are on that and then also what is out there that people would recommend for doing mail-outs that are too big for CF.I'm thinking that I want to use CF to give some Admin controls to users for formatting an email and then sending to their list.Some of the lists for clients are upwards of 2,000+ members. I'm thinking CF could probably handle one client at a time doing this, but in the odd situation where two people are on at once trying it, I'm afraid CF will choke.Is there some kind of software (preferrably cheap or free) that can actually handle the mailing part in the background without slowing down CF?Let me know. John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sending lots of mail
My main project (CF based) is an online publishing and email broadcasting system. I used to use ActivMail for sending out broadcasts when we were on CF5, but found with CFMX that the cfmail tag was VASTLY improved (both feature-wise and performance-wise) and have moved back to that. That said, concerning multiple clients trying to send... I had to write a whole queueing system so as not to potentially overwhelm my servers if multiple clients wanted to send at the same time. I basically break each send up into 5k blocks (should the send be more than 5k), and have a scheduled task running a script that basically picks up a single 5k block, processes it, and then terminates. Hit me up off-list if you'd like to chat more on it, I'd be happy to try and nudge you in the right direction. --Scott At 07:45 AM 4/21/2004, you wrote: I know this discussion came up before about how many emails can be sent *reliably* using cfmail in CFMX 6.1.I'm curious what the numbers are on that and then also what is out there that people would recommend for doing mail-outs that are too big for CF.I'm thinking that I want to use CF to give some Admin controls to users for formatting an email and then sending to their list.Some of the lists for clients are upwards of 2,000+ members. I'm thinking CF could probably handle one client at a time doing this, but in the odd situation where two people are on at once trying it, I'm afraid CF will choke.Is there some kind of software (preferrably cheap or free) that can actually handle the mailing part in the background without slowing down CF?Let me know. John -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:160759This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11694.10690.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: FCKeditor Upload/Browse
I did one in CMLite, which is a free download in the MM devex.More accurately, I spruced up the one included in the download a bit, making the window resizable, adding scrollbars and making the cffile uploader more robust. http://mysecretbase.com/CMLite_Home.cfm It doesn't use v1.5 though (v.14 I think).I have an updated/revised version that I have to upload later today. I talked to the CF developer responsible for the lead on v2.0 and he's planning a fully-functional browser that allows navigation thru subfolders.I built one of *those* too but my _javascript_ skills weren't solid enough to be able to tie it back into the editor.Then like a dummy I lost the files :( Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: best CF host for 20 dollars a month
$20 totalor per domain?You seem to be asking a lot for a CF host to give you all of that for $20/month total.I can't think of anyone. John -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 11:36 AM To: CF-Talk Subject: best CF host for 20 dollars a month who does everyone think is the best CF host for 20 dollars a month. im hoping to get sql server access as well as host multiple domains (and create sub domains). thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sending lots of mail
On Wednesday 21 Apr 2004 16:37 pm, Burns, John D wrote: Anyone know of something like that? You can replace tokens in the file easily enough with reg. exps. in your favorite language. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: best CF host for 20 dollars a month
You are sure asking for a lot for $20 bucks!:-) SQL server user licenses are not free, ya know, neither is the connectivity. == We can get rid of spam on your domain! , Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == - Original who does everyone think is the best CF host for 20 dollars a month. im hoping to get sql server access as well as host multiple domains (and create sub domains). thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Locking Records!
Matt Robertson wrote: Just setting a binary lock value in the table will lock it for everybody, including the person who owns the lock and is allowed to edit it. My cms uses an application-scoped 2d array that holds the record's primary key, the user ID of the person 'owning' the lock and a timestamp value. This might be overkill for this application, but nevertheless an entertaining read on concurrency control: Concurrency Control and Recovery in Database Systems ftp://ftp.research.microsoft.com/users/ccontrol/ccontrol.zip Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Sending lots of mail
John Burns wrote: Some of the lists for clients are upwards of 2,000+ members. I'm thinking CF could probably handle one client at a time doing this, but in the odd situation where two people are on at once trying it, I'm afraid CF will choke. Thats not even close to enough mail to worry about.I've got clients with 5,000+ lists and have seen three or four of them hit the server at once.No problemo. If you want you can throttle down the mail send rate for lists in this size range. http://mysecretbase.com/Slowing_Down_CFMAIL.cfm Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Activity Logging Options
I wrote an app that managed some patient data and we used a fairly generic audit table to capture our audit trail. Because it was generic, I wrote a UDF to perform the actual logging with very minimal impact. Below is the SQL to create the table, you will probably have to modify it. CREATE TABLE [Audit_Trail] ( [Activity_Timestamp] [smalldatetime] NOT NULL , [User_Entity_ID] [int] NULL , [Activity] [varchar] (200)NOT NULL , [Primary_Table_Affected] [varchar] (50)NULL , [Record_ID_Affected] [int] NULL , [IP_Address] [varchar] (23) NOT NULL , [Audit_Comments] [varchar] (1000)NULL ) ON [PRIMARY] GO Column explanations: [Activity_Timestamp] : when the item was logged [User_Entity_ID] : user identifier (we use int id's for our users but could be changed to whatever) [Activity] : brief description of the activity (we used common items like view, delete, update, add, etc) [Primary_Table_Affected] : name of the table affected by user's actions [Record_ID_Affected] : primary record id affected by user's actions [IP_Address] : we captured the ip address of the computer where the user was working [Audit_Comments] : free text to put longer messages usually included old values and new values where applicable Hope this is helpful. Let me know if I can help further. Doug Claremont, Timothy wrote: I am writing an intranet app in a medical environment. As such, I need/want to track accesses to the data, client records, etc. What I am wondering is what is the most effective logging from both a security persepctive and a performance angle. Management sees the need to log as much activity as possible. This would mean logging the username (obtained with CGI variables), the date, the time, the page visited, as well as variables such as ClientNumber or ClientName to know whose record was viewed, etc. Also, was the record modified on this visit, WHAT was modified, etc. etc. As much as I would like a textbook answer, any references to case studies, etc would be appreciated! Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: best CF host for 20 dollars a month
www.nexpoint.net has a $99/yr (see their Win2K special) CF deal, with SQL Server for an additional $25/yr.Subdomains are available too.Don't know about multiple domains. Bear in mind you get what you pay for.They don't yet have CFMX (afaik), and no control panel (so no adding dsns on your own).Caveat emptor :) - Original Message - From: Wurst, Keith D. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 8:36 AM Subject: best CF host for 20 dollars a month who does everyone think is the best CF host for 20 dollars a month. im hoping to get sql server access as well as host multiple domains (and create sub domains). thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
WOT: Digital VideoCam recommendations
This is WOT for this list, but I know many of you members have videocams--- so I hope you will give me the benefit of your experience. My granddaughter's first communion is approaching. I would like to record the proceedings, etc., so I am in the market for a digital videocam. Ideally, it would plug and play with my Mac Powerbook 17 inch and upload the movies over Firewire 2. I also have a 23 Apple studio display -- both the 17 and the 23 are wide aspect displays. The PB also has FireWire 1 and USB 1 ports. The FireWire 2 would be best because it is twice the speed of FireWire 1 and USB 2. I am willing to pay a premium for FW2 Otherwise, I just want a good price-performer until a FW2 camera becomes available. TIA Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Locking Records!
Jochem van Dieten wrote: This might be overkill for this application, but nevertheless an entertaining read on concurrency control: 22mb zip file.holy cow!:-) --Matt-- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: FCKeditor Upload/Browse
I did one in CMLite, which is a free download in the MM devex.More accurately, I spruced up the one included in the download a bit, making the window resizable, adding scrollbars and making the cffile uploader more robust. http://mysecretbase.com/CMLite_Home.cfm Sorry, maybe I'm still tired this morning... not sure if you're switching gears from CMLite to FCKeditor, or if CMLite includes FCKeditor. Either way, do you have the upload/browse code that you'd be willing to share? It doesn't use v1.5 though (v.14 I think).I have an updated/revised version that I have to upload later today. I talked to the CF developer responsible for the lead on v2.0 and he's planning a fully-functional browser that allows navigation thru subfolders.I built one of *those* too but my _javascript_ skills weren't solid enough to be able to tie it back into the editor.Then like a dummy I lost the files :( Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: FCKeditor Upload/Browse
hah!right?FCK are the initials of teh author.This thing rawks by the way. Jake, There should be samples in the download.I used this recently for a PHP site and they were there.I thought I saw CF versions too.If not, shold be able to port the PHP ones quite easily.Could send these to the author FCK too so he can include in future releases! Doug -Original Message- From: Tim Claremont [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:41 AM To: CF-Talk Subject: Re: FCKeditor Upload/Browse I had to put my reading glasses on to make sure i was reading the product name correctly. How do you pronounce it??? I'm working on setting up the terrific FCKeditor, and was curious if anyone had already built an image uploader and/or a image browser to go along with this editor. If so, are you willing to share? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Cursor Output in CF?
On Wednesday 21 Apr 2004 15:33 pm, Jeff Small wrote: Is there a way to get SQL Cursor output in ColdFusion? Yup, but possibly only from stored procedures. What CF version ? CFMX, does that matter? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Is it a bug or not a bug?
A boolean _expression_ must take a boolean value, a boolean value is either true or false, it cannot take any integer value like 20, 20 is NOT a boolean, PERIOD. You're still missing the fundemental point about a loosely typed language. There is no such thing as a boolean (nor an integer, nor a floating point number), there are only values that can be evaluated in different ways. Let's switch languages for a second to keep this a loosely typed language debate and not a CF implementation debate.Here's some _javascript_ and VBScript: script language=_javascript_ document.write(true 5); /script script language=vbscript document.write(true and 5) /script These will return 5 every time, because both are loosely typed languages. They'll NEVER return true (nor 1, yes, or anything else). I don't have runtimes/compilers for any other loosely typed languages hanging about on my machine, but if anyone else does, I'd be very interested to see the output from equivalent statements in various other loosely typed languages. Cheers, barneyb -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 6:39 PM To: CF-Talk Subject: Re: Is it a bug or not a bug? So all those people using cfif Len(Trim(value))IS TRUEcfelseIS FALSE/cfif are doing it wrong? I dont think so... this is valid and good practice. Please don't mix up everything: it IS correct to use your statement, because len(...) will be converted to a boolean. You can use any integer in a boolean _expression_. What is NOT correct is CF evaluating a boolean _expression_ as an integer value. A boolean _expression_ must take a boolean value, a boolean value is either true or false, it cannot take any integer value like 20, 20 is NOT a boolean, PERIOD. -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
WYSIWYG HTML Editors...
Hello... all I am looking for a good open source WYSIWYG HTML form field editor control thingy. Something like SPAW or FCKeditor, I guess a better question is which one of these is better or more stable. I need to implement one pretty fast but don't have a lot of time to research them all, so I thought I would consult the great collective wisdom of this list to help me decide on the right one to use. Let me know what you think of if there are any better, newer or more stable ones outthere. Thanks. Neal Bailey Internet Marketing Manager E-mail:II mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: WYSIWYG HTML Editors...
Here is the code I got somewhere along the line. It works for an inital insert but to bring it back up to edit an existing article is my problem. I would like to basically recreate this same page but it would display an article that was previously save for editing, like typos or overall text changes. Any takers. html head title Browser Based HTML Editor /title script language=_javascript_ function ProcessNews() { // Assign the HTML code to a hidden form variable var htmlCode = iView.document.body.innerHTML; document.frmNews.newsPost.value = htmlCode; // Make sure that all fields are completed if(document.frmNews.author.selectedIndex == 0) { alert('Please select an author for this news post.'); document.frmNews.author.focus(); return false; } if(document.frmNews.title.value == '') { alert('This news post must contain a title.'); document.frmNews.title.focus(); return false; } if(document.frmNews.topics.selectedIndex == -1) { alert('Please select a topic for this news post.'); document.frmNews.topics.focus(); return false; } if(document.frmNews.newsPost.value == '') { alert('Please enter some content for this news post.'); iView.focus(); return false; } return true; } /script script language=_javascript_ var viewMode = 1; // WYSIWYG function Init() { iView.document.designMode = 'On'; } function selOn(ctrl) { ctrl.style.borderColor = '#00'; ctrl.style.backgroundColor = '#B5BED6'; ctrl.style.cursor = 'hand'; } function selOff(ctrl) { ctrl.style.borderColor = '#D6D3CE'; ctrl.style.backgroundColor = '#D6D3CE'; } function selDown(ctrl) { ctrl.style.backgroundColor = '#8492B5'; } function selUp(ctrl) { ctrl.style.backgroundColor = '#B5BED6'; } function doBold() { iView.document.execCommand('bold', false, null); } function doItalic() { iView.document.execCommand('italic', false, null); } function doUnderline() { iView.document.execCommand('underline', false, null); } function doLeft() { iView.document.execCommand('justifyleft', false, null); } function doCenter() { iView.document.execCommand('justifycenter', false, null); } function doRight() { iView.document.execCommand('justifyright', false, null); } function doOrdList() { iView.document.execCommand('insertorderedlist', false, null); } function doBulList() { iView.document.execCommand('insertunorderedlist', false, null); } function doForeCol() { var fCol = prompt('Enter foreground color', ''); if(fCol != null) iView.document.execCommand('forecolor', false, fCol); } function doBackCol() { var bCol = prompt('Enter background color', ''); if(bCol != null) iView.document.execCommand('backcolor', false, bCol); } function doLink() { iView.document.execCommand('createlink'); } function doImage() { var imgSrc = prompt('Enter image location', ''); if(imgSrc != null) iView.document.execCommand('insertimage', false, imgSrc); } function doRule() { iView.document.execCommand('inserthorizontalrule', false, null); } function doFont(fName) { if(fName != '') iView.document.execCommand('fontname', false, fName); } function doSize(fSize) { if(fSize != '') iView.document.execCommand('fontsize', false, fSize); } function doHead(hType) { if(hType != '') { iView.document.execCommand('formatblock', false, hType); doFont(selFont.options[selFont.selectedIndex].value); } } function doToggleView() { if(viewMode == 1) { iHTML = iView.document.body.innerHTML; iView.document.body.innerText = iHTML; // Hide all controls tblCtrls.style.display = 'none'; selFont.style.display = 'none'; selSize.style.display = 'none'; selHeading.style.display = 'none'; iView.focus(); viewMode = 2; // Code } else { iText = iView.document.body.innerText; iView.document.body.innerHTML = iText; // Show all controls tblCtrls.style.display = 'inline'; selFont.style.display = 'inline'; selSize.style.display = 'inline'; selHeading.style.display = 'inline'; iView.focus(); viewMode = 1; // WYSIWYG } } /script style .butClass { border: 1px solid; border-color: #D6D3CE; } .tdClass { padding-left: 3px; padding-top:3px; } /style body > form ProcessNews() name=frmNews action="" method=post input type=hidden name=action value=addNews input type=hidden name=newsPost value= table width=415px height=30px border=0 cellspacing=0 cellpadding=0 bgcolor=#D6D3CE tr td width=10% height=30 class=title colspan=2 h2nbsp;Add News Post/h2 /td /tr tr td width=20% height=22 class=title p style=margin-left:5 Author: /p /td td width=80% height=22 class=title input type=text name=author maxlength=50 style=width:335px /td /tr tr td width=20% height=22 class=title p style=margin-left:5 Title: /p /td td width=80% input type=text name=title maxlength=50 style=width:335px /td /tr tr td width=20% height=22 class=title p style=margin-left:5 Topic(s): /p /td td width=80% height=22 input type=text name=topic maxlength=50
RE: FCKeditor Upload/Browse
Yes you can have the code, its freely available.Just download the tool and grab browse.cfm, browsefile.cfm (there is also a file browser that lets you link to stuff) as well as upload.cfm and uploadfile.cfm.These files are in the root folder. The files use some settings in /Application.cfm, notably the list of allowable MIME extensions (plain vanilla FCKEditor only does extension checking). The editor is in its own subfolder.Some of the .js files have been modified to allow the window resizing and scrollbar stuff I mentioned. I forget exactly which.Just copy the entire folder out. If you like, wait a bit and I'll update the tool with the v1.5 editor files. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: advice needed on multi-version data model design
Jochem, I am not sure this will work, since there are about 30 tables in the schema and each table has various relationships with one another.During the review process, the reviewer can quit anytime and maybe come back later to resume on it.Having said that, there are several starting points in the review process, meaning the reviewer could start out looking and making changes to the financial information page, which 3 or 4 pages down from the submiter's contact info page.By 'inserting new records' to the financial table right off the bat, I would get a database referential integrity error, because the financial table primary key ultimately traverses back up to the contact table.So I guess I don't see how by 'inserting new records' would work? Maybe you can help clarify further and I apologize if I didn't understandyour suggestion. Nick Han [EMAIL PROTECTED] 04/21/04 01:28AM Nick Han said: I am more interested in database design help.What I am thinking right now is right after the deadline, before the reviewer making changes, I dup the db schema and back that up, and the current schema will have the current data, including changes made by the reviewer. If there is dispute and I need to compare original version and edited version, I can toggle my variable that has the schema name? I think there is a better way: never update records :-) Instead of updating, insert a new record and timestamp it. If you just show the latest version as the working version in the frontend nobody knows the difference, but you can track all revisions in the background if you want to. (This is the same solution as Barney proposed, but with a slightly different angle on the explanation.) Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: BlueDragon in production?
Chris, You should post this question on the BlueDragon-Interest mailing list, you'll find many more BlueDragon users there than on this list: http://www.newatlanta.com/products/bluedragon/self_help/archive_search/index .cfm Of course, New Atlanta's web site is running on BlueDragon. So, yes, we trust our entire business to be running on BlueDragon. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 9:52 AM To: CF-Talk Subject: BlueDragon in production? I am looking at BlueDragon and would like to know who is using it for their production apps.Can you offer a brief evaluation?Stable?Fast?Any incompatibilites other than the unsupported tags mentioned in the docs?We are currently using CF5/Win2K/IIS/Oracle with client variables in a load-balanced environment.We want the equivalent, so I guess we would be looking at BD 3 for now. In short, do you trust BlueDragon for your production apps? Thanks, Chris -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 9:36 AM To: CF-Talk Subject: Re: CFMX for sale Tim, Sounds to me like you need BlueDragon. -adam -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 12:36 PM To: 'CF-Talk' Subject: RE: CFMX for sale I work for a non-profit senior care facility that has been trying to figure out how to come up with the cost of purchasing 6.1. Donating it to us would be a great compromise, wouldn't it??? -Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: FREE BD vs. $$$$ CF
Well, you could always buy BlueDragon Server JX, which at $549/server is still cheaper than upgrading to CFMX. As for the question, who is New Atlanta?, we've been in business selling server-side Java products since 1997. During that time, we've sold products to over 10,000 customers in 70 countries worldwide; here's a partial list: http://www.newatlanta.com/corporate/customers/index.jsp Regards, Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:29 AM To: CF-Talk Subject: FREE BD vs. CF The free BD vs CF comes down to politics in our organization. It was a struggle to get my employer to warm up to CF 4.5. I literally had to formally donate my copy, make an effective application, then beg for forgiveness instead of asking for permission. Slowly but surely, there were converts. Moving to 6.1 at this point means the cost of an upgrade ($600 or so). Moving to the free BD means a hard sell to management that we should make use of a product that is free. And, with the ironic comedy worthy of a Dilbert cartoon, management is quite steadfast in the opinion that taking a huge gamble with the sanctity of our data with a company like Macromedia at a cost of $600 is more prudent than the free route with the lesser known New Atlanta. The humor is that 4.5 (the version I demonstated with) was an Allaire product. New Atlanta vs Allaire, in the medical arena, is not exactly the makings of a big draw prizefight. Now, I could go through a long educational process that explains the pros and cons of going with a Macromedia vs a New Atlanta, but the $600 savings gets eaten away really quick by the time I prepare a presentation, bang my head on the walls of my cubicle, make enemies in IS for being a rebel, spend $$$ on Tylenol, etc. So, as painful as it might be for an organization such as ours to pony up the $600 for a CF upgrade, the relative cost of going with New Atlanta is not worth it. The name Macromedia garners enough recognition from management and the IT staff where they are at least willing to let me get the product onto the network. I can't afford to give up that credibility at the cost of $600. Is this a jab on my part against New Atlanta? Not at all. I am merely illustrating why, in MY CASE, $600 for CF is cheaper than $0 for BlueDragon. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: best CF host for 20 dollars a month
IMO your best bet is probably going to be crystaltech.net, though SQL Server is $27/mo Pete Wurst, Keith D. wrote: who does everyone think is the best CF host for 20 dollars a month. im hoping to get sql server access as well as host multiple domains (and create sub domains). thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: FREE BD vs. $$$$ CF
That's perfect. Now you can use BlueDragon/J2EE to redeploy all of your existing CFML applications to WebSphere. We can raise the price from the current $2500/CPU, if that'll keep your management happy.:-) Should I have an account rep contact you? Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:48 AM To: CF-Talk Subject: RE: FREE BD vs. CF This isn't all that odd. in my case the problem is similar, but comes from another end.My (very large) company won't consider either product because their both too cheap - and so (goes the management opinion) are not fit for enterprise use. We're not allowed to use open source software for the same reasons: free means no support' (which is bogus) and poor quality compared to enterprise vendors. Now wait for the punchline.What did this company decide to standardize on? What tool meets their criteria? IBM WebSphere on IBM Apache.So we end up spending many, MANY thousands of dollars on essentially branded open source software.(Which, has an aside, is so difficult to configure and learn that we've yet to produce any applications significantly better than our legacy CF 4.5 apps). Jim Davis _ From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:29 AM To: CF-Talk Subject: FREE BD vs. CF The free BD vs CF comes down to politics in our organization. It was a struggle to get my employer to warm up to CF 4.5. I literally had to formally donate my copy, make an effective application, then beg for forgiveness instead of asking for permission. Slowly but surely, there were converts. Moving to 6.1 at this point means the cost of an upgrade ($600 or so). Moving to the free BD means a hard sell to management that we should make use of a product that is free. And, with the ironic comedy worthy of a Dilbert cartoon, management is quite steadfast in the opinion that taking a huge gamble with the sanctity of our data with a company like Macromedia at a cost of $600 is more prudent than the free route with the lesser known New Atlanta. The humor is that 4.5 (the version I demonstated with) was an Allaire product. New Atlanta vs Allaire, in the medical arena, is not exactly the makings of a big draw prizefight. Now, I could go through a long educational process that explains the pros and cons of going with a Macromedia vs a New Atlanta, but the $600 savings gets eaten away really quick by the time I prepare a presentation, bang my head on the walls of my cubicle, make enemies in IS for being a rebel, spend $$$ on Tylenol, etc. So, as painful as it might be for an organization such as ours to pony up the $600 for a CF upgrade, the relative cost of going with New Atlanta is not worth it. The name Macromedia garners enough recognition from management and the IT staff where they are at least willing to let me get the product onto the network. I can't afford to give up that credibility at the cost of $600. Is this a jab on my part against New Atlanta? Not at all. I am merely illustrating why, in MY CASE, $600 for CF is cheaper than $0 for BlueDragon. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: WYSIWYG HTML Editors...
I've been using FCKeditor in several applications for over a year now.I find it lightweight and easy to use and configure ( I have about 4 different configurations depending on the complexity of the application). Walt -Original Message- From: Bailey, Neal [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 12:32 PM To: CF-Talk Subject: WYSIWYG HTML Editors... Hello... all I am looking for a good open source WYSIWYG HTML form field editor control thingy. Something like SPAW or FCKeditor, I guess a better question is which one of these is better or more stable. I need to implement one pretty fast but don't have a lot of time to research them all, so I thought I would consult the great collective wisdom of this list to help me decide on the right one to use. Let me know what you think of if there are any better, newer or more stable ones outthere. Thanks. Neal Bailey Internet Marketing Manager E-mail:II mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: advice needed on multi-version data model design
Your financial table shouldn't have a reference to a contact.It should have a reference to an application.That application should then have a reference to a contact.Then you can add an arbitrary number of records in the financial table without ever needing worry about the contactID's referential integrity. The application table is the abstraction layer between your multi-versioning system and the rest of your schema.Outside your application table, the rest of your DB needn't care if you have a single version of each app, or multiple versions of each individual page in the app. Cheers, barneyb -Original Message- From: Nick Han [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 9:58 AM To: CF-Talk Subject: Re: advice needed on multi-version data model design Jochem, I am not sure this will work, since there are about 30 tables in the schema and each table has various relationships with one another.During the review process, the reviewer can quit anytime and maybe come back later to resume on it. Having said that, there are several starting points in the review process, meaning the reviewer could start out looking and making changes to the financial information page, which 3 or 4 pages down from the submiter's contact info page.By 'inserting new records' to the financial table right off the bat, I would get a database referential integrity error, because the financial table primary key ultimately traverses back up to the contact table.So I guess I don't see how by 'inserting new records' would work? Maybe you can help clarify further and I apologize if I didn't understandyour suggestion. Nick Han [EMAIL PROTECTED] 04/21/04 01:28AM Nick Han said: I am more interested in database design help.What I am thinking right now is right after the deadline, before the reviewer making changes, I dup the db schema and back that up, and the current schema will have the current data, including changes made by the reviewer. If there is dispute and I need to compare original version and edited version, I can toggle my variable that has the schema name? I think there is a better way: never update records :-) Instead of updating, insert a new record and timestamp it. If you just show the latest version as the working version in the frontend nobody knows the difference, but you can track all revisions in the background if you want to. (This is the same solution as Barney proposed, but with a slightly different angle on the explanation.) Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: best CF host for 20 dollars a month
I thought MS SQL was licensed per processor.No reason you can't grossly over-subscribe a SQL server, just like some web hosts badly overload shared web servers. You're right though, that's a lot to ask for $20/month.Although in the php/MySQL world it's easily found.If you look hard enough you can even get half-decent service and support for that price. - Original Message - From: Doug White [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 9:48 AM Subject: Re: best CF host for 20 dollars a month You are sure asking for a lot for $20 bucks!:-) SQL server user licenses are not free, ya know, neither is the connectivity. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Dumping Local Vars Scope
Okay I'm brain cramping today so forgive the simple request - I'm working within a CF5 environment on an inherited application that has approximate 30 different files being cfincluded (depending on what the end user is doing) to create a single page (I don't know why the person wrote it this way) and would like to output the variables. scope to figure out what the H#LL this person was doing.There's somewhere near 100 local variables that are used throughout the creation of the page.Obviously [cfdump var=#variables#] doesn't work.Anyone have tag or section of code that does this?I've checked out 'MegaDump' but it doesn't output the variables. scope for CF5. Thanks in advance, Steven Semrau [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Site being blocked for content
Doug, Thanks.I was unrated and now have a shopping rating.This should fix the problem. Andy -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 8:09 PM To: CF-Talk Subject: Re: Site being blocked for content http://sitereview.cwfservice.net/sitereview.jsp == We can get rid of spam on your domain! , Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == - Original Message - From: Andy Ousterhout To: CF-Talk Sent: Tuesday, April 20, 2004 3:56 PM Subject: Site being blocked for content Somehow, our site, which only sells cookies, no nudity or profanity,is being blocked by at least one school system for content. Does anyone have a list of service providers that provide blocking services? I'd really like to find out who is blocking us and get us off of that list! Andy Ousterhout O'My Goodness www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL 60044 Phone 847.735.9890 Fax847.735.9910 Yahoo IM:andy_ousterhout [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dumping Local Vars Scope
I don't know how to answer your question, but it sounds like that they might have written it in FuseBox?That would explain all the files being included Ray http://www.crystalvision.org At 01:55 PM 4/21/2004, you wrote: Okay I'm brain cramping today so forgive the simple request - I'm working within a CF5 environment on an inherited application that has approximate 30 different files being cfincluded (depending on what the end user is doing) to create a single page (I don't know why the person wrote it this way) and would like to output the variables. scope to figure out what the H#LL this person was doing.There's somewhere near 100 local variables that are used throughout the creation of the page.Obviously [cfdump var=#variables#] doesn't work.Anyone have tag or section of code that does this?I've checked out 'MegaDump' but it doesn't output the variables. scope for CF5. Thanks in advance, Steven Semrau [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dumping Local Vars Scope
Go download cf_dump from the macromedia exchange. -- Timothy Heald Web Portfolio Manager Diplomatic Security U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have these opinions been approved or sanctioned by these organizations. This e-mail is unclassified based on the definitions in E.O. 12958. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 2:03 PM To: CF-Talk Subject: Re: Dumping Local Vars Scope I don't know how to answer your question, but it sounds like that they might have written it in FuseBox?That would explain all the files being included Ray http://www.crystalvision.org At 01:55 PM 4/21/2004, you wrote: Okay I'm brain cramping today so forgive the simple request - I'm working within a CF5 environment on an inherited application that has approximate 30 different files being cfincluded (depending on what the end user is doing) to create a single page (I don't know why the person wrote it this way) and would like to output the variables. scope to figure out what the H#LL this person was doing.There's somewhere near 100 local variables that are used throughout the creation of the page.Obviously [cfdump var=#variables#] doesn't work.Anyone have tag or section of code that does this?I've checked out 'MegaDump' but it doesn't output the variables. scope for CF5. Thanks in advance, Steven Semrau _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dumping Local Vars Scope
Hehe, I wish.It's definitely not FuseBox - from what I've heard (I came onto the project AFTER the developer left) this was his first CF application, leading me to believe he just got 'cfinclude' happy.Now I've taken the time to piece all the code together into 1 file (over 6,000 lines long) unfortunately Dreamweaver completely closes out whenever I try to load up the file.Argh.Iknow the latest version of DWMX should resolve this problem, however, I currently don't have the ability to update DWMX due to Pentagon network constraints. Steve -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 1:59 PM To: CF-Talk Subject: Re: Dumping Local Vars Scope I don't know how to answer your question, but it sounds like that they might have written it in FuseBox?That would explain all the files being included Ray http://www.crystalvision.org At 01:55 PM 4/21/2004, you wrote: Okay I'm brain cramping today so forgive the simple request - I'm working within a CF5 environment on an inherited application that has approximate 30 different files being cfincluded (depending on what the end user is doing) to create a single page (I don't know why the person wrote it this way) and would like to output the variables. scope to figure out what the H#LL this person was doing.There's somewhere near 100 local variables that are used throughout the creation of the page.Obviously [cfdump var=#variables#] doesn't work.Anyone have tag or section of code that does this?I've checked out 'MegaDump' but it doesn't output the variables. scope for CF5. Thanks in advance, Steven Semrau _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]