Re: Handling invalid recipient in mailing list
Have any of you tried Amazon SES for email? I paid to clean my list and then started using them. I can send out 20,000 emails for $2. Its so much cheaper. I do use a software program called Sendy in conjunction with Amazon which cost $50 (one time). Just thought Id mention it, but its about 2% of the cost to send emails. Kelly On Apr 3, 2015, at 10:29 AM, Rob Voyle robvo...@voyle.com wrote: Hi Folks Robert details all the steps to keeping an email list clean and valid. Having done that in the past and for a list of 5000 addresses I would say it is a far better deal to go with one of the email newsletter companies. Having tried several I can highly recommend mailchimp http://mailchimp.com/ They offer several benefits. 1. They clean the bounced email and keep the list valid. (no programing to write and validate) 2. They have deals with ISPs to recognize their bulk email as legit. When I was doing that privately it was a headache to stay on top of all the ISP's spam protections and have my server continually validated. (And if you are on a shared server forget it as you will be vulnerable to all the other user's bad practices and reputation) 3. The time saving was well worth the $s 4. If you do decide to use a provider check their rules about establishing your list. (some such as icontact will require you to do a new optin on your already established list, and then they will block anyone who does not re-optin. Those address could then never be resubsbcribed even by their owner.) Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry Author: Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment http://www.appreciativeway.com/ 503-647-2378 or 503-647-2382 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360366 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is time for a change?
Agreed! Vivio rocks! I have had no problems with them for years and years. Very awesome support as well. On Nov 7, 2014, at 2:20 PM, Matt Quackenbush quackfu...@gmail.com wrote: I only have one response when people are looking for CFML hosting. Use Vivio! https://www.viviotech.net/ I was once told, If you have nothing good to say, say nothing at all. As such, I'll refrain from commenting on any other CFML host. :-) On Fri, Nov 7, 2014 at 1:15 PM, Rick Eidson cfh...@kchost.net wrote: Anyone using Hostek? I have been with them for. well a long time. But in the last year it seems there have been more problems than ever. I really hate the idea of moving all my clients but I am wondering if in the long run will I be better off. Any thoughts? Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359568 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Very disappointed in Viviotech
Yeah they are really great guys! And $10 for a full month of manage support is a STEAL. :) Ive used it on a month by month basis a couple times when Ive needed to. On Apr 1, 2014, at 10:02 AM, Cameron Childress camer...@gmail.com wrote: On Mon, Mar 31, 2014 at 11:46 PM, Mike K wrote: We got me set up for managed support and in the mean time he had researched the answer to my problem, and we went on from there. Also, Jordan Michaels the co-owner of Viviotech wanted to talk to me too.I thought he was going to give me a lecture about patience (he'd have been justified ) but no, he was ready to listen and understood my issue entirely. I'm glad you got things worked out. I've had to call VivioTech support a few times myself and they always answer the phone quickly and are helpful. The managed support is worth it when you are trying to troubleshoot a problem and for the handful of my customers who are hosted there, I always suggest that they get the managed plan. They have even helped me once or twice with I didn't have a managed plan, but I asked super nice knowing they didn't have to help me. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Viviotech?
I think they had some issues. Several of my sites went down, also I think their support number is tied to their network so if the network goes down so do their phones. If that's still the case, I really wish that's something they would fix, it's my only gripe. :) However, my sites seem to be back up now. On 28 Jan 2014, at 14:08, Money Pit wrote: Anyone hear anything from them? They've been completely off the air for about an hour. Fast busy signal on the phone. Was originally just 'busy' so I'm wondering if someone got thru to them before the phone went down. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357507 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Viviotech?
Cool thanks for the clarification Jordan I wasn't sure about the phones! :) On 28 Jan 2014, at 17:53, Jordan Michaels wrote: I think they had some issues. Several of my sites went down, also I think their support number is tied to their network so if the network goes down so do their phones This used to be true but thankfully it's no longer the case. Vivio's VOIP system now has backup POTS lines that are used if the VOIP trunk ever becomes inaccessible. If the POTS lines are all busy, you get a busy signal - which is what happened today. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Hosting... Again
I 2nd viviotech. I have had my own web development business since 2006. I host all my clients websites. Viviotech has been amazing! Their support is incredible and their prices are great! Kelly On 13 Jan 2014, at 10:01, DURETTE, STEVEN J wrote: Hostmedia.co.uk - Never had a problem with them and they are always responsive. Their prices are great and they have servers all over the place so it can probably be hosted in the same country you are located in. Steve -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Friday, January 10, 2014 8:22 AM To: cf-talk Subject: Hosting... Again Hi All, I've got a lot of large CF sites I have to move because my host is not up to what we've grown to be. Love the guy and been with him for years, but now I have to go. I've asked this before (in October), but now that I'm no longer in denial I'm looking for CF hosting recommendations again. I have the previous recommendations which I'm listing below. If anyone has comments about any of the hosts below, or better recommendations, please provide your feedback. I'm about to move a boatload of serous sites. So far, I've gotten recommendations for: Hostek Viviotech CrystalTech http://www.kickassvps.com/ Please let me know if you have additional recommendations or feedback on these hosts. Thanks, Robert ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357398 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Hosting
I have used viviotech for years and never have any issues. They are very responsive. http://www.viviotech.net On Oct 21, 2013, at 9:04 AM, Robert Harrison wrote: I know this has been asked 100 times before, but it looks like I need a new cf hosts that can host enterprise level sites. Any recommendations? I've have gone to the archives but the HOF site is down. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356952 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need help finding new CF Hosting
I second that. Viviotech is awesome! On Dec 18, 2012, at 10:52 AM, Matt Quackenbush wrote: I would highly recommend a VPS with Viviotech. They also have shared plans, although I'm not certain what is allowed/disallowed under those plans. On Tue, Dec 18, 2012 at 9:32 AM, Dave Long d...@northgoods.com wrote: I'm trying to find a CF Hosting provider with 24/7 support and allows code such as CFILE plus access to the CF Administrator so I can add ODBC sources timely. Any suggestions? Dave Long NorthGoods Merchant Services ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353523 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: hostek - server down?
Yep I have 2 sites down as well. On May 31, 2012, at 8:41 PM, Mike Little wrote: hey guys, anyone else experiencing outage with sites at hostek. they are not replying to any support emails, and cannot get through on phone. mike ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351396 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: hostek - server down?
Odd that they say it's a switch. My site's HTML pages come up fine, the Coldfusion pages are dead. Yet a switch is down? On May 31, 2012, at 8:53 PM, Mike Little wrote: thanks guys! FYI: from the Hostek status page at http://hostek.com/serverstatus.asp Server Update: Servers experiencing issues http://hostek.com/serverstatus.asp?id=238Thursday, May 31, 2012 7:37:26 PM CST We are experiencing some issues with one of our network switches. We are working on getting this resolved. Thank you for you patience. -Update- The failed equipment has been replaced and we are in the process of bringing up remaining services at this time. On a more technical note, we have redundant network switches in place that did not automatically fail over as expected. We will be taking this up with our hardware vendor. On 5/31/12 5:41 PM, Mike Little m...@nzsolutions.co.nz wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351397 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Very disappointing statis
Yep several sites I rebuilt I use HTML files to process CF as well so they wouldn't lose their search engine positions etc. Kelly Matthews Sr. Web Developer CF Webtools www.cfwebtools.com On Dec 14, 2011, at 12:18 PM, Wil Genovese wrote: Plus, many sites don't even have a way to show that ColdFusion (or any other language) is being used. Politico for example is a HUGE ColdFusion powered site that generates dynamic content with CF and builds HTML files. The United Nations websites does the same with ColdFusion. There are a ton of Government sites using ColdFusion - Does Alexa even rank Government sites? Google this filetype:cfm But this still only finds actual .cfm files and not any site that uses SES URL's. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Dec 14, 2011, at 10:39 AM, Justin Scott wrote: Very disappointing statistics for ColdFusion market penetration. http://w3techs.com/technologies/overview/programming_language/all I'm actually surprised it's as high as it is given their methodology. They claim to look at the top one million (or thereabouts) websites as ranked by Alexa. These are going to be popular, public, relatively high-traffic sites which is not ColdFusion's bread and butter. ColdFusion has a huge market behind the firewall in corporate and government intranets and other places that these kinds of surveys can't report on. PHP will usually dominate these kinds of surveys because of popular open source tools that can be deployed by less technical users, such as forums, content management systems, and blogging tools such as WordPress. Contrary to reports like this, ColdFusion is alive and well in the enterprise. It's less popular for public websites than other languages, but that doesn't concern me in the least. -Justin Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349112 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfdocument and page-break-inside: avoid
The following will work.
create the following style:
.PB { page-break-after: always; margin-top : 1px; margin-bottom : 1px; }
Then anywhere you want the page to break put a paragraph tag w/ a class of PB.
On Nov 27, 2011, at 3:22 PM, Justin Scott wrote:
I'm curious if anyone has found a way to prevent content blocks
converted to PDF with cfdocument from breaking across pages (e.g. a
div with content that could be a couple of lines or 30 lines, but I'd
like to keep it all together on the same page). I've tried applying
the page-break-inside: avoid CSS element but it appears to have no
effect. Research on the topic has not wielded anything practical.
Some suggest encapsulating the content with cfsavecontent and then
counting line breaks to estimate the element height and further, keep
track of how much has been output since the beginning or last page
break to determine if a manual page break should be inserted. I'd
like to find a more elegant solution using existing CSS elements if
possible. Any thoughts from PDF-generating ninjas out there?
-Justin
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348886
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfdocument and page-break-inside: avoid
Some awesome company named CFWebTools! Run by this guy named Mark Kruger! LOL
I'm on vacation, cut me some slack!! :)
On Nov 27, 2011, at 4:06 PM, Mark A. Kruger wrote:
Nice... who do you work for again? :D
-Original Message-
From: Kelly Matthews [mailto:webd...@gmail.com]
Sent: Sunday, November 27, 2011 2:52 PM
To: cf-talk
Subject: Re: cfdocument and page-break-inside: avoid
The following will work.
create the following style:
.PB { page-break-after: always; margin-top : 1px; margin-bottom : 1px; }
Then anywhere you want the page to break put a paragraph tag w/ a class of
PB.
On Nov 27, 2011, at 3:22 PM, Justin Scott wrote:
I'm curious if anyone has found a way to prevent content blocks
converted to PDF with cfdocument from breaking across pages (e.g. a
div with content that could be a couple of lines or 30 lines, but I'd
like to keep it all together on the same page). I've tried applying
the page-break-inside: avoid CSS element but it appears to have no
effect. Research on the topic has not wielded anything practical.
Some suggest encapsulating the content with cfsavecontent and then
counting line breaks to estimate the element height and further, keep
track of how much has been output since the beginning or last page
break to determine if a manual page break should be inserted. I'd
like to find a more elegant solution using existing CSS elements if
possible. Any thoughts from PDF-generating ninjas out there?
-Justin
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:34
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Form Validation Issue using cfinput AND jquery
Sorry if this ends up being a dupe post. I'm working on a client site that already had a CF Form in place using cfinput and validation via required=yes We added some select boxes that are required and as most of you know CF forms don't really validate those. So, I am using jquery to validate the select boxes when the form is submitted. The problem I am running into is this: The jquery portion works AND the CF validation errors are thrown as well. But if I fill in all the selects that are validated via jquery and do not to fill in the fields that are being required via cfinput required=yes, the error is thrown but the form still submits. Is this because of the jquery on submit validation? Has anyone run into this before, is there an easy fix, outside of moving the cfinput validation into the jquery validation? Kelly Matthews Web Developer http://www.cfwebtools.com blog: http://kellymatthews.wordpress.com Twitter: @webdiva ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341787 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Hosting
Not dreaming you can get that at Hostek but you will get what you pay for, their servers seem to get a bit bogged down at times. Can anyone recommend a decent yet cheap web host for ColdFusion? Right now I'm hosting my site at DreamHost (Simple wordpress as CMS site). I'm looking for SQL PHP 5 and Coldfusion 8 support all under $6. Am I dreaming? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341657 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How would I do this in SQL?
Ok so I haven't really written any code in tSQL yet that does major looping like I'm doing in CF. Figured I'd post this here and see if anyone had some input on how to convert this into tSQL so it could be run w/ in a DTS package. Basically we have products, top-level categories, sub-categories, sub-sub-categories, etc. The purpose of this script is to find any sub, or sub sub etc. categories that have no products, and mark that sub-category as having no products. The script works great but I'd love to pull it out of CF. Anyone care to take a stab or lead me in the right direction. IN the meantime I shall google some SQL looping examples and see what I find. cfquery datasource=#application.ds# name=getcats select distinct a.category, a.parent_id from products b inner join cfx_prod_custCat x on b.id = x.prod_id inner join categories a on a.category = x.custcat_id where a.main_id is not null UNION select distinct a.category, a.parent_id from categories a inner join products2 b on a.category = b.category Where a.main_id is not null and b.deleted = 0 /cfquery cfloop query=getcats cfquery datasource=#application.ds# name=update update categories set hasproducts = cfqueryparam value=1 cfsqltype=CF_SQL_INTEGER / where category = cfqueryparam value=#getcats.category# cfsqltype=CF_SQL_INTEGER / cfif getcats.parent_id neq 0 OR category = cfqueryparam value=#getcats.parent_id# cfsqltype=CF_SQL_INTEGER / /cfif /cfquery cfif getcats.parent_id neq 0 cfquery datasource=#application.ds# name=getparent select parent_id from categories where category = cfqueryparam value=#getcats.parent_id# cfsqltype=CF_SQL_INTEGER / /cfquery cfif getparent.parent_id neq 0 cfquery datasource=#application.ds# name=update update categories set hasproducts = cfqueryparam value=1 cfsqltype=CF_SQL_INTEGER / where category = cfqueryparam value=#getparent.parent_id# cfsqltype=CF_SQL_INTEGER / /cfquery cfquery datasource=#application.ds# name=getparent2 select parent_id from categories where category = cfqueryparam value=#getparent.parent_id# cfsqltype=CF_SQL_INTEGER / /cfquery cfif getparent2.parent_id neq 0 cfquery datasource=#application.ds# name=update update categories set hasproducts = cfqueryparam value=1 cfsqltype=CF_SQL_INTEGER / where category = cfqueryparam value=#getparent2.parent_id# cfsqltype=CF_SQL_INTEGER / /cfquery cfquery datasource=#application.ds# name=getparent3 select parent_id from categories where category = cfqueryparam value=#getparent2.parent_id# cfsqltype=CF_SQL_INTEGER / /cfquery cfif getparent3.parent_id neq 0 cfquery datasource=#application.ds# name=update update categories set hasproducts = cfqueryparam value=1 cfsqltype=CF_SQL_INTEGER / where category = cfqueryparam value=#getparent3.parent_id# cfsqltype=CF_SQL_INTEGER / /cfquery cfquery datasource=#application.ds# name=getparent4 select parent_id from categories where category = cfqueryparam value=#getparent3.parent_id# cfsqltype=CF_SQL_INTEGER / /cfquery cfif getparent4.parent_id neq 0 cfquery datasource=#application.ds# name=update
Re: How would I do this in SQL?
Ditto on the repost, not sure if my first reply posted... Actually it's much more than that. There are a ton of categories that won't have products, however, if they are a parent of a sub category that has a product, they ultimately have products as well. This is why it requires nested queries about 5 levels deep in coldfusion. Did you happen to scroll down enough to see the plethora of CFIF statements and nested queries? I wish it were that simple. :) Sorry if this is a repost. I am not sure it posted the first time. I do not think any looping is required. You should be able to do this using sub queries within the where clause. If you are using cfx_prod_custCat as a lookup table simply look for any category that is not listed in the custcat_id field: UPDATE Categories SET hasproducts = 0 WHERE category IN (SELECT DISTINCT category FROM Categories WHERE ID NOT IN (SELECT DISTINCT custcat_id FROM cfx_prod_custCat)) You use the same logic for the 2nd part of the UNION clause: UPDATE Categories SET hasproducts = 0 WHERE category IN (SELECT DISTINCT category FROM Categories WHERE category NOT IN (SELECT DISTINCT category FROM products)) Basically you use the sub query to pull a list of all products that have a category assigned and the look for categories that are not in that list. Hopefully I am not way off on this and it helps point you in the right direction. Brian Cain ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341567 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How would I do this in SQL?
It can go up to 5 levels deep, no more than that. Re: the UDF, that's a good idea, I'll take a look at the link, thanks! Sorry that I answer didn't take inheritance into account. Is there a maximum number of levels of subcategories, or will it always be an unknown? I have done looping with tSQL in the past using cursors, and it really is a pain. You could use a UDF (User Defined Function) and return a table variable. Here is a link for an example of returning a table variable: http://sqlt.tripod.com/recursivity.htm You could probably modify this example to return a bit value if the category or any parent has a product assigned. In theory if you write the function correctly you could write a single update statement that sets the hasproducts column equal to the funtion value passing in the category as a parameter. Something like UPDATE categories set hasprodutcs = fnHasProduct(category) where fnHasProduct id the name of your UDF and accepts the category as a parameter. The real work would be in writing your UDF. You would want you to thoroughly test your UDF, but it could provide you with a powerful and simple execution that even incorporates a little OOP using tSQL. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341571 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Custom Tags, cf_location
um... then why not use: cflocation addtoken=no / addtoken=no doesn't add the unnecessary cftoken Because the website that I'm working with has thousands of cflocation's. My entire reason for using cf_location was so that I wouldn't have the annoying, and highly unneccessary cftoken in my urls. It's much easier to just simply use a custom tag that defaults to no than to Find and Replace every single tag with addToken=no. I'm also trying to use customtags as somewhat of a learning experience since I've not dealt with them much. I don't really consider myself to be a novice with CF, but I'm also not an expert. I have a different customtag that works perfectly fine, but the cf_location does not. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341193 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Custom Tags, cf_location
My thoughts exactly. Figured maybe I was missing something. lol Yet he planned to replace all cflocation with cf_location, didn't he? Regards, Andrew Scott http://www.andyscott.id.au/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Custom Tags, cf_location
Good God! Having flashbacks from high school with this thread! LOL Your not just getting it and I don't think you every will. You come off as sounding like a jerk plain and simple, so who cares if your right. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341228 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Custom Tags, cf_location
Seriously Michael I don't know you, but I think you've blown this whole thing out of proportion. Why not take the high road and just give it a rest? I suffer from Last word syndrome at times, maybe that's what we're dealing with here. We shall see. :) Wow. Sounds like the expert is taking it personally. Good to know you like to resort to personal attacks like this. Real class On Jan 25, 2011 8:24 PM, Russ Michaels r...@michaels.me.uk wrote: www.cfmldeveloper.com might ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341248 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: favorite coldfusion host
Hostek I wasn't happy with lotsa down time. Crystaltech not too happy with and a bit pricey. I've heard good things about Edge Web as well. I ended up getting a VPS linux server at Viviotech, running CF 9 enterprise for under $100 a month. I couldn't be happier. And their support is 2nd to none! Love these guys! Kelly On Tue, Jan 25, 2011 at 6:05 PM, Michael Firth mfsqlser...@gmail.com wrote: Curious to see what everybody's favorite coldfusion host is also? Hostek? CrystalTech? DailyRazor? Personally I'm a huge fan of Edge Web Hosting - they really know their stuff. I've also heard a lot of good things about Vivio Tech and their team are awesome (I deal with them quite a bit). -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atw ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341314 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: why is cf_builder so expensive?
I'd agree. I mean if my employer is willing to pay for my copy once my trial runs out I'll be happy to use it *hint hint*. :) I still use Homesite for the most part. :) I use it at home and at work. For me it is a nice-to-have but probably not worth $300. I know a few developers who tried it and went back to CFEclipse. The only reason I like it is for some of the RDS and ORM functionality. I wouldn't miss it if it was gone. On Tue, Jan 25, 2011 at 8:48 PM, Michael Firth mfsqlser...@gmail.comwrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341315 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Server Setup Opinions
Windows or Linux? What type of DB? MS SQL? mySQL? I host approx. 5-6 dozen (small traffic) database driven CF sites on multiple servers and I am in the market for new server hardware. Since I last purchased hardware, the capabilities of server hardware has increased dramatically. That said, for those of you whose company hosts CF web sites, do you: A: Have a separate database server and a separate web server for 'X' number of sites? B: Have one server that is the combined database/web server for only 'X' number of sites? C: Have one 'mega' server that is the combined database/web server for all of your sites? D: Some other combo. Please explain. I guess I'm wondering if it is still frowned upon to combine the database and the web server on the same machine? Any responses would be appreciated. Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Server Setup Opinions
Windows or Linux? What type of DB? MS SQL? mySQL? I host approx. 5-6 dozen (small traffic) database driven CF sites on multiple servers and I am in the market for new server hardware. Since I last purchased hardware, the capabilities of server hardware has increased dramatically. That said, for those of you whose company hosts CF web sites, do you: A: Have a separate database server and a separate web server for 'X' number of sites? B: Have one server that is the combined database/web server for only 'X' number of sites? C: Have one 'mega' server that is the combined database/web server for all of your sites? D: Some other combo. Please explain. I guess I'm wondering if it is still frowned upon to combine the database and the web server on the same machine? Any responses would be appreciated. Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Server Setup Opinions
Windows or Linux? What type of DB? MS SQL? mySQL? I host approx. 5-6 dozen (small traffic) database driven CF sites on multiple servers and I am in the market for new server hardware. Since I last purchased hardware, the capabilities of server hardware has increased dramatically. That said, for those of you whose company hosts CF web sites, do you: A: Have a separate database server and a separate web server for 'X' number of sites? B: Have one server that is the combined database/web server for only 'X' number of sites? C: Have one 'mega' server that is the combined database/web server for all of your sites? D: Some other combo. Please explain. I guess I'm wondering if it is still frowned upon to combine the database and the web server on the same machine? Any responses would be appreciated. Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Server Setup Opinions
Oops sorry for the dupe. Windows or Linux? What type of DB? MS SQL? mySQL? www.asitv.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340856 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Server Setup Opinions
I'd go with option A. The one time I had SQL and CF on the same box it caused issues and was not efficient. No problem. Were a Windows shop. So it will be Microsoft 2008 R2 for the OS and the DB. Oops sorry for the dupe. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: US Government moving to Drupal?
We started using CF while I was working at HUD in 1997. On 1/12/2011 8:53 PM, Sean Corfield wrote: The government has always been a pretty strong area for ColdFusion (does someone here know how long ColdFusion has been so deeply embedded in government? I get the impression it long predates my exposure to ColdFusion - 2001). ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340721 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFFM and TinyMCE?
Hey John!
Thanks! Worked like a charm!!! :)
Kelly
Relevant JS looks like this:
function cffmCallback(field_name, url, type, win) {
// Do custom browser logic
url =
'#base#cffm.
cfm?imaged
ir=#URLEncodedFormat(imagedir)#editorType=mceEDITOR_RESOURCE_TYPE='
+ type;
x = 700; // width of window
y = 500; // height of window
win2 = win; // don't ask, it works. win2 ends up being global to the
page, while win is only accessible to the function.
cffmWindow =
window.open(url,,width=+x+,height=+y+,left=20,top=20,
bgcolor=white,resizable,scrollbars,menubar=0);
if ( cffmWindow != null ) {
// bring the window to the front
cffmWindow.focus();
}
}
tinyMCE.init({
[snip]
file_browser_callback : cffmCallback,
[snip]
});
On Thu, Sep 23, 2010 at 7:12 AM, Kym Kovan dev-li...@mbcomms.net.au
wrote:
On 23/09/2010 9:52 PM, Rick Root wrote:
Anyone using a recent version of CFFM with TinyMCE 3?
Before I spend my time figuring out how to do it, thought I'd ask
to
see if anyone had already spent that time and might be willing to
donate the knowledge to the project =)
yes, it was not too hard.
I haven't tried the latest cffm version yet but the previous two
versions went fine except for the issue with paths and the
uploadifyer
thingy in the last version.
I don't have the code in front of me and its late evening here,
I'll
send it directly in the morning...
--
Yours,
Kym Kovan
mbcomms.net.au
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337401
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF 9 Hosting
Anyone know any good, reasonable CF 9 hosting companies w/ mysql. Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333833 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 Hosting
Thanks. Although I use them now, they go down 2-3 times a day. Far too much for my client, they want to move. I've been using hostek for awhile and really like it. http://hostek.com/ One of the best features I think is that you can run cf9 applications, asp.net applications and php applications all from 1 hosting package which is awesome since I develop in all of those languages. Also they're CF package is only $5/month which is awesome. One down side I think is the hosting control panel isn't all that great, but it works well and does that I want. Regards, Paul Alkema http://paulalkema.com/ http://www.viviotech.net/ mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 20 May 2010 06:10, Kelly Matthews ke...@webdiva.org wrote: Anyone know any good, reasonable CF 9 hosting companies w/ mysql. Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333843 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 Hosting
Actually while hostek's prices are great, the fact that they go down 2-3 times PER day is far too much for my client, which is why I'm looking to move. Should have mentioned anyone but hostek. I've been using hostek for awhile and really like it. http://hostek.com/ One of the best features I think is that you can run cf9 applications, asp.net applications and php applications all from 1 hosting package which is awesome since I develop in all of those languages. Also they're CF package is only $5/month which is awesome. One down side I think is the hosting control panel isn't all that great, but it works well and does that I want. Regards, Paul Alkema http://paulalkema.com/ http://www.viviotech.net/ mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 20 May 2010 06:10, Kelly Matthews ke...@webdiva.org wrote: Anyone know any good, reasonable CF 9 hosting companies w/ mysql. Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF programmer with experience building Social networking sites
Or some people like myself, get the digest therefore you can't reply to the individual person. FYI :) Ahhh... I see. Sounds like MD should/could unmask emails for the CF-Jobs list... -Cameron Cameron, Some people read these in the forum through their browser, and there, if you 'reply', you are replying to the 'post' and your reply will go to the list, not the original sender. Some also read in digest mode, so it is definitely a requirement to post your contact e-mail if you want EVERYONE to be able to respond. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3940 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Turn this into 1 query?
I have 2 queries wondering if I can accomplish this in 1. Query 1: CREATE PROCEDURE [dbo].[fa_addonqueue_inout] @date2 datetime=null, @today datetime=null AS SELECT DISTINCTb.id, b.qnum, b.firstname, b.lastname, b.ssn, c.phase, c.disbursed_date FROMfaLoans a INNER JOIN abIdentity b ON a.IdentityID = b.ID INNER JOIN Import_Cap_Status c ON b.SSN = c.SSN WHERE (c.Branch = 0001) AND (c.phase=1) AND (c.Disbursed_date between @date2 and@today) order by c.disbursed_date DESC GO Query 2: SELECT ssn FROMImport_Cap_Status WHERE (Branch = 0001) AND (phase=2) AND (ssn IN (#ValueList(addonqueue.ssn)#)) Basically w/ query 2 I am taking the results of query 1 and going back through them and pulling any records that have phase 2 as well (that means the person would have 2 records a phase 1 phase 2), these are then going to be eliminated from what we display on the page.Any suggestions on combining this query? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Turn this into 1 query?
I have 2 queries wondering if I can accomplish this in 1. Query 1: CREATE PROCEDURE [dbo].[fa_addonqueue_inout] @date2 datetime=null, @today datetime=null AS SELECT DISTINCTb.id, b.qnum, b.firstname, b.lastname, b.ssn, c.phase, c.disbursed_date FROMfaLoans a INNER JOIN abIdentity b ON a.IdentityID = b.ID INNER JOIN Import_Cap_Status c ON b.SSN = c.SSN WHERE (c.Branch = 0001) AND (c.phase=1) AND (c.Disbursed_date between @date2 and@today) order by c.disbursed_date DESC GO Query 2: SELECT ssn FROMImport_Cap_Status WHERE (Branch = 0001) AND (phase=2) AND (ssn IN (#ValueList(addonqueue.ssn)#)) Basically w/ query 2 I am taking the results of query 1 and going back through them and pulling any records that have phase 2 as well (that means the person would have 2 records a phase 1 phase 2), these are then going to be eliminated from what we display on the page.Any suggestions on combining this query? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
2 Queries into one?
I have 2 queries wondering if I can accomplish this in 1. Query 1: CREATE PROCEDURE [dbo].[fa_addonqueue_inout] @date2 datetime=null, @today datetime=null AS SELECT DISTINCTb.id, b.qnum, b.firstname, b.lastname, b.ssn, c.phase, c.disbursed_date FROMfaLoans a INNER JOIN abIdentity b ON a.IdentityID = b.ID INNER JOIN Import_Cap_Status c ON b.SSN = c.SSN WHERE (c.Branch = 0001) AND (c.phase=1) AND (c.Disbursed_date between @date2 and@today) order by c.disbursed_date DESC GO Query 2: SELECT ssn FROMImport_Cap_Status WHERE (Branch = 0001) AND (phase=2) AND (ssn IN (#ValueList(addonqueue.ssn)#)) Basically w/ query 2 I am taking the results of query 1 and going back through them and pulling any records that have phase 2 as well (that means the person would have 2 records a phase 1 phase 2), these are then going to be eliminated from what we display on the page.Any suggestions on combining this query? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Help with Date Stuff
Ok I have a weekly report I have to run.Basically it's run every Sunday and brings back info for the previous week. If it's, as an example, the 3rd sunday of hte month it will bring back info for the last 3 weeks of the month (basically going back to the first). I have the report running fine however he wants me to have the display broken out to say Week 1, Week 2, Week 3, within the report and I cant figure out how to do that. Here is the code and where you see !--WEEK 1 HERE-- is where that would need to display. CFPARAM name=enddate default=08/17/04 CFPARAM name=startdate default=#dateformat(Createdate(year,month,1),'mm/dd/yy')# CFPARAM name=type default=1 CFPARAM name=displaydate default= CFMAIL type=HTML to= server= from= subject=Report for #startdate# - #enddate# font face=arial size=2 CFLOOP from=#type# to=3 step=1 index=count table cellpadding=5 cellspacing=0 border bordercolor=silver width=600 CFQUERY datasource=emailertemp name=test exec sp_emailreports '#startdate#','#enddate#','OSI',#count# /CFQUERY tr td colspan=5OSI CFIF type EQ 1Single StepCFELSEIF type eq 2Two Step Phase 1CFELSEIF type eq 3Two Step Phase 2/CFIF/td tr tdfont size=2Name/font/td tdfont size=2ID/font/td tdfont size=2Status/font/td tdfont size=2Type/font/td tdfont size=2Date/font/td /tr trtd colspan=5 !---Week 1 here (or week 2 or week 3 etc based on the date. Obviously since it's outside the query loop its not working right if i put it in the query loop it gets repeate etc.--- /td/tr CFIF Isdefined(test.recordcount) CFLOOP query=test CFIF count EQ 1 CFSET displaydate = #dateformat(test.ssd, 'mm/dd/yy')# CFELSEIF count eq 2 CFSET displaydate = #dateformat(test.ts1d, 'mm/dd/yy')# CFELSE CFSET displaydate = #dateformat(test.ts2d, 'mm/dd/yy')# /CFIF tr tdfont size=2#firstname# #lastname#/font/td tdfont size=2#ID#/font/td tdfont size=2#status#/font/td tdfont size=2#description#/font/td tdfont size=2#displaydate#/font/td /tr /CFLOOP /CFIF CFSET type=type+1 /table P/P /CFLOOP /CFMAIL ANy suggestions on how to do get it to group by Week 1, week 2 week 3? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Help with Date Stuff
correct but the WEEK function brings back the week number for the YEAR not the MONTH. The key is to figure out for each date what the week number is. Once you can do that reliably it'll be easy. I take it that each weeks starts on a Sunday, so that for September 2004 we're in week 2, and week 3 starts this coming Sunday, right? _ From: Kelly Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 9:23 a.m. To: CF-Talk Subject: Help with Date Stuff Ok I have a weekly report I have to run.Basically it's run every Sunday and brings back info for the previous week. If it's, as an example, the 3rd sunday of hte month it will bring back info for the last 3 weeks of the month (basically going back to the first). I have the report running fine however he wants me to have the display broken out to say Week 1, Week 2, Week 3, within the report and I cant figure out how to do that. Here is the code and where you see !--WEEK 1 HERE-- is where that would need to display. CFPARAM name=enddate default=08/17/04 CFPARAM name=startdate default=#dateformat(Createdate(year,month,1),'mm/dd/yy')# CFPARAM name=type default=1 CFPARAM name=displaydate default= CFMAIL type=HTML to= server= from= subject=Report for #startdate# - #enddate# font face=arial size=2 CFLOOP from=#type# to=3 step=1 index=count table cellpadding=5 cellspacing=0 border bordercolor=silver width=600 CFQUERY datasource=emailertemp name=test exec sp_emailreports '#startdate#','#enddate#','OSI',#count# /CFQUERY tr td colspan=5OSI CFIF type EQ 1Single StepCFELSEIF type eq 2Two Step Phase 1CFELSEIF type eq 3Two Step Phase 2/CFIF/td tr tdfont size=2Name/font/td tdfont size=2ID/font/td tdfont size=2Status/font/td tdfont size=2Type/font/td tdfont size=2Date/font/td /tr trtd colspan=5 !---Week 1 here (or week 2 or week 3 etc based on the date. Obviously since it's outside the query loop its not working right if i put it in the query loop it gets repeate etc.--- /td/tr CFIF Isdefined(test.recordcount) CFLOOP query=test CFIF count EQ 1 CFSET displaydate = #dateformat(test.ssd, 'mm/dd/yy')# CFELSEIF count eq 2 CFSET displaydate = #dateformat(test.ts1d, 'mm/dd/yy')# CFELSE CFSET displaydate = #dateformat(test.ts2d, 'mm/dd/yy')# /CFIF tr tdfont size=2#firstname# #lastname#/font/td tdfont size=2#ID#/font/td tdfont size=2#status#/font/td tdfont size=2#description#/font/td tdfont size=2#displaydate#/font/td /tr /CFLOOP /CFIF CFSET type=type+1 /table P/P /CFLOOP /CFMAIL ANy suggestions on how to do get it to group by Week 1, week 2 week 3? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF Outlook
I have a cf application where people can register for events. When they register a vcs file is created to import the event into their outlook calendar.It works fine but we found something weird happening recently.There is an event scheduled for April 16th, the time is from 12:00 - 1:00 yet when the outlook file comes over it has it down as 1:00 - 2:00.All the other 12-1 events work fine and have the right time in outlook. I realized this must be happening because of daylight savings time.My question would be is there a way to avoid this? Had anyone run into this before? Just looking for an easy fix. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFFILE Question
OK I have a form that someone fills out, they hit submit and I present the results.At the same time I need to create an html file on the fly with the same results to save for later use.So basically I set something like CFSET body='THE ENTIRE HTML DOCUMENT BODY' Now within the above CFSET tag the body contains html and cold fusion. There are some CFIF statements in it etc. However when I then go to write the file CFFILE action="" output=#body# etc. The file is created but the cold fusion tags appear in the html file.Any cold fusion out put is coming through fine but anything like CFIF tags are actually in the html document AS CFIF tags instead of processing BEFORE the html document is created.I hope that makes sense. I just need to create this html document but have the tags actually process rather then show up in the body. Suggestions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CFFILE Question
I tried that and that outputs nothing. All the Cf comes through like #form.whatever# and nothing is processed. Instead of cfset use cfsavecontent -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 11:06 AM To: CF-Talk Subject: CFFILE Question OK I have a form that someone fills out, they hit submit and I present the results.At the same time I need to create an html file on the fly with the same results to save for later use.So basically I set something like CFSET body='THE ENTIRE HTML DOCUMENT BODY' Now within the above CFSET tag the body contains html and cold fusion. There are some CFIF statements in it etc. However when I then go to write the file CFFILE action="" output=#body# etc. The file is created but the cold fusion tags appear in the html file. Any cold fusion out put is coming through fine but anything like CFIF tags are actually in the html document AS CFIF tags instead of processing BEFORE the html document is created.I hope that makes sense. I just need to create this html document but have the tags actually process rather then show up in the body. Suggestions? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CFFILE Question
Um DUH! I must blame lack of sleep! lol thanks :) You have a cfoutput right? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Regular Expression Help (Ben)
Hi Ben, Version MX and here is the exact text i am working withWednesday, January 01, 20038:49 PM 125072 A HREF="">So for that above line I need to remove this:A HREF="" and/Abut leave the CIMG0131.JPG. Each line is different however so basically i need to keep the text between the and /aas well as everything before the a href starts.Hope that makes sense. :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF Hosting space available
Hey folks, I have a server I am using to host my site and a couple client sites. I am running WIN 2k, Cold Fusion MX, Access and SQL 2000. I am looking to open up the server to some hosting for those who might be interested. I am only going to take on about 10 people. If you are looking for some hosting space and need CF SQL let me know maybe we can work out a reasonable rate, based on what you need. Hosting would include unlimited pop email, ftp access to the server and access to SQL through enterprise manager. Drop me an email at [EMAIL PROTECTED] if you're in need of some hosting. Just trying to offset some of my costs. Thank, Kelly [EMAIL PROTECTED] _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help Please: Find/Replace
OK I am sure there is an ez way to do this my brain just doesn't seem to be working today... We have an application where some people may enter URLs they are requested to enter them like so [http://www.whatever.com] [http://www.whatever2.com] [http://www.whatever3.com] What i want to be able to do is find each [ ] and take what's in the middle of it and wrap it in a a href=http://www.whatever.com;http://www.whatever.com/a and remove the [ ] there may be multiple URLS in the text. I have been messin around with the find/replace etc. for a bit now and running into some problems. I am sure i am just doing it wrong. Any suggestions on how to do this right? Kelly ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help Please: Find/Replace
YOU RULE! :) that worked just wonderfully :-) From: Ben Doom [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Help Please: Find/Replace Date: Thu, 23 Jan 2003 14:54:43 -0500 This sounds like a job for (da da da-dh) RegEx! You want something along the lines of string = rereplace(string, '\[([^]]+)\]', 'a href=\1\1/a', 'all'); I /think/ this will work. I've not tested it and whatnot. Working with brackets and other special characters always adds a bit of adventure to it. :-) HTH. And, of course, if you need more help or more in-depth commentary, jump on over to CF-RegEx (available via the [http://www.houseoffusion.com] website). Good luck. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Kelly Matthews [mailto:[EMAIL PROTECTED]] : Sent: Thursday, January 23, 2003 2:43 PM : To: CF-Talk : Subject: Help Please: Find/Replace : : : OK I am sure there is an ez way to do this my brain just doesn't : seem to be : working today... : : We have an application where some people may enter URLs they are : requested : to enter them like so : : [http://www.whatever.com] : [http://www.whatever2.com] : [http://www.whatever3.com] : : What i want to be able to do is find each [ ] and take what's in : the middle : of it and wrap it in a a : href=http://www.whatever.com;http://www.whatever.com/a and : remove the [ : ] there may be multiple URLS in the text. I have been messin around with : the find/replace etc. for a bit now and running into some problems. I am : sure i am just doing it wrong. Any suggestions on how to do this right? : : Kelly : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Is there a Better Way to do this?
Ok here is what i am doing and I am just trying to find out if 1. there is a better way and 2. if it can be done on the SQL side (as a stored proc) instaed of the CF side. Just not all that familiar with looping outside of CF. ANyway I have one table that is a dictionary with about 1500 words. THen I have another table that has dreams people have entered. THe idea is to take the list of words and see if any of them show up in the dream and then display those words to the user. What I built works and it's actually pretty speedy, but the dictionary is very small right now and it may be closer to 1 by the time we are done which is a MUCH larger list of words to loop through. So right now I am doing a query to get the words CFQUERY name=wordS SELECT word from dictionary /CFQUERY THen we grab a dream CFQUERY name=dream SELECT dream from dreams where dream_id = 3 /CFQUERY Then I Loop through like so: CFLOOP list=#valuelist(words.word)# delimiters=, index=theword Then I check to see if the dream contains the word. CFIF dream.dream contains #theword# OR dream.dream contains #theword#s Then I grab the definition if it found that word. CFQUERY name=getdef SELECT definition from dictionary where word = '#theword#' /CFQUERY Then I display it #theword#BR#getdef.definition#P /CFIF /CFLOOP This words fine and with a dream thats a few thousand words it completes in a few seconds. I just wonder if there is a faster or better way to do this so down the road we don't run into problems as the word list grows. THoughts? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Is there a Better Way to do this?
No you were correct I only want to pull the dictionary words that were found
in the dream. The code you gave me worked great the only issue i see now for
example let's say the word is FEEL then it pulls EEL out of the dictionary.
IS there a way to avoid that?
I'm not a SQL wizard and am doing this off the top of my
head, but I'd try
something along the lines of
select word from dictionary where
(select dream from dreams where dream_id = #dreamid#)
like ('%' + word + '%')
But, again, that's off the top of my head.
What you mean is :
SELECT dictionary.word, dictionary.definition
FROM dictionary LEFT JOIN dream
ON dreams.dream LIKE '%' + dictionary.word + '%'
Which is what Isaac's got in his stored proc... ;o)
Accept that if you left join dream, you'll get every word from the
dictionary -- I was under the impression ( possibly mistaken ) he was
looking for only words appearing in the dream text ...
s. isaac dealey954-776-0046
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Is there a Better Way to do this?
awesome thanks :)))
From: S. Isaac Dealey [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Is there a Better Way to do this?
Date: Thu, 19 Dec 2002 13:26:40 -0500
Yea, there's a couple things you can do ...
Make sure that every word in the dream is bounded by spaces
You can do this with a couple regular expressions like this:
cfset dreamtext = REReplace(dreamtext,([[:alpha:]])([^ [:alpha:]]),\1
\2,ALL)
cfset dreamtext = REReplace(dreamtext,([^ [:alpha:]])([[:alpha:]]),\1
\2,ALL)
To give you a quick run-down ( in case you're unfamiliar with regular
expressions ), this says find an alphabetic character [[:alpha:]] followed
by a character that is not a space and not alphabetical [^ [:alpha:]], and
replace them with the first character \1 a space and the second character
\2
-- it then reverses the position of the alpha and the non alpha characters
and places spaces in front of words which are prepended with something
other
than a space.
Then feed your massaged dream text into the stored procedure with an extra
space on either side of the text and add the spaces to the query like so:
WHERE dreams.dream LIKE '% ' + dictionary.word + ' %'
Alternatively, you could just change anything that's not a space into a
space before you feed it to the stored procedure like this:
cfquery ...
exec sp_DreamNewLookup
@txt_dream = ' #REReplace(dreamtext,[^ [:alpha:]], ,ALL)# ';
/cfquery
This is going to also replace numbers and punctuation, however, so you
probably won't want to store the text after this REReplace() function call.
If you need / want more help with regular expressions, check out the
cf-regex list also on www.houseoffusion.com
hth
s. isaac dealey954-776-0046
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
No you were correct I only want to pull the dictionary
words that were found
in the dream. The code you gave me worked great the only
issue i see now for
example let's say the word is FEEL then it pulls EEL out
of the dictionary.
IS there a way to avoid that?
I'm not a SQL wizard and am doing this off the top of
my
head, but I'd try
something along the lines of
select word from dictionary where
(select dream from dreams where dream_id = #dreamid#)
like ('%' + word + '%')
But, again, that's off the top of my head.
What you mean is :
SELECT dictionary.word, dictionary.definition
FROM dictionary LEFT JOIN dream
ON dreams.dream LIKE '%' + dictionary.word + '%'
Which is what Isaac's got in his stored proc... ;o)
Accept that if you left join dream, you'll get every word
from the
dictionary -- I was under the impression ( possibly
mistaken ) he was
looking for only words appearing in the dream text ...
s. isaac dealey954-776-0046
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~~
~~~|
Archives:
http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/cf_lists/index.
cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up
with the latest news in ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
One More Question Re: Is there a Better Way to do this?
ok right now i am doing this cfset dreamtext = REReplace(dream.dream,([[:alpha:]])([^ [:alpha:]]),\1 \2,ALL) cfset dreamtext = REReplace(dream.dream,([^ [:alpha:]])([[:alpha:]]),\1 \2,ALL) CFQUERY datasource=#request.dsn# name=dictionary SELECT DISTINCT DJ_Dictionary.Word FROM DJ_Dictionary WHERE '#dreamtext#' LIKE '% ' + DJ_Dictionary.Word + ' %' ORDER BY DJ_Dictionary.Word /CFQUERY Works great and is very speedy. I implement the spaces then just find the words and the results come back very fast. HOWEVER how would i add one more where clause to pick up any word ending in S. Meaning if the word bat is in the dream it will pick it up, but if it's bats it will not, and i want to pick up plurals. I tried OR '#dreamtext#' LIKE '% ' + DJ_Dictionary.Word[s] + ' %' but that didn't work I am sure i Have the right idea just the wrong format. LOL Anyway ideas? Kelly ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Figured it out
this works OR '#dreamtext#' LIKE '% ' + DJ_Dictionary.Word2 + 's %' ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: One More Question Re: Is there a Better Way to do this?
for now im not going to do verity BUT it is full text indexed would using CONTAIN instead of like make any difference? Well, the easy way is to just add 'bats' to your words table -- this also will help with plurals for which the trailing s doesn't necessarily apply, i.e. gooss, octopuss or mooses... ;P You could also add an or to your sql statement and another like, although for this sort of functionality you usually want to go with Verity indexing -- which will also improve your overall speed at the expense of forcing you to update your dictionary and your dreams catalog ( in Verity ) periodically and not getting up to the second results from the dream catalog when you perform these searches. If you don't want to get into the Verity stuff and you don't want to padd your dictionary, here's the other sql syntax SELECT DISTINCT DJ_Dictionary.Word FROM DJ_Dictionary WHERE '#dreamtext#' LIKE '% ' + DJ_Dictionary.Word + ' %' OR '#dreamtext#' LIKE '% ' + DJ_Dictionary.Word + 's %' ORDER BY DJ_Dictionary.Word ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Next/Previous???
Does anyone know of an unencrypted tag that will do next/previous start/end type navigation. The type that outputs like Anyone? -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Next/Previous???
Maybe I am missing something but the help on this is SERIOUSLY lacking [EMAIL PROTECTED] writes: search dev-exchange for CF_recordcount it is very nice and unencrypted. ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Next/Previous???
Probably and I have a normal next previous module I have been using for years but as I mentioned in my first message they want it like this which is a tad different then Next/Previous... don't worry about it i will figure it out eventually... [EMAIL PROTECTED] writes: It would probably just be easier to write it yourself, its pretty basic.. Quick dirty example below.. - cfparam name=MyStartRow default=1 cfset MyMaxRows = 10 cfif MyStartRow is 0 PROBLEMS! cfabort /cfif cfquery name=MyQuery datasource=MyDataSource SomeQuery /cfquery cfoutput query=MyQuery StartRow=#MyStartRow# MaxRows=#MyMaxRows# Some output /cfoutput cfif MyStartRow - MyMaxRows gt 0 cfoutput a href=MyPage.cfm?MyStartRow=#Evaluate(MyStartRow - MyMaxRows)#Previous #MyMaxRows#/a /cfoutput /cfif cfif MyStartRow + MyMaxRows lt MyQuery.RecordCount cfoutput a href=MyPage.cfm?MyStartRow=#Evaluate(MyStartRow + MyMaxRows)#Next #MyMaxRows#/a /cfoutput /cfif ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: simple cfloop
Yep in is much better, quicker too! [EMAIL PROTECTED] writes: cfquery datasoure=xxx name=listsQuery SELECT this, that, theotherthing FROM tblName WHERE ID IN (#id#) /cfquery cfoutput query=listsQuery #this#br#that#br#theotherthing#brbr /cfoutput ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CyberCash
Ok I am sure this has been discussed before but I am going to send a message anyway then I will go search the archives. :) Anyway I have a client who INSISTS on using Cybercash, so don't even recommend going w/ someone else, already tried that. I am sure they will switch once they see how slow they are. Anyway I know there are a few CyberCash tags out there for CF. However, I have never used one myself so thought I would ask for some recommendations on the best one out there. Preferably a FREE one. :) -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CyberCash
As I clearly stated they are NOT switching they already have Cybercash. Looking for a Cybercash tag... So for now they will stick with that if Verisign makes them switch later they will have to deal with that at the time. -KLM [EMAIL PROTECTED] writes: If they are setting up a new account with Verisign, they will ONLY be able to get PayFlowPro as Cybercash is being phased out. ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cybercash tag not found...
I went to the developers section and when I try to download CFX_Cybercash (which appears to download from Cybercash's site) it's not found. Does anyone have a copy? Also I just spoke w/ Verisign, while they are merging Cybercash with their existing service customers who have Cybercash will not have to change a thing, all their cyber cash settings will still work with the merged service. Just an FYI. -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem w/ CFFILE...
I haven't run across this error before. On my form I have this: td valign=bottom align=rightfont size=2bLogo:/b/font/td td valign=bottominput type=file name=LogoFileName value= size=30 maxlength=64/td Which allows for me to upload a file. I basically click Browse and find the image. The action page has: CFIF Trim(LogoFileName) NEQ cffile action=UPLOAD filefield=Form.LogoFileName destination=#UploadDirectory# nameconflict=MAKEUNIQUE CFSET LogoFileName=ServerFile /CFIF Well I am getting an error on that that says: Message Error in CFFILE tag Type UNKNOWN Detail The form field specified in the CFFILE tag (LogoFileName) does not contain an uploaded file. Please be sure that you have specified the correct form field name. Yet I am choosing a file on the form page. Any idea what would be causing this NOT to work? I have never see this problem before. -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access to SQL Server
You go into enterprise manager depending if you have 2000 or 7.0 it may differ but: right click on the table in question Click Design Table Depending if you have 7.0 or 2000 will depend on where this is located. If you have 2000 it should be at the bottom of the screen you should see something that says IDENTITY it should be set to NO at default change it to yes and you will be good to go. If you have 7.0 instead of identity being at the bottom it may be over towards the right of the screen. Kelly -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 10:36 AM To: CF-Talk Subject: Access to SQL Server In Access you can set the primary key to auto number - how do you do this in SQL Server? I would assume that has something to do with this error that I am getting: Error Diagnostic Information ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'UserID', table 'SaraLee.dbo.ChockUsers'; column does not allow nulls. INSERT fails. Thanks! __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help with resolving a variable...
Ok we have a survey where we have to rate each person in 3 categories.
We have 50 people to rate.
I set a comma delimited list of names and then create a loop to create 3
questions
for each person, so we can rate each of the 50 people in the 3 categories.
Looks like this:
cfloop index=Surname list=#ChunkLast#
cfset ChunkFirstIndex = ChunkFirstIndex +1
cfinput type=radio name=#trim(Surname)#_Comm value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Comm value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Comm value=3
style=background: 9DCBFF
input name=#trim(Surname)#_Comm_required type=hidden value=You forgot
to rate b#trim(Surname)#/b for bCommitted to AAAE Goals,/b
cfinput type=radio name=#trim(Surname)#_Cust value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Cust value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Cust value=3
style=background: 9DCBFF
input name=#trim(Surname)#_Cust_required type=hidden value=You forgot
to rate b#trim(Surname)#/b for bCustomer Service/b.
cfinput type=radio name=#trim(Surname)#_Extr value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Extr value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Extr value=3
style=background: 9DCBFFcfinput type=radio
name=#trim(Surname)#_Extr value=4 style=background: 5785FF
input name=#trim(Surname)#_Extr_required type=hidden value=You forgot
to rate b#trim(Surname)#/b for bExtra Effort/b.
/CFLOOP
It creates this part fine and as you can see for each category there are 3
radio buttons all
w/ the same name. So if the surname for the first person were smith the
first set of radio
buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
It does this for all 50 people, works great.
Here is the problem when I hit submit I want to loop through to resolve all
the values rather
than have to type up 200 separate values in the insert statement.
However if I want to loop through on the insert page similarly to how I am
looping through on the
form I can't resolve the variable. Because if I pass a value named
smith_comm
I can't loop through to get the value of smith_comm...
Meaning an insert statement like:
cfloop index=Surname list=#ChunkLast#
cfset ChunkFirstIndex = ChunkFirstIndex +1
CFQUERY datasource=SC2002
INSERT INTO SCORES
(#trim(Surname)#_Comm)
VALUES
('#trim(surname)#_comm') (obviously that won't work because it will
insert a value of smith_comm instead of say 3 How do I find the value of
smith_comm by looping through? Any ideas??
/CFQUERY
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
oh dammit that's right I knew there was a solution cuz I had this problem
well over
a year ago just couldn't remember. Thanks Bryan! :)
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 3:03 PM
To: CF-Talk
Subject: Re: Help with resolving a variable...
Evaluate()
Use that to find the value of the vars you are dynamically building the
names for
Bryan Stevenson
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
- Original Message -
From: Kelly Matthews [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
Ok we have a survey where we have to rate each person in 3 categories.
We have 50 people to rate. I set a comma delimited list of names and
then create a loop to create 3 questions
for each person, so we can rate each of the 50 people in the 3 categories.
Looks like this:
cfloop index=Surname list=#ChunkLast#
cfset ChunkFirstIndex = ChunkFirstIndex +1
cfinput type=radio name=#trim(Surname)#_Comm value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Comm value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Comm value=3
style=background: 9DCBFF
input name=#trim(Surname)#_Comm_required type=hidden value=You
forgot to rate b#trim(Surname)#/b for bCommitted to AAAE
Goals,/b
cfinput type=radio name=#trim(Surname)#_Cust value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Cust value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Cust value=3
style=background: 9DCBFF
input name=#trim(Surname)#_Cust_required type=hidden value=You
forgot to rate b#trim(Surname)#/b for bCustomer Service/b.
cfinput type=radio name=#trim(Surname)#_Extr value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Extr value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Extr value=3
style=background: 9DCBFFcfinput type=radio
name=#trim(Surname)#_Extr value=4 style=background: 5785FF
input name=#trim(Surname)#_Extr_required type=hidden value=You
forgot to rate b#trim(Surname)#/b for bExtra Effort/b.
/CFLOOP It creates this part fine and as you can see for each
category there are 3 radio buttons all
w/ the same name. So if the surname for the first person were smith the
first set of radio
buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
It does this for all 50 people, works great.
Here is the problem when I hit submit I want to loop through to
resolve all the values rather than have to type up 200 separate values
in the insert statement.
However if I want to loop through on the insert page similarly to how
I am looping through on the form I can't resolve the variable. Because
if I pass a value named smith_comm
I can't loop through to get the value of smith_comm...
Meaning an insert statement like:
cfloop index=Surname list=#ChunkLast#
cfset ChunkFirstIndex = ChunkFirstIndex +1
CFQUERY datasource=SC2002
INSERT INTO SCORES
(#trim(Surname)#_Comm)
VALUES
('#trim(surname)#_comm') (obviously that won't work because it will
insert a value of smith_comm instead of say 3 How do I find the value
of
smith_comm by looping through? Any ideas??
/CFQUERY
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
Ok wait still confused...
Evaluate(WHAT?)
For instance Evaluate(surname_Comm) doesn't work
nor does Evaluate(#surname#_Comm)
Sorry just not sure how to display it properly... Was using a CFSET tag like
CFSET surnamecomm = Evaluate(#surname#_Comm)
That gives an error
CFSET surnamecomm = Evaluate(#surname#_Comm)
Makes surnamecomm = to Evaluate(smith_comm) instead of just smith_comm
I am probably missing something minor...
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 3:03 PM
To: CF-Talk
Subject: Re: Help with resolving a variable...
Evaluate()
Use that to find the value of the vars you are dynamically building the
names for
Bryan Stevenson
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
- Original Message -
From: Kelly Matthews [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
Ok we have a survey where we have to rate each person in 3 categories.
We have 50 people to rate. I set a comma delimited list of names and
then create a loop to create 3 questions
for each person, so we can rate each of the 50 people in the 3 categories.
Looks like this:
cfloop index=Surname list=#ChunkLast#
cfset ChunkFirstIndex = ChunkFirstIndex +1
cfinput type=radio name=#trim(Surname)#_Comm value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Comm value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Comm value=3
style=background: 9DCBFF
input name=#trim(Surname)#_Comm_required type=hidden value=You
forgot to rate b#trim(Surname)#/b for bCommitted to AAAE
Goals,/b
cfinput type=radio name=#trim(Surname)#_Cust value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Cust value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Cust value=3
style=background: 9DCBFF
input name=#trim(Surname)#_Cust_required type=hidden value=You
forgot to rate b#trim(Surname)#/b for bCustomer Service/b.
cfinput type=radio name=#trim(Surname)#_Extr value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Extr value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Extr value=3
style=background: 9DCBFFcfinput type=radio
name=#trim(Surname)#_Extr value=4 style=background: 5785FF
input name=#trim(Surname)#_Extr_required type=hidden value=You
forgot to rate b#trim(Surname)#/b for bExtra Effort/b.
/CFLOOP It creates this part fine and as you can see for each
category there are 3 radio buttons all
w/ the same name. So if the surname for the first person were smith the
first set of radio
buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
It does this for all 50 people, works great.
Here is the problem when I hit submit I want to loop through to
resolve all the values rather than have to type up 200 separate values
in the insert statement.
However if I want to loop through on the insert page similarly to how
I am looping through on the form I can't resolve the variable. Because
if I pass a value named smith_comm
I can't loop through to get the value of smith_comm...
Meaning an insert statement like:
cfloop index=Surname list=#ChunkLast#
cfset ChunkFirstIndex = ChunkFirstIndex +1
CFQUERY datasource=SC2002
INSERT INTO SCORES
(#trim(Surname)#_Comm)
VALUES
('#trim(surname)#_comm') (obviously that won't work because it will
insert a value of smith_comm instead of say 3 How do I find the value
of
smith_comm by looping through? Any ideas??
/CFQUERY
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
Ok I figured it out, ignore my last message. Thanks again!
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 3:03 PM
To: CF-Talk
Subject: Re: Help with resolving a variable...
Evaluate()
Use that to find the value of the vars you are dynamically building the
names for
Bryan Stevenson
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
- Original Message -
From: Kelly Matthews [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
Ok we have a survey where we have to rate each person in 3 categories.
We have 50 people to rate. I set a comma delimited list of names and
then create a loop to create 3 questions
for each person, so we can rate each of the 50 people in the 3 categories.
Looks like this:
cfloop index=Surname list=#ChunkLast#
cfset ChunkFirstIndex = ChunkFirstIndex +1
cfinput type=radio name=#trim(Surname)#_Comm value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Comm value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Comm value=3
style=background: 9DCBFF
input name=#trim(Surname)#_Comm_required type=hidden value=You
forgot to rate b#trim(Surname)#/b for bCommitted to AAAE
Goals,/b
cfinput type=radio name=#trim(Surname)#_Cust value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Cust value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Cust value=3
style=background: 9DCBFF
input name=#trim(Surname)#_Cust_required type=hidden value=You
forgot to rate b#trim(Surname)#/b for bCustomer Service/b.
cfinput type=radio name=#trim(Surname)#_Extr value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Extr value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Extr value=3
style=background: 9DCBFFcfinput type=radio
name=#trim(Surname)#_Extr value=4 style=background: 5785FF
input name=#trim(Surname)#_Extr_required type=hidden value=You
forgot to rate b#trim(Surname)#/b for bExtra Effort/b.
/CFLOOP It creates this part fine and as you can see for each
category there are 3 radio buttons all
w/ the same name. So if the surname for the first person were smith the
first set of radio
buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
It does this for all 50 people, works great.
Here is the problem when I hit submit I want to loop through to
resolve all the values rather than have to type up 200 separate values
in the insert statement.
However if I want to loop through on the insert page similarly to how
I am looping through on the form I can't resolve the variable. Because
if I pass a value named smith_comm
I can't loop through to get the value of smith_comm...
Meaning an insert statement like:
cfloop index=Surname list=#ChunkLast#
cfset ChunkFirstIndex = ChunkFirstIndex +1
CFQUERY datasource=SC2002
INSERT INTO SCORES
(#trim(Surname)#_Comm)
VALUES
('#trim(surname)#_comm') (obviously that won't work because it will
insert a value of smith_comm instead of say 3 How do I find the value
of
smith_comm by looping through? Any ideas??
/CFQUERY
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with resolving a variable...
actually what I did was
CFSET surnamecomm = #Surname#_Comm
Then in the insert statement for the values I did
'#Evaluate(surnamecomm)#'
-Original Message-
From: Bruce, Rodney (Contractor) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 3:18 PM
To: CF-Talk
Subject: RE: Help with resolving a variable...
I believe it would be one of these
CFSET surnamecomm = #Evaluate(surname_#Comm#)#
or
CFSET surnamecomm = #Evaluate(#surname#_Comm)#
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 1:09 PM
To: CF-Talk
Subject: RE: Help with resolving a variable...
Ok wait still confused...
Evaluate(WHAT?)
For instance Evaluate(surname_Comm) doesn't work
nor does Evaluate(#surname#_Comm)
Sorry just not sure how to display it properly... Was using a CFSET tag like
CFSET surnamecomm = Evaluate(#surname#_Comm) That gives an error CFSET
surnamecomm = Evaluate(#surname#_Comm) Makes surnamecomm = to
Evaluate(smith_comm) instead of just smith_comm I am probably missing
something minor...
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 3:03 PM
To: CF-Talk
Subject: Re: Help with resolving a variable...
Evaluate()
Use that to find the value of the vars you are dynamically building the
names for
Bryan Stevenson
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
- Original Message -
From: Kelly Matthews [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 11:46 AM
Subject: Help with resolving a variable...
Ok we have a survey where we have to rate each person in 3 categories.
We have 50 people to rate. I set a comma delimited list of names and
then create a loop to create 3 questions
for each person, so we can rate each of the 50 people in the 3 categories.
Looks like this:
cfloop index=Surname list=#ChunkLast#
cfset ChunkFirstIndex = ChunkFirstIndex +1
cfinput type=radio name=#trim(Surname)#_Comm value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Comm value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Comm value=3
style=background: 9DCBFF
input name=#trim(Surname)#_Comm_required type=hidden value=You
forgot to rate b#trim(Surname)#/b for bCommitted to AAAE
Goals,/b
cfinput type=radio name=#trim(Surname)#_Cust value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Cust value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Cust value=3
style=background: 9DCBFF
input name=#trim(Surname)#_Cust_required type=hidden value=You
forgot to rate b#trim(Surname)#/b for bCustomer Service/b.
cfinput type=radio name=#trim(Surname)#_Extr value=1
style=background: white
cfinput type=radio name=#trim(Surname)#_Extr value=2
style=background: BBE9FF
cfinput type=radio name=#trim(Surname)#_Extr value=3
style=background: 9DCBFFcfinput type=radio
name=#trim(Surname)#_Extr value=4 style=background: 5785FF
input name=#trim(Surname)#_Extr_required type=hidden value=You
forgot to rate b#trim(Surname)#/b for bExtra Effort/b.
/CFLOOP It creates this part fine and as you can see for each
category there are 3 radio buttons all
w/ the same name. So if the surname for the first person were smith the
first set of radio
buttons would be named smith_comm, 2nd set smith_cust, 3rd set smith_extr
It does this for all 50 people, works great.
Here is the problem when I hit submit I want to loop through to
resolve all the values rather than have to type up 200 separate values
in the insert statement.
However if I want to loop through on the insert page similarly to how
I am looping through on the form I can't resolve the variable. Because
if I pass a value named smith_comm
I can't loop through to get the value of smith_comm...
Meaning an insert statement like:
cfloop index=Surname list=#ChunkLast#
cfset ChunkFirstIndex = ChunkFirstIndex +1
CFQUERY datasource=SC2002
INSERT INTO SCORES
(#trim(Surname)#_Comm)
VALUES
('#trim(surname)#_comm') (obviously that won't work because it will
insert a value of smith_comm instead of say 3 How do I find the value
of
smith_comm by looping through? Any ideas??
/CFQUERY
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verify password is alpha numeric?
Ok I should probably know this but basically I am letting people choose their own passwords, each password must contain at least ONE number and one alpha character. What's the best way to verify this? They are creating the password themselves, I am not creating random passwords for them. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Verify password is alpha numeric?
Cool Thanks! -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 2:11 PM To: CF-Talk Subject: RE: Verify password is alpha numeric? try CFIF REFind([0-9], VARIABLES.password) AND REFind([A-Za-z], VARIABLES.password) it's good! /CFIF christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 2:05 PM To: CF-Talk Subject: Verify password is alpha numeric? Ok I should probably know this but basically I am letting people choose their own passwords, each password must contain at least ONE number and one alpha character. What's the best way to verify this? They are creating the password themselves, I am not creating random passwords for them. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Better Javascript/DHTML Calender!
it's down they have reached their max transfer load for the day, that's a free site for ya -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 11:39 AM To: CF-Talk Subject: RE: Better Javascript/DHTML Calender! That link doesn't work The site is down or doesn't exist -Original Message- From: Zac spitzer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 9:18 AM To: CF-Talk Subject: Better Javascript/DHTML Calender! similair to Popup Calander XP or whatever, except it's free and not $150 US it's a cross browser, inline DHTML calender http://www.geocities.com/bazillyo/spiffy/calendar/ z __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is Their a Standard Way of Preventing Users from Entering Dou ble Records by Refreshing Browser?
Well I usually query the database first to see if the name/email combo exists before inserting it, if so I don't allow it to enter again. So if they do refresh it would prevent that. -Original Message- From: PHP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 7:57 PM To: CF-Talk Subject: Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser? Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser? So when I submit A name and Email to a database and then hit refresh on the page I was sent to Another entry appears in the Database with the same information duplicated. Is their a Common Practice in your coding to follow to prevent such a small (yet potentially very common) Data Distortion. Thanks, Dave __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFLOCK on files
as far as I know it's not something that can be done. CFLOCK is strictly for sessions, etc. CFFILE doesn't allow you to add a system level lock on a file nor release a lock. Would be nice though. :) I could be wrong but I don't think it has that capability. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 6:33 PM To: CF-Talk Subject: CFLOCK on files Does CF set an operating system level file lock on files being accessed within a named CFLOCK? Or is this handled by CFFILE? Or at all? Jim __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF_CFLOOP_2nd_pair_of_eyes
Pull an ID or whatever record identifier you have in your first query.
Not just the date.
Then in the update statement you need a where ID = #ID# or
whatever your record identifier is called. It has no idea what
row you want to update the way you wrote it.
Kelly
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 4:07 PM
To: CF-Talk
Subject: CF_CFLOOP_2nd_pair_of_eyes
Hi,
I'm trying to interate through all the records in a
table and add two weeks to a new date column based on
and existing date value(srf_date_created). When I run
the code below, I get the same date instead of an entry
based on (srf_date_created + 2 weeks) And yes the date
valuefor srf_date_created is different for each record.
srf_date_created is an exist date value
srf_date_fu is a newly added date column
CFQUERY name=loop_date_sr datasource=#source1#
SELECT srf_date_created
FROM samprequest
/cfquery
CFoutput query=loop_date_sr
CFQUERY NAME=update_sampler datasource=#source1#
UPDATE samprequest
SET srf_date_fu = #DateAdd('ww', 2, (srf_date_created))# /cfquery
/CFoutput
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: null characters in a file
That's what we are considering now using VB we aren't running perl on our machine here and I would rather not hopefully VB can handle it. We are just going ot have VB split the file in 2, CF will edit the one portion then VB would put them batch together. Is Cold Fusion able to CALL a vb script/executable? I am assuming it can just have never done that. Do you know the best way to CALL something like that? Make it a COM Object? Kelly -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 9:31 AM To: CF-Talk Subject: RE: null characters in a file Kelly, We ran into this EXACT same problem about a month ago. We were doing a cffile, then parsing through the file to modify it and then spitting the modified version to screen. We discovered, as you did, that cf chokes on null characters and were perplexed at what to do. In our situation, we ended up modifying the file on the back-end, through perl, when the file was placed in the directory (business rules state that the file gets ftp'd from the main frame to a directory on the web server). It made perfect sense to do any modifications on the back-end - why slow down cf when you know that every time you get a file, you have to modify it. After the file was modified on the back-end, we were free to call the file anyway we wanted. I.E. cffile, cfcontent, cflocation, etc. Hope that helps. Mark -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Monday, December 31, 2001 11:28 PM To: CF-Talk Subject: null characters in a file Using CFFILE to read a file. The file has a couple of null characters in the middle of the file. When it reaches the NULL characters it assumes it has reached the end and stops. Is there a way to read the file (I have to make some modifications to it as well) and get around or parse out the null characters? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help reading a file using CFFILE Binary/Hex etc problems....
Ok I have this file, which we will receive automatically. The first part of the file is hex code data, which can be read easily, even manipulated etc. The 2nd part of the file is binary data. When I use CFFILE to READ the file it reads it fine comes back with no errors, but when I output what it read it only saves up to where the hex code ends. Meaning all the binary is not read nor is it added to the CFFILE variable for output. The same thing happens using CFHTTP it reads only the first part yet it can see the ENTIRE file size, and comes back w/ no error just partial data. I don't want to send the file to the list because it's quite large (600K), the hexcode part it is only about the 1st K of the file. But if you want a copy to play around with, if you think you can help, I can send you one. The perdicament is this. I have to edit data in the first part (hexcode) of the file. I have been able to do this successfully when I do not include the binary portion of the file. I READ the file and then change data and then WRITE the file out. But since reading the file only pulls the first portion the binary part does not get written. If I try READBINARY then I can't manipulate the hex code part. The binary standard they are using (if it makes a difference is) Wavelet Scalar Quantization (WSQ). Ultimately I would like to be able to just manipulate the data in one file if that won't work then possibly strip OUT the first part of the file (after making a copy) so I can just save the binary. Then in another file make all my changes to the hex (first part of the file) code and then somehow put the 2 pieces back together. My code looks like this (actually I have tried this a number of ways even with ASP and it still only grabs the initial part of the file) CF CODE: CFSET tempfolder = D:\Inetpub\www\dev\kelly\test\ CFDIRECTORY action=LIST directory=#tempfolder# name=newfiles CFFILE ACTION=Read FILE=#tempfolder#efts.sub VARIABLE=test CFOUTPUT#test#/CFOUTPUT Then I played around with using READBINARY CFSET tempfolder = D:\Inetpub\www\dev\kelly\test\ CFDIRECTORY action=LIST directory=#tempfolder# name=newfiles CFFILE ACTION=Readbinary FILE=#tempfolder#efts.sub VARIABLE=test CFSET abinaryobj=tobase64(test) This does infact pull the whole file but of course now it's tobase64 (not even really familiar w/ this) and not hexcode... W/ ASP I tried: % Set fs=Server.CreateObject(Scripting.FileSystemObject) Set f=fs.OpenTextFile(Server.MapPath(test.sub), 1) Response.Write(f.ReadAll) f.Close Set f=Nothing Set fs=Nothing % __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
null characters in a file
Using CFFILE to read a file. The file has a couple of null characters in the middle of the file. When it reaches the NULL characters it assumes it has reached the end and stops. Is there a way to read the file (I have to make some modifications to it as well) and get around or parse out the null characters? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Licensing/User Question
Ok have a question. We have a license that allows 4 people/logins to be connected to the SQL server at one time. Via Enterprise manager or whatever. Well it keeps telling us there are 4 connected yet there are only 2 of us using it. Is there a place I can go to see who the current USERS are that are connected to the sql server? Sorry it's something I normally don't deal w/ so just don't know where to look. Kelly __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Licensing/User Question
could it be cold fusion? -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:33 PM To: CF-Talk Subject: RE: SQL Licensing/User Question I believe your web server is a user also... Not sure where the other is coming from. -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:32 PM To: CF-Talk Subject: SQL Licensing/User Question Ok have a question. We have a license that allows 4 people/logins to be connected to the SQL server at one time. Via Enterprise manager or whatever. Well it keeps telling us there are 4 connected yet there are only 2 of us using it. Is there a place I can go to see who the current USERS are that are connected to the sql server? Sorry it's something I normally don't deal w/ so just don't know where to look. Kelly __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Licensing/User Question
I have maintain connection on, we are running 23 different databases and that has NEVER posed a problem with connections from what I can tell it still sees it as ONE connection otherwise I would never be able to log into enterprise manager. -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:49 PM To: CF-Talk Subject: RE: SQL Licensing/User Question Every datasource you define in the CF Administrator will count as a user IF you check the Maintain Connection box. In other words if you have Datasources --- DS1 SQL Server 7 DS2 SQL Server 7 If you checked the Maintain Connection box for both of these then there will be two connections open as long as CF is running. *Note* a connection is not established until the first time you hit the DB. After that the connection persists unless you UNCHECK the Maintain Connection box and restart the service. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecomunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:39 PM To: CF-Talk Subject: RE: SQL Licensing/User Question I think yur right :-) not sure though... Im just guessing -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:40 PM To: CF-Talk Subject: RE: SQL Licensing/User Question could it be cold fusion? -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:33 PM To: CF-Talk Subject: RE: SQL Licensing/User Question I believe your web server is a user also... Not sure where the other is coming from. -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:32 PM To: CF-Talk Subject: SQL Licensing/User Question Ok have a question. We have a license that allows 4 people/logins to be connected to the SQL server at one time. Via Enterprise manager or whatever. Well it keeps telling us there are 4 connected yet there are only 2 of us using it. Is there a place I can go to see who the current USERS are that are connected to the sql server? Sorry it's something I normally don't deal w/ so just don't know where to look. Kelly __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Transaction Logs...?
supposedly they do a full back up every night. I am using a shared SQL server so we don't have permissions to create our own maintenance schedule. I will still pass this on though thanks. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 9:08 AM To: CF-Talk Subject: Re: SQL Transaction Logs...? On 12/12/01, Kelly Matthews penned: Has anyone ever had a SQL 7 or 2000 database that wasn't that large. Have one that's about 9 megs. Where the transaction log was HUGE? My transaction log is 231 megs right now and rapidly growing. There is not that much update, insert, delete activity against the database so I am confused as to why this is happening. I run a ton of other databases where the transaction log is not so much larger then the database. Thoughts? Alot depend on how you have your maintenance scheduling set up. If you have a single transaction log that keeps growing, then it sounds as though you DON'T have a maintenance schedule. That's not using one of SQL Server's most desirable functions. :) I set mine up to do a full backup weekly and a transaction log backup every 12 hours. Every time the transaction log is backed up, all of those transactions are deleted from the log (auto-shrink). Then I backup to tape daily. If I have a failure, I can restore the most recent full backup, then all the transaction log backups after that. The most I'd lose is less than 12 hours worth of data and disk usage is kept to a minimum. One question I have for you SQL experts though. I have the full backup and transaction backups set to be deleted automatically every 8 days. The full backup files are deleted fine, but I have to delete the old transaction log backups manually. Any idea as to why? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
EXCEL Question Spaces in Field names
Ok here is the deal. I have an excel file. I can query through it no problem. I have to take results and update a SQL database. Again no problem. Except some of the field names in the excel file have spaces. We receive this file from another party so we can't remove the spaces from the file. Can we 1. rename the field names in excel and remove the spaces that way? or 2. Somehow convert it during the query so it will work. Example: CFQUERY UPDATE TABLE SET CASENUM = '#CASE NUMBER#' WHERE WHATEVER = WHATEVER /CFQUERY It errors out at NUMBER because of the space. Any suggestions? ~~ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: EXCEL Question Spaces in Field names
Ok I tried that but it threw an error let me show you all the code so it may help. You will see for the FLAG field I used your code that threw an error saying it didn't know what CURROW was. before it was throwing an error because of the space. Kelly CFQUERY datasource=faastatus name=info SELECT * FROM RESULTS /CFQUERY CFLOOP query=info CFQUERY datasource=asc UPDATE STORAGE SET FLAG = '#info['case status'][curRow]#', LNAME = '#LAST NAME#', FNAME = '#FIRST NAME#', MNAME = '#MIDDLE NAME#', SUFFIX = '#SUFFIX#', CASENUM = '#CASE NUMBER#', CFIF #CASE STATUS# IS CL OR #CASE STATUS# IS CP DATECLOSED = '#STATUS DATE#' CFELSE DATESCHEDULED = '#STATUS DATE#' /CFIF WHERE SON = '#son#' AND SSN = 11223#SSN# /CFQUERY /CFLOOP -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 3:00 PM To: CF-Talk Subject: Re: EXCEL Question Spaces in Field names Is 'case number' from another query? if so, you could reference it via #queryname['case number'][curRow]# Jerry Johnson Lawyersweekly.com [EMAIL PROTECTED] 12/13/01 02:39PM Ok here is the deal. I have an excel file. I can query through it no problem. I have to take results and update a SQL database. Again no problem. Except some of the field names in the excel file have spaces. We receive this file from another party so we can't remove the spaces from the file. Can we 1. rename the field names in excel and remove the spaces that way? or 2. Somehow convert it during the query so it will work. Example: CFQUERY UPDATE TABLE SET CASENUM = '#CASE NUMBER#' WHERE WHATEVER = WHATEVER /CFQUERY It errors out at NUMBER because of the space. Any suggestions? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: EXCEL Question Spaces in Field names
Worked like a charm you rock! :) Thanks! Kelly -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 3:16 PM To: CF-Talk Subject: RE: EXCEL Question Spaces in Field names Sorry. I should have been more clear. I used curRow as a generic variable indicating the row of the query you were on. Since you are using a query loop, there should be a variable called currentRow available to you, that CF increments at each loop. [EMAIL PROTECTED] 12/13/01 02:58PM Ok I tried that but it threw an error let me show you all the code so it may help. You will see for the FLAG field I used your code that threw an error saying it didn't know what CURROW was. before it was throwing an error because of the space. Kelly CFQUERY datasource=faastatus name=info SELECT * FROM RESULTS /CFQUERY CFLOOP query=info CFQUERY datasource=asc UPDATE STORAGE SET FLAG = '#info['case status'][curRow]#', LNAME = '#LAST NAME#', FNAME = '#FIRST NAME#', MNAME = '#MIDDLE NAME#', SUFFIX = '#SUFFIX#', CASENUM = '#CASE NUMBER#', CFIF #CASE STATUS# IS CL OR #CASE STATUS# IS CP DATECLOSED = '#STATUS DATE#' CFELSE DATESCHEDULED = '#STATUS DATE#' /CFIF WHERE SON = '#son#' AND SSN = 11223#SSN# /CFQUERY /CFLOOP -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 3:00 PM To: CF-Talk Subject: Re: EXCEL Question Spaces in Field names Is 'case number' from another query? if so, you could reference it via #queryname['case number'][curRow]# Jerry Johnson Lawyersweekly.com [EMAIL PROTECTED] 12/13/01 02:39PM Ok here is the deal. I have an excel file. I can query through it no problem. I have to take results and update a SQL database. Again no problem. Except some of the field names in the excel file have spaces. We receive this file from another party so we can't remove the spaces from the file. Can we 1. rename the field names in excel and remove the spaces that way? or 2. Somehow convert it during the query so it will work. Example: CFQUERY UPDATE TABLE SET CASENUM = '#CASE NUMBER#' WHERE WHATEVER = WHATEVER /CFQUERY It errors out at NUMBER because of the space. Any suggestions? ~~ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
HELP CFTRY/CFCATCH/CFDIRECTORY problem
Ok here's the scenario. We have to place a file into a directory structure. The end result would be D:\FILES\SONNUMBER\TODAYSDATE\SOCIALSECURITYNUMBER\ACTUALFILE.TXT These folders SONNUMBER, TODAYSDATE, and SOCIALSECURITYNUMBER would be created on the fly if they aren't already there. Most of the time the SONNUMBER (which is actually 1 of 600+ numbers) will already be there. TODAYSDATE would be there the first time I file comes through that day for that SONNUMBER and SOCIALSECURITYNUMBER will always be new. Now if I create a CFDIRECTORY tag to create the SONNUMBER folder and it already exists it of course throws and error, which it should. So using CFTRY I did the following: CFTRY cfdirectory action=create directory=#FILEPATH##SON#\ cfdirectory action=create directory=#FILEPATH##SON#\#DATEFORMAT(NOW(), 'mmddyy')#\ cfdirectory action=create directory=#FILEPATH##SON#\#DATEFORMAT(NOW(), 'mmddyy')#\#SSN#\ CFCATCH type=ANY cfdirectory action=create directory=#FILEPATH##SON#\#DATEFORMAT(NOW(), 'mmddyy')#\ cfdirectory action=create directory=#FILEPATH##SON#\#DATEFORMAT(NOW(), 'mmddyy')#\#SSN#\ /CFCATCH CFCATCH type=Any cfdirectory action=create directory=#FILEPATH##SON#\#DATEFORMAT(NOW(), 'mmddyy')#\#SSN#\ /CFCATCH CFCATCH type=Any An Error has occurred /CFCATCH /CFTRY So if it gets an error on the first set (meaning it can't create the SON folder) then it goes to the next cfcatch and tries to start from the DATE folder. If that throws an error that it exists it tries the last one which is simply creating the SocialSecurityNumber folder. However if I run this code and the SON folder does already exist but the date and socialsecurity number do not it skips the next 2 cfcatchs and goes to the last one an error has occurred. To make sure it was doing that I removed the LAST CFCATCH and then it would try to run the last one skipping the one before it. If I removed that LAST one then it would finally work. Am I just missing soemthing here with the way CFTRY and CFCATCH work? I figured if it errored on the first process it would automatically try the next one NOT the last one. Any suggestions?? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP CFTRY/CFCATCH/CFDIRECTORY problem
makes sense and I didn't even know there was a DirectoryExists() shows you how much I deal with directory stuff. :) I will try both although it still is odd that the cftry/cfcatchs were working that way. Thanks! Kelly -Original Message- From: Richard Fantini [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 8:14 PM To: CF-Talk Subject: Re: HELP CFTRY/CFCATCH/CFDIRECTORY problem Well, I would use DirectoryExists(), but if you really want to use TRY/CATCH, you could do it like this... CFTRY cfdirectory action=create directory=#FILEPATH##SON#\ CFCATCH type=ANY !--- We dont really care --- /CFCATCH /CFTRY CFTRY cfdirectory action=create directory=#FILEPATH##SON#\#DATEFORMAT(NOW(),'mmddyy')#\ CFCATCH type=ANY !--- We dont really care --- /CFCATCH /CFTRY CFTRY cfdirectory action=create directory=#FILEPATH##SON#\#DATEFORMAT(NOW(),'mmddyy')#\#SSN#\ CFCATCH type=ANY An Error has occurred /CFCATCH /CFTRY -Rich ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SOLVED - HELP CFTRY/CFCATCH/CFDIRECTORY problem
Thanks Richard. DirectoryExists works great. :) ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Transaction Logs...?
Has anyone ever had a SQL 7 or 2000 database that wasn't that large. Have one that's about 9 megs. Where the transaction log was HUGE? My transaction log is 231 megs right now and rapidly growing. There is not that much update, insert, delete activity against the database so I am confused as to why this is happening. I run a ton of other databases where the transaction log is not so much larger then the database. Thoughts? Kelly ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Anyone else get solicited? FW: CFX ImageCR
Did anyone else get solicited by these people? They snatched my email address off CF-Talk... not appreciated... really hate it when people do that! -Original Message- From: Efflare Systems [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 09, 2001 11:47 AM To: [EMAIL PROTECTED] Subject: CFX ImageCR Based on your input on the cf-talk mailing list, I thought you might be interested in knowing about the recent public release of cfx ImageCR. http://efflare.com/products/cfx_imagecr/?12 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: No cfquery output within cfquery output - but I need to
Don't embed it... if it's just a form then there is just one record for the one query so why embed? meaning do this. I have done a ton of forms with query filled select boxes this way. never have a problem. === START CODE SAMPLE === cfquery name=outsideQuery datasource=dsn select * from tblA /cfquery cfquery name=embeddedQuery datasource=dsn select * from tblB /cfquery form action=actionPage.cfm method=post cfoutput query=outsideQuery Member Name: input type=text name=nameFld value=#nameFld# /cfoutput Member Level: !-- Need the dropdown box here - select name=this cfoutput query=embeddedQuery option value=#fldID##fldName# /cfoutput you can also do * cfoutput query=embeddedQuery option value=#fldID# CFIF outsidequery.fldid EQ embeddedquery.fldidSELECTED/CFIF#fldName# /cfoutput /select Then if you have more fields just open the other output again. CFOUTPUT query=outsideQuery ETC ETC ETC /CFOUTPUT /form -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Friday, December 07, 2001 5:18 PM To: CF-Talk Subject: No cfquery output within cfquery output - but I need to I am setting up a form page that requires a drop down selection box. The dropdown box is generated dynamically in a cfoutput query section. But the dropdown box is itself to be inserted within another cfoutput query section of the page. I've tried using cfset above the first cfoutput section to make a variable that I can embed with the second cfoutput section. The problem with that is I can't do a cfoutput within the cfset tag to set up the variable (at least I don't think I can.) What I want to do is something like this: === START CODE SAMPLE === cfquery name=outsideQuery datasource=dsn select * from tblA /cfquery cfquery name=embeddedQuery datasource=dsn select * from tblB /cfquery form action=actionPage.cfm method=post cfoutput query=outsideQuery Member Name: input type=text name=nameFld value=#nameFld# Member Level: !-- Need the dropdown box here - select name=this cfoutput query=embeddedQuery option value=#fldID##fldName# /cfoutput /select /cfoutput /form === END CODE SAMPLE === Any ideas how to cram the dropdown box in there? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Random passwords
uh what code would that be? :) seems to have gotten cut off -Original Message- From: Joseph DeVore [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 1:52 PM To: CF-Talk Subject: RE: Random passwords This code will generate mixed case passwords: ! ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Question about Inserting into SQL via CF... Binary file or Image File
As most of you know SQL has a datatype of Binary that can hold an actual binary file and has a datatype of image that can hold an image file. I sent this question yesterday but go no response figured I would try once more. Obviously I know how to insert DATA via CF into SQL. But w/ in that insert statement does anyone know how to insert a binary file or an image file into a SQL database, using a CF/SQL insert statement? Any help would be most appreciated. :) Kelly ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Hosting Company...
I concur I use advances.com too have had no problems! -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 9:43 AM To: CF-Talk Subject: RE: CF Hosting Company... www.advances.com Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Gary P. McNeel, Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 7:56 PM To: CF-Talk Subject: CF Hosting Company... Can anyone recommend a good CF/SQL Server hosting company that is rea sonably priced? I pay $165 quarterly now. Has pop email for each site, 10 vir tual domains per account, ODBC for SQL and Access, SSI, Unlimited bandwidt h (probably my problem, it is getting slower). TIA. Gary P. McNeel, Jr. MyKitPlane.com [EMAIL PROTECTED] http://www.mykitplane.com What's the hurry? Are you afraid I won't come back? - Manfred von Richthofen, 'The Red Baron,' last recorded words, in reply to a request for an autograph as he was climbing into the cockpit of his plane. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Question about SQL binary files
Ok I just haven't had to do this before so I am not sure if it's really simple or what. But we have a database, one field will be a BINARY field where we want to store a FILE. This is a file we will receive and will be on the harddrive itself. When inserting the other data I also want to insert that file into that binary field. Is there a trick to this, since I am inserting a file instead of straight data? Kelly http://www.webdiva.org ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT- Hosting recommendations
Yes I use them too (advances.com) and LOVE them, their prices are great and I have had NO CF or SQL problems, they even let me install custom dll tags etc... Very helpful support. Kelly -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:54 AM To: CF-Talk Subject: RE: OT- Hosting recommendations Try www.advances.com -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 8:48 PM To: CF-Talk Subject: OT- Hosting recommendations I'm looking to move my smaller clients to a new hosting company, because of support issues and restrictions on what I can and can't do where I am now. There are about 20 domains involved, and I'm thinking of using Sitebysize.com in Texas. Has anyone had any experience with them? What I need are: CF, SQLServer, ability to control my domains, mail accounts, etc myself from the web, low cost (which rules out any Australian hosting companies), and a responsive support department (my biggest complaint about my current host). Cheers, Mike Kear AFP Webworks, Windsor, NSW, Australia. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Quotes?
Double quotes is already the preferred method. I would use cfparam name=myOtherVar default=The car made a loud bang! sound. Just my personal preference. -Original Message- From: Christian Abad [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 4:42 PM To: CF-Talk Subject: Quotes? Folks: I have some questions concerning the correct usage of single versus double-quotes. First, I need to know if CF or HTML cares if attributes are single-quoted or double quoted? It appears: cfparam name=myVar default=123 works the same as: cfparam name='myVar' default='123' and: a href=myPage.cfm works the same as: a href='myPage.cfm' Is there a preferred method? What about: cfparam name='myOtherVar' default='The car made a loud bang! sound.' and: cfparam name=myOtherVar default=The car made a loud bang! sound. Is there a correct way to code quoted strings? Any insight would be _greatly_ appreciated! Thanks! Christian N. Abad ColdFusion Web Developer ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Why aren't there more CF programmers out there?
well if he thinks Front page is the way to go then he also wouldn't have a clue as to how many CF programmers are truly out there... Frontpage is the DEVIL! -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 17:40 To: CF-Talk Subject: Why aren't there more CF programmers out there? A higher up said If ColdFusion was so easy to learn why aren't there more CF programmers out there? So what do I tell him? How many CF Developers are there? How many sites use CF? Is there a Macromedia rep in the house? He thinks FrontPage is the way to go Let the games begin! ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Deleting DB Records Automatically ???
Sure you could set up a scheduled task in CF (say once a day at midnight) that runs a page that then runs a query deleting all records whose itemexpires date is less than NOW(). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 2:47 PM To: CF-Talk Subject: Deleting DB Records Automatically ??? Hi I have a field in my database table called 'itemexpires' which contains a date field i.e. 17 November 2001. What I would like to do is when the date is reached in the date field ie if a record had a value in the 'itemexpires' field of 21 November 2001 this entire record would be automatically deleted from the database a day later (22nd November) 1.) Can this be done with Coldfusion? 2.) How can it be achieved? TIA ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Event Logs Win2000
This program does it but isn't free of course :) http://www.logviewer.com -Original Message- From: Tim Stadinski [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 2:33 PM To: CF-Talk Subject: Event Logs Win2000 Does anyone know where I can look for reference on how to connect to the windows event logs programmatically? I bascially need to have a utility that can search through the event logs on some web servers and was hoping to tie this to a CF app. Thanks. Timothy Stadinski Senior Software Engineer Afternic.com [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Event Logs Win2000
I have searched high and low and everywhere in between for a free one, have yet to find one, if you do please pass it on. :) Kelly -Original Message- From: Tim Stadinski [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 2:46 PM To: CF-Talk Subject: RE: Event Logs Win2000 I was hoping for a free reference to a discussion resource on which COM object I need to play with to tie into the eventLog anyone else? tim -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 2:37 PM To: CF-Talk Subject: RE: Event Logs Win2000 This program does it but isn't free of course :) http://www.logviewer.com -Original Message- From: Tim Stadinski [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 2:33 PM To: CF-Talk Subject: Event Logs Win2000 Does anyone know where I can look for reference on how to connect to the windows event logs programmatically? I bascially need to have a utility that can search through the event logs on some web servers and was hoping to tie this to a CF app. Thanks. Timothy Stadinski Senior Software Engineer Afternic.com [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
