Re: OT? Tracking bandwidth usage.
On a shared server the only way to do this is to monitor the logs. If you also have FTP server(s) to monitor then you'll need to do the FTP logs as well. Statistics server will give you web server totals for the domains, but like you say, you need to go into each one individually and find the bandwidth usage. I've corresponded with Media House asking for a machine-wide site by site summary report for exactly this purpose. Maybe if another hosting provider did the same they'd start to take notice. You could create a simple log analyzer in CF, but when those logs get large, it tends to bog down. A better language to use would be Perl. One thing to be certain of is that you're logging all traffic - graphics files, html, everything. Jim -Original Message- From: Bud [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, March 28, 2000 8:39 PM Subject: OT? Tracking bandwidth usage. Howdy all. Got my server up and running. CF 4.01, WebSite Pro and Statistics Server 5. I'm looking for suggestions on how to track bandwidth monthly for individual domains, and on the server as a whole. Short of going in and looking at each and every stats package every month. That's also not going to give me ftp bandwidth, etc. used, which I'm not worried about tracking on a per domain basis, but would like to know what I'm using up for the whole server total. Any suggestions would be appreciated. Of course, if there's a way to do it with CF, that would be even better because that would put this posting on topic. :) Thanks. Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Netscape vs. IE
This is a multi-part message in MIME format. --=_NextPart_000_000A_01BF991A.5AA22B40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Most Used Browsers Browser Hits % of Total Hits User Sessions 1 Microsoft Internet Explorer 567,553 78.63% 23,874 2 Netscape 146,705 20.32% 2,593 3 Other Netscape Compatible 6,409 0.88% 1,224 4 Others 529 0.07% 25 5 WebTrends 213 0.02% 2 6 Mag-Net 171 0.02% 0 7 MIIxpc/4.1 46 0% 2 8 Teleport Pro/1.29 44 0% 3 9 Wget/1.5.3 41 0% 0 10 Netscape/3.0 [en] (X11; I; Linux 2.0.34 i586) 26 0% 1 Total For Browsers Above 721,737 99.99% 27,724 These stats are from an e-commerce web site that I run and I must say that this is about the most lop sided that I've seen it yet in IE's favor. How about the rest of you? DSJ --=_NextPart_000_000A_01BF991A.5AA22B40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLE/TITLE META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR/HEAD BODYFONT color=3D#ff face=3DArial size=3D2 CENTER TABLE border=3D1 cellSpacing=3D0 width=3D"90%" TBODY TR bgColor=3D#ffdd00 TD colSpan=3D5 noWrapFONT color=3D#00 face=3DArial size=3D+1 CENTERBMost Used Browsers /FONTBRFONT=20 size=3D-2/FONT/B/CENTER/TD/TR TR bgColor=3D#d0d0d0 TD width=3D"5%"FONT color=3D#00 face=3DArial size=3D3 CENTERBnbsp;/B/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D3 CENTERBBrowser/B/CENTER/FONT/TD TD width=3D"12%"FONT color=3D#00 face=3DArial size=3D3 CENTERBHits/B/CENTER/FONT/TD TD width=3D"12%"FONT color=3D#00 face=3DArial size=3D3 CENTERB% of Total Hits/B/CENTER/FONT/TD TD width=3D"12%"FONT color=3D#00 face=3DArial size=3D3 CENTERBUser Sessions/B/CENTER/FONT/TD/TR TR bgColor=3D#ff TDFONT color=3D#00 face=3DArial size=3D2 CENTER1/CENTER/FONT/TD TD align=3DleftFONT color=3D#00 face=3DArial = size=3D2Microsoft Internet=20 Explorer/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER567,553/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER78.63%/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER23,874/CENTER/FONT/TD/TR TR bgColor=3D#f0f0f0 TDFONT color=3D#00 face=3DArial size=3D2 CENTER2/CENTER/FONT/TD TD align=3DleftFONT color=3D#00 face=3DArial = size=3D2Netscape/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER146,705/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER20.32%/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER2,593/CENTER/FONT/TD/TR TR bgColor=3D#ff TDFONT color=3D#00 face=3DArial size=3D2 CENTER3/CENTER/FONT/TD TD align=3DleftFONT color=3D#00 face=3DArial size=3D2Other = Netscape=20 Compatible/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER6,409/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER0.88%/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER1,224/CENTER/FONT/TD/TR TR bgColor=3D#f0f0f0 TDFONT color=3D#00 face=3DArial size=3D2 CENTER4/CENTER/FONT/TD TD align=3DleftFONT color=3D#00 face=3DArial = size=3D2Others/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER529/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER0.07%/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER25/CENTER/FONT/TD/TR TR bgColor=3D#ff TDFONT color=3D#00 face=3DArial size=3D2 CENTER5/CENTER/FONT/TD TD align=3DleftFONT color=3D#00 face=3DArial = size=3D2WebTrends/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER213/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER0.02%/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER2/CENTER/FONT/TD/TR TR bgColor=3D#f0f0f0 TDFONT color=3D#00 face=3DArial size=3D2 CENTER6/CENTER/FONT/TD TD align=3DleftFONT color=3D#00 face=3DArial = size=3D2Mag-Net/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER171/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER0.02%/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER0/CENTER/FONT/TD/TR TR bgColor=3D#ff TDFONT color=3D#00 face=3DArial size=3D2 CENTER7/CENTER/FONT/TD TD align=3DleftFONT color=3D#00 face=3DArial = size=3D2MIIxpc/4.1/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER46/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2
You never know exactly how much you miss something until ........
Hey Gang, If anyone's directed questions or comments to me please re-send, I've lost about 2 almost 3 days of messages. Whether it was due to mail server errors or someone just decided to unsubscribe me I have no idea (I'm leaning more towards the mail server errors, you guys wouldn't do that). Glad to be back, Fred Sanders -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Mark and Re-Crystalise
Try this link http://crystal-reports-asp.com/ http://crystal-reports-asp.com/ Mark -Original Message- From: Todd Ashworth [SMTP:[EMAIL PROTECTED]] Sent: Wed, 29 Mar 2000 19:05 To: [EMAIL PROTECTED] Subject:Re: Mark and Re-Crystalise Do you know who the creators of this software might be? So far, I haven't been able to find anything about it. Todd Ashworth - Original Message - From: "Mark Jones" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 28, 2000 10:43 AM Subject: RE: Crystal Problems Look for a product called Re-Crystalise and you might be very impressed. It produces its reports from crystal reports but puts them in a form readable from the web - the only problem being that it produces it in asp page format - I am sure you guys are intelligent enough to cope with this. Mark -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Netscape vs. IE
uh don't take this the wrong way but, so? - Original Message - From: "DSJ" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 29, 2000 2:01 AM Subject: Netscape vs. IE This is a multi-part message in MIME format. --=_NextPart_000_000A_01BF991A.5AA22B40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Most Used Browsers Browser Hits % of Total Hits User Sessions 1 Microsoft Internet Explorer 567,553 78.63% 23,874 2 Netscape 146,705 20.32% 2,593 3 Other Netscape Compatible 6,409 0.88% 1,224 4 Others 529 0.07% 25 5 WebTrends 213 0.02% 2 6 Mag-Net 171 0.02% 0 7 MIIxpc/4.1 46 0% 2 8 Teleport Pro/1.29 44 0% 3 9 Wget/1.5.3 41 0% 0 10 Netscape/3.0 [en] (X11; I; Linux 2.0.34 i586) 26 0% 1 Total For Browsers Above 721,737 99.99% 27,724 These stats are from an e-commerce web site that I run and I must say that this is about the most lop sided that I've seen it yet in IE's favor. How about the rest of you? DSJ --=_NextPart_000_000A_01BF991A.5AA22B40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLE/TITLE META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR/HEAD BODYFONT color=3D#ff face=3DArial size=3D2 CENTER TABLE border=3D1 cellSpacing=3D0 width=3D"90%" TBODY TR bgColor=3D#ffdd00 TD colSpan=3D5 noWrapFONT color=3D#00 face=3DArial size=3D+1 CENTERBMost Used Browsers /FONTBRFONT=20 size=3D-2/FONT/B/CENTER/TD/TR TR bgColor=3D#d0d0d0 TD width=3D"5%"FONT color=3D#00 face=3DArial size=3D3 CENTERBnbsp;/B/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D3 CENTERBBrowser/B/CENTER/FONT/TD TD width=3D"12%"FONT color=3D#00 face=3DArial size=3D3 CENTERBHits/B/CENTER/FONT/TD TD width=3D"12%"FONT color=3D#00 face=3DArial size=3D3 CENTERB% of Total Hits/B/CENTER/FONT/TD TD width=3D"12%"FONT color=3D#00 face=3DArial size=3D3 CENTERBUser Sessions/B/CENTER/FONT/TD/TR TR bgColor=3D#ff TDFONT color=3D#00 face=3DArial size=3D2 CENTER1/CENTER/FONT/TD TD align=3DleftFONT color=3D#00 face=3DArial = size=3D2Microsoft Internet=20 Explorer/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER567,553/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER78.63%/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER23,874/CENTER/FONT/TD/TR TR bgColor=3D#f0f0f0 TDFONT color=3D#00 face=3DArial size=3D2 CENTER2/CENTER/FONT/TD TD align=3DleftFONT color=3D#00 face=3DArial = size=3D2Netscape/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER146,705/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER20.32%/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER2,593/CENTER/FONT/TD/TR TR bgColor=3D#ff TDFONT color=3D#00 face=3DArial size=3D2 CENTER3/CENTER/FONT/TD TD align=3DleftFONT color=3D#00 face=3DArial size=3D2Other = Netscape=20 Compatible/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER6,409/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER0.88%/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER1,224/CENTER/FONT/TD/TR TR bgColor=3D#f0f0f0 TDFONT color=3D#00 face=3DArial size=3D2 CENTER4/CENTER/FONT/TD TD align=3DleftFONT color=3D#00 face=3DArial = size=3D2Others/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER529/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER0.07%/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER25/CENTER/FONT/TD/TR TR bgColor=3D#ff TDFONT color=3D#00 face=3DArial size=3D2 CENTER5/CENTER/FONT/TD TD align=3DleftFONT color=3D#00 face=3DArial = size=3D2WebTrends/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER213/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER0.02%/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER2/CENTER/FONT/TD/TR TR bgColor=3D#f0f0f0 TDFONT color=3D#00 face=3DArial size=3D2 CENTER6/CENTER/FONT/TD TD align=3DleftFONT color=3D#00 face=3DArial = size=3D2Mag-Net/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER171/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER0.02%/CENTER/FONT/TD TDFONT color=3D#00 face=3DArial size=3D2 CENTER0/CENTER/FONT/TD/TR TR bgColor=3D#ff TDFONT
Worldpay integration
Does anybody know of a CF tag or set of tags to interface with the Worldpay payment system. I need to get something up and running soon and don't really want to integrate the site I'm working on from scratch if someone has already done the donkey work. Steve Martin E: [EMAIL PROTECTED] T: +44 (0)29 20252555 F: +44 (0)29 20252444 W: http://www.sequence.co.uk -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFMail issues
upon further investigation.. .I happens every time I or another user makes use of the CFMail. What seems to be happening is the first mail gets stuck in the spool (cfusion/mail/spool..I think)I have gotten it to send one msg after clearing this dir, all mail sent after that gets stuck. john -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 28, 2000 3:13 PM To: '[EMAIL PROTECTED]' Subject: RE: CFMail issues This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BF98F1.F87BD370 Content-Type: text/plain; charset="windows-1252" Does this happen everytime or did it just happen once? PS Can anyone tell me how to get Outlook2000 not to attach the MIME part? I've already made sure this is being sent out plain text. in fact i've been sending plain text for all my mail since this fiasco started. please help me. -Original Message- From: John Tierney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 28, 2000 2:00 PM To: Cf-Talk@Houseoffusion. Com Subject: CFMail issues Hi, Im having weirdness using cfmail on our installation on NT I get this error: unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (9:1) to (9:105) in the template file Has anyone seen this? John J. Tierney Web Application Developer Information Artist Dreamscape Online LLC. 315.437.4166 http://www.dreamscape.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01BF98F1.F87BD370 Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dwindows-1252" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0" TITLERE: CFMail issues/TITLE /HEAD BODY PFONT SIZE=3D2Does this happen everytime or did it just happen = once?/FONT /P PFONT SIZE=3D2PS Can anyone tell me how to get Outlook2000 not to = attach the MIME part?nbsp; I've already made sure this is being sent = out plain text.nbsp; in fact i've been sending plain text for all my = mail since this fiasco started.nbsp; please help me./FONT/P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: John Tierney [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/F= ONT BRFONT SIZE=3D2Sent: Tuesday, March 28, 2000 2:00 PM/FONT BRFONT SIZE=3D2To: Cf-Talk@Houseoffusion. Com/FONT BRFONT SIZE=3D2Subject: CFMail issues/FONT /P BR PFONT SIZE=3D2Hi,/FONT BRFONT SIZE=3D2Im having weirdness using cfmail on our installation = on NT/FONT BRFONT SIZE=3D2I get this error:/FONT BRFONT SIZE=3D2unknown exception condition/FONT /P PFONT SIZE=3D2TagCFMail::sendMessage/FONT /P PFONT SIZE=3D2nbsp;The error occurred while processing an element = with a general identifier of/FONT BRFONT SIZE=3D2(CFMAIL), occupying document position (9:1) to = (9:105) in the template file/FONT /P PFONT SIZE=3D2Has anyone seen this?/FONT /P BR BR BR PFONT SIZE=3D2John J. Tierney/FONT BRFONT SIZE=3D2Web Application Developer amp;/FONT BRFONT SIZE=3D2Information Artist/FONT BRFONT SIZE=3D2Dreamscape Online LLC./FONT BRFONT SIZE=3D2315.437.4166/FONT BRFONT SIZE=3D2A HREF=3D"http://www.dreamscape.com" = TARGET=3D"_blank"http://www.dreamscape.com/A/FONT /P BR PFONT = SIZE=3D2---= ---/FONT BRFONT SIZE=3D2Archives: A = HREF=3D"http://www.eGroups.com/list/cf-talk" = TARGET=3D"_blank"http://www.eGroups.com/list/cf-talk/A/FONT BRFONT SIZE=3D2To Unsubscribe visit A = HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dli= sts/cf_talk" = TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= body=3Dlists/cf_talk/A or send a message to = [EMAIL PROTECTED] with 'unsubscribe' in the = body./FONT/P /BODY /HTML --_=_NextPart_001_01BF98F1.F87BD370-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OT? Tracking bandwidth usage.
On 3/29/00, Jim McAtee penned: On a shared server the only way to do this is to monitor the logs. If you also have FTP server(s) to monitor then you'll need to do the FTP logs as well. Statistics server will give you web server totals for the domains, but like you say, you need to go into each one individually and find the bandwidth usage. I've corresponded with Media House asking for a machine-wide site by site summary report for exactly this purpose. Maybe if another hosting provider did the same they'd start to take notice. You could create a simple log analyzer in CF, but when those logs get large, it tends to bog down. A better language to use would be Perl. One thing to be certain of is that you're logging all traffic - graphics files, html, everything. Thanks Jim. I think I've got my solution though. I purchased a server with Linux NetMax installed for my firewall. I'm playing with it now before I take it to the Co-Lo facility. Says it has a traffic monitor that I can monitor traffic to the network by machine and URL. That's cool. :) Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFMail issues
So far none of the e-mail address are coming from a database query. just form inputs. -Original Message- From: Jay Wigginton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 28, 2000 4:32 PM To: [EMAIL PROTECTED] Subject: RE: CFMail issues I have come upon this error and found it to be related to information in the database that I was querying email address from the email address field had some invalid email addresses in them... some had spaces and others were phone number... I removed the invalid email addresses from the database and my cfmail query worked just fine... worked for me at least G jay -Original Message- From: John Tierney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 28, 2000 2:00 PM To: Cf-Talk@Houseoffusion. Com Subject: CFMail issues Hi, Im having weirdness using cfmail on our installation on NT I get this error: unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (9:1) to (9:105) in the template file Has anyone seen this? John J. Tierney Web Application Developer Information Artist Dreamscape Online LLC. 315.437.4166 http://www.dreamscape.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFMail issues
Which dll exactly and where can I get a fres one short of reinstalling? -Original Message- From: Rahul Joshi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 28, 2000 4:10 PM To: [EMAIL PROTECTED] Subject: Re: CFMail issues Check out the dll for CFmail TAG if needed replace it with fresh copy .. - Original Message - From: John Tierney [EMAIL PROTECTED] To: Cf-Talk@Houseoffusion. Com [EMAIL PROTECTED] Sent: Wednesday, March 29, 2000 12:30 AM Subject: CFMail issues Hi, Im having weirdness using cfmail on our installation on NT I get this error: unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (9:1) to (9:105) in the template file Has anyone seen this? John J. Tierney Web Application Developer Information Artist Dreamscape Online LLC. 315.437.4166 http://www.dreamscape.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: 2 different data sources
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BF9983.1C63CC50 Content-Type: text/plain; charset="windows-1252" Content-Transfer-Encoding: quoted-printable If you are going to be using the DTS to use multiple datasources? = isn't that the same thing as creating a new table with a stored procedure and copying the table over? essentially making it one datasource? -Original Message- From: Brendan Avery [mailto:[EMAIL PROTECTED]] Sent: Monday, March 20, 2000 4:43 PM To: [EMAIL PROTECTED] Subject: RE: 2 different data sources Here's a solution: If you need to join two or more tables from different datasources in a query, you're going to have to do your linking inside on of the = datasources or in a new datasource. MS ACCESS allows a REALLY simple way to do = this with the command: "FILE GET EXTERNAL DATA LINK TABLES" That lets you set up a local reference in your .MDB file to a table in = an another database, either through JET or ODBC (yes, you too can connect = to ODBC datasources in access if they're set up on your local machine.) = Just note that you can only perform this function if you are working on the ACTUAL machine which this database will reside. MS ACCESS is funny = like that -- so you'll have to install Access on your server and do the = linking from there. So, as an example, if I have one datasource called "EMPLOYEEDATA" and one called "PAYROLLDATA" and I wanted to run a query = that joined "EMPLOYEEDATA.tblEmployees" and "PAYROLLDATA.tblChecks", I would create an MS ACCESS database that contained "Link Tables" for each, = even though I use SQL SERVER for all my other database functions. It's = pretty easy to do, if a bit kludgey. SQL SERVER also has a way to connect to external datasources through = it's DATA TRANSFORMATION SERVICES area. I'm not as familiar with using = STORED PROCEDURES to perform DTS actions or connect to other ODBC sources, so = I use little MS ACCESS databases as my connection points between seperate = ODBC datasources. Peas. B][A -- =DF=AE=EB=D1=D0=C5=F1 =E5V=CA=AE=A5 2.=D8 The Open-Source Human Project http://mediahorse.com/ba [EMAIL PROTECTED] 323.402.1222.x7839 vm/fax -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Monday, March 20, 2000 1:09 PM To: [EMAIL PROTECTED] Subject: 2 different data sources I hope this is not off topic!! Is possible to have a query to 2 different data sources? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlist s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. = -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_t= alk or send a message to [EMAIL PROTECTED] with 'unsubscribe' = in the body. --_=_NextPart_001_01BF9983.1C63CC50 Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dwindows-1252" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0" TITLERE: 2 different data sources/TITLE /HEAD BODY PFONT SIZE=3D2If you are going to be using the DTS to use multiple = datasources?nbsp; isn't that the same thing as creating a new table = with a stored procedure and copying the table over?nbsp; essentially = making it one datasource?/FONT/P BR BR PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Brendan Avery [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=3D2Sent: Monday, March 20, 2000 4:43 PM/FONT BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Subject: RE: 2 different data sources/FONT /P BR PFONT SIZE=3D2Here's a solution:/FONT /P PFONT SIZE=3D2If you need to join two or more tables from different = datasources in a/FONT BRFONT SIZE=3D2query, you're going to have to do your linking = inside on of the datasources/FONT BRFONT SIZE=3D2or in a new datasource.nbsp; MS ACCESS allows a = REALLY simple way to do this/FONT BRFONT SIZE=3D2with the command:/FONT BRFONT SIZE=3D2quot;FILE gt;gt; GET EXTERNAL DATA gt;gt; LINK = TABLESquot;/FONT BRFONT SIZE=3D2That lets you set up a local reference in your .MDB = file to a table in an/FONT BRFONT SIZE=3D2another database, either through JET or ODBC (yes, = you too can connect to/FONT BRFONT SIZE=3D2ODBC datasources in access if they're set up on your = local machine.)nbsp; Just/FONT BRFONT SIZE=3D2note that you can only perform this function if you = are working on the/FONT BRFONT SIZE=3D2ACTUAL machine
RE: CFSchedule
Sorry , I forgot a line Delete them without the task name(that's why I want a list of the task names) -Original Message- From: Christian Labrecque Sent: Wednesday, March 29, 2000 8:44 AM To: '[EMAIL PROTECTED]' Subject: CFSchedule Hi folks, I set up few task with cfschedule , and I want a know if there's a way to have a list of the tasks from the server or a way to delete them. Thanks Christian -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Passing form variables through frames
Hi! Is there a way to pass form variables throught a frameset? Tx! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Hacked Allaire Forums?
Anyone hacked Allaire Forums to enable posting of messages from a list server? best, paul PS I've got the hard part done, CFSCHEDULE ;-) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFMail issues
Well... I found that the problem was in the ones that were phone numbers instead of email addresses... they contained dashes which for some reason was being misinterpreted by CF as an arithmetic operator... just another thought... :) Jay -Original Message- From: John Tierney [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 7:47 AM To: [EMAIL PROTECTED] Subject: RE: CFMail issues So far none of the e-mail address are coming from a database query. just form inputs. -Original Message- From: Jay Wigginton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 28, 2000 4:32 PM To: [EMAIL PROTECTED] Subject: RE: CFMail issues I have come upon this error and found it to be related to information in the database that I was querying email address from the email address field had some invalid email addresses in them... some had spaces and others were phone number... I removed the invalid email addresses from the database and my cfmail query worked just fine... worked for me at least G jay -Original Message- From: John Tierney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 28, 2000 2:00 PM To: Cf-Talk@Houseoffusion. Com Subject: CFMail issues Hi, Im having weirdness using cfmail on our installation on NT I get this error: unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (9:1) to (9:105) in the template file Has anyone seen this? John J. Tierney Web Application Developer Information Artist Dreamscape Online LLC. 315.437.4166 http://www.dreamscape.com -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Virtual Memory Errors
Greetings all: My CF (4.0) Server is getting Virtual Memory Errors. I noticed that when this happens, all of the CF Sites seem to crap out - it doesn't seem to be effecting the html sites. Another thing I noticed is that when this happens (it is happening about every 2 days), the CF .exe is only using about 200K of memory (it usually uses about 35MB). Rebooting the server fixes all. Has anyone ever heard of this???!!! Erik -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFMail issues
Heck of a work around. Kinds makes it useless in a lot of cases. Right now as I try to trouble shoot this, all TO: and FROM: address are in our domain. -Original Message- From: Childress, Emily [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 8:24 AM To: '[EMAIL PROTECTED]' Subject: RE: CFMail issues I ran into the same problem with our setup. The mail server didn't like addresses outside of our domain as the FROM: address. It had something to do with our mail server, not CF the work-around was to only allow a from address within our domain. -e -Original Message- From: Jay Wigginton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 28, 2000 4:32 PM To: [EMAIL PROTECTED] Subject: RE: CFMail issues I have come upon this error and found it to be related to information in the database that I was querying email address from the email address field had some invalid email addresses in them... some had spaces and others were phone number... I removed the invalid email addresses from the database and my cfmail query worked just fine... worked for me at least G jay -Original Message- From: John Tierney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 28, 2000 2:00 PM To: Cf-Talk@Houseoffusion. Com Subject: CFMail issues Hi, Im having weirdness using cfmail on our installation on NT I get this error: unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (9:1) to (9:105) in the template file Has anyone seen this? John J. Tierney Web Application Developer Information Artist Dreamscape Online LLC. 315.437.4166 http://www.dreamscape.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFMail issues
Here is what I've done so far: I replaced smtp.dll as per the allaire hot fixes page. I have verified and reverified the server settings. I have doubled the time out in cfadmin. I have started and restarted the services and cleared the spool adnauseum. I am still able to use the tag about 5 times, no mail is ever sent and I still get the same error, nothing's changed. Anyone have any more ideas? Are you running 4.5? If so, perhaps 4.5.1 RC1 would help. It supposedly fixes all the cfmail bugs in 4.5 (including some not fixed by the smtp.dll hotfix). However, Allaire recommends not installing the RC1 upgrade on a production server since it is still officially beta. Kind of a sucky situation though, since upgrading a production server to the 4.5 release is what may be causing your problems to begin with. I had a similar situation, I feel your pain. - Sean ~ Sean Daniels Manager of Engineering DealStream, Inc. [EMAIL PROTECTED] ~ tel: 207.439.6030 cel: 978.764.0799 Fax: 240.269.6319 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Has someone wrangled a way to get CF to print an HTML document?
Howdy Y'all, Is there a way to get CF to print an HTML document? I'm looking for a way to dump an html page to a networked fax machine. Lon Lentz GetLists.Com [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Do I need listserv?
Hello, My company sends out a weekly digest to about 10,000 site subscribers who can opt-in/out from their profile on the site. Do I need to employ a listserv package for this, or would CFMAIL suffice? I really don't want to get another box to run a mailer. We currently use MessageMedia, but that's becoming a bit expensive. If anybody has built a system for doing this, we wouldn't mind paying for it. Thanks! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Form Action Question - JS
Is it possible to have the form action driven by a form element? I have a select box that is listing some pages, when the user select a page and fills out the rest of the form, I want the form submited to the page selected in the select box... I realize I can do this by using this form param on the action page and redirecting from there, but I would like to make this work cleaner than that... Any help - Thanks -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Database Access
I am designing a system where users log in to see data and can update add and delete the data. What I was wondering is whether or not it is possible to tell which user id has edited the database. For instance, is it possible for a user to access the database according to his/her user id and password rather than using the default user id and password given by the coldfusion server. Or is it possible to write directly to the logs on the database itself with the user name and password of the user who has done the update etc. Any help will be greatly appreciated, Thanks in advance, Mark Jones [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFSCRIPT
Is CFSCRIPT faster than regular coldfusion coding or is it just easier to write so you can get something done faster? Yes. :) I can't remember exactly where I saw the article (I could've sworn it was in Fusion Authority WNA somewhere, but I couldn't find it this morning), but if I recall correctly, CFScript was faster from a performance standpoint if you were evaluating more than one or two variables in a row using the CFSet method: cfSet fred='barney' cfSet foo='bar' cfSet gargle='blaster' ... was said to be slower than: cfScript foo='bar'; fred='barney'; gargle='blaster' /cfScript ...and so on and so forth. I use it for as much procedural code as I can; it's got all the looping functions, case/switch functionality, and (to the eye of this long-time Perl junkie), it's a lot cleaner. :) HTH. HAND. Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Do I need listserv?
CF can do it (once or more a week) We did statistics on how long it would take, but I can't find them right now, probably less than 4 hours on a decent machine. best, paul At 10:15 AM 3/29/2000 -0500, you wrote: Hello, My company sends out a weekly digest to about 10,000 site subscribers who can opt-in/out from their profile on the site. Do I need to employ a listserv package for this, or would CFMAIL suffice? I really don't want to get another box to run a mailer. We currently use MessageMedia, but that's becoming a bit expensive. If anybody has built a system for doing this, we wouldn't mind paying for it. Thanks! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Who Said netscape is dead as for People dressed in black we aring berets.....
One reason to not use Netscape is the mailto links will only pull up Netscape Messenger unless you find an Outlook Express dll so that Netscape will use OE instead of itself. I agree that the page needs to "work" in both browsers, it's just that a major annoyance with the email will prevent people from using Netscape. I personally use them both, because I still run across pages that only one or the other browser will display properly. I also use Mozilla, but I don't recall the messaging being any more robust than the 4.x versions. I will have to look at it again. Chris -Original Message- From: Will [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 10:51 AM To: [EMAIL PROTECTED] Subject: Re: Who Said netscape is dead as for People dressed in black wearing berets. Well, that's no reason to not use Netscape as a browser since Outlook Express has nothing to do with IE. Plus, the new Mozilla Browser (Netscape 6.0 when it's released) will have multiple mail accounts, and from the alpha version, it looks like it'll handle them even better than OE. But the fact remains that you need to use both browsers if you're a good developer ;) Gotta make sure all your compatibilites are in place. hehe - Original Message - From: "lsellers" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 28, 2000 10:49 PM Subject: RE: Who Said netscape is dead as for People dressed in black wearing berets. Wonder how many people switched to IE/OE just for the fact they could handle multiple email accounts / newsgroups in the same sign - on. Netscape blew that one too! Duoooh. Shut down browser | Login as a new User just to check another email account, bad move NS. I would be one. That was _THE_ reason I switched. --min -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Disappearing Session Variables
Anyone know why/how session variables can magically disappear? I have a page that sets session variables then submits it to the next page for processing. Now and then, I would get an error stating that the variables are undefined. This error occurs infrequently and sporadically. I'm guessing that there is a timing issue between the time the variables are defined and when the session variables expire. Tom -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFFILE error
I had that problem until I added the enctype to my form tag. See below. form action="uploadaction.cfm" enctype="multipart/form-data" method="post" input type="file" name="testfile" The form field specified in the CFFILE tag (FILMESSAGE) does not contain an uploaded file. Please be sure you have specified the correct form field name. Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 302 Hiram Smith 1545 Observatory Dr. Madison, WI 53706 (608) 265-7923 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFSCRIPT
Is CFSCRIPT faster than regular coldfusion coding or is it just easier to write so you can get something done faster? Yes. :) Faster for variable assignment but slower when looping so I am led to believe. I was chomping at the bit to refute this, in the fine tradition of Usenet Holy Warriors everywhere. Perhaps it's my ever-increasing age, but something told me to check this out for myself before getting my undies in a bunch. For the edification of all, the following is the actual code I used to perform the test, along with the results. ## loopTest1.cfm ## cfQuery name="testQuery" datasource="foo" SELECT wban, stationname, station_id, state_id, icao_id FROM w_stations /cfQuery cfScript tick1=getTickCount(); counter = 0; for (i=1; i LTE testQuery.recordCount; i=i+1) { if (len(testQuery.icao_id[i]) LT 4) { counter = counter+1; } } tick2=getTickCount(); finalTick=tick2 - tick1; /cfScript cfOutput#counter#br#finalTick#/cfOutput ## loopTest2.cfm ## cfQuery name="testQuery" datasource="foo" SELECT wban, stationname, station_id, state_id, icao_id FROM w_stations /cfQuery cfSet tick1=getTickCount() cfSet counter = 0 cfloop query="testQuery" cfIf len(testQuery.icao_id) LT 4 cfSet counter = counter+1 /cfIf /cfLoop cfSet tick2=getTickCount() cfSet finalTick=tick2 - tick1 cfOutput#counter#br#finalTick#/cfOutput Final results: Both loops counted to the proper number, 752. RUN ONCE: The cfScript method: 485 milliseconds. The cfLoop query method: 141 milliseconds. RUN 10 TIMES: cfScript method average: 212 milliseconds. cfLoop query method: 138 milliseconds. *sigh* live and learn. :) Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: FindNoCase Function
Sherry, How 'bout converting both sides of the WHERE clause to all upper (or lower) case? Might be simpler way of bypassing case-sensitivity e.g. SELECT * from aTable where upper(proj_name) LIKE '%#UCase(projcontains)#%'; CFQUERY NAME="GetContracts" DATASOURCE="Purchasing" SELECT * FROM pwcntrct ...various other CFIF statements CFIF projcontains IS NOT "" WHERE proj_name LIKE '%#FindNoCase(projcontains, projcontains)#%' /CFIF -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Who Said netscape is dead as for People dressed in black wearing berets.....
Rey Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." Good Gdd Mn!!! Its Dave Watts everywhere :-) Now... off to list my beret on Ebay. Steve -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Any good Improve Queries Articles?
-- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFTry Question
If it doesn't fail, it works. So if it isn't caught, it succeeded. cftry cffile action="WRITE" .. !-- if it failed, execution would drop down to the catch blcok -- It worked! cfcatch type="Any" The file could not be updated. File is locked or read only. /cfcatch /cftry Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 12:45 PM To: CFTalk Subject: CFTry Question Hi all, How do I return a success from CFTry? I have wrapped cftry around a cfflile call to intercept error messages if the file can not be updated but I want to return a success message if the was no errors. Here is what I have: cftry cffile action="WRITE" .. cfcatch type="Any" The file could not be updated. File is locked or read only. /cfcatch /cftry Duane Boudreau Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 Fax: 603-594-0258 ICQ#: 18024374 Jobs: [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFTry Question
How about... cfset success=true cftry cffile action="WRITE" .. cfcatch type="Any" cfset success = false The file could not be updated. File is locked or read only. /cfcatch /cftry cfif success Display success message... /cfif I have wrapped cftry around a cfflile call to intercept error messages if the file can not be updated but I want to return a success message if the was no errors. Here is what I have: cftry cffile action="WRITE" .. cfcatch type="Any" The file could not be updated. File is locked or read only. /cfcatch /cftry -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Using CFLOCK
When using CFLOCK how important is it to name the lock and if you name all locks should everylock in your application have a different name? Thanks. -- Ric Smith -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Who Said netscape is dead as for People dressed in black wearing berets.....
I can bid on a genuine Steve Aylor beret Gotta go off to Ebay!!! Hey that almost rhymes. - Original Message - From: "Stephen M. Aylor" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 29, 2000 11:58 AM Subject: Re: Who Said netscape is dead as for People dressed in black wearing berets. Good Gdd Mn!!! Its Dave Watts everywhere :-) Now... off to list my beret on Ebay. Steve -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using CFLOCK
When using CFLOCK how important is it to name the lock In CF 4.0: very, always name it... In CF 4.5, which I am not using yet, I am uncertain if names should be used or not. In 4.5, I *think* they should be used in all cases except for when locking application, session and server vars. Someone else should be able to answer that for you. and if you name all locks should everylock in your application have a different name? Depends on what you are locking and why you are locking it. -Cameron Cameron Childress McRae Communications 770.460.7277 x.232 770.460.0963 fax -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Has someone wrangled a way to get CF to print an HTML document?
protofax or you might try active4 Steve Howdy Y'all, Is there a way to get CF to print an HTML document? I'm looking for a way to dump an html page to a networked fax machine. Lon Lentz GetLists.Com [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: query date problem
your asking for everything its got that doesn't have a date equal to greater than the exact second your run the query. Which is probably everything in the table. - Original Message - From: "S R" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 29, 2000 1:25 PM Subject: query date problem This query gives me all records in the database instead of just what I asked for. What am I doing wrong?? This NewDateArc field is a DateTime field in Access cfquery datasource="Articles" name="DeleteOldArc" select * from ArchivesCopy WHERE NewDateArc NOW() /cfquery __ Get Your Private, Free Email at http://www.hotmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: query date problem
Wrap CreateODBCDate around it: Where NewDateArc #CreateODBCDate(Now())# However, remember that by using Now(), you're specifying everything older than the date _to the second_ -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 2:26 PM To: [EMAIL PROTECTED] Subject: query date problem This query gives me all records in the database instead of just what I asked for. What am I doing wrong?? This NewDateArc field is a DateTime field in Access cfquery datasource="Articles" name="DeleteOldArc" select * from ArchivesCopy WHERE NewDateArc NOW() /cfquery __ Get Your Private, Free Email at http://www.hotmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using CFLOCK
So David... riddle me this... If you should lock all session vars, and you name your lock with a session var, what is locking the session var you are using as the name of the lock? -Cameron Cameron Childress McRae Communications 770.460.7277 x.232 770.460.0963 fax -Original Message- From: David Gassner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 2:31 PM To: [EMAIL PROTECTED] Subject: RE: Using CFLOCK If you are locking session vars, use the name: name="#session.sessionid#" If you are locking application vars, use the name: name="#application.applicationname#" -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 10:48 AM To: [EMAIL PROTECTED] Subject: RE: Using CFLOCK When using CFLOCK how important is it to name the lock In CF 4.0: very, always name it... In CF 4.5, which I am not using yet, I am uncertain if names should be used or not. In 4.5, I *think* they should be used in all cases except for when locking application, session and server vars. Someone else should be able to answer that for you. and if you name all locks should everylock in your application have a different name? Depends on what you are locking and why you are locking it. -Cameron Cameron Childress McRae Communications 770.460.7277 x.232 770.460.0963 fax -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFTry Question
Thanks David this works but I was kind of hoping it worked more like CFIF or CFSWITCH like below cftry cffile action="WRITE" .. cfcatch type="Any" cfset success = false The file could not be updated. File is locked or read only. /cfcatch cfcatch type="NoError" The file updated. /cfcatch /cftry Cheers, Duane -Original Message- From: David Gassner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 1:12 PM To: [EMAIL PROTECTED] Subject: RE: CFTry Question How about... cfset success=true cftry cffile action="WRITE" .. cfcatch type="Any" cfset success = false The file could not be updated. File is locked or read only. /cfcatch /cftry cfif success Display success message... /cfif I have wrapped cftry around a cfflile call to intercept error messages if the file can not be updated but I want to return a success message if the was no errors. Here is what I have: cftry cffile action="WRITE" .. cfcatch type="Any" The file could not be updated. File is locked or read only. /cfcatch /cftry -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ODBC error
Hi guys, can anybody tell me quickly, what this means: ODBC Error Code = S1000 (General error) [INTERSOLV][ODBC Oracle 8 driver][Oracle 8]ORA-02019: connection description for remote database not found I am just doing a simple SELECT there. Thanks! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: query date problem
did you try the hmm what's it called createdateformat(now()) or some such probably should look it up but you can format it with that function as well. I still say your pulling up every record you have because your asking for everything that was created before the exact time of your query, all syntax problems aside, but then maybe that's what you want to do. - Original Message - From: "S R" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 29, 2000 2:02 PM Subject: RE: query date problem Its a Date/Time field in MS Access. The field has 'Short Format' specified. I did place pound signs around 'NOW()' but it still does the same thing From: "Mark Warrick" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: query date problem Date: Wed, 29 Mar 2000 11:35:33 -0800 First problem: you need to put pound signs around "Now()". Second problem: even if you try that, the date format might be incorrect. What kind of field are you searching against? What kind of database is it? What is the format of the dates in the field? Match up the date with your search query, and you'll get the right results. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 11:26 AM To: [EMAIL PROTECTED] Subject: query date problem This query gives me all records in the database instead of just what I asked for. What am I doing wrong?? This NewDateArc field is a DateTime field in Access cfquery datasource="Articles" name="DeleteOldArc" select * from ArchivesCopy WHERE NewDateArc NOW() /cfquery __ Get Your Private, Free Email at http://www.hotmail.com --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Get Your Private, Free Email at http://www.hotmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: I'm looking for good references for improving queries
does any know of any reference sites or tips sites for improving queries? what about www.sqlserver.com and www.mssqlserver.com (they are different but even one good nuget found is worth a visit) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: looping through a mailing list
I've changed part of the checking to the query, not cfif's, but I am still getting the same wrong results. I could really use some help if someone can, or at least a nudge in the right direction. ***!--- Get the list of subscribers who wich to be notified. --- CFQUERY NAME="notify_list" DATASOURCE="kane" SELECT * FROM notify Where 0=0 AND #form.bed# = des_bed AND #form.bath# = des_bath AND #form.garage# = des_garage AND #form.price# = gt_price AND #form.price# = lt_price AND #form.sq_ft# = des_sq_ft ORDER BY date_subscribed /CFQUERY !--- Loop through the subscribers --- cfloop QUERY="notify_list" !--- Check the desires of the subscriber against the actual values of the property. --- cfif notify_list.des_city CONTAINS form.city AND form.display eq 1 AND form.status eq "for sale" !--- Send email if the cfif evaluates true cfmail block will go here when it's working right. --- Send email to cfoutput query="notify_list"#notify_list.first_name# #notify_list.last_name#/cfoutputbr cfelse !--- Don't send email if cfif evaluates to false. cfelse is only here for testing now. --- Don't send email cfoutput query="notify_list"#notify_list.first_name# #notify_list.last_name#/cfoutputbr /cfif /cfloop *** Thanks! Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 Yer wasting a lot of processing power in coldfusion unnecessarily. You should build a where clause that replicates the conditions you are searchinf for in your CFIF, that way you just loop over the result set and send the email to every single record. SQL Will handle that much faster than Cold Fusion will. Jordon This is for a real estate web site where the realtor will add their own property. When new property is added, I want it to check a data table of subscribers who are interested in a property fitting certain criteria, such as price, number of bedrooms, bathrooms, etc. I thought I had this figured out, but am not getting the desired results. Here's my code: ** !--- Get the list of subscribers who wich to be notified. --- CFQUERY NAME="notify_list" DATASOURCE="kane" SELECT * FROM notify ORDER BY date_subscribed /CFQUERY !--- Loop through the subscribers --- cfloop QUERY="notify_list" !--- Check the desires of the subscriber against the actual values of the property. --- cfif form.bed gte notify_list.des_bed AND form.bath gte notify_list.des_bed AND form.garage gte notify_list.des_garage AND form.price gte notify_list.gt_price AND form.price lte notify_list.lt_price AND form.sq_ft gte notify_list.des_sq_ft AND notify_list.des_city CONTAINS form.city AND form.display eq 1 AND form.status eq "for sale" !--- Send email if the cfif evaluates true cfmail block will go here when it's working right. --- Send email to cfoutput query="notify_list"#notify_list.first_name# #notify_list.last_name#/cfoutputbr cfelse !--- Don't send email if cfif evaluates to false. cfelse is only here for testing now. --- Don't send email cfoutput query="notify_list"#notify_list.first_name# #notify_list.last_name#/cfoutputbr /cfif /cfloop ** I currently have just 3 subscrbers in the notify table for testing and the above code gives me this result. * Send email to joe testerTest PersonChris Giminez Don't send email joe testerTest PersonChris Giminez Don't send email joe testerTest PersonChris Giminez * It's somehow evaluating to true and false for each person. I know I'm close to getting this. If someone could enlighten me I would be most grateful. Thanks! Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Inline html editor
At 03:19 PM 3/29/00 -0500, you wrote: Are you saying you got cfa_htmleditor to work in netscape? No, I'm saying that I was told that it worked. I didn't do anything, I sat and watched the people demonstrating do things. I was also saying that, with creative use of javascript to tweak the DOM, you *should* be able to make a tool such as cfa_htmleditor work under Netscape. It is entirely possible that I was lied to, and it doesn't work under Netscape. Wouldn't be the first time I was lied to by presenters. Judah -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF4.5 doesn't support Win2000 file encryption?
This is a multi-part message in MIME format. --=_NextPart_000__01BF9995.F72A13D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Windows 2000 allows you to encrypt files. ColdFusion does not seem to support this, as I get the following error on any page that I encrypt: The template file exists, however, it either cannot be opened for reading, or it is encrypted and its data has been corrupted as soon as i unencrypt, all things are good to go. anyone heard anything about this? is allaire going to fix this in a service patch? Mike Amburn Application Development --=_NextPart_000__01BF9995.F72A13D0 Content-Type: image/gif; name="atworklogo_very_small.gif" Content-Transfer-Encoding: base64 Content-ID: 994194320@29032000-1c68 R0lGODlhhwAsAPcAAMDAwHNzc4SEhKWlpa2trdbW1ufn5+/v77Wtpf/nvffWnP/vzv/nte/WpXtr Sv/WhPfv3vfWjO/OhPfGWvfGUvfOa++9OffWc+fGY+/GUue9Svfv1v/nnP/nlN7Gc97Ga+/GKffG GOe1CPfGCP/GAJSMa+fWjFpSMf/WMee9GOe9APfGAN7Wrf/nc97GUv/eQufGKf/3xv/nUu/WSt7G Of/ve9bGSu/npefWQt7OOf/3nP/3jP/3e//3Y6WlnM7Ovf//zv//xu/vra2te///td7elPf/vd7n pdbn1qW9tWN7c87W1rW9vUpSUnuMjDFCQuf3/6W1vYyltb3Gzpylrd7v/4SMlGNrc0pSWtbe55Sc pVJaY9bn/zFCWhAhOb3O56W1zmNzjL3G1pyltXuElFpjczlCUsbO3qWtvYSMnJytzjlKaxAhQhgx YwgYOdbe787W57W9zq21xoyUpXN7jGtzhHOErWNznBApawgYQgghY73G3nuEnFpje5Sl1jlKezFC cxgpWhAhUsbO56WtxpSctYyUrWNrhFJac0pSa2t7rWNzpSkxSkpajFJjnCk5axAhWggYSgAQQpyl xoyc1oSUzjlCYzFChBghQhgpawAQStbe/7W93q211r3G73N7nGNrjFJae1pjjHOEzjE5WikxUiEp Sik5exAYORAhawgYWoyUvWtznEpSe0JKcyExexAYQhgpewgQOcbO/62156Wt3pSczoSMvXuEtWNr nDlCezE5ayEpWhghUrW994yUzoSMxkpSjCkxayEpYxAYUkJKjCkxcykxhCEpcyEpexAYWhAYYwgQ Wufn787O1rW1vaWlrZycpdbW597e78bG1r29zpycrdbW72tre97e/4yMpb293lJSY7W13sbG94SE pb2973t7nGtrjISEtSEhMTExSmNjpSEhQjExYzExawgIIca9xmtja/fn7wAA ACH5BAEALACHACwA QAj/AAEIHEiwoMGDCBMqXMiwocOHECNKLHigWho02yYqvDaslxaNIEO+OWXMi6kkY9oYCwSoChSC tgJlWjamILheMxFVEWin1zA8vCC1eZRFYCGhmA4BsMPMmKBHhgYRLBBtDaY2gsIIFCCoVxdpBBcJ aiPMG4BBXjJl+ghACjNkqAq1C6nQTiRjy0qFqtMnVJ8+ZUKRSnXMFCiBtQQtw0MF4RxNxpAdcxOK oBQ3bTLFitUl20Bs6kixa0KIS0FPgIY9yhPmJRlVeLpsAhBOVi9BtQiCK5UJjyGBZCQN4+WHLsgD KlbAsMDBiEQgQHRwaFEhQwYDCw1MmXaGyZmEU5ox/0TyA3vCAg7FxDHOvr17hQecERiw7oBCJAbm vt/fEMqeOdgkws0VZFAhxxnTAGAfANPAEccY34SCSiTDGAMMfxgWxIkuyhijVhtRDATFGLZMMskq haA4iRSTVHEIMcMo00hB2xgjDB6CLFKQL714aEYnBNGyiiKiNJKLId14BgAddAg0hSGrmGgiIZ1I VRCUwCxRUCeTkCEFEhk2EskpmdgBABRo5oJMMpAUI9AGEBRiSiCBWGPQNFYJ84gvjQTSCyOmkQEJ HplQMsoy6ESCBgCtmJLJMGYpROYwbqYB2zC5gGLOH2xEEskTjQEADjqQBNLIbYEokqFAaDSBSCiJ fP93kAw4lHBCGYlsoZ5ffYSIkBh9JIIIWwRdww43JzjQwA0sCAGBiGKE04clpZRiSR/hUGPQAK0g UkeCAlFzSCgDOgPAGX2IEsozBYkjTiJ1oLeqQjeYYAMNKeSrb74wwIDBBxKYkMACxp3BjkB0aHGG AHMkAsAS0kBjJzdvpGHIG30MEs41AByyxzdgfMMHAIawAkYhnXxzDSgrg7FNOIWA8gkYVzbZhxiD pEHNFlnENy+GVVwDhjZ1FFOMLrukk84aruQyTiez/Sz1qllQQ4c4VshBkH4ONbMKOrwQ48TU+3VS LSm8dKOgQ4ScA/Yu4EhTzRTyAjMMG4Ac9E0v6Jz/c4h5DE1jRhlku/eFJcS0gcxMeDBipSfo9NJL OjDyogwvkaDzxhvFQKJWqABcww2MeuBhii0DNROKKcMQ881ZhxgjSRuQQKKKIIG00QYzyezyy0Bp KNPGMMLY2EsebuRhiRoCcYIJMszUJFAnfUSShyucrFpFIjGasgpPdymzhmkDrWIK7dIT9A2dptwC gDe89GKKHbWUEoseSmVjSS+88DJLJcoYRiCU8BKE8AESwpDEHQBghWW0oRSzIAguehGJUuzhLOcj BiGqIIo8EAMQb5gXF/qwjEw8QhilYEOnMMELZOAhFqmogzTgZIte0M5OBunE+TLxCmTcZg4CMcAf /2TSQ2RgojVLyUNmmpSQOQwvEouAwmsy8QdbhAIWqpkE+QQyi1K0AQ+d8AYgTCGJRoQwQ2noHy+C gRAgDIEUpohck2rBCwGCziCLgIUwlGGJLxCEC4K6hIcQAAAjCIEIQmBCAEqhDqEEYhiQzEQbiBGI UBBiIE5QBSTQwTEATAITiQpFJ3cjyUUJpBvoyIQyENHJwgEAAiRQgQeI8B4dSCcCDWCAK3cJEQpo QAQiGEEIZNADDuggCMhMpg52UIMayGAGOaCBDVxgggY8yyEFcAY1yDCNZzTjDUsAFzW0lAQ6hPNc 0hjEGc8gKzrYaRrUANcZqGGIM0jvDHB4yTSuIf+rgVihDgDYAz8LmIV1TKUovNTIMxKRoCloAyxn sMIYziCNOdhJolZQGB2ogYY4TMEaBbACGphAhTOkwUF1sKjVqiGHek4DDWg4gzWYAI2BEE0adYip Fpwxh2fQbQwGTahQh0rU9kwjC0jAD+CKylSQVGMM4rCEKchxjnNAUhjCABsmYDEhUoRCa00N60GW YIhgHcIQ1ChgQzbxCWNgLh1iEGtTpfGMOQhgG0qiCyvCNja5OoQa1agGuyKChj10Iq4CWQcB5CCN bHhiDxc0SAGqcYbAQiRyU/BrQ8KBClNEAhOigMg1ygGLXmBiHAYJBSbyMAywDiQb6IAkKl7HEPv/ oCERQNLsQr6RuZUYQxkBGMggGIGKCWGCFKXABCpkwYg3EGJ4KjmjQKzRC+HhYQ1RE8gvOqSMPggk C0nARv8CoQxMmNcUoeBEyLQEACfAwhSeJYc6TFGKRPABsQAQAzkCkYffLCgOppCFOsrA3gzZgQ2Z EMYlHKEHZJBDCjuBghr8QAtztE4YiqiFLWqxk0UkDg9KEcgZrGoMPQAiDwsUCBK6YApI6IJjokCF SjRxikVUAhiK+IMgXpEKXjgCDsCBUTF+MYtZ2EIUvSiFG0RhGk+YAhnI+B4AmkEHVPACHVJe1Rhk gonKGEAXkOTFb2DCiy+mTyDZaMVMumAWKLTC/4aXuAMkBFjTJfkEE2rwxC6UIclKqJUgnFgDnUoB JAGwgRdmsElmMqG24aryI18gBTKUsbGfgQETxmBGK8g3i2GohQ1SIMgkehEISJx5esNogykaAQU0 yC8QtKjCGu7XBS5wwgvxC0Y2zJHgNiRBIYMQRibY0AoGCiUdkeJCJ/7QBky0wjNOxsoc5lAKXggj Nz+LQv+UIQxXKCIMoVjEH6DsuR8AIAYbMB/t6lwQVrAWEot4BC9MkYiXxEF3mXBEMfTAC6IwShbE yx4AgFCQZ53BQ8Rw0xz0kIl06AIVmHjkMFqRPvjR6ROtYAMx/hApDImHE7wRRiCIoUL+SQ4PeP84 RirI8WsA1FCApxYIF7ihCmSo4hT8y6xAzIGT3iDDDZMQCC0eESNGuLYgb+BGJIRBnPaqwsRVqN8w BIGLP8+iF8sgRtBtYYrV8GEnGFqCLu6SCU5sAgouKSAXWJGKWMCCFJn9hSA+h5A44OUVyegFLgjy BSw0OBWp+ARBxHAIbjShCV7oQyH28AVChIEXu5AELABxSQC8Bg+WiGAcWhEJU+kcALNIZSoKIRAx BCMSvdDF0dsz4khg7kIHAQILWmEbWZwDDr9ggyQiAUSEjMODzOjDn6EgBU0wgxjpQM8NinAEWhYg
RE: CFTry Question
Well the whole idea of cfcatch is so that it "catches" the error. So if it didn't why not just put after cfcatch that the file was succesfull. There should be a cfabort in there also, just in case you have any other code that runs only if the cfcatch was successful. That's what I do. cftry cffile action="WRITE" .. cfcatch type="Any" The file could not be updated. File is locked or read only. cfabort /cfcatch /cftry The file updated. Robert Everland III Network Administrator Orlando.com -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 3:07 PM To: [EMAIL PROTECTED] Subject: RE: CFTry Question Thanks David this works but I was kind of hoping it worked more like CFIF or CFSWITCH like below cftry cffile action="WRITE" .. cfcatch type="Any" cfset success = false The file could not be updated. File is locked or read only. /cfcatch cfcatch type="NoError" The file updated. /cfcatch /cftry Cheers, Duane -Original Message- From: David Gassner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 1:12 PM To: [EMAIL PROTECTED] Subject: RE: CFTry Question How about... cfset success=true cftry cffile action="WRITE" .. cfcatch type="Any" cfset success = false The file could not be updated. File is locked or read only. /cfcatch /cftry cfif success Display success message... /cfif I have wrapped cftry around a cfflile call to intercept error messages if the file can not be updated but I want to return a success message if the was no errors. Here is what I have: cftry cffile action="WRITE" .. cfcatch type="Any" The file could not be updated. File is locked or read only. /cfcatch /cftry -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Has someone wrangled a way to get CF to print an HTML document?
Craig, your such a tease. - Original Message - From: "Craig M. Rosenblum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 29, 2000 1:49 PM Subject: RE: Has someone wrangled a way to get CF to print an HTML document? There is some javascript ways of doing that... -Original Message- From: Steve Aylor [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 2:05 PM To: [EMAIL PROTECTED] Subject: Re: Has someone wrangled a way to get CF to print an HTML document? protofax or you might try active4 Steve Howdy Y'all, Is there a way to get CF to print an HTML document? I'm looking for a way to dump an html page to a networked fax machine. Lon Lentz GetLists.Com [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Server_Name
very reliable. I use for over 20 URLs doing the same thing, then I set a SiteID variable. -Original Message- From: John Bowering [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 12:40 PM To: [EMAIL PROTECTED] Subject: Server_Name Has anyone had any problems relying on the 'server_name' variable? I am trying to find a way to host 2 (or more) sites on one hosting account. Just wondering how reliable it is. This would be the index.htm: cfif server_name is 'www.Domain1.com' cflocation url="/domain1" cfelseif server_name is 'www.domain2.com' cflocation url="/domain2" /cfif Or, if anyone has a better idea, can ya share? I would prefer not to pay for 2 or more accounts for sites that aren't bringing in any money right now. Thanks, John -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Open source development?
Is there a Spectra mailing list available? -Original Message- From: Chris Evans [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 12:35 PM To: [EMAIL PROTECTED] Subject: Open source development? Id any body doing any kind of open source development for Spectra? I have heard there are a few known bugs and enhancements for Spectra that everybody is complaining about. The code is open, and I'm sure people are making changes to the underlying code to get it working. Is there a web site ( or should there be) where developers can post their fixes, both for other developers to use and for Allaire? Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Inline html editor
It seems like you were lied to, or a mistake was made. I prefer to think the presenter made a mistake - it happens. Of course, by definition, CFA_HTMLEditor does _work_ in Netscape, ie, it doesn't throw an error, but you don't get the fancy DHTML stuff. You are correct, of course, that someone could build such a tool that would work in both Netscape and IE. === Raymond Camden, Webmaster of the Death Clock (www.deathclock.com) Cold Fusion Jedi Master for Syntegra (www.syntegra.com) Allaire Certified Instructor and Member of Team Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda -Original Message- From: Judah McAuley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 3:37 PM To: [EMAIL PROTECTED] Subject: Re: Inline html editor At 03:19 PM 3/29/00 -0500, you wrote: Are you saying you got cfa_htmleditor to work in netscape? No, I'm saying that I was told that it worked. I didn't do anything, I sat and watched the people demonstrating do things. I was also saying that, with creative use of javascript to tweak the DOM, you *should* be able to make a tool such as cfa_htmleditor work under Netscape. It is entirely possible that I was lied to, and it doesn't work under Netscape. Wouldn't be the first time I was lied to by presenters. Judah -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: query date problem
Thanks everyone. I solved it with your help!! From: Brad Tumy [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: query date problem Date: Wed, 29 Mar 2000 15:12:45 -0500 Did you check the data in newDatearc? ...maybe it is less than now in all of the records? -- Director, Information Technology Regulatory Affairs Professionals Society 301.770.2920 x241 http://www.raps.org -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 3:03 PM To: [EMAIL PROTECTED] Subject: RE: query date problem Its a Date/Time field in MS Access. The field has 'Short Format' specified. I did place pound signs around 'NOW()' but it still does the same thing From: "Mark Warrick" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: query date problem Date: Wed, 29 Mar 2000 11:35:33 -0800 First problem: you need to put pound signs around "Now()". Second problem: even if you try that, the date format might be incorrect. What kind of field are you searching against? What kind of database is it? What is the format of the dates in the field? Match up the date with your search query, and you'll get the right results. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 11:26 AM To: [EMAIL PROTECTED] Subject: query date problem This query gives me all records in the database instead of just what I asked for. What am I doing wrong?? This NewDateArc field is a DateTime field in Access cfquery datasource="Articles" name="DeleteOldArc" select * from ArchivesCopy WHERE NewDateArc NOW() /cfquery __ Get Your Private, Free Email at http://www.hotmail.com --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Get Your Private, Free Email at http://www.hotmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Get Your Private, Free Email at http://www.hotmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF4.5 doesn't support Win2000 file encryption?
Forgive me for asking, but if MS gives a new 'feature' that will effect CF, Perl, Rebol and almost every non-MS scripting language, why would you think it needs a fix from Allaire? Windows 2000 allows you to encrypt files. ColdFusion does not seem to support this, as I get the following error on any page that I encrypt: The template file exists, however, it either cannot be opened for reading, or it is encrypted and its data has been corrupted as soon as i unencrypt, all things are good to go. anyone heard anything about this? is allaire going to fix this in a service patch? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF4.5 doesn't support Win2000 file encryption?
Mike, I wouldn't expect it to be dealt with. That's a feature of Win2K to help protect your files in an internal, corporate environment. MS would have to allow 3rd party vendors access to their unecryption algorithms in order to do this. This would essentially negate any security that encryption might offer you. As a side note, the admins of CF-Talk list have disabled file attachment capabilities because of a virus scare so any messages w/ attached files are coming out screwy. Would you mind removing your atworklogo_very_small.gif Glacier Bkgrd.jpg files from your messages. Thanks, Rey... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." - Original Message - From: "Mike Amburn" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Wednesday, March 29, 2000 3:46 PM Subject: CF4.5 doesn't support Win2000 file encryption? This is a multi-part message in MIME format. --=_NextPart_000__01BF9995.F72A13D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Windows 2000 allows you to encrypt files. ColdFusion does not seem to support this, as I get the following error on any page that I encrypt: The template file exists, however, it either cannot be opened for reading, or it is encrypted and its data has been corrupted as soon as i unencrypt, all things are good to go. anyone heard anything about this? is allaire going to fix this in a service patch? Mike Amburn Application Development --=_NextPart_000__01BF9995.F72A13D0 Content-Type: image/gif; name="atworklogo_very_small.gif" Content-Transfer-Encoding: base64 Content-ID: 994194320@29032000-1c68 R0lGODlhhwAsAPcAAMDAwHNzc4SEhKWlpa2trdbW1ufn5+/v77Wtpf/nvffWnP/vzv/nte/WpXtr Sv/WhPfv3vfWjO/OhPfGWvfGUvfOa++9OffWc+fGY+/GUue9Svfv1v/nnP/nlN7Gc97Ga+/GKffG GOe1CPfGCP/GAJSMa+fWjFpSMf/WMee9GOe9APfGAN7Wrf/nc97GUv/eQufGKf/3xv/nUu/WSt7G Of/ve9bGSu/npefWQt7OOf/3nP/3jP/3e//3Y6WlnM7Ovf//zv//xu/vra2te///td7elPf/vd7n pdbn1qW9tWN7c87W1rW9vUpSUnuMjDFCQuf3/6W1vYyltb3Gzpylrd7v/4SMlGNrc0pSWtbe55Sc pVJaY9bn/zFCWhAhOb3O56W1zmNzjL3G1pyltXuElFpjczlCUsbO3qWtvYSMnJytzjlKaxAhQhgx YwgYOdbe787W57W9zq21xoyUpXN7jGtzhHOErWNznBApawgYQgghY73G3nuEnFpje5Sl1jlKezFC cxgpWhAhUsbO56WtxpSctYyUrWNrhFJac0pSa2t7rWNzpSkxSkpajFJjnCk5axAhWggYSgAQQpyl xoyc1oSUzjlCYzFChBghQhgpawAQStbe/7W93q211r3G73N7nGNrjFJae1pjjHOEzjE5WikxUiEp Sik5exAYORAhawgYWoyUvWtznEpSe0JKcyExexAYQhgpewgQOcbO/62156Wt3pSczoSMvXuEtWNr nDlCezE5ayEpWhghUrW994yUzoSMxkpSjCkxayEpYxAYUkJKjCkxcykxhCEpcyEpexAYWhAYYwgQ Wufn787O1rW1vaWlrZycpdbW597e78bG1r29zpycrdbW72tre97e/4yMpb293lJSY7W13sbG94SE pb2973t7nGtrjISEtSEhMTExSmNjpSEhQjExYzExawgIIca9xmtja/fn7wAA ACH5BAEALACHACwA QAj/AAEIHEiwoMGDCBMqXMiwocOHECNKLHigWho02yYqvDaslxaNIEO+OWXMi6kkY9oYCwSoChSC tgJlWjamILheMxFVEWin1zA8vCC1eZRFYCGhmA4BsMPMmKBHhgYRLBBtDaY2gsIIFCCoVxdpBBcJ aiPMG4BBXjJl+ghACjNkqAq1C6nQTiRjy0qFqtMnVJ8+ZUKRSnXMFCiBtQQtw0MF4RxNxpAdcxOK oBQ3bTLFitUl20Bs6kixa0KIS0FPgIY9yhPmJRlVeLpsAhBOVi9BtQiCK5UJjyGBZCQN4+WHLsgD KlbAsMDBiEQgQHRwaFEhQwYDCw1MmXaGyZmEU5ox/0TyA3vCAg7FxDHOvr17hQecERiw7oBCJAbm vt/fEMqeOdgkws0VZFAhxxnTAGAfANPAEccY34SCSiTDGAMMfxgWxIkuyhijVhtRDATFGLZMMskq haA4iRSTVHEIMcMo00hB2xgjDB6CLFKQL714aEYnBNGyiiKiNJKLId14BgAddAg0hSGrmGgiIZ1I VRCUwCxRUCeTkCEFEhk2EskpmdgBABRo5oJMMpAUI9AGEBRiSiCBWGPQNFYJ84gvjQTSCyOmkQEJ HplQMsoy6ESCBgCtmJLJMGYpROYwbqYB2zC5gGLOH2xEEskTjQEADjqQBNLIbYEokqFAaDSBSCiJ fP93kAw4lHBCGYlsoZ5ffYSIkBh9JIIIWwRdww43JzjQwA0sCAGBiGKE04clpZRiSR/hUGPQAK0g UkeCAlFzSCgDOgPAGX2IEsozBYkjTiJ1oLeqQjeYYAMNKeSrb74wwIDBBxKYkMACxp3BjkB0aHGG AHMkAsAS0kBjJzdvpGHIG30MEs41AByyxzdgfMMHAIawAkYhnXxzDSgrg7FNOIWA8gkYVzbZhxiD pEHNFlnENy+GVVwDhjZ1FFOMLrukk84aruQyTiez/Sz1qllQQ4c4VshBkH4ONbMKOrwQ48TU+3VS LSm8dKOgQ4ScA/Yu4EhTzRTyAjMMG4Ac9E0v6Jz/c4h5DE1jRhlku/eFJcS0gcxMeDBipSfo9NJL OjDyogwvkaDzxhvFQKJWqABcww2MeuBhii0DNROKKcMQ881ZhxgjSRuQQKKKIIG00QYzyezyy0Bp KNPGMMLY2EsebuRhiRoCcYIJMszUJFAnfUSShyucrFpFIjGasgpPdymzhmkDrWIK7dIT9A2dptwC gDe89GKKHbWUEoseSmVjSS+88DJLJcoYRiCU8BKE8AESwpDEHQBghWW0oRSzIAguehGJUuzhLOcj BiGqIIo8EAMQb5gXF/qwjEw8QhilYEOnMMELZOAhFqmogzTgZIte0M5OBunE+TLxCmTcZg4CMcAf /2TSQ2RgojVLyUNmmpSQOQwvEouAwmsy8QdbhAIWqpkE+QQyi1K0AQ+d8AYgTCGJRoQwQ2noHy+C gRAgDIEUpohck2rBCwGCziCLgIUwlGGJLxCEC4K6hIcQAAAjCIEIQmBCAEqhDqEEYhiQzEQbiBGI UBBiIE5QBSTQwTEATAITiQpFJ3cjyUUJpBvoyIQyENHJwgEAAiRQgQeI8B4dSCcCDWCAK3cJEQpo QAQiGEEIZNADDuggCMhMpg52UIMayGAGOaCBDVxgggY8yyEFcAY1yDCNZzTjDUsAFzW0lAQ6hPNc 0hjEGc8gKzrYaRrUANcZqGGIM0jvDHB4yTSuIf+rgVihDgDYAz8LmIV1TKUovNTIMxKRoCloAyxn sMIYziCNOdhJolZQGB2ogYY4TMEaBbACGphAhTOkwUF1sKjVqiGHek4DDWg4gzWYAI2BEE0adYip Fpwxh2fQbQwGTahQh0rU9kwjC0jAD+CKylSQVGMM4rCEKchxjnNAUhjCABsmYDEhUoRCa00N60GW YIhgHcIQ1ChgQzbxCWNgLh1iEGtTpfGMOQhgG0qiCyvCNja5OoQa1agGuyKChj10Iq4CWQcB5CCN bHhiDxc0SAGqcYbAQiRyU/BrQ8KBClNEAhOigMg1ygGLXmBiHAYJBSbyMAywDiQb6IAkKl7HEPv/
RE: Server_Name
John, If you don't want to look for www. .com use contain rather than is: cfif cgi.server_name contains "shirleywolcoski" I use a virtual directory called "rootdir" that can be altered for each site, so it would look something like this: cfif cgi.server_name contains "shirleywolcoski" cfset rootdir = "/shirleywolcoski" Then all other paths are relative to the rootdir variable. Seems to work well, no caveats...yet. -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 1:12 PM To: [EMAIL PROTECTED] Subject: RE: Server_Name Yes it should work ok, but keep in mind what if someone types in the IP address, then the IP address is the server name. Also if I typed in domain1.com then I wouldn't match anything either. So add the sites without the www. and also have a default case just incase something unexpected comes along. Pete Freitag CFDEV.COM Cold Fusion Developer Resources http://www.cfdev.com -Original Message- From: John Bowering [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 3:40 PM To: [EMAIL PROTECTED] Subject: Server_Name Has anyone had any problems relying on the 'server_name' variable? I am trying to find a way to host 2 (or more) sites on one hosting account. Just wondering how reliable it is. This would be the index.htm: cfif server_name is 'www.Domain1.com' cflocation url="/domain1" cfelseif server_name is 'www.domain2.com' cflocation url="/domain2" /cfif Or, if anyone has a better idea, can ya share? I would prefer not to pay for 2 or more accounts for sites that aren't bringing in any money right now. Thanks, John -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Newbie to the List from client server
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BF99C8.2BF5C820 Content-Type: text/plain; charset="iso-8859-1" I've been developing in Omnis and Omnis Studio for the past 5 years and I am making the move over to Cold Fusion. I've been putting together some test apps but nothing major. What I am trying to find out is what do you find to be the best development tool/add-ons for Cold Fusion Studio? What I am trying to do is take alot of our existing applications, Action Requests, Contract Administration, Calling Card Maintenance. and develop them using Cold Fusion Studio / Cold Fusion Enterprise Server. What I've found most difficult coming from the client server over to the web is that alot of requests must be posted to another page. Is there a way that I can have a user input a calling card number or last name and have the "SAME" page display all found customers in a list/table field then have my user either single click or double click to load the customer information on the same page into the appropriate fields? thanks Daniel Bogesdorfer Programmer/Analyst RSL COM USA INC Voice 412.244.6628 --_=_NextPart_001_01BF99C8.2BF5C820 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLENewbie to the List from client server/TITLE /HEAD BODY PFONT SIZE=3D2 FACE=3D"Arial"I've been developing in Omnis and = Omnis Studio for the past 5 years and I am making the move over to Cold = Fusion. I've been putting together some test apps but nothing = major.nbsp; What I am trying to find out is what do you find to be the = best development tool/add-ons for Cold Fusion Studio?nbsp; What I am = trying to do is take alot of our existing applications, Action = Requests, Contract Administration, Calling Card Maintenance. and = develop them using Cold Fusion Studio / Cold Fusion Enterprise = Server./FONT/P Pnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; FONT SIZE=3D2 = FACE=3D"Arial"What I've found most difficult coming from the client = server over to the web is that alot of requests must be posted to = another page.nbsp; Is there a way that I can have a user input a = calling card number or last name and have the quot;SAMEquot; page = display all found customers in a list/table field then have my user = either single click or double click to load the customer information on = the same page into the appropriate fields?/FONT/P PFONT SIZE=3D2 FACE=3D"Arial"thanks/FONT /P PFONT COLOR=3D"#00" SIZE=3D2 FACE=3D"Arial"Daniel = Bogesdorfer/FONT BRFONT COLOR=3D"#00" SIZE=3D2 = FACE=3D"Arial"Programmer/Analyst/FONT BRFONT COLOR=3D"#00" SIZE=3D2 FACE=3D"Arial"RSL COM USA = INC/FONT BRFONT COLOR=3D"#00" SIZE=3D2 FACE=3D"Arial"Voice = 412.244.6628/FONT /P /BODY /HTML --_=_NextPart_001_01BF99C8.2BF5C820-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using CFLOCK
Good answer... makes sense... officially it conflicts with Allaire's recomendation, but I think you are correct. -Cameron Cameron Childress McRae Communications 770.460.7277 x.232 770.460.0963 fax -Original Message- From: David Gassner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 4:01 PM To: [EMAIL PROTECTED] Subject: RE: Using CFLOCK session.sessionid is a value which is set by the CF server, not by the user, and is based on the CFID and CFToken cookies. It's initialized at the beginning of the session, and not changed until the session expires, and therefore (theoretically) it needs no locking. Doing it this way simulates the rules followed by CF server 4.5 when you turn on "Automatic read locking" in CF Server Administrator. -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 11:54 AM To: [EMAIL PROTECTED] Subject: RE: Using CFLOCK So David... riddle me this... If you should lock all session vars, and you name your lock with a session var, what is locking the session var you are using as the name of the lock? -Cameron Cameron Childress McRae Communications 770.460.7277 x.232 770.460.0963 fax -Original Message- From: David Gassner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 2:31 PM To: [EMAIL PROTECTED] Subject: RE: Using CFLOCK If you are locking session vars, use the name: name="#session.sessionid#" If you are locking application vars, use the name: name="#application.applicationname#" -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 10:48 AM To: [EMAIL PROTECTED] Subject: RE: Using CFLOCK When using CFLOCK how important is it to name the lock In CF 4.0: very, always name it... In CF 4.5, which I am not using yet, I am uncertain if names should be used or not. In 4.5, I *think* they should be used in all cases except for when locking application, session and server vars. Someone else should be able to answer that for you. and if you name all locks should everylock in your application have a different name? Depends on what you are locking and why you are locking it. -Cameron Cameron Childress McRae Communications 770.460.7277 x.232 770.460.0963 fax -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
login application help requested
I have a home page in which there are links both for public and private pages. I want users with a password to be able to click on a private page link, login, then be forwarded directly to that page. It is easy enough to send them to a specific page, but I can't seem to "forward" them. This code takes the user back to the login form. The code I'm using is very simple and basic (which is probably the problem). I've included it below. If anyone can help, I'd appreciate it. I've wasted two days of my life working on this. Application.cfm: cfapplication name="login" clientmanagement="YES" sessionmanagement="YES" setclientcookies="Yes" !--- test for existence of session.logged in --- cfif NOT IsDefined("Session.LoggedIn") CFSET Session.LoggedIn=False /cfif !--- if logged.in is false, send user to form --- CFIF Session.LoggedIn EQ FALSE cfif NOT (CGI.Path_Info EQ "/formpage.cfm") OR NOT (CGI.Path_Info is "/actionpage.cfm") !--- send formpage.cfm the path user was trying to get to --- CFLOCATION url="http://localhost/isri/login/formpage.cfm?dest=#cgi.path_info#" addtoken="No" /cfif /cfif !--- if user has already logged in, let them into page --- cfif Session.LoggedIn EQ True CFLOCATION url="#CGI.Path_info#" addtoken="No" /cfif Formpage.cfm: !--- login form with generic username already submitted via hidden field --- form action="actionpage.cfm" method="post" cfif ISDEFINED ("URL.dest") EQ TRUE cfoutputinput type="Hidden" value="#URL.dest#" name="dest"/cfoutput/cfif input type="hidden" name="name" size="30" maxlength="30" value="u"font face="Verdana, Arial, Helvetica, sans-serif" size="2"bPassword: /b/font input type="password" name="password" size="30" maxlength="30"br input type="submit" value="Log In"nbsp;input type="Reset" /form Actionpage.cfm: cfquery datasource="isri" name="auth" SELECT username, pwd FROM login WHERE username = '#Form.name#' AND pwd = '#form.password#' /cfquery !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleLog In/title /head body !--- if the query produces a record send user to page they had clicked on --- cfif auth.RecordCount IS 1 CFSET Session.LoggedIn = True CFLocation url="#dest#" addtoken="No" !--- if login is not acceptable --- cfelse script language="javascript" alert("We're sorry, but we were unable to verify either your Name or Password. Please try again.") self.location = 'formpage.cfm' /script /cfif /body /html Chris Estes (202) 662-8536 [EMAIL PROTECTED] http://www.isri.org http://www.scrap.org -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Server_Name
not sure. but I think older browsers don't pass the server_name, but I think it is simple enough to put up a front door. ie. index.html displays link:domain1 link:domain2 from then on they browse www.domain1.com/domain1/index.html how much traffic are your sites pushing through? ?? Does the cflocation double the load on the server? Where are you hosting? you can contact me offlist. [EMAIL PROTECTED] From: "John Bowering" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Server_Name Date: Wed, 29 Mar 2000 15:40:06 -0500 Has anyone had any problems relying on the 'server_name' variable? I am trying to find a way to host 2 (or more) sites on one hosting account. Just wondering how reliable it is. This would be the index.htm: cfif server_name is 'www.Domain1.com' cflocation url="/domain1" cfelseif server_name is 'www.domain2.com' cflocation url="/domain2" /cfif Or, if anyone has a better idea, can ya share? I would prefer not to pay for 2 or more accounts for sites that aren't bringing in any money right now. Thanks, John __ Get Your Private, Free Email at http://www.hotmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using CFLOCK
Actually, this is the Allaire recommendation for 4.01 and prior. For 4.5, they recommend using the new scope attribute, as in: scope="application" or scope="session" which results in the same behavior. For more see Knowledgebase Article 14165. -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 1:37 PM To: [EMAIL PROTECTED] Subject: RE: Using CFLOCK Good answer... makes sense... officially it conflicts with Allaire's recomendation, but I think you are correct. -Cameron Cameron Childress McRae Communications 770.460.7277 x.232 770.460.0963 fax -Original Message- From: David Gassner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 4:01 PM To: [EMAIL PROTECTED] Subject: RE: Using CFLOCK session.sessionid is a value which is set by the CF server, not by the user, and is based on the CFID and CFToken cookies. It's initialized at the beginning of the session, and not changed until the session expires, and therefore (theoretically) it needs no locking. Doing it this way simulates the rules followed by CF server 4.5 when you turn on "Automatic read locking" in CF Server Administrator. -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 11:54 AM To: [EMAIL PROTECTED] Subject: RE: Using CFLOCK So David... riddle me this... If you should lock all session vars, and you name your lock with a session var, what is locking the session var you are using as the name of the lock? -Cameron Cameron Childress McRae Communications 770.460.7277 x.232 770.460.0963 fax -Original Message- From: David Gassner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 2:31 PM To: [EMAIL PROTECTED] Subject: RE: Using CFLOCK If you are locking session vars, use the name: name="#session.sessionid#" If you are locking application vars, use the name: name="#application.applicationname#" -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 10:48 AM To: [EMAIL PROTECTED] Subject: RE: Using CFLOCK When using CFLOCK how important is it to name the lock In CF 4.0: very, always name it... In CF 4.5, which I am not using yet, I am uncertain if names should be used or not. In 4.5, I *think* they should be used in all cases except for when locking application, session and server vars. Someone else should be able to answer that for you. and if you name all locks should everylock in your application have a different name? Depends on what you are locking and why you are locking it. -Cameron Cameron Childress McRae Communications 770.460.7277 x.232 770.460.0963 fax -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
237 checkboxes
I have search form that contains a large amount of yes/no check boxes -237 to be exact. It is to search the results of a survey that has 237 questions. Only when a checkbox is checked will data be sent from the form. Because of this I need to check if each variable is present. I can create 237 "CFIF IsDefined" statements to see if the variables are present. The other option is to set 237 CFPARAM variables to "NO" as default, and then create my dynamic SQL statements with CFIF tags checking for "YES". The problems with these two options is that they are slow and will take a long time to code. I was thinking: Is there a way to create a loop that will run through all the values from the form - creating a query and output for each one. Thanks, Dan -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Who Said netscape is dead as for People dressed in black wearing berets.....
Did you require the De-Loused model :-)? At least I trimmed the headers and footer.. I can bid on a genuine Steve Aylor beret Gotta go off to Ebay!!! Hey that almost rhymes. Good Gdd Mn!!! Its Dave Watts everywhere :-) Now... off to list my beret on Ebay. Steve -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
sql list syntax
What is the sql syntax for checking if a form field value is contained in the contents of a comma delimted list of values in a field? Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF4.5 doesn't support Win2000 file encryption?
maybe you shouldn't let MS encrypt the pages and just let CF do the work like its supposed to if something is going to go through two encryption/decryption processes from two different servers what is going to define which goes first common sense - Original Message - From: "Michael Dinowitz" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 29, 2000 3:33 PM Subject: Re: CF4.5 doesn't support Win2000 file encryption? Forgive me for asking, but if MS gives a new 'feature' that will effect CF, Perl, Rebol and almost every non-MS scripting language, why would you think it needs a fix from Allaire? Windows 2000 allows you to encrypt files. ColdFusion does not seem to support this, as I get the following error on any page that I encrypt: The template file exists, however, it either cannot be opened for reading, or it is encrypted and its data has been corrupted as soon as i unencrypt, all things are good to go. anyone heard anything about this? is allaire going to fix this in a service patch? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF4.5 doesn't support Win2000 file encryption?
Mike - Just a guess here as I haven't tried EFS on a server yet, but I would think that since files are encrypted by and can only be read by the file owner (as I understand it) that the CF Server service would need to run under the context of the file owner - ie have the CF service login as that user. Jay At 04:27 PM 3/29/2000 -0500, you wrote: Mike, I wouldn't expect it to be dealt with. That's a feature of Win2K to help protect your files in an internal, corporate environment. MS would have to allow 3rd party vendors access to their unecryption algorithms in order to do this. This would essentially negate any security that encryption might offer you. As a side note, the admins of CF-Talk list have disabled file attachment capabilities because of a virus scare so any messages w/ attached files are coming out screwy. Would you mind removing your atworklogo_very_small.gif Glacier Bkgrd.jpg files from your messages. Thanks, Rey... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." - Original Message - From: "Mike Amburn" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Wednesday, March 29, 2000 3:46 PM Subject: CF4.5 doesn't support Win2000 file encryption? This is a multi-part message in MIME format. --=_NextPart_000__01BF9995.F72A13D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Windows 2000 allows you to encrypt files. ColdFusion does not seem to support this, as I get the following error on any page that I encrypt: The template file exists, however, it either cannot be opened for reading, or it is encrypted and its data has been corrupted as soon as i unencrypt, all things are good to go. anyone heard anything about this? is allaire going to fix this in a service patch? Mike Amburn Application Development --=_NextPart_000__01BF9995.F72A13D0 Content-Type: image/gif; [Ugly GIF garbage removed...] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using CFLOCK
How do you output its value? best, paul At 01:01 PM 3/29/2000 -0800, you wrote: session.sessionid is a value which is set by the CF server, not by the user, -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
iPlanet Web Server
Does CF run on the iPlanet Web Server? I see both support NSAPI, so I presume the answer is "yes". Also is anyone out there familiar with WebSite or IIS using it? How does it compare? Larry -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: sql list syntax
What is the sql syntax for checking if a form field value is contained in the contents of a comma delimted list of values in a field? I think about the only way to do it is using: LIKE '%#form.name#%' Thus, if your db field contained 'nuts,bolts,nail,gun' and your form field was 'bolts', the record would match. Is that what your are trying to do? - Sean ~ Sean Daniels Manager of Engineering DealStream, Inc. [EMAIL PROTECTED] ~ tel: 207.439.6030 cel: 978.764.0799 Fax: 240.269.6319 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Has someone wrangled a way to get CF to print an HTML document?
The fact your not thinking about is that CF is server side, thus if you were able to send a print command, it would print on the server that is running CF. If you want to print the contents of a CF page, what you are effectively printing is the HTML page, thus you need to use Javascript to initiate the browsers print command, it's nothing to do with CF. If by some chance you really do mean that you want to print the CF source code, then why can't you do it from CFStudio You couldn't very well print source code while it is being executed. Netscape Navigator has a print method, one of the few times that Netscape turns out to be better than IE. window.print() with IE you have to use ActiveX, although I suspect IE5 probably has a built in method. Russ Satachi Internet Development -- Tel/Fax: 0870 787 3610 Mobile: 07050 648684 http://www.satachi.com email: [EMAIL PROTECTED] -- To join the Satachi-news mailing list send a blank e-mail to mailto:[EMAIL PROTECTED][EMAIL PROTECTED] or visit http://www.satachi.listbot.comsatachi.listbot.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: 237 checkboxes
Optionally, you can name them all the same, assign them different values...any that are checked will have their values passed as a list. That way you only have 1 CFPARAM to worry about. I have search form that contains a large amount of yes/no check boxes -237 to be exact. It is to search the results of a survey that has 237 questions. Only when a checkbox is checked will data be sent from the form. Because of this I need to check if each variable is present. I can create 237 "CFIF IsDefined" statements to see if the variables are present. The other option is to set 237 CFPARAM variables to "NO" as default, and then create my dynamic SQL statements with CFIF tags checking for "YES". The problems with these two options is that they are slow and will take a long time to code. I was thinking: Is there a way to create a loop that will run through all the values from the form - creating a query and output for each one. Thanks, Dan -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: 237 checkboxes
H. You could give each checkbox the same name (ex/ yes_no) with incrimental values (1,2,3,...237). The result is a single variable, form.yes_no, to define. The plus side is the result is a list you can just search for the yeses (boxes that were checked). The minus side is the result is a list you have to search for the yeses. If each checkbox has a different name, you can loop through form fields with something like: CFLOOP INDEX="field_name" LIST="#form.fieldnames#" cfoutput#evaluate('form.' field_name)#/CFOUTPUT /CFLOOP HTH, Sean -Original Message- From: Daniel Murphy [mailto:[EMAIL PROTECTED]] I have search form that contains a large amount of yes/no check boxes -237 to be exact. It is to search the results of a survey that has 237 questions. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFGRID and validate
Gang: Is there an easy way to validate a cfgrid column prior to a db update - Thanks DHR -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Allaire survey
Allaire has posted a survey for feedback about their developer resource. I feel that everyone should answer it as truthfully as possible. One thing to pay special attention to is questions 25 and 26. Let Allaire know what CF resources you use (House of Fusion, Fusion Authority, Defusion, CFNewbie, CFAdvisor, etc.). This will (hopefully) suggest to them that there are a lot of 'third party resources' out there that they should work closer with. This is a survey for ALL Allaire products, so it applies to the JRun and HomeSite communities as well. 25 In your opinion, which technical Web site offers the best mix of content and intuitive navigation? (enter valid URL) 26 Which three technical information Web sites do you access most frequently? (enter valid URL) Survey: http://www.allaire.com/handlers/index.cfm?Method=RegistrationType=Event_Sur veySection=developer Michael Dinowitz ListMaster - various lists. ;) Latest Alert went out on the 27th- http://www.fusionauthority.com/alert -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: 237 checkboxes
I was thinking: Is there a way to create a loop that will run through all the values from the form - creating a query and output for each one. If your questions are all numbered sequentially then this is real easy. Name your checkboxes something like "Question_x" where "x" is the question number. Then... !--- action_page.cfm --- CFLOOP INDEX="i" FROM="1" TO="237" CFIF IsDefined("Form.Question_" i) !--- question was checked --- CFELSE !--- question was not checked --- /CFIF /CFLOOP If your questions aren't numbered sequentially then you have to modify this slightly. You will need a list of all the question numbers that are on the form (such as "1,3,4,5,9,11"). Assuming that the list of numbers is in lstNumbers you can do: !--- action_page.cfm --- CFLOOP INDEX="i" LIST="#lstNumbers#" CFIF IsDefined("Form.Question_" i) !--- question was checked --- CFELSE !--- question was not checked --- /CFIF /CFLOOP If you have non-sequential question numbers and need help figuring out how to build the list of numbers let me know. Hope this makes sense, Seth Petry-Johnson Argo Enterprise and Associates -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
How to update database from the data in a txt file
i have a text file with data like this: Student_ID Lic_No --- 333 444 555 ... and so on. This is pure text file. In the database, I have a column called 'Student_ID'. I have created a new column called Lic_No in the database. I want to put the Lic_No info into the database. If I do it individually I would say: Update tbl_Student set Lic_No = '' where Student_ID = '333' But, it is going to be very painful to do it individually. I am sure there is an easy way. Can someone tell me how. Thanks all. Mirza __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Open source development?
getting everyone in the Spectra beta program would be good start wouldn't it? I was told there was 100+ registered spectra developers. . . . At 04:46 PM 29/03/00 -0500, you wrote: [EMAIL PROTECTED] Not much traffic, though. It seems Spectra has a lot of people scratching their heads. Either that, or they are all on the Forums, but I can't deal with Forums. Chris Evans -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF and PST files
Has anyone done anything with taking messages out of a PST file and importing them using CF into a db ? I know that Outlook has an export feature to export to an Access db or dbase but this is manual and I'm looking for something that I can schedule and run automatically so that my db is populated each night. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFMail issues
I had the same problem and ended up re-installing CF to fix it. Hasn't happened since and I have one page sending out over 1000 emails to external domains (gst.accc.gov.au). -Original Message- From: John Tierney [mailto:[EMAIL PROTECTED]] Sent: Thursday, 30 March 2000 1:06 AM To: [EMAIL PROTECTED] Subject: RE: CFMail issues Here is what I've done so far: I replaced smtp.dll as per the allaire hot fixes page. I have verified and reverified the server settings. I have doubled the time out in cfadmin. I have started and restarted the services and cleared the spool adnauseum. I am still able to use the tag about 5 times, no mail is ever sent and I still get the same error, nothing's changed. Anyone have any more ideas? -Original Message- From: John Tierney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 28, 2000 2:00 PM To: Cf-Talk@Houseoffusion. Com Subject: CFMail issues Hi, Im having weirdness using cfmail on our installation on NT I get this error: unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (9:1) to (9:105) in the template file Has anyone seen this? John J. Tierney Web Application Developer Information Artist Dreamscape Online LLC. 315.437.4166 http://www.dreamscape.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: 237 checkboxes
On 3/29/00, WBB penned: Optionally, you can name them all the same, assign them different values...any that are checked will have their values passed as a list. That way you only have 1 CFPARAM to worry about. I have search form that contains a large amount of yes/no check boxes -237 to be exact. It is to search the results of a survey that has 237 questions. In actuality, unless you explained it wrong, you are saying you have 237 yes/no checkboxes. If you are using checkboxes, you should only have a Yes, and say to click any checkbox that the answer is Yes. Otherwise, you'll invariably have some numbskulls that will check both yes and no and REALLY play havoc with your survery. :) If you need to do Yes/No, use radio buttons and set them all to a default of yes or no. Then you won't have to check for existence because each question will be passed as either yes or no. You could easily loop through and evaluate the "fieldnames" variable: Do your questions with underscores: Do_You_Smoke? The replace the underscores in the QuerySetCell tag. cfset qrySurvey = QueryNew("Question,Answer") cfloop index="myList" list = "#fieldnames#"CFIF myList IS NOT "Submit" and myList is not (whatever other fields you don't want in your query) cfset temp = QueryAddRow(qrySurvey) cfset temp = QuerySetCell(qrySurvey, "Question", replace(myList, "_", " ", "ALL")) cfset temp = QuerySetCell(qrySurvey, "Answer", evaluate(myList))/CFIF/cfloop evaluate(myList) will evaluate to yes or no. Then: Here are your survey answers.p cfoutput query="qrySurvey" #Question# - #Answer#br /cfoutput THE ONLY THING WRONG WITH THIS IS, FOR SOME REASON COLDFUSION LIKES TO CHANGE FIELDNAMES TO ALL CAPS. Wish they'd fix that. Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OT: Form Action Question - JS (MORE)
james larry, :~~ : From: Larry Meadors [EMAIL PROTECTED] : : I just stuck this in, but I think it's close. When you change : the selection, it updates the form action. :~~ this was close, but it won't set it with the value of the OPTION. this is simpler still. select name="reportfile" onChange="this.form.action = this[this.selectedIndex].value" option value="action1.cfm"test1 option value="action2.cfm"test2 /select good luck, .jeff name://jeff.howden game://web.development http://www.evolt.org/ mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: iPlanet Web Server
Current and past versions run on IPlanet (Netscape) 3.6.x. The new version (4.5.1) will work with 4.0.x. Cary Gordon At 03:43 PM 3/29/00 -0700, you wrote: Does CF run on the iPlanet Web Server? I see both support NSAPI, so I presume the answer is "yes". Also is anyone out there familiar with WebSite or IIS using it? How does it compare? Larry -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: cold fusion's version of 404
Anyway, my question is this: Has anyone figured out a way to trick indexing systems (like Verity) into reading cold fusion's custom 404 page as a regular 404 page and not indexing it? What happens is that Verity reads the first line of the file not found message, as opposed to recognizing it as a broken link. The only way I can think of to do this is to have the web server check for the existence of the file before asking CF to process it - if it's not there, the web server will return a real 404 page. You can do this easily for IIS, but I don't know about for other servers. This imposes some overhead as well. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFMail issues
I ran into the same problem with our setup. The mail server didn't like addresses outside of our domain as the FROM: address. It had something to do with our mail server, not CF the work-around was to only allow a from address within our domain. ... Heck of a work around. Kinds makes it useless in a lot of cases. Right now as I try to trouble shoot this, all TO: and FROM: address are in our domain. Unfortunately, this is common. Mail servers are often configured to only accept SMTP requests from the same domain; this prevents others, such as spammers, from improperly using your mail server to send lots of junk. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFCONTENT problem
You should also make sure the mime type is setup on the server. You don't have to configure the server if CF is returning the MIME type in the CFCONTENT tag. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
How-To: Search Engine Friendly URLs?
Could someone please point me at a resource for how to do search-engine friendly URLs with Fusebox applications. I can't seem to find anything useful on this. Thank You! Eron -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: login application help requested
You will never get out of that loop. First time in, cfif NOT IsDefined("Session.LoggedIn") CFSET Session.LoggedIn=False /cfif this isnt defined, so you show login page then you submit to page to autheticate, but the application.cfm is run before that page as well. What you could do is include your authentication in the app.cfm Check there if good they are in if not send back. -Original Message- From: Chris Estes [mailto:[EMAIL PROTECTED]] Sent: Thursday, 30 March 2000 8:24 AM To: '[EMAIL PROTECTED]' Subject: login application help requested I have a home page in which there are links both for public and private pages. I want users with a password to be able to click on a private page link, login, then be forwarded directly to that page. It is easy enough to send them to a specific page, but I can't seem to "forward" them. This code takes the user back to the login form. The code I'm using is very simple and basic (which is probably the problem). I've included it below. If anyone can help, I'd appreciate it. I've wasted two days of my life working on this. Application.cfm: cfapplication name="login" clientmanagement="YES" sessionmanagement="YES" setclientcookies="Yes" !--- test for existence of session.logged in --- cfif NOT IsDefined("Session.LoggedIn") CFSET Session.LoggedIn=False /cfif !--- if logged.in is false, send user to form --- CFIF Session.LoggedIn EQ FALSE cfif NOT (CGI.Path_Info EQ "/formpage.cfm") OR NOT (CGI.Path_Info is "/actionpage.cfm") !--- send formpage.cfm the path user was trying to get to --- CFLOCATION url="http://localhost/isri/login/formpage.cfm?dest=#cgi.path_info#" addtoken="No" /cfif /cfif !--- if user has already logged in, let them into page --- cfif Session.LoggedIn EQ True CFLOCATION url="#CGI.Path_info#" addtoken="No" /cfif Formpage.cfm: !--- login form with generic username already submitted via hidden field --- form action="actionpage.cfm" method="post" cfif ISDEFINED ("URL.dest") EQ TRUE cfoutputinput type="Hidden" value="#URL.dest#" name="dest"/cfoutput/cfif input type="hidden" name="name" size="30" maxlength="30" value="u"font face="Verdana, Arial, Helvetica, sans-serif" size="2"bPassword: /b/font input type="password" name="password" size="30" maxlength="30"br input type="submit" value="Log In" input type="Reset" /form Actionpage.cfm: cfquery datasource="isri" name="auth" SELECT username, pwd FROM login WHERE username = '#Form.name#' AND pwd = '#form.password#' /cfquery !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleLog In/title /head body !--- if the query produces a record send user to page they had clicked on --- cfif auth.RecordCount IS 1 CFSET Session.LoggedIn = True CFLocation url="#dest#" addtoken="No" !--- if login is not acceptable --- cfelse script language="javascript" alert("We're sorry, but we were unable to verify either your Name or Password. Please try again.") self.location = 'formpage.cfm' /script /cfif /body /html Chris Estes (202) 662-8536 [EMAIL PROTECTED] http://www.isri.org http://www.scrap.org -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: login application help requested
what about something a little easier, given that all times after the first time will the SESSION.LoggedIn be true: cfparam name="SESSION.LoggedIn" default="false" type="boolean" cfif NOT SESSION.LoggedIn cfset SESSION.LoggedIn = 1 !--- set stuff other stuff --- /cfif the binary operation is surely faster than the IsDefined() function, yes? :) the other comment that it has to be part of an application.cfm is right, or at least an application.cfm equivalent (such as FuseBox's app_globals.cfm), and obviously you have to have used the CFAPPLICATION ... tag to allow for SESSION variables in the first place :) you could also put any gross application CFSET's within this loop too, thereby only having to set them once. (most people just put the CFSET's in the application.cfm with no loop and so they get set and reset and reset everytime a page is called. For a high volume site obviously this makes a difference). Even in a non-high volume site it makes some difference. we had a site where only 1 or 2 people were logged in at once and not a heck of a lot of DB queries being done. In hitting the pages many times in a row, we noticed a 3-4% increase in speed by wrapping the 20-25 CFSET's inside such a loop. Although not scientific, I daresay to guess at least that savings would occur in a high-traffic site, perhaps substantially higher depending on what you do (or in this case, don't do) outside the loop. You will never get out of that loop. First time in, cfif NOT IsDefined("Session.LoggedIn") CFSET Session.LoggedIn=False /cfif this isnt defined, so you show login page then you submit to page to autheticate, but the application.cfm is run before that page as well. What you could do is include your authentication in the app.cfm Check there if good they are in if not send back. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Date Comparisons - what's wrong here?
I've got a date stored in my SQL7 database. When someone comes to the site, I want to compare this date with Now() to see if they were here today. But it's just not happening for me. (Sigh - dates are always my nemesis!) What am I doing wrong please? The field in the SQL7 database is a datetime field, named whenvotes which is brought to the template by the query testvoter: CFQUERY NAME="testvoter" DATASOURCE="datasource" SELECT whenvotes, remote_addr FROM poll_bank_1 Where remote_addr='#remote_addr#' /CFQUERY. So to check if they were here today, I'm using the following: !--- turn ODBC Date into ColdFusion date format cfset datevoted=parsedatetime(testvoter.whenvotes) !--- compare to now - if dates are equal result is zero cfif (datecompare('datevoted','now()') is '0') But the result I'm getting is an error message thus: The date parameter of function ParseDateTime(date), which is , does not represent a valid date The error occurred while evaluating the expression: datevoted=parsedatetime(testvoter.whenvotes) The error occurred while processing an element with a general identifier of (CFSET), occupying document -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Transact
Hy! What sort of a sodtware can we buy to make a transaction. We know for OpenMarket and their Transact. Are there any others (links, info, price...)? Bye, Iztok -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFSCRIPT
Faster for variable assignment but slower when looping so I am led to believe. -Original Message- From: Brandon Whitaker [mailto:[EMAIL PROTECTED]] Sent: 29 March 2000 16:30 To: [EMAIL PROTECTED] Subject: Re: CFSCRIPT Is CFSCRIPT faster than regular coldfusion coding or is it just easier to write so you can get something done faster? Yes. :) I can't remember exactly where I saw the article (I could've sworn it was in Fusion Authority WNA somewhere, but I couldn't find it this morning), but if I recall correctly, CFScript was faster from a performance standpoint if you were evaluating more than one or two variables in a row using the CFSet method: cfSet fred='barney' cfSet foo='bar' cfSet gargle='blaster' ... was said to be slower than: cfScript foo='bar'; fred='barney'; gargle='blaster' /cfScript ...and so on and so forth. I use it for as much procedural code as I can; it's got all the looping functions, case/switch functionality, and (to the eye of this long-time Perl junkie), it's a lot cleaner. :) HTH. HAND. Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFMail issues
You may want to check with your mail provider as a lot of them now block certain mails depending on where they originate from, the from address domain, etc. Our last one did this, generally as a precaution to stop spammers from using it as a relay for spam. -Original Message- From: Childress, Emily [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Wednesday, March 29, 2000 8:28 AM Subject: RE: CFMail issues I ran into the same problem with our setup. The mail server didn't like addresses outside of our domain as the FROM: address. It had something to do with our mail server, not CF the work-around was to only allow a from address within our domain. -e -Original Message- From: Jay Wigginton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 28, 2000 4:32 PM To: [EMAIL PROTECTED] Subject: RE: CFMail issues I have come upon this error and found it to be related to information in the database that I was querying email address from the email address field had some invalid email addresses in them... some had spaces and others were phone number... I removed the invalid email addresses from the database and my cfmail query worked just fine... worked for me at least G jay -Original Message- From: John Tierney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 28, 2000 2:00 PM To: Cf-Talk@Houseoffusion. Com Subject: CFMail issues Hi, Im having weirdness using cfmail on our installation on NT I get this error: unknown exception condition TagCFMail::sendMessage The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (9:1) to (9:105) in the template file Has anyone seen this? John J. Tierney Web Application Developer Information Artist Dreamscape Online LLC. 315.437.4166 http://www.dreamscape.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Who Said netscape is dead as for People dressed in black wearing berets.....
Well, that's no reason to not use Netscape as a browser since Outlook Express has nothing to do with IE. Plus, the new Mozilla Browser (Netscape 6.0 when it's released) will have multiple mail accounts, and from the alpha version, it looks like it'll handle them even better than OE. But the fact remains that you need to use both browsers if you're a good developer ;) Gotta make sure all your compatibilites are in place. hehe - Original Message - From: "lsellers" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 28, 2000 10:49 PM Subject: RE: Who Said netscape is dead as for People dressed in black wearing berets. Wonder how many people switched to IE/OE just for the fact they could handle multiple email accounts / newsgroups in the same sign - on. Netscape blew that one too! Duoooh. Shut down browser | Login as a new User just to check another email account, bad move NS. I would be one. That was _THE_ reason I switched. --min -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
TEST
-- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFFILE error
I have been around the block with this error and at the moment am very frustrated. First the line of code: CFFILE ACTION="upload" FILEFIELD="filMessage" DESTINATION="#SavePath#" NAMECONFLICT="overwrite" The error: The form field specified in the CFFILE tag (FILMESSAGE) does not contain an uploaded file. Please be sure you have specified the correct form field name. filMessage contains C:\BIN\HPFILES\EMAEM.MSG Any help would be greatly appreciated. Thanks John Keane [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT: Form Action Question - JS (MORE)
Thanks Larry - Can you give me some guidance on syntax placement... What I have... form action="" method="get" name="Selecttest" onsubmit="return verify(document.Selecttest);" pReport: select name="ReportFile" option value="test1.rpt"test1 option value="test2.rpt"test2 /select ... other form fields ... /form I want the form to be submited to whichever file is selected in the "ReportFile" field... Where would "this.form.action='x'" go FYI: I am using the onsubmit to make sure select boxex are checked James Yes, set the form's action property (available in ie4+ and NN3+ I think). You can do this from a form element (this.form.action="foo.cfm"). If you want more info, check out: http://developer.netscape.com/docs/manuals/communicator/jsref/index.htm Larry -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Database Access
Mark, What I would do is add a column in the table to store the identity of the user who updates the relative row. When the user first accesses the site, get them to log in and then you can hold an account, or you could just set a cookie with a unique ID. Then when adding to the database just throw that unique ID into the new column. If you set up an account with users details on it you can put that in a different table which gives their unique ID as a key so you'll be able to cross reference it later on. Hope this helps Taz - Original Message - From: "Mark Jones" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 29, 2000 4:03 PM Subject: Database Access I am designing a system where users log in to see data and can update add and delete the data. What I was wondering is whether or not it is possible to tell which user id has edited the database. For instance, is it possible for a user to access the database according to his/her user id and password rather than using the default user id and password given by the coldfusion server. Or is it possible to write directly to the logs on the database itself with the user name and password of the user who has done the update etc. Any help will be greatly appreciated, Thanks in advance, Mark Jones [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: query to textfile
Sure. Within a CF template, use CFFILE to write the file, then create a page with a link to the new file. Jim -Original Message- From: Won Lee [EMAIL PROTECTED] To: cf-talk (E-mail) [EMAIL PROTECTED] Date: Wednesday, March 29, 2000 9:06 AM Subject: query to textfile Any way to do this? 1)do a query. 2)cfoutput the query to a text file. 3)have the user DL the text file Won Lee Systems Consultant New Channel Technologies (330) 220-1558 [EMAIL PROTECTED] "Turning ideas into e-Business" allaire Premier Partner -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFFILE error
What does your form declaration look like?? Mike Fleming CF Codeslinger "I spent my whole life not knowing what I want out of it, just chasing my tail. Now for the first time I know exactly what I want and who... that's the damnable misery of it." Tombstone -Original Message- From: John Keane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 29, 2000 10:54 AM To: [EMAIL PROTECTED] Subject: CFFILE error I have been around the block with this error and at the moment am very frustrated. First the line of code: CFFILE ACTION="upload" FILEFIELD="filMessage" DESTINATION="#SavePath#" NAMECONFLICT="overwrite" The error: The form field specified in the CFFILE tag (FILMESSAGE) does not contain an uploaded file. Please be sure you have specified the correct form field name. filMessage contains C:\BIN\HPFILES\EMAEM.MSG Any help would be greatly appreciated. Thanks John Keane [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Open source development?
Id any body doing any kind of open source development for Spectra? I have heard there are a few known bugs and enhancements for Spectra that everybody is complaining about. The code is open, and I'm sure people are making changes to the underlying code to get it working. Is there a web site ( or should there be) where developers can post their fixes, both for other developers to use and for Allaire? Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.