Re: Swfs not showing when CF is Connected
Yes, someone from then JRUN list suggsested the same thing and this did work. It is very odd however as there are 5 other cf instances on this server and they are all working fine and all still have the mapping in IIS. The only difference between this instance and the others is that it has more than one domain name mapped by the web connector. Do you think this is the reason it is behaving differently ? Another thing that is weird is that it had been working fine for the past 2 months and then suddenly stopped displaying the swfs this week after crashing repeatedly with cfoutput timeouts. I assume that it was the cfoutputs surrounding the swf object tag that were timing out until the server finally gave up on the swfs and then was working fine with the exception of the swfs no longer showing. Rich On 1/11/06, John C. Bland II [EMAIL PROTECTED] wrote: If you look at your site configuration (in IIS) you'll notice the .swf extension is mapped to CF. I had this same issue locally after flash forms came out. I believe I just deleted the .swf. Its been awhile so don't quote me on that one. On 1/11/06, Rich Tretola [EMAIL PROTECTED] wrote: OK here is our setup: JRun 4 with CFMX 6 under IIS Our issue is that as soon as we add a 2nd domain using the web connector, the server ignores all swfs. If we disconnect ColdFusion from IIS we can then browse to swfs again. has anyone seen anything like this ? Rich ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229307 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: eGovernment and Wiki's --- anyone making Wiki's with CF?
I've also played with Confluence and I think its awesome, shame its not written in CF Kola :) -Original Message- From: Geoff Bowers [mailto:[EMAIL PROTECTED] Sent: 11 January 2006 22:32 To: CF-Talk Subject: Re: eGovernment and Wiki's --- anyone making Wiki's with CF? On 1/12/06, Munson, Jacob [EMAIL PROTECTED] wrote: It sounds like you want a content management system rather than a wiki. The difference being you give people access to edit your content instead of a free-for-all system. Check out Farcry, an open source, CF based CMS. Personally I haven't tried it, but I did attend their demo at CFUnited 2005, and I was pretty impressed. Thanks for that :) Not our demo per se just an enthusiastic member of the community at CFUnited. Current link for FarCry community site: http://www.farcrycms.org/ I thought I might chime in to say I've been using a WIKI as an experiment for building developer documentation for the FarCry community. You can see our efforts here: http://bugs.farcrycms.org:8080/confluence/dashboard.action We tried this in FarCry initially but WIKI and CMS are not really equivalent. A wiki is a very niche sort of CMS; very interactive and very organis. And although I'm sure we could engineer FarCry to run in wiki mode I'm not sure about the return on investment given the multitude of specialist wiki engines out there. I'm a late convert to the WIKI seen.. but I quite like working with them once you get going. I think however you need the right content project and a community of wiki users ie people who know how it works or are prepared to learn -- this isn't the general public just yet. Navigational concepts get a bit blurry and its important that people who really do know what they are doing constantly keep pruning the wiki so to speak, otherwise it gets out of hand, and/or whithers and dies. We're using Confluence. Its Java and its commercial (unless you are an open source project) but its very much more sophisticated than the variety of other WIKIs I've tried to set up: http://www.atlassian.com/software/confluence/ If you are building wikis you wouldn't go far wrong trying to benchmark against Confluence's feature set -- it's really a great product. -- geoff http://www.daemon.com.au/ ~ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229308 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Swfs not showing when CF is Connected
I couldn't answer, really. Once I found the issue I could care less why it happened...as long as it was fixed. This was my local IIS so it wasn't a big deal to me...just very annoying. On 1/12/06, Rich Tretola [EMAIL PROTECTED] wrote: Yes, someone from then JRUN list suggsested the same thing and this did work. It is very odd however as there are 5 other cf instances on this server and they are all working fine and all still have the mapping in IIS. The only difference between this instance and the others is that it has more than one domain name mapped by the web connector. Do you think this is the reason it is behaving differently ? Another thing that is weird is that it had been working fine for the past 2 months and then suddenly stopped displaying the swfs this week after crashing repeatedly with cfoutput timeouts. I assume that it was the cfoutputs surrounding the swf object tag that were timing out until the server finally gave up on the swfs and then was working fine with the exception of the swfs no longer showing. Rich On 1/11/06, John C. Bland II [EMAIL PROTECTED] wrote: If you look at your site configuration (in IIS) you'll notice the .swf extension is mapped to CF. I had this same issue locally after flash forms came out. I believe I just deleted the .swf. Its been awhile so don't quote me on that one. On 1/11/06, Rich Tretola [EMAIL PROTECTED] wrote: OK here is our setup: JRun 4 with CFMX 6 under IIS Our issue is that as soon as we add a 2nd domain using the web connector, the server ignores all swfs. If we disconnect ColdFusion from IIS we can then browse to swfs again. has anyone seen anything like this ? Rich ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229309 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Slightly OT:Linux distro for CF Developers
Hi all, After many years, I decided to go back to school and finish my degree... One of my current classes is Linux + Certification and I am going to have a project. I was thinking that my project would be to create a Linux distro that had just the tools needed by ColdFusion developers to do their work. That being said, I have some questions for everyone on the list. Is there anyone out there that is using Linux as a CF Development environment? What software are you using to do it? What extra software do you use that might not be used directly for you coding but is needed to do your job? Is there a CF Developer Edition for Linux? (Of course I'm thinking with Linux that the editor would probably be Eclipse with the cfeclipse plug-in) I'm from an entirely Windows background, so this is going to be interesting. I'd also like to hear what Windows programs that developers just can't seem to be without. Maybe I can find Linux versions. Comments? Questions? I'd love to hear them. I'm also considering doing a Linux distro for Database Administrators so if you know of Linux software to manage MSSQL, Oracle, mySQL, etc I'd love to hear about those also! Steve Durette ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229310 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: (ot) tracert logging software
To append use tracert 84.43.72.133 mylog.txt To overwrite use tracert 84.43.72.133 mylog.txt -Original Message- From: FROEHLING, ROBERT (AIT) [mailto:[EMAIL PROTECTED] Sent: 11 January 2006 22:40 To: CF-Talk Subject: RE: (ot) tracert logging software Note that this will override the contents of mylog.txt each time. -Original Message- From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 11, 2006 4:32 PM To: CF-Talk Subject: RE: (ot) tracert logging software a batch file with: tracert 84.43.72.133 mylog.txt will result in a log file with: Tracing route to 84-43-72-133.ppp.onetel.net.uk [84.43.72.133] over a maximum of 30 hops: 11 ms1 ms1 ms 84-43-72-133.ppp.onetel.net.uk [84.43.72.133] Trace complete. -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: 11 January 2006 18:32 To: CF-Talk Subject: (ot) tracert logging software Does anyone know of an application that can schedule a network tracert every 15 minutes and then log that data to file or DB? Thanks ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229311 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Slightly OT:Linux distro for CF Developers
Hi Steven, You might be better to focus on the linux/coldfusion server distro vs. adding another desktop to a crouded environment. I was using linux for a bit and just had troubles since i couldn't get Macromedia apps to work.Post MX2004 I tried and had to revert back to windows. This was even post install of CodeWeavers Crossover Plugin. Problem here was a licencing script that runs in the background on Macromedia Products. You'll be hard pressed to put something together that would beat Ubuntu but if you can figure out how to get around that problem with Macromedia apps I'll make the switch. http://www.ubuntu.com http://www.kubuntu.org regards, Casey On 1/12/06, DURETTE, STEVEN J (AIT) [EMAIL PROTECTED] wrote: I was thinking that my project would be to create a Linux distro that had just the tools needed by ColdFusion developers to do their work. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229312 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Mail list archives
I'm looking for an out of the box coldfusion based application for storing and displaying mail list archives. I've looked at doing it myself and it ocurrs to me I am probably wasting my time creating an application that I'm sure must have been done before. I already have a mail list server and as this needs to integrate into a members area of a site I need it to fit into the existing security set up for controlled access. It also needs to be MS SQL based. If anyone has a product in mind, and even better with feedback from using it, I'd appreciate the info. Many thanks, Jenny ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229313 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Swfs not showing when CF is Connected
Did it actually crash your server or just not show the swfs ? Rich On 1/12/06, John C. Bland II [EMAIL PROTECTED] wrote: I couldn't answer, really. Once I found the issue I could care less why it happened...as long as it was fixed. This was my local IIS so it wasn't a big deal to me...just very annoying. On 1/12/06, Rich Tretola [EMAIL PROTECTED] wrote: Yes, someone from then JRUN list suggsested the same thing and this did work. It is very odd however as there are 5 other cf instances on this server and they are all working fine and all still have the mapping in IIS. The only difference between this instance and the others is that it has more than one domain name mapped by the web connector. Do you think this is the reason it is behaving differently ? Another thing that is weird is that it had been working fine for the past 2 months and then suddenly stopped displaying the swfs this week after crashing repeatedly with cfoutput timeouts. I assume that it was the cfoutputs surrounding the swf object tag that were timing out until the server finally gave up on the swfs and then was working fine with the exception of the swfs no longer showing. Rich On 1/11/06, John C. Bland II [EMAIL PROTECTED] wrote: If you look at your site configuration (in IIS) you'll notice the .swf extension is mapped to CF. I had this same issue locally after flash forms came out. I believe I just deleted the .swf. Its been awhile so don't quote me on that one. On 1/11/06, Rich Tretola [EMAIL PROTECTED] wrote: OK here is our setup: JRun 4 with CFMX 6 under IIS Our issue is that as soon as we add a 2nd domain using the web connector, the server ignores all swfs. If we disconnect ColdFusion from IIS we can then browse to swfs again. has anyone seen anything like this ? Rich ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229314 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Scripting DB records in enterprise manager
If you use Aqua Data studio, you can export the records in a cvs, then when you import them you can use it to generate the script files. It's good for when you have a product that you need to include the database creation along with the database records. http://www.aquafold.com/ Bob Everland ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229315 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF Blog Hosting
Looking for a very affordable (I'm still poor) CF Domain Hosting for a single domain with support for Ray's BlogCFC, MySQL 4.1x+, 5 or six IMAP mail accounts. Someplace I can eventually show off a small sample app or two. Any suggestions? Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229316 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Blog Hosting
Just a warning - do not do GoDaddy. They do not support createObject. (On the other hand, I _love_ GoDaddy for their DNS work, and their virtual server prices are good. You should see if that is cheap enough for you.) On 1/12/06, Cutter [EMAIL PROTECTED] wrote: Looking for a very affordable (I'm still poor) CF Domain Hosting for a single domain with support for Ray's BlogCFC, MySQL 4.1x+, 5 or six IMAP mail accounts. Someplace I can eventually show off a small sample app or two. Any suggestions? Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229317 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Blog Hosting
$20 Bluedragon / mySql virtual hosting http://www.viviotech.net/hosting.cfm dont know if it supports the blog tool Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com - Original Message - From: Cutter [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, January 12, 2006 1:59 PM Subject: CF Blog Hosting Looking for a very affordable (I'm still poor) CF Domain Hosting for a single domain with support for Ray's BlogCFC, MySQL 4.1x+, 5 or six IMAP mail accounts. Someplace I can eventually show off a small sample app or two. Any suggestions? Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229318 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Blog Hosting
The prices for DNS are great. I was hesitant to do any hosting with them though. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 9:07 AM To: CF-Talk Subject: Re: CF Blog Hosting Just a warning - do not do GoDaddy. They do not support createObject. (On the other hand, I _love_ GoDaddy for their DNS work, and their virtual server prices are good. You should see if that is cheap enough for you.) On 1/12/06, Cutter [EMAIL PROTECTED] wrote: Looking for a very affordable (I'm still poor) CF Domain Hosting for a single domain with support for Ray's BlogCFC, MySQL 4.1x+, 5 or six IMAP mail accounts. Someplace I can eventually show off a small sample app or two. Any suggestions? Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229319 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Query of query error
Does anyone know why a query of a query would return this error. The column was description, but I changed it to bobTest to make sure it wasn't a reserved word. Error Executing Database Query. Query Of Queries runtime error. Query Of Queries runtime error. Failed to get meta_data for columnissues.bobTest . on the left of the LIKE condition Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229320 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Blog Hosting
BlogCFC runs fine under BD - it just doesn't show the Print link. On 1/12/06, Paul Stewart [EMAIL PROTECTED] wrote: $20 Bluedragon / mySql virtual hosting http://www.viviotech.net/hosting.cfm dont know if it supports the blog tool -- === Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229321 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Free third party DNS hosting from godaddy
has anyone tried using the free DNS management from godaddy? They apparently let you manage dns records of outside domains without transferring them there (just pointing the nameserver to godaddy). I'm looking for a place that I could set up and manage domains at and my hosting company doesnt offer that Thanks NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229322 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query of query error
Can we see your code? -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: 12 January 2006 13:11 To: CF-Talk Subject: Query of query error Does anyone know why a query of a query would return this error. The column was description, but I changed it to bobTest to make sure it wasn't a reserved word. Error Executing Database Query. Query Of Queries runtime error. Query Of Queries runtime error. Failed to get meta_data for columnissues.bobTest . on the left of the LIKE condition Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229323 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query of query error
I'm just trying to integrate the new changes to lighthouse into the 6.1 version, nothing crazy. I did a dump of the query and it has the column in it cfquery name=issues dbtype=query select * fromissues where 1=1 cfif url.bugtype_filter is not cfset qs = qs bugtype_filter=#url.bugtype_filter# cfset form.filter = 1 and bugtype = cfqueryparam cfsqltype=cf_sql_varchar value=#url.bugtype_filter# /cfif cfif url.loci_filter is not cfset qs = qs loci_filter=#url.loci_filter# cfset form.filter = 1 and locusidfk = cfqueryparam cfsqltype=cf_sql_varchar value=#url.loci_filter# /cfif cfif url.severity_filter is not cfset qs = qs severity_filter=#url.severity_filter# cfset form.filter = 1 and severityidfk = cfqueryparam cfsqltype=cf_sql_varchar value=#url.severity_filter# /cfif cfif url.status_filter is not cfset qs = qs status_filter=#url.status_filter# cfset form.filter = 1 and statusidfk = cfqueryparam cfsqltype=cf_sql_varchar value=#url.status_filter# /cfif cfif url.owner_filter is not cfset qs = qs owner_filter=#url.owner_filter# cfset form.filter = 1 and useridfk = cfqueryparam cfsqltype=cf_sql_varchar value=#url.owner_filter# /cfif cfif url.keyword_filter is not cfset qs = qs keyword_filter=#url.keyword_filter# cfset form.filter = 1 and (upper(name) like cfqueryparam cfsqltype=cf_sql_varchar value=%#uCase(url.keyword_filter)#% or upper(description) like cfqueryparam cfsqltype=cf_sql_varchar value=%#uCase(url.keyword_filter)#%) /cfif /cfquery ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229324 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Blog Hosting
If you want cheap or free and it's non commercial, try www.cfdeveloper.co.uk -Original Message- From: Cutter [mailto:[EMAIL PROTECTED] Sent: 12 January 2006 14:00 To: CF-Talk Subject: CF Blog Hosting Looking for a very affordable (I'm still poor) CF Domain Hosting for a single domain with support for Ray's BlogCFC, MySQL 4.1x+, 5 or six IMAP mail accounts. Someplace I can eventually show off a small sample app or two. Any suggestions? Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229325 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Blog Hosting
U can't blame them. If you do support createobject you are creating a potential security nightmare with people able to hack into the cfadmin and do all kinds of nasty things with java such as steal other sites session data or get into their application variables and steal database usernames and password etc. Russ -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 12 January 2006 14:07 To: CF-Talk Subject: Re: CF Blog Hosting Just a warning - do not do GoDaddy. They do not support createObject. (On the other hand, I _love_ GoDaddy for their DNS work, and their virtual server prices are good. You should see if that is cheap enough for you.) On 1/12/06, Cutter [EMAIL PROTECTED] wrote: Looking for a very affordable (I'm still poor) CF Domain Hosting for a single domain with support for Ray's BlogCFC, MySQL 4.1x+, 5 or six IMAP mail accounts. Someplace I can eventually show off a small sample app or two. Any suggestions? Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229326 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfform type=xml class_cfLabelPosRight
any tips about xml-forms (skins etc) - tutorials/doku? -- Sebastian Mork [EMAIL PROTECTED] -- On Wed, 11 Jan 2006 16:09:12 +0100 Sebastian Mork [EMAIL PROTECTED] wrote: Hi, In my last app I used flash-forms, now I'm developing a new application and I arrived at that point I need to create the first forms. Well, now I want to use xml-Forms and made the first test modifying the system-styles (e.g. blue_style.css, blue.xsl) I've read the article from Mike Nimer (http://www.macromedia.com/de/devnet/coldfusion/articles/richforms_05.html) about that topic... So, using xforms might be a reason, as he wrote, to learn about xsl.. I googled to find some kind of tutorial using cfforms xml-forms but didn't find any good sources. Does anyone know some? Another question.. in my first tests I created a simple form (code below) and used a cfformgroup-tag with type=vertical, to align some input-fields vertically. Now, why does the first table-cell with the laber for the input 'emailsender' gets the class 'cfLabelPosRight'? (confused) thx sebastian code: cfform format=xml action= id=formtaf skin=blue cfformgroup type=fieldset label=Artikel weiterempfehlen cfformgroup type=vertical cfinput type=text name=emailsender label=Absender validate=email size=20 maxlength=100 required=true message=Bitte geben Sie eine gültige Absender-Email-Adresse ein. / cfinput type=text name=emailreceiver label=Empfänger validate=email size=20 maxlength=100 required=true message=Bitte geben Sie eine gültige Absender-Email-Adresse ein. / cftextarea name=test rows=5 cols=66 label=Mitteilung / /cfformgroup /cfformgroup /cfform generated code (without script): link href=/CFIDE/scripts/css/blue_style.css rel=stylesheet type=text/css media=all/ div class=cfform form id=formtaf action=/memocity/index.cfm?event=prodtafamp;pid=1771 method=post onsubmit=return _CF_checkCFForm_1(this); class=cfHaloSkin name=CFForm_1 table border=0 cellpadding=2 cellspacing=0 width=100% class=vertical tr td colspan=2 fieldset legendArtikel weiterempfehlen/legend table border=0 cellpadding=2 cellspacing=0 width=100% class=vertical tr class=cfElementRow !--- | HERE APPEARS THE CLASS: cfLabelPosRight --- td valign=top align=right width=100 class=cfLabelTitle cfLabelPosRight cfFirstChild nowrap=nowrap label for=emailsender class=cfRequiredLabel span class=cfRequiredLabelIndicator* /spanAbsender/label /td td width=1000 align=left input id=emailsender name=emailsender class=cfInput cfRequiredElement value= type=text maxlength=100 size=20/ /td /tr tr class=cfElementRow td valign=top align=right width=100 class=cfLabelTitle cfLabelPosRight cfFirstChild nowrap=nowrap label for=emailreceiver class=cfRequiredLabel span class=cfRequiredLabelIndicator* /spanEmpfänger/label /td td width=1000 align=left input id=emailreceiver name=emailreceiver class=cfInput cfRequiredElement value= type=text maxlength=100 size=20/ /td /tr tr class=cfElementRow td colspan=2 valign=top align=left class=cfLabelTitle cfLabelPosTop nowrap=nowrap label for=testMitteilung/label /td /tr tr td colspan=2 width=100% align=left textarea id=test name=test class=cfTextarea rows=5 cols=66 /textarea /td /tr tr td br/ /td /tr /table /fieldset /td /tr tr td br/ /td /tr /table /form /div -- Sebastian Mork [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229327 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Calculate schedule timeslots
I am sure that I saw something a while back that may address the issue I have. I have a scheduler that has time slots in increments of 15 minutes. What I need to do is to be able to exclude time slots that have already been allocated. For example I have start and end time dropdown lists so a user can select a time slot as follows; Start time : 11:45 AM Finish Time : 12:45PM Once this time slot has been allocated I need to be able to exclude this range from both of dropdown list i.e. Start time will now look as follows 11:30AM 01:00PM End time will be same. I already have the logic to ensure that the start and end time are not the same and also that the end time is after the start time but I am struggling to figure out how edit my dropdowns on the fly as time slots are allocated. Anybody help? Maybe a more simple method would be to only initially populate the start time dropdown and use the onchange method to populate the end time box? Would this be easier do you think? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229328 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Detecting if a Verity Collection Exists in CFMX7...
I'm need to detect if a collection exists and if it doesn't, then I need to create the collection. In previous versions of CF, if you performed the cfcollection action=create / on a collection it would throw an error. This meant you could just wrap the code in a cftry and than use a cfcatch to skip processing. In CFMX7 they've added a cfcollection action=list / to retrieve all the collections which you can use to see if a collection exists. The problem is, cfcollection / is taking 20+ seconds to run--which is way too long. Is there a faster way to determine if a collection exists? I know I could check for the directory, but this doesn't really confirm if the collection is actually registered. -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229329 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Scripting DB records in enterprise manager
Mike, If this is something that you need to do often, or need to keep those two databases in synch, I would definitely check out the sql-compare and sql-datacompare tools from redgate... http://www.red-gate.com/ They are a bit pricey, but they can save you a lot of time and headache. -jim On 1/11/06, Mike | NZSolutions Ltd [EMAIL PROTECTED] wrote: hi guys, I need to duplicate some existing tables to a new SQL database. i am trying to script my sql server db, and include all records - not just the table structure. i am using the generate SQL script tool, but cannot seem to include the records. does anyone know what i am not doing? Regards Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229330 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Slightly OT:Linux distro for CF Developers
Actually what I was hoping to do was when it was all said and done, the whole thing would fit on a usb drive. Then you walk up to a workstation/pc/etc. Boot from the usb and work with your files on the usb (no need to really touch the hard drive). An entirely portable development environment. I just wanted to start with a regular distro until I get more proficient. That's why I wanted a list of software that most cf/web developers just can't live without. I want it to be able to do anything that might be needed. The absolute basics that I was thinking of were: Eclipse with the cfeclipse plug-in (any body know of any other good plug-ins for web developers that I might want to include?) FireFox for web browsing Thunderbird for e-mail I'm not sure if flowcharting would be useful to the average cf developer (I use Visio) but if so does anyone know of Linux flow charters? In the end, I'm hoping that all of the software will be totally free. (remember I said cf developer edition not server) Steve -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 7:17 AM To: CF-Talk Subject: Re: Slightly OT:Linux distro for CF Developers Hi Steven, You might be better to focus on the linux/coldfusion server distro vs. adding another desktop to a crouded environment. I was using linux for a bit and just had troubles since i couldn't get Macromedia apps to work.Post MX2004 I tried and had to revert back to windows. This was even post install of CodeWeavers Crossover Plugin. Problem here was a licencing script that runs in the background on Macromedia Products. You'll be hard pressed to put something together that would beat Ubuntu but if you can figure out how to get around that problem with Macromedia apps I'll make the switch. http://www.ubuntu.com http://www.kubuntu.org regards, Casey On 1/12/06, DURETTE, STEVEN J (AIT) [EMAIL PROTECTED] wrote: I was thinking that my project would be to create a Linux distro that had just the tools needed by ColdFusion developers to do their work. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229331 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: eGovernment and Wiki's --- anyone making Wiki's with CF?
Sounds like a new Open Source CF project for somebody... [EMAIL PROTECTED] wrote: I've also played with Confluence and I think its awesome, shame its not written in CF Kola :) -Original Message- From: Geoff Bowers [mailto:[EMAIL PROTECTED] Sent: 11 January 2006 22:32 To: CF-Talk Subject: Re: eGovernment and Wiki's --- anyone making Wiki's with CF? On 1/12/06, Munson, Jacob [EMAIL PROTECTED] wrote: It sounds like you want a content management system rather than a wiki. The difference being you give people access to edit your content instead of a free-for-all system. Check out Farcry, an open source, CF based CMS. Personally I haven't tried it, but I did attend their demo at CFUnited 2005, and I was pretty impressed. Thanks for that :) Not our demo per se just an enthusiastic member of the community at CFUnited. Current link for FarCry community site: http://www.farcrycms.org/ I thought I might chime in to say I've been using a WIKI as an experiment for building developer documentation for the FarCry community. You can see our efforts here: http://bugs.farcrycms.org:8080/confluence/dashboard.action We tried this in FarCry initially but WIKI and CMS are not really equivalent. A wiki is a very niche sort of CMS; very interactive and very organis. And although I'm sure we could engineer FarCry to run in wiki mode I'm not sure about the return on investment given the multitude of specialist wiki engines out there. I'm a late convert to the WIKI seen.. but I quite like working with them once you get going. I think however you need the right content project and a community of wiki users ie people who know how it works or are prepared to learn -- this isn't the general public just yet. Navigational concepts get a bit blurry and its important that people who really do know what they are doing constantly keep pruning the wiki so to speak, otherwise it gets out of hand, and/or whithers and dies. We're using Confluence. Its Java and its commercial (unless you are an open source project) but its very much more sophisticated than the variety of other WIKIs I've tried to set up: http://www.atlassian.com/software/confluence/ If you are building wikis you wouldn't go far wrong trying to benchmark against Confluence's feature set -- it's really a great product. -- geoff http://www.daemon.com.au/ ~ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229332 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Slightly OT:Linux distro for CF Developers
You could include an option to install a cf server, since you can't run or debug without the server. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229333 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Slightly OT:Linux distro for CF Developers
but you could FTP it to one ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 9:28 AM To: CF-Talk Subject: Re: Slightly OT:Linux distro for CF Developers You could include an option to install a cf server, since you can't run or debug without the server. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229334 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Slightly OT:Linux distro for CF Developers
I was planning on having the cfmx 7 developer edition as an install option if it works on Linux. This may just be for me when all is said and done, but if I can get the ok from Adobe (for the cf dev edition) I might release it. Or I might just give an option in the install that goes out to Adobe/Macromedia and downloads the dev edition (have to check if that's legal). I'm just in the planning stages right now. The first class was last night and we will be getting more indepth creating or using existing distros to do specifically what is needed. -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 9:28 AM To: CF-Talk Subject: Re: Slightly OT:Linux distro for CF Developers You could include an option to install a cf server, since you can't run or debug without the server. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229335 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: I don't know if this is even possible
Jared Smith of WebAIM (Web Accessibility in Mind) just came out with Part 1 of an article series talking about Ajax and its accessibility. Part one is basically an overview, but it does contain links to other resources. http://webaim.org/techniques/ajax/ I'm still out on it, especially since as he points out, the WCAG 1.0 does require that pages function correctly without Javascript. Sandra Clark -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 8:42 PM To: CF-Talk Subject: Re: I don't know if this is even possible Rubbish. I tested all of my stuff in FF pre 1.5 and IE 6, months ago - all of the new links I was writing to the screen (via AJAX) read out perfectly in all 3 screen readers I tested. The links were not in a form. On 1/11/06, Sandra Clark [EMAIL PROTECTED] wrote: The problem is that up until Firefox 1.5 dHTML is not totally accessible by screen readers. Most screen readers can handle some javascript, but not any screen changes after a body onload(). Thus any dHTML changes to the screen will not be noticeable to screen readers. If a user is in a forms mode, it might work in some screen readers, but its not across the board. And if you aren't talking about a form, but changing the screen, thats where the problems come in. Ajax is not inherently inaccessible, its the way of presenting the information (dHTML and Javascript changes to the client screen) that are problematic. FireFox 1.5 has incorporated a newer version of Javascript (think Web 2.0) which when combined with Window-eyes actually created accessible javascript. I saw a demo by IBM at the CSUN accessibility conference last March. Unfortunately most disabled users are using a combination of IE and Jaws, neither of which supports it. -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229336 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Slightly OT:Linux distro for CF Developers
You're assuming that the computer they run the usb drive off of is able to get to the internet. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229337 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Encapsulate persistent variables
Hi, Is there a way to encapsulate and hide the cflocking of persistent variables? For example, in my app I would like to do: PersistentVariables.CustomerObj.Update() Instead of: cflock Session.CustomerObj.Update() /cflock Basically the PersistentVariables CFC stores and manages all persistent variables and locking. Thanks, Baz ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229338 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: eGovernment and Wiki's --- anyone making Wiki's with CF?
There is one (farcry), read earlier in this email for the link. (I'm assuming you meant open source CMS) -Original Message- From: Cutter (CF-Talk) Sounds like a new Open Source CF project for somebody... [EMAIL PROTECTED] wrote: I've also played with Confluence and I think its awesome, shame its not written in CF -Original Message- From: Geoff Bowers On 1/12/06, Munson, Jacob [EMAIL PROTECTED] wrote: It sounds like you want a content management system rather than a wiki. The difference being you give people access to edit your content instead of a free-for-all system. Check out Farcry, an open source, CF based CMS. Personally I haven't tried it, but I did attend their demo at CFUnited 2005, and I was pretty impressed. Thanks for that :) Not our demo per se just an enthusiastic member of the community at CFUnited. Current link for FarCry community site: http://www.farcrycms.org/ [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229339 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Detecting if a Verity Collection Exists in CFMX7...
admin API perhaps? john. On 1/12/06, Dan G. Switzer, II [EMAIL PROTECTED] wrote: I'm need to detect if a collection exists and if it doesn't, then I need to create the collection. In previous versions of CF, if you performed the cfcollection action=create / on a collection it would throw an error. This meant you could just wrap the code in a cftry and than use a cfcatch to skip processing. In CFMX7 they've added a cfcollection action=list / to retrieve all the collections which you can use to see if a collection exists. The problem is, cfcollection / is taking 20+ seconds to run--which is way too long. Is there a faster way to determine if a collection exists? I know I could check for the directory, but this doesn't really confirm if the collection is actually registered. -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229340 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Slightly OT:Linux distro for CF Developers
Well, If there are no legal problems with including the developer edition with the distro, then it would be totally self-sufficient storing all the data (cfm files, etc) on the usb drive. The extra software like Thunderbird would be for IF you had an internet connection. Steve -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 9:40 AM To: CF-Talk Subject: Re: Slightly OT:Linux distro for CF Developers You're assuming that the computer they run the usb drive off of is able to get to the internet. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229341 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Slightly OT:Linux distro for CF Developers
I have never had much luck trying to get Windows software to run on Linux. Some things go Ok, but some don't. If one wants to move to Linux (or just try it), one is better off forgetting about their favorite software from the Windows world, unless they have a Linux version. That said, there /are/ a ton of good Linux replacements for popular Windows software. Graphics? The Gimp. Multimedia player? MPlayer. Games? Sorry, out of luck. ;) Actually there are a lot of really good games for Linux, but you have to be open minded. Don't say, I want to play WarCraft III on Linux but say I want a good RTS game for Linux. Once you start thinking that way, a whole world opens up. You start checking sites like http://www.sourceforge.net/ http://www.freshmeat.net/ http://www.happypenguin.org/ And you discover a ton of really great, production quality software (or close to it) to do exactly what you need. And most of it was built FOR Linux, not ported TO Linux. -Original Message- From: Casey Dougall Hi Steven, You might be better to focus on the linux/coldfusion server distro vs. adding another desktop to a crouded environment. I was using linux for a bit and just had troubles since i couldn't get Macromedia apps to work.Post MX2004 I tried and had to revert back to windows. This was even post install of CodeWeavers Crossover Plugin. Problem here was a licencing script that runs in the background on Macromedia Products. You'll be hard pressed to put something together that would beat Ubuntu but if you can figure out how to get around that problem with Macromedia apps I'll make the switch. http://www.ubuntu.com http://www.kubuntu.org On 1/12/06, DURETTE, STEVEN J wrote: I was thinking that my project would be to create a Linux distro that had just the tools needed by ColdFusion developers to do their work. [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229342 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Slightly OT:Linux distro for CF Developers
As far as a specific distro, you might use Red Hat or Fedora (Red Hat's bleeding edge). Why? Because Steven Erat, one of Macromedia's support guys, has a LOT of excellent information for using CF with Red Hat. Search his blog for Linux and you will find a lot of good information. Because you will most likely run into problems getting CF to work, but Steven has fixes posted for most everything you'll run into. Personally I'd prefer not to use Fedora/Red Hat, but since there is such a wealth of information for Red Hat/CF, I'd probably go that route. Also, search the archives of the Online CF Meetup group, because there were one or two presentations by Steven that cover using CF in Linux. Sorry I didn't grab any links for you, but that's what Google's for, right? ;) -Original Message- From: DURETTE, STEVEN J Hi all, After many years, I decided to go back to school and finish my degree... One of my current classes is Linux + Certification and I am going to have a project. I was thinking that my project would be to create a Linux distro that had just the tools needed by ColdFusion developers to do their work. That being said, I have some questions for everyone on the list. Is there anyone out there that is using Linux as a CF Development environment? What software are you using to do it? What extra software do you use that might not be used directly for you coding but is needed to do your job? Is there a CF Developer Edition for Linux? (Of course I'm thinking with Linux that the editor would probably be Eclipse with the cfeclipse plug-in) I'm from an entirely Windows background, so this is going to be interesting. I'd also like to hear what Windows programs that developers just can't seem to be without. Maybe I can find Linux versions. Comments? Questions? I'd love to hear them. I'm also considering doing a Linux distro for Database Administrators so if you know of Linux software to manage MSSQL, Oracle, mySQL, etc I'd love to hear about those also! This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229343 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Slightly OT:Linux distro for CF Developers
Hi Steve, I admire someone as open-minded as you. The desire to learn new things and try new ways of doing things is an attribute that deserves respect. I'm a linux man myself. I'm currently writing you from a SuSE Linux system and I'd recommend SuSE Linux for both your server and PC environment - as that's what I do myself. There are other great distro's out there, but SuSE is widely supported in both servers and desktops and I find that makes my life easier most times. SuSE 10 can also be downloaded for free at www.opensuse.org. What's more, Macromedia/Adobe officially supports it as a server environment. I don't know if the developer edition works on Linux, but I know the Server works great on it. The viviotech.net web site is a SuSE server. For an IDE, I'd highly recommend the Eclipse/CFEclipse combo. It takes a little getting used to, but so did dreamweaver when you first started using it. ;) For FTP, I use the KBear client that comes with OpenSuSE. It reminds me of what I used to do with CFStudio and WS_FTP LE back in the day. Again, it'll take a little getting used to when you first get into it, but once you're familiar with it it's pretty slick. Hope this helps! Warm regards, Jordan Michaels Vivio Technologies DURETTE, STEVEN J (AIT) wrote: Hi all, After many years, I decided to go back to school and finish my degree... One of my current classes is Linux + Certification and I am going to have a project. I was thinking that my project would be to create a Linux distro that had just the tools needed by ColdFusion developers to do their work. That being said, I have some questions for everyone on the list. Is there anyone out there that is using Linux as a CF Development environment? What software are you using to do it? What extra software do you use that might not be used directly for you coding but is needed to do your job? Is there a CF Developer Edition for Linux? (Of course I'm thinking with Linux that the editor would probably be Eclipse with the cfeclipse plug-in) I'm from an entirely Windows background, so this is going to be interesting. I'd also like to hear what Windows programs that developers just can't seem to be without. Maybe I can find Linux versions. Comments? Questions? I'd love to hear them. I'm also considering doing a Linux distro for Database Administrators so if you know of Linux software to manage MSSQL, Oracle, mySQL, etc I'd love to hear about those also! Steve Durette ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229344 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Scripting DB records in enterprise manager
There is also a stored procedure that was written and I have used extensively if you do not want to pay for Red-Gate. http://vyaskn.tripod.com/code/generate_inserts.txt This will script the inserts and will also set the identity Off and then Back on... You can take all these insert statements and paste them at the end of you CREATE tables and keys statements. Vance -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 8:58 AM To: CF-Talk Subject: Re: Scripting DB records in enterprise manager Mike, If this is something that you need to do often, or need to keep those two databases in synch, I would definitely check out the sql-compare and sql-datacompare tools from redgate... http://www.red-gate.com/ They are a bit pricey, but they can save you a lot of time and headache. -jim On 1/11/06, Mike | NZSolutions Ltd [EMAIL PROTECTED] wrote: hi guys, I need to duplicate some existing tables to a new SQL database. i am trying to script my sql server db, and include all records - not just the table structure. i am using the generate SQL script tool, but cannot seem to include the records. does anyone know what i am not doing? Regards Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229345 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Slightly OT:Linux distro for CF Developers
I like Redhat Fedora myself. As far as CFEclipse, it has an ftp client built in, although I don't think they've worked all the bugs out yet... And it doesn't support secure FTP afaik, but it's better then nothing. -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 11:29 AM To: CF-Talk Subject: Re: Slightly OT:Linux distro for CF Developers Hi Steve, I admire someone as open-minded as you. The desire to learn new things and try new ways of doing things is an attribute that deserves respect. I'm a linux man myself. I'm currently writing you from a SuSE Linux system and I'd recommend SuSE Linux for both your server and PC environment - as that's what I do myself. There are other great distro's out there, but SuSE is widely supported in both servers and desktops and I find that makes my life easier most times. SuSE 10 can also be downloaded for free at www.opensuse.org. What's more, Macromedia/Adobe officially supports it as a server environment. I don't know if the developer edition works on Linux, but I know the Server works great on it. The viviotech.net web site is a SuSE server. For an IDE, I'd highly recommend the Eclipse/CFEclipse combo. It takes a little getting used to, but so did dreamweaver when you first started using it. ;) For FTP, I use the KBear client that comes with OpenSuSE. It reminds me of what I used to do with CFStudio and WS_FTP LE back in the day. Again, it'll take a little getting used to when you first get into it, but once you're familiar with it it's pretty slick. Hope this helps! Warm regards, Jordan Michaels Vivio Technologies DURETTE, STEVEN J (AIT) wrote: Hi all, After many years, I decided to go back to school and finish my degree... One of my current classes is Linux + Certification and I am going to have a project. I was thinking that my project would be to create a Linux distro that had just the tools needed by ColdFusion developers to do their work. That being said, I have some questions for everyone on the list. Is there anyone out there that is using Linux as a CF Development environment? What software are you using to do it? What extra software do you use that might not be used directly for you coding but is needed to do your job? Is there a CF Developer Edition for Linux? (Of course I'm thinking with Linux that the editor would probably be Eclipse with the cfeclipse plug-in) I'm from an entirely Windows background, so this is going to be interesting. I'd also like to hear what Windows programs that developers just can't seem to be without. Maybe I can find Linux versions. Comments? Questions? I'd love to hear them. I'm also considering doing a Linux distro for Database Administrators so if you know of Linux software to manage MSSQL, Oracle, mySQL, etc I'd love to hear about those also! Steve Durette ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229346 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Scripting DB records in enterprise manager
+1 on that recommendation, I'm currently using it to synch schemas and data on some large tables and it works great! Kola -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: 12 January 2006 14:58 To: CF-Talk Subject: Re: Scripting DB records in enterprise manager Mike, If this is something that you need to do often, or need to keep those two databases in synch, I would definitely check out the sql-compare and sql-datacompare tools from redgate... http://www.red-gate.com/ They are a bit pricey, but they can save you a lot of time and headache. -jim On 1/11/06, Mike | NZSolutions Ltd [EMAIL PROTECTED] wrote: hi guys, I need to duplicate some existing tables to a new SQL database. i am trying to script my sql server db, and include all records - not just the table structure. i am using the generate SQL script tool, but cannot seem to include the records. does anyone know what i am not doing? Regards Mike ~ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229347 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Scripting DB records in enterprise manager
Why not just backup the db or use DTS to transfer the tables and data? -Original Message- From: Vance M. Duke [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 11:33 AM To: CF-Talk Subject: RE: Scripting DB records in enterprise manager There is also a stored procedure that was written and I have used extensively if you do not want to pay for Red-Gate. http://vyaskn.tripod.com/code/generate_inserts.txt This will script the inserts and will also set the identity Off and then Back on... You can take all these insert statements and paste them at the end of you CREATE tables and keys statements. Vance -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 8:58 AM To: CF-Talk Subject: Re: Scripting DB records in enterprise manager Mike, If this is something that you need to do often, or need to keep those two databases in synch, I would definitely check out the sql-compare and sql-datacompare tools from redgate... http://www.red-gate.com/ They are a bit pricey, but they can save you a lot of time and headache. -jim On 1/11/06, Mike | NZSolutions Ltd [EMAIL PROTECTED] wrote: hi guys, I need to duplicate some existing tables to a new SQL database. i am trying to script my sql server db, and include all records - not just the table structure. i am using the generate SQL script tool, but cannot seem to include the records. does anyone know what i am not doing? Regards Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229348 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encapsulate persistent variables
Bazlocking is not required on version 6 or higherin CF Admin you can set CF to auto-lock those scopes. Hope you're on 6 or higher ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229349 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encapsulate persistent variables
DOH!...and you obviouslky are on 6 or higher if you're using CFCs...hehe Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229350 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Encapsulate persistent variables
I'm on MX7, so it should be fine, but what about race conditions? Those can easily occur no? People don't lock their shopping carts in MX7? What about application scope vars, that's race-condition central.. Baz -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 11:43 AM To: CF-Talk Subject: Re: Encapsulate persistent variables Bazlocking is not required on version 6 or higherin CF Admin you can set CF to auto-lock those scopes. Hope you're on 6 or higher ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229351 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Time zone issue
I am running CF MX 7.01 on linux. My time zone in telnet (both os and hardware) is set to CST, but the now() function returns EST. WHY??? I can't find any setting in cf admin to change the time zone. ~Brad ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229352 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Time zone issue
Oh yeah, when I run cfset tz = CreateObject(java, java.util.TimeZone) cfset tz = tz.getDefault() cfoutputTimeZone: #tz.getDisplayName()# (#tz.getID()#)/cfoutput It says I am in the America/New_York time zone. Is this from java? How do I change? -Original Message- From: Brad Wood Sent: Thursday, January 12, 2006 10:55 AM To: CF-Talk Subject: Time zone issue I am running CF MX 7.01 on linux. My time zone in telnet (both os and hardware) is set to CST, but the now() function returns EST. WHY??? I can't find any setting in cf admin to change the time zone. ~Brad ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229353 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Slightly OT:Linux distro for CF Developers
No, they haven't worked the bugs out of the built-in FTP client yet. Hence my use of KBear for FTP. I'll happily use the built-in FTP client once it works well enough to be dependable. ;) -JM Russ wrote: I like Redhat Fedora myself. As far as CFEclipse, it has an ftp client built in, although I don't think they've worked all the bugs out yet... And it doesn't support secure FTP afaik, but it's better then nothing. -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 11:29 AM To: CF-Talk Subject: Re: Slightly OT:Linux distro for CF Developers Hi Steve, I admire someone as open-minded as you. The desire to learn new things and try new ways of doing things is an attribute that deserves respect. I'm a linux man myself. I'm currently writing you from a SuSE Linux system and I'd recommend SuSE Linux for both your server and PC environment - as that's what I do myself. There are other great distro's out there, but SuSE is widely supported in both servers and desktops and I find that makes my life easier most times. SuSE 10 can also be downloaded for free at www.opensuse.org. What's more, Macromedia/Adobe officially supports it as a server environment. I don't know if the developer edition works on Linux, but I know the Server works great on it. The viviotech.net web site is a SuSE server. For an IDE, I'd highly recommend the Eclipse/CFEclipse combo. It takes a little getting used to, but so did dreamweaver when you first started using it. ;) For FTP, I use the KBear client that comes with OpenSuSE. It reminds me of what I used to do with CFStudio and WS_FTP LE back in the day. Again, it'll take a little getting used to when you first get into it, but once you're familiar with it it's pretty slick. Hope this helps! Warm regards, Jordan Michaels Vivio Technologies DURETTE, STEVEN J (AIT) wrote: Hi all, After many years, I decided to go back to school and finish my degree... One of my current classes is Linux + Certification and I am going to have a project. I was thinking that my project would be to create a Linux distro that had just the tools needed by ColdFusion developers to do their work. That being said, I have some questions for everyone on the list. Is there anyone out there that is using Linux as a CF Development environment? What software are you using to do it? What extra software do you use that might not be used directly for you coding but is needed to do your job? Is there a CF Developer Edition for Linux? (Of course I'm thinking with Linux that the editor would probably be Eclipse with the cfeclipse plug-in) I'm from an entirely Windows background, so this is going to be interesting. I'd also like to hear what Windows programs that developers just can't seem to be without. Maybe I can find Linux versions. Comments? Questions? I'd love to hear them. I'm also considering doing a Linux distro for Database Administrators so if you know of Linux software to manage MSSQL, Oracle, mySQL, etc I'd love to hear about those also! Steve Durette ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229354 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encapsulate persistent variables
I'm on MX7, so it should be fine, but what about race conditions? Those can easily occur no? People don't lock their shopping carts in MX7? What about application scope vars, that's race-condition central.. Baz appliocation/session/server scopes are all handled automatically Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229355 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: eGovernment and Wiki's --- anyone making Wiki's with CF?
The way I think of it is that most CMS are designed around the idea of structured, categorized content. A wiki tends to be more pure hypertext in that it's not so much categorized as cross-linked. Those are really broad oversimplifications, and a CMS can certainly be designed to be wiki-like but a wiki can't be anything but a wiki. --- Kevin Graeme Cooperative Extension Technology Services University of Wisconsin-Extension I really don't see how this differs from any other public or semi-private CMS system, which employs access control among a group of users. I build this type all the time. I guess a CMS by any other name is still just a CMS... Is it just in how wiki's are built that distinguishes them? (I guess I just need to spend some time working on a wiki...) Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229356 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Time zone issue
Brad Wood wrote: Is this from java? How do I change? yes that's from the JVM. if it's a shared host, you probably won't be allowed if that's the correct tz (or you shouldn't) but try setDefault(tz) off that same java class. if you need to cast between tz, etc. have a look at http://www.sustainablegis.com/projects/tz/testTZCFC.cfm ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229357 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encapsulate persistent variables
doesn't locking all the scopes in the admin have an impact on performance? aren't you effectively single threading -every- reference to those scopes server-wide? no bottlenecking results from this? On 1/12/06, Bryan Stevenson [EMAIL PROTECTED] wrote: I'm on MX7, so it should be fine, but what about race conditions? Those can easily occur no? People don't lock their shopping carts in MX7? What about application scope vars, that's race-condition central.. Baz appliocation/session/server scopes are all handled automatically Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229358 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Time zone issue
daylight savings perhaps on the OS? There is no time zone stuff in CF - it comes from the host On 1/12/06, Brad Wood [EMAIL PROTECTED] wrote: I am running CF MX 7.01 on linux. My time zone in telnet (both os and hardware) is set to CST, but the now() function returns EST. WHY??? I can't find any setting in cf admin to change the time zone. ~Brad ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229359 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Time zone issue
Fixed. -Duser.timezone=America/Chicago was added to the JVM arguments parameter list upon init bug report http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4762673 ~Brad -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 11:14 AM To: CF-Talk Subject: Re: Time zone issue daylight savings perhaps on the OS? There is no time zone stuff in CF - it comes from the host On 1/12/06, Brad Wood [EMAIL PROTECTED] wrote: I am running CF MX 7.01 on linux. My time zone in telnet (both os and hardware) is set to CST, but the now() function returns EST. WHY??? I can't find any setting in cf admin to change the time zone. ~Brad ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229360 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encapsulate persistent variables
According to MM, you still need to lock shared-scope variables to protect against race conditions. AFAIK, setting the locking in the CFadmin will affect performance. http://www.macromedia.com/cfusion/knowledgebase/index.cfm?event=viewid=KC.tn_18235extid=tn_18235dialogID=92334813iterationID=1sessionID=963070052628646c1818stateID=1+0+92344765mode=advanced ~Max On 1/12/06, Charlie Griefer [EMAIL PROTECTED] wrote: doesn't locking all the scopes in the admin have an impact on performance? aren't you effectively single threading -every- reference to those scopes server-wide? no bottlenecking results from this? On 1/12/06, Bryan Stevenson [EMAIL PROTECTED] wrote: I'm on MX7, so it should be fine, but what about race conditions? Those can easily occur no? People don't lock their shopping carts in MX7? What about application scope vars, that's race-condition central.. Baz appliocation/session/server scopes are all handled automatically Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229361 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query of query error
Another thing to add is the field is a CLOB from Oracle, could that have anything to do with why I can't query that field? Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229362 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Access to Oracle
Hey All, I have an Access DB that needs to move to Oracle 9i. The Oracle DB has been created and then generated via Oracle Designer and does contain different table names than the Access DB, and some tables will have less/more columns than their Access counterparts. In some cases their will be additional columns on the Oracle side that I will need to add a default value to (so not data that comes from the Access DB). So does anyone have advice to transform this data from Access to Oracle given the above issues? and before you say flat filere-read the above ;-) TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229363 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Access to Oracle
In the past I have used MSSQL's Import/Export tool for this since it will let you connect to both of those DB types and it is free with their client tools. Usually if I need to do a lot of manipulation I just take what I am importing and put it into staging tables then write some PL/SQL scripts to run aftwards that will do the changes needed and insert into the live tables. On 1/12/06, Bryan Stevenson [EMAIL PROTECTED] wrote: Hey All, I have an Access DB that needs to move to Oracle 9i. The Oracle DB has been created and then generated via Oracle Designer and does contain different table names than the Access DB, and some tables will have less/more columns than their Access counterparts. In some cases their will be additional columns on the Oracle side that I will need to add a default value to (so not data that comes from the Access DB). So does anyone have advice to transform this data from Access to Oracle given the above issues? and before you say flat filere-read the above ;-) TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229364 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encapsulate persistent variables
Bryan Stevenson wrote: I'm on MX7, so it should be fine, but what about race conditions? Those can easily occur no? People don't lock their shopping carts in MX7? What about application scope vars, that's race-condition central.. appliocation/session/server scopes are all handled automatically They are not automatically protected against race conditions. Guess what happens when the following templates run concurrently: up.cfm: cfloop from=1 to=100 index=application.i step=1 do something /cfloop down.cfm: cfloop from=100 to=1 index=application.i step=-1 do something /cfloop Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229365 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Access to Oracle
There's a thing called the oracle migration workbench that could be of some help. I've never actually used it because the DBA's restrict our use of it here. But, it might help. There's always just creating an access datasource in CF and running queries to enter it into Oracle. I do that when I don't want to fiddle with asking for DBA permission. On 1/12/06, Bryan Stevenson [EMAIL PROTECTED] wrote: Hey All, I have an Access DB that needs to move to Oracle 9i. The Oracle DB has been created and then generated via Oracle Designer and does contain different table names than the Access DB, and some tables will have less/more columns than their Access counterparts. In some cases their will be additional columns on the Oracle side that I will need to add a default value to (so not data that comes from the Access DB). So does anyone have advice to transform this data from Access to Oracle given the above issues? and before you say flat filere-read the above ;-) TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229366 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Access to Oracle
Bryan Stevenson wrote: I have an Access DB that needs to move to Oracle 9i. The Oracle DB has been created and then generated via Oracle Designer and does contain different table names than the Access DB, and some tables will have less/more columns than their Access counterparts. In some cases their will be additional columns on the Oracle side that I will need to add a default value to (so not data that comes from the Access DB). So does anyone have advice to transform this data from Access to Oracle given the above issues? and before you say flat filere-read the above ;-) For a one-time manual job: Create linked tables in Access to your Oracle database. Then just use SELECT .. INTO ... to move the data and apply any transformation you want in the process. For repeated exports: export from Access to flat files and mount them in Oracle as external tables. Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229367 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Mail list archives
I don;t know of any out of the box solutions, but you could just use CFPOP to store the emails in your DB and then you have an easy way to display them in an archive... Eric On Thu, 12 Jan 2006 12:24:17 - Jennifer Gavin-Wear [EMAIL PROTECTED] wrote: I'm looking for an out of the box coldfusion based application for storing and displaying mail list archives. I've looked at doing it myself and it ocurrs to me I am probably wasting my time creating an application that I'm sure must have been done before. I already have a mail list server and as this needs to integrate into a members area of a site I need it to fit into the existing security set up for controlled access. It also needs to be MS SQL based. If anyone has a product in mind, and even better with feedback from using it, I'd appreciate the info. Many thanks, Jenny ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229368 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Slightly OT:Linux distro for CF Developers
I like Fedora myself because of wide support availability. It isn't free, it's $35 / year, but the MyEclipse plugin has a huge set of tools that would round out your feature set, including UML, XML, CSS, JS, database, J2EE editing features. It has a free 30-day trial. Optionally, just look for other Eclipse plugins. There are free plugins for most of this stuff. I don't know if you will get the whole thing on a USB drive. Eclipse/CFE alone is pretty big if you include the full Eclipse installer. CFMX on Linux is a big install as well. That's a few hundred MB worth of stuff right there. MyEclipse is big as well. I guess it depends on whether you plan on pre-installing all the apps and making an image of your distro, then you might get away with a USB drive. Don't forget a database server- MySQL is the way to go. What about source control? You could setup SubVersion and the subClipse plugin, that's all free stuff. Eclipse with the cfeclipse plug-in (any body know of any other good plug-ins for web developers that I might want to include?) FireFox for web browsing Thunderbird for e-mail I'm not sure if flowcharting would be useful to the average cf developer (I use Visio) but if so does anyone know of Linux flow charters? In the end, I'm hoping that all of the software will be totally free. (remember I said cf developer edition not server) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229369 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Blog Hosting
Check out uplinkearth.com I have been with them a couple of years. I pay $105 for 3 months, which includes 3gig of space, MySQL db (you can also get SQL Server). They use CFMX7. Not sure if they support IMAP or not. Eric On Thu, 12 Jan 2006 07:59:53 -0600 Cutter [EMAIL PROTECTED] wrote: Looking for a very affordable (I'm still poor) CF Domain Hosting for a single domain with support for Ray's BlogCFC, MySQL 4.1x+, 5 or six IMAP mail accounts. Someplace I can eventually show off a small sample app or two. Any suggestions? Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229370 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Slightly OT:Linux distro for CF Developers
I admire someone as open-minded as you. The desire to learn new things and try new ways of doing things is an attribute that deserves respect. I second that. So many people just use what came on their PC/Server, even if they are geeks. There is no adventure in saying, Everybody uses [preinstalled software], and I want to be compatible, plus I don't have the time to learn [alternative software]. I can remember the first time I tried Windows, it was SOO cool. I think everybody probably had the same experience. But now most people are too busy/complacent/lazy or whatever to go out and try new things. --- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229371 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Free third party DNS hosting from godaddy
I use registerfly.com Eric On Thu, 12 Jan 2006 09:21:12 -0500 Katz, Dov B \(IT\) [EMAIL PROTECTED] wrote: has anyone tried using the free DNS management from godaddy? They apparently let you manage dns records of outside domains without transferring them there (just pointing the nameserver to godaddy). I'm looking for a place that I could set up and manage domains at and my hosting company doesnt offer that Thanks NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229372 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Scripting DB records in enterprise manager
I use this program quite often. It does everything I need it to and it's free. It's getting harder to find as it seems like it's abandonware. I'll always keep a copy of it though. http://www.yessoft.com/software/sqlservercompare/sqlservercompare.htm On 1/12/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: +1 on that recommendation, I'm currently using it to synch schemas and data on some large tables and it works great! Kola -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: 12 January 2006 14:58 To: CF-Talk Subject: Re: Scripting DB records in enterprise manager Mike, If this is something that you need to do often, or need to keep those two databases in synch, I would definitely check out the sql-compare and sql-datacompare tools from redgate... http://www.red-gate.com/ They are a bit pricey, but they can save you a lot of time and headache. -jim On 1/11/06, Mike | NZSolutions Ltd [EMAIL PROTECTED] wrote: hi guys, I need to duplicate some existing tables to a new SQL database. i am trying to script my sql server db, and include all records - not just the table structure. i am using the generate SQL script tool, but cannot seem to include the records. does anyone know what i am not doing? Regards Mike ~ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229373 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Access to Oracle
There's a thing called the oracle migration workbench that could be of some help. I've never actually used it because the DBA's restrict our use of it here. But, it might help. Great..I'll look into that one. There's always just creating an access datasource in CF and running queries to enter it into Oracle. I do that when I don't want to fiddle with asking for DBA permission. Yep...have been thinking of this approachwill run a hell of alot slowerbut I wouldn't waste a bunch of time looking at various daat transformation tools ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229374 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Detecting if a Verity Collection Exists in CFMX7...
admin API perhaps? It seems as if the admin may use the cfcollection action=list / command. I've got 64 collections on my box and this tag takes like 20 seconds to run. It takes forever for the admin page to load. I looked on CFLIB.org for an existing UDF and found one, but it uses the cfcollection action=list action as well--which takes way to long to run. What I did was re-write the UDF to the code at the bottom of this message. What this code does is attempt to use cfsearch / to search a collection. If an error is thrown that has the string does not exist then I return false, otherwise the function returns true. This seems to runs much more efficiently in my tests. -Dan cffunction name=collectionExists returnType=boolean output=false hint=This returns a yes/no value that checks for the existence of a named collection. cfargument name=collection type=string required=yes !---// by default return true //--- cfset var bExists = true / !---// if you can't search the collection, then assume it doesn't exist //--- cftry cfsearch name=SearchItems collection=#arguments.collection# type=explicit criteria= / cfcatch type=any !---// if the message contains the string does not exist, then the collection can't be found //--- cfif cfcatch.message contains does not exist cfset bExists = false / /cfif /cfcatch /cftry !---// returns true if search was successful and false if an error occurred //--- cfreturn bExists / /cffunction ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229375 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Slightly OT:Linux distro for CF Developers
So is he ;-) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 9:40 AM To: CF-Talk Subject: Re: Slightly OT:Linux distro for CF Developers You're assuming that the computer they run the usb drive off of is able to get to the internet. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229376 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf open shopping cart
Ok maybe 'bickering' is too strong a word, but it didnt look to me like the kind of productive, energetic, progressive discussion I see happening on the CFEclipse and Model-glue lists for example. As i said, it could well be that the initial wide-ranging stuff has now been narrowed down to a more focussed point, and what seemed like a cloud of ideas has now gelled into an organised project. rely I lost track of the project when it moved off CF-Talk, but at the time that happened, it didnt look to me like it was going to [A] offer me anything i could use that i didn't already have, and/or [B] offer an opportunity for me to learn at the same time as contributing something back to the cf community that has supported me so well over all these years since cF4.0.1 Your post, Andy, puts an entirely different perspective on it. Thanks for your post. Where can those of us who are interested in the project, but not currently involved, find out more? Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 1/12/06, Andy [EMAIL PROTECTED] wrote: Mike, I am sorry that you took it as bickering. Sounded like discussion to me. As far as you other points, the project is not in a mess, right now, there are just two of us working through it, and perhaps as we progress, you might reconsider. Andy PS: We are using CFC's, and will probably end up converting Ben's work in the process. I am just finishing a first draft of a high level archicture document. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229377 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Proper Syntax for Access (CF App)
I have created an application using MySQL database platform but a client wants to use the App using MS Access. Now I created the tables and everything but some of the Query statements bomb out in Access. Example 1 (MySQL) SELECT SUBMISSIONRECORDS.EMPLOYEEID, MEMBERS.FIRSTNAME AS EMPLOYEE_FIRST_NAME, MEMBERS.LASTNAME AS EMPLOYEE_LAST_NAME, MANAGER.EMPLOYEEID AS MANAGER_EMPLOYEE_ID, MANAGER.FIRSTNAME AS MANAGER_FIRST_NAME, MANAGER.LASTNAME AS MANAGER_LAST_NAME, RELEASED.EMPLOYEEID AS RELEASED_EMPLOYEE_ID, RELEASED.FIRSTNAME AS RELEASED_FIRST_NAME, RELEASED.LASTNAME AS RELEASED_LAST_NAME, APPROVER.EMPLOYEEID AS APPROVER_EMPLOYEE_ID, APPROVER.FIRSTNAME AS APPROVER_FIRST_NAME, APPROVER.LASTNAME AS APPROVER_LAST_NAME, SUBMISSIONRECORDS.RELEASED, SUBMISSIONRECORDS.APPROVED, PAYPERIODS.ID AS PAYPERIODID, PAYPERIODS.PPSTARTDATE, PAYPERIODS.PPENDDATE, TIMESUBMISSIONS.PPDATE, TIMESUBMISSIONS.ST_TIME, TIMESUBMISSIONS.OT_TIME, TIMESUBMISSIONS.DT_TIME, TIMESUBMISSIONS.JCW_CODE, TIMESUBMISSIONS.JOBCODE, TIMESUBMISSIONS.CRAFTCODE, WAGERATES.WAGERATE FROM SUBMISSIONRECORDS LEFT JOIN MEMBERS ON SUBMISSIONRECORDS.EMPLOYEEID = MEMBERS.ID LEFT JOIN MEMBERS AS MANAGER ON SUBMISSIONRECORDS.MANAGERID = MANAGER.ID LEFT JOIN MEMBERS AS RELEASED ON SUBMISSIONRECORDS.RELEASEDBY = RELEASED.ID LEFT JOIN MEMBERS AS APPROVER ON SUBMISSIONRECORDS.APPROVEDBY = APPROVER.ID LEFT JOIN PAYPERIODS ON SUBMISSIONRECORDS.PAYPERIODID = PAYPERIODS.ID LEFT JOIN TIMESUBMISSIONS ON SUBMISSIONRECORDS.ID = TIMESUBMISSIONS.SUBRECID LEFT JOIN WAGERATES ON TIMESUBMISSIONS.WAGERATE = WAGERATES.ID This worked perfectly in MySQL but then requires the ( ) in the FROM line on Access such as: (SUBMISSIONRECORDS LEFT JOIN MEMBERS ON SUBMISSIONRECORDS.EMPLOYEEID = MEMBERS.ID) Now if I only had ONE join transaction, it would be okay, what is the syntax for multiple Joins? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229378 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Proper Syntax for Access (CF App)
Usually this stuff in MS sql and access is left associative, so you have to use parens like this FROM (((a left join b) left join c) left join d) -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 3:14 PM To: CF-Talk Subject: Proper Syntax for Access (CF App) I have created an application using MySQL database platform but a client wants to use the App using MS Access. Now I created the tables and everything but some of the Query statements bomb out in Access. Example 1 (MySQL) SELECT SUBMISSIONRECORDS.EMPLOYEEID, MEMBERS.FIRSTNAME AS EMPLOYEE_FIRST_NAME, MEMBERS.LASTNAME AS EMPLOYEE_LAST_NAME, MANAGER.EMPLOYEEID AS MANAGER_EMPLOYEE_ID, MANAGER.FIRSTNAME AS MANAGER_FIRST_NAME, MANAGER.LASTNAME AS MANAGER_LAST_NAME, RELEASED.EMPLOYEEID AS RELEASED_EMPLOYEE_ID, RELEASED.FIRSTNAME AS RELEASED_FIRST_NAME, RELEASED.LASTNAME AS RELEASED_LAST_NAME, APPROVER.EMPLOYEEID AS APPROVER_EMPLOYEE_ID, APPROVER.FIRSTNAME AS APPROVER_FIRST_NAME, APPROVER.LASTNAME AS APPROVER_LAST_NAME, SUBMISSIONRECORDS.RELEASED, SUBMISSIONRECORDS.APPROVED, PAYPERIODS.ID AS PAYPERIODID, PAYPERIODS.PPSTARTDATE, PAYPERIODS.PPENDDATE, TIMESUBMISSIONS.PPDATE, TIMESUBMISSIONS.ST_TIME, TIMESUBMISSIONS.OT_TIME, TIMESUBMISSIONS.DT_TIME, TIMESUBMISSIONS.JCW_CODE, TIMESUBMISSIONS.JOBCODE, TIMESUBMISSIONS.CRAFTCODE, WAGERATES.WAGERATE FROM SUBMISSIONRECORDS LEFT JOIN MEMBERS ON SUBMISSIONRECORDS.EMPLOYEEID = MEMBERS.ID LEFT JOIN MEMBERS AS MANAGER ON SUBMISSIONRECORDS.MANAGERID = MANAGER.ID LEFT JOIN MEMBERS AS RELEASED ON SUBMISSIONRECORDS.RELEASEDBY = RELEASED.ID LEFT JOIN MEMBERS AS APPROVER ON SUBMISSIONRECORDS.APPROVEDBY = APPROVER.ID LEFT JOIN PAYPERIODS ON SUBMISSIONRECORDS.PAYPERIODID = PAYPERIODS.ID LEFT JOIN TIMESUBMISSIONS ON SUBMISSIONRECORDS.ID = TIMESUBMISSIONS.SUBRECID LEFT JOIN WAGERATES ON TIMESUBMISSIONS.WAGERATE = WAGERATES.ID This worked perfectly in MySQL but then requires the ( ) in the FROM line on Access such as: (SUBMISSIONRECORDS LEFT JOIN MEMBERS ON SUBMISSIONRECORDS.EMPLOYEEID = MEMBERS.ID) Now if I only had ONE join transaction, it would be okay, what is the syntax for multiple Joins? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229379 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Encapsulate persistent variables
Good example Jochem, I'm a bit surprised about how many people think that locking is unnecessary. The need to do it is definitely less noticeable nowadays because your server won't crash, but it's still essential. Imagine charging your customer too little or too much because s/he was accessing your session scoped shopping cart with 2 browsers... not fun. Locking is still required! (albeit in fewer cases) The solution of auto-locking in the CFAdmin is not optimal because, as Charlie Griefer mentioned, the performance impact could be catastrophic - especially if you were locking the application scope on every request! That would likely be your #1 bottleneck. It is in fact could practice to only use named locks. You should almost never lock an entire scope, except, perhaps, at app startup or some other rare case, but definitely not on every request. So this brings us back to the original question of how to manage all this. It would be nice to be able to encapsulate all locking somehow, and not have the developer worry about which variable was in what scope, and what's that lock name again? The developer would only reference the new custom scope called AppName (a CFC), that manages and contains all persistent vars. Oh, how that would be great... Baz ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229380 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encapsulate persistent variables
I have an issue with using name locks. You would have to know the name of the lock you set up. I think that becomes very unmanigable unless you set up a dynamic name based on session. Named lockes on application scope are not needed. It's only going to be a one hit and that's it. The only place would be session. Someone pointed out that they don't lock the entire box, only the application then the scope. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229381 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Free third party DNS hosting from godaddy
We use it all the time at my company. It's great. Lots of options, easy to use. I would highly reccommend it. On 1/12/06, Owner, Three Ravens Consulting [EMAIL PROTECTED] wrote: I use registerfly.com Eric On Thu, 12 Jan 2006 09:21:12 -0500 Katz, Dov B \(IT\) [EMAIL PROTECTED] wrote: has anyone tried using the free DNS management from godaddy? They apparently let you manage dns records of outside domains without transferring them there (just pointing the nameserver to godaddy). I'm looking for a place that I could set up and manage domains at and my hosting company doesnt offer that Thanks NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229382 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Encapsulate persistent variables
Sir Robert Everland the III, You would have to know the name of the lock you set up. I agree. That's a downfall of using named locks, but another great reason to encapsulate all locking in 1 place! Named locks on application scope are not needed I disagree. If you were to update the application scope and not just read from it, you need to lock. Someone pointed out that they don't lock the entire box, only the application, then the scope. I agree. If you lock the session scope, I think it's only that specific session that's locked and not all sessions on the box - same with application scope, only a specific application is locked and not all applications on a box. Baz -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 2:37 PM To: CF-Talk Subject: Re: Encapsulate persistent variables I have an issue with using name locks. I think that becomes very unmanigable unless you set up a dynamic name based on session. Named lockes on application scope are not needed. It's only going to be a one hit and that's it. The only place would be session. Someone pointed out that they don't lock the entire box, only the application then the scope. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229383 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: CSS mystery
Can anyone explain to me why this works in IE 6 and Opera but not in Firefox?
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html
head
titleUntitled/title
/head
style
.container {
color: #00;
font-family:tahoma, verdana, helvetica;
font-size: 11px;
background-color: #f1f1ed;
width:170px;
height: 100%;
border-right: buttonshadow 1px solid;
border-top: #f5f5f5 1px solid;
border-left: #f5f5f5 1px solid;
border-bottom: buttonshadow 1px solid;
padding-right : 1px;
padding-top : 1px;
padding-bottom : 1px;
}
...leftMenu {
color:#006699;
text-decoration:none;
font-weight:bold;
}
...leftMenu:hover {
color:#00;
text-decoration:none;
font-weight:bold;
}
...leftMenu:active {
color:#00;
text-decoration:none;
font-weight:bold ;
}
...Menu {
width: 100%;
height: 20px;
padding:2px 5px 3px 2px;
border-right: buttonshadow 1px solid;
border-top: #f5f5f5 1px solid;
border-left: #f5f5f5 1px solid;
border-bottom: buttonshadow 1px solid;
background-color: #D4D0C8;
cursor:hand;
color:#00;
}
...Option {
width: 100%;
height: 24px;
padding:2 5 3 16;
background-color: #f5f5f5;
border-top : 1px solid #ff;
border-bottom : 1px solid #ff;
border-left : 1px solid #ff;
border-right : 1px solid #ff;
cursor:hand;
}
...Options {padding:1 1 1 1}
...imgPosition {
vertical-align: middle;
}
/style
body leftmargin=0 topmargin=0 rightmargin=0 bottommargin=0
marginwidth=0 marginheight=0
div class=container
div id=parent
div class=menu/div
/div
/div
/body
/html
Bob
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229384
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Proper Syntax for Access (CF App)
Got it.. Now I can understand it. Sometimes you just have to step away And then come back. Thanks! -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 3:18 PM To: CF-Talk Subject: RE: Proper Syntax for Access (CF App) Usually this stuff in MS sql and access is left associative, so you have to use parens like this FROM (((a left join b) left join c) left join d) -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 3:14 PM To: CF-Talk Subject: Proper Syntax for Access (CF App) I have created an application using MySQL database platform but a client wants to use the App using MS Access. Now I created the tables and everything but some of the Query statements bomb out in Access. Example 1 (MySQL) SELECT SUBMISSIONRECORDS.EMPLOYEEID, MEMBERS.FIRSTNAME AS EMPLOYEE_FIRST_NAME, MEMBERS.LASTNAME AS EMPLOYEE_LAST_NAME, MANAGER.EMPLOYEEID AS MANAGER_EMPLOYEE_ID, MANAGER.FIRSTNAME AS MANAGER_FIRST_NAME, MANAGER.LASTNAME AS MANAGER_LAST_NAME, RELEASED.EMPLOYEEID AS RELEASED_EMPLOYEE_ID, RELEASED.FIRSTNAME AS RELEASED_FIRST_NAME, RELEASED.LASTNAME AS RELEASED_LAST_NAME, APPROVER.EMPLOYEEID AS APPROVER_EMPLOYEE_ID, APPROVER.FIRSTNAME AS APPROVER_FIRST_NAME, APPROVER.LASTNAME AS APPROVER_LAST_NAME, SUBMISSIONRECORDS.RELEASED, SUBMISSIONRECORDS.APPROVED, PAYPERIODS.ID AS PAYPERIODID, PAYPERIODS.PPSTARTDATE, PAYPERIODS.PPENDDATE, TIMESUBMISSIONS.PPDATE, TIMESUBMISSIONS.ST_TIME, TIMESUBMISSIONS.OT_TIME, TIMESUBMISSIONS.DT_TIME, TIMESUBMISSIONS.JCW_CODE, TIMESUBMISSIONS.JOBCODE, TIMESUBMISSIONS.CRAFTCODE, WAGERATES.WAGERATE FROM SUBMISSIONRECORDS LEFT JOIN MEMBERS ON SUBMISSIONRECORDS.EMPLOYEEID = MEMBERS.ID LEFT JOIN MEMBERS AS MANAGER ON SUBMISSIONRECORDS.MANAGERID = MANAGER.ID LEFT JOIN MEMBERS AS RELEASED ON SUBMISSIONRECORDS.RELEASEDBY = RELEASED.ID LEFT JOIN MEMBERS AS APPROVER ON SUBMISSIONRECORDS.APPROVEDBY = APPROVER.ID LEFT JOIN PAYPERIODS ON SUBMISSIONRECORDS.PAYPERIODID = PAYPERIODS.ID LEFT JOIN TIMESUBMISSIONS ON SUBMISSIONRECORDS.ID = TIMESUBMISSIONS.SUBRECID LEFT JOIN WAGERATES ON TIMESUBMISSIONS.WAGERATE = WAGERATES.ID This worked perfectly in MySQL but then requires the ( ) in the FROM line on Access such as: (SUBMISSIONRECORDS LEFT JOIN MEMBERS ON SUBMISSIONRECORDS.EMPLOYEEID = MEMBERS.ID) Now if I only had ONE join transaction, it would be okay, what is the syntax for multiple Joins? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229385 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CSS mystery
What's it supposed to be doing? What doesn't it do in FF?
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 12, 2006 1:50 PM
To: CF-Talk
Subject: OT: CSS mystery
Can anyone explain to me why this works in IE 6 and Opera but not in
Firefox?
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html
head
titleUntitled/title
/head
style
.container {
color: #00;
font-family:tahoma, verdana, helvetica;
font-size: 11px;
background-color: #f1f1ed;
width:170px;
height: 100%;
border-right: buttonshadow 1px solid;
border-top: #f5f5f5 1px solid;
border-left: #f5f5f5 1px solid;
border-bottom: buttonshadow 1px solid;
padding-right : 1px;
padding-top : 1px;
padding-bottom : 1px;
}
leftMenu {
color:#006699;
text-decoration:none;
font-weight:bold;
}
leftMenu:hover {
color:#00;
text-decoration:none;
font-weight:bold;
}
leftMenu:active {
color:#00;
text-decoration:none;
font-weight:bold ;
}
Menu {
width: 100%;
height: 20px;
padding:2px 5px 3px 2px;
border-right: buttonshadow 1px solid;
border-top: #f5f5f5 1px solid;
border-left: #f5f5f5 1px solid;
border-bottom: buttonshadow 1px solid;
background-color: #D4D0C8;
cursor:hand;
color:#00;
}
Option {
width: 100%;
height: 24px;
padding:2 5 3 16;
background-color: #f5f5f5;
border-top : 1px solid #ff;
border-bottom : 1px solid #ff;
border-left : 1px solid #ff;
border-right : 1px solid #ff;
cursor:hand;
}
Options {padding:1 1 1 1}
imgPosition {
vertical-align: middle;
}
/style
body leftmargin=0 topmargin=0 rightmargin=0 bottommargin=0
marginwidth=0 marginheight=0
div class=container
div id=parent
div class=menu/div
/div
/div
/body
/html
Bob
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229386
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CSS mystery
There is a box inside of a box. In IE and Opera the inner box is constrained to the size of the outer box. In FF with padding it goes over the container box. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229387 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Encapsulate persistent variables
Let's say you have a display TAG for Customer.CFC. And since we all know that TAGs should never access outside variables, we pass in Customer.CFC. All the TAG does is update some part of customer, and then displays its values. Now let's say instead of passing in a new instance of Customer.CFC you pass in session.CustomerObj. You've passed in a session scoped instance of Customer, but the TAG doesn't know it, nor should it. So where do you lock? Baz ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229388 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Mail list archives
Can't believe I remembered the name of this application. This should do what you want http://www.amxfiles.com/wixlist/ Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229389 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: CSS mystery
Because IE and Opera are incorrectly ignoring the first two periods,
while Firefox is correctly ignoring the rest of the rule? I'm not
sure that applies to selectors or just rules, but I'd guess it's for
both. Or perhaps its a case-sensitivity issue. CSS is case
sensitive, but I believe IE doesn't enforce it. Did you try removing
the extra periods or fixing the casing and see if that resolves it?
cheers,
barneyb
On 1/12/06, Robert Everland III [EMAIL PROTECTED] wrote:
Can anyone explain to me why this works in IE 6 and Opera but not in Firefox?
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html
head
titleUntitled/title
/head
style
.container {
color: #00;
font-family:tahoma, verdana, helvetica;
font-size: 11px;
background-color: #f1f1ed;
width:170px;
height: 100%;
border-right: buttonshadow 1px solid;
border-top: #f5f5f5 1px solid;
border-left: #f5f5f5 1px solid;
border-bottom: buttonshadow 1px solid;
padding-right : 1px;
padding-top : 1px;
padding-bottom : 1px;
}
...leftMenu {
color:#006699;
text-decoration:none;
font-weight:bold;
}
...leftMenu:hover {
color:#00;
text-decoration:none;
font-weight:bold;
}
...leftMenu:active {
color:#00;
text-decoration:none;
font-weight:bold ;
}
...Menu {
width: 100%;
height: 20px;
padding:2px 5px 3px 2px;
border-right: buttonshadow 1px solid;
border-top: #f5f5f5 1px solid;
border-left: #f5f5f5 1px solid;
border-bottom: buttonshadow 1px solid;
background-color: #D4D0C8;
cursor:hand;
color:#00;
}
...Option {
width: 100%;
height: 24px;
padding:2 5 3 16;
background-color: #f5f5f5;
border-top : 1px solid #ff;
border-bottom : 1px solid #ff;
border-left : 1px solid #ff;
border-right : 1px solid #ff;
cursor:hand;
}
...Options {padding:1 1 1 1}
...imgPosition {
vertical-align: middle;
}
/style
body leftmargin=0 topmargin=0 rightmargin=0 bottommargin=0
marginwidth=0 marginheight=0
div class=container
div id=parent
div class=menu/div
/div
/div
/body
/html
Bob
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229390
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: CSS mystery
It has to do with the way IE and Firefox treat the box model in quirks
mode. There's some info about it here:
http://www.quirksmode.org/css/quirksmode.html
Also, if you remove the width:100% in the menu def, it will fill out correctly.
On 1/12/06, Robert Everland III [EMAIL PROTECTED] wrote:
Can anyone explain to me why this works in IE 6 and Opera but not in Firefox?
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html
head
titleUntitled/title
/head
style
.container {
color: #00;
font-family:tahoma, verdana, helvetica;
font-size: 11px;
background-color: #f1f1ed;
width:170px;
height: 100%;
border-right: buttonshadow 1px solid;
border-top: #f5f5f5 1px solid;
border-left: #f5f5f5 1px solid;
border-bottom: buttonshadow 1px solid;
padding-right : 1px;
padding-top : 1px;
padding-bottom : 1px;
}
...leftMenu {
color:#006699;
text-decoration:none;
font-weight:bold;
}
...leftMenu:hover {
color:#00;
text-decoration:none;
font-weight:bold;
}
...leftMenu:active {
color:#00;
text-decoration:none;
font-weight:bold ;
}
...Menu {
width: 100%;
height: 20px;
padding:2px 5px 3px 2px;
border-right: buttonshadow 1px solid;
border-top: #f5f5f5 1px solid;
border-left: #f5f5f5 1px solid;
border-bottom: buttonshadow 1px solid;
background-color: #D4D0C8;
cursor:hand;
color:#00;
}
...Option {
width: 100%;
height: 24px;
padding:2 5 3 16;
background-color: #f5f5f5;
border-top : 1px solid #ff;
border-bottom : 1px solid #ff;
border-left : 1px solid #ff;
border-right : 1px solid #ff;
cursor:hand;
}
...Options {padding:1 1 1 1}
...imgPosition {
vertical-align: middle;
}
/style
body leftmargin=0 topmargin=0 rightmargin=0 bottommargin=0
marginwidth=0 marginheight=0
div class=container
div id=parent
div class=menu/div
/div
/div
/body
/html
Bob
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229391
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get last inserted ID
dont know about mysql, but this is how i do it in mssql2k : cfquery name=getMaxObject datasource=#dsn# SET NOCOUNT ON INSERT INTO Objects (EmployeeID, patientID, ObjectTypeID) VALUES (cfqueryparam cfsqltype=CF_SQL_INTEGER value=#session.whoami#, cfqueryparam cfsqltype=CF_SQL_INTEGER value=#form.patientid#, cfqueryparam cfsqltype=CF_SQL_INTEGER value=27) SELECT @@identity as maxObjectID SET NOCOUNT OFF /cfquery then to get the value i do #getMaxObject.maxObjectID#. give it a shot? -alex Is this the best way to do this: cftransaction cfquery name=InsertAddress datasource=#DSN# INSERT INTO Address (City) VALUES (cfqueryparam value=#City# cfsqltype=cf_sql_integer /) /cfquery cfquery name=getInsertedID datasource=#DSN# SELECT MAX(AddressID) as MaxID FROM Address /cfquery /cftransaction I'm using MySQL. Cheers, Baz ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229392 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: CSS mystery
That's awesome, it works beautifully now. It was driving me crazy. Also those extra periods were added after I posted. The code only has one period. bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229393 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Scripting DB records in enterprise manager
thanks guys for the advice. i have ended up using the DTS export - but had to change the table ownership first on the relevant tables. mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229394 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CSS mystery
I am using Firefox 1.5, IE 6, and Opera 8.5. I don't see any overlap in any of them. However, IE is the only one that shows me a darker shade for the inner box. I don't even see the box in Firefox nor Opera. It looks like you could be using some IE specific CSS, you could try validating your CSS with the W3C validator. -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 1:09 PM To: CF-Talk Subject: Re: CSS mystery There is a box inside of a box. In IE and Opera the inner box is constrained to the size of the outer box. In FF with padding it goes over the container box. [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229395 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CSS mystery
judging by the padding being used my guess would be the box model hackalthough this is an issue with IE...not FF and yes...of course knowing what it is supposed to do and is not doing would be a tad more helpful ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229396 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CSS mystery
BTW I have never seen this notation before leftMenu normally I'd expect to see .leftMenu So that most certainly could be a problemwhether or not it is the mysterious and unknown problem you are having I do not know ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229397 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Encrypt CC number and store in DB
What's the best way to encrypt a CC number and store it in DB? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229398 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Encrypt CC number and store in DB
HINT: #replace(ccnumber, ccnumber, )# ;-) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Baz [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 5:47 PM To: CF-Talk Subject: Encrypt CC number and store in DB What's the best way to encrypt a CC number and store it in DB? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229399 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Encrypt CC number and store in DB
What's the best way to encrypt a CC number and store it in DB? The best way is really a business question - what's the best way for one company may not be best for another. My answers below emphasize security above convenience, but that might not be the choice you want to make. Ideally, it's best not to store it at all. If you must store it, you shouldn't allow the same application to encrypt and decrypt the number. For example, using PKI you could have your ecommerce application encrypt the number, and a private internal application on a separate machine could then decrypt it. Choosing an algorithm is much less important than figuring out how you'll manage keys. It doesn't matter how strong your encryption algorithm is, if an attacker can get all the keys from one place. This is the big problem with symmetric encryption, of course. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229400 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encrypt CC number and store in DB
Dave Watts wrote: What's the best way to encrypt a CC number and store it in DB? Ideally, it's best not to store it at all. Couldn't have said it better myself. Also, keep in mind that CC storage is highly regulated. Non-compliance could lead to heavy fines and, in most cases, cancellation of your merchant account. -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229401 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Encrypt CC number and store in DB
I was expecting an answer like: put encrypt() in your setter method and decrypt() in your getter... heh. Or better yet, a link to a function on cflib... looks like this is going to be a big one. Baz -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 5:59 PM To: CF-Talk Subject: RE: Encrypt CC number and store in DB What's the best way to encrypt a CC number and store it in DB? The best way is really a business question - what's the best way for one company may not be best for another. My answers below emphasize security above convenience, but that might not be the choice you want to make. Ideally, it's best not to store it at all. If you must store it, you shouldn't allow the same application to encrypt and decrypt the number. For example, using PKI you could have your ecommerce application encrypt the number, and a private internal application on a separate machine could then decrypt it. Choosing an algorithm is much less important than figuring out how you'll manage keys. It doesn't matter how strong your encryption algorithm is, if an attacker can get all the keys from one place. This is the big problem with symmetric encryption, of course. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229402 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Encrypt CC number and store in DB
I have to store credit card numbers for an internal order processing system. Orders come by fax and the credit card number must be written to DB for later viewing/charging by another employee. Where can I see these regulations? Cheers, Baz -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 6:13 PM To: CF-Talk Subject: Re: Encrypt CC number and store in DB Dave Watts wrote: What's the best way to encrypt a CC number and store it in DB? Ideally, it's best not to store it at all. Couldn't have said it better myself. Also, keep in mind that CC storage is highly regulated. Non-compliance could lead to heavy fines and, in most cases, cancellation of your merchant account. -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229403 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Encrypt CC number and store in DB
If you must store CC numbers be sure you client understands the risks. We have used CardCrypt and TextCrypt from Perth Web (http://developer.perthweb.com.au/) with good success. Just be sure you NEVER let the private key be stored on the server and NEVER use it without SSL. And NEVER let the private just lay around. The private key MUST be stored in a safe and secure loction just like you would the keys to a safe. I always suggest to clients they remove the CC numbers ASAP after they don't need them anymore like Bobby suggested #replace(ccnumber, ccnumber, )# What's the best way to encrypt a CC number and store it in DB? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229404 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
We are not focused enough yet, but quickly getting there. https://sourceforge.net/projects/openbizservices/ -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Thursday, January 12, 2006 2:09 PM To: CF-Talk Subject: Re: cf open shopping cart Ok maybe 'bickering' is too strong a word, but it didnt look to me like the kind of productive, energetic, progressive discussion I see happening on the CFEclipse and Model-glue lists for example. As i said, it could well be that the initial wide-ranging stuff has now been narrowed down to a more focussed point, and what seemed like a cloud of ideas has now gelled into an organised project. rely I lost track of the project when it moved off CF-Talk, but at the time that happened, it didnt look to me like it was going to [A] offer me anything i could use that i didn't already have, and/or [B] offer an opportunity for me to learn at the same time as contributing something back to the cf community that has supported me so well over all these years since cF4.0.1 Your post, Andy, puts an entirely different perspective on it. Thanks for your post. Where can those of us who are interested in the project, but not currently involved, find out more? Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 1/12/06, Andy [EMAIL PROTECTED] wrote: Mike, I am sorry that you took it as bickering. Sounded like discussion to me. As far as you other points, the project is not in a mess, right now, there are just two of us working through it, and perhaps as we progress, you might reconsider. Andy PS: We are using CFC's, and will probably end up converting Ben's work in the process. I am just finishing a first draft of a high level archicture document. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229405 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Swfs not showing when CF is Connected
Wouldn't show the swfs. I don't recall CF crashing but I know my PC didn't crash. On 1/12/06, Rich Tretola [EMAIL PROTECTED] wrote: Did it actually crash your server or just not show the swfs ? Rich On 1/12/06, John C. Bland II [EMAIL PROTECTED] wrote: I couldn't answer, really. Once I found the issue I could care less why it happened...as long as it was fixed. This was my local IIS so it wasn't a big deal to me...just very annoying. On 1/12/06, Rich Tretola [EMAIL PROTECTED] wrote: Yes, someone from then JRUN list suggsested the same thing and this did work. It is very odd however as there are 5 other cf instances on this server and they are all working fine and all still have the mapping in IIS. The only difference between this instance and the others is that it has more than one domain name mapped by the web connector. Do you think this is the reason it is behaving differently ? Another thing that is weird is that it had been working fine for the past 2 months and then suddenly stopped displaying the swfs this week after crashing repeatedly with cfoutput timeouts. I assume that it was the cfoutputs surrounding the swf object tag that were timing out until the server finally gave up on the swfs and then was working fine with the exception of the swfs no longer showing. Rich On 1/11/06, John C. Bland II [EMAIL PROTECTED] wrote: If you look at your site configuration (in IIS) you'll notice the .swf extension is mapped to CF. I had this same issue locally after flash forms came out. I believe I just deleted the .swf. Its been awhile so don't quote me on that one. On 1/11/06, Rich Tretola [EMAIL PROTECTED] wrote: OK here is our setup: JRun 4 with CFMX 6 under IIS Our issue is that as soon as we add a 2nd domain using the web connector, the server ignores all swfs. If we disconnect ColdFusion from IIS we can then browse to swfs again. has anyone seen anything like this ? Rich ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229406 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
