RE: Smart or Stupid (CFLOOP as a GOTO)
> -Original Message- > From: Mike Kear [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 28, 2003 2:08 AM > To: CF-Talk > Subject: RE: Smart or Stupid (CFLOOP as a GOTO) > > Bluntness and forthfightness are what I'm well known for and it's made me > lots of trouble over the years, but it does save a lot of time. I still > got > my point across didn't I, even if it doesn't apply to this specific field. I'm pretty sure that getting a point across that has nothing to do with the topic at hand isn't something to be particularly proud of. > No offence intended. None taken. How could I when you were actually unable to say anything about the topic at hand? This wasn't actually blunt, forthright or tactless - it was Tourette Syndrome. Jim Davis, still tired and cranky. ~| 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: Smart or Stupid (CFLOOP as a GOTO)
Well it'll be a wonderful day, and make my tired old mother smile with satisfaction if the day ever comes when someone says I'm tactful. Bluntness and forthfightness are what I'm well known for and it's made me lots of trouble over the years, but it does save a lot of time. I still got my point across didn't I, even if it doesn't apply to this specific field. No offence intended. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Saturday, 28 June 2003 1:27 PM To: CF-Talk Subject: RE: Smart or Stupid (CFLOOP as a GOTO) > -Original Message- > From: Mike Kear [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 10:42 PM > To: CF-Talk > Subject: RE: Smart or Stupid (CFLOOP as a GOTO) > > When you're done, can you let us know which site it is, so I'll put it on > my > list of sites never to go to? I HATE forms that tell me somethings wrong, > I > correct that, then it says something else is wrong. As I've already told Jochem (who made the same comment, only far more tactfully) this for a SINGLE FIELD. The email field (a SINGLE FIELD) for example might: 1) Need to be populated. 2) Need to be less than 255 characters 3) Need to follow general email format. 4) Need to be checked against the database. You would NEVER want all four of these situations to be shown at once. You want the system to validate until it finds an error then STOP (you don't check the database if there's no value for example). You store than error, then check the other fields (which may themselves have many validations). So a single form MAY display multiple issues - but a single FIELD would only display one. You are still left with the potential for several iteration of a form. They forget the email here, but here it's been found not to be unique. But if you still want to stay away from the sites here they are: www.depressedpres.com www.cfadvocacy.org www.firstnight.org Jim Davis, tired and cranky. ~| 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: Is there a way to test to see if a data source exists?
I guess you would just make a call to the datasource within a cftry block and catch the error with cfcatch if it does not exist.. -Original Message- From: CF Dude [mailto:[EMAIL PROTECTED] Sent: Saturday, 28 June 2003 12:12 PM To: CF-Talk Subject: Re: Is there a way to test to see if a data source exists? >I'm not sure why it would be an "obvious" - are you talking about a >specific database with known tables, or just an unknown datasource? Yes. I really can't imagine anybody building a web app that will give a user the option of connecting to some random unknown datasource. Know what I mean? I would imagine that there is some sort of idea which datasources will be given as options, and appropriate actions can be taken. E ~| 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: Smart or Stupid (CFLOOP as a GOTO)
Yup. > -Original Message- > From: Matt Blatchley ~ Bridgeleaf Studios [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 11:33 PM > To: CF-Talk > Subject: RE: Smart or Stupid (CFLOOP as a GOTO) > > Jim, > > Are you Tired and Cranky in New England? > > > > -Original Message- > From: Jim Davis [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 10:27 PM > To: CF-Talk > Subject: RE: Smart or Stupid (CFLOOP as a GOTO) > > > > -Original Message- > > From: Mike Kear [mailto:[EMAIL PROTECTED] > > Sent: Friday, June 27, 2003 10:42 PM > > To: CF-Talk > > Subject: RE: Smart or Stupid (CFLOOP as a GOTO) > > > > When you're done, can you let us know which site it is, so I'll put it > on > > my > > list of sites never to go to? I HATE forms that tell me somethings > wrong, > > I > > correct that, then it says something else is wrong. > > As I've already told Jochem (who made the same comment, only far more > tactfully) this for a SINGLE FIELD. > > The email field (a SINGLE FIELD) for example might: > > 1) Need to be populated. > > 2) Need to be less than 255 characters > > 3) Need to follow general email format. > > 4) Need to be checked against the database. > > You would NEVER want all four of these situations to be shown at once. > You > want the system to validate until it finds an error then STOP (you don't > check the database if there's no value for example). You store than > error, > then check the other fields (which may themselves have many validations). > > So a single form MAY display multiple issues - but a single FIELD would > only > display one. > > You are still left with the potential for several iteration of a form. > They > forget the email here, but here it's been found not to be unique. > > But if you still want to stay away from the sites here they are: > > www.depressedpres.com > www.cfadvocacy.org > www.firstnight.org > > Jim Davis, tired and cranky. > > > > ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem setting dynamic links in variables
Thanks for the suggestion, but it doesn't look like it will work. I think I need double quotes. The processing page searches through HTML code that has been generated in HTMLArea looking for an exact match and HTMLArea (actually I believe it's the rich text editing functions in IE) automatically converts to double quotes. Any other ideas? Terry--Tired & Cranky in Utah -Original Message- From: Matt Blatchley ~ Bridgeleaf Studios [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 9:23 PM To: CF-Talk Subject: RE: Problem setting dynamic links in variables Is that what your looking for? -Original Message- From: Terry Hogan [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:01 PM To: CF-Talk Subject: Problem setting dynamic links in variables I'm trying to set a variable that will be passed to a form field something like: " & #LinkName# & ""> I've tried escaping the quotes in various ways double quotes, single quotes, etc. The real choker seems to be the "> needed between #contentID# and #LinkName#. ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Smart or Stupid (CFLOOP as a GOTO)
Jim, Are you Tired and Cranky in New England? -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:27 PM To: CF-Talk Subject: RE: Smart or Stupid (CFLOOP as a GOTO) > -Original Message- > From: Mike Kear [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 10:42 PM > To: CF-Talk > Subject: RE: Smart or Stupid (CFLOOP as a GOTO) > > When you're done, can you let us know which site it is, so I'll put it on > my > list of sites never to go to? I HATE forms that tell me somethings wrong, > I > correct that, then it says something else is wrong. As I've already told Jochem (who made the same comment, only far more tactfully) this for a SINGLE FIELD. The email field (a SINGLE FIELD) for example might: 1) Need to be populated. 2) Need to be less than 255 characters 3) Need to follow general email format. 4) Need to be checked against the database. You would NEVER want all four of these situations to be shown at once. You want the system to validate until it finds an error then STOP (you don't check the database if there's no value for example). You store than error, then check the other fields (which may themselves have many validations). So a single form MAY display multiple issues - but a single FIELD would only display one. You are still left with the potential for several iteration of a form. They forget the email here, but here it's been found not to be unique. But if you still want to stay away from the sites here they are: www.depressedpres.com www.cfadvocacy.org www.firstnight.org Jim Davis, tired and cranky. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Smart or Stupid (CFLOOP as a GOTO)
> -Original Message- > From: Mike Kear [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 10:42 PM > To: CF-Talk > Subject: RE: Smart or Stupid (CFLOOP as a GOTO) > > When you're done, can you let us know which site it is, so I'll put it on > my > list of sites never to go to? I HATE forms that tell me somethings wrong, > I > correct that, then it says something else is wrong. As I've already told Jochem (who made the same comment, only far more tactfully) this for a SINGLE FIELD. The email field (a SINGLE FIELD) for example might: 1) Need to be populated. 2) Need to be less than 255 characters 3) Need to follow general email format. 4) Need to be checked against the database. You would NEVER want all four of these situations to be shown at once. You want the system to validate until it finds an error then STOP (you don't check the database if there's no value for example). You store than error, then check the other fields (which may themselves have many validations). So a single form MAY display multiple issues - but a single FIELD would only display one. You are still left with the potential for several iteration of a form. They forget the email here, but here it's been found not to be unique. But if you still want to stay away from the sites here they are: www.depressedpres.com www.cfadvocacy.org www.firstnight.org Jim Davis, tired and cranky. ~| 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: Problem setting dynamic links in variables
Is that what your looking for? -Original Message- From: Terry Hogan [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:01 PM To: CF-Talk Subject: Problem setting dynamic links in variables I'm trying to set a variable that will be passed to a form field something like: " & #LinkName# & ""> I've tried escaping the quotes in various ways double quotes, single quotes, etc. The real choker seems to be the "> needed between #contentID# and #LinkName#. ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem setting dynamic links in variables
I'm trying to set a variable that will be passed to a form field something like: " & #LinkName# & ""> I've tried escaping the quotes in various ways double quotes, single quotes, etc. The real choker seems to be the "> needed between #contentID# and #LinkName#. ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Smart or Stupid (CFLOOP as a GOTO)
When you're done, can you let us know which site it is, so I'll put it on my list of sites never to go to? I HATE forms that tell me somethings wrong, I correct that, then it says something else is wrong. Then when I go back, usually my last input is removed from the form so I have to fill it all out again. Yahoo mail is like that. It can take half an hour or more to create a yahoo mail account. You have to go back and change something, and when you do, you don't notice that a checkbox is no longer selected, or it's changed the country back to the default of USA and therefore you haven't entered a valid zipcode. I strongly urge you to think about giving the user all the things that are wrong with his form, WITH the form below it with all the previous entries already filled out, so they only have to correct the errors and they can proceed. It's much better that way. You'll have less user rage. Please? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=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: Smart or Stupid (CFLOOP as a GOTO)
Sure, but that's why you loop over the validation types as well.
something like...
valStruct.email = listToArray("null,maxlength,email");
valStruct.email.value = "[EMAIL PROTECTED]";
valid = true;
while(valid) {
valid = true;
for(i = 1; i LT arrayLen(valStruct.email), i = i + 1) {
switch(vType[i]) {
case "null":
valid = isNull(valStruct.email.value);
if (NOT valid)
break;
case "maxlength":
valid = checkLength(valStruct.email.value);
if (NOT valid)
break;
etc...
}
if (NOT valid)
break;
}
}
This is very generally the best form validation routine
I've been able to come up with in CF, at least until the form
collection becomes an object itself. Of course if you are not on
MX...you can't do cfquery's in UDF's, so perhaps the best angle would
be to have each validation type a custom tag...
Wouldn't it be cool though if we could have a loop watched a
particular variable/method for an event? Like if a particular variable
changed...the event is fired which breaks the loop immediately.
--
mailto:[EMAIL PROTECTED]
Friday, June 27, 2003, 7:43:54 PM, you wrote:
JD> That's only checked (as far as I understand it) before each iteration, not
JD> throughout the processing.
JD> In other words setting "theform" equal to "invalid" will not stop processing
JD> immediately - it will finish out the rest of the code in the loop THEN stop.
JD> Jim Davis
>> -Original Message-
>> From: Kwang Suh [mailto:[EMAIL PROTECTED]
>> Sent: Friday, June 27, 2003 7:36 PM
>> To: CF-Talk
>> Subject: Re: Smart or Stupid (CFLOOP as a GOTO)
>>
>> Why not use the condition attribute?
>>
>>
>>
>> - Original Message -
>> From: "Jim Davis" <[EMAIL PROTECTED]>
>> To: "CF-Talk" <[EMAIL PROTECTED]>
>> Sent: Friday, June 27, 2003 5:26 PM
>> Subject: Smart or Stupid (CFLOOP as a GOTO)
>>
>>
>> > This may be a VERY dumb question, but I'm brain fried.
>> >
>> > Okay - so I'm working on a form and I need to validate fields for many
>> > things. Taking "email address" for example I need to validate that it's
>> > been filled in (not zero length), that it's less than 255 characters
>> (the
>> > database limit), that it fits a email format and finally that the email
>> > address isn't already in use.
>> >
>> > What I'd like to be able to do is check through all these validations.
>> The
>> > instant a problem is found I want to stop checking. I would then
>> redisplay
>> > the form and so forth.
>> >
>> > In a custom tag or function I might, when an error is found simply
>> "return"
>> > to the caller with the error information. Since this is a rather small
>> set
>> > and is only the first of many small forms I decided (perhaps wrongly) to
>> > just do the validation at the top of the page.
>> >
>> > To simulate a components ability to return at any point I wrapped the
>> whole
>> > validation block in a CFLOOP from 1 to 1 (1 iteration) - as soon as I
>> hit
>> an
>> > error (and set the error variable) I CFBREAK. Right after the loop I
>> check
>> > the value of the error variable.
>> >
>> > Now that I'm looking at it I'm not sure... is this just the stupidest
>> thing
>> > you're ever heard? Should I take the extra time and create a customized
>> > validation custom tag for each and every form?
>> >
>> > Jim Davis
>> >
>> >
>>
JD>
~|
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
Host with the leader in ColdFusion hosting.
Voted #1 ColdFusion host by CF Developers.
Offering shared and dedicated hosting options.
www.cfxhosting.com/default.cfm?redirect=10481
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is there a way to test to see if a data source exists?
>I'm not sure why it would be an "obvious" - are you talking about a specific database >with known tables, or just an unknown datasource? Yes. I really can't imagine anybody building a web app that will give a user the option of connecting to some random unknown datasource. Know what I mean? I would imagine that there is some sort of idea which datasources will be given as options, and appropriate actions can be taken. E ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Overriding Request Timeout in CFAdmin
> Yes, but a better practice would be to use the tag and set the > timeout in the template itself. > Actually, I don't think you can use the URL string, regardless. In MX, to use the requestTimeOut, you must specify it in the cfsetting tag. At least, that's been my experience using MX for J2EE on JRun. Regards, Dave. ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Smart or Stupid (CFLOOP as a GOTO)
Ususally I stick to the if than else routine, but I think I'd try the different options mentioned here and see what works better. I'll bet it looks a hell of a lot cleaner :) -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 8:54 PM To: CF-Talk Subject: RE: Smart or Stupid (CFLOOP as a GOTO) > -Original Message- > From: Matt Blatchley ~ Bridgeleaf Studios [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 9:51 PM > To: CF-Talk > Subject: RE: Smart or Stupid (CFLOOP as a GOTO) > > Why not just use JavaScript client side and then use CF server side? JavaScript will be added later - but first I want to ensure that lacking script everything still works as it should (a practice I highly recommend). Jim Davis ~| 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: Smart or Stupid (CFLOOP as a GOTO)
> -Original Message- > From: Matt Blatchley ~ Bridgeleaf Studios [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 9:51 PM > To: CF-Talk > Subject: RE: Smart or Stupid (CFLOOP as a GOTO) > > Why not just use JavaScript client side and then use CF server side? JavaScript will be added later - but first I want to ensure that lacking script everything still works as it should (a practice I highly recommend). Jim Davis ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Smart or Stupid (CFLOOP as a GOTO)
Why not just use JavaScript client side and then use CF server side? -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 8:03 PM To: CF-Talk Subject: RE: Smart or Stupid (CFLOOP as a GOTO) I could - I was just hoping for a quick(er) fix. I guess I'm also being a little silly... thinking that CFTRY is only for "pure" errors, not validation rules... But I probably should use it... it does make perfect sense. Jim Davis > -Original Message- > From: Scott Brady [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 7:53 PM > To: CF-Talk > Subject: Re: Smart or Stupid (CFLOOP as a GOTO) > > - Original Message - > From: "Jim Davis" <[EMAIL PROTECTED]> > > > That's only checked (as far as I understand it) before each iteration, > not > > throughout the processing. > > > > In other words setting "theform" equal to "invalid" will not stop > processing > > immediately - it will finish out the rest of the code in the loop THEN > stop. > > > What about using a cftry/catch block? > > Put a cftry around it (forget the loop entirely). When you encounter a > validation issue, cfthrow with your error message. Then, in the cfcatch, > do > what you need to do when you want to stop the processing. > > > > > > > > #cfcatch.message# > > > > > --- > Scott Brady > http://www.scottbrady.net > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Overriding Request Timeout in CFAdmin
Yes, but a better practice would be to use the tag and set the timeout in the template itself. -Novak - Original Message - From: "Stacy Young" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 5:37 AM Subject: Overriding Request Timeout in CFAdmin > Setting the request timeout in the query string will override the > default setting in the CF Admin, correct? > > Thx > > Stace > > > AVIS IMPORTANT: > --- > Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme.. > > WARNING: > --- > The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. > > ~| 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: Image Editor
http://www.imagemagick.org -Novak - Original Message - From: "Cedric Villat" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 26, 2003 9:41 PM Subject: Image Editor > Anyone know of an image editor, like resizing gifs/jpgs, etc, that will work > on a unix/linux server? It also has to work on CF5. Any recommendations? > > Cedric > > > ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Smart or Stupid (CFLOOP as a GOTO)
I could - I was just hoping for a quick(er) fix. I guess I'm also being a little silly... thinking that CFTRY is only for "pure" errors, not validation rules... But I probably should use it... it does make perfect sense. Jim Davis > -Original Message- > From: Scott Brady [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 7:53 PM > To: CF-Talk > Subject: Re: Smart or Stupid (CFLOOP as a GOTO) > > - Original Message - > From: "Jim Davis" <[EMAIL PROTECTED]> > > > That's only checked (as far as I understand it) before each iteration, > not > > throughout the processing. > > > > In other words setting "theform" equal to "invalid" will not stop > processing > > immediately - it will finish out the rest of the code in the loop THEN > stop. > > > What about using a cftry/catch block? > > Put a cftry around it (forget the loop entirely). When you encounter a > validation issue, cfthrow with your error message. Then, in the cfcatch, > do > what you need to do when you want to stop the processing. > > > > > > > > #cfcatch.message# > > > > > --- > Scott Brady > http://www.scottbrady.net > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Smart or Stupid (CFLOOP as a GOTO)
> -Original Message- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 7:52 PM > To: CF-Talk > Subject: Re: Smart or Stupid (CFLOOP as a GOTO) > > Jim Davis wrote: > > > > Okay - so I'm working on a form and I need to validate fields for many > > things. Taking "email address" for example I need to validate that it's > > been filled in (not zero length), that it's less than 255 characters > (the > > database limit), that it fits a email format and finally that the email > > address isn't already in use. > > > > What I'd like to be able to do is check through all these validations. > The > > instant a problem is found I want to stop checking. I would then > redisplay > > the form and so forth. > > I think checking all the input and then displaying all the errors at > once provides a much better user experience. This is more for multiple validations on a single field. So, for example, if there's no email address entered I don't want to go though the process of checking to see if it's in the DB. I could do this with a lot of CFIF logic, but I was looking for a way to bail out totally ignoring further checks (for the same field). Jim Davis ~| 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: Smart or Stupid (CFLOOP as a GOTO)
Jim Davis wrote: > > Okay - so I'm working on a form and I need to validate fields for many > things. Taking "email address" for example I need to validate that it's > been filled in (not zero length), that it's less than 255 characters (the > database limit), that it fits a email format and finally that the email > address isn't already in use. > > What I'd like to be able to do is check through all these validations. The > instant a problem is found I want to stop checking. I would then redisplay > the form and so forth. I think checking all the input and then displaying all the errors at once provides a much better user experience. Jochem ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Smart or Stupid (CFLOOP as a GOTO)
- Original Message - From: "Jim Davis" <[EMAIL PROTECTED]> > That's only checked (as far as I understand it) before each iteration, not > throughout the processing. > > In other words setting "theform" equal to "invalid" will not stop processing > immediately - it will finish out the rest of the code in the loop THEN stop. What about using a cftry/catch block? Put a cftry around it (forget the loop entirely). When you encounter a validation issue, cfthrow with your error message. Then, in the cfcatch, do what you need to do when you want to stop the processing. #cfcatch.message# --- Scott Brady http://www.scottbrady.net ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=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: Smart or Stupid (CFLOOP as a GOTO)
That's a really clever idea. I'm a FB guy so I never really been in that situation (and I usually prefer to generate all error message not just the first), but if that's what you're looking for, I'd say it's a perfect solution. Here's a different take on the same idea, except using the same template as both the form and the validation custom tag. Obviously have to flesh it out, but it'll let you have both your custom tag and your consolidated code all in one. ... ... --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -Original Message- > From: Jim Davis [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 4:27 PM > To: CF-Talk > Subject: Smart or Stupid (CFLOOP as a GOTO) > > > This may be a VERY dumb question, but I'm brain fried. > > Okay - so I'm working on a form and I need to validate fields for many > things. Taking "email address" for example I need to validate that it's > been filled in (not zero length), that it's less than 255 characters (the > database limit), that it fits a email format and finally that the email > address isn't already in use. > > What I'd like to be able to do is check through all these > validations. The > instant a problem is found I want to stop checking. I would then > redisplay > the form and so forth. > > In a custom tag or function I might, when an error is found > simply "return" > to the caller with the error information. Since this is a rather > small set > and is only the first of many small forms I decided (perhaps wrongly) to > just do the validation at the top of the page. > > To simulate a components ability to return at any point I wrapped > the whole > validation block in a CFLOOP from 1 to 1 (1 iteration) - as soon > as I hit an > error (and set the error variable) I CFBREAK. Right after the > loop I check > the value of the error variable. > > Now that I'm looking at it I'm not sure... is this just the > stupidest thing > you're ever heard? Should I take the extra time and create a customized > validation custom tag for each and every form? > > Jim Davis > > ~| 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: Smart or Stupid (CFLOOP as a GOTO)
That's only checked (as far as I understand it) before each iteration, not throughout the processing. In other words setting "theform" equal to "invalid" will not stop processing immediately - it will finish out the rest of the code in the loop THEN stop. Jim Davis > -Original Message- > From: Kwang Suh [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 7:36 PM > To: CF-Talk > Subject: Re: Smart or Stupid (CFLOOP as a GOTO) > > Why not use the condition attribute? > > > > - Original Message - > From: "Jim Davis" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, June 27, 2003 5:26 PM > Subject: Smart or Stupid (CFLOOP as a GOTO) > > > > This may be a VERY dumb question, but I'm brain fried. > > > > Okay - so I'm working on a form and I need to validate fields for many > > things. Taking "email address" for example I need to validate that it's > > been filled in (not zero length), that it's less than 255 characters > (the > > database limit), that it fits a email format and finally that the email > > address isn't already in use. > > > > What I'd like to be able to do is check through all these validations. > The > > instant a problem is found I want to stop checking. I would then > redisplay > > the form and so forth. > > > > In a custom tag or function I might, when an error is found simply > "return" > > to the caller with the error information. Since this is a rather small > set > > and is only the first of many small forms I decided (perhaps wrongly) to > > just do the validation at the top of the page. > > > > To simulate a components ability to return at any point I wrapped the > whole > > validation block in a CFLOOP from 1 to 1 (1 iteration) - as soon as I > hit > an > > error (and set the error variable) I CFBREAK. Right after the loop I > check > > the value of the error variable. > > > > Now that I'm looking at it I'm not sure... is this just the stupidest > thing > > you're ever heard? Should I take the extra time and create a customized > > validation custom tag for each and every form? > > > > Jim Davis > > > > > ~| 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: Smart or Stupid (CFLOOP as a GOTO)
Why not use the condition attribute? - Original Message - From: "Jim Davis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 5:26 PM Subject: Smart or Stupid (CFLOOP as a GOTO) > This may be a VERY dumb question, but I'm brain fried. > > Okay - so I'm working on a form and I need to validate fields for many > things. Taking "email address" for example I need to validate that it's > been filled in (not zero length), that it's less than 255 characters (the > database limit), that it fits a email format and finally that the email > address isn't already in use. > > What I'd like to be able to do is check through all these validations. The > instant a problem is found I want to stop checking. I would then redisplay > the form and so forth. > > In a custom tag or function I might, when an error is found simply "return" > to the caller with the error information. Since this is a rather small set > and is only the first of many small forms I decided (perhaps wrongly) to > just do the validation at the top of the page. > > To simulate a components ability to return at any point I wrapped the whole > validation block in a CFLOOP from 1 to 1 (1 iteration) - as soon as I hit an > error (and set the error variable) I CFBREAK. Right after the loop I check > the value of the error variable. > > Now that I'm looking at it I'm not sure... is this just the stupidest thing > you're ever heard? Should I take the extra time and create a customized > validation custom tag for each and every form? > > Jim Davis > > ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Smart or Stupid (CFLOOP as a GOTO)
This may be a VERY dumb question, but I'm brain fried. Okay - so I'm working on a form and I need to validate fields for many things. Taking "email address" for example I need to validate that it's been filled in (not zero length), that it's less than 255 characters (the database limit), that it fits a email format and finally that the email address isn't already in use. What I'd like to be able to do is check through all these validations. The instant a problem is found I want to stop checking. I would then redisplay the form and so forth. In a custom tag or function I might, when an error is found simply "return" to the caller with the error information. Since this is a rather small set and is only the first of many small forms I decided (perhaps wrongly) to just do the validation at the top of the page. To simulate a components ability to return at any point I wrapped the whole validation block in a CFLOOP from 1 to 1 (1 iteration) - as soon as I hit an error (and set the error variable) I CFBREAK. Right after the loop I check the value of the error variable. Now that I'm looking at it I'm not sure... is this just the stupidest thing you're ever heard? Should I take the extra time and create a customized validation custom tag for each and every form? Jim Davis ~| 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: CSV Upload Note
However, it is the CSV file format output by Peachtree, which is what I need
to interface with and represents real data input by Users. So I am stuck
with my "work around". I was hoping for an easier and faster solution.
Andy
-Original Message-
From: jon hall [mailto:[EMAIL PROTECTED]
Sent: Friday, June 27, 2003 5:23 PM
To: CF-Talk
Subject: Re: CSV Upload Note
If you were using a the correct custom delimiter for your file
...that's quite a bug, and quite incredible that it has gone
undetected for all these years.
If you left the DSN on the default of CSV delimited...expect crazy
things like that to happen, because the example you give is _not_ a
valid csv file.
--
jon
mailto:[EMAIL PROTECTED]
Friday, June 27, 2003, 5:06:46 PM, you wrote:
AO> I've tested using OBDC to upload CSV files into queries and have found
that
AO> they do not handle the following situation properly:
AO> Small Heart, with ""Red" decorations
AO> is translated as
AO> Small Heart, with "Red
AO> and
AO> Small Heart, with PINK "decorations"
AO> becomes
AO> Small Heart, with PINK
AO> The following code handles this correctly:
AO>
AO>
AO> aryCSV = ArrayNew(1);
AO> // Only do stuff if something passed
AO> if (len(lstCSV) GT 0) {
AO>// First, add a comma onto the end so that the search for ", and not
"",
AO> always finds something unless bad CSV string.
AO>// Then, replace any ",," with ", ," so that individual array
elements will
AO> be found
AO>lstWork = Trim(lstCSV) & ",";
AO>lstWork = replace(lstWork, ",", ", ", "ALL");
AO>// Then loop thru string, parsing off to next comma and checking if
AO> complete field
AO>// Note that if the field has imbedded quotes, this routine will
create bad
AO> data.
AO>// For example, [This is a test, "test"] will come through as ["This
is a
AO> test, ""test""]
AO>// and will be parsed into two fields, [This is a test, "] and
["test"].
AO> The calling routine will
AO>// need to handle the possibility that more fields will be returned
then
AO> expected.
AO>Do {
AO> // If Line starts with quote, next field is next quote+comma that is
not
AO> part of a quote+quote+comma
AO> if (left(lstWork, 1) EQ '"') {
AO> tmpStr = Right(lstWork, len(lstWork)-1);
AO> EndPos = REFInd('([^"]",) | ("*"",)', tmpStr);
AO> // If nothing found, look for "", ending
AO> if (EndPos EQ 0) {
AO> EndPos=REFInd('([^"]",) | (["]*["",])', tmpStr);
AO> EndPos=REFInd('("",)', Mid(tmpStr, EndPos+1, len(tmpStr)))+EndPos;
AO> }
AO> // If still nothing found, Error. Stop work immediately
AO> if (EndPos EQ 0) {
AO> lstwork = "";
AO> NextField = "";
AO> }
AO> Else {
AO> NextField = mid(trim(lstWork), 2, EndPos);
AO> if (len(lstWork)-(EndPos+2) EQ 0)
AO>lstwork = "";
AO> else
AO>lstWork = ltrim(right(lstWork, len(lstWork)-(EndPos+3)));
AO> }
AO> }
AO> else if (left(lstwork, 1) EQ ",") {
AO> lstWork = ltrim(right(lstWork, len(lstWork)-1));
AO> NextField = " ";
AO> }
AO> else {
AO> NextField = Trim(ListFirst(lstWork, ","));
AO> lstWork = LTrim(ListDeleteAt(lstWork, 1, ","));
AO> }
AO> //Append the new field, converting CSV's double quotes to single
quotes
AO> ArrayAppend(aryCSV, Replace(NextField, '""', '"', "all"));
AO> //writeoutput(",[#lstwork#], [#NextField#]");
AO>}
AO>while (len(lstWork) GT 1);
AO> }
AO>
AO>
~|
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
Host with the leader in ColdFusion hosting.
Voted #1 ColdFusion host by CF Developers.
Offering shared and dedicated hosting options.
www.cfxhosting.com/default.cfm?redirect=10481
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFM Shopping Cart System
I would to - Original Message - From: "Dan Phillips" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 9:53 AM Subject: RE: CFM Shopping Cart System > Same here. > > -Original Message- > From: admin [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 12:50 PM > To: CF-Talk > Subject: Re: CFM Shopping Cart System > > > I would be interested is seing it too. > - Original Message - > From: "Manesh Manickam" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, June 27, 2003 9:35 AM > Subject: RE: CFM Shopping Cart System > > > > Nice site, do you think I could get the source and try to see if I > > could > get > > it to work on a computer site? thanks > > > > -Original Message- > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > > Sent: Friday, June 27, 2003 10:57 AM > > To: CF-Talk > > > > Just the checkout feature. > > I have shipping features built in but its commented out because they > wanted > > paypal to do shipping as well. > > > > -Original Message- > > From: Jason Miller [mailto:[EMAIL PROTECTED] > > Sent: Friday, June 27, 2003 10:58 AM > > To: CF-Talk > > Subject: Re: CFM Shopping Cart System > > > > > > Out of curiousity - how much is integrated with paypal? Just checkout? > > > Actual product catalog? Curious to see if it could handle one of my > > client needs. Thanks, Jason > > > > Matt Blatchley ~ Bridgeleaf Studios wrote: > > > Dave, > > > > > > Clean site, I like it. You should make it so the user can add the > > > product to the cart as soon as they see it, not just on the detail > > > page. How many clicks does it take to get them to add it to the > > > cart. If the user has to go to the detail page then it's too many. > > > Other than that, it'd very nice and clean. Clean design and well > > > formatted. > > > > > > Matt > > > > > > -Original Message- > > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > > > Sent: Friday, June 27, 2003 7:04 AM > > > To: CF-Talk > > > Subject: RE: CFM Shopping Cart System > > > > > > > > > I just completed a site that uses a shopping cart system with > > > paypal. http://www.savvy-selections.com/catalog.cfm > > > > > > > > > -Original Message- > > > From: Manesh Manickam [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, June 26, 2003 11:02 PM > > > To: CF-Talk > > > Subject: CFM Shopping Cart System > > > > > > > > > I was wondering if there are any free shopping cart systems for cfm, > > > > that are actually good! As in inventory, paypal authoring. Thanks > > > for you help guys and girls! > > > > > > > > > > > > > > > > > > > > > > > ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Upload Note
If you were using a the correct custom delimiter for your file
...that's quite a bug, and quite incredible that it has gone
undetected for all these years.
If you left the DSN on the default of CSV delimited...expect crazy
things like that to happen, because the example you give is _not_ a
valid csv file.
--
jon
mailto:[EMAIL PROTECTED]
Friday, June 27, 2003, 5:06:46 PM, you wrote:
AO> I've tested using OBDC to upload CSV files into queries and have found that
AO> they do not handle the following situation properly:
AO> Small Heart, with ""Red" decorations
AO> is translated as
AO> Small Heart, with "Red
AO> and
AO> Small Heart, with PINK "decorations"
AO> becomes
AO> Small Heart, with PINK
AO> The following code handles this correctly:
AO>
AO>
AO> aryCSV = ArrayNew(1);
AO> // Only do stuff if something passed
AO> if (len(lstCSV) GT 0) {
AO>// First, add a comma onto the end so that the search for ", and not "",
AO> always finds something unless bad CSV string.
AO>// Then, replace any ",," with ", ," so that individual array elements will
AO> be found
AO>lstWork = Trim(lstCSV) & ",";
AO>lstWork = replace(lstWork, ",", ", ", "ALL");
AO>// Then loop thru string, parsing off to next comma and checking if
AO> complete field
AO>// Note that if the field has imbedded quotes, this routine will create bad
AO> data.
AO>// For example, [This is a test, "test"] will come through as ["This is a
AO> test, ""test""]
AO>// and will be parsed into two fields, [This is a test, "] and ["test"].
AO> The calling routine will
AO>// need to handle the possibility that more fields will be returned then
AO> expected.
AO>Do {
AO> // If Line starts with quote, next field is next quote+comma that is not
AO> part of a quote+quote+comma
AO> if (left(lstWork, 1) EQ '"') {
AO> tmpStr = Right(lstWork, len(lstWork)-1);
AO> EndPos = REFInd('([^"]",) | ("*"",)', tmpStr);
AO> // If nothing found, look for "", ending
AO> if (EndPos EQ 0) {
AO> EndPos=REFInd('([^"]",) | (["]*["",])', tmpStr);
AO> EndPos=REFInd('("",)', Mid(tmpStr, EndPos+1, len(tmpStr)))+EndPos;
AO> }
AO> // If still nothing found, Error. Stop work immediately
AO> if (EndPos EQ 0) {
AO> lstwork = "";
AO> NextField = "";
AO> }
AO> Else {
AO> NextField = mid(trim(lstWork), 2, EndPos);
AO> if (len(lstWork)-(EndPos+2) EQ 0)
AO>lstwork = "";
AO> else
AO>lstWork = ltrim(right(lstWork, len(lstWork)-(EndPos+3)));
AO> }
AO> }
AO> else if (left(lstwork, 1) EQ ",") {
AO> lstWork = ltrim(right(lstWork, len(lstWork)-1));
AO> NextField = " ";
AO> }
AO> else {
AO> NextField = Trim(ListFirst(lstWork, ","));
AO> lstWork = LTrim(ListDeleteAt(lstWork, 1, ","));
AO> }
AO> //Append the new field, converting CSV's double quotes to single quotes
AO> ArrayAppend(aryCSV, Replace(NextField, '""', '"', "all"));
AO> //writeoutput(",[#lstwork#], [#NextField#]");
AO>}
AO>while (len(lstWork) GT 1);
AO> }
AO>
AO>
~|
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: used to use cfml.exe but MX doesn't have it...
You could write a cfm page that does a CFHTTP call to your CF script and save the results to an HTML file. If you need this to run automagically, you could use the scheduler. Doug >-Original Message- >From: cf talk [mailto:[EMAIL PROTECTED] >Sent: Friday, June 27, 2003 5:11 PM >To: CF-Talk >Subject: RE: used to use cfml.exe but MX doesn't have it... > > >Steve, > >I would love to not use a bat file. I just don't know how to >create an html file from the data of a CFM page. > >Brian > > >Brian, > >I asked this question before. Short answer... Can't be done. >CFMX is now >entirely Java. No more cfml.exe. > >I'm sure that there is probably some way to make it work, but instead I >found another way to do what I wanted. Do you have to do it >in a batch file >or can you find another way to do it? > >Also, many people suggested using wget to run it. I believe >that they said >it was a free program. > >What is does is pretend to be a web browser and hit the page. > >Steve > > >-Original Message- >From: cf talk [mailto:[EMAIL PROTECTED] >Sent: Friday, June 27, 2003 4:29 PM >To: CF-Talk >Subject: used to use cfml.exe but MX doesn't have it... > > >I had a bat file that created an HTML page based off of the >running of a CFM >page. With MX, it doesn't work anymore. Can anyone look at what I was >doing and give me some direction? > > >Bat file: > > >REM *** set variable to contain URL variables >set QUERY_STRING="PASSEDNAME=a0002" > >REM *** set variable to call specific CF template >set CF_TEMPLATE_PATH=c:\Dir\gmd_hp_jms_critical_path_summ_html.cfm > >REM *** Run template into a tmp file >@for /f "usebackq skip=5 tokens=*" %%i in >(`c:\CFusion\BIN\cfml`) do @echo+ >%%i>>"c:\Dir\gmd_hp_jms_critical_path_summ.tmp" > >REM *** Copy from the tmp file into the html file >copy "c:\Dir\GMDUtilities\gmd_hp_jms_critical_path_summ.tmp" >"c:\Dir\GMDUtilities\gmd_hp_jms_critical_path_summ.html" > >REM *** Delete the tmp file if it is there >if exist "c:\Dir\gmd_hp_jms_critical_path_summ.tmp" del >"c:\Dir\gmd_hp_jms_critical_path_summ.tmp" > > > >Thanks, > >Brian Yager >President - North Alabama >Cold Fusion Users Group >http://www.nacfug.com >Ground-Based Midcourse Defense JPO >Contractor CSC >(256)313-9668 >[EMAIL PROTECTED] > > > > ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: End of stream was detected on a read...again?
I have come to the conclusion that there is no answer for this question. But I did find a workaround. I installed Oracle's JDBC Type IV thin driver and configured the DSN in MX server for "other" driver type. I don't know if MS SQL has a JDBC driver you could use though... Alan. -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 7:06 AM To: CF-Talk Subject: RE: End of stream was detected on a read...again? I get the same error msg using MS SQL Server. My web page queries work fine but something generates that "End of stream was detected on a read." error msg. Dave -Original Message- From: SPANGLER ALAN L. (dal1als) [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 5:45 PM To: CF-Talk Subject: End of stream was detected on a read...again? I know this has been listed here before, but I check the archives and found nothing that had an answer, although I did find the question. So I thought I would put it out here again. I just did a fresh install of the development version of CFMX server on my local PC. I'm running windows 2000 and using IIS as the web server. I've also downloaded and installed the Updater3. I've tested all the queries in sql+ (Oracle) and the work. Whenever I try to run a query in a web page I get the error "[Macromedia][Oracle JDBC Driver]End of stream was detected on a read." Anyone remember the answer? TIA Alan. ~| 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: used to use cfml.exe but MX doesn't have it...
Steve, I would love to not use a bat file. I just don't know how to create an html file from the data of a CFM page. Brian Brian, I asked this question before. Short answer... Can't be done. CFMX is now entirely Java. No more cfml.exe. I'm sure that there is probably some way to make it work, but instead I found another way to do what I wanted. Do you have to do it in a batch file or can you find another way to do it? Also, many people suggested using wget to run it. I believe that they said it was a free program. What is does is pretend to be a web browser and hit the page. Steve -Original Message- From: cf talk [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 4:29 PM To: CF-Talk Subject: used to use cfml.exe but MX doesn't have it... I had a bat file that created an HTML page based off of the running of a CFM page. With MX, it doesn't work anymore. Can anyone look at what I was doing and give me some direction? Bat file: REM *** set variable to contain URL variables set QUERY_STRING="PASSEDNAME=a0002" REM *** set variable to call specific CF template set CF_TEMPLATE_PATH=c:\Dir\gmd_hp_jms_critical_path_summ_html.cfm REM *** Run template into a tmp file @for /f "usebackq skip=5 tokens=*" %%i in (`c:\CFusion\BIN\cfml`) do @echo+ %%i>>"c:\Dir\gmd_hp_jms_critical_path_summ.tmp" REM *** Copy from the tmp file into the html file copy "c:\Dir\GMDUtilities\gmd_hp_jms_critical_path_summ.tmp" "c:\Dir\GMDUtilities\gmd_hp_jms_critical_path_summ.html" REM *** Delete the tmp file if it is there if exist "c:\Dir\gmd_hp_jms_critical_path_summ.tmp" del "c:\Dir\gmd_hp_jms_critical_path_summ.tmp" Thanks, Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9668 [EMAIL PROTECTED] ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Remote SQL Server and intermittent connection
via MS SQL Server driver configg'd in the Admin or via ODBC datasource (configg'd in ODBC Datasources CP and then via ODBC socket in the CFMX Admin? The reason I ask is that when I upgraded our servers to CFMX *all* of our datasources that were MS Sql Driver completely blew up. the only way I found to fix the problem was to eliminate the datasource mapping, set one up in ODBC CP and then remap using ODBC Socket. now they work fine, and we haven't had a hiccup since. HTH will - Original Message - From: "Brook Davies" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 6:56 AM Subject: Remote SQL Server and intermittent connection > Hello, > > I have a CFMX server which speaks to a remote SQL Server 7 Box via the > TCP-IP using the IP address of the remote server. This works fine during > testing and most of the time, but quite often the connection to the SQL > Server can not be made. > > Is there anything I can do to make this connection more reliable? > > Brook > > > ~| 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
CSV Upload Note
I've tested using OBDC to upload CSV files into queries and have found that
they do not handle the following situation properly:
Small Heart, with ""Red" decorations
is translated as
Small Heart, with "Red
and
Small Heart, with PINK "decorations"
becomes
Small Heart, with PINK
The following code handles this correctly:
aryCSV = ArrayNew(1);
// Only do stuff if something passed
if (len(lstCSV) GT 0) {
// First, add a comma onto the end so that the search for ", and not "",
always finds something unless bad CSV string.
// Then, replace any ",," with ", ," so that individual array elements will
be found
lstWork = Trim(lstCSV) & ",";
lstWork = replace(lstWork, ",", ", ", "ALL");
// Then loop thru string, parsing off to next comma and checking if
complete field
// Note that if the field has imbedded quotes, this routine will create bad
data.
// For example, [This is a test, "test"] will come through as ["This is a
test, ""test""]
// and will be parsed into two fields, [This is a test, "] and ["test"].
The calling routine will
// need to handle the possibility that more fields will be returned then
expected.
Do {
// If Line starts with quote, next field is next quote+comma that is not
part of a quote+quote+comma
if (left(lstWork, 1) EQ '"') {
tmpStr = Right(lstWork, len(lstWork)-1);
EndPos = REFInd('([^"]",) | ("*"",)', tmpStr);
// If nothing found, look for "", ending
if (EndPos EQ 0) {
EndPos=REFInd('([^"]",) | (["]*["",])', tmpStr);
EndPos=REFInd('("",)', Mid(tmpStr, EndPos+1, len(tmpStr)))+EndPos;
}
// If still nothing found, Error. Stop work immediately
if (EndPos EQ 0) {
lstwork = "";
NextField = "";
}
Else {
NextField = mid(trim(lstWork), 2, EndPos);
if (len(lstWork)-(EndPos+2) EQ 0)
lstwork = "";
else
lstWork = ltrim(right(lstWork, len(lstWork)-(EndPos+3)));
}
}
else if (left(lstwork, 1) EQ ",") {
lstWork = ltrim(right(lstWork, len(lstWork)-1));
NextField = " ";
}
else {
NextField = Trim(ListFirst(lstWork, ","));
lstWork = LTrim(ListDeleteAt(lstWork, 1, ","));
}
//Append the new field, converting CSV's double quotes to single quotes
ArrayAppend(aryCSV, Replace(NextField, '""', '"', "all"));
//writeoutput(",[#lstwork#], [#NextField#]");
}
while (len(lstWork) GT 1);
}
~|
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
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: used to use cfml.exe but MX doesn't have it...
Brian, I asked this question before. Short answer... Can't be done. CFMX is now entirely Java. No more cfml.exe. I'm sure that there is probably some way to make it work, but instead I found another way to do what I wanted. Do you have to do it in a batch file or can you find another way to do it? Also, many people suggested using wget to run it. I believe that they said it was a free program. What is does is pretend to be a web browser and hit the page. Steve -Original Message- From: cf talk [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 4:29 PM To: CF-Talk Subject: used to use cfml.exe but MX doesn't have it... I had a bat file that created an HTML page based off of the running of a CFM page. With MX, it doesn't work anymore. Can anyone look at what I was doing and give me some direction? Bat file: REM *** set variable to contain URL variables set QUERY_STRING="PASSEDNAME=a0002" REM *** set variable to call specific CF template set CF_TEMPLATE_PATH=c:\Dir\gmd_hp_jms_critical_path_summ_html.cfm REM *** Run template into a tmp file @for /f "usebackq skip=5 tokens=*" %%i in (`c:\CFusion\BIN\cfml`) do @echo+ %%i>>"c:\Dir\gmd_hp_jms_critical_path_summ.tmp" REM *** Copy from the tmp file into the html file copy "c:\Dir\GMDUtilities\gmd_hp_jms_critical_path_summ.tmp" "c:\Dir\GMDUtilities\gmd_hp_jms_critical_path_summ.html" REM *** Delete the tmp file if it is there if exist "c:\Dir\gmd_hp_jms_critical_path_summ.tmp" del "c:\Dir\gmd_hp_jms_critical_path_summ.tmp" Thanks, Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9668 [EMAIL PROTECTED] ~| 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: error handling question
Mark: CFTRY/CFCATCH is definitely the way to go here. Something like: -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -Original Message- > From: Mark W. Breneman [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 1:03 PM > To: CF-Talk > Subject: error handling question > > > I have a loop that is doing a db insert. From time to time > the data I am > inserting will have some invalid data. So, loop will stop. What I need to > do is to just skip insert if it can not insert it and keep going with the > loop. > > Can cftry/cfcatch do this? > > Mark W. Breneman > -Macromedia Certified ColdFusion Developer > -Network / Web Server Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 > > > > ~| 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
Is there a way to test to see if a data source exists?
Thank you for all the suggestions! Using the following cfcatch block I get the below messages returned #cfcatch.message# CF5 & ODBC & SQL 2K: "ODBC Error Code = IM002 (Data source not found and no default driver specified)" CFMX & SQL 2K: "Data source foo could not be found." I have not as yet tested the following: 1. CF5 with OLE-DB (though if don't specify dbtype, then it falls back to ODBC, and there may be no need to test OLE-DB?) 2. CF4.5 3. Access 4. CF4 (is there enough of a user base to justify developing for CF4?) I am hoping to have this application compatible with CF4.5 - CFMX, SQL Server, MS Access. I suppose I may try later to look at testing MYSQL, but for now just SQL Server & Access will do. Stan Winchester [EMAIL PROTECTED] http://www.aftershockweb.com/ Tel. 503-244-3440 Fax 503-244-3454 >Is there a way to test to see if a data source exists? I am creating a setup >routine where the user will enter the data source name, and I would like to >check to see if it exists before using it. > >Stan Winchester >[EMAIL PROTECTED] >http://www.aftershockweb.com/ >Tel. 503-244-3440 >Fax 503-244-3454 > ~| 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
used to use cfml.exe but MX doesn't have it...
I had a bat file that created an HTML page based off of the running of a CFM page. With MX, it doesn't work anymore. Can anyone look at what I was doing and give me some direction? Bat file: REM *** set variable to contain URL variables set QUERY_STRING="PASSEDNAME=a0002" REM *** set variable to call specific CF template set CF_TEMPLATE_PATH=c:\Dir\gmd_hp_jms_critical_path_summ_html.cfm REM *** Run template into a tmp file @for /f "usebackq skip=5 tokens=*" %%i in (`c:\CFusion\BIN\cfml`) do @echo+ %%i>>"c:\Dir\gmd_hp_jms_critical_path_summ.tmp" REM *** Copy from the tmp file into the html file copy "c:\Dir\GMDUtilities\gmd_hp_jms_critical_path_summ.tmp" "c:\Dir\GMDUtilities\gmd_hp_jms_critical_path_summ.html" REM *** Delete the tmp file if it is there if exist "c:\Dir\gmd_hp_jms_critical_path_summ.tmp" del "c:\Dir\gmd_hp_jms_critical_path_summ.tmp" Thanks, Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9668 [EMAIL PROTECTED] ~| 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: Is there a way to test to see if a data source exists?
on Windows you can check the registry: -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:55 AM To: CF-Talk Subject: Is there a way to test to see if a data source exists? Is there a way to test to see if a data source exists? I am creating a setup routine where the user will enter the data source name, and I would like to check to see if it exists before using it. Stan Winchester [EMAIL PROTECTED] http://www.aftershockweb.com/ Tel. 503-244-3440 Fax 503-244-3454 ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: livedocs.macromedia.com is down...
Looks like someone restarted something :)...was jrun errors before... Stace -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 2:56 PM To: CF-Talk Subject: RE: livedocs.macromedia.com is down... Worked fine for me. -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 2:32 PM To: CF-Talk Subject: RE: livedocs.macromedia.com is down... More specifically... http://livedocs.macromedia.com/cfmxdocs/dochome.jsp -Original Message- From: Stacy Young Sent: Friday, June 27, 2003 2:31 PM To: '[EMAIL PROTECTED]' Subject: livedocs.macromedia.com is down... -Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is there a way to test to see if a data source exists?
> -Original Message- > From: CF Dude [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 2:39 PM > To: CF-Talk > Subject: Re: Is there a way to test to see if a data source exists? > > I consider the "right" query as an obvious, but now I do have another > question. I'm not sure why it would be an "obvious" - are you talking about a specific database with known tables, or just an unknown datasource? Furthermore are you talking about a known DB system or any system? I was assuming unknown databases and DBMSs - if we're limiting things to known databases or systems then the problem gets a LOT easier. For example in SQL Server you can say "SELECT name from SYSOBJECTS WHERE name = ''" That query will return no rows without error in pretty much every version of SQL Server. But it will fail in Access (or Oracle or Sysbase) even if the Datasource exists. You can also do (in SQL Server) "SELECT name from SYSDatabases WHERE name = 'databasename'" to see if a specific database exists. As for systems if know, for example, that you're only interested in ODBC datasources then you can easily easily query the ODBC key in the Windows Registery - it has a list of all ODBC datasources. For other datasources (JDBC for example) there really isn't a registry component to reference - CF itself maintains the information. If a simple works for you, use it (who wouldn't!?) but if you're trying to be more generic (any connection, any DB) then the problem's a little larger and you should consider using something like the CF.Factory (and that's actually pretty easy - easy enough that you may want to use it regardless just for possible expansion later). Jim Davis ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is there a way to test to see if a data source exists?
That makes sense. - Original Message - From: "Jim Davis" <[EMAIL PROTECTED]> You get a "no SQL specificied" error - CF won't try to make a connection for no reason. Jim Davis ~| 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: Is there a way to test to see if a data source exists?
You get a "no SQL specificied" error - CF won't try to make a connection for no reason. Jim Davis > -Original Message- > From: CF Dude [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 2:39 PM > To: CF-Talk > Subject: Re: Is there a way to test to see if a data source exists? > > I consider the "right" query as an obvious, but now I do have another > question. > > What would happen if, in this scenario, you just used an empty > tag? > > EG : > > > > > What would happen if no query was specified? > > > > I'd like to assume that cfServer still tries to make a physical connection > before running the query. Or does it check > for the existence of a query first, and then connect? > > Eric > > - Original Message - > From: "Jim Davis" <[EMAIL PROTECTED]> > > The "right" query to use may different with database and connection type. > For example in ODBC the message "data source not found" us returned and > you > can search for it, but this message may not come back for other drivers > (such as OLE DB or JDBC). > > ~| 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
OT: Server ? for CF
<< Make the 2.4 GHz server the database server, it will give you the best growth-path (it is easier to serve many webservers from one database server as one webserver from many database servers). >> Thanks Jochem. I failed to say that we've got a one to one website to database relationship. Only one webserver to the database. Jeff ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMail
Stephenie and Jochem Thanks both of you this is what we are looking for, Server wide is fine only one site on the server and we want controll over all the mail. Thanks again Rodney -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 11:49 AM To: CF-Talk Subject: RE: CFMail Yes, in the registry under HKEY_LOCAL_MACHINE --> SOFTWARE -->Allaire --> CurrentVersion --> Mail there is a key for BaseDirectory that should point to your cfusion\mail folder, you can change this, but I believe wherever you point this should have a spool dir inside of it (ie: don't point it straight to another spool dir, but to a dir with spool dir inside it). ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 2:40 PM To: CF-Talk Subject: RE: CFMail CF 5, win2K --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 6/18/2003 ~| 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: livedocs.macromedia.com is down...
Worked fine for me. -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 2:32 PM To: CF-Talk Subject: RE: livedocs.macromedia.com is down... More specifically... http://livedocs.macromedia.com/cfmxdocs/dochome.jsp -Original Message- From: Stacy Young Sent: Friday, June 27, 2003 2:31 PM To: '[EMAIL PROTECTED]' Subject: livedocs.macromedia.com is down... -Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| 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: OT: Server ? for CF
Jeff Horne wrote: > << How large are the databases? >> > > Not very large. 474mb for all. > << Are your databases CPU bound or I/O bound? >> > > I/O bound. Why are you I/O bound when you should have enough RAM to cache all databases completely? Make the 2.4 GHz server the database server, it will give you the best growth-path (it is easier to serve many webservers from one database server as one webserver from many database servers). Jochem ~| 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: CFMail
Yes, in the registry under HKEY_LOCAL_MACHINE --> SOFTWARE -->Allaire --> CurrentVersion --> Mail there is a key for BaseDirectory that should point to your cfusion\mail folder, you can change this, but I believe wherever you point this should have a spool dir inside of it (ie: don't point it straight to another spool dir, but to a dir with spool dir inside it). ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 2:40 PM To: CF-Talk Subject: RE: CFMail CF 5, win2K --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 6/18/2003 ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMail
Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > Is there a way when using to get CF to drop the mail into a > diffrent dir then ../mail/spool? Check HKLM\Software\Allaire\ColdFusion\CurrentVersion\Mail (but this is a server-wide setting) Jochem ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMail
CF 5, win2K -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 11:36 AM To: CF-Talk Subject: RE: CFMail Which version of CF? ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 2:16 PM To: CF-Talk Subject: CFMail Hi all Is there a way when using to get CF to drop the mail into a diffrent dir then ../mail/spool? Thanks Rodney ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is there a way to test to see if a data source exists?
I consider the "right" query as an obvious, but now I do have another question. What would happen if, in this scenario, you just used an empty tag? EG : What would happen if no query was specified? I'd like to assume that cfServer still tries to make a physical connection before running the query. Or does it check for the existence of a query first, and then connect? Eric - Original Message - From: "Jim Davis" <[EMAIL PROTECTED]> The "right" query to use may different with database and connection type. For example in ODBC the message "data source not found" us returned and you can search for it, but this message may not come back for other drivers (such as OLE DB or JDBC). ~| 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: CFMail
Which version of CF? ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 2:16 PM To: CF-Talk Subject: CFMail Hi all Is there a way when using to get CF to drop the mail into a diffrent dir then ../mail/spool? Thanks Rodney ~| 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: livedocs.macromedia.com is down...
More specifically... http://livedocs.macromedia.com/cfmxdocs/dochome.jsp -Original Message- From: Stacy Young Sent: Friday, June 27, 2003 2:31 PM To: '[EMAIL PROTECTED]' Subject: livedocs.macromedia.com is down... -Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
livedocs.macromedia.com is down...
-Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is there a way to test to see if a data source exists?
Assuming CFMX (version matters) you could use the stuff described here to do it quite easily: http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=12 Using TRY/CATCH is a good idea as well, but you'll need to determine a good query to use: you want to make sure that the datasource doesn't exist but the catch will activate for ANY error (if the table doesn't exist or if the column doesn't exist for example). The "right" query to use may different with database and connection type. For example in ODBC the message "data source not found" us returned and you can search for it, but this message may not come back for other drivers (such as OLE DB or JDBC). In SQL server you can query the system tables but you can't in Access and so on. If you're using CF 5 (let us know) there are a few undocumented functions to do this as well - very easy. Jim > -Original Message- > From: Stan Winchester [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 1:55 PM > To: CF-Talk > Subject: Is there a way to test to see if a data source exists? > > Is there a way to test to see if a data source exists? I am creating a > setup > routine where the user will enter the data source name, and I would like > to > check to see if it exists before using it. > > Stan Winchester > [EMAIL PROTECTED] > http://www.aftershockweb.com/ > Tel. 503-244-3440 > Fax 503-244-3454 > > ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is there a way to test to see if a data source exists?
I'm sure you would have come up with it. If this is cf 4x, you could use BenForta's connection tag that does a reg query and find the currently created dsns. I wish I knew what that was called. - Original Message - From: "Stan Winchester" <[EMAIL PROTECTED]> CF Dude, I should have thought of that; for some reason my thinking was down another path. ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Is there a way to test to see if a data source exists?
CF Dude, I should have thought of that; for some reason my thinking was down another path. Thanks, Stan >Couldn't you do something like this? (not exact code) > > > > >select * from table where 1 = 2 > > > >Something broker > > > >Just an idea. > >E > >- Original Message - >From: "Stan Winchester" <[EMAIL PROTECTED]> > > >Is there a way to test to see if a data source exists? I am creating a setup >routine where the user will enter the data source name, and I would like to >check to see if it exists before using it. ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMail
Hi all Is there a way when using to get CF to drop the mail into a diffrent dir then ../mail/spool? Thanks Rodney ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is there a way to test to see if a data source exists?
These are CF 5 solutions. Try the undocumented or if you prefer a supported option you could try something like this: SELECT Foo FROM Bar DSN exists DSN does not exist! DSN exists Chris > -Original Message- > From: Stan Winchester [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 1:55 PM > To: CF-Talk > Subject: Is there a way to test to see if a data source exists? > > > Is there a way to test to see if a data source exists? I am > creating a setup > routine where the user will enter the data source name, and I > would like to > check to see if it exists before using it. > > Stan Winchester > [EMAIL PROTECTED] > http://www.aftershockweb.com/ > Tel. 503-244-3440 > Fax 503-244-3454 > > ~| 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: Is there a way to test to see if a data source exists?
You should be able to run a query that you know will fail on the DSN within a CFTRY..CFCATCH block, and then look at the error message to determine what kind of failure it was: invalid DSN or something else. barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -Original Message- > From: Stan Winchester [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 10:55 AM > To: CF-Talk > Subject: Is there a way to test to see if a data source exists? > > > Is there a way to test to see if a data source exists? I am > creating a setup > routine where the user will enter the data source name, and I > would like to > check to see if it exists before using it. > > Stan Winchester > [EMAIL PROTECTED] > http://www.aftershockweb.com/ > Tel. 503-244-3440 > Fax 503-244-3454 > > ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is there a way to test to see if a data source exists?
Couldn't you do something like this? (not exact code) select * from table where 1 = 2 Something broker Just an idea. E - Original Message - From: "Stan Winchester" <[EMAIL PROTECTED]> Is there a way to test to see if a data source exists? I am creating a setup routine where the user will enter the data source name, and I would like to check to see if it exists before using it. ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Is there a way to test to see if a data source exists?
Is there a way to test to see if a data source exists? I am creating a setup routine where the user will enter the data source name, and I would like to check to see if it exists before using it. Stan Winchester [EMAIL PROTECTED] http://www.aftershockweb.com/ Tel. 503-244-3440 Fax 503-244-3454 ~| 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: Server ? for CF
<< What are the specs of the disks? >> >I'm not sure what you mean. I think he means the type - IDE or SCSI and the speed of the drives - 7200, 10K, 15K This can be a strong determining factor for choosing the DB box. -Original Message- From: Jeff Horne [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 12:04 PM To: CF-Talk Subject: OT: Server ? for CF << How large are the databases? >> Not very large. 474mb for all. << What are the specs of the disks? >> I'm not sure what you mean. << Are your databases CPU bound or I/O bound? >> I/O bound. Thanks, Jeff ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server is very slow
No I haven't. Done any updates to this box other than the sfw that we bought. Thanks for the link! -Original Message- From: Chris Kief [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:04 AM To: CF-Talk Subject: RE: Server is very slow Have you updated your install to Updater 3? http://www.macromedia.com/software/coldfusion/special/updater/faq/ chris >-Original Message- >From: Ray Bujarski [mailto:[EMAIL PROTECTED] >Sent: Friday, June 27, 2003 9:50 AM >To: CF-Talk >Subject: Server is very slow > >I am running the new CFMX server on a sparc9 box with 2gig of ram and 2 >750MHz processors. The CFMX server wants to hog 50% of the processor, >as well as a half a gig of memory, without anyone even making requests >to the server. Is this typical behavioral traits of MX? Is there any >way to tame this server down a bit? Thanks for any info anyone may >have? > >Ray Bujarski >Direct 858-845-7669 >Pager 858-636-9900 > > ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server is very slow
They go back to normal for a while, but then the system starts calling system functions to poll (I am not for sure what it is polling for) however the "truss -p" command showed me this. -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:03 AM To: CF-Talk Subject: RE: Server is very slow H ... What happens if you restart services? -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 1:00 PM To: CF-Talk Subject: RE: Server is very slow Found it (capital letters start the directory structure), but there is nothing in the directory at all. -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 9:53 AM To: CF-Talk Subject: RE: Server is very slow Does the cfusionmx/mail/spool directory have any zero bite files in it? Or a ton of mail? That would cause something like this. Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 12:50 PM To: CF-Talk Subject: Server is very slow I am running the new CFMX server on a sparc9 box with 2gig of ram and 2 750MHz processors. The CFMX server wants to hog 50% of the processor, as well as a half a gig of memory, without anyone even making requests to the server. Is this typical behavioral traits of MX? Is there any way to tame this server down a bit? Thanks for any info anyone may have? Ray Bujarski Direct 858-845-7669 Pager 858-636-9900 ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFM Shopping Cart System
Yes, Please. -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 12:53 PM To: CF-Talk Subject: RE: CFM Shopping Cart System Same here. -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 12:50 PM To: CF-Talk Subject: Re: CFM Shopping Cart System I would be interested is seing it too. - Original Message - From: "Manesh Manickam" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 9:35 AM Subject: RE: CFM Shopping Cart System > Nice site, do you think I could get the source and try to see if I > could get > it to work on a computer site? thanks > > -Original Message- > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 10:57 AM > To: CF-Talk > > Just the checkout feature. > I have shipping features built in but its commented out because they wanted > paypal to do shipping as well. > > -Original Message- > From: Jason Miller [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 10:58 AM > To: CF-Talk > Subject: Re: CFM Shopping Cart System > > > Out of curiousity - how much is integrated with paypal? Just checkout? > Actual product catalog? Curious to see if it could handle one of my > client needs. Thanks, Jason > > Matt Blatchley ~ Bridgeleaf Studios wrote: > > Dave, > > > > Clean site, I like it. You should make it so the user can add the > > product to the cart as soon as they see it, not just on the detail > > page. How many clicks does it take to get them to add it to the > > cart. If the user has to go to the detail page then it's too many. > > Other than that, it'd very nice and clean. Clean design and well > > formatted. > > > > Matt > > > > -Original Message- > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > > Sent: Friday, June 27, 2003 7:04 AM > > To: CF-Talk > > Subject: RE: CFM Shopping Cart System > > > > > > I just completed a site that uses a shopping cart system with > > paypal. http://www.savvy-selections.com/catalog.cfm > > > > > > -Original Message- > > From: Manesh Manickam [mailto:[EMAIL PROTECTED] > > Sent: Thursday, June 26, 2003 11:02 PM > > To: CF-Talk > > Subject: CFM Shopping Cart System > > > > > > I was wondering if there are any free shopping cart systems for cfm, > > that are actually good! As in inventory, paypal authoring. Thanks > > for you help guys and girls! > > > > > > > > > > > > > ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server is very slow
Have you updated your install to Updater 3? http://www.macromedia.com/software/coldfusion/special/updater/faq/ chris >-Original Message- >From: Ray Bujarski [mailto:[EMAIL PROTECTED] >Sent: Friday, June 27, 2003 9:50 AM >To: CF-Talk >Subject: Server is very slow > >I am running the new CFMX server on a sparc9 box with 2gig of ram and 2 >750MHz processors. The CFMX server wants to hog 50% of the processor, >as well as a half a gig of memory, without anyone even making requests >to the server. Is this typical behavioral traits of MX? Is there any >way to tame this server down a bit? >Thanks for any info anyone may have? > >Ray Bujarski >Direct 858-845-7669 >Pager 858-636-9900 > > ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Writing HTML emails to SMTP pickup
Writing HTML emails to SMTP pickup Hello. I'm pretty sure this was discussed in previous threads, but the lack of a full text-search in cflist makes it very hard to search. My client has about 100.000 e-mails and he wants to send customized e-mail messages, with products and details about the customer's account. This newslettetter will be sent every 10 days or so and will be in HTML format. Since its very customizes for each one of the customers, he cant rely on a bulk email software. I'm considering writing those emails directly into the SMTP (win2k), using CFFILE. Maybe one of you can clarify this single point to me. How should be the syntax of the file in order to SMTP process HTML e-mails correctly? Do you know any website with such information? I found some articles here on cflist and on evolt.org but they're all related to plain text e-mails. It will be very nice if you could share some pages with related information. Thank you. LC. Ps: I checked Jochem's tag but, unfortunatly, it does not work with CFMX. http://jochem.vandieten net/coldfusion/customtags/advancedemail/advancedemail.html ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server is very slow
H ... What happens if you restart services? -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 1:00 PM To: CF-Talk Subject: RE: Server is very slow Found it (capital letters start the directory structure), but there is nothing in the directory at all. -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 9:53 AM To: CF-Talk Subject: RE: Server is very slow Does the cfusionmx/mail/spool directory have any zero bite files in it? Or a ton of mail? That would cause something like this. Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 12:50 PM To: CF-Talk Subject: Server is very slow I am running the new CFMX server on a sparc9 box with 2gig of ram and 2 750MHz processors. The CFMX server wants to hog 50% of the processor, as well as a half a gig of memory, without anyone even making requests to the server. Is this typical behavioral traits of MX? Is there any way to tame this server down a bit? Thanks for any info anyone may have? Ray Bujarski Direct 858-845-7669 Pager 858-636-9900 ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
error handling question
I have a loop that is doing a db insert.From time to time the data I am inserting will have some invalid data. So, loop will stop. What I need to do is to just skip insert if it can not insert it and keep going with the loop. Can cftry/cfcatch do this? Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Server ? for CF
<< How large are the databases? >> Not very large. 474mb for all. << What are the specs of the disks? >> I'm not sure what you mean. << Are your databases CPU bound or I/O bound? >> I/O bound. Thanks, Jeff ~| 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: Server is very slow
Thanks for the suggestion, I don't think this is the cause because the directory is completely empty. -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 9:53 AM To: CF-Talk Subject: RE: Server is very slow Does the cfusionmx/mail/spool directory have any zero bite files in it? Or a ton of mail? That would cause something like this. Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 12:50 PM To: CF-Talk Subject: Server is very slow I am running the new CFMX server on a sparc9 box with 2gig of ram and 2 750MHz processors. The CFMX server wants to hog 50% of the processor, as well as a half a gig of memory, without anyone even making requests to the server. Is this typical behavioral traits of MX? Is there any way to tame this server down a bit? Thanks for any info anyone may have? Ray Bujarski Direct 858-845-7669 Pager 858-636-9900 ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server is very slow
Found it (capital letters start the directory structure), but there is nothing in the directory at all. -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 9:53 AM To: CF-Talk Subject: RE: Server is very slow Does the cfusionmx/mail/spool directory have any zero bite files in it? Or a ton of mail? That would cause something like this. Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 12:50 PM To: CF-Talk Subject: Server is very slow I am running the new CFMX server on a sparc9 box with 2gig of ram and 2 750MHz processors. The CFMX server wants to hog 50% of the processor, as well as a half a gig of memory, without anyone even making requests to the server. Is this typical behavioral traits of MX? Is there any way to tame this server down a bit? Thanks for any info anyone may have? Ray Bujarski Direct 858-845-7669 Pager 858-636-9900 ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server is very slow
Do you know where the mail spool will install to by default? I looked in /opt/coldfusionmx/... But no mail/spool directory. I am not sure where to look for this directory. -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 9:53 AM To: CF-Talk Subject: RE: Server is very slow Does the cfusionmx/mail/spool directory have any zero bite files in it? Or a ton of mail? That would cause something like this. Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 12:50 PM To: CF-Talk Subject: Server is very slow I am running the new CFMX server on a sparc9 box with 2gig of ram and 2 750MHz processors. The CFMX server wants to hog 50% of the processor, as well as a half a gig of memory, without anyone even making requests to the server. Is this typical behavioral traits of MX? Is there any way to tame this server down a bit? Thanks for any info anyone may have? Ray Bujarski Direct 858-845-7669 Pager 858-636-9900 ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: silicon
I am trying to tell our management that we need more ppl. Does anyone work for a silicon manufacturing company that supports it's engineers? If so I am trying to understand the industry standard for howmany cfml developers per engineer. Thanks for any input... Ray Bujarski Direct 858-845-7669 Pager 858-636-9900 ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFM Shopping Cart System
Same here. -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 12:50 PM To: CF-Talk Subject: Re: CFM Shopping Cart System I would be interested is seing it too. - Original Message - From: "Manesh Manickam" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 9:35 AM Subject: RE: CFM Shopping Cart System > Nice site, do you think I could get the source and try to see if I > could get > it to work on a computer site? thanks > > -Original Message- > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 10:57 AM > To: CF-Talk > > Just the checkout feature. > I have shipping features built in but its commented out because they wanted > paypal to do shipping as well. > > -Original Message- > From: Jason Miller [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 10:58 AM > To: CF-Talk > Subject: Re: CFM Shopping Cart System > > > Out of curiousity - how much is integrated with paypal? Just checkout? > Actual product catalog? Curious to see if it could handle one of my > client needs. Thanks, Jason > > Matt Blatchley ~ Bridgeleaf Studios wrote: > > Dave, > > > > Clean site, I like it. You should make it so the user can add the > > product to the cart as soon as they see it, not just on the detail > > page. How many clicks does it take to get them to add it to the > > cart. If the user has to go to the detail page then it's too many. > > Other than that, it'd very nice and clean. Clean design and well > > formatted. > > > > Matt > > > > -Original Message- > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > > Sent: Friday, June 27, 2003 7:04 AM > > To: CF-Talk > > Subject: RE: CFM Shopping Cart System > > > > > > I just completed a site that uses a shopping cart system with > > paypal. http://www.savvy-selections.com/catalog.cfm > > > > > > -Original Message- > > From: Manesh Manickam [mailto:[EMAIL PROTECTED] > > Sent: Thursday, June 26, 2003 11:02 PM > > To: CF-Talk > > Subject: CFM Shopping Cart System > > > > > > I was wondering if there are any free shopping cart systems for cfm, > > that are actually good! As in inventory, paypal authoring. Thanks > > for you help guys and girls! > > > > > > > > > > > > > ~| 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: Server is very slow
Does the cfusionmx/mail/spool directory have any zero bite files in it? Or a ton of mail? That would cause something like this. Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 12:50 PM To: CF-Talk Subject: Server is very slow I am running the new CFMX server on a sparc9 box with 2gig of ram and 2 750MHz processors. The CFMX server wants to hog 50% of the processor, as well as a half a gig of memory, without anyone even making requests to the server. Is this typical behavioral traits of MX? Is there any way to tame this server down a bit? Thanks for any info anyone may have? Ray Bujarski Direct 858-845-7669 Pager 858-636-9900 ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFM Shopping Cart System
I would be interested is seing it too. - Original Message - From: "Manesh Manickam" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 9:35 AM Subject: RE: CFM Shopping Cart System > Nice site, do you think I could get the source and try to see if I could get > it to work on a computer site? thanks > > -Original Message- > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 10:57 AM > To: CF-Talk > > Just the checkout feature. > I have shipping features built in but its commented out because they wanted > paypal to do shipping as well. > > -Original Message- > From: Jason Miller [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 10:58 AM > To: CF-Talk > Subject: Re: CFM Shopping Cart System > > > Out of curiousity - how much is integrated with paypal? Just checkout? > Actual product catalog? > Curious to see if it could handle one of my client needs. Thanks, Jason > > Matt Blatchley ~ Bridgeleaf Studios wrote: > > Dave, > > > > Clean site, I like it. You should make it so the user can add the > > product to the cart as soon as they see it, not just on the detail > > page. How many clicks does it take to get them to add it to the cart. > > If the user has to go to the detail page then it's too many. Other > > than that, it'd very nice and clean. Clean design and well formatted. > > > > Matt > > > > -Original Message- > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > > Sent: Friday, June 27, 2003 7:04 AM > > To: CF-Talk > > Subject: RE: CFM Shopping Cart System > > > > > > I just completed a site that uses a shopping cart system with paypal. > > http://www.savvy-selections.com/catalog.cfm > > > > > > -Original Message- > > From: Manesh Manickam [mailto:[EMAIL PROTECTED] > > Sent: Thursday, June 26, 2003 11:02 PM > > To: CF-Talk > > Subject: CFM Shopping Cart System > > > > > > I was wondering if there are any free shopping cart systems for cfm, > > that are actually good! As in inventory, paypal authoring. Thanks for > > you help guys and girls! > > > > > > > > > > > > > ~| 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
Server is very slow
I am running the new CFMX server on a sparc9 box with 2gig of ram and 2 750MHz processors. The CFMX server wants to hog 50% of the processor, as well as a half a gig of memory, without anyone even making requests to the server. Is this typical behavioral traits of MX? Is there any way to tame this server down a bit? Thanks for any info anyone may have? Ray Bujarski Direct 858-845-7669 Pager 858-636-9900 ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFM Shopping Cart System
Nice site, do you think I could get the source and try to see if I could get it to work on a computer site? thanks -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:57 AM To: CF-Talk Just the checkout feature. I have shipping features built in but its commented out because they wanted paypal to do shipping as well. -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:58 AM To: CF-Talk Subject: Re: CFM Shopping Cart System Out of curiousity - how much is integrated with paypal? Just checkout? Actual product catalog? Curious to see if it could handle one of my client needs. Thanks, Jason Matt Blatchley ~ Bridgeleaf Studios wrote: > Dave, > > Clean site, I like it. You should make it so the user can add the > product to the cart as soon as they see it, not just on the detail > page. How many clicks does it take to get them to add it to the cart. > If the user has to go to the detail page then it's too many. Other > than that, it'd very nice and clean. Clean design and well formatted. > > Matt > > -Original Message- > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 7:04 AM > To: CF-Talk > Subject: RE: CFM Shopping Cart System > > > I just completed a site that uses a shopping cart system with paypal. > http://www.savvy-selections.com/catalog.cfm > > > -Original Message- > From: Manesh Manickam [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 26, 2003 11:02 PM > To: CF-Talk > Subject: CFM Shopping Cart System > > > I was wondering if there are any free shopping cart systems for cfm, > that are actually good! As in inventory, paypal authoring. Thanks for > you help guys and girls! > > > > > ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image Editor
Benoit Hedigard (sp?) wrote a little CFC frontend for ImageJ, which is an open source Java image editing package. obviously you won't be able to use the CFC on CF5, but pulling the appropriate method bodies out of the CFC and putting them in you code (or more probably UDFs/custom tags) shouldn't be much of a task. check out www.benorama.com in the ColdFUsion section, down near the bottom of the page. --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -Original Message- > From: Cedric Villat [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 26, 2003 9:42 PM > To: CF-Talk > Subject: Image Editor > > > Anyone know of an image editor, like resizing gifs/jpgs, etc, > that will work > on a unix/linux server? It also has to work on CF5. Any recommendations? > > Cedric > > > ~| 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: Change document root of internal Web Server?
> Folks know where to modify the document root of the internal > web server on cfmx? Could have sworn this was possible but I > must be blind...I don't see it... http://www.macromedia.com/support/coldfusion/adv_development/config_builtin_ webserver/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| 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: OT: Server ? for CF
Horne, Jeff wrote: > We have two servers to choose from for loading CF. One is a current CF > webserver, the other is a new webserver that will be used for MySQL > databases. My dilema is, since I have the option now, which one do I want > to run CF on? I can switch them around and run either piece on either > server. How large are the databases? What are the specs of the disks? Are your databases CPU bound or I/O bound? Jochem ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOLVED: URLEncodedFormat and IE bug ?
no, that's not new, but I too just discovered it about 6 months ago. I must have been under a rock to miss this one. This little function is most powerful for sure. >-Original Message- >From: Stacy Young [mailto:[EMAIL PROTECTED] >Sent: Friday, June 27, 2003 11:34 AM >To: CF-Talk >Subject: SOLVED: URLEncodedFormat and IE bug ? > > >Ah...have to use this instead...(think new in cfmx?) > >JSStringFormat() > > >-Stace > >-Original Message- >From: Stacy Young >Sent: Friday, June 27, 2003 10:44 AM >To: CF-Talk >Subject: URLEncodedFormat and IE bug ? > >Something odd I've just come across on one of our older apps. Below is >an example of a link that uses URLEncodedFormat() for an account name. >Worked fine for 2+ years until IE6.0.2800 on XP Pro. > >javascript:document.myform.account.value='A%20Dog%27s%20Life%20 >Inc%2E';d >ocument.myform.submit(); > >IE complains of a javascript error saying it's " expecting a ';' ". >Anyone run into this? > >Stace > > >AVIS IMPORTANT: >--- >Les informations contenues dans le present document et ses pieces >jointes sont strictement confidentielles et reservees a l'usage de la >(des) personne(s) a qui il est adresse. Si vous n'etes pas le >destinataire, soyez avise que toute divulgation, distribution, >copie, ou >autre utilisation de ces informations est strictement prohibee. Si vous >avez recu ce document par erreur, veuillez s'il vous plait communiquer >immediatement avec l'expediteur et detruire ce document sans >en faire de >copie sous quelque forme. > >WARNING: >--- >The information contained in this document and attachments is >confidential and intended only for the person(s) named above. >If you are >not the intended recipient you are hereby notified that any disclosure, >copying, distribution, or any other use of the information is strictly >prohibited. If you have received this document by mistake, >please notify >the sender immediately and destroy this document and >attachments without >making any copy of any kind. > > > ~| 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
Change document root of internal Web Server?
Damn I'm rusty... Folks know where to modify the document root of the internal web server on cfmx? Could have sworn this was possible but I must be blind...I don't see it... Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| 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: Server ? for CF
I'd use the more powerful box as the database server. You can then add more web servers as necessary and hopefully be able to use the same db box. -Original Message- From: Horne, Jeff [mailto:[EMAIL PROTECTED] Sent: 27 June 2003 16:48 To: CF-Talk Subject: OT: Server ? for CF We have two servers to choose from for loading CF. One is a current CF webserver, the other is a new webserver that will be used for MySQL databases. My dilema is, since I have the option now, which one do I want to run CF on? I can switch them around and run either piece on either server. The specs are below and thanks for any input. Thanks, Jeff *** New Server *** Processing Speed 2.4 GHZ Memory 1 GB Hard Drive CTotal space available 7.8 GB DTotal space available 26 GB (Currently used Hard drive has RAID5, 3 drives connected to on-board RAID. Each drive 18 GB *** Current CF Server *** Processing Speed 600 MHZ Dual processor Memory 1 GB Hard Drive CTotal space available 1.95GB DTotal space available 50.5 GB (Currently used on production server = 22.8 GB (Currently loaded on new ColdFusion server = 1.27 GB) ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Do CFCs cache?
Have you applied any updaters? Perhaps it's the 'ol class caching issues from the old days. ;) Stace -Original Message- From: Andrew S. Peterson [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 8:51 AM To: CF-Talk Subject: Do CFCs cache? If I go into a cfc and modify a function, save it, reload the page that calls it, the page that does the calling still pulls up the old version of the function that existed before I made the changes. For instance, if I call a function called getEntries but modify the code within getEntries, the calling page does not recognize any of the changes. Further, I renamed a function getEntries to getEntriesX and refreshed the page again that calls getEntries, and I did NOT get the error that getEntries was not found, until I restart the server, then I get the error message that getEntries was not found (since I renamed it). In effect, the page does not recognize any changes to my cfc until I reboot the server or service. It makes for some awkward debugging to say the least, since none of my changes ever take effect. I've tried this on multiple servers with the same issue. Is it a compile thing? Am I the only one who doesn't know about this? :-) Sincerely, Andrew ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOLVED: URLEncodedFormat and IE bug ?
Ah...have to use this instead...(think new in cfmx?) JSStringFormat() -Stace -Original Message- From: Stacy Young Sent: Friday, June 27, 2003 10:44 AM To: CF-Talk Subject: URLEncodedFormat and IE bug ? Something odd I've just come across on one of our older apps. Below is an example of a link that uses URLEncodedFormat() for an account name. Worked fine for 2+ years until IE6.0.2800 on XP Pro. javascript:document.myform.account.value='A%20Dog%27s%20Life%20Inc%2E';d ocument.myform.submit(); IE complains of a javascript error saying it's " expecting a ';' ". Anyone run into this? Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| 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
Recall: CF-Talk: Digest every 8 hours
Fat Fingered this one. Sorry, Jeff ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Server ? for CF
We have two servers to choose from for loading CF. One is a current CF webserver, the other is a new webserver that will be used for MySQL databases. My dilema is, since I have the option now, which one do I want to run CF on? I can switch them around and run either piece on either server. The specs are below and thanks for any input. Thanks, Jeff *** New Server *** Processing Speed 2.4 GHZ Memory 1 GB Hard Drive CTotal space available 7.8 GB DTotal space available 26 GB (Currently used Hard drive has RAID5, 3 drives connected to on-board RAID. Each drive 18 GB *** Current CF Server *** Processing Speed 600 MHZ Dual processor Memory 1 GB Hard Drive CTotal space available 1.95GB DTotal space available 50.5 GB (Currently used on production server = 22.8 GB (Currently loaded on new ColdFusion server = 1.27 GB) ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Recall: CF-Talk: Digest every 8 hours
Horne, Jeff would like to recall the message, "CF-Talk: Digest every 8 hours". ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF-Talk: Digest every 8 hours
-Original Message- From: CF-Talk [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 8:03 AM To: CF-Talk Subject: CF-Talk: Digest every 8 hours CF-Talk 27-Jun-03 Issue:377 In this issue: Browser resize looses attributes scope Browser resize looses attributes scope Calendar App Calendar App Calendar App Calendar App Calendar App Calendar App Calendar App Calendar App Calendar App Calendar App Calendar App Calendar App Calendar App Calendar App Calendar App Calendar/Exchange Server CF Email Parsing Tag/Function CF Email Parsing Tag/Function CFC performance difficulties CFC performance difficulties CFC performance difficulties CFC performance difficulties CFC performance difficulties CFM Shopping Cart System CFMX Running on FreeBSD 5.1-RELEASE Creating a CF Data Source with CF Code - Possible? Creating a CF Data Source with CF Code - Possible? CSV Question CSV Question CSV Question CSV Question Hardware Disable Right-Click Hardware Disable Right-Click Hardware Disable Right-Click Homesite + question Homesite + question Homesite + question Homesite + question Homesite + question Homesite + question Homesite + question Homesite + question how to get the tablenames in a database how to get the tablenames in a database how to get the tablenames in a database how to get the tablenames in a database how to get the tablenames in a database how to get the tablenames in a database How to stop DW from chocking on FB index file How to stop DW from chocking on FB index file How to stop DW from chocking on FB index file Image Editor Image Editor java.lang.IndexOutOfBoundsException java.lang.IndexOutOfBoundsException OT: email "bouncing" problems OT: email "bouncing" problems Self-Contained templates? WAS: The Verbosity of CFOUTPUT Self-Contained templates? WAS: The Verbosity of CFOUTPUT Self-Contained templates? WAS: The Verbosity of CFOUTPUT SOT: Canberra (Australia) CF/MM User group The Verbosity of CFOUTPUT The Verbosity of CFOUTPUT treating queries as structures/array treating queries as structures/array treating queries as structures/array treating queries as structures/array treating queries as structures/array treating queries as structures/array UDF for XML What calendar features do people want WAS -> Calendar App ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Yahoo Web Services?
Check this calendar app, written in CF 5.0 running against a MySQL database. http://www.bsa-troop401.net/calendar/index.cfm == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 == If you are not satisfied with my service, my job isn't done! - Original Message - From: "Hagan, Ryan Mr (Contractor ACI)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 10:07 AM Subject: Yahoo Web Services? | Greetings, | | Does anyone know if Yahoo! has, or plans to, release any web services based | on their applications? There's been talk of lots of people wanting to | create various types of calendar apps, and I was just thinking that it would | be really nice to be able to use Yahoo!'s calendar application through a web | service. Not to mention any of the other applications they provide. | | | Ryan Hagan | ph: 540-731-3598 | | ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Do CFCs cache?
Oh dang. It's being set in the application scope. I guess that makes sense to me. Thanks for your help. Sincerely, Andrew -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 7:12 AM To: CF-Talk Subject: RE: Do CFCs cache? How are you calling the CFC? If you instantiate it as a cfc (not stored in the session or application scope) then the changes should be shown. If you set it in the Session or Application scope then they will need to be re-set. If you are calling the CFC as a webservice then you will need to refresh the webservice via the CF Administrator HTH Mikey -Original Message- From: Andrew S. Peterson [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 13:51 To: CF-Talk Subject: Do CFCs cache? If I go into a cfc and modify a function, save it, reload the page that calls it, the page that does the calling still pulls up the old version of the function that existed before I made the changes. For instance, if I call a function called getEntries but modify the code within getEntries, the calling page does not recognize any of the changes. Further, I renamed a function getEntries to getEntriesX and refreshed the page again that calls getEntries, and I did NOT get the error that getEntries was not found, until I restart the server, then I get the error message that getEntries was not found (since I renamed it). In effect, the page does not recognize any changes to my cfc until I reboot the server or service. It makes for some awkward debugging to say the least, since none of my changes ever take effect. I've tried this on multiple servers with the same issue. Is it a compile thing? Am I the only one who doesn't know about this? :-) Sincerely, Andrew ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Survey/questionnaire app
Can anyone recommend a good survey or questionnaire app? I need to collect survey data but not post the combined results. ~| 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
Yahoo Web Services?
Greetings, Does anyone know if Yahoo! has, or plans to, release any web services based on their applications? There's been talk of lots of people wanting to create various types of calendar apps, and I was just thinking that it would be really nice to be able to use Yahoo!'s calendar application through a web service. Not to mention any of the other applications they provide. Ryan Hagan ph: 540-731-3598 ~| 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: CFM Shopping Cart System
Just the checkout feature. I have shipping features built in but its commented out because they wanted paypal to do shipping as well. -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:58 AM To: CF-Talk Subject: Re: CFM Shopping Cart System Out of curiousity - how much is integrated with paypal? Just checkout? Actual product catalog? Curious to see if it could handle one of my client needs. Thanks, Jason Matt Blatchley ~ Bridgeleaf Studios wrote: > Dave, > > Clean site, I like it. You should make it so the user can add the > product to the cart as soon as they see it, not just on the detail > page. How many clicks does it take to get them to add it to the cart. > If the user has to go to the detail page then it's too many. Other > than that, it'd very nice and clean. Clean design and well formatted. > > Matt > > -Original Message- > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 7:04 AM > To: CF-Talk > Subject: RE: CFM Shopping Cart System > > > I just completed a site that uses a shopping cart system with paypal. > http://www.savvy-selections.com/catalog.cfm > > > -Original Message- > From: Manesh Manickam [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 26, 2003 11:02 PM > To: CF-Talk > Subject: CFM Shopping Cart System > > > I was wondering if there are any free shopping cart systems for cfm, > that are actually good! As in inventory, paypal authoring. Thanks for > you help guys and girls! > > > > > ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
URLEncodedFormat and IE bug ?
Something odd I've just come across on one of our older apps. Below is an example of a link that uses URLEncodedFormat() for an account name. Worked fine for 2+ years until IE6.0.2800 on XP Pro. javascript:document.myform.account.value='A%20Dog%27s%20Life%20Inc%2E';d ocument.myform.submit(); IE complains of a javascript error saying it's " expecting a ';' ". Anyone run into this? Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFM Shopping Cart System
Out of curiousity - how much is integrated with paypal? Just checkout? Actual product catalog? Curious to see if it could handle one of my client needs. Thanks, Jason Matt Blatchley ~ Bridgeleaf Studios wrote: > Dave, > > Clean site, I like it. You should make it so the user can add the product > to the cart as soon as they see it, not just on the detail page. How many > clicks does it take to get them to add it to the cart. If the user has to > go to the detail page then it's too many. Other than that, it'd very nice > and clean. Clean design and well formatted. > > Matt > > -Original Message- > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 7:04 AM > To: CF-Talk > Subject: RE: CFM Shopping Cart System > > > I just completed a site that uses a shopping cart system with paypal. > http://www.savvy-selections.com/catalog.cfm > > > -Original Message- > From: Manesh Manickam [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 26, 2003 11:02 PM > To: CF-Talk > Subject: CFM Shopping Cart System > > > I was wondering if there are any free shopping cart systems for cfm, that > are actually good! As in inventory, paypal authoring. Thanks for you help > guys and girls! > > > > > ~| 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: Do CFCs cache?
Check the path to the CFC. Make sure that if the CFC is in a sub-directory,
that you provide the complete path. Otherwise, it will look to a cached
version:
createObject("component","correctpath.MyCFC")
Andy
-Original Message-
From: Andrew S. Peterson [mailto:[EMAIL PROTECTED]
Sent: Friday, June 27, 2003 7:51 AM
To: CF-Talk
Subject: Do CFCs cache?
If I go into a cfc and modify a function, save it, reload the page that
calls it, the page that does the calling still pulls up the old version
of the function that existed before I made the changes. For instance, if
I call a function called getEntries but modify the code within
getEntries, the calling page does not recognize any of the changes.
Further, I renamed a function getEntries to getEntriesX and refreshed
the page again that calls getEntries, and I did NOT get the error that
getEntries was not found, until I restart the server, then I get the
error message that getEntries was not found (since I renamed it). In
effect, the page does not recognize any changes to my cfc until I reboot
the server or service. It makes for some awkward debugging to say the
least, since none of my changes ever take effect.
I've tried this on multiple servers with the same issue. Is it a compile
thing? Am I the only one who doesn't know about this? :-)
Sincerely,
Andrew
~|
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
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
