Re: Inserting date/time stamp
just make a function that reset the form (to its default values) when the submit button is clicked.. input type=button name=submit value=submit onClick=runTheFunction() function runThefunction(){ document.formname.reset(); document.formname.submit(); } - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 6:46 PM Subject: RE: Inserting date/time stamp Right, but the idea I was trying to achieve was to keep the look the same (with the input field) so it matches the rest of the form. From: FlashGuy [EMAIL PROTECTED] How can I stop people of editing the input line where I'm dumping the date? I don't want them to be able to change it. input type=text name=theTime value=cfoutput #DateFormat(todayDate, , dd, )#/cfoutput size=30 I'd display it as plain text (not in a form field), and do a hidden form field to send the value through the form. cfoutput #DateFormat(todayDate, , dd, )#/cfoutput input type=hidden name=theTime value=cfoutput #DateFormat(todayDate, , dd, )#/cfoutput Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inserting date/time stamp
cfoutput input type=text name=theTime value=#DateFormat(todayDate, , dd, )# size=30 onBlur=this.value='#DateFormat(todayDate, , dd, )#'; /cfoutput or input type=text name=theTime value=#DateFormat(todayDate, , dd, )# size=30 READONLY thats two methods that i use. tony -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:44 PM To: CF-Talk Subject: Re: Inserting date/time stamp just make a function that reset the form (to its default values) when the submit button is clicked.. input type=button name=submit value=submit onClick=runTheFunction() function runThefunction(){ document.formname.reset(); document.formname.submit(); } - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 6:46 PM Subject: RE: Inserting date/time stamp Right, but the idea I was trying to achieve was to keep the look the same (with the input field) so it matches the rest of the form. From: FlashGuy [EMAIL PROTECTED] How can I stop people of editing the input line where I'm dumping the date? I don't want them to be able to change it. input type=text name=theTime value=cfoutput #DateFormat(todayDate, , dd, )#/cfoutput size=30 I'd display it as plain text (not in a form field), and do a hidden form field to send the value through the form. cfoutput #DateFormat(todayDate, , dd, )#/cfoutput input type=hidden name=theTime value=cfoutput #DateFormat(todayDate, , dd, )#/cfoutput Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How to get field names in MSAccess
I know this is simple, but can't remember. How do use a query to get list of column or field names. Using CF5.0 Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to get field names in MSAccess
cfquery name=qName . select * from someTable /cfquery cfoutput #qName.columnList# /cfoutput Joe Eugene Certified Advanced ColdFusion Developer -Original Message- From: Terry [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 9:32 PM To: CF-Talk Subject: How to get field names in MSAccess I know this is simple, but can't remember. How do use a query to get list of column or field names. Using CF5.0 Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to get field names in MSAccess
If you don't want to select any data, and just want the column names, use cfquery name=qName . select * from someTable where myprimarykey is null /cfquery or where myprimarykey = #somevalueiknowwontexistinthetable# cfquery name=qName . select * from someTable /cfquery cfoutput #qName.columnList# /cfoutput Joe Eugene Certified Advanced ColdFusion Developer -Original Message- From: Terry [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 9:32 PM To: CF-Talk Subject: How to get field names in MSAccess I know this is simple, but can't remember. How do use a query to get list of column or field names. Using CF5.0 Thanks ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Where did my CFMX files go?
oi CF-Talk,!! I have installed/uninstalled/removed dirs/rebooted/installed...etc a number of times. my file extensions point to: C:\CFusionMX\runtime\lib\wsconfig\1\jrun.dll but under wsconfig, I have no 1 directory.. I thought perhaps my copy of cfmx was uh I dunno old... so i d/l a new one... same deal. any ideas any suggestions? Critz --- [This E-mail scanned for viruses by Declude Virus] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: MXDU 2003 photos/speaker slides online
Check out http://mxdu.com == Peter Tilbrook Internet Applications Developer Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2601 AUSTRALIA WWW: http://www.abcb.gov.au/ E-Mail: [EMAIL PROTECTED] Telephone: +61 (02) 6213 6731 Mobile: 0439 401 823 Facsimile: +61 (02) 6213 7287 ** The information contained in this e-mail, and any attachments to it, is intended for the use of addressee and is confidential. If you are not the intended recipient, you must not use, disclose, read, forward, copy or retain any of the information. If you have received this e-mail in error, please delete it and notify the sender by return e-mail or telephone. The Commonwealth does not warrant that any attachments are free from viruses or any other defects. You assume all liability for any loss, damage, or other consequences which may arise from opening or using the attachments. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Macromedia DONT help me now. so where do i turn now?
AMAZING Regular readers to this list will be aware that I have been wrestling with installing CFMX since last Friday to no avail. I decided to see if Macromedia would back me up as a reseller and developer, and I called their support line. I got connected to their Manilla office and Pauline's response was that I couldn't even talk to a support person unless I paid US$500. IN other words, I have downloaded the CFMX, it doesn't install correctly, for whatever reason, I can't make it work, no one else can either apparently, and Macromedia aren't going to try unless I cough up nearly 2/3 of the cost of a server. That's to evalutate it!!! I guess I'm just not meant to be in the MX world. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to get field names in MSAccess
If you don't want to select any data, and just want the column names, use or where myprimarykey = #somevalueiknowwontexistinthetable# What happens.. if you dont have a primary key? out of luck? select * from TableName where 1=0; Joe Eugene -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 10:25 PM To: CF-Talk Subject: RE: How to get field names in MSAccess If you don't want to select any data, and just want the column names, use cfquery name=qName . select * from someTable where myprimarykey is null /cfquery or where myprimarykey = #somevalueiknowwontexistinthetable# cfquery name=qName . select * from someTable /cfquery cfoutput #qName.columnList# /cfoutput Joe Eugene Certified Advanced ColdFusion Developer -Original Message- From: Terry [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 9:32 PM To: CF-Talk Subject: How to get field names in MSAccess I know this is simple, but can't remember. How do use a query to get list of column or field names. Using CF5.0 Thanks ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Where did my CFMX files go?
O does this sound familiar to me I'm sorry Critz, I can only offer sympathy, because I have been wrestling with this same problem since last Friday. I'll save you some heartburn. Don't call Macromedia unless you have US$500 lying around the place with nothing to do. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Critz [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 March 2003 2:45 PM To: CF-Talk Subject: Where did my CFMX files go? oi CF-Talk,!! I have installed/uninstalled/removed dirs/rebooted/installed...etc a number of times. my file extensions point to: C:\CFusionMX\runtime\lib\wsconfig\1\jrun.dll but under wsconfig, I have no 1 directory.. I thought perhaps my copy of cfmx was uh I dunno old... so i d/l a new one... same deal. any ideas any suggestions? Critz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Where did my CFMX files go?
Did it stop working all of the sudden, or were there suspicious circumstances... My 1 dir contains: jrun.dll jrun.ini jrunserver.store README.txt and a bunch of jrun log files. Try reinstalling updater 2, I've found it useful for fixing an install I've broken by deleting stuff I shouldn't have. -- mailto:[EMAIL PROTECTED] Monday, March 10, 2003, 10:44:32 PM, you wrote: C oi CF-Talk,!! C I have installed/uninstalled/removed dirs/rebooted/installed...etc a number of times. C my file extensions point to: C:\CFusionMX\runtime\lib\wsconfig\1\jrun.dll C but under wsconfig, I have no 1 directory.. I thought perhaps my copy of cfmx was uh I dunno C old... so i d/l a new one... same deal. C any ideas any suggestions? C Critz C --- C [This E-mail scanned for viruses by Declude Virus] C ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Macromedia DONT help me now. so where do i turn now?
Michael, have you tried installing on another computer entirely? -- mailto:[EMAIL PROTECTED] Monday, March 10, 2003, 11:11:05 PM, you wrote: MK AMAZING MK Regular readers to this list will be aware that I have been wrestling MK with installing CFMX since last Friday to no avail. I decided to see MK if Macromedia would back me up as a reseller and developer, and I called MK their support line. MK I got connected to their Manilla office and Pauline's response was that MK I couldn't even talk to a support person unless I paid US$500. MK IN other words, I have downloaded the CFMX, it doesn't install MK correctly, for whatever reason, I can't make it work, no one else can MK either apparently, and Macromedia aren't going to try unless I cough up MK nearly 2/3 of the cost of a server. That's to evalutate it!!! MK I guess I'm just not meant to be in the MX world. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Macromedia DONT help me now. so where do i turn now?
Thanks for your suggestion. What would be the point of it? I'm sorry but I don't see the reason. Can you elaborate a little for me? I have two computers in my company. Only two. It's a one-person company. The other computer is really small and old. It would be really stretched to run the server at all, let alone do anything with it. (Plus my servers which are production servers and I'm not going to go tinkering about with those unless I know what I'm doing) I need it on this box. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 March 2003 3:24 PM To: CF-Talk Subject: Re: Macromedia DONT help me now. so where do i turn now? Michael, have you tried installing on another computer entirely? -- mailto:[EMAIL PROTECTED] Monday, March 10, 2003, 11:11:05 PM, you wrote: MK AMAZING MK Regular readers to this list will be aware that I have been wrestling MK with installing CFMX since last Friday to no avail. I decided to see MK if Macromedia would back me up as a reseller and developer, and I called MK their support line. MK I got connected to their Manilla office and Pauline's response was that MK I couldn't even talk to a support person unless I paid US$500. MK IN other words, I have downloaded the CFMX, it doesn't install MK correctly, for whatever reason, I can't make it work, no one else can MK either apparently, and Macromedia aren't going to try unless I cough up MK nearly 2/3 of the cost of a server. That's to evalutate it!!! MK I guess I'm just not meant to be in the MX world. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Macromedia DONT help me now. so where do i turn now?
I got connected to their Manilla office and Pauline's response was that I couldn't even talk to a support person unless I paid US$500. To all List Members who recommended calling MM Support to report BUGS. Can you guys please contribute $500 to Mike, so we can this resolved :). Yea right... Joe Eugene -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 11:11 PM To: CF-Talk Subject: Macromedia DONT help me now. so where do i turn now? AMAZING Regular readers to this list will be aware that I have been wrestling with installing CFMX since last Friday to no avail. I decided to see if Macromedia would back me up as a reseller and developer, and I called their support line. I got connected to their Manilla office and Pauline's response was that I couldn't even talk to a support person unless I paid US$500. IN other words, I have downloaded the CFMX, it doesn't install correctly, for whatever reason, I can't make it work, no one else can either apparently, and Macromedia aren't going to try unless I cough up nearly 2/3 of the cost of a server. That's to evalutate it!!! I guess I'm just not meant to be in the MX world. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Macromedia DONT help me now. so where do i turn now?
I got connected to their Manilla office and Pauline's response was that I couldn't even talk to a support person unless I paid US$500. Sorry Michael, but this is no suprise. I downloaded IBM Websphere v5.0 evaluation version, which comes with 60 day support, had some simple issues with software JVM, send IBM support an email at like 2am, got a reply with solution 9am. Excellent support. Joe Eugene -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 11:11 PM To: CF-Talk Subject: Macromedia DONT help me now. so where do i turn now? AMAZING Regular readers to this list will be aware that I have been wrestling with installing CFMX since last Friday to no avail. I decided to see if Macromedia would back me up as a reseller and developer, and I called their support line. I got connected to their Manilla office and Pauline's response was that I couldn't even talk to a support person unless I paid US$500. IN other words, I have downloaded the CFMX, it doesn't install correctly, for whatever reason, I can't make it work, no one else can either apparently, and Macromedia aren't going to try unless I cough up nearly 2/3 of the cost of a server. That's to evalutate it!!! I guess I'm just not meant to be in the MX world. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Macromedia DONT help me now. so where do i turn now?
I'm just thinking along the lines that there may be something wrong with the computer, maybe a corrupted nic driver, or a somehow broken IIS install...I've seen both of those cause many strange problems. The Metabase can get corrupted, but IIS will still function to a point, and corrupted nic drivers can cause all sorts of odd things to happen. I've installed MX on 3 machines, some old, some new, and had problems, but nothing like what you are seeing, and haven't seen people mentioning this kind of problem, so the problem would seem to be with your setup somewhere.Trying to install on another system would at least give concrete proof that the problem is with the computer if it succeeds. At which point I'd say it's time for a Windows reinstall, or at least download a copy of Metaedit to make sure your IIS metabase isn't corrupt, and reinstall the nic drivers. Forgive me if I'm off base, I've followed the threads but there have been quite a few and I may have missed some relevant point. -- mailto:[EMAIL PROTECTED] Monday, March 10, 2003, 11:30:08 PM, you wrote: MK Thanks for your suggestion. MK What would be the point of it? I'm sorry but I don't see the reason. MK Can you elaborate a little for me? MK I have two computers in my company. Only two. It's a one-person MK company. The other computer is really small and old. It would be MK really stretched to run the server at all, let alone do anything with MK it. (Plus my servers which are production servers and I'm not going to MK go tinkering about with those unless I know what I'm doing) I need it MK on this box. MK Cheers, MK Michael Kear MK Windsor, NSW, Australia MK AFP Webworks. MK -Original Message- MK From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] MK Sent: Tuesday, 11 March 2003 3:24 PM MK To: CF-Talk MK Subject: Re: Macromedia DONT help me now. so where do i turn now? MK Michael, have you tried installing on another computer entirely? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Javascript Signed Scripting Re: window.close question?
Actually, you CAN do this without needing to change security settings. Just change the window opener's reference to TOP and then you can close it. script window.open('popup.html','popWin','width=300,height=300'); window.opener=top; window.close(); /script This doesn't work on IE5 or Netscape 4.7x but it works on all other IE/NS variations. I saw this link earlier today while looking for some ActionScript reference. http://aspalliance.com/peterbrunone/impossible.asp HTH Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 7:18 PM To: CF-Talk Subject: Javascript Signed Scripting Re: window.close question? Mozilla has a write up on signed javascripting: http://www.mozilla.org/projects/security/components/signed-scripts.html There's an old (Netscape 4.0) article here: http://polaris.umuc.edu/~mgaylor/SignedScripts.html And some Netscape/Gekko notes at http://devedge.netscape.com/central/security/ AND http://devedge.netscape.com/viewsource/2002/bypassing-security-restricti ons/ On 3/9/03 1:48 PM, James Blaha [EMAIL PROTECTED] wrote: Jeff, Jann Critz, Thank you all very much for your input and time. I¹m working on an intranet application so I¹m not worried about security for the user¹s browser. Jann do you know how this would be done in a secure, signed, scripting environment? If you do can you please email me an example if you have one handy otherwise I found a work around for my issue so I can put an end to this thread. Thanks again! Regards, James Blaha Jann VanOver wrote: On 3/7/03 10:30 AM, James Blaha [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hello All: JavaScript Question I need to have JavaScript code work for Netscape 4.7 to open a child window and close the parent and bypass the confirm message. [snip] You should not be able to do this unless you are in a secure, signed, scripting environment. Period. What you are asking invades the user's privacy. When you close the parent, you lose all their page history information -- this is why the confirmation message appears. The confirmation message will always appear if you programmatically try to close a window that the user opened. I am a bit shocked that the code you give doesn't launch a confirmation message in IE and Netscape 6-7. You must have your user privacy settings lower in those browsers. Can someone please send me an example? This code works in IE and Netscape 6-7 but not Netscape 4.7 !--- SCRIPT LANGUAGE = JavaScript { newwin=window.open(Login.cfm,_blank,... ) firstwindow = window.self; firstwindow.opener = window.self; firstwindow.close(); newwin.focus() } /SCRIPT --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to get field names in MSAccess
just do a WHERE 0 = 0 I just tested it out and it works cfquery name=qName datasource=#dsndata# select * from ModuleFeatures where 0 = 0 /cfquery cfoutput #qName.columnList# /cfoutput outputs all the columns in that table jay miller Joe Eugene wrote: If you don't want to select any data, and just want the column names, use or where myprimarykey = #somevalueiknowwontexistinthetable# What happens.. if you dont have a primary key? out of luck? select * from TableName where 1=0; Joe Eugene -Original Message- From: S. Isaac Dealey [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Monday, March 10, 2003 10:25 PM To: CF-Talk Subject: RE: How to get field names in MSAccess If you don't want to select any data, and just want the column names, use cfquery name=qName . select * from someTable where myprimarykey is null /cfquery or where myprimarykey = #somevalueiknowwontexistinthetable# cfquery name=qName . select * from someTable /cfquery cfoutput #qName.columnList# /cfoutput Joe Eugene Certified Advanced ColdFusion Developer -Original Message- From: Terry [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Monday, March 10, 2003 9:32 PM To: CF-Talk Subject: How to get field names in MSAccess I know this is simple, but can't remember. How do use a query to get list of column or field names. Using CF5.0 Thanks ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index http://www.houseoffusion.com/cf_lists/index . cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to http://www.turnkey.to lead architect, tapestry cmshttp://products.turnkey.to http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Macromedia DONT help me now. so where do i turn now?
For installation support via email, use the following form: http://www.macromedia.com/support/email/isupport/ It's free. Christian On Monday, March 10, 2003, at 11:11 PM, Michael Kear wrote: AMAZING Regular readers to this list will be aware that I have been wrestling with installing CFMX since last Friday to no avail. I decided to see if Macromedia would back me up as a reseller and developer, and I called their support line. I got connected to their Manilla office and Pauline's response was that I couldn't even talk to a support person unless I paid US$500. IN other words, I have downloaded the CFMX, it doesn't install correctly, for whatever reason, I can't make it work, no one else can either apparently, and Macromedia aren't going to try unless I cough up nearly 2/3 of the cost of a server. That's to evalutate it!!! I guess I'm just not meant to be in the MX world. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to get field names in MSAccess
just do a WHERE 0 = 0 This will work for the purpose of getting the schema/columns, but it brings back the entire Table Data.. because 0=0 leads to TRUE The query has to lead to False like i suggested below. select * from TableName where 1=0; Which leads to false and brings back NO DATA, Just schema(columns). This is not the best way to get Table metaData. You should also be able to get column data types and size limits. This is only possible with using a Java Alernative(Better) or using System Table Information. Joe Eugene -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 12:11 AM To: CF-Talk Subject: Re: How to get field names in MSAccess just do a WHERE 0 = 0 I just tested it out and it works cfquery name=qName datasource=#dsndata# select * from ModuleFeatures where 0 = 0 /cfquery cfoutput #qName.columnList# /cfoutput outputs all the columns in that table jay miller Joe Eugene wrote: If you don't want to select any data, and just want the column names, use or where myprimarykey = #somevalueiknowwontexistinthetable# What happens.. if you dont have a primary key? out of luck? select * from TableName where 1=0; Joe Eugene -Original Message- From: S. Isaac Dealey [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Monday, March 10, 2003 10:25 PM To: CF-Talk Subject: RE: How to get field names in MSAccess If you don't want to select any data, and just want the column names, use cfquery name=qName . select * from someTable where myprimarykey is null /cfquery or where myprimarykey = #somevalueiknowwontexistinthetable# cfquery name=qName . select * from someTable /cfquery cfoutput #qName.columnList# /cfoutput Joe Eugene Certified Advanced ColdFusion Developer -Original Message- From: Terry [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Monday, March 10, 2003 9:32 PM To: CF-Talk Subject: How to get field names in MSAccess I know this is simple, but can't remember. How do use a query to get list of column or field names. Using CF5.0 Thanks ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index http://www.houseoffusion.com/cf_lists/index . cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to http://www.turnkey.to lead architect, tapestry cmshttp://products.turnkey.to http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Verity file indexing
OK, found the problem. The .cfm files had an xml prolog - ?xml version=1.0 encoding=iso-8859-1?. If I change the filename to .html they are indexed fine, prolog and all. If I remove the prolog, the .cfm files get indexed. This seems like a bug... I couldn't find mention of it anywhere on MM's site though. Seeing as Dreamweaver inserts the prolog by default I'd imagine this is a problem that more people will start to see. Is it changed in MX I wonder? Kay. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Verity file indexing
The .cfm files had an xml prolog - ?xml version=1.0 encoding=iso-8859-1?. Yes, that prolog is Part of what makes an xml document valid. I dont think DWMX puts that in any file, unless you tell it to create an xml file. Joe Eugene -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 12:05 AM To: CF-Talk Subject: Verity file indexing OK, found the problem. The .cfm files had an xml prolog - ?xml version=1.0 encoding=iso-8859-1?. If I change the filename to .html they are indexed fine, prolog and all. If I remove the prolog, the .cfm files get indexed. This seems like a bug... I couldn't find mention of it anywhere on MM's site though. Seeing as Dreamweaver inserts the prolog by default I'd imagine this is a problem that more people will start to see. Is it changed in MX I wonder? Kay. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Macromedia DONT help me now. so where do i turn now?
Mike, what's your phone number. I'll call you tommorrow (Wednesday) morning and try and assist. Cheeers! == Peter Tilbrook Internet Applications Developer Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2601 AUSTRALIA WWW: http://www.abcb.gov.au/ E-Mail: [EMAIL PROTECTED] Telephone: +61 (02) 6213 6731 Mobile: 0439 401 823 Facsimile: +61 (02) 6213 7287 -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 March 2003 3:30 PM To: CF-Talk Subject: RE: Macromedia DONT help me now. so where do i turn now? Thanks for your suggestion. What would be the point of it? I'm sorry but I don't see the reason. Can you elaborate a little for me? I have two computers in my company. Only two. It's a one-person company. The other computer is really small and old. It would be really stretched to run the server at all, let alone do anything with it. (Plus my servers which are production servers and I'm not going to go tinkering about with those unless I know what I'm doing) I need it on this box. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 March 2003 3:24 PM To: CF-Talk Subject: Re: Macromedia DONT help me now. so where do i turn now? Michael, have you tried installing on another computer entirely? -- mailto:[EMAIL PROTECTED] Monday, March 10, 2003, 11:11:05 PM, you wrote: MK AMAZING MK Regular readers to this list will be aware that I have been wrestling MK with installing CFMX since last Friday to no avail. I decided to see MK if Macromedia would back me up as a reseller and developer, and I called MK their support line. MK I got connected to their Manilla office and Pauline's response was that MK I couldn't even talk to a support person unless I paid US$500. MK IN other words, I have downloaded the CFMX, it doesn't install MK correctly, for whatever reason, I can't make it work, no one else can MK either apparently, and Macromedia aren't going to try unless I cough up MK nearly 2/3 of the cost of a server. That's to evalutate it!!! MK I guess I'm just not meant to be in the MX world. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to get field names in MSAccess
Found this old piece of code hope it helps CFSET Table = MyTable CFSET Datasource= myDsn CFSET dbusername= admin CFSET dbpassword= CFSET columnlist= CFOBJECT type=COM name=MyConnection class=ADODB.Connection action=CREATE CFSET TEMP = MyConnection.Open(DSN=#Datasource#,#dbusername#, #dbpassword#, -1) CFSET ColumnNames = MyConnection.OpenSchema(4) CFSET RSfields = columnnames.Fields CFSET Tablename = RSfields.Item(TABLE_NAME) CFSET Columnname = RSfields.Item(COLUMN_NAME) CFLOOP condition=NOT ColumnNames.EOF CFSET Column = Columnname.Value CFSET Table2 = Tablename.Value CFIF not listcontains(columnlist,Column) AND Table2 is #Table# CFSET columnlist = listappend(columnlist,Column) /CFIF CFSET temp = ColumnNames.MoveNext() /CFLOOP CFSET CALLER.getColumns = QueryNew(column_name,type_name,length) CFSET temp = QueryAddRow(CALLER.getColumns , listlen(columnlist) ) CFSET x=1 CFLOOP list=#columnlist# index=column CFSET temp = QuerySetCell(CALLER.getColumns, column_name, column , x) CFSET temp = QuerySetCell(CALLER.getColumns, type_name, text , x) CFSET temp = QuerySetCell(CALLER.getColumns, length, 10 , x) CFSET x=x+1 /CFLOOP CFSET temp = MyConnection.Close() It's bad code, inefficient, not documented... but it worked I think I used it to mimic sp_columns in SQL. I think you have to create a regular DSN for this to work. Shlomy Gantz Certified Macromedia Instructor President, Bluebrick Inc. -Original Message- From: Terry [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 6:32 PM To: CF-Talk Subject: How to get field names in MSAccess I know this is simple, but can't remember. How do use a query to get list of column or field names. Using CF5.0 Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to get field names in MSAccess
Yes you are right - I may have misunderstood.. .I thought what was requested was merely getting column names.. nothing more.. so that was the quick and dirty of it. Depending on what was needed - I thought it may have helped.. I use that quick code if I just need to quickly sniff out the db - didn't know the involvment of what was needed. but yes - everything you say below is true - no argument there.. Joe Eugene wrote: just do a WHERE 0 = 0 This will work for the purpose of getting the schema/columns, but it brings back the entire Table Data.. because 0=0 leads to TRUE The query has to lead to False like i suggested below. select * from TableName where 1=0; Which leads to false and brings back NO DATA, Just schema(columns). This is not the best way to get Table metaData. You should also be able to get column data types and size limits. This is only possible with using a Java Alernative(Better) or using System Table Information. Joe Eugene -Original Message- From: Jason Miller [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Tuesday, March 11, 2003 12:11 AM To: CF-Talk Subject: Re: How to get field names in MSAccess just do a WHERE 0 = 0 I just tested it out and it works cfquery name=qName datasource=#dsndata# select * from ModuleFeatures where 0 = 0 /cfquery cfoutput #qName.columnList# /cfoutput outputs all the columns in that table jay miller Joe Eugene wrote: If you don't want to select any data, and just want the column names, use or where myprimarykey = #somevalueiknowwontexistinthetable# What happens.. if you dont have a primary key? out of luck? select * from TableName where 1=0; Joe Eugene -Original Message- From: S. Isaac Dealey [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Monday, March 10, 2003 10:25 PM To: CF-Talk Subject: RE: How to get field names in MSAccess If you don't want to select any data, and just want the column names, use cfquery name=qName . select * from someTable where myprimarykey is null /cfquery or where myprimarykey = #somevalueiknowwontexistinthetable# cfquery name=qName . select * from someTable /cfquery cfoutput #qName.columnList# /cfoutput Joe Eugene Certified Advanced ColdFusion Developer -Original Message- From: Terry [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Monday, March 10, 2003 9:32 PM To: CF-Talk Subject: How to get field names in MSAccess I know this is simple, but can't remember. How do use a query to get list of column or field names. Using CF5.0 Thanks ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index http://www.houseoffusion.com/cf_lists/index http://www.houseoffusion.com/cf_lists/index http://www.houseoffusion.com/cf_lists/index . cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq http://www.thenetprofits.co.uk/coldfusion/faq http://www.thenetprofits.co.uk/coldfusion/faq http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com http://www.coolfusion.com http://www.coolfusion.com http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns http://www.houseoffusion.com/cf_lists/uns http://www.houseoffusion.com/cf_lists/uns http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epochhttp://www.turnkey.to http://www.turnkey.to http://www.turnkey.to http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to http://products.turnkey.to http://products.turnkey.to http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi http://www.turnkey.to/tapi http://www.turnkey.to/tapi http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
RE: Macromedia DONT help me now. so where do i turn now?
This is a very generous offer from Peter. He's a good man. I've sent him my phone number off-line. SO many people have shown a willingness to help with this, I promise I wont get it fixed and not post the solution here. I'm sure there are plenty of people who want to know how it turns out. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 March 2003 5:15 PM To: CF-Talk Subject: RE: Macromedia DONT help me now. so where do i turn now? Mike, what's your phone number. I'll call you tommorrow (Wednesday) morning and try and assist. Cheeers! == Peter Tilbrook Internet Applications Developer Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2601 AUSTRALIA WWW: http://www.abcb.gov.au/ E-Mail: [EMAIL PROTECTED] Telephone: +61 (02) 6213 6731 Mobile: 0439 401 823 Facsimile: +61 (02) 6213 7287 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4