Re: Handling invalid recipient in mailing list

[Kelly Matthews]

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. It’s so much cheaper. I do use a software 
program called Sendy
 in conjunction with Amazon which cost $50 (one time). 

Just thought I’d mention it, but it’s about 2% of the cost to send emails. 

Kelly


> On Apr 3, 2015, at 10:29 AM, Rob Voyle  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?

[Kelly Matthews]

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  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  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

[Kelly Matthews]

Yeah they are really great guys!  And $10 for a full month of manage support is 
a STEAL. :) I’ve used it on a month by month basis a couple times when I’ve 
needed to.  


On Apr 1, 2014, at 10:02 AM, Cameron Childress  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  |
> twitter |
> google+ 
> 
> 
> 

~|
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?

[Kelly Matthews]

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: Viviotech?

[Kelly Matthews]

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: Hosting... Again

[Kelly Matthews]

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

[Kelly Matthews]

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

[Kelly Matthews]

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  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?

[Kelly Matthews]

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
>> Thursday, 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"  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: hostek - server down?

[Kelly Matthews]

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: Very disappointing statis

[Kelly Matthews]

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

[Kelly Matthews]

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

Re: cfdocument and page-break-inside: avoid

[Kelly Matthews]

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

Form Validation Issue using cfinput AND jquery

[Kelly Matthews]

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

[Kelly Matthews]

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

Re: How would I do this in SQL?

[Kelly Matthews]

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: How would I do this in SQL?

[Kelly Matthews]

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  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

How would I do this in SQL?

[Kelly Matthews]

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.


  
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




update categories
set hasproducts = 
where category =  

OR category =   
 



select parent_id 
from categories 
where category = 



update categories
set hasproducts = 
where category = 


select parent_id 
from categories 
where category = 



update categories
set hasproducts = 
where category = 


select parent_id 
from categories 
where category = 



update categories
set hasproducts = 
where category = 


select parent_id 
from categories 
where category = 




update 
categories
set hasproducts 
= 
where category 
= 


select 
parent_id 
from categories 
where category 
= 


update 
categories
set hasproducts 
= 
where category 
= 






 

~|
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:341556
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscr

Re: why is cf_builder so expensive?

[Kelly Matthews]

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 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:341315
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: favorite coldfusion host

[Kelly Matthews]

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  
> 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: Custom Tags, cf_location

[Kelly Matthews]

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"  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: Custom Tags, cf_location

[Kelly Matthews]

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

[Kelly Matthews]

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

[Kelly Matthews]

um... then why not use:
 
addtoken="no" doesn't add the unnecessary cftoken

> Because the website that I'm working with has thousands of 
> 's. My entire reason for using  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: (ot) Server Setup Opinions

[Kelly Matthews]

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: (ot) Server Setup Opinions

[Kelly Matthews]

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

[Kelly Matthews]

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

[Kelly Matthews]

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

[Kelly Matthews]

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: US Government moving to Drupal?

[Kelly Matthews]

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?

[Kelly Matthews]

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=mce&EDITOR_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  
> 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

Re: CF 9 Hosting

[Kelly Matthews]

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  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 9 Hosting

[Kelly Matthews]

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  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

CF 9 Hosting

[Kelly Matthews]

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

2 Queries into one?

[Kelly Matthews]

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    DISTINCT  b.id, b.qnum, b.firstname, b.lastname, b.ssn, c.phase, c.disbursed_date
	FROM faLoans 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
	FROM  Import_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?

[Kelly Matthews]

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    DISTINCT  b.id, b.qnum, b.firstname, b.lastname, b.ssn, c.phase, c.disbursed_date
	FROM faLoans 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
	FROM  Import_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?

[Kelly Matthews]

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    DISTINCT  b.id, b.qnum, b.firstname, b.lastname, b.ssn, c.phase, c.disbursed_date
	FROM faLoans 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
	FROM  Import_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]

Re: Help with Date Stuff

[Kelly Matthews]

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  is where that would
>need to display.
>
> 
>
>default="#dateformat(Createdate(year,month,1),'mm/dd/yy')#">
>
>
>
>
>
> 
>
>
>
>width="600">
>
>
>exec sp_emailreports '#startdate#','#enddate#','OSI',#count#
>
>
>OSI Single StepTwo Step
>Phase 1Two Step Phase 2
>
>Name
>ID
>Status
>Type
>Date
> 
>
>
> 
>
>
>
>
>
>
>
>
>
>
>
>#firstname# #lastname#
>#ID#
>#status#
>#description#
>#displaydate#
>
>
>
> 
> 
>
> 
>
>
>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]

Help with Date Stuff

[Kelly Matthews]

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  is where that would need to display.

 






		 
	
	
		

		
			exec sp_emailreports '#startdate#','#enddate#','OSI',#count#
		
			
OSI Single StepTwo Step Phase 1Two Step Phase 2
			
Name
ID
Status
Type
Date



 
	
	
		
		
		
		
		
		
		
		
		
		#firstname# #lastname#
		#ID#
		#status#
		#description#
		#displaydate#
		
		
		
			
	
		
	


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

[Kelly Matthews]

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]

Re:CFFILE Question

[Kelly Matthews]

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:CFFILE Question

[Kelly Matthews]

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 
>
>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
> 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 
>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]

CFFILE Question

[Kelly Matthews]

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 

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
 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  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:Regular Expression Help (Ben)

[Kelly Matthews]

Hi Ben, Version MX and here is the exact text i am working withWednesday, January 01, 2003  8:49 PM   125072 So for that above line I need to remove this:but leave the CIMG0131.JPG. Each line is different however so basically i need to keep the text between the > and as well as everything before the Hope that makes sense. :)
 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

CF Hosting space available

[Kelly Matthews]

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=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Help Please: Find/Replace

[Kelly Matthews]

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, '\[([^]]+)\]', '\1', '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 : href="http://www.whatever.com";>http://www.whatever.com 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=subscribe&forumid=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

[Kelly Matthews]

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 http://www.whatever.com";>http://www.whatever.com 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=subscribe&forumid=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: One More Question Re: Is there a Better Way to do this?

[Kelly Matthews]

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=subscribe&forumid=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

Figured it out

[Kelly Matthews]

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=subscribe&forumid=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

One More Question Re: Is there a Better Way to do this?

[Kelly Matthews]

ok right now i am doing this





SELECT DISTINCT DJ_Dictionary.Word
FROM DJ_Dictionary
WHERE '#dreamtext#' LIKE '% ' + DJ_Dictionary.Word + ' %'
ORDER BY DJ_Dictionary.Word

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=subscribe&forumid=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?

[Kelly Matthews]

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:
>
>\2","ALL")>
>\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:
>
>
>   exec sp_DreamNewLookup
>   @txt_dream = ' #REReplace(dreamtext,"[^ [:alpha:]]"," ","ALL")# ';
>
>
>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=subscribe&forumid=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=subscribe&forumid=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?

[Kelly Matthews]

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=subscribe&forumid=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

Is there a Better Way to do this?

[Kelly Matthews]

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

SELECT word
from dictionary


THen we grab a dream

SELECT dream
from dreams
where dream_id = 3


Then I Loop through like so:

Then I check to see if the dream contains the word.

Then I grab the definition if it found that word.

SELECT definition from dictionary
where word = '#theword#'

Then I display it #theword##getdef.definition#



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=subscribe&forumid=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: RE: Next/Previous???

[Kelly Matthews]

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..
>
>-
>
>
>
>
>
>
>   PROBLEMS!
>   
>
>
>
>   SomeQuery
>
>
>MaxRows="#MyMaxRows#">
>   Some output
>
>
>
>   
>   Previous #MyMaxRows#
>   
>
>
>
>   
>   Next #MyMaxRows#
>   
>



~~
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???

[Kelly Matthews]

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

Next/Previous???

[Kelly Matthews]

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: simple cfloop

[Kelly Matthews]

Yep in is much better, quicker too!

[EMAIL PROTECTED] writes:
>
>SELECT this, that, theotherthing
>FROM tblName
>WHERE ID IN (#id#)
>
>
>
>#this##that##theotherthing#
>


~~
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 tag not found...

[Kelly Matthews]

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

Re: CyberCash

[Kelly Matthews]

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

[Kelly Matthews]

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

Problem w/ CFFILE...

[Kelly Matthews]

I haven't run across this error before.
On my form I have this:
Logo:


Which allows for me to upload a file. I basically click Browse and find the
image.

The action page has:





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

[Kelly Matthews]

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

RE: Help with resolving a variable...

[Kelly Matthews]

actually what I did was 

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



or



-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
 That gives an error  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:
>
> 
> 
>  style="background: white">
>  style="background: BBE9FF">
>  style="background: 9DCBFF">
> 
>
>  style="background: white">
>  style="background: BBE9FF">
>  style="background: 9DCBFF">
> 
>
>  style="background: white">
>  style="background: BBE9FF">
>  style="background: 9DCBFF"> name="#trim(Surname)#_Extr" value="4" style="background: 5785FF"> 
>  
>  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:
> 
> 
> 
>  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??
> 
> 



__
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...

[Kelly Matthews]

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:
>
> 
> 
>  style="background: white">
>  style="background: BBE9FF">
>  style="background: 9DCBFF">
> 
>
>  style="background: white">
>  style="background: BBE9FF">
>  style="background: 9DCBFF">
> 
>
>  style="background: white">
>  style="background: BBE9FF">
>  style="background: 9DCBFF"> name="#trim(Surname)#_Extr" value="4" style="background: 5785FF"> 
>  
>  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:
> 
> 
> 
>  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??
> 
> 

__
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...

[Kelly Matthews]

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

That gives an error

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:
>
> 
> 
>  style="background: white">
>  style="background: BBE9FF">
>  style="background: 9DCBFF">
> 
>
>  style="background: white">
>  style="background: BBE9FF">
>  style="background: 9DCBFF">
> 
>
>  style="background: white">
>  style="background: BBE9FF">
>  style="background: 9DCBFF"> name="#trim(Surname)#_Extr" value="4" style="background: 5785FF"> 
>  
>  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:
> 
> 
> 
>  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??
> 
> 

__
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...

[Kelly Matthews]

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:
>
> 
> 
>  style="background: white">
>  style="background: BBE9FF">
>  style="background: 9DCBFF">
> 
>
>  style="background: white">
>  style="background: BBE9FF">
>  style="background: 9DCBFF">
> 
>
>  style="background: white">
>  style="background: BBE9FF">
>  style="background: 9DCBFF"> name="#trim(Surname)#_Extr" value="4" style="background: 5785FF"> 
>  
>  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:
> 
> 
> 
>  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??
> 
> 

__
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...

[Kelly Matthews]

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:


















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:



 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??

__
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?

[Kelly Matthews]

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

 it's good! 

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

Verify password is alpha numeric?

[Kelly Matthews]

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: Is Their a Standard Way of Preventing Users from Entering Dou ble Records by Refreshing Browser?

[Kelly Matthews]

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: Better Javascript/DHTML Calender!

[Kelly Matthews]

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: CFLOCK on files

[Kelly Matthews]

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:

[Kelly Matthews]

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: 


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


SELECT srf_date_created
FROM   samprequest


 

UPDATE samprequest
SET srf_date_fu = #DateAdd('ww', 2, (srf_date_created))# 



__
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

[Kelly Matthews]

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
, 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. , , , 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

null characters in a file

[Kelly Matthews]

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

Help reading a file using CFFILE Binary/Hex etc problems....

[Kelly Matthews]

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:



#test#

Then I played around with using READBINARY




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

RE: SQL Licensing/User Question

[Kelly Matthews]

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 Licensing/User Question

[Kelly Matthews]

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

SQL Licensing/User Question

[Kelly Matthews]

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: EXCEL Question Spaces in Field names

[Kelly Matthews]

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


SELECT *
FROM RESULTS




UPDATE STORAGE
SET 
FLAG = '#info['case status'][curRow]#',
LNAME = '#LAST NAME#',
FNAME = '#FIRST NAME#',
MNAME = '#MIDDLE NAME#',
SUFFIX = '#SUFFIX#',
CASENUM = '#CASE NUMBER#',

DATECLOSED = '#STATUS DATE#'

DATESCHEDULED = '#STATUS DATE#'

WHERE SON = '#son#'
AND SSN = 11223#SSN#

 

-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:

UPDATE TABLE
SET CASENUM = '#CASE NUMBER#'
WHERE WHATEVER = WHATEVER

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

[Kelly Matthews]

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


SELECT *
FROM RESULTS




UPDATE STORAGE
SET 
FLAG = '#info['case status'][curRow]#',
LNAME = '#LAST NAME#',
FNAME = '#FIRST NAME#',
MNAME = '#MIDDLE NAME#',
SUFFIX = '#SUFFIX#',
CASENUM = '#CASE NUMBER#',

DATECLOSED = '#STATUS DATE#'

DATESCHEDULED = '#STATUS DATE#'

WHERE SON = '#son#'
AND SSN = 11223#SSN#

 

-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:

UPDATE TABLE
SET CASENUM = '#CASE NUMBER#'
WHERE WHATEVER = WHATEVER

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

EXCEL Question Spaces in Field names

[Kelly Matthews]

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:

UPDATE TABLE
SET CASENUM = '#CASE NUMBER#'
WHERE WHATEVER = WHATEVER

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: SQL Transaction Logs...?

[Kelly Matthews]

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

SQL Transaction Logs...?

[Kelly Matthews]

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

RE: SOLVED - HELP CFTRY/CFCATCH/CFDIRECTORY problem

[Kelly Matthews]

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

RE: HELP CFTRY/CFCATCH/CFDIRECTORY problem

[Kelly Matthews]

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...



   
  
 



 
 
  
 



 
 
  An Error has occurred
 


-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

HELP CFTRY/CFCATCH/CFDIRECTORY problem

[Kelly Matthews]

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  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:

 
  
 
 

 
 
  

  

An Error has occurred

 

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

Anyone else get solicited? FW: CFX ImageCR

[Kelly Matthews]

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 within - but I need to

[Kelly Matthews]

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 ===

select *
from tblA



select *
from tblB





Member Name: 


Member Level:





#fldName#

 you can also do *


SELECTED>#fldName#


Then if you have more fields just open the other output again.

ETC ETC ETC





-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 07, 2001 5:18 PM
To: CF-Talk
Subject: No  within  - 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  section. But the
dropdown box is itself to be inserted within another 
section of the page.

I've tried using  above the first  section to make a
variable that I can embed with the second  section. The problem
with that is I can't do a  within the  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 ===

select *
from tblA



select *
from tblB





Member Name: 


Member Level:





#fldName#







=== 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

Question about Inserting into SQL via CF... Binary file or Image File

[Kelly Matthews]

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: Random passwords

[Kelly Matthews]

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:


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

[Kelly Matthews]

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: CF Hosting Company...

[Kelly Matthews]

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

RE: Quotes?

[Kelly Matthews]

Double quotes is already the preferred method.
I would use 
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:


works the same as:


and:


works the same as:


Is there a preferred method?

What about:


and:


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: OT- Hosting recommendations

[Kelly Matthews]

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: "Why aren't there more CF programmers out there?"

[Kelly Matthews]

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 ???

[Kelly Matthews]

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: How do I prevent a user from backing up to a previous page.

[Kelly Matthews]

There are a couple things you can do.  You can clear the struct out
automatically after you 
do whatever you are doing with it on the next page so if they do hit back
it's cleared out.
OR if it's being put into some database you can always double check upon
entering that they
aren't submitting info that was just submitted. We ran into this before and
simply set
a session variable on the 2nd page (after all the data was done being
processed) so if they do hit back and try to submit again and it notices
that session variable is set and we throw an error.
Kelly

-Original Message-
From: Bill Mee [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 19, 2001 4:40 PM
To: CF-Talk
Subject: How do I prevent a user from backing up to a previous page.


Aside from both expiring and disabling caching of a previously visited page
I want to warn the user that when they depresss the backup button on the web
browser that the previous page has expired. I am progressively gathering
data on subsequent pages which is entered into a struct array and I do not
want the user to reenter the same data into the struct (passed in a wddx
client vaiable) which will happen if they backup then move forward.

Any ideas on how to deal with this?

Bill

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
~~
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: Fusebox - opinions?

[Kelly Matthews]

Personally I use fusebox and like it but it's a scaled down version of
fusebox, I kinda modified it to my liking... Haven't run into problems yet
but I don't have any SUPER high traffic cf sites.
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: Event Logs Win2000

[Kelly Matthews]

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