RE: How do I format pop3 Date!?
Almost, try: #ParseDateTime(mail.date, POP)# And then you can use dateformat on the resultant if required, Jb. -Original Message- From: Jordon Bedwell [mailto:[EMAIL PROTECTED] Sent: 22 April 2004 06:10 To: CF-Talk Subject: How do I format pop3 Date!? Hello, Im fairly new to ColdFusion and somone From EasyCFM pointed me here.Im making a custom application for my open-source site that has to do with pop3.Im having trouble formating the date, or even getting it to show up correctly.I was wondering if somone could tell me what im doing wrong and how to do it write.I was first told to use DateFormat with ParseDateTime and then to use just ParseDateTime(). Here is the code that is relevent to the Area I am talking about! td width=88 align=center valign=middlediv align=center #parseDateTime(#qGetMessages.date#, mm/dd/) #mm/dd/##/div/td Am I formatting it correctly!?Should I use that in conjuction as an arguement for DateFormat!? Im confused. So many people tell me so many things.I have the original code I was using for it, which was actually a regular _expression_.But I dont know how to change the regular _expression_ into a mm/dd/ format. #reReplace(left(qGetMessages.date, 21), ^(.* ).*, \1)# Either way is fine with me if you can help me code it. Thank You. Jordon Bedwell Cybercom Pros (Design Is Only as Good as your bad planning, because planning is bad in design) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: xslt beginners guide?
thanks all :-) -- David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Enter key not working to submit?
On Thursday 22 Apr 2004 03:04 am, ChunshenLi wrote: js keycode etc. is fine it works while with Netscape (my version 6.2.1) it won't. However there is good key capture behaviour in recent Mozilla's, and of course the usual gaggle of cross-platform libraries to make adding events easy across platforms. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: A lesson in security by obscurity...
10 is a bit tricky, so far for mei think there is a big red herring that I am following on this one -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 4:40 PM To: CF-Talk Subject: RE: A lesson in security by obscurity... I got to 8 and im tired...time to go play golf...try for 9 tonight. -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 3:45 PM To: CF-Talk Subject: SOT: A lesson in security by obscurity... I know the debate has come up about whether or not security by obscurity is really any security at all.I thought everyone would enjoy trying this out. Basically you have to try to hack your way through a site that uses _javascript_ for its security and you have to find ways around it.Enjoy. http://scifi.pages.at/hackits/ John _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Blue Dragon - StandAlone or IIS
Hi all what's the best performance: using BD with StandAlone Server or with IIS 5? Thanx for your time. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Design Graphical user interface
Hi Any body provide me examples of your experience in design graphical user interface in coldfusion AlsoUsing Computer Assisted Software Engineering (CASE) tools Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Blue Dragon - StandAlone or IIS
From: Spectrum WebDesign what's the best performance: using BD with StandAlone Server or with IIS 5? It depends on your purpose If you're talking production, then use IIS - most standalone servers are only designed to be testing tools and nothing more [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Turning CFMX DevNet edition into developer mode?
Unfortunately that doesn't help the WDDX output. That is automatically done by the CF server when it gets a call to a remote service from something other than flash remoting.in this case I don't get the opportunity to tell it that WDDX is XML. It is an oversight on MM part and nothing I can control. -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:32 PM To: CF-Talk Subject: RE: Turning CFMX DevNet edition into developer mode? Use cfcontent type=text/xml at the top and it won't output the watermark -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Craig Earls [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:23 PM To: CF-Talk Subject: Turning CFMX DevNet edition into developer mode? I really need to use WDDX in local testing. The DevNet version of CFMX puts a silly watermark in everything even the XML WDDX.This totally hose the _javascript_ code supplied.Is there a simple way to transform a CFMX DevNet installer into the developer edition?My understanding is that the developer edition doesn't put the watermark on anything. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Blue Dragon - StandAlone or IIS
You'll get better performance with IIS. Also, we don't recommend using the built-in web server for production. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 7:26 AM To: CF-Talk Subject: Blue Dragon - StandAlone or IIS Hi all what's the best performance: using BD with StandAlone Server or with IIS 5? Thanx for your time. -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: msSQL management script needed
We've been using an ASP application called 1 Click DB Pro.It's pretty nice and as close as you're likely to come to phpMyAdmin. http://www.standardreporting.net/1ClickDB/ http://www.standardreporting.net/1ClickDB/ -Original Message- From: Mystic [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 5:58 PM To: CF-Talk Subject: msSQL management script needed Greetings, I need some help. I have been searching for a script like phpmyadmin for msSQL. I have had no luck with Google.com, Downloads.com or any other search I have tried. Can anyone direct me to something that will allow me to manage my online msSQL databse? Thank you, Kevin _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: Turning CFMX DevNet edition into developer mode?
Original Message: From: Craig Earls I really need to use WDDX in local testing. The DevNet version of CFMX puts a silly watermark in everything even the XML WDDX.This totally hose the _javascript_ code supplied.Is there a simple way to transform a CFMX DevNet installer into the developer edition?My understanding is that the developer edition doesn't put the watermark on anything. It's probably not the solution you want, but is there any reason you can't just install the developer edition?(I'm not sure what the DevNet version gets you that the Developer edition doesn't, unless it's multiple IPs) Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT-Webex
Try Convoq ASAP (http://www.convoq.com/) Matt _ From: Mickael [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 4:20 PM To: CF-Talk Subject: OT-Webex Hello All, I know this is OT but I am sure that someone on this list has an answer to this.Does anyone know of a anther company that provides the same services or similar to webex, the idea here is cheaper then webex. Thanks Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: A lesson in security by obscurity...
Oh really?What am I missing? John -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 5:00 PM To: CF-Talk Subject: RE: A lesson in security by obscurity... Actually, it's not so much guessing.The answers on the page itself :) -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 3:54 PM To: CF-Talk Subject: RE: A lesson in security by obscurity... I did the same.9 seems like a lot of quess work.Up to that point it was a test of working around _javascript_ security and from what I can tell, to get to 9 you have to guess the name of the next page.If anyone takes the time to get there please share :-) John -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 4:40 PM To: CF-Talk Subject: RE: A lesson in security by obscurity... I got to 8 and im tired...time to go play golf...try for 9 tonight. -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 3:45 PM To: CF-Talk Subject: SOT: A lesson in security by obscurity... I know the debate has come up about whether or not security by obscurity is really any security at all.I thought everyone would enjoy trying this out. Basically you have to try to hack your way through a site that uses _javascript_ for its security and you have to find ways around it. Enjoy. http://scifi.pages.at/hackits/ John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Max 2003 Conference Photo
This is OT, but I just got accused of trying to humiliate someone who won a photo contest and the photo is the picture (at least I'm fairly certain) that was all over the Max 2003 conference. http://www.theparentperspective.com/boards/thread-view.asp?threadid=200412posts=15#0 Can someone clarify if it is? Thanks, Cathy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: A lesson in security by obscurity...
Marlon, I'm not sure what you mean.I tried selecting everything on the page before the _javascript_ prompt and the _javascript_ prompt page.I'm confused.Any more help?What am I looking for? John -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:23 PM To: CF-Talk Subject: RE: A lesson in security by obscurity... -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wed 4/21/2004 8:14 PM To: CF-Talk Cc: Subject: RE: A lesson in security by obscurity... dude its killing me, ive typed everything in I can think of for that page, must you be a mindreader or something here...WTF??? and funny how all of us, well most of us tripped up on this one... spoiler space.. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. select all of the contents on the page with the mouse. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: A lesson in security by obscurity...
spoiler space .. .. .. .. .. .. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 8:39 AM To: CF-Talk Subject: RE: A lesson in security by obscurity... Marlon, I'm not sure what you mean.I tried selecting everything on the page before the _javascript_ prompt and the _javascript_ prompt page.I'm confused.Any more help?What am I looking for? John -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:23 PM To: CF-Talk Subject: RE: A lesson in security by obscurity... -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wed 4/21/2004 8:14 PM To: CF-Talk Cc: Subject: RE: A lesson in security by obscurity... dude its killing me, ive typed everything in I can think of for that page, must you be a mindreader or something here...WTF??? and funny how all of us, well most of us tripped up on this one... spoiler space.. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. select all of the contents on the page with the mouse. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL: hierarchical view of parent child categories
Hi all, Here's s sql stumper, well, not really.But I haven't been able to figure out the best way to do it yet so I'm posting here.I know it's sql but it does have CF implications. Scenario: I have a table called CATEGORY with the following columns ID PK for table PARENT_ID If populated it's the ID of this category's parent NAME Name of category DESCRIPTION Description of category ACTIVE_IND Active indicator (1 | 0) DATE_ADDED Date category added to db DATE_UPDATED Date category was last updated The goal is to create a view that will go through every single category and determine the tree structure used to navigate to that category.This table can be used for menus, directory structures, or any other app that needs the ability to store data in a hierarchical structure. The drawback of this table design is that when a user selects a particular category from the table and you want to show them where this category is in relation to it's parent(s) categories you have to jump through a lot of cfif's.The ideal solution is to have a view that determines all of these relationships and you just run a query on that view by passing in the category you want info on and your query returns the exact hierarchical structure of the category relative to the category you selected. Here's an example: You have the following categories. Fruits Apples Washington Red Apples Fiji Golden Delicious Pears Peaches Veggies Meats When someone clicks on a link representing the Washington Red Apples category we should automatically create a navigational crumb trail with this, Fruits Apples Washington Red Apples and make each one of the parents of Washington Red Apples clickable.This means we'll need to return their category id in our query as well. Anyone have experience in doing such a thing? Thanks, Jason Application Engineering Services Information Management Florida Operations Telephone: 321.799.6845 Fax: 321.799.5970 e-mail:[EMAIL PROTECTED] Thecomments and opinions expressed are my own and do not represent the view of United Space Alliance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: A lesson in security by obscurity...
answer at bottom. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 8:39 AM To: CF-Talk Subject: RE: A lesson in security by obscurity... Marlon, I'm not sure what you mean.I tried selecting everything on the page before the _javascript_ prompt and the _javascript_ prompt page.I'm confused.Any more help?What am I looking for? John -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:23 PM To: CF-Talk Subject: RE: A lesson in security by obscurity... -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wed 4/21/2004 8:14 PM To: CF-Talk Cc: Subject: RE: A lesson in security by obscurity... dude its killing me, ive typed everything in I can think of for that page, must you be a mindreader or something here...WTF??? and funny how all of us, well most of us tripped up on this one... spoiler space.. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. select all of the contents on the page with the mouse. I didn't realize it the first time, but you need to disable _javascript_, otherwise, you'll have to view the source and remove all of the font tags.If you disable _javascript_, the noscript tags will print out black characters on a black background.Select them and you have the clue. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Max 2003 Conference Photo
wow, they are giving you a hard time in there huh -Original Message- From: Cathy Taylor [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 9:34 AM To: CF-Talk Subject: Max 2003 Conference Photo This is OT, but I just got accused of trying to humiliate someone who won a photo contest and the photo is the picture (at least I'm fairly certain) that was all over the Max 2003 conference. http://www.theparentperspective.com/boards/thread-view.asp?threadid=200412p osts=15#0 Can someone clarify if it is? Thanks, Cathy _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Max 2003 Conference Photo
On Thursday 22 Apr 2004 14:33 pm, Cathy Taylor wrote: Can someone clarify if it is? No idea, but that thread paints a terriable picture of the sort of forum that is. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Browser compatibility testing
On Wednesday 21 Apr 2004 19:21 pm, ketan patel wrote: I am looking for a tool or software to test my application in all browsers for Windows,MAC,Linux.Please let me know about this if anybody know about it. I know there is a web site that will do this, and email you pictures of you site under various browers/OS. Can't remember the name. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Max 2003 Conference Photo
No, it looks like you were in the wrong: http://www.macromedia.com/macromedia/conference/images/max_wallpaper_gra ss.jpg John Burns -Original Message- From: Cathy Taylor [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 9:34 AM To: CF-Talk Subject: Max 2003 Conference Photo This is OT, but I just got accused of trying to humiliate someone who won a photo contest and the photo is the picture (at least I'm fairly certain) that was all over the Max 2003 conference. http://www.theparentperspective.com/boards/thread-view.asp?threadid=2004 12posts=15#0 Can someone clarify if it is? Thanks, Cathy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Max 2003 Conference Photo
Yea, I agree.I would walk away from that place.That mediator is a little uptight.Talk about censorship!Wasn't even close to being humiliating. I even thought about posting in your defense, but I figured it wouldn't do any good whatsoever Ray At 09:47 AM 4/22/2004, you wrote: wow, they are giving you a hard time in there huh -Original Message- From: Cathy Taylor [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 9:34 AM To: CF-Talk Subject: Max 2003 Conference Photo This is OT, but I just got accused of trying to humiliate someone who won a photo contest and the photo is the picture (at least I'm fairly certain) that was all over the Max 2003 conference. http://www.theparentperspective.com/boards/thread-view.asp?threadid=200412p osts=15#0 Can someone clarify if it is? Thanks, Cathy _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: A lesson in security by obscurity...
spoilers -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 9:44 AM To: CF-Talk Subject: RE: A lesson in security by obscurity... answer at bottom. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 8:39 AM To: CF-Talk Subject: RE: A lesson in security by obscurity... Marlon, I'm not sure what you mean.I tried selecting everything on the page before the _javascript_ prompt and the _javascript_ prompt page.I'm confused.Any more help?What am I looking for? John -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:23 PM To: CF-Talk Subject: RE: A lesson in security by obscurity... -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wed 4/21/2004 8:14 PM To: CF-Talk Cc: Subject: RE: A lesson in security by obscurity... dude its killing me, ive typed everything in I can think of for that page, must you be a mindreader or something here...WTF??? and funny how all of us, well most of us tripped up on this one... spoiler space.. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. select all of the contents on the page with the mouse. I didn't realize it the first time, but you need to disable _javascript_, otherwise, you'll have to view the source and remove all of the font tags.If you disable _javascript_, the noscript tags will print out black characters on a black background.Select them and you have the clue. I got it by viewing source and then removing all the font tags. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
stand_alone_cfapp
All, I understand that a CF Application needs a Web server and an installation of CF.However, has anyone every built a Cold Fusion application that resides on a CD?Also, has anyone every built a CF app that would store data while off line (no network connection) and then update a datasource once the machine is connected/online again? Any comments are much appreciated. D- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMAIL PARAM
Afternoon I am coding an email to send data that the destination will read as an ini file, the original code done using JMail and ASP placed the code in the body of the email - and it is required that the following is used: MMail.ContentType = application/x-gm-impdata which in ColdFusion I believe is cfmailparam name=Content-Type value=application/x-gm-impdata however, this then sets the text as a dat file and attaches it to the email (twice) whereas I want the text in the body, as below: cfset mailtext = [Instructions] chr(13) chr(10) cfset mailtext = mailtext Dupcheck=Email chr(13) chr(10) cfmail from=[EMAIL PROTECTED] to=[EMAIL PROTECTED] subject=Web Site Import Details type= cfmailparam name=Content-Type value=application/x-gm-impdata #mailtext# /cfmail so is it possible to get the text in the body of the email when using cfmailparam name=Content-Type value=application/x-gm-impdata?? thanks, Dave -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 22 April 2004 14:50 To: CF-Talk Subject: RE: Max 2003 Conference Photo Yea, I agree.I would walk away from that place.That mediator is a little uptight.Talk about censorship!Wasn't even close to being humiliating. I even thought about posting in your defense, but I figured it wouldn't do any good whatsoever Ray At 09:47 AM 4/22/2004, you wrote: wow, they are giving you a hard time in there huh -Original Message- From: Cathy Taylor [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 9:34 AM To: CF-Talk Subject: Max 2003 Conference Photo This is OT, but I just got accused of trying to humiliate someone who won a photo contest and the photo is the picture (at least I'm fairly certain) that was all over the Max 2003 conference. http://www.theparentperspective.com/boards/thread-view.asp?threadid=200 412p osts=15#0 Can someone clarify if it is? Thanks, Cathy _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: A lesson in security by obscurity...
Marlon, Are you using IE 6?I disabled Active Scripting in Security and the noscript tags aren't showing up.This is driving me nuts. John -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 9:44 AM To: CF-Talk Subject: RE: A lesson in security by obscurity... answer at bottom. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 8:39 AM To: CF-Talk Subject: RE: A lesson in security by obscurity... Marlon, I'm not sure what you mean.I tried selecting everything on the page before the _javascript_ prompt and the _javascript_ prompt page.I'm confused.Any more help?What am I looking for? John -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:23 PM To: CF-Talk Subject: RE: A lesson in security by obscurity... -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wed 4/21/2004 8:14 PM To: CF-Talk Cc: Subject: RE: A lesson in security by obscurity... dude its killing me, ive typed everything in I can think of for that page, must you be a mindreader or something here...WTF??? and funny how all of us, well most of us tripped up on this one... spoiler space.. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. select all of the contents on the page with the mouse. I didn't realize it the first time, but you need to disable _javascript_, otherwise, you'll have to view the source and remove all of the font tags.If you disable _javascript_, the noscript tags will print out black characters on a black background.Select them and you have the clue. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Browser compatibility testing
You might check out Mozie http://www.zeit.ca/mozie/ Doug Thomas Chiverton wrote: On Wednesday 21 Apr 2004 19:21 pm, ketan patel wrote: I am looking for a tool or software to test my application in all browsers for Windows,MAC,Linux.Please let me know about this if anybody know about it. I know there is a web site that will do this, and email you pictures of you site under various browers/OS. Can't remember the name. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: A lesson in security by obscurity...
Can we move this to CF-OT, or continue in the conversation in CF-Community? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: A lesson in security by obscurity...
Nope, Firefoxbtw, this thread is continuing in CF-community. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 9:02 AM To: CF-Talk Subject: RE: A lesson in security by obscurity... Marlon, Are you using IE 6?I disabled Active Scripting in Security and the noscript tags aren't showing up.This is driving me nuts. John -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 9:44 AM To: CF-Talk Subject: RE: A lesson in security by obscurity... answer at bottom. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 8:39 AM To: CF-Talk Subject: RE: A lesson in security by obscurity... Marlon, I'm not sure what you mean.I tried selecting everything on the page before the _javascript_ prompt and the _javascript_ prompt page.I'm confused.Any more help?What am I looking for? John -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:23 PM To: CF-Talk Subject: RE: A lesson in security by obscurity... -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wed 4/21/2004 8:14 PM To: CF-Talk Cc: Subject: RE: A lesson in security by obscurity... dude its killing me, ive typed everything in I can think of for that page, must you be a mindreader or something here...WTF??? and funny how all of us, well most of us tripped up on this one... spoiler space.. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. select all of the contents on the page with the mouse. I didn't realize it the first time, but you need to disable _javascript_, otherwise, you'll have to view the source and remove all of the font tags.If you disable _javascript_, the noscript tags will print out black characters on a black background.Select them and you have the clue. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Max 2003 Conference Photo
Thanks all! I don't mind being wrong - that's why I asked :-) But the reaction to the question really miffed me. Thanks for the clarification and LOL Thanks for nearly jumping to my defense. Yep, definitely not a place to hang around :-) Cathy No, it looks like you were in the wrong: http://www.macromedia.com/macromedia/conference/images/max_wallpaper_gra ss.jpg John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: stand_alone_cfapp
I believe there's an app named Coral that allows you to build a limited CF app that runs on a CD. John Burns -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 9:57 AM To: CF-Talk Subject: stand_alone_cfapp All, I understand that a CF Application needs a Web server and an installation of CF.However, has anyone every built a Cold Fusion application that resides on a CD?Also, has anyone every built a CF app that would store data while off line (no network connection) and then update a datasource once the machine is connected/online again? Any comments are much appreciated. D- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: stand_alone_cfapp
To your second question, there is an interesting example on WDDX at webmonkey.com ( http://hotwired.lycos.com/webmonkey/99/15/index3a.html?tw=authoring) that demonstrates an application where data is sent to the client with WDDX.It is then modified by the user on the client and not until he is done is the data sent back to the server again with WDDX. HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: WYSIWYG HTML Editors...
www.editlet.com ?Thanks. Nice tool indeed -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Max 2003 Conference Photo
The original pics are here: http://www.macromedia.com/macromedia/conference/ Similar style, but definately a different photo... -Original Message- From: Cathy Taylor [mailto:[EMAIL PROTECTED] Sent: Thursday, 22 April 2004 11:34 PM To: CF-Talk Subject: Max 2003 Conference Photo This is OT, but I just got accused of trying to humiliate someone who won a photo contest and the photo is the picture (at least I'm fairly certain) that was all over the Max 2003 conference. http://www.theparentperspective.com/boards/thread-view.asp?threadid=200412p osts=15#0 Can someone clarify if it is? Thanks, Cathy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: WYSIWYG HTML Editors...
HTMLArea v3 I just had a look at it, and the undo/redo feature seems to bo out of order. -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
MAX Registration / Topics?
Anyone have any idea on when the registration for MAX will begin and when there will be more info on hotels, topics, etc.?Thanks! John PS- Ben Forta is not allowed to say soon unless it's followed by an actual date. :-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: A lesson in security by obscurity...
One last note on this topic It seems that there is a problem with number 8 according to root of the site http://www.academy.dyndns.org/ THE TRAFFIC PROBLEM IN LEVEL 8 WILL BE FIXED THURSDAY Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 9:05 AM To: CF-Talk Subject: RE: A lesson in security by obscurity... Nope, Firefoxbtw, this thread is continuing in CF-community. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 9:02 AM To: CF-Talk Subject: RE: A lesson in security by obscurity... Marlon, Are you using IE 6?I disabled Active Scripting in Security and the noscript tags aren't showing up.This is driving me nuts. John -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 9:44 AM To: CF-Talk Subject: RE: A lesson in security by obscurity... answer at bottom. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 8:39 AM To: CF-Talk Subject: RE: A lesson in security by obscurity... Marlon, I'm not sure what you mean.I tried selecting everything on the page before the _javascript_ prompt and the _javascript_ prompt page.I'm confused.Any more help?What am I looking for? John -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:23 PM To: CF-Talk Subject: RE: A lesson in security by obscurity... -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wed 4/21/2004 8:14 PM To: CF-Talk Cc: Subject: RE: A lesson in security by obscurity... dude its killing me, ive typed everything in I can think of for that page, must you be a mindreader or something here...WTF??? and funny how all of us, well most of us tripped up on this one... spoiler space.. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. select all of the contents on the page with the mouse. I didn't realize it the first time, but you need to disable _javascript_, otherwise, you'll have to view the source and remove all of the font tags.If you disable _javascript_, the noscript tags will print out black characters on a black background.Select them and you have the clue. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Max 2003 Conference Photo
Whoever that PM is an arse. Its def the mm pic. -adam -Original Message- From: Cathy Taylor [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 01:33 PM To: 'CF-Talk' Subject: Max 2003 Conference Photo This is OT, but I just got accused of trying to humiliate someone who won a photo contest and the photo is the picture (at least I'm fairly certain) that was all over the Max 2003 conference. http://www.theparentperspective.com/boards/thread-view.asp?threadid=200412posts=15#0 Can someone clarify if it is? Thanks, Cathy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: FREE BD vs. $$$$ CF
$100+ do exist.And I am sure that holding one of these makes all problems solvable with hammering. $174.99 15-Ounce Titanium Hammer http://www.amazon.com/exec/obidos/tg/detail/-/B6K158/qid=1082644930/sr=1 -2/ref=sr_1_2_etk-tools/102-3185839-9957746?v=glances=hin=228013 Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Paul Kenney [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 9:38 PM To: CF-Talk Subject: RE: FREE BD vs. CF Expecially if that's a $100 hammer. Paul Kenney [EMAIL PROTECTED] 916-212-4359 -Original Message- From: Nathan C. Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 7:24 PM To: CF-Talk Subject: RE: FREE BD vs. CF When the only tool you have is a hammer you tend to see the problem as a nail. -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 7:48 PM To: CF-Talk Subject: RE: FREE BD vs. CF Actually we use CICS on our mainframe. I've just started a project where I need to deal with it for the first time. Also, just to round this out, it was IBM Consulting Services that recommended WebSphere as the obvious solution for the enterprise.The management hired them to examine our then-current applications (written for our part in CF) and determine our future course of action. How surprised were we when they settled on WebSphere on AIX? Not very.;^) Jim Davis _ From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 11:20 AM To: CF-Talk Subject: Re: FREE BD vs. CF On Apr 21, 2004, at 7:48 AM, Jim Davis wrote: This isn't all that odd. in my case the problem is similar, but comes from another end.My (very large) company won't consider either product because their both too cheap - and so (goes the management opinion) are not fit for enterprise use. I used to work for IBM Data Processing Division and many IBM products were (rumored to be) priced this way (high) because they had a perceived greater worth. One specific product comes to mind, CICS. This was a back-end terminal to MaimFrame CPU (no network) information system. It was a good system, but nowhere near the capability, power, ease-of-use, etc. of CFMX. Work was essentially completed on the product in the 1980's and it went into maintenance mode (no new development) The last I heard the number of users of the CICS (MaimFrame DOS) version was over 30,000 users. The average cost to IBM customers was $3,000 per month You do the math! Dick _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Max 2003 Conference Photo
Adam, No, it's not.Look at the wallpapers available at: http://www.macromedia.com/macromedia/conference John -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 10:41 AM To: CF-Talk Subject: Re: Max 2003 Conference Photo Whoever that PM is an arse. Its def the mm pic. -adam -Original Message- From: Cathy Taylor [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 01:33 PM To: 'CF-Talk' Subject: Max 2003 Conference Photo This is OT, but I just got accused of trying to humiliate someone who won a photo contest and the photo is the picture (at least I'm fairly certain) that was all over the Max 2003 conference. http://www.theparentperspective.com/boards/thread-view.asp?threadid=20 0412posts=15#0 Can someone clarify if it is? Thanks, Cathy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: SQL SERVER RESTORE DATABASE
Hey guys I set up a new instance of SQL server 2000 on a new machine, and am trying to restore a database from a backup file.I backed up the mdf and ldf file as well. the ldf that i backed up is 4GB.I was wondering if I needed todo something with that, or if i can just throw thataway. THanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: FREE BD vs. $$$$ CF
On Apr 21, 2004, at 5:48 PM, Jim Davis wrote: Actually we use CICS on our mainframe. I've just started a project where I need to deal with it for the first time. You might want to look into Mitem at: http://www.mitem.com For the record, my daughter has a very minor stock position in Mitem Also, just to round this out, it was IBM Consulting Services that recommended WebSphere as the obvious solution for the enterprise.  The management hired them to examine our then-current applications (written for our part in CF) and determine our future course of action. How surprised were we when they settled on WebSphere on AIX?  Not very.  ;^) Well, you go with what you know... ... It's likely different now, but when I recommended IBM products or services, I knew if they did not perform, Ihad complete access to the responsible parties, their immediate superiors... all the way to the chairman of the Board. I t gave me a lot of confidence in my recommendations -- I am not shy! Dick Jim Davis   _  From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 11:20 AM To: CF-Talk Subject: Re: FREE BD vs. CF On Apr 21, 2004, at 7:48 AM, Jim Davis wrote: This isn't all that odd. in my case the problem is similar, but comes from   another end.  My (very large) company won't consider either product because   their both too cheap - and so (goes the management opinion) are not fit for   enterprise use. I used to work for IBM Data Processing Division and many IBM products were (rumored to be) priced this way (high) because they had a perceived greater worth. One specific product comes to mind, CICS. This was a back-end terminal to MaimFrame CPU (no network) information system. It was a good system, but nowhere near the capability, power, ease-of-use, etc. of CFMX. Work was essentially completed on the product in the 1980's and it went into maintenance mode (no new development) The last I heard the number of users of the CICS (MaimFrame DOS) version was over 30,000 users. The average cost to IBM customers was $3,000 per month You do the math! Dick   _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL SERVER RESTORE DATABASE
if you did a backup, you will just be using that backup to restore -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 11:56 AM To: CF-Talk Subject: SOT: SQL SERVER RESTORE DATABASE Hey guys I set up a new instance of SQL server 2000 on a new machine, and am trying to restore a database from a backup file.I backed up the mdf and ldf file as well. the ldf that i backed up is 4GB.I was wondering if I needed todo something with that, or if i can just throw thataway. THanks! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MAX Registration / Topics?
Soon! :-) Ok, ok ... registration will open in July, is what I am being told. Hotel and other info will be posted before that, but I don't have any dates at all for that, so ... soon. --- Ben _ From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 10:18 AM To: CF-Talk Subject: MAX Registration / Topics? Anyone have any idea on when the registration for MAX will begin and when there will be more info on hotels, topics, etc.?Thanks! John PS- Ben Forta is not allowed to say soon unless it's followed by an actual date. :-) _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Windows Server 2003
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] I am *guessing* that CF5 will run on W2k3 server but, I know that it will not install correctly and register the ISAPIs for .cfm in IIS 6. I would highly advise upgrading to CFMX 6.1 if CF5 is not officially supported on W2k3 server, if this is a production server. ColdFusion 5 is officially supported to run on Windows 2003 with IIS6. Reference: http://www.macromedia.com/support/coldfusion/ts/documents/install_cf_win2003 .htm Note that although supported, the CF5 installation requires manual modifications that are described in this Tech Note. -Steven Erat [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MAX Registration / Topics?
Ok, that's acceptable.At least now I can let my manager know that I will have more info for him soon...I mean, by July.Thanks! John -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 11:03 AM To: CF-Talk Subject: RE: MAX Registration / Topics? Soon! :-) Ok, ok ... registration will open in July, is what I am being told. Hotel and other info will be posted before that, but I don't have any dates at all for that, so ... soon. --- Ben _ From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 10:18 AM To: CF-Talk Subject: MAX Registration / Topics? Anyone have any idea on when the registration for MAX will begin and when there will be more info on hotels, topics, etc.?Thanks! John PS- Ben Forta is not allowed to say soon unless it's followed by an actual date. :-) _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: stand_alone_cfapp
Look into Flash Projectors (Flash that runs standalone...no served up by a server).The EXE file would be on the CD with perhaps an XML file for the data.The CD would have to have a light install routine (probably just copy the XML file to the user's local file system).The Flash app could then suck in data from the XML file and make changes..add new datawhatever.When a net connection is detected the Flash App could prompt the user to syncronize the data (or do it transparently) with a live database. I know it's not pure CFbut it should be doable. What about Central...isn't it supposed to allow for online/offline functionality?? HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Thursday, April 22, 2004 6:56 AM Subject: stand_alone_cfapp All, I understand that a CF Application needs a Web server and an installation of CF.However, has anyone every built a Cold Fusion application that resides on a CD?Also, has anyone every built a CF app that would store data while off line (no network connection) and then update a datasource once the machine is connected/online again? Any comments are much appreciated. D- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL: hierarchical view of parent child categories
here's a good discussion of the topic: http://www.sitepoint.com/article/hierarchical-data-database/1 also google for Joe Celko --he has lots of information on the topic -- may have to do a bit of reading to dig it out, but it's there! Finally you might consider Xindice (an open source XML database) as an option -- by its nature XML is hierarchical, and a better fit for hierarchical structures HTH Dick On Apr 22, 2004, at 6:42 AM, Dowdell, Jason G wrote: Hi all, Here's s sql stumper, well, not really.  But I haven't been able to figure out the best way to do it yet so I'm posting here.  I know it's sql but it does have CF implications. Scenario: I have a table called CATEGORY with the following columns ID PK for table PARENT_ID If populated it's the ID of this category's parent NAME Name of category DESCRIPTION Description of category ACTIVE_IND Active indicator (1 | 0) DATE_ADDED Date category added to db DATE_UPDATED Date category was last updated The goal is to create a view that will go through every single category and determine the tree structure used to navigate to that category.  This table can be used for menus, directory structures, or any other app that needs the ability to store data in a hierarchical structure. The drawback of this table design is that when a user selects a particular category from the table and you want to show them where this category is in relation to it's parent(s) categories you have to jump through a lot of cfif's.  The ideal solution is to have a view that determines all of these relationships and you just run a query on that view by passing in the category you want info on and your query returns the exact hierarchical structure of the category relative to the category you selected. Here's an example: You have the following categories. Fruits Apples Washington Red Apples Fiji Golden Delicious Pears Peaches Veggies Meats When someone clicks on a link representing the Washington Red Apples category we should automatically create a navigational crumb trail with this, Fruits Apples Washington Red Apples and make each one of the parents of Washington Red Apples clickable.  This means we'll need to return their category id in our query as well. Anyone have experience in doing such a thing? Thanks, Jason Application Engineering Services Information Management Florida Operations Telephone: 321.799.6845 Fax: 321.799.5970 e-mail:[EMAIL PROTECTED] The  comments and opinions expressed are my own and do not represent the view of United Space Alliance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: 2 CFMX UPgrade Questions
Robert, The CFMX 6.1 installer was designed to permit the upgrade from ColdFusion 5 to ColdFusion MX 6.1 for J2EE.Follow the instructions during the installation to choose the upgrade path, and then choose one of the J2EE paths.Later, the second half of the installation requires that a migration wizard be run from the CFAdmin URL, and I recommend actually reading each window of information during that migration. References: ColdFusion MX Migration Overview http://macromedia.com/devnet/mx/coldfusion/articles/migration_overview.html Migrating to ColdFusion MX http://macromedia.com/devnet/mx/coldfusion/articles/migrating.html ColdFusion MX Migration Center http://macromedia.com/devnet/mx/coldfusion/migrating.html -Steven Erat From: Robert Shaw [mailto:[EMAIL PROTECTED] Hi, I am going to upgrade some of our CF 5 machines and we have a few questions we thought the CF gurus on this list may be able to answer. 1. Can we upgrade from CF 5 to CFMX for J2EE and if so will this save our settings and migrae them like a straight CFMX upgrade would? 2. I heard the built in JDBC drivers do not rely on the tsnames.ora file, is this the case and will we need manually enter our SID name? TIA, Robbie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: SQL SERVER RESTORE DATABASE
Did you backup from SQL or just copy the mdf file? You might be able to reattach the database file, although the best way to do it is to do a backup from SQL itself, then copy the backup file to the new server. You can then use the SQL restore utility to read in the backup file the new database. Matt - Original Message - From: Phoeun Pha [EMAIL PROTECTED] Date: Thu, 22 Apr 2004 09:55:43 -0700 Subject: SOT:SQL SERVER RESTORE DATABASE To: CF-Talk [EMAIL PROTECTED] Hey guys I set up a new instance of SQL server 2000 on a new machine, and am trying to restore a database from a backup file.I backed up the mdf and ldf file as well. the ldf that i backed up is 4GB.I was wondering if I needed todo something with that, or if i can just throw thataway. THanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Caching issue
Hey Guys/Gals I'm trying to work through what seems to be a caching issue on a production server.If i request a file, then rename the file and try to request its original name the file is not found-good.When i rename the file back to its original name, the file is still not found-bad.I've also requested another file, then removed it completely and the file is still rendered by the browser-bad. Does anyone have any suggestions on what settings should be checked both in CFMX and in IIS? Thanks Jason [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Which JDK with CF MX 6.1
What JDK is included with MX 6.1 - say on a windows install (if different than *nix)? 1.3 or 1.4? If 1.3 do you know if upgrading to 1.4 is supported? If 1.4 does that mean JRun is certified to run 1.4 when running CF? Thanks, Bob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I format pop3 Date!?
How would I Use ParseDateTime as an arguement or string to DateFormat!? Thank You, Jordon Bedwell Cybercom Pros (Design is only as good as your bad planning, because there is not planning in good design its art!) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Which JDK with CF MX 6.1
1.4.1 or 1.4.2 can't remember which...this is Windows and Linux Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bob Jacoby To: CF-Talk Sent: Thursday, April 22, 2004 8:28 AM Subject: Which JDK with CF MX 6.1 What JDK is included with MX 6.1 - say on a windows install (if different than *nix)? 1.3 or 1.4? If 1.3 do you know if upgrading to 1.4 is supported? If 1.4 does that mean JRun is certified to run 1.4 when running CF? Thanks, Bob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: stand_alone_cfapp
On Thursday 22 Apr 2004 16:13 pm, Bryan Stevenson wrote: What about Central...isn't it supposed to allow for online/offline functionality?? Yeah, your applet gets a 'going on|off line' event and can take whatever action is needed. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Which JDK with CF MX 6.1
What JDK is included with MX 6.1 - say on a windows install (if different than *nix)? 1.3 or 1.4? If 1.3 do you know if upgrading to 1.4 is supported? If 1.4 does that mean JRun is certified to run 1.4 when running CF? CFMX 6.1 and/or JRun 4 install 1.4.2 on Windows. I don't know about certification, but I would assume that it is certified. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Blue Dragon - StandAlone or IIS
what's the best performance: using BD with StandAlone Server or with IIS 5? While many people have already recommended that you use IIS - and I'd second their recommendations - I doubt you'll see much difference in performance. When you're using CF (or BD, I suspect), most of the work isn't being done by the web server, it's being done by the application server. The big advantage of using IIS is that it's easier to manage, and it can do more things than the built-in web server. IIS is probably faster in serving static content, but static content isn't likely to be your bottleneck. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Archive CF5 - Deploy CFMX?
The deployment of .car files built in CF5 to CFMX is not supported. -Steven Erat -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, April 17, 2004 1:33 PM To: CF-Talk Subject: Archive CF5 - Deploy CFMX? I know I've done this before, but it doesn't seem to be working now.I'm attempting to archive various applications on a CF5 server and deploy on a CFMX server.The deployment fails with an error indicating the car.variable.workingdir variable does not exist (although I've verfied that it was set at the time of the archive on CF5). Any suggestions would be greatly appreciated?Also, is it possible this might have worked with 6.0 but not in 6.1? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Max 2003 Conference Photo
I'm not sure if it was that exact one (I mean, clouds 'n' grass - could be), but it's definitely the same composition. You'd need a copy of both to be sure and, sorry, I don't have one. Jim Davis _ From: Cathy Taylor [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 9:34 AM To: CF-Talk Subject: Max 2003 Conference Photo This is OT, but I just got accused of trying to humiliate someone who won a photo contest and the photo is the picture (at least I'm fairly certain) that was all over the Max 2003 conference. http://www.theparentperspective.com/boards/thread-view.asp?threadid=200412p osts=15#0 Can someone clarify if it is? Thanks, Cathy _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Generic Table Copy from one DB to another
I'm trying to write a script which will take as an argument a table name, then copy the data from that table in one table to an identical table in another database (assuming that the target database has a blank table with an identical structure). Has anyone attempted this sort of task before?How would I go about starting this project? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Generic Table Copy from one DB to another
don't need to do all that, look up select into tis what you want to use. tony -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:03 PM To: CF-Talk Subject: Generic Table Copy from one DB to another I'm trying to write a script which will take as an argument a table name, then copy the data from that table in one table to an identical table in another database (assuming that the target database has a blank table with an identical structure). Has anyone attempted this sort of task before?How would I go about starting this project? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Caching issue
Have you checked to ensure that the browser isn't caching it?Try multiple machines? John -Original Message- From: Jason Rogoz [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 11:26 AM To: CF-Talk Subject: Caching issue Hey Guys/Gals I'm trying to work through what seems to be a caching issue on a production server.If i request a file, then rename the file and try to request its original name the file is not found-good.When i rename the file back to its original name, the file is still not found-bad.I've also requested another file, then removed it completely and the file is still rendered by the browser-bad. Does anyone have any suggestions on what settings should be checked both in CFMX and in IIS? Thanks Jason [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generic Table Copy from one DB to another
are the source and target db's 1) on the same db server? 2) on different db servers local to the same host 3) on different db servers local to different hosts. 4) are you trying to create an exact duplicate of the source in the target or update the target? what db servers? Depending on the above answers, you may be able to: 1) use built-in db server commands/features 2) write a CF query of the source and iterate over it, doing inserts/updates with the target 3) you may have to do some data exchange using WDDX with a stub program on the target host and do the above HTH Dick On Apr 22, 2004, at 9:02 AM, Richard Crawford wrote: I'm trying to write a script which will take as an argument a table name, then copy the data from that table in one table to an identical table in another database (assuming that the target database has a blank table with an identical structure). Has anyone attempted this sort of task before?  How would I go about starting this project? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Which JDK with CF MX 6.1
Well, from http://java.sun.com/j2ee/compatibility.html it's not certified. So they're shipping with something they're not certified to run correctly. Nice. Few vendors are 1.4 certified, BEA being notably absent. I'd expect them to hold off on shipping 1.4 pieces until they are (like BEA) or at least say it's a preview (like Oracle did until they were certified). Of course, what MM supports is often weird. For example, when I was looking at things a few months back they listed support for CF MX on top of JRun4 in a RedHat ES environment even though JRun4 didn't support Redhat ES. How does that work? Bob [EMAIL PROTECTED] 04/22/04 10:44AM What JDK is included with MX 6.1 - say on a windows install (if different than *nix)? 1.3 or 1.4? If 1.3 do you know if upgrading to 1.4 is supported? If 1.4 does that mean JRun is certified to run 1.4 when running CF? CFMX 6.1 and/or JRun 4 install 1.4.2 on Windows. I don't know about certification, but I would assume that it is certified. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generic Table Copy from one DB to another
Dick Applebaum wrote: are the source and target db's 1) on the same db server? 2) on different db servers local to the same host 3) on different db servers local to different hosts. 4) are you trying to create an exact duplicate of the source in the target or update the target? what db servers? The databases are on two different servers, but I don't believe that's an issue since both are accessible to Cold Fusion, and I believe I can maintain two separate datasources at once.Both databases are in SQL Server. The two databases are... DBA - DBB tab1A tab1B tab2A tab2B ... tabnA tabnB I want to replace all of the data in tab1B with the data in tab1A, then all the data in tab2B with all the data in tab2A, and so on. Ordinarily I would use the bcp utility to take care of this task, but there are a couple of reasons why I can't this time. Depending on the above answers, you may be able to: 1) use built-in db server commands/features Won't work, unfortunately.See above. 2) write a CF query of the source and iterate over it, doing inserts/updates with the target That was my plan.I can't figure out how to insert into the target table without specifically referencing the field names of the source table, which I'm hoping to avoid. 3) you may have to do some data exchange using WDDX with a stub program on the target host and do the above Haven't got a clue how to do that. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generic Table Copy from one DB to another
Well as long as the request is generic. This is a Very generic... Brute force approach.You get the idea. the syntax might need a little help. cfquery datasource=#sourcedatabasename# name=source select * from #tablename# /cfquery cfloop index=i from=1 to=#source.recordcount# cfquery datasource=#targetdatabasename# name=target insert into #tablename# ( #source.columnlist# ) Values ( cfloop index=j from=1 to=#listlen(source.columnlist)# '## #listgetat(source.columnlist, j)# ##' /cfloop ) /cfquery /cfloop At 09:02 AM 4/22/04, you wrote: I'm trying to write a script which will take as an argument a table name, then copy the data from that table in one table to an identical table in another database (assuming that the target database has a blank table with an identical structure). Has anyone attempted this sort of task before?How would I go about starting this project? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Generic Table Copy from one DB to another
why not use select into? -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:38 PM To: CF-Talk Subject: Re: Generic Table Copy from one DB to another Well as long as the request is generic. This is a Very generic... Brute force approach.You get the idea. the syntax might need a little help. cfquery datasource=#sourcedatabasename# name=source select * from #tablename# /cfquery cfloop index=i from=1 to=#source.recordcount# cfquery datasource=#targetdatabasename# name=target insert into #tablename# ( #source.columnlist# ) Values ( cfloop index=j from=1 to=#listlen(source.columnlist)# '## #listgetat(source.columnlist, j)# ##' /cfloop ) /cfquery /cfloop At 09:02 AM 4/22/04, you wrote: I'm trying to write a script which will take as an argument a table name, then copy the data from that table in one table to an identical table in another database (assuming that the target database has a blank table with an identical structure). Has anyone attempted this sort of task before?How would I go about starting this project? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generic Table Copy from one DB to another
Tony Weeg wrote: why not use select into? I am still looking for information about select into. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Caching issue
I have checked on multiple machines and the issue was replicated on all of them.It looks to me like either CFMX is caching the page or IIS is caching the page somehow. Jason -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thu 4/22/2004 10:23 AM To: CF-Talk Cc: Subject: RE: Caching issue Have you checked to ensure that the browser isn't caching it?Try multiple machines? John -Original Message- From: Jason Rogoz [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 11:26 AM To: CF-Talk Subject: Caching issue Hey Guys/Gals I'm trying to work through what seems to be a caching issue on a production server.If i request a file, then rename the file and try to request its original name the file is not found-good.When i rename the file back to its original name, the file is still not found-bad.I've also requested another file, then removed it completely and the file is still rendered by the browser-bad. Does anyone have any suggestions on what settings should be checked both in CFMX and in IIS? Thanks Jason _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Generic Table Copy from one DB to another
ok... here ya go...simple but effective. select * INTO server_B.something.dbo.database_B from server_A.something.dbo.database_A that will take everything from a to b, table structure etc. tw -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:49 PM To: CF-Talk Subject: Re: Generic Table Copy from one DB to another Tony Weeg wrote: why not use select into? I am still looking for information about select into. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Caching issue
does your issue exist for .html files as well as .cfm files?If only for cfm files an dnot html files, its CFMX doing it.Check your caching settings in teh CF Admin tool.trusted cache and save class files settigns. Doug -Original Message- From: Jason M. Rogoz [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:54 PM To: CF-Talk Subject: RE: Caching issue I have checked on multiple machines and the issue was replicated on all of them.It looks to me like either CFMX is caching the page or IIS is caching the page somehow. Jason -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thu 4/22/2004 10:23 AM To: CF-Talk Cc: Subject: RE: Caching issue Have you checked to ensure that the browser isn't caching it?Try multiple machines? John -Original Message- From: Jason Rogoz [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 11:26 AM To: CF-Talk Subject: Caching issue Hey Guys/Gals I'm trying to work through what seems to be a caching issue on a production server.If i request a file, then rename the file and try to request its original name the file is not found-good.When i rename the file back to its original name, the file is still not found-bad.I've also requested another file, then removed it completely and the file is still rendered by the browser-bad. Does anyone have any suggestions on what settings should be checked both in CFMX and in IIS? Thanks Jason _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generic Table Copy from one DB to another
Tony Weeg wrote: ok... here ya go...simple but effective. select * INTO server_B.something.dbo.database_B from server_A.something.dbo.database_A that will take everything from a to b, table structure etc. tw I must need more coffee this morning, because I can't find any reference to this in my CF manuals.Can you point me to an on-line reference with some more information? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Caching issue
From time to time I have had the same issue... I just restart and all is well. Don't know that you can do that but... it's a quick idea. At 09:59 AM 4/22/04, you wrote: does your issue exist for .html files as well as .cfm files?If only for cfm files an dnot html files, its CFMX doing it.Check your caching settings in teh CF Admin tool.trusted cache and save class files settigns. Doug -Original Message- From: Jason M. Rogoz [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:54 PM To: CF-Talk Subject: RE: Caching issue I have checked on multiple machines and the issue was replicated on all of them.It looks to me like either CFMX is caching the page or IIS is caching the page somehow. Jason -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thu 4/22/2004 10:23 AM To: CF-Talk Cc: Subject: RE: Caching issue Have you checked to ensure that the browser isn't caching it?Try multiple machines? John -Original Message- From: Jason Rogoz [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 11:26 AM To: CF-Talk Subject: Caching issue Hey Guys/Gals I'm trying to work through what seems to be a caching issue on a production server.If i request a file, then rename the file and try to request its original name the file is not found-good.When i rename the file back to its original name, the file is still not found-bad.I've also requested another file, then removed it completely and the file is still rendered by the browser-bad. Does anyone have any suggestions on what settings should be checked both in CFMX and in IIS? Thanks Jason _ _ -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:160995This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=664.584.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=41 [] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generic Table Copy from one DB to another
It's sql not cf http://www.w3schools.com/sql/sql_select_into.asp At 10:08 AM 4/22/04, you wrote: I must need more coffee this morning, because I can't find any reference to this in my CF manuals.Can you point me to an on-line reference with some more information? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Generic Table Copy from one DB to another
Hey Tony, how ya do this with cf?the query extends across two databases... reading source from one and writing to the second... would be great to know. thanks. At 09:51 AM 4/22/04, you wrote: ok... here ya go...simple but effective. select * INTO server_B.something.dbo.database_B from server_A.something.dbo.database_A that will take everything from a to b, table structure etc. tw -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:49 PM To: CF-Talk Subject: Re: Generic Table Copy from one DB to another Tony Weeg wrote: why not use select into? I am still looking for information about select into. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:160994This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=664.584.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=40 [] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generic Table Copy from one DB to another
Presuming M$ SQL Server, one could write a stored procedure the perform the 'select into'. One note, if the goal is to be able to pass in any source table and any matching destination table then the stored proc would have to build a string and then use 'exec sp_executesql' to execute the string. Doug Gonzo Rock wrote: Hey Tony, how ya do this with cf?the query extends across two databases... reading source from one and writing to the second... would be great to know. thanks. At 09:51 AM 4/22/04, you wrote: ok... here ya go...simple but effective. select * INTO server_B.something.dbo.database_B from server_A.something.dbo.database_A that will take everything from a to b, table structure etc. tw -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:49 PM To: CF-Talk Subject: Re: Generic Table Copy from one DB to another Tony Weeg wrote: why not use select into? I am still looking for information about select into. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:160994This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=664.584.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=40 [] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Apache 1.3.28 CF5 on Windows
I installed a new copy of apache 1.3.28on a windows 2000 machine. I configured it like all the copies of the installation manual for CF+apache say by adding the two lines needed: LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll AddModule mod_coldfusion.c However, when I try to issue the restart command for apache, it says Restart failed. It gives me no error message at all. Things to note: This box already runs ColdFusion with IIS 5.0. I am running this version of apache on port 88 and was hoping to test my application on the apache web server. Perhaps this is why apache is having problems starting. Can anyone offer any insight on this? Jason Gulledge ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL: hierarchical view of parent child categories
Thanks for the feedback.I have read articles by him before and his articles were what I used to learn exactly how hierarchical data is stored in tables. Thanks again, Jason -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 11:15 AM To: CF-Talk Subject: Re: SQL: hierarchical view of parent child categories here's a good discussion of the topic: http://www.sitepoint.com/article/hierarchical-data-database/1 also google for Joe Celko --he has lots of information on the topic -- may have to do a bit of reading to dig it out, but it's there! Finally you might consider Xindice (an open source XML database) as an option -- by its nature XML is hierarchical, and a better fit for hierarchical structures HTH Dick On Apr 22, 2004, at 6:42 AM, Dowdell, Jason G wrote: Hi all, Here's s sql stumper, well, not really.But I haven't been able to figure out the best way to do it yet so I'm posting here.I know it's sql but it does have CF implications. Scenario: I have a table called CATEGORY with the following columns ID PK for table PARENT_ID If populated it's the ID of this category's parent NAME Name of category DESCRIPTION Description of category ACTIVE_IND Active indicator (1 | 0) DATE_ADDED Date category added to db DATE_UPDATED Date category was last updated The goal is to create a view that will go through every single category and determine the tree structure used to navigate to that category.This table can be used for menus, directory structures, or any other app that needs the ability to store data in a hierarchical structure. The drawback of this table design is that when a user selects a particular category from the table and you want to show them where this category is in relation to it's parent(s) categories you have to jump through a lot of cfif's.The ideal solution is to have a view that determines all of these relationships and you just run a query on that view by passing in the category you want info on and your query returns the exact hierarchical structure of the category relative to the category you selected. Here's an example: You have the following categories. Fruits Apples Washington Red Apples Fiji Golden Delicious Pears Peaches Veggies Meats When someone clicks on a link representing the Washington Red Apples category we should automatically create a navigational crumb trail with this, Fruits Apples Washington Red Apples and make each one of the parents of Washington Red Apples clickable.This means we'll need to return their category id in our query as well. Anyone have experience in doing such a thing? Thanks, Jason Application Engineering Services Information Management Florida Operations Telephone: 321.799.6845 Fax: 321.799.5970 e-mail:[EMAIL PROTECTED] Thecomments and opinions expressed are my own and do not represent the view of United Space Alliance. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Apache 1.3.28 CF5 on Windows
Did you move the ApacheModuleColdFusion.dll file to your apache 'modules' directory?If not, you can either do that, or just specify the full path to the DLL (I think it's in the cfusion/bin dir).Just remember to use the forward slash. Cheers, barneyb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 10:42 AM To: CF-Talk Subject: Apache 1.3.28 CF5 on Windows I installed a new copy of apache 1.3.28on a windows 2000 machine. I configured it like all the copies of the installation manual for CF+apache say by adding the two lines needed: LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll AddModule mod_coldfusion.c However, when I try to issue the restart command for apache, it says Restart failed. It gives me no error message at all. Things to note: This box already runs ColdFusion with IIS 5.0. I am running this version of apache on port 88 and was hoping to test my application on the apache web server. Perhaps this is why apache is having problems starting. Can anyone offer any insight on this? Jason Gulledge ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generic Table Copy from one DB to another
Doug James wrote: Presuming M$ SQL Server, one could write a stored procedure the perform the 'select into'. One note, if the goal is to be able to pass in any source table and any matching destination table then the stored proc would have to build a string and then use 'exec sp_executesql' to execute the string. We won't be using stored procedures for this particular task.The goal, for various reasons, is to stick with CF. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Apache 1.3.28 CF5 on Windows
I did.I also tried using the full path.I know it loaded properly because without the AddModule mod_coldfusion.c it errored because it said it couldn't find the .c I figured once I had done that, I'd be home free. Not the case =( Jason -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:46 PM To: CF-Talk Subject: RE: Apache 1.3.28 CF5 on Windows Did you move the ApacheModuleColdFusion.dll file to your apache 'modules' directory?If not, you can either do that, or just specify the full path to the DLL (I think it's in the cfusion/bin dir).Just remember to use the forward slash. Cheers, barneyb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 10:42 AM To: CF-Talk Subject: Apache 1.3.28 CF5 on Windows I installed a new copy of apache 1.3.28on a windows 2000 machine. I configured it like all the copies of the installation manual for CF+apache say by adding the two lines needed: LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll AddModule mod_coldfusion.c However, when I try to issue the restart command for apache, it says Restart failed. It gives me no error message at all. Things to note: This box already runs ColdFusion with IIS 5.0. I am running this version of apache on port 88 and was hoping to test my application on the apache web server. Perhaps this is why apache is having problems starting. Can anyone offer any insight on this? Jason Gulledge ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Generic Table Copy from one DB to another
Presuming Oracle, this could be done using the data dictionary. -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:50 PM To: CF-Talk Subject: Re: Generic Table Copy from one DB to another Doug James wrote: Presuming M$ SQL Server, one could write a stored procedure the perform the 'select into'. One note, if the goal is to be able to pass in any source table and any matching destination table then the stored proc would have to build a string and then use 'exec sp_executesql' to execute the string. We won't be using stored procedures for this particular task.The goal, for various reasons, is to stick with CF. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Apache 1.3.28 CF5 on Windows
'Nother stupid question.Did you check the apache error.log? I've got this in my config file (CF4.5 on Apache 1.3 on win2k) # # buncha load modules LoadModule coldfusion_module C:/CFUSION/bin/ApacheModuleColdFusion.dll # buncha add modules AddModule mod_coldfusion.c # I'm not sure if it matters, but did you try putting the the LoadModule up with the other LoadModules, rather than right above the AddModule? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 10:52 AM To: CF-Talk Subject: RE: Apache 1.3.28 CF5 on Windows I did.I also tried using the full path.I know it loaded properly because without the AddModule mod_coldfusion.c it errored because it said it couldn't find the .c I figured once I had done that, I'd be home free. Not the case =( Jason -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:46 PM To: CF-Talk Subject: RE: Apache 1.3.28 CF5 on Windows Did you move the ApacheModuleColdFusion.dll file to your apache 'modules' directory?If not, you can either do that, or just specify the full path to the DLL (I think it's in the cfusion/bin dir).Just remember to use the forward slash. Cheers, barneyb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 10:42 AM To: CF-Talk Subject: Apache 1.3.28 CF5 on Windows I installed a new copy of apache 1.3.28on a windows 2000 machine. I configured it like all the copies of the installation manual for CF+apache say by adding the two lines needed: LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll AddModule mod_coldfusion.c However, when I try to issue the restart command for apache, it says Restart failed. It gives me no error message at all. Things to note: This box already runs ColdFusion with IIS 5.0. I am running this version of apache on port 88 and was hoping to test my application on the apache web server. Perhaps this is why apache is having problems starting. Can anyone offer any insight on this? Jason Gulledge ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL: hierarchical view of parent child categories
This is a little off the topic, but might provide an alternate solution that's just as usable. I usually use the adjacency list model (really simple to build the backend), and then build a recordset that has the tree in linear form (a lanested set model), along with some metadata (like node indexes and counts at each level), and then cache that in memory.Do that and it's even faster than an nested set model for certain operations, at the expense of having to regenerate it when you make changes.It's quite nasty to implement on CF4.5 and less, because they lack QofQs, but on CF5 or CFMX, it's really quite simple. Cheers, barneyb -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 10:43 AM To: CF-Talk Subject: RE: SQL: hierarchical view of parent child categories Thanks for the feedback.I have read articles by him before and his articles were what I used to learn exactly how hierarchical data is stored in tables. Thanks again, Jason [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Apache 1.3.28 CF5 on Windows
Hah, its ok. The stupid questions are good to get out of the way first. I checked the logfiles--nothing in them.I changed the configuration to have the log set to debug rather than just warn. I tried restarting--nothing in the log again. My LoadModule is up with the other LoadModules (I appended to the bottom of the list). The addModule is with the other AddModules (I appended it to the bottom as well). -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:58 PM To: CF-Talk Subject: RE: Apache 1.3.28 CF5 on Windows 'Nother stupid question.Did you check the apache error.log? I've got this in my config file (CF4.5 on Apache 1.3 on win2k) # # buncha load modules LoadModule coldfusion_module C:/CFUSION/bin/ApacheModuleColdFusion.dll # buncha add modules AddModule mod_coldfusion.c # I'm not sure if it matters, but did you try putting the the LoadModule up with the other LoadModules, rather than right above the AddModule? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 10:52 AM To: CF-Talk Subject: RE: Apache 1.3.28 CF5 on Windows I did.I also tried using the full path.I know it loaded properly because without the AddModule mod_coldfusion.c it errored because it said it couldn't find the .c I figured once I had done that, I'd be home free. Not the case =( Jason -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:46 PM To: CF-Talk Subject: RE: Apache 1.3.28 CF5 on Windows Did you move the ApacheModuleColdFusion.dll file to your apache 'modules' directory?If not, you can either do that, or just specify the full path to the DLL (I think it's in the cfusion/bin dir).Just remember to use the forward slash. Cheers, barneyb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 10:42 AM To: CF-Talk Subject: Apache 1.3.28 CF5 on Windows I installed a new copy of apache 1.3.28on a windows 2000 machine. I configured it like all the copies of the installation manual for CF+apache say by adding the two lines needed: LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll AddModule mod_coldfusion.c However, when I try to issue the restart command for apache, it says Restart failed. It gives me no error message at all. Things to note: This box already runs ColdFusion with IIS 5.0. I am running this version of apache on port 88 and was hoping to test my application on the apache web server. Perhaps this is why apache is having problems starting. Can anyone offer any insight on this? Jason Gulledge ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Web Server for CFMX
Can anyone recommend a good web server for running CFMX on a windows platform, (other than IIS).I currently have apache running, but am having major problems with getting ssl working correctly. Thanks Dan P [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Generic Table Copy from one DB to another
with cf?
cfquery name=get datasource=dsn1
select * from thisTable
/cfquery
cfloop query=get
cfquery name=set datasource=dsn2
insert into newTable
(column1, column2, column3)
values
('#get.value1#','#get.value2#','#get.value3#')
/cfquery
/cfloop
that's just one way...that I usually use!
-Original Message-
From: Gonzo Rock [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 1:14 PM
To: CF-Talk
Subject: RE: Generic Table Copy from one DB to another
Hey Tony, how ya do this with cf?the query extends across two databases...
reading source from one and writing to the second... would be great to know.
thanks.
At 09:51 AM 4/22/04, you wrote:
ok...
here ya go...simple but effective.
select *
INTO server_B.something.dbo.database_B
from server_A.something.dbo.database_A
that will take everything from a to b, table structure etc.
tw
-Original Message-
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 12:49 PM
To: CF-Talk
Subject: Re: Generic Table Copy from one DB to another
Tony Weeg wrote:
why not use select into?
I am still looking for information about select into.
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
--
[http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads]
[http://www.houseoffusion.com/lists.cfm/link=i:4:160994This Message]
[http://www.houseoffusion.com/lists.cfm/link=s:4Subscription]
[http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=664.584.4
Fast
Unsubscribe] [http://www.houseoffusion.com/signin/User Settings]
--
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
[]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Apache 1.3.28 CF5 on Windows
well whatever it was, its fixed. My solution: 1. Overwrite httpd.conf with httpd.conf.default. 2. add the loadmodule and addmodule lines. 3. restart. That worked. Thanks for asking the stupid questions and making me start off at square one. -Original Message- From: Gulledge, Jason Sent: Thursday, April 22, 2004 1:05 PM To: CF-Talk Subject: RE: Apache 1.3.28 CF5 on Windows Hah, its ok. The stupid questions are good to get out of the way first. I checked the logfiles--nothing in them.I changed the configuration to have the log set to debug rather than just warn. I tried restarting--nothing in the log again. My LoadModule is up with the other LoadModules (I appended to the bottom of the list). The addModule is with the other AddModules (I appended it to the bottom as well). -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:58 PM To: CF-Talk Subject: RE: Apache 1.3.28 CF5 on Windows 'Nother stupid question.Did you check the apache error.log? I've got this in my config file (CF4.5 on Apache 1.3 on win2k) # # buncha load modules LoadModule coldfusion_module C:/CFUSION/bin/ApacheModuleColdFusion.dll # buncha add modules AddModule mod_coldfusion.c # I'm not sure if it matters, but did you try putting the the LoadModule up with the other LoadModules, rather than right above the AddModule? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 10:52 AM To: CF-Talk Subject: RE: Apache 1.3.28 CF5 on Windows I did.I also tried using the full path.I know it loaded properly because without the AddModule mod_coldfusion.c it errored because it said it couldn't find the .c I figured once I had done that, I'd be home free. Not the case =( Jason -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:46 PM To: CF-Talk Subject: RE: Apache 1.3.28 CF5 on Windows Did you move the ApacheModuleColdFusion.dll file to your apache 'modules' directory?If not, you can either do that, or just specify the full path to the DLL (I think it's in the cfusion/bin dir).Just remember to use the forward slash. Cheers, barneyb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 10:42 AM To: CF-Talk Subject: Apache 1.3.28 CF5 on Windows I installed a new copy of apache 1.3.28on a windows 2000 machine. I configured it like all the copies of the installation manual for CF+apache say by adding the two lines needed: LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll AddModule mod_coldfusion.c However, when I try to issue the restart command for apache, it says Restart failed. It gives me no error message at all. Things to note: This box already runs ColdFusion with IIS 5.0. I am running this version of apache on port 88 and was hoping to test my application on the apache web server. Perhaps this is why apache is having problems starting. Can anyone offer any insight on this? Jason Gulledge ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Generic Table Copy from one DB to another
or you can certainly update, delete or do whatever, but in the scenario he
is looking for, I believe it's an insert...
but seriously a select into is the easiest.
im not sure who the original poster was...but are you looking for a one time
thing to do, or something to do day to day, etc...?
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 2:09 PM
To: CF-Talk
Subject: RE: Generic Table Copy from one DB to another
with cf?
cfquery name=get datasource=dsn1
select * from thisTable
/cfquery
cfloop query=get
cfquery name=set datasource=dsn2
insert into newTable
(column1, column2, column3)
values
('#get.value1#','#get.value2#','#get.value3#')
/cfquery
/cfloop
that's just one way...that I usually use!
-Original Message-
From: Gonzo Rock [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 1:14 PM
To: CF-Talk
Subject: RE: Generic Table Copy from one DB to another
Hey Tony, how ya do this with cf?the query extends across two databases...
reading source from one and writing to the second... would be great to know.
thanks.
At 09:51 AM 4/22/04, you wrote:
ok...
here ya go...simple but effective.
select *
INTO server_B.something.dbo.database_B
from server_A.something.dbo.database_A
that will take everything from a to b, table structure etc.
tw
-Original Message-
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 12:49 PM
To: CF-Talk
Subject: Re: Generic Table Copy from one DB to another
Tony Weeg wrote:
why not use select into?
I am still looking for information about select into.
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
--
[http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads]
[http://www.houseoffusion.com/lists.cfm/link=i:4:160994This Message]
[http://www.houseoffusion.com/lists.cfm/link=s:4Subscription]
[http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=664.584.4
Fast
Unsubscribe] [http://www.houseoffusion.com/signin/User Settings]
--
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
[]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Enter key not working to submit?
Thanks for the update.So, versions would be taken into consideration as well for ua detection. On Thursday 22 Apr 2004 03:04 am, ChunshenLi wrote: js keycode etc. is fine it works while with Netscape (my version 6.2.1) it won't. However there is good key capture behaviour in recent Mozilla's, and of course the usual gaggle of cross-platform libraries to make adding events easy across platforms. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Web Server for CFMX
You have few choices - IBM Websphere Sun Java OSX/Unix Oracle application server What is wrong with IIS? == We can get rid of spam on your domain! , Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == - Original Message - From: Daniel Pacitti - ASP To: CF-Talk Sent: Thursday, April 22, 2004 1:04 PM Subject: Web Server for CFMX Can anyone recommend a good web server for running CFMX on a windows platform, (other than IIS).I currently have apache running, but am having major problems with getting ssl working correctly. Thanks Dan P [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Generic Table Copy from one DB to another
na he was asking for a generic script that could be specified at
runtime what tables were involved... so i gave him a cf routine similar to
yours but generic... mine has a small problem with the insert... but I'm
sure he can figure it out...
I was just curious as to how you would use a select into statement in a
cfquery across databases with cf...
later,
Gonz
At 11:18 AM 4/22/04, you wrote:
or you can certainly update, delete or do whatever, but in the scenario he
is looking for, I believe it's an insert...
but seriously a select into is the easiest.
im not sure who the original poster was...but are you looking for a one time
thing to do, or something to do day to day, etc...?
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 2:09 PM
To: CF-Talk
Subject: RE: Generic Table Copy from one DB to another
with cf?
cfquery name=get datasource=dsn1
select * from thisTable
/cfquery
cfloop query=get
cfquery name=set datasource=dsn2
insert into newTable
(column1, column2, column3)
values
('#get.value1#','#get.value2#','#get.value3#')
/cfquery
/cfloop
that's just one way...that I usually use!
-Original Message-
From: Gonzo Rock [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 1:14 PM
To: CF-Talk
Subject: RE: Generic Table Copy from one DB to another
Hey Tony, how ya do this with cf?the query extends across two databases...
reading source from one and writing to the second... would be great to know.
thanks.
At 09:51 AM 4/22/04, you wrote:
ok...
here ya go...simple but effective.
select *
INTO server_B.something.dbo.database_B
from server_A.something.dbo.database_A
that will take everything from a to b, table structure etc.
tw
-Original Message-
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 12:49 PM
To: CF-Talk
Subject: Re: Generic Table Copy from one DB to another
Tony Weeg wrote:
why not use select into?
I am still looking for information about select into.
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
--
[http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads]
[http://www.houseoffusion.com/lists.cfm/link=i:4:160994This Message]
[http://www.houseoffusion.com/lists.cfm/link=s:4Subscription]
[http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=664.584.4
Fast
Unsubscribe] [http://www.houseoffusion.com/signin/User Settings]
--
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
[]
--
[http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads]
[http://www.houseoffusion.com/lists.cfm/link=i:4:161013This Message]
[http://www.houseoffusion.com/lists.cfm/link=s:4Subscription]
[http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=664.584.4Fast
Unsubscribe] [http://www.houseoffusion.com/signin/User Settings]
--
http://www.houseoffusion.com/banners/view.cfm?bannerid=36
[]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Query to find Primary key?
Is it possible to find the column name of the primary key in a table from a query? Select getPrimarykey() as Pkey >From table FYI I'm running MS SQL2000 Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Generic Table Copy from one DB to another
cfquery name=get datasource=dsn1
select *
INTO server_B.something.dbo.database_B from
server_A.something.dbo.database_A
/cfquery
just like that.
tony
-Original Message-
From: Gonzo Rock [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 2:36 PM
To: CF-Talk
Subject: RE: Generic Table Copy from one DB to another
na he was asking for a generic script that could be specified at
runtime what tables were involved... so i gave him a cf routine similar to
yours but generic... mine has a small problem with the insert... but I'm
sure he can figure it out...
I was just curious as to how you would use a select into statement in a
cfquery across databases with cf...
later,
Gonz
At 11:18 AM 4/22/04, you wrote:
or you can certainly update, delete or do whatever, but in the scenario
he is looking for, I believe it's an insert...
but seriously a select into is the easiest.
im not sure who the original poster was...but are you looking for a one
time thing to do, or something to do day to day, etc...?
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 2:09 PM
To: CF-Talk
Subject: RE: Generic Table Copy from one DB to another
with cf?
cfquery name=get datasource=dsn1
select * from thisTable
/cfquery
cfloop query=get
cfquery name=set datasource=dsn2
insert into newTable
(column1, column2, column3)
values
('#get.value1#','#get.value2#','#get.value3#')
/cfquery
/cfloop
that's just one way...that I usually use!
-Original Message-
From: Gonzo Rock [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 1:14 PM
To: CF-Talk
Subject: RE: Generic Table Copy from one DB to another
Hey Tony, how ya do this with cf?the query extends across two
databases...
reading source from one and writing to the second... would be great to
know.
thanks.
At 09:51 AM 4/22/04, you wrote:
ok...
here ya go...simple but effective.
select *
INTO server_B.something.dbo.database_B from
server_A.something.dbo.database_A
that will take everything from a to b, table structure etc.
tw
-Original Message-
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 12:49 PM
To: CF-Talk
Subject: Re: Generic Table Copy from one DB to another
Tony Weeg wrote:
why not use select into?
I am still looking for information about select into.
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group
(http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
--
[http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads]
[http://www.houseoffusion.com/lists.cfm/link=i:4:160994This
Message]
[http://www.houseoffusion.com/lists.cfm/link=s:4Subscription]
[http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=664.584.
4
Fast
Unsubscribe] [http://www.houseoffusion.com/signin/User Settings]
--
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
[]
--
[http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads]
[http://www.houseoffusion.com/lists.cfm/link=i:4:161013This Message]
[http://www.houseoffusion.com/lists.cfm/link=s:4Subscription]
[http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=664.584.4
Fast
Unsubscribe] [http://www.houseoffusion.com/signin/User Settings]
--
http://www.houseoffusion.com/banners/view.cfm?bannerid=36
[]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Query to find Primary key?
SELECT case isNullable when 1 then 0 else 1 end as required, st.name as type, sc.name, sc.length FROM SysObjects so JOIN SysColumns sc ON so.id = sc.id JOIN sysTypes st ON sc.xtype = st.xtype WHERE so.name = '#table_nm#' AND sc.autoval is not null -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 1:37 PM To: CF-Talk Subject: Query to find Primary key? Is it possible to find the column name of the primary key in a table from a query? Select getPrimarykey() as Pkey From table FYI I'm running MS SQL2000 Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Which JDK with CF MX 6.1
1.4.1 or 1.4.2 can't remember which...this is Windows and Linux 1.4.2 comes with MX. We use 1.4.2_04 on our boxes (Solaris and Linux) and haven't had a problem. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Generic Table Copy from one DB to another
Tony Weeg wrote:
with cf?
cfquery name=get datasource=dsn1
select * from thisTable
/cfquery
cfloop query=get
cfquery name=set datasource=dsn2
insert into newTable
(column1, column2, column3)
values
('#get.value1#','#get.value2#','#get.value3#')
/cfquery
/cfloop
that's just one way...that I usually use!
Spiffy!
Is there a way to do this without specifically listing all of the table
names?
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Generic Table Copy from one DB to another
uhh, Im not sure what ya mean.I guess you could have a random word
generator, and hope that it matches a table in your database or something
like that.
:) seriously...tho', not sure what you mean, or where/why it would come into
play...im sure you have a valid need...just wondering.
-Original Message-
From: Richard Crawford [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 2:42 PM
To: CF-Talk
Subject: Re: Generic Table Copy from one DB to another
Tony Weeg wrote:
with cf?
cfquery name=get datasource=dsn1
select * from thisTable
/cfquery
cfloop query=get
cfquery name=set datasource=dsn2
insert into newTable
(column1, column2, column3)
values
('#get.value1#','#get.value2#','#get.value3#')
/cfquery
/cfloop
that's just one way...that I usually use!
Spiffy!
Is there a way to do this without specifically listing all of the table
names?
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: FREE BD vs. $$$$ CF
Sorry - by deal with it I meant ignore it as much as humanly possible - preferably pretending it doesn't exist;^) In any case there's already a very specific middleware tool in place that we're being forced to use - we won't access CICS specifically but rather this GMI layer. Jim Davis _ From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 10:57 AM To: CF-Talk Subject: Re: FREE BD vs. CF On Apr 21, 2004, at 5:48 PM, Jim Davis wrote: Actually we use CICS on our mainframe. I've just started a project where I need to deal with it for the first time. You might want to look into Mitem at: http://www.mitem.com For the record, my daughter has a very minor stock position in Mitem Also, just to round this out, it was IBM Consulting Services that recommended WebSphere as the obvious solution for the enterprise.The management hired them to examine our then-current applications (written for our part in CF) and determine our future course of action. How surprised were we when they settled on WebSphere on AIX?Not very.;^) Well, you go with what you know... ... It's likely different now, but when I recommended IBM products or services, I knew if they did not perform, Ihad complete access to the responsible parties, their immediate superiors... all the way to the chairman of the Board. I t gave me a lot of confidence in my recommendations -- I am not shy! Dick Jim Davis _ From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 11:20 AM To: CF-Talk Subject: Re: FREE BD vs. CF On Apr 21, 2004, at 7:48 AM, Jim Davis wrote: This isn't all that odd. in my case the problem is similar, but comes from another end.My (very large) company won't consider either product because their both too cheap - and so (goes the management opinion) are not fit for enterprise use. I used to work for IBM Data Processing Division and many IBM products were (rumored to be) priced this way (high) because they had a perceived greater worth. One specific product comes to mind, CICS. This was a back-end terminal to MaimFrame CPU (no network) information system. It was a good system, but nowhere near the capability, power, ease-of-use, etc. of CFMX. Work was essentially completed on the product in the 1980's and it went into maintenance mode (no new development) The last I heard the number of users of the CICS (MaimFrame DOS) version was over 30,000 users. The average cost to IBM customers was $3,000 per month You do the math! Dick _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
