Re: CF and URL vars as folders?
If you are always going to use index.cfm would you be able to drop that as well? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Scott Weikert To: CF-Talk Sent: Wed Nov 29 06:56:57 2006 Subject: Re: CF and URL vars as folders? Well thanks to Ray's blog entry, and the last comment on that page - I found SESConverter - http://developer.fusium.com/tools/ses.cfm A little hacking on it, to be able to (optionally) pass it a variable name list to check over and use instead of every other fake folder string, and it's working great in my quickie tests so far. So now instead of http://domain.com/index.cfm/var1/one/var2/two/var3/three ending up with var1 = one, var2 = two etc, I just pass in a list - var1,var2,var3 and with the URL http://domain.com/index.cfm/one/two/three I get the same result. Since the pages I'm looking to revise always have mostly the same variables, this works great. I can always tack on the trailing slash, with ? and normal URL variables, which get picked up normally - http://domain.com/index.cfm/one/two/three/?x=1y=2 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261971 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Jingle Bells
LOL Is that on the sign into it? :-) Twinned with Las Vegas, the other Armpit of America.. :-) This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Doug Brown To: CF-Talk Sent: Wed Nov 29 04:18:00 2006 Subject: Re: Jingle Bells Big City of Delta...Armpit of America!! Doug - Original Message - From: Crow T. Robot [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, November 28, 2006 5:58 PM Subject: Re: Jingle Bells Where in CO are u? On 11/28/06, Doug Brown [EMAIL PROTECTED] wrote: Well, we are getting buried by the snow here in Colorado. Looks like Christmas!! HO HO HO!!! Doug B. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261972 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: compiling apache connector on windows
Are there no binaries for these? Saving you compiling at all? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Russ To: CF-Talk Sent: Wed Nov 29 01:46:05 2006 Subject: compiling apache connector on windows I've tried to compile the apache mod_jrun20.so and mod_jrun22.so connectors from sources provided in the wsconfig.jar, but I can't seem to get it to work on a windows platform. I went and downloading Visual C++ Express, the platform SDK and got a version of apxs for windows, and tried to compile. After a bit of hacking I get the compilation to work, but the module wont' load up into apache. Has anyone had luck compiling the module from source? Russ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261973 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL sums and joins
Hi, I have a table (ordersonline) that may have multiple entries for each client within the client table (clients). I wanted to be able to see the total spend for for each client sum(ORD.price) as totalprice but this just returns the first price for that client. Here's the SQL SELECT ORD.orderGroupID ,count(ORD.orderID) as numbProducts ,ORD.dateAdded ,ORD.price ,CLI.fname ,CLI.sname ,CLI.city ,CLI.clientID ,sum(ORD.price) as totalprice ,sum(ORD.discount) as totaldiscount FROM ordersonline as ORD LEFT JOIN clients as CLI ON ORD.clientID = CLI.clientID WHEREORD.active = '1' AND ORD.status = 'Authorised' GROUP BY ORD.orderGroupID ,ORD.dateAdded ,ORD.price ,CLI.fname ,CLI.sname ,CLI.city ,CLI.clientID ORDER BY ORD.dateAdded Can you see what I'm doing wrong? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261974 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: DNS Problems...
On Wednesday 29 November 2006 04:10, Rick Faircloth wrote: They've been without their online business app for 3 business days now... not good... If it's critical, consider two different hosts in different data centers, as far apart as you can get... -- Tom Chiverton Helping to dynamically streamline virtual ROI This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261975 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Vista (was: CrystalTech outage?)
On Tuesday 28 November 2006 17:06, Dave Watts wrote: Vista simply makes that a little simpler, by requiring user intervention for administrative actions Unless it's turned off. Or broken. Or there's an issue with a privileged network deamon. Or... If you can't accidentally run executables, you can't accidentally turn your machine into a spambot. As I said, it's not what users do that bothers me, it's the non-user related holes. from zombie Windows machines, you should hope that everyone upgrades to Vista as soon as it's available. Either it'll work, and their machines won't be zombies, or it won't, and their machines won't run at all. I hear the 2nd is a feature... -- Tom Chiverton Helping to appropriately network synergistic eyeballs This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261976 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Vista (was: CrystalTech outage?)
On Wednesday 29 November 2006 00:33, John C. Bland II wrote: Yeah, but some of the best hackers couldn't get through. Only 1 did, which is amazing taking the history of Windows. The best hackers (in terms of success rate) work for spammers or crime syndicates. They have an incentive to keep quiet about problems with Vista until it is (widely) deployed. -- Tom Chiverton Helping to administratively create guinine relationships This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261977 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Vista (was: CrystalTech outage?)
On Wednesday 29 November 2006 01:05, Snake wrote: Linux users would argue otherwise :-) That's odd, because my old public DNS server was attacked, and my new Sendmail install bounces at lest one a day. Never mind all the funny things in the Apache logs. True, most of them are IIS attacks :-) -- Tom Chiverton Helping to proactively streamline sticky users This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261978 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL sums and joins
Hi Richard, in order to get the sum of all details in the ord table you should not group over fields in the ord table that are not equal for each client. So if you do something like this: SELECT COUNT(ORD.orderID) AS numbProducts, CLI.fname, CLI.sname, CLI.city, CLI.clientID, SUM(ORD.price) AS totalprice, SUM(ORD.discount) AS totaldiscount FROM ordersonline ORD LEFT OUTER JOIN clients CLI ON ORD.clientID = CLI.clientID WHERE (ORD.active = '1') AND ORD.status = 'Authorised' GROUP BY ORD.dateAdded, CLI.fname, CLI.sname, CLI.city, CLI.clientID ORDER BY ORD.dateAdded Then it should do the trick. I know, some of the fields are missing, but you can still get the details afterwards, or by using inner select statements. Greetings from Zürich/Switzerland Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ Richard Cooper schrieb: Hi, I have a table (ordersonline) that may have multiple entries for each client within the client table (clients). I wanted to be able to see the total spend for for each client sum(ORD.price) as totalprice but this just returns the first price for that client. Here's the SQL SELECT ORD.orderGroupID ,count(ORD.orderID) as numbProducts ,ORD.dateAdded ,ORD.price ,CLI.fname ,CLI.sname ,CLI.city ,CLI.clientID ,sum(ORD.price) as totalprice ,sum(ORD.discount) as totaldiscount FROM ordersonline as ORD LEFT JOIN clients as CLI ON ORD.clientID = CLI.clientID WHERE ORD.active = '1' ANDORD.status = 'Authorised' GROUP BY ORD.orderGroupID ,ORD.dateAdded ,ORD.price ,CLI.fname ,CLI.sname ,CLI.city ,CLI.clientID ORDER BY ORD.dateAdded Can you see what I'm doing wrong? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261979 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL sums and joins
Sorry, I grouped over the DateAdded Field too. You have to remove it from the Select and Group BY statement. Gert Richard Cooper schrieb: Hi, I have a table (ordersonline) that may have multiple entries for each client within the client table (clients). I wanted to be able to see the total spend for for each client sum(ORD.price) as totalprice but this just returns the first price for that client. Here's the SQL SELECT ORD.orderGroupID ,count(ORD.orderID) as numbProducts ,ORD.dateAdded ,ORD.price ,CLI.fname ,CLI.sname ,CLI.city ,CLI.clientID ,sum(ORD.price) as totalprice ,sum(ORD.discount) as totaldiscount FROM ordersonline as ORD LEFT JOIN clients as CLI ON ORD.clientID = CLI.clientID WHERE ORD.active = '1' ANDORD.status = 'Authorised' GROUP BY ORD.orderGroupID ,ORD.dateAdded ,ORD.price ,CLI.fname ,CLI.sname ,CLI.city ,CLI.clientID ORDER BY ORD.dateAdded Can you see what I'm doing wrong? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261980 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: DNS Problems...
Rick, I don't know anything about your client's setup, but do they use any kind of 3rd party DNS server or Web Filter (e.g. - http:// www.barracudanetworks.com/ns/products/spyware_overview.php) to restrict the accessible content behind their firewall (i.e. - to keep their employees from accessing certain sites on company time)? If so, could there be a DNS caching issue with the 3rd party provider where they cached one of the bad settings during your changes? Also, do they maintain any kind of internal DNS for their intranet? If so, there may be a hosts file on the server that manages their internal DNS that can be edited directly that would point all of the clients behind their firewall to your IP. That might be a good short-term solution. Sorry I didn't get back to you yesterday. I was off-list for the day. Jon On Nov 28, 2006, at 11:10 PM, Rick Faircloth wrote: Thanks for the reply, Tom... I'm tardy in replying because I had fouled up my DNS, making some of the very mistakes you mentioned. With a lot of off-list help from Ben Koshy and feedback about my changes from DNSReport.com, I was able to get things properly configured... for my email at least. Still no solution (as far as I know) for my client who can't access any sites on my server. Let's hope somehow the changes I made will enable them to access them tomorrow. They've been without their online business app for 3 business days now... not good... Rick -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 9:10 AM To: CF-Talk Subject: Re: OT: DNS Problems... On Tuesday 28 November 2006 13:25, Rick Faircloth wrote: In the A records, I did have a Host name mail that Points To 66.79.46.138 (my only IP). I say I did have because I figured it was unnecessary at least and harmful at best, so I removed the mail subdomain from the A records completely. Correct this to do? It's normal to define an A record for the host that is your MX (ie handles your email). Now in the MX records, there is Host mail Goes To mail.whitestonemedia.com Host smtp Goes To mail.whitestonemedia.com Host pop Goes To mail.whitestonemedia.com If you've removed the A record, this won't work - what is the IP of mail.whitestonemedia.com, according to your DNS ? But why would these settings, if incorrect, only affect only one customer? Why not all people trying to access my websites? DNS propogates slowly, and at different speeds, depending on the moon :-) -- Tom Chiverton Helping to adaptively target performance-oriented solutions ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261981 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: DNS Problems...
If it's critical, consider two different hosts in different data centers, as far apart as you can get... I may have to go that route... I haven't seen this problem before in 10 years of business... perplexing! Rick -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 5:04 AM To: CF-Talk Subject: Re: OT: DNS Problems... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: DNS Problems...
Also, One other thing you can do for any of the individual clients that absolutely need to access the application today is to have them edit the hosts file on their own computer to point toward that IP. In Windows XP, the hosts file is usually located at C:\WINDOWS \system32\drivers\etc\hosts On a Mac, the hosts file is located at /etc/hosts This will override the external DNS and always point that machine to your IP for that particular domain name. Jon On Nov 29, 2006, at 6:52 AM, Jon Clausen wrote: Rick, I don't know anything about your client's setup, but do they use any kind of 3rd party DNS server or Web Filter (e.g. - http:// www.barracudanetworks.com/ns/products/spyware_overview.php) to restrict the accessible content behind their firewall (i.e. - to keep their employees from accessing certain sites on company time)? If so, could there be a DNS caching issue with the 3rd party provider where they cached one of the bad settings during your changes? Also, do they maintain any kind of internal DNS for their intranet? If so, there may be a hosts file on the server that manages their internal DNS that can be edited directly that would point all of the clients behind their firewall to your IP. That might be a good short-term solution. Sorry I didn't get back to you yesterday. I was off-list for the day. Jon On Nov 28, 2006, at 11:10 PM, Rick Faircloth wrote: Thanks for the reply, Tom... I'm tardy in replying because I had fouled up my DNS, making some of the very mistakes you mentioned. With a lot of off-list help from Ben Koshy and feedback about my changes from DNSReport.com, I was able to get things properly configured... for my email at least. Still no solution (as far as I know) for my client who can't access any sites on my server. Let's hope somehow the changes I made will enable them to access them tomorrow. They've been without their online business app for 3 business days now... not good... Rick -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 9:10 AM To: CF-Talk Subject: Re: OT: DNS Problems... On Tuesday 28 November 2006 13:25, Rick Faircloth wrote: In the A records, I did have a Host name mail that Points To 66.79.46.138 (my only IP). I say I did have because I figured it was unnecessary at least and harmful at best, so I removed the mail subdomain from the A records completely. Correct this to do? It's normal to define an A record for the host that is your MX (ie handles your email). Now in the MX records, there is Host mail Goes To mail.whitestonemedia.com Host smtp Goes To mail.whitestonemedia.com Host pop Goes To mail.whitestonemedia.com If you've removed the A record, this won't work - what is the IP of mail.whitestonemedia.com, according to your DNS ? But why would these settings, if incorrect, only affect only one customer? Why not all people trying to access my websites? DNS propogates slowly, and at different speeds, depending on the moon :-) -- Tom Chiverton Helping to adaptively target performance-oriented solutions ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261983 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: DNS Problems...
Thanks, Jon... I'll check on your solutions and see what happens. Rick -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 6:53 AM To: CF-Talk Subject: Re: OT: DNS Problems... Rick, I don't know anything about your client's setup, but do they use any kind of 3rd party DNS server or Web Filter (e.g. - http:// www.barracudanetworks.com/ns/products/spyware_overview.php) to restrict the accessible content behind their firewall (i.e. - to keep their employees from accessing certain sites on company time)? If so, could there be a DNS caching issue with the 3rd party provider where they cached one of the bad settings during your changes? Also, do they maintain any kind of internal DNS for their intranet? If so, there may be a hosts file on the server that manages their internal DNS that can be edited directly that would point all of the clients behind their firewall to your IP. That might be a good short-term solution. Sorry I didn't get back to you yesterday. I was off-list for the day. Jon ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261984 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Vista (was: CrystalTech outage?)
I didn't compare either one to the other or claim either was better than the other. They both have their uses where I'm concerned. I use both on a daily basis. I simply said (in a round-about way) that Linux isn't as secure as a lot of people like to think or make others think. I'd say the same thing about Windows but there really isn't any opposition to that argument so it's pointless to even bring it up. That would be Pre-Vista of course... I don't know enough about Vista to say one way or another but hey... they claimed IE7 was all new and improved too didn't they. So did they just code in the same old bugs or lie about writing it from scratch this time around? The only person and argument you have to worry about starting a debate in this trhead would be Dave the Disruptor claiming the all mighty MAC supremecy. ;-) ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: John C. Bland II [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 11:02 PM To: CF-Talk Subject: Re: Vista (was: CrystalTech outage?) You may not want to open that bag of worms. lol. Plee: Please don't start a Linux vs Windows flame war. On 11/28/06, Bobby Hartsfield [EMAIL PROTECTED] wrote: argue blindly maybe :-) There are plenty of holes in the security of default Linux installations and just as many viruses/Trojans written specifically with Linux in mind. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 8:06 PM To: CF-Talk Subject: RE: Vista (was: CrystalTech outage?) Linux users would argue otherwise :-) -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 22:13 To: CF-Talk Subject: Re: Vista (was: CrystalTech outage?) Aren't all comps open to hack/attacks... This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Munson, Jacob To: CF-Talk Sent: Tue Nov 28 21:56:27 2006 Subject: RE: Vista (was: CrystalTech outage?) They actually let hackers take a shot at Vista this summer and rave reviews came out of it. I think 1 person was able to trick UAC but this was in...hrmmm...I think Beta 2. That hole was covered in the next major release. See, this is exactly what I'm talking about. I have no doubt that Vista will be more secure than XP, merely because of the non-admin user thing. But there /will/ be holes that allow hackers to bypass the UAC stuff. Mark my words. Will antivirus programs solve this? They could, but like Dave pointed out you still have to have updated virus definitions (which should be automated anyway). -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == EMF idahopower.com made the previous annotations. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261985 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Queries adding table Alias to column name
Select c.* from mytable C is aliasing 'mytable' as 'c' Yes, I know. That's not the problem. The problem is that the COLUMN is being returned as c.columnname. This should NOT happen. If you run your same query in the Access query analyzer you are going to get the exact same results. It is NOT a 'bug' in the Unicode driver. A bug would be returning results that it shouldnt. Since Access itself returns those EXACT same results... the driver does what it should. I don't care what happens in Query Analyzer. Microsoft is know to do things not quite by the book. Why do all other drivers return the actual column name? If it's NOT a bug, then is there is a bug in ALL the other drivers? Here are samples on SQL Server and MySQL. http://www.cf-ezcart.com/bud.cfm http://www.cf-ezcart.com/mysql/bud.cfm Can you show me an example of one (other than the buggy unicode driver) that returns the table name as part of the column name? This is the first time I've seen it since I started coding in 1997. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261986 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Queries adding table Alias to column name
I expected more from you Dave. :) It's an inner join that will always have the same value in both columns or nothing will be returned. * is a standard wildcard to call all columns in all tables. I see experts write sql that way all the time. If it were a left join with the possibility of different values, obviously I'd write my SQL different. That doesn't excuse whoever released this buggy driver making up the rules as they go. Anyway, as with all other bugs, I'll take it into account in the future. While the failure of the Unicode driver to conform to the behavior of other drivers you used previously may well be a bug, the ambiguity within your own code that brought this failure to your attention is also a bug. One of these two bugs can be fixed by you, the other can't. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Queries adding table Alias to column name
I don't care what happens in Query Analyzer. Well, there is where your problem starts. The driver simply lets CF communicate with the access database. What the analyzer returns is the exact same thing that the driver is giving you. The next time you need help, just tell us what you want to hear and we'll see what we can do. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Bud [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 7:45 AM To: CF-Talk Subject: RE: Queries adding table Alias to column name Select c.* from mytable C is aliasing 'mytable' as 'c' Yes, I know. That's not the problem. The problem is that the COLUMN is being returned as c.columnname. This should NOT happen. If you run your same query in the Access query analyzer you are going to get the exact same results. It is NOT a 'bug' in the Unicode driver. A bug would be returning results that it shouldnt. Since Access itself returns those EXACT same results... the driver does what it should. I don't care what happens in Query Analyzer. Microsoft is know to do things not quite by the book. Why do all other drivers return the actual column name? If it's NOT a bug, then is there is a bug in ALL the other drivers? Here are samples on SQL Server and MySQL. http://www.cf-ezcart.com/bud.cfm http://www.cf-ezcart.com/mysql/bud.cfm Can you show me an example of one (other than the buggy unicode driver) that returns the table name as part of the column name? This is the first time I've seen it since I started coding in 1997. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local Int'l Phone/Fax: 386.789.0968 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261989 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: DNS Problems...
Thanks, Jon... Rick -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 7:10 AM To: CF-Talk Subject: Re: OT: DNS Problems... Also, One other thing you can do for any of the individual clients that absolutely need to access the application today is to have them edit the hosts file on their own computer to point toward that IP. In Windows XP, the hosts file is usually located at C:\WINDOWS \system32\drivers\etc\hosts On a Mac, the hosts file is located at /etc/hosts This will override the external DNS and always point that machine to your IP for that particular domain name. Jon ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261988 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: DNS Problems...
Thanks, Jon... Rick -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 7:10 AM To: CF-Talk Subject: Re: OT: DNS Problems... Also, One other thing you can do for any of the individual clients that absolutely need to access the application today is to have them edit the hosts file on their own computer to point toward that IP. In Windows XP, the hosts file is usually located at C:\WINDOWS \system32\drivers\etc\hosts On a Mac, the hosts file is located at /etc/hosts This will override the external DNS and always point that machine to your IP for that particular domain name. Jon ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261990 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL sums and joins
Thanks Gert, that did the trick. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261991 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple Date - I think
Thank you Ben. You're the best! D CreateODBCDateTime( CreateDate( Year( Now() ), Month( FORM_VALUE_GOES_HERE ), Day( Now() ) ) ) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UDF inspection, please!
Ben Nadel wrote: So, are you saying that the attribute value IS going to be an issue, or it is not? Sorry, I was just a bit confused if you needed any more ideas? If your goal is ONLY to prevent unwanted HTML, then it's not an issue - neither is the comment thing, for that matter. If you absolutely desire clean removal of HTML, then quoted attributes with chars in them will actually cause some leftover, unwanted text.. but it won't leave any unwanted html tags. Take the following: input type=text name=foo value=embed .. In a perfect world, the entire thing would be removed. However, my tag would leave ... not dangerous HTML or anything but not the desired output. But since my only goal is to allow only certain HTML or to strip dangerous html... it works fabulously. If you were stripping HTML from a blog comment for the purpose of emailing a text only version of that comment to subscribers, you might be left with a few extra characters, like in the case above. Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261993 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Queries adding table Alias to column name
I expected more from you Dave. :) I'm sorry to disappoint. But as a consultant, it's my job to tell people the unpleasant things they don't want to hear. I'll be sending you a bill, of course. I'd type a smiley face here, but I'm too priggish to do that. It's an inner join that will always have the same value in both columns or nothing will be returned. * is a standard wildcard to call all columns in all tables. I see experts write sql that way all the time. If it were a left join with the possibility of different values, obviously I'd write my SQL different. That doesn't excuse whoever released this buggy driver making up the rules as they go. First, you need to seek a better class of experts. Anybody worthy of being called an expert web application developer would tell you to only select the columns that you need. Second, you should try to avoid any ambiguity in your code. I'm not trying to excuse anybody from anything - I don't have a horse in this race. But writing ambiguous commands in any programming environment is asking for trouble, and you shouldn't be surprised when you get what you ask for. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Vista (was: CrystalTech outage?)
Vista simply makes that a little simpler, by requiring user intervention for administrative actions Unless it's turned off. Or broken. Or there's an issue with a privileged network deamon. Or... How is this any different from anything else? Fortunately, most users won't be able to figure out how to disable UAC, I suspect. As I said, it's not what users do that bothers me, it's the non-user related holes. The remote attack surface for a patched Windows XP SP2 machine with the Windows firewall enabled is pretty small. I have every reason to expect the attack surface for Vista to be as small or smaller. That, by itself, doesn't mean that users can't do stupid things that will get their machines compromised. So I'm not sure why you'd be so unconcerned with user security. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261995 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFQUERY: comma delimited list of id values
All, I'm trying to figure out how best to pass a list of comma delimited id (numeric) values to another query. I'm having trouble with getting the list of id values to not have a , (comma) after the last value in the output. Any help would be very appreciated. Should I be using a cfloop instead on the 2nd section below? !--- 1 - GET RECIPES FOR PRE SELECTED MONTH AND YEAR --- CFquery name=get_rec_4month datasource=#datasource# select * from dbo.tbl_recipe_monthly_winner where (month(recw_assign_month )= 01) AND (year(recw_assign_month )= 2006) /CFquery !--- 2 - OUTPUT VALUES IN QUERY TO GET COMMA DELIMITED LIST OF ID VALUES --- cfoutput query=get_rec_4month CFSET results = #get_rec_4month.recipeID#, /cfoutput !--- 3 - QUERY TABLES WHERE COMMA DELIMTED LIST IN IN WHERE CLAUSE --- cfquery name=sfc_all_recipes datasource=#recipes# SELECT *, dbo.recipeingredients.ingredients, dbo.addresses.firstname, dbo.addresses.lastname, dbo.recipes.recipeID, dbo.recipes.recipename, dbo.recipes.recipedesc, dbo.recipes.instructions, dbo.recipes.imageID FROM dbo.recipes INNER JOIN dbo.addresses ON dbo.recipes.addressID = dbo.addresses.addressID INNER JOIN dbo.recipeingredients ON dbo.recipes.recipeID = dbo.recipeingredients.recipeID WHERE dbo.recipes.recipeID IN #results# /cfquery Thanks. D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261996 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFQUERY: comma delimited list of id values
Try this: cfset results = valuelist(get_rec_4month.recipeID) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 7:38 PM To: CF-Talk Subject: CFQUERY: comma delimited list of id values All, I'm trying to figure out how best to pass a list of comma delimited id (numeric) values to another query. I'm having trouble with getting the list of id values to not have a , (comma) after the last value in the output. Any help would be very appreciated. Should I be using a cfloop instead on the 2nd section below? !--- 1 - GET RECIPES FOR PRE SELECTED MONTH AND YEAR --- CFquery name=get_rec_4month datasource=#datasource# select * from dbo.tbl_recipe_monthly_winner where (month(recw_assign_month )= 01) AND (year(recw_assign_month )= 2006) /CFquery !--- 2 - OUTPUT VALUES IN QUERY TO GET COMMA DELIMITED LIST OF ID VALUES --- cfoutput query=get_rec_4month CFSET results = #get_rec_4month.recipeID#, /cfoutput !--- 3 - QUERY TABLES WHERE COMMA DELIMTED LIST IN IN WHERE CLAUSE --- cfquery name=sfc_all_recipes datasource=#recipes# SELECT *, dbo.recipeingredients.ingredients, dbo.addresses.firstname, dbo.addresses.lastname, dbo.recipes.recipeID, dbo.recipes.recipename, dbo.recipes.recipedesc, dbo.recipes.instructions, dbo.recipes.imageID FROM dbo.recipes INNER JOIN dbo.addresses ON dbo.recipes.addressID = dbo.addresses.addressID INNER JOIN dbo.recipeingredients ON dbo.recipes.recipeID = dbo.recipeingredients.recipeID WHERE dbo.recipes.recipeID IN #results# /cfquery Thanks. D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261997 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFQUERY: comma delimited list of id values
You could try a couple different ways... First you could use #valuelist(get_rec_4month.recipeID)# as the list Or you could just put the query that gets the recipeIDs in the IN () section of the final query like so... WHERE dbo.recipes.recipeID IN ( select recipeid from dbo.tbl_recipe_monthly_winner where (month(recw_assign_month )= 01) AND (year(recw_assign_month )= 2006 ) ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 9:08 AM To: CF-Talk Subject: CFQUERY: comma delimited list of id values All, I'm trying to figure out how best to pass a list of comma delimited id (numeric) values to another query. I'm having trouble with getting the list of id values to not have a , (comma) after the last value in the output. Any help would be very appreciated. Should I be using a cfloop instead on the 2nd section below? !--- 1 - GET RECIPES FOR PRE SELECTED MONTH AND YEAR --- CFquery name=get_rec_4month datasource=#datasource# select * from dbo.tbl_recipe_monthly_winner where (month(recw_assign_month )= 01) AND (year(recw_assign_month )= 2006) /CFquery !--- 2 - OUTPUT VALUES IN QUERY TO GET COMMA DELIMITED LIST OF ID VALUES --- cfoutput query=get_rec_4month CFSET results = #get_rec_4month.recipeID#, /cfoutput !--- 3 - QUERY TABLES WHERE COMMA DELIMTED LIST IN IN WHERE CLAUSE --- cfquery name=sfc_all_recipes datasource=#recipes# SELECT *, dbo.recipeingredients.ingredients, dbo.addresses.firstname, dbo.addresses.lastname, dbo.recipes.recipeID, dbo.recipes.recipename, dbo.recipes.recipedesc, dbo.recipes.instructions, dbo.recipes.imageID FROM dbo.recipes INNER JOIN dbo.addresses ON dbo.recipes.addressID = dbo.addresses.addressID INNER JOIN dbo.recipeingredients ON dbo.recipes.recipeID = dbo.recipeingredients.recipeID WHERE dbo.recipes.recipeID IN #results# /cfquery Thanks. D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261998 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFQUERY: comma delimited list of id values
A few ways depending on what you need. Look at ValueList(). A very useful function. Or combine the first query in the second: cfquery name=sfc_all_recipes datasource=#recipes# SELECT *, dbo.recipeingredients.ingredients, dbo.addresses.firstname, dbo.addresses.lastname, dbo.recipes.recipeID, dbo.recipes.recipename, dbo.recipes.recipedesc, dbo.recipes.instructions, dbo.recipes.imageID FROM dbo.recipes INNER JOIN dbo.addresses ON dbo.recipes.addressID = dbo.addresses.addressID INNER JOIN dbo.recipeingredients ON dbo.recipes.recipeID = dbo.recipeingredients.recipeID WHERE dbo.recipes.recipeID IN ( select recipeID from dbo.tbl_recipe_monthly_winner where (month(recw_assign_month )= 01) AND (year(recw_assign_month )= 2006) ) /cfquery Adrian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 29 November 2006 14:08 To: CF-Talk Subject: CFQUERY: comma delimited list of id values All, I'm trying to figure out how best to pass a list of comma delimited id (numeric) values to another query. I'm having trouble with getting the list of id values to not have a , (comma) after the last value in the output. Any help would be very appreciated. Should I be using a cfloop instead on the 2nd section below? !--- 1 - GET RECIPES FOR PRE SELECTED MONTH AND YEAR --- CFquery name=get_rec_4month datasource=#datasource# select * from dbo.tbl_recipe_monthly_winner where (month(recw_assign_month )= 01) AND (year(recw_assign_month )= 2006) /CFquery !--- 2 - OUTPUT VALUES IN QUERY TO GET COMMA DELIMITED LIST OF ID VALUES --- cfoutput query=get_rec_4month CFSET results = #get_rec_4month.recipeID#, /cfoutput !--- 3 - QUERY TABLES WHERE COMMA DELIMTED LIST IN IN WHERE CLAUSE --- cfquery name=sfc_all_recipes datasource=#recipes# SELECT *, dbo.recipeingredients.ingredients, dbo.addresses.firstname, dbo.addresses.lastname, dbo.recipes.recipeID, dbo.recipes.recipename, dbo.recipes.recipedesc, dbo.recipes.instructions, dbo.recipes.imageID FROM dbo.recipes INNER JOIN dbo.addresses ON dbo.recipes.addressID = dbo.addresses.addressID INNER JOIN dbo.recipeingredients ON dbo.recipes.recipeID = dbo.recipeingredients.recipeID WHERE dbo.recipes.recipeID IN #results# /cfquery Thanks. D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFQUERY: comma delimited list of id values
[EMAIL PROTECTED] wrote: All, I'm trying to figure out how best to pass a list of comma delimited id (numeric) values to another query. I'm having trouble with getting the list of id values to not have a , (comma) after the last value in the output. Any help would be very appreciated. Should I be using a cfloop instead on the 2nd section below? You should be using valuelist... cfset restults = valuelist(get_rec_4month.recipeID) (or quotedvaluelist, if dealing with strings) !--- 1 - GET RECIPES FOR PRE SELECTED MONTH AND YEAR --- CFquery name=get_rec_4month datasource=#datasource# select * from dbo.tbl_recipe_monthly_winner where (month(recw_assign_month )= 01) AND (year(recw_assign_month )= 2006) /CFquery !--- 2 - OUTPUT VALUES IN QUERY TO GET COMMA DELIMITED LIST OF ID VALUES --- cfoutput query=get_rec_4month CFSET results = #get_rec_4month.recipeID#, /cfoutput !--- 3 - QUERY TABLES WHERE COMMA DELIMTED LIST IN IN WHERE CLAUSE --- cfquery name=sfc_all_recipes datasource=#recipes# SELECT *, dbo.recipeingredients.ingredients, dbo.addresses.firstname, dbo.addresses.lastname, dbo.recipes.recipeID, dbo.recipes.recipename, dbo.recipes.recipedesc, dbo.recipes.instructions, dbo.recipes.imageID FROM dbo.recipes INNER JOIN dbo.addresses ON dbo.recipes.addressID = dbo.addresses.addressID INNER JOIN dbo.recipeingredients ON dbo.recipes.recipeID = dbo.recipeingredients.recipeID WHERE dbo.recipes.recipeID IN #results# /cfquery But you could also do this as a subquery... cfquery name=sfc_all_recipes datasource=#recipes# SELECT dbo.recipes.*, dbo.recipeingredients.ingredients, dbo.addresses.firstname, dbo.addresses.lastname, dbo.recipes.recipeID, dbo.recipes.recipename, dbo.recipes.recipedesc, dbo.recipes.instructions, dbo.recipes.imageID FROM dbo.recipes INNER JOIN dbo.addresses ON dbo.recipes.addressID = dbo.addresses.addressID INNER JOIN dbo.recipeingredients ON dbo.recipes.recipeID = dbo.recipeingredients.recipeID WHERE dbo.recipes.recipeID IN (select recipeID from dbo.tbl_recipe_monthly_winner where (month(recw_assign_month )= 01) AND (year(recw_assign_month )= 2006) ) /cfquery Thanks. D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262000 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Loading page
If you are interested, I wrote a short little blog entry on this using
CFFLUSH and a tiny bit of JavaScript:
http://ray.camdenfamily.com/index.cfm/2006/11/29/A-Loading-page-with-CFFLUSH-and-JavaScript
On 11/28/06, Matthew Chambers [EMAIL PROTECTED] wrote:
Hi,
There is no need for the call to be truly asynchronous. The problem at the
moment is that the call can sometimes take up to 40 seconds so the customer
is not sure that something is happening. I would prefer if when the user hits
submit button on the form I take them to a page that has a loading message
and then forward them on to the result page once the page has loaded.
Someone out there must have a rock solid solution to this! Most of the
airlines have some sort of loading page!
Cheers
Matthew
You can actually use specific AJAX status codes to determine the calls
status (2,3,4... If I remember correctly).
I think you will need to use AJAX if you want true loading status as the
browsers spinning globe etc is supposed to be used to tell the user a
page/request is loading..
Do you need the call to be truly asynchronous (so you can do other things?)
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privileged. It is for the exclusive use of the
intended recipient(s). If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful. If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910. The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: Jon Clausen
To: CF-Talk
Sent: Tue Nov 28 07:29:44 2006
Subject: Re: Loading page
Matthew,
Simple, but you can take it from there (if you're using AJAX to
display the results of the call you can skip the show/hide of the div):
script type=text/javascript language=javascript
cfsilent
cfsavecontent variable=message
h2Thank You. We Are Processing the information you have requested/
h2
p class=noticePlease Stand By./p
div align=centerimg src=loading.gif alt=loading//div
/cfsavecontent
/cfsilent
cfwddx action=cfml2js input=#message#
toplevelvariable=procmessage /
function showProcess() {
pcontent = document.getElementById(processing);
fcontent = document.getElementById(yourForm);
fcontent.style.display = none;
pcontent.style.display = block;
pcontent.innerHTML = procmessage;
}
/script
div#processing is obviously set with style=display:none when the
page loads.
- Jon
On Nov 27, 2006, at 11:57 PM, Matthew Chambers wrote:
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262001
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Challenging Loop problem SOLVED
Great job guys! Drop this into the code to see the colors displayed: cfoutput cfloop index=val list=#colorList# div style=float: left; background:###val#;width: 50px; height:50px;/div /cfloop /cfoutput !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 11:49 AM To: CF-Talk Subject: RE: Challenging Loop problem SOLVED As promised the completed task of this strange harmonic looping project. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UDF inspection, please!
oh, I converted this to a CF5 compatible UDF for those poor souls still stuck maintaining CF5 code out there. =) I just submitted it to cflib that way. Hopefully I did it right, Ray's got a lot of rules :) Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262003 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFQUERY: comma delimited list of id values
coldfusion.developer wrote: I'm trying to figure out how best to pass a list of comma delimited id (numeric) values to another query. !--- 1 - GET RECIPES FOR PRE SELECTED MONTH AND YEAR --- CFquery name=get_rec_4month datasource=#datasource# select * from dbo.tbl_recipe_monthly_winner where (month(recw_assign_month )= 01) AND (year(recw_assign_month )= 2006) /CFquery cfquery name=sfc_all_recipes datasource=#recipes# SELECT *, RI.ingredients, A.firstname, A.lastname, R.recipeID, R.recipename, R.recipedesc, R.instructions, R.imageID FROM dbo.recipes R INNER JOIN dbo.addresses A ON R.addressID = A.addressID INNER JOIN dbo.recipeingredients RI ON R.recipeID = RI.recipeID WHERE R.recipeID IN (cfqueryparam cfsqltype=cf_sql_integer value=#ValueList(get_rec_4month.recipeID)# list=true /cfquery Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262004 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Strange (non consistent) behaviour in CF
On one of our servers, we are getting a page stopping rendering half- way down the page, has anyone seen this happen before? Just a wild stab in the dark here... MD ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262005 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Strange (non consistent) behaviour in CF
Yes, this happened to a site I worked on. The server used Trusted Cache so that was assumed to be the problem (restarting CF cleared the cache) - but maybe the restart worked in some other way! David -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 29 November 2006 14:36 To: CF-Talk Subject: Strange (non consistent) behaviour in CF On one of our servers, we are getting a page stopping rendering half- way down the page, has anyone seen this happen before? Just a wild stab in the dark here... MD ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262006 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Challenging Loop problem.
Regardless of the hexidecimal generation. The pattern is taught to first year statistic students. It is just a permutation set of all possible combinations of three items that allow repeats. If you have three items with three slots, that means that you have have 3 comibnations in each slot, so 3^3 possibilities. The pattern changes exponentially based upon the number of slots and items. 4 items with three slots goes to 4^3 and thus 64. So, you have this huge change for adding item ball to the permutation set. Ben's explanation showed the proof of the pattern. A harmonic permutation would have more than one permutation set working together. Teddy On 11/28/06, Ian Skinner [EMAIL PROTECTED] wrote: Some sort of hexadecimal generator? YUP! Andy wins the prize. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262007 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
UDF Inspection, #2
Okay.. since there's really no good way to use regular expressions to
strip HTML attributes that may contain javascript... I decided to write
a UDF that detects possible javacript in user published content. For
example, if you allow users to enter anchor tags, you need to prevent
them from attaching unwelcome javascript via things like onmouseover,
onclick, etc
This could also be used to detect style attributes and other unwanted items.
So... How does this UDF look?
cfscript
function findScript(str)
{
var badAttributes =
onblur,onfocus,oncontextmenu,onresize,onscroll,onunload,onclick,ondblclick,onmousedown,onmouseup,onmouseover,onmouseout,onmouseenter,onmouseleave,onmousemove,onchange,onreset,onselect,onsubmit,onkeydown,onkeypress,onkeyup,onabort;
var loc = 0;
var i = 0;
var att = '';
for (i=1; i lte listLen(badAttributes); i = i + 1)
{
att = listgetat(badAttributes,i);
loc = REFindNoCase([A-Z]*\s+[^]*#att#=.*?,str);
if (loc gt 0) {
return true;
}
}
return false;
}
/cfscript
cfscript
function findScript(str)
{
var badAttributes =
onblur,onfocus,oncontextmenu,onresize,onscroll,onunload,onclick,ondblclick,onmousedown,onmouseup,onmouseover,onmouseout,onmouseenter,onmouseleave,onmousemove,onchange,onreset,onselect,onsubmit,onkeydown,onkeypress,onkeyup,onabort;
var loc = 0;
var i = 0;
var att = '';
for (i=1; i lte listLen(badAttributes); i = i + 1)
{
att = listgetat(badAttributes,i);
loc = REFindNoCase([A-Z]*\s+[^]*#att#=.*?,str);
if (loc gt 0) {
return true;
}
}
return false;
}
/cfscript
cfsavecontent variable=myString
a href=http://www.foo.com; onmouseover=alert('Hi')Click
here!/a/cfsavecontent
cfoutput#findScript(myString)#/cfoutput
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262008
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Strange (non consistent) behaviour in CF
On one of our servers, we are getting a page stopping rendering half- way down the page, has anyone seen this happen before? Another reason for this could be an error deep in the HTML code so that one cannot see it on the page. In that case, viewing the source will help. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262009 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Getting image files from another server
This is as much an HTML question as CF, but...I'm building a CF app to display images. Let's call my webserver X with the images being on Y and Z and the database I need to use is on Z. X, Y and Z are all on the same network. I can set up a datasource across the network so I can pull data from Z but one piece of that data is the path to the image - which may be on Y or Z. But I can't access the images. I'm beginning to suspect I'll have to copy the images to the webserver to use them. Anyone knowledgeable about this? Larry V. Stephens Indiana University Office of Risk Management [EMAIL PROTECTED] 812-855-9758 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Getting image files from another server
If you run CF under a user acocunt instead of SYSTEM, and give that user access to shared folders on the remote machines that contain the images, then CF should be able to access the images. Russ -Original Message- From: Stephens, Larry V [mailto:[EMAIL PROTECTED] Sent: 29 November 2006 15:05 To: CF-Talk Subject: Getting image files from another server This is as much an HTML question as CF, but...I'm building a CF app to display images. Let's call my webserver X with the images being on Y and Z and the database I need to use is on Z. X, Y and Z are all on the same network. I can set up a datasource across the network so I can pull data from Z but one piece of that data is the path to the image - which may be on Y or Z. But I can't access the images. I'm beginning to suspect I'll have to copy the images to the webserver to use them. Anyone knowledgeable about this? Larry V. Stephens Indiana University Office of Risk Management [EMAIL PROTECTED] 812-855-9758 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262011 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting image files from another server
Are Y and Z web servers? If so you would just need to supply their host names in the in html. On 11/29/06, Stephens, Larry V [EMAIL PROTECTED] wrote: This is as much an HTML question as CF, but...I'm building a CF app to display images. Let's call my webserver X with the images being on Y and Z and the database I need to use is on Z. X, Y and Z are all on the same network. I can set up a datasource across the network so I can pull data from Z but one piece of that data is the path to the image - which may be on Y or Z. But I can't access the images. I'm beginning to suspect I'll have to copy the images to the webserver to use them. Anyone knowledgeable about this? Larry V. Stephens Indiana University Office of Risk Management [EMAIL PROTECTED] 812-855-9758 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262013 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Can't figure out why these ID's aren't unique
Just noticed a flaw in my store app. I'm generating what I THOUGHT were unique ID's for carts and shoppers. They get plugged into the db for later use. There seem to be a few records with the same ID. This ID field isn't the PK of the table. When the app starts, a shopper service and cart service are initialized. This is where I'm creating the ID. I WAS using randrange() and the date appended to it. Just changed that to timeformat() to get an exact time and maybe help this problem out. What's odd is I'm lookin in the cart table, and I see no such duplication. All the ID's are unique, yet I'm using the same method to generate THOSE too. Here's where it's created. Any ideas? cfset APPLICATION.cartservice = CreateObject(component, cfcs.cartservice).init(dsn=application.settings.dsn) cfset APPLICATION.shopperservice = CreateObject(component, cfcs.shopperservice).init(browser=CGI.http_user_agent) cffunction name=init access=public output=false returntype=shopperservice cfargument name=browser required=yes cfset VARIABLES.shopperStats = StructNew() !--- Create a shopper ID for this shopper --- cfset VARIABLES.shopperStats.shopperID = TimeFormat(Now(), hmmss) DateFormat(Now(),m-dd-yy) !--- Setup other variables that come in from onAppStart in App.cfc --- cfset VARIABLES.shopperStats.shopperBrowser = ARGUMENTS.browser cfreturn this /cffunction And here's for the cartID. No problem I see with these ID's. cffunction name=init access=public output=false returntype=cartservice cfargument name=dsn cfset VARIABLES.dsn = ARGUMENTS.dsn cfset VARIABLES.finalCartTotal = 0 !--- Create a cart ID for this cart --- cfset VARIABLES.cartID = TimeFormat(Now(), hmmss) DateFormat(Now(),m-dd-yy) cfset VARIABLES.totals = StructNew() cfset VARIABLES.cartItemsAdded = false cfreturn this /cffunction Thanks, Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262012 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: UDF Inspection, #2
found one bug already the regex should be as follows, since all HTML
tags start with an alpha but *CAN* contain numbers.. ie, h1-h5...
loc = REFindNoCase([A-Z][A-Z0-9]*\s+[^]*#att#=.*?,str);
In english... find any tag that starts with a letter and is followed by
zero or more alphanumeric characters, one or more whitespace characters,
any amount of text that doesn't include a , the specified attribute and
an equal sign, any amount of text ending with a
there does seem to be a flaw in it...
a ... someatt= onmouseover=foo
would not be detected...
If I try *THIS* regex
loc = REFindNoCase([A-Z][A-Z0-9]*\s+.*#att#=.*?,str);
it works with the above case, but *NOT* with this case:
a href=http://www.cflib.org;Click here!/b if you
don't like onmouseover= in your code.a
href=http://www.opensourcecf.com;foo/a/cfsavecontent
So again, there seems to be no valid solution for either detecting or
stripping unwanted attributes.
However.. I could convert the = sign to an HTML entity, which would
render it invalid.
a href=foo.html onmouseover#61;alert('hi')foo/A
The #61; would still be visible on the page as an equal sign, but in
the source code it would prevent the attribute from working.
So I would regex like this:
reReplaceNoCase(str,onmouseover\s*=,onmouseover##61;,ALL)
Of course, the output wouldn't be very xhtml compliant ;)
Rick
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262014
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Loading page
I actually wrote a post covering something similar a few weeks back - http://www.remotesynthesis.com/blog/index.cfm/2006/11/16/Processing-Uploaded-Files-Using-AjaxCFC It does use Ajax, but the key was that I was able to offer some kind of actual usable feedback to the user as the process was running. - Brian Rinaldi blog: http://www.remotesynthesis.com/blog ColdFusion Open Source List: http://www.remotesynthesis.com/cfopensourcelist Boston CFUG - http://www.bostoncfug.org Adobe Community Expert - http://www.adobe.com/communities/experts/members/brian_rinaldi.html CFDJ Editorial Board - http://coldfusion.sys-con.com/general/editboard.htm -Original Message- From: Matthew Chambers To: CF-Talk Sent: Wed Nov 29 04:57:19 2006 Subject: Re: Loading page Hi, There is no need for the call to be truly asynchronous. The problem at the moment is that the call can sometimes take up to 40 seconds so the customer is not sure that something is happening. I would prefer if when the user hits submit button on the form I take them to a page that has a loading message and then forward them on to the result page once the page has loaded. Someone out there must have a rock solid solution to this! Most of the airlines have some sort of loading page! Cheers Matthew the intended recipient(s). If you are not the intended recipient(s) please note ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262015 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Loading page
I actually wrote a post covering something similar a few weeks back - http://www.remotesynthesis.com/blog/index.cfm/2006/11/16/Processing-Uploaded-Files-Using-AjaxCFC It does use Ajax, but the key was that I was able to offer some kind of actual usable feedback to the user as the process was running. - Brian Rinaldi blog: http://www.remotesynthesis.com/blog ColdFusion Open Source List: http://www.remotesynthesis.com/cfopensourcelist Boston CFUG - http://www.bostoncfug.org Adobe Community Expert - http://www.adobe.com/communities/experts/members/brian_rinaldi.html CFDJ Editorial Board - http://coldfusion.sys-con.com/general/editboard.htm -Original Message- From: Matthew Chambers To: CF-Talk Sent: Wed Nov 29 04:57:19 2006 Subject: Re: Loading page Hi, There is no need for the call to be truly asynchronous. The problem at the moment is that the call can sometimes take up to 40 seconds so the customer is not sure that something is happening. I would prefer if when the user hits submit button on the form I take them to a page that has a loading message and then forward them on to the result page once the page has loaded. Someone out there must have a rock solid solution to this! Most of the airlines have some sort of loading page! Cheers Matthew the intended recipient(s). If you are not the intended recipient(s) please note ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262016 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Getting image files from another server
No - they aren't webservers. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 10:18 AM To: CF-Talk Subject: Re: Getting image files from another server Are Y and Z web servers? If so you would just need to supply their host names in the in html. On 11/29/06, Stephens, Larry V [EMAIL PROTECTED] wrote: This is as much an HTML question as CF, but...I'm building a CF app to display images. Let's call my webserver X with the images being on Y and Z and the database I need to use is on Z. X, Y and Z are all on the same network. I can set up a datasource across the network so I can pull data from Z but one piece of that data is the path to the image - which may be on Y or Z. But I can't access the images. I'm beginning to suspect I'll have to copy the images to the webserver to use them. Anyone knowledgeable about this? Larry V. Stephens Indiana University Office of Risk Management [EMAIL PROTECTED] 812-855-9758 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262017 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't figure out why these ID's aren't unique
Kinda weird huh? What I usually do is grab the users phone number and then append the date to the end of it. Since no two users phone numbers will be the same, then I never get a duplicate. I notice with using randRange() it does alot of duplication. If I use it and say randRange(1, 1000) I will get as an example...There is always a chance of duplication. 5,4,900,900,350,5 - Original Message - From: Will Tomlinson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, November 29, 2006 7:08 AM Subject: Can't figure out why these ID's aren't unique Just noticed a flaw in my store app. I'm generating what I THOUGHT were unique ID's for carts and shoppers. They get plugged into the db for later use. There seem to be a few records with the same ID. This ID field isn't the PK of the table. When the app starts, a shopper service and cart service are initialized. This is where I'm creating the ID. I WAS using randrange() and the date appended to it. Just changed that to timeformat() to get an exact time and maybe help this problem out. What's odd is I'm lookin in the cart table, and I see no such duplication. All the ID's are unique, yet I'm using the same method to generate THOSE too. Here's where it's created. Any ideas? cfset APPLICATION.cartservice = CreateObject(component, cfcs.cartservice).init(dsn=application.settings.dsn) cfset APPLICATION.shopperservice = CreateObject(component, cfcs.shopperservice).init(browser=CGI.http_user_agent) cffunction name=init access=public output=false returntype=shopperservice cfargument name=browser required=yes cfset VARIABLES.shopperStats = StructNew() !--- Create a shopper ID for this shopper --- cfset VARIABLES.shopperStats.shopperID = TimeFormat(Now(), hmmss) DateFormat(Now(),m-dd-yy) !--- Setup other variables that come in from onAppStart in App.cfc --- cfset VARIABLES.shopperStats.shopperBrowser = ARGUMENTS.browser cfreturn this /cffunction And here's for the cartID. No problem I see with these ID's. cffunction name=init access=public output=false returntype=cartservice cfargument name=dsn cfset VARIABLES.dsn = ARGUMENTS.dsn cfset VARIABLES.finalCartTotal = 0 !--- Create a cart ID for this cart --- cfset VARIABLES.cartID = TimeFormat(Now(), hmmss) DateFormat(Now(),m-dd-yy) cfset VARIABLES.totals = StructNew() cfset VARIABLES.cartItemsAdded = false cfreturn this /cffunction Thanks, Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262018 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Getting image files from another server
You could play with mapped drives if they are on the same network. Otherwise move them over. Joshua Cyr Savvy Software 866.870.6358 www.besavvy.com -Original Message- From: Stephens, Larry V [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 10:22 AM To: CF-Talk Subject: RE: Getting image files from another server No - they aren't webservers. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 10:18 AM To: CF-Talk Subject: Re: Getting image files from another server Are Y and Z web servers? If so you would just need to supply their host names in the in html. On 11/29/06, Stephens, Larry V [EMAIL PROTECTED] wrote: This is as much an HTML question as CF, but...I'm building a CF app to display images. Let's call my webserver X with the images being on Y and Z and the database I need to use is on Z. X, Y and Z are all on the same network. I can set up a datasource across the network so I can pull data from Z but one piece of that data is the path to the image - which may be on Y or Z. But I can't access the images. I'm beginning to suspect I'll have to copy the images to the webserver to use them. Anyone knowledgeable about this? Larry V. Stephens Indiana University Office of Risk Management [EMAIL PROTECTED] 812-855-9758 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262019 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't figure out why these ID's aren't unique
Maybe I'm missing something but if the ID's are supposed to be unique wouldn't it make common sense to also have the field in the DB unique (PK)? Seems like a problem with the database design more than anything. Just noticed a flaw in my store app. I'm generating what I THOUGHT were unique ID's for carts and shoppers. They get plugged into the db for later use. There seem to be a few records with the same ID. This ID field isn't the PK of the table. When the app starts, a shopper service and cart service are initialized. This is where I'm creating the ID. I WAS using randrange() and the date appended to it. Just changed that to timeformat() to get an exact time and maybe help this problem out. What's odd is I'm lookin in the cart table, and I see no such duplication. All the ID's are unique, yet I'm using the same method to generate THOSE too. Here's where it's created. Any ideas? cfset APPLICATION.cartservice = CreateObject(component, cfcs. cartservice).init(dsn=application.settings.dsn) cfset APPLICATION.shopperservice = CreateObject(component, cfcs. shopperservice).init(browser=CGI.http_user_agent) cffunction name=init access=public output=false returntype=shopperservice cfargument name=browser required=yes cfset VARIABLES.shopperStats = StructNew() !--- Create a shopper ID for this shopper --- cfset VARIABLES.shopperStats.shopperID = TimeFormat(Now(), hmmss) DateFormat(Now(),m-dd-yy) !--- Setup other variables that come in from onAppStart in App.cfc --- cfset VARIABLES.shopperStats.shopperBrowser = ARGUMENTS.browser cfreturn this /cffunction And here's for the cartID. No problem I see with these ID's. cffunction name=init access=public output=false returntype=cartservice cfargument name=dsn cfset VARIABLES.dsn = ARGUMENTS.dsn cfset VARIABLES.finalCartTotal = 0 !--- Create a cart ID for this cart --- cfset VARIABLES.cartID = TimeFormat(Now(), hmmss) DateFormat(Now(),m-dd-yy) cfset VARIABLES.totals = StructNew() cfset VARIABLES.cartItemsAdded = false cfreturn this /cffunction Thanks, Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262020 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Strange (non consistent) behaviour in CF
Actually... more information here we have a cflocation in what would be midway down a page (includes etc etc) but it seems that if it hits a redirect, the ORIGINAL page displays, the new URL is there but the user isnt being forwarded this happens but not in a consistent manner. Any ideas? MD On 29 Nov 2006, at 15:00, Claude Schneegans wrote: On one of our servers, we are getting a page stopping rendering half- way down the page, has anyone seen this happen before? Another reason for this could be an error deep in the HTML code so that one cannot see it on the page. In that case, viewing the source will help. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262021 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF and URL vars as folders?
Robertson-Ravo, Neil (RX) wrote: If you are always going to use index.cfm would you be able to drop that as well? I've been pondering this one as well. With the SESconverter script I'm using, and I'm guessing with any CF-based solution - I'm betting, no. As you're depending on some code inside the index.cfm file (at least in my case) to do the URL fake folder sniffing. I was just thinking about this a few minutes ago - I don't know much about the Apache mod-rewrite method of doing this, but I'm wondering if part of that method involves Apache using a default script when none is specified. With CF, domain.com/x/y/ would make the server look for the index.cfm file if none is specified, yeah, but in the webroot/x/y folder - which wouldn't exist. Apparently IIS does this sort of thing, where you can set it to kick over to a particular file when a 404 (file not found) error pops: http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_21400098.html ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262023 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Vista (was: CrystalTech outage?)
On Wednesday 29 November 2006 14:07, Dave Watts wrote: How is this any different from anything else? Fortunately, most users won't be able to figure out how to disable UAC, I suspect. It'll be interesting to see how many computers ship with it off because it's very broken. As I said, it's not what users do that bothers me, it's the non-user related holes. The remote attack surface for a patched Windows XP SP2 machine with the Windows firewall enabled is pretty small. I have every reason to expect the attack surface for Vista to be as small or smaller. It may be. But there's the whole 'packet of death' thing that's *built into it as a feature*. doesn't mean that users can't do stupid things that will get their machines compromised. So I'm not sure why you'd be so unconcerned with user security. I very concerened about both, don't get me wrong ! -- Tom Chiverton Helping to interactively innovate impactful communities This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262022 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't figure out why these ID's aren't unique
Will, Any reason you can't use createUUID() to generate the unique identifier for each cart/shopper and then timestamp their entry into the database so that you can clean them out later beyond a certain date? Then you won't have to worry about them being duplicated. Jon On Nov 29, 2006, at 9:08 AM, Will Tomlinson wrote: Just noticed a flaw in my store app. I'm generating what I THOUGHT were unique ID's for carts and shoppers. They get plugged into the db for later use. There seem to be a few records with the same ID. This ID field isn't the PK of the table. When the app starts, a shopper service and cart service are initialized. This is where I'm creating the ID. I WAS using randrange() and the date appended to it. Just changed that to timeformat() to get an exact time and maybe help this problem out. What's odd is I'm lookin in the cart table, and I see no such duplication. All the ID's are unique, yet I'm using the same method to generate THOSE too. Here's where it's created. Any ideas? cfset APPLICATION.cartservice = CreateObject(component, cfcs.cartservice).init(dsn=application.settings.dsn) cfset APPLICATION.shopperservice = CreateObject(component, cfcs.shopperservice).init(browser=CGI.http_user_agent) cffunction name=init access=public output=false returntype=shopperservice cfargument name=browser required=yes cfset VARIABLES.shopperStats = StructNew() !--- Create a shopper ID for this shopper --- cfset VARIABLES.shopperStats.shopperID = TimeFormat(Now(), hmmss) DateFormat(Now(),m-dd-yy) !--- Setup other variables that come in from onAppStart in App.cfc --- cfset VARIABLES.shopperStats.shopperBrowser = ARGUMENTS.browser cfreturn this /cffunction And here's for the cartID. No problem I see with these ID's. cffunction name=init access=public output=false returntype=cartservice cfargument name=dsn cfset VARIABLES.dsn = ARGUMENTS.dsn cfset VARIABLES.finalCartTotal = 0 !--- Create a cart ID for this cart --- cfset VARIABLES.cartID = TimeFormat(Now(), hmmss) DateFormat (Now(),m-dd-yy) cfset VARIABLES.totals = StructNew() cfset VARIABLES.cartItemsAdded = false cfreturn this /cffunction Thanks, Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't figure out why these ID's aren't unique
I'm confused. You're creating the cartservice object in the application scope (a scope shared by *ALL* visitors to your web site) *AND* initializing it with an ID SPECIFIC to the current shopper. Question #1 - Why are you using the application scope for session specific information? I can't even imagine how that would work at all... I'm sure it does... but.. Question #2 - why not use CreateUUID() instead of attempting to generate a unique ID? Your method doesn't guarantee uniqueness because two shoppers may be created in the same second. RandRange() doesn't guarantee uniqueness either, but createUUID() does. If you must insist on basing your shopper ID on the time, you could try using Now().getTime() which actually returns a very long integer containing the number of milliseconds since the java epoch (like january 1, 1970 or something). It's allegedly precise to the millisecond, but still not a guarantee. Question #3 - Why don't you just put a unique key on the column in the database table. That would guarantee uniqueness upon insertion into the database. It doesn't have to be the primary key, but you can still put a unique index on it. Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262025 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Strange (non consistent) behaviour in CF
Mark, Any chance there is a cfflush in any of the code being executed (Maybe in an if statement that's not being delivered every time) before the cflocation that would be preventing it from executing? Jon On Nov 29, 2006, at 10:31 AM, Mark Drew wrote: Actually... more information here we have a cflocation in what would be midway down a page (includes etc etc) but it seems that if it hits a redirect, the ORIGINAL page displays, the new URL is there but the user isnt being forwarded this happens but not in a consistent manner. Any ideas? MD On 29 Nov 2006, at 15:00, Claude Schneegans wrote: On one of our servers, we are getting a page stopping rendering half- way down the page, has anyone seen this happen before? Another reason for this could be an error deep in the HTML code so that one cannot see it on the page. In that case, viewing the source will help. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Getting image files from another server
Larry, Have you tried creating a virtual directory (or even a global Alias in Apache) using the network path as the source? I know this works on IIS and I see no reason it wouldn't on Linux. Jon On Nov 29, 2006, at 10:05 AM, Stephens, Larry V wrote: This is as much an HTML question as CF, but...I'm building a CF app to display images. Let's call my webserver X with the images being on Y and Z and the database I need to use is on Z. X, Y and Z are all on the same network. I can set up a datasource across the network so I can pull data from Z but one piece of that data is the path to the image - which may be on Y or Z. But I can't access the images. I'm beginning to suspect I'll have to copy the images to the webserver to use them. Anyone knowledgeable about this? Larry V. Stephens Indiana University Office of Risk Management [EMAIL PROTECTED] 812-855-9758 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
VPS - Rehashed....
OK... I know this has been discussed before, but I am looking for an update. I would like to get some VPS hosting. ..and of course I would like as much as possible for not alot of money ;) Well not necessarily, but lets start from there anyway... I would prefer windows VPS so I could remote desktop in. I wouldn't mind Linux VPS hosting but I would need some type of GUI as I am not that versed in command line Linux. ColdFusion would be preferred if there is someone with a good deal with CF in the package. I will be running a light duty PHP vbulletin forum and need some HD space for user pictures etc. Anyone have any good suggestions. I like hostmysite, but they are a bit steep on the coldfusion hosting. Anyone with any good suggestions? Jeff ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262028 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Vista (was: CrystalTech outage?)
The remote attack surface for a patched Windows XP SP2 machine with the Windows firewall enabled is pretty small. I have every reason to expect the attack surface for Vista to be as small or smaller. That, by itself, doesn't mean that users can't do stupid things that will get their machines compromised. So I'm not sure why you'd be so unconcerned with user security. The statement that started this whole conversation was a Microsoft exec. claiming that Vista won't need antivirus software. I TOTALLY agree that Vista will be way more secure than previous versions. But to claim that Vista won't need antivirus software is to claim that it won't have holes. Microsoft is notorious for taking a while to fix holes. On the other hand, antivirus companies usually have updated definitions within a few hours. So the first time a critical zero day exploit is released, even if it does require user intervention, what is a network admin to do? Hope and pray that MS develops and hurries a patch to market, and in the mean time all of their users read the emails and posted warning signs? That won't happen, so their only recourse is to get the updated definitions pushed ASAP, or maybe send everybody home in the mean time. I think this MS quote will be added to the previous retarded quotes that have come from Redmond: No user will ever need more than 64 KB of RAM The NTFS file system doesn't ever get fragmented and now, Vista doesn't need antivirus software -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == EMF idahopower.com made the previous annotations. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Looking for a good MXAjax Coldfusion freelancer...
As title suggests, looking for a good CF MXAJAX person for some freelance work! If interested please contact me at [EMAIL PROTECTED] Thanks, Ben ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Can't figure out why these ID's aren't unique
I can't say that I've ever seen anyone store a cart structure in the application scope. Let's see if I can figure out how to get someone else to pay but have it sent to me h... :-) Anyway... createUUID() would probably make for a better... umm... well... UUID... heh And for the love of god... move the cart to the session scope. :-P ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 9:08 AM To: CF-Talk Subject: Can't figure out why these ID's aren't unique Just noticed a flaw in my store app. I'm generating what I THOUGHT were unique ID's for carts and shoppers. They get plugged into the db for later use. There seem to be a few records with the same ID. This ID field isn't the PK of the table. When the app starts, a shopper service and cart service are initialized. This is where I'm creating the ID. I WAS using randrange() and the date appended to it. Just changed that to timeformat() to get an exact time and maybe help this problem out. What's odd is I'm lookin in the cart table, and I see no such duplication. All the ID's are unique, yet I'm using the same method to generate THOSE too. Here's where it's created. Any ideas? cfset APPLICATION.cartservice = CreateObject(component, cfcs.cartservice).init(dsn=application.settings.dsn) cfset APPLICATION.shopperservice = CreateObject(component, cfcs.shopperservice).init(browser=CGI.http_user_agent) cffunction name=init access=public output=false returntype=shopperservice cfargument name=browser required=yes cfset VARIABLES.shopperStats = StructNew() !--- Create a shopper ID for this shopper --- cfset VARIABLES.shopperStats.shopperID = TimeFormat(Now(), hmmss) DateFormat(Now(),m-dd-yy) !--- Setup other variables that come in from onAppStart in App.cfc --- cfset VARIABLES.shopperStats.shopperBrowser = ARGUMENTS.browser cfreturn this /cffunction And here's for the cartID. No problem I see with these ID's. cffunction name=init access=public output=false returntype=cartservice cfargument name=dsn cfset VARIABLES.dsn = ARGUMENTS.dsn cfset VARIABLES.finalCartTotal = 0 !--- Create a cart ID for this cart --- cfset VARIABLES.cartID = TimeFormat(Now(), hmmss) DateFormat(Now(),m-dd-yy) cfset VARIABLES.totals = StructNew() cfset VARIABLES.cartItemsAdded = false cfreturn this /cffunction Thanks, Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262032 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UDF Inspection, #2
On Wednesday 29 November 2006 15:21, Rick Root wrote: found one bug already the regex should be as follows, since all HTML tags start with an alpha but *CAN* contain numbers.. ie, h1-h5... I didn't see the start of the thread, so this may have been addressed - but why are you letting your users enter HTML ? Either give them a WYSIWYG DHTML editor with no 'alter source' option, or have them use BBCode or similar instead and replace all and with an escaped version. -- Tom Chiverton Helping to continuously leverage edge-of-your-seat schemas This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262031 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Challenging Loop problem.
It is just a permutation set of all possible combinations of three items that allow repeats. But it was NOT a set of all possible combinations. For example 000, 888 and FFF were not desired results for my problem. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262034 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Loading page
I've done something like what you're after in my main project.
What I basically did was toss in my initial loading content inside a
div with a particular ID name. Below that, I create an iframe pointing
to the first (or only, if need be) CF file that's going to do the
processing.
In the file/files executed in the iframe, they cook along, calling
themselves or the next file, and whilst they do their cooking, they call
the div (by the id) in the parent window, passing updated content in via
innerHTML.
For example, I have an import process. It's several steps. Once I get to
the step where I do validation, I generally do this in 1k blocks. Say an
import is 10k+. You'd get the initial processing text - then you'd get
processing 1-1000 of 10k+ text, along with a thermometer showing the
total progress. As the script in the iframe (which is refreshing itself,
passing what block of 1k it's working on) cooks along, it keeps updating
the content in that div - 1001-2000, 2001-3000, etc etc. Once it's done,
I just use some JS to refresh the parent window on to the next script.
For example, on the main script:
div id=status style=width:600px;Processing.../divp
iframe frameborder=0 width=1 height=1 src=(your script/vars
here)/iframe
within the script called in the iframe, when you want to give the user
an update:
script language=javascript
parent.document.getElementById('status').innerHTML = 'Your
processing update text...';
/script
I generally have two iframes set up, to display one or the other based
on the user status - if it's me, I set the border to one and the
width/height larger so I can see any errors or textual outputs I may
have in there as they come up. Otherwise it's invisible to the average user.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262035
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: DNS Problems...
On Wednesday 29 November 2006 12:01, Rick Faircloth wrote: If it's critical, consider two different hosts in different data centers, far apart as you can get... I may have to go that route... I haven't seen this problem before in 10 years of business... perplexing! You've not had to deal with high availability / redundancy before ? It's a big area to get into, what with risk/threat assessment etc. -- Tom Chiverton Helping to ambassadorially cultivate cross-platform metrics This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262033 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for a good MXAjax Coldfusion freelancer...
Hit the cf-jobs list. ~Brad -Original Message- From: Ben Scammell [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 8:47 AM To: CF-Talk Subject: Looking for a good MXAjax Coldfusion freelancer... As title suggests, looking for a good CF MXAJAX person for some freelance work! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262036 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Challenging Loop problem.
3^3 would be all possibilities though. There were exclusions I believe. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 9:47 AM To: CF-Talk Subject: Re: Challenging Loop problem. Regardless of the hexidecimal generation. The pattern is taught to first year statistic students. It is just a permutation set of all possible combinations of three items that allow repeats. If you have three items with three slots, that means that you have have 3 comibnations in each slot, so 3^3 possibilities. The pattern changes exponentially based upon the number of slots and items. 4 items with three slots goes to 4^3 and thus 64. So, you have this huge change for adding item ball to the permutation set. Ben's explanation showed the proof of the pattern. A harmonic permutation would have more than one permutation set working together. Teddy On 11/28/06, Ian Skinner [EMAIL PROTECTED] wrote: Some sort of hexadecimal generator? YUP! Andy wins the prize. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262037 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Loading page
Pretty simple - you can use the cfflush on the slow page as Ray describes but I
also put it on forms or pages that call slow pages.
Say that you have a page that displays a form and the form calls a slow page.
Add a onclick event on the button that submits the form. When the user clicks
on the submit button, it changes the current view to the waiting image. This
will also keep folks from clicking on submit twice thinking the first click
didn't do anything.
span id=loader style=display:none;
img src=loading.gif alt=Please Wait
/span
form action=... id=fileuploader
input type=file name=topsecretfile
input type=Submit
value=Upload
onclick=document.getElementById('fileuploader').style.display='none';
document.getElementById('loader').style.display='';
/form
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262038
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Vista (was: CrystalTech outage?)
It'll be interesting to see how many computers ship with it off because it's very broken. My guess is that no computers will ship with it off. It doesn't seem broken to me, either. If by broken you mean makes things more difficult for the user, well, yes, I guess it's broken. I'm using Vista RC1. Can you explain what you mean by that? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262039 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Vista (was: CrystalTech outage?)
The statement that started this whole conversation was a Microsoft exec. claiming that Vista won't need antivirus software. I TOTALLY agree that Vista will be way more secure than previous versions. But to claim that Vista won't need antivirus software is to claim that it won't have holes. No, those aren't the same at all. It might have as many holes as a block of Swiss cheese, but if the user can't execute the virus because he lacks permissions to do so, the virus can't run. If the user can execute the virus, but lacks permissions to modify the operating system itself, the virus can't do those things either. In previous versions of Windows, the way you solved this problem was by logging in as a non-privileged user, which would prevent you from performing administrative actions. If you did actually want to perform an administrative action, you'd log in using an account with the required privileges, or you'd use something like runas to run a specific process with those privileges. This is how I've been using Windows XP (and before that, Windows 2000) for some time. Unfortunately, it's kind of clunky to do this, because many applications simply aren't designed to easily run without those privileges. So, for an average user on his own, this isn't an easy route to take. I've found this site to be helpful: http://nonadmin.editme.com/ In Vista, by default, when you log in as a privileged user, you are still prompted every time you do something that requires administrative privileges. In any case, running without administrative privileges is a better security measure than relying on antivirus software. For the most part, antivirus software knows what's been done before that's bad (virus signatures) and prevents you from doing those known bad things. Running without administrative privileges doesn't differentiate between bad and good things, it just prevents you from doing things to the system, period. If you actually want to do those things, you have to jump a few hurdles to do so (if you can do them at all). Of course, there's a bit of oversimplification here, as should be expected on a discussion list, such as the fact that a virus could destroy user data when executed with that user's rights. In general, though, a deny, then allow approach (like restricting user rights) is superior to an allow, then deny approach (like using antivirus software). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262041 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: UDF Inspection, #2
Tom Chiverton wrote: I didn't see the start of the thread, so this may have been addressed - but why are you letting your users enter HTML ? That's not the sole purpose. In fact, I'm trying to sanitize HTML emails being viewed in a webmail application. Either give them a WYSIWYG DHTML editor with no 'alter source' option Just FYI, that doesn't work because even if you disable the ability to edit source directly, users can still paste in undesirable stuff. Not really relevant to my case, but don't be fooled into thinking you're safe by disabling the alter source option. , or have them use BBCode or similar instead and replace all and with an escaped version. Again, not relevant in this case. That is exactly what I do with CFMBB. Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262042 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: VPS - Rehashed....
Are there actually Windows VPS solutions out there? I highly recommend viviotech for Linux VPS hosting... comes with BlueDragon at no extra charge if you ask for it. You can do just about everything managing it through the CP+ control panel interface... from creating users to managing apache configuration and such. Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: DNS Problems...
You've not had to deal with high availability / redundancy before ? Actually, not on this level. I have always built websites for clients, some of whom were more concerned with uptime than others, but this is only the first business app that is used to run an office that I have hosted off-site. I've built business apps before, but always installed a server on-site. I've had very few problems with my web server, but I do walk a fine line running people's websites without a backup server. I run a RAID 1 (mirroring) setup which provides redundancy in case of hard drive failure. And I have other PC's around that I can convert fairly quickly to a server if I need to. All data and websites are backed up daily in case of catastrophy. I haven't had time (or rather, made time) to trying to setup a fail-over server. When I looked at it before, I would have had to purchase Windows 2000 Server Advanced to achieve that, and that was cost- prohibitive. I take one step at a time as a 1-man operation. There's only so many irons I can put into the fire at once. Rick -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 11:00 AM To: CF-Talk Subject: Re: OT: DNS Problems... On Wednesday 29 November 2006 12:01, Rick Faircloth wrote: If it's critical, consider two different hosts in different data centers, far apart as you can get... I may have to go that route... I haven't seen this problem before in 10 years of business... perplexing! You've not had to deal with high availability / redundancy before ? It's a big area to get into, what with risk/threat assessment etc. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: VPS - Rehashed....
I had a trial of Windows VPS via GoDaddy. Wouldn't normally touch them with a bargepole but someone recommended it. I couldn't get it working and gave up the same day. HostMySite do have some good looking plans there, but they aren't cheap. +1 for Viviotech though. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 29 November 2006 16:32 To: CF-Talk Subject: Re: VPS - Rehashed Are there actually Windows VPS solutions out there? I highly recommend viviotech for Linux VPS hosting... comes with BlueDragon at no extra charge if you ask for it. You can do just about everything managing it through the CP+ control panel interface... from creating users to managing apache configuration and such. Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262046 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: compiling apache connector on windows
I've tried to compile the apache mod_jrun20.so and mod_jrun22.so connectors from sources provided in the wsconfig.jar, but I can't seem to get it to work on a windows platform. I went and downloading Visual C++ Express, the platform SDK and got a version of apxs for windows, and tried to compile. After a bit of hacking I get the compilation to work, but the module wont' load up into apache. I've never tried to compile it, but last week I did try to use the updated wsconfig.jar Adobe provides for Apache 2.2, and after hours of installs/reinstalls/head scratching, I finally gave up and went with Apache 2.0. :( EMF idahopower.com made the following annotations. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT:robocopy gui
I just saw this article, and thought some people here may find it useful..I use robocopy a lot for deploying files, but the array of switches can be a bit daunting...this utility seems to make it much easier to create a script... http://www.microsoft.com/technet/technetmag/issues/2006/11/UtilitySpotlight/default.aspx ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Vista (was: CrystalTech outage?)
No, those aren't the same at all. It might have as many holes as a block of Swiss cheese, but if the user can't execute the virus because he lacks permissions to do so, the virus can't run. If the user can execute the virus, but lacks permissions to modify the operating system itself, the virus can't do those things either. Right. I understand that. I feel like we're running in circles here. I know that Microsoft is making most people a non-privileged user in Vista, and I like and agree with that decision. But, viruses can and probably will find ways around that limitation. You and Microsoft are assuming that all of their coding that prevents software from accessing sensitive files will ALWAYS work, and will NEVER have any holes in /itself/. Yes, I know that MS is doing a good thing here, but they are still human, and humans create software with holes. However, antivirus software can plug those holes while we wait for MS to put out a patch. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == EMF idahopower.com made the previous annotations. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Vista (was: CrystalTech outage?)
On Wednesday 29 November 2006 16:02, Dave Watts wrote: If by broken you mean makes things more difficult for the user, well, yes, I guess it's broken. I'm using Vista RC1. Can you explain what you mean by that? It's Just Another Box. Users will click it and type their usernames without reading it, because they are users. Or software will fake the box (trusted path not withstanding, this is Windows), get the password, and elevate itself. I'm with Jacob - it doesn't matter how flash and secure Vista is. It's software. It'll have problems. MS will fix them, once a month, or not. In the mean time the only thing that'll stop yet another Windows virus outbreak is having Anti-everything installed. -- Tom Chiverton Helping to dramatically generate network methodologies This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: UDF Inspection, #2
On Wednesday 29 November 2006 16:28, Rick Root wrote: I didn't see the start of the thread, so this may have been addressed - but why are you letting your users enter HTML ? That's not the sole purpose. In fact, I'm trying to sanitize HTML emails being viewed in a webmail application. Ahh. Most HTML emails contain a plain text part, as I'm sure you know, but a good start with HTML only emails might be: Repeat until no matches: For each (.*)(.*)/$1 replace with $2 For each (.*)/ except p/ replace with empty string For each br replace with \n For each p or p/ replace with \n\n For each (.*) replace with escape()$1escape() If you know non-CF langauges, look at a webmail app written (SquirrelMail springs to mind) in them and see what they do - this isn't the first or last time someone's had to do this :-) Just FYI, that doesn't work because even if you disable the ability to edit source directly, users can still paste in undesirable stuff. Not But the editor will escape it when it's inserted, so all the angle brackets 'vanish'. tinyMCE, for instance also supports doing all sorts of cleaver things when content is pasted. -- Tom Chiverton Helping to synergistically embrace robust schemas This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Weird CFC argument behavior.
I got a weird one.. CF7, Windows iis6. From a URL response from another separate process, I get a base64 url variable thats url encoded. In turn, I pass it directly through to my CFC as an argument. In most instances the process works great, but in some it has a really strange behavior.. If the base64 url variable contains a + sign somewhere in it, when passed through as an argument, the + is replaced what appears to be a space. If I try to replace the space with a + using replace(), the space still remains. A side note. UTF-8 is the character set that I am working with. Anyone with any idea's?? Probably something easy I am missing... Thanks, J ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFQUERY: comma delimited list of id values
ValueList would be the simplest means of doing what you need. cfquery name=myList SELECT id FROM tableName ORDER BY id /cfquery cfset idList = ValueList(queryName.column) !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 8:08 AM To: CF-Talk Subject: CFQUERY: comma delimited list of id values All, I'm trying to figure out how best to pass a list of comma delimited id (numeric) values to another query. I'm having trouble with getting the list of id values to not have a , (comma) after the last value in the output. Any help would be very appreciated. Should I be using a cfloop instead on the 2nd section below? !--- 1 - GET RECIPES FOR PRE SELECTED MONTH AND YEAR --- CFquery name=get_rec_4month datasource=#datasource# select * from dbo.tbl_recipe_monthly_winner where (month(recw_assign_month )= 01) AND (year(recw_assign_month )= 2006) /CFquery !--- 2 - OUTPUT VALUES IN QUERY TO GET COMMA DELIMITED LIST OF ID VALUES --- cfoutput query=get_rec_4month CFSET results = #get_rec_4month.recipeID#, /cfoutput !--- 3 - QUERY TABLES WHERE COMMA DELIMTED LIST IN IN WHERE CLAUSE --- cfquery name=sfc_all_recipes datasource=#recipes# SELECT *, dbo.recipeingredients.ingredients, dbo.addresses.firstname, dbo.addresses.lastname, dbo.recipes.recipeID, dbo.recipes.recipename, dbo.recipes.recipedesc, dbo.recipes.instructions, dbo.recipes.imageID FROM dbo.recipes INNER JOIN dbo.addresses ON dbo.recipes.addressID = dbo.addresses.addressID INNER JOIN dbo.recipeingredients ON dbo.recipes.recipeID = dbo.recipeingredients.recipeID WHERE dbo.recipes.recipeID IN #results# /cfquery Thanks. D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Crystal Tech or HostMySite? That's my problem!!!
That being said, my current site at HostMySite was very stable the first 6 months and now seems to go down a handful of times a day (based on my error reports and monitoring), which is probably due to some site on their that eats up CF resources but still really isn't acceptable. Bringing this up to HostMySite's support has not made much headway, and the initial improvement after the install of SeeFusion appears to have completely disappeared. I had a shared site on HMS for a few months, and from the beginning until I moved to a different host, I had daily error reports saying that CF couldn't connect to MySQL. HMS support tried to convince me the problem was that my code was sending too many requests to their shared MySQL server. I didn't like that answer, but chalked it up to using shared hosting. I have since moved to a VPS on Vivio, and have only received 3 error reports in the last few months. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == EMF idahopower.com made the previous annotations. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: VPS - Rehashed....
I highly recommend viviotech for Linux VPS hosting... comes with BlueDragon at no extra charge if you ask for it. I'd highly recommend it as well. Jordan might jump in and correct me, but I believe they no longer offer the free BD Server with VPS accounts. However, as long as you're doing non-commercial stuff, you can still get BD Server for free. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == EMF idahopower.com made the previous annotations. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Challenging Loop problem SOLVED
If you would like to display the colors in a circle:
div id=colorWheel
cfscript
for (deg = 0; deg LT listLen(colorList); deg = deg + 1)
{
xp = 250 + 200*cos(360/listLen(colorList))*deg)+270)*pi())/180);
yp = 250 + 200*sin(360/listLen(colorList))*deg)+270)*pi())/180);
writeOutput('div style=width: 20px; height: 20px; background-color:
##' ListGetAt(colorList,deg + 1) '; position: absolute; top: '
round(yp)-10 'px; left: ' round(xp)-10 'px;/div'
chr(13) chr(10));
}
/cfscript
/div
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-
| 1 | |
- Binary Soduko
| | |
-
C code. C code run. Run code run. Please!
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262054
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF and URL vars as folders?
On Wednesday 29 November 2006 15:34, Scott Weikert wrote: I was just thinking about this a few minutes ago - I don't know much about the Apache mod-rewrite method of doing this, but I'm wondering if part of that method involves Apache using a default script when none is specified. With CF, domain.com/x/y/ would make the server look for the index.cfm file if none is specified, yeah, but in the webroot/x/y folder - which wouldn't exist. Not if you've told Apache to step in before the request even gets to the CF server, and turn http://domain.com/x/y into http://domain.com/ses.cfm?x=y You can set up an ErrorDocument in Apache to catch non .cfm files that don't exist, and obviously the handler in the CF admin for .cfm files that aren't there. -- Tom Chiverton Helping to autoschediastically architect slick segments This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem with chr() and Linux?
Hi guys, i have the following simple code: cfsavecontent variable=sTmpMailContent À Á á ý ò ë Ç /cfsavecontent cfscript sTmpMailContent = Replace(sTmpMailContent,chr(192),'Agrave;','all'); sTmpMailContent = Replace(sTmpMailContent,chr(193),'Aacute;','all'); /cfscript cfoutput#sTmpMailContent#/cfoutput It works fine on Windows but can´t find the characters on Linux. What´s the problem? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: stored procedures and mysql
Richard,
Just to confirm background stuff ...
Is the following enabled:
In ColdFusion Administrator -- Data Sources -- {select data source in
question} -- Advanced Settings -- Allowed SQL -- Stored Procedures
I am running stored procs with no problem with MySQL 5.0.19 with ColdFusion
7.0.2 with mysql-connector-java-3.1.12.
This is the first that I have seen this thread. Sorry.
hth,
g
On 11/28/06, Richard White [EMAIL PROTECTED] wrote:
Hi i posted a problem a while ago as i couldnt get stored procedures
stored in mysql to work, it keeps coming up with a java.lang null pointer
error.
previous thread:
http://www.houseoffusion.comhttp://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:48365
/groups/CF-Talk/thread.cfmhttp://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:48365
/threadid:48365http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:48365
i was wondering if any using mysql and cfstoredproc could provide an
example or to see what i might be doing wrong as i cant work out whats
wrong.
I have granted full rights to my account as well so dont think its this
but dont know why it is coming up with the null pointer. If i run the stored
procedure from mysql it works fine so the stored procedure in the mysql
database is fine.
Thanks for any help, i would really appreciate it as i've been tearing my
hair out for weeks, and i didn't have that much to start with!
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262059
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Getting image files from another server
I was presuming he didn't want to just link to them, and wanted to get them via cffile or something :-) -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 29 November 2006 15:18 To: CF-Talk Subject: Re: Getting image files from another server Are Y and Z web servers? If so you would just need to supply their host names in the in html. On 11/29/06, Stephens, Larry V [EMAIL PROTECTED] wrote: This is as much an HTML question as CF, but...I'm building a CF app to display images. Let's call my webserver X with the images being on Y and Z and the database I need to use is on Z. X, Y and Z are all on the same network. I can set up a datasource across the network so I can pull data from Z but one piece of that data is the path to the image - which may be on Y or Z. But I can't access the images. I'm beginning to suspect I'll have to copy the images to the webserver to use them. Anyone knowledgeable about this? Larry V. Stephens Indiana University Office of Risk Management [EMAIL PROTECTED] 812-855-9758 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UDF Inspection, #2
Tom Chiverton wrote: On Wednesday 29 November 2006 16:28, Rick Root wrote: That's not the sole purpose. In fact, I'm trying to sanitize HTML emails being viewed in a webmail application. Ahh. Most HTML emails contain a plain text part, as I'm sure you know, but a good start with HTML only emails might be: Repeat until no matches: For each (.*)(.*)/$1 replace with $2 For each (.*)/ except p/ replace with empty string For each br replace with \n For each p or p/ replace with \n\n For each (.*) replace with escape()$1escape() my tagStripper() udf already does that quite nicely. But I'm not trying to eliminate HTML markup from HTML emails.. I'd prefer to actually show the HTML. That's why I said sanitize And by sanitize I mean removing unfriendly HTML tags like EMBED, OBJECT, APPLET, IFRAME, etc.. and removing javascript so that you can view an HTML email without being overly concerned about nasty javascript, activex controls, etc. If you know non-CF langauges, look at a webmail app written (SquirrelMail springs to mind) in them and see what they do - this isn't the first or last time someone's had to do this :-) As I move on, I will dig into SquirrelMail to see how they handle blocking images in HTML emails. Just FYI, that doesn't work because even if you disable the ability to edit source directly, users can still paste in undesirable stuff. Not But the editor will escape it when it's inserted, so all the angle brackets 'vanish'. Not always and not be default for sure. Both FCKeditor and TinyMCE allow you to paste in javascript: go here: http://www.opensourcecf.com/test.html Do a ctrl-A to select all and copy everything.. (not the source, just the HTML content of the page). Then go to the TinyMCE demo page: http://tinymce.moxiecode.com/example_full.php?example=true Paste what you copied in... and submit. the javascript is still there, and it works. You didn't have to edit any HTML source to do that. FCKeditor is the same way. Can you prevent people from pasting in javascript URLs and onmouseovers with TinyMCE? I don't know. I'd rather rely on the server to make sure nothing like that gets through. Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
virus software
Can anyone recomend a good virus software. Not sure if it make a difference but its for a server on win 2k, running mx 7. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: VPS - Rehashed....
Munson, Jacob wrote: I highly recommend viviotech for Linux VPS hosting... comes with BlueDragon at no extra charge if you ask for it. I'd highly recommend it as well. Jordan might jump in and correct me, but I believe they no longer offer the free BD Server with VPS accounts. However, as long as you're doing non-commercial stuff, you can still get BD Server for free. We could spawn a whole new discussion about what the bluedragon free version can and cannot be used for. =) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: virus software
Can anyone recomend a good virus software. Not sure if it make a difference but its for a server on win 2k, running mx 7. Nod32 from ESET. http://www.eset.com It is superb... Fast and efficient and just about the best (according to Virus Bulletin) AV software there is. Just don't use the IMON TCP/IP filter on the server as it will kill performance scanning the HTTP network traffic. Paul ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Challenging Loop problem SOLVED
Ha! Very nice.
..:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 29, 2006 11:51 AM
To: CF-Talk
Subject: RE: Challenging Loop problem SOLVED
If you would like to display the colors in a circle:
div id=colorWheel
cfscript
for (deg = 0; deg LT listLen(colorList); deg = deg + 1)
{
xp = 250 + 200*cos(360/listLen(colorList))*deg)+270)*pi())/180);
yp = 250 + 200*sin(360/listLen(colorList))*deg)+270)*pi())/180);
writeOutput('div style=width: 20px; height: 20px; background-color:
##' ListGetAt(colorList,deg + 1) '; position: absolute; top: '
round(yp)-10 'px; left: ' round(xp)-10 'px;/div'
chr(13) chr(10));
}
/cfscript
/div
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-
| 1 | |
- Binary Soduko
| | |
-
C code. C code run. Run code run. Please!
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262065
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: VPS - Rehashed....
Rick Root wrote: Munson, Jacob wrote: I highly recommend viviotech for Linux VPS hosting... comes with BlueDragon at no extra charge if you ask for it. I'd highly recommend it as well. Jordan might jump in and correct me, but I believe they no longer offer the free BD Server with VPS accounts. However, as long as you're doing non-commercial stuff, you can still get BD Server for free. We could spawn a whole new discussion about what the bluedragon free version can and cannot be used for. =) I also believe the version that viviotech used to provide at no extra cost with their VPS was not the free version of BD, but a full version of BlueDragon Server JX. And I also believe they are no longer offering that bundled...but it is available as an add-on. Oh yeah...+1 for viviotech. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFQuery - cfoutput - list of months and their year
All, I have a table that contains several items and most of these items are assigned a month and the current year using #CreateODBCDateTime(CreateDate(Year( Now() ), form.month_assigned, Day( Now() )))# in my insert or update sql statements. Some items will not be assigned a date. recw_assign_month: contains all the date values for each item. cfquery name=rsContestwinners datasource=#datasource# SELECT DISTINCT recw_assign_month FROM dbo.tbl_recipe_monthly_winner WHERE (recw_assign_month '') GROUP BY recw_assign_month ORDER BY YEAR(recw_assign_month), MONTH(recw_assign_month) /cfquery ERROR I get: ORDER BY items must appear in he select list if SELECT DISTINCT is SPECIFIED. QUESTION: How do I get this list to sort by year and then by month from newest to oldest date? I want to query all the items that have been assigned a data value and create a distinct list of the months and the year that have been assigned. Regardless of the number of items assigned to a particular month, the list would look ... October 2005 November 2005 December 2005 January 2006 February 200 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 ... etc. Thank you. D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFQuery - cfoutput - list of months and their year
if recw_assign_month is a date/time field - wouldn't sorting on this field straight up work fine? Seems like you're jumping through unnecessary hoops... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Jingle Bells
Ha! You think thats bad?? Try living in the snow belt of the great lakes (ie...upstate nyseasonal depression capital haha) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: virus software
AVG from Grisoft still does an ok job but Zonelabs anti virus seems to be out ranking it now. I know AVG has a free edition and I'm pretty sure the anti-virus from Zonelabs is free as well. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Richard Cooper [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 11:49 AM To: CF-Talk Subject: virus software Can anyone recomend a good virus software. Not sure if it make a difference but its for a server on win 2k, running mx 7. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Jingle Bells
Gabrielle Mack wrote: Ha! You think thats bad?? Try living in the snow belt of the great lakes (ie...upstate nyseasonal depression capital haha) If you're in or near Buffalo, isn't every season depressing? =) I assume that's why people keep moving away, cuz it sucks. good hockey team though. Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Challenging Loop problem.
Then I missed that condition. If the premise is the absence of triple multiplicities, then you will hav items^slots - itemslots, thus 3^3 - the permutations were one item has all three items slots sets. 3^3 - 3 and thus 24. This changes quickly if you have more items than slots and have to determine which multiplicities you want to exclude. Teddy On 11/29/06, Ian Skinner [EMAIL PROTECTED] wrote: It is just a permutation set of all possible combinations of three items that allow repeats. But it was NOT a set of all possible combinations. For example 000, 888 and FFF were not desired results for my problem. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
