Re: catching broken links?
I have a pure CF solution. email me if interested. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239843 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: getting the closest number to an increment of 25,000
Closest number, which is SMALLER than a given num (round down): cfset down25 = 25000 * int(num/25000) Closest number, which is LARGER than a given num (round up): cfset up25 = 25000 * ceiling(num/25000) Closest number (round): cfset round25 = 25000 * int(0.5 + num/25000) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237116 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFEXECUTE
Try to use cscript.exe instead of wscript.exe ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237120 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: getting the closest number to an increment of 25,000
Closest number (round): cfset round25 = 25000 * int(0.5 + num/25000) You can just use round for this, instead of adding an then using int: cfset round25 = 25000 * round(num / 25000) / cheers, barneyb On 4/6/06, One User [EMAIL PROTECTED] wrote: -- Barney Boisvert Of course. I use int(0.5+... because that Java rounding (MX and up), sometimes gives strange results. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237123 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Multithreading within a request
Is it possible to multithread within a single request. For example, I would like to make multiple http requests to a web service, but at the moment they run one after the other, taken about 3 seconds each, but if I could run them both at the same time it would improve the performance of the script greatly, any ideas on how this could be done? http://www.cftagstore.com/tags/cfxhttp5.cfm ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237131 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Cybersource CF tag
If you under Windows, post your email. I am looking for someone who has or can write me a CF tag for processing credit cards through cybersource's payment gateway. They publish examples for most scripting languages: http://www.cybersource.com/support_center/implementation/downloads/ I just don't have time to write one from scratch. I have a budget of $300. Any takers? Thanks, Dave Livingston ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217520 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFHTTP calling an infinite loop
This fixes the problem: http://www.cftagstore.com/tags/cfxhttp5.cfm Thanks for looking at it Dave, it has me completely stumped, I always seem to find the cruelest limitations of a technology where there's no way out. I think the CFHTTP timeout is probably working as intended, so that if no reply at all is received then the timeout applies. The problem is that there's no way to tell CFHTTP when to stop after it does start receiving data AND there wasn't an error in the HTTP header. It's pretty interesting to put the code snip on a server and watch CPU utilization in the Task Manager when it's run. CPU utilization starts rising pretty rapidly, it takes ten or fifteen seconds to get all the way to 100% and then it's just pegged there forever, which means I can't ever let my link checker run unattended, and nobody else who ever builds a link checker with ColdFusion can either. Sometimes CPU utilization rises and falls a few times, creating an upward sawtooth pattern before it reaches 100%. I've tried putting the CFHTTP in a CFLOOP inside a custom tag to use CFEXIT logic on it, trying to break out of the loop execution after a few seconds time, but that didn't work either. I could theoretically accomplish the goal by using CFEXECUTE to run Ping.exe, but then I'd have to parse the output to get the ping time and deal with every possible error message, ack. What do you think the chances are that MM would patch version 5.0 CFHTTP for me with a 'global timeout' to force CFHTTP to stop after X seconds, LOL? Other than that I'm at a loss for a fix to this problem unless somebody else has some brilliant ideas. Do you know how to report a bug to Macromedia? Their website discusses various levels of paid support, but I am not about to pay them for the privilege of informing them of a bug in their code. Regards, Karl S. At 06:59 AM 8/12/05, Dave wrote: -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.8/71 - Release Date: 8/12/05 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214842 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFHTTP calling an infinite loop
Oops... Found the original post... This is not a timeout issue, because their server is outputting data and does not stop. Since HTTP allows the response not to have Content-Length header, the garbage they output is perfectly valid response. What needed is some limit on the size of received content that does not exist in CFHTTP... ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214843 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: File Progress Bar - Flash Remoting
http://www.cftagstore.com/tags/cfxupload.cfm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214117 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Don't wait for webservice?
May want to look here: http://www.cftagstore.com/tags/cfxhttp5.cfm I would like to use a web service to invoke a function on a remote server, but I explicitly *don't* want my local server to wait for the remote server to complete the action. I just want my local server to send the command and then move on. Is this sort of thing possible? And if so, is it considered an okay idea? Any help is appreciated. Ben Mueller ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209958 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
executing windows scheduled tasks through CF
If the problem is in executing a task under another account, use this: http://www.cftagstore.com/tags/cfxexec.cfm This is a replacement for CFEXECUTE that allows account switching. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209635 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: REPOST Re: FedEx Shipping custom tags
We use CFX_FEDEX for a long time and it works fine. What else can I say? I don't have any experience with the other tag. If people are selling it, I assume it works also. spent a week or so trying to work out the integration myself for my ecommerce software . . . I'm not sure I'd pay $250 for one though!... What is your salary per hour? If you earn below $250 a week, it might worth to waste one week of your time for unsuccessful project. Otherwise, consider to buy something that works. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209230 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: REPOST Re: FedEx Shipping custom tags
Also. Just checked cf_FedEx on adminprotools.com. Here some observations: - For $49 you get only the ability to issue the rate and tracking requests. No actual shipping supported. You have to pay $149 for a full version that allows shipping operations. - Labels are browser-based, as far as I understand. CFX_FEDEX actually saves labels in various formats and also prints them. - Ground shipping manifests supported, as PNG file?? Not a document (text) file. - Not clear whether return labels supported or not. - Not clear what label formats are supported. - No trial version. You have to buy it in order to try. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209235 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: asynch cfml gateway - working example
This provides asynchronous capabilities in full. And without MX7. http://www.cftagstore.com/tags/cfxhttp5.cfm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208918 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: asynch cfml gateway - working example
Windows hosts files? Potential external/unknown variables? Hmmm... What you are talking about? Give me a potential point of break. Multithreading assumes cooperation between different parts of a task. So-called async gateways are just parallel and NOT cooperating DIFFERENT tasks. If this is what you want, try CFEXECUTE first. Looks nice, although I wouldn't use it for asynch processing... Reason I want to use the asynch cfml gateway is to eliminate an http request as a potential point at which the process could break -- I realize I'm trading out cfhttp for the gateway, but it seems like the gateway would be more contained / involve fewer potential external/unknown variables like for instance, windows hosts files. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208929 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Digest Authentication
This tag supports it: http://www.cftagstore.com/tags/cfxhttp5.cfm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207963 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfexecute and wget
Try this instead: http://www.cftagstore.com/tags/cfxhttp5.cfm Roger I was using cfexecute because I wanted the process to launch and then release. So the page calling it could still continue processing. Kind of a poor mans version of creating another thread to process in the background. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207964 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How do you change this number 70.0500 to 70.05?
Anyone have any idea how to change a number thats being outputted from a table as 70.0500 to 70.05 with only 2 decimal points. Is this doable thru a change in SQL 2000 or a change in the query itself? I'm doing an email merge, and the tag used won't allow formatting of anything within the body of the email, so the data has to be correctly formatted before being inserted into the email. The above number is a dollar amount owed by customers past due, so it need to be displayed in the email as $70.05 and right now shows as $70.0500 Appreciate any insights. Thanks. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do you change this number 70.0500 to 70.05?
Thanks for your help. Only thing is a list of about 1000 clients is merged into the Activ Mail tag, and so each record has to be formatted within the query itself because Active Mail only takes lists from the query, not from CFPARAM or CFSET. The emails go out only to clients who's accounts are past due, but again the email tag uses variables only coming directly from within a query. Also, the database is managed by another company and they may be averse to changing the field type to decimal with a scale of 2, although I'm going to try that as the first option. Is there anyway to perhaps format fields with a function directly in the queries? Regards, Pardeep. - Original Message - From: Christopher Olive [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 12:59 PM Subject: RE: How do you change this number 70.0500 to 70.05? try making the field decimal with a scale of 2. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 4:08 PM To: CF-Talk Subject: Re: How do you change this number 70.0500 to 70.05? Anyone have any idea how to change a number thats being outputted from a table as 70.0500 to 70.05 with only 2 decimal points. Is this doable thru a change in SQL 2000 or a change in the query itself? I'm doing an email merge, and the tag used won't allow formatting of anything within the body of the email, so the data has to be correctly formatted before being inserted into the email. The above number is a dollar amount owed by customers past due, so it need to be displayed in the email as $70.05 and right now shows as $70.0500 Appreciate any insights. Thanks. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do you change this number 70.0500 to 70.05?
I forgot to mention, the Activ Mail tag won't take regular Cold Fusion variables with the # signs, it works with only what they refer to as Tokens, and the Tokens which are really data from a query can't be formatted with regular Cold Fusion functions such as dollarformat, etc. Hence the need to somehow format within a query or revert to changing the database field type structure. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do you change this number 70.0500 to 70.05?
How do you round it off? Multiply the number b7 100, round it off, and then divide by 100. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 4:22 PM To: CF-Talk Subject: Re: How do you change this number 70.0500 to 70.05? Thanks for your help. Only thing is a list of about 1000 clients is merged into the Activ Mail tag, and so each record has to be formatted within the query itself because Active Mail only takes lists from the query, not from CFPARAM or CFSET. The emails go out only to clients who's accounts are past due, but again the email tag uses variables only coming directly from within a query. Also, the database is managed by another company and they may be averse to changing the field type to decimal with a scale of 2, although I'm going to try that as the first option. Is there anyway to perhaps format fields with a function directly in the queries? Regards, Pardeep. - Original Message - From: Christopher Olive [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 12:59 PM Subject: RE: How do you change this number 70.0500 to 70.05? try making the field decimal with a scale of 2. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 4:08 PM To: CF-Talk Subject: Re: How do you change this number 70.0500 to 70.05? Anyone have any idea how to change a number thats being outputted from a table as 70.0500 to 70.05 with only 2 decimal points. Is this doable thru a change in SQL 2000 or a change in the query itself? I'm doing an email merge, and the tag used won't allow formatting of anything within the body of the email, so the data has to be correctly formatted before being inserted into the email. The above number is a dollar amount owed by customers past due, so it need to be displayed in the email as $70.05 and right now shows as $70.0500 Appreciate any insights. Thanks. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do you change this number 70.0500 to 70.05?
Just tried this code, but alas, no dice:(
Thanks for the suggestion tho.
- Original Message -
From: VAN VLIET, SCOTT E (SBCSI) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 2:07 PM
Subject: RE: How do you change this number 70.0500 to 70.05?
SELECT ('$' + CONVERT(VARCHAR,DollarField)) As DollarField
FROM TABLENAME
(Where DollarField is the Column you are getting the dollar value from)
The convert function trimmed off to only 2 decimals in the conversion. I
was starting to get all crazy with SUBSTING, but I think will work just
fine. HTH!
--
Scott Van Vliet
Senior Analyst
SBC Services, Inc.
ITO Enterprise Tools
Office: 858.886.3878
Pager: 858.536.0070
Email: [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 1:22 PM
To: CF-Talk
Subject: Re: How do you change this number 70.0500 to 70.05?
Thanks for your help. Only thing is a list of about 1000 clients is merged
into the Activ Mail tag, and so each record has to be formatted within the
query itself because Active Mail only takes lists from the query, not from
CFPARAM or CFSET. The emails go out only to clients who's accounts are
past
due, but again the email tag uses variables only coming directly from
within
a query. Also, the database is managed by another company and they may be
averse to changing the field type to decimal with a scale of 2, although
I'm
going to try that as the first option.
Is there anyway to perhaps format fields with a function directly in the
queries?
Regards,
Pardeep.
- Original Message -
From: Christopher Olive [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 12:59 PM
Subject: RE: How do you change this number 70.0500 to 70.05?
try making the field decimal with a scale of 2.
christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 4:08 PM
To: CF-Talk
Subject: Re: How do you change this number 70.0500 to 70.05?
Anyone have any idea how to change a number thats being outputted from a
table as 70.0500 to 70.05 with only 2 decimal points.
Is this doable thru a change in SQL 2000 or a change in the query
itself?
I'm doing an email merge, and the tag used won't allow formatting of
anything within the body of the email, so the data has to be correctly
formatted before being inserted into the email. The above number is a
dollar
amount owed by customers past due, so it need to be displayed in the
email
as $70.05 and right now shows as $70.0500
Appreciate any insights. Thanks.
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to format numerical data in SQL 2000 table?
How do you format numbers in SQL 2000 table. i.e. So that a number that is used in a mail merge shows up as either 500.00 or 500 In one case with only two decimal points and in the other, with none. The first is to be used with displaying currency values, i.e. $500.00 The second with customer account numbers - i.e. 500 At the moment these numbers are showing up as 500.000 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Emails get jammed in CF 5 using CF Mail
Anyone know why emails get jammed or put into undeliverable folder using CF Mail in CF 5. I am CF Ticked off on this one and now dare I say it, even CF Perplexed!! __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Activ Mail vs. Infusion SE Mail tag
Does anyone know the pros and cons of sending email internally through a tag's own SMTP server vs. sending all generated emails to the email server. Activ Mail sends emails to the email server. Infusion Mail SE sends them out internally. Appreciate any feedback on the real world pros and cons of either tag. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Activ Mail vs. Infusion SE Mail tag
Does anyone know the pros and cons of sending email internally through a tag's own SMTP server vs. sending all generated emails to the email server. Activ Mail sends emails to the email server. Infusion Mail SE sends them out internally. Appreciate any feedback on the real world pros and cons of either tag. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IMS Fusion Mail vs. ActivMail ?!!
Does anyone know the main differences between IMS Fusion Mail tag at: http://www.coolfusion.com/moreinfo.cfm?Product_ID=39 and the ActivMail tag at: http://www.cfdev.com/jmail/ __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFAuthorize tag not working with CF 5 ?!! Any ideas why not?
Am having a problem connecting to Authorizenet using the cfauthorize tag with Cold Fusion 5. Any ideas what the problem might be or any ideas on how to fix it? Regards, Pardee. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Does CFHTTP in CF 5 only handle 56 bit encyrption?
Does CFHTTP in CF 5 only handle 56 bit encyrption? This is what I read on their site? If its true, it sucks, because I'm trying to use CF Authorize, a 3rd party tag. Due to United States export limitations that were in effect when Macromedia ColdFusion Server 4.5 and 5 were released, the cfhttp tag only supports 56-bit encryption. If you try to use 128-bit encryption you will get a communication failure error. Secure Sockets Layer (SSL) is a protocol developed by Netscape for secure message transmission over the Internet. The encryption is performed by a number of different cipher algorithms. When an SSL enabled client (browser) and SSL enabled Server communicate for the first time, they pick a cipher algorithm that they both support. Commonly used cipher algorithms include Export RC 2/RC4 40 and 128-bit encryption. You can use the cfhttp tag on a Secure Sockets Layer for negotiating secured transactions. Please note that currently the highest level of encryption supported is 56-bit. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFHTTP not connection to Authorizenet !!!???!!
Anyone have any ideas why CFHTTP may not be connecting with Authorizenet using the CF Authorize tag? Here is the response message: Your charge was declined for the following reason: An error occurred when attempting to connect with the credit card processor. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to expire session variables?
Is there a good way to consistently make sessions expire within a 10 min period? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Whats the best way to expire session variables when browser not closed?
Hi, I'm having a problem using session variables. They are set to time out at 120 (2 hours). However if someone does NOT close his browser and then they try to come back to the site after a couple of hours, they get an error message. Is there a way to flush and totally expire session variables with some code so that when they revisit after 2 hours, a new CFID and CFTOKEN are automatically assigned? I'm new to session variables, so maybe I'm misssing something obvious here. Thanks. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Whats the best way to expire session variables when browser not closed?
Hmmm, what if that session setting code is also in application.cfm?
So far my code looks like this in application.cfm after some thought over
the last hour.
cfif NOT isdefined('session.cid')
cfapplication name=protect
sessionmanagement=yes
sessiontimeout=#createtimespan(0,0,0,0)#
/cfif
cfapplication name=protect
clientmanagement=yes
sessionmanagement=yes
But ding dang dong, its still not working:( Any ideas?
- Original Message -
From: Joseph DeVore [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, March 23, 2002 3:06 PM
Subject: RE: Whats the best way to expire session variables when browser not
closed?
Pardeep,
One way you could accomplish this task is to add code like this to your
Application.cfm file.
cfif not isdefined('session.info')
cflocation url=setSessionVarsTemplate.cfm
/cfif
Any time the session information isn't available, it will send the user to
a
template that you set the session variables in.
HTH,
Joseph DeVore
VeloxWeb Technologies
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 23, 2002 11:41 AM
To: CF-Talk
Subject: Re: Whats the best way to expire session variables when browser
not closed?
Hi, I'm having a problem using session variables. They are set to time out
at 120 (2 hours).
However if someone does NOT close his browser and then they try to come
back
to the site after a couple of hours, they get an error message.
Is there a way to flush and totally expire session variables with some
code
so that when they revisit after 2 hours, a new CFID and CFTOKEN are
automatically assigned?
I'm new to session variables, so maybe I'm misssing something obvious
here.
Thanks.
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Problem with math in query !!!
Hi, I'm having a prob. with the following query to generate a report. There are 3 colums called: pastdue30 pastdue60 payments region So what I'm trying to do is add up pastdue30 and pastdue60 amounts and then minus payments - which is payment a customer has made to show what the net balance is thats still owed. The report needs to display only customers who are past due more than $1, hence the attempt to define this through the WHERE clause. CFQUERY NAME=accountsreceivable DATASOURCE=data SELECT region, payments - (pastdue30 + pastdue60) as netdue FROM accounts_receivable where (payments) - (pastdue30 + pastdue60) 1 order by total_due ASC /CFQUERY Any ideas where I might be messing up on this code? Also, if you wanted to summarize totals by region, and show the % each region is contributing to the overall total of past due accounts with the company, whats the best way to write a query for that? Thanks, Pardee. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Problem with math in query !!!
Thanks, that solved the problem:) - Original Message - From: John Wilker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 6:37 PM Subject: RE: Problem with math in query !!! What error do you get? This may not be the culprit but I'd wrap payments - (pastdue30 + pastdue60) in another set a parens. (payments - (pastdue30 + pastdue60)) just to make sure SQL (I presume) knows for certain what you are doing. Just some initial off the top of my head stuff J. John Wilker Web Applications Consultant, and Author Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com more people are killed by donkeys than by airplane crashes each year -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 7:10 PM To: CF-Talk Subject: Re: Problem with math in query !!! Hi, I'm having a prob. with the following query to generate a report. There are 3 colums called: pastdue30 pastdue60 payments region So what I'm trying to do is add up pastdue30 and pastdue60 amounts and then minus payments - which is payment a customer has made to show what the net balance is thats still owed. The report needs to display only customers who are past due more than $1, hence the attempt to define this through the WHERE clause. CFQUERY NAME=accountsreceivable DATASOURCE=data SELECT region, payments - (pastdue30 + pastdue60) as netdue FROM accounts_receivable where (payments) - (pastdue30 + pastdue60) 1 order by total_due ASC /CFQUERY Any ideas where I might be messing up on this code? Also, if you wanted to summarize totals by region, and show the % each region is contributing to the overall total of past due accounts with the company, whats the best way to write a query for that? Thanks, Pardee. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How do you 'blackout' a page while data being loaded?
Does anyone know how to make a page that will display a lot of data can be made to be completely black until all the information has been loaded and is ready for display? Some of the data in this instance is graphics being pulled from a database and it looks not very pretty as you see them being assembled since not everything loads at the same time. What I'm trying to accomplish is the same effect as on the clip art web sites, where the page goes black until the next set of selection have downloaded. I think there's a IE 5 page transition trick, but don't seem to be able to locate it. Thanks in advance for any tips. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Is is poss. to prevent page view till ALL data downloaded?
As an addition to last msg - is it possible to prevent a page view until all data has been downloaded? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL getting stuck in the SPOOL directory
Hi, I'm having problems with the top email in the SPOOL directory blocking all other emails in that directory. So if there are 100 emails, 99 are being blocked because the top one is not processing. Then I have to switch off the CF server, and delete the top file, restart the server only to find the problem has occured again a little further down the list. Any idea what could be causing this problem? And are there any solutions? Thanks. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL getting stuck in the SPOOL directory
Actually its not 0KB in size, its 22KB and when I try to delete it, I get a msg that says Cannot delete 11F0: There has been a sharing violation. The source or destination file may be in use. Any idea what could be causing this? Thanks. - Original Message - From: John Wilker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 12:47 PM Subject: RE: CFMAIL getting stuck in the SPOOL directory The one file is probably 0k in size right? It's a common bug in ColdFusion. You could put a script in place that will look in the spool dir for 0k files, then stop the service and delete the file real quick, then restart the service. Not ideal but the service should only be off a second. J. John Wilker Web Applications Consultant, and Author Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com more people are killed by donkeys than by airplane crashes each year -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 12:45 PM To: CF-Talk Subject: Re: CFMAIL getting stuck in the SPOOL directory Hi, I'm having problems with the top email in the SPOOL directory blocking all other emails in that directory. So if there are 100 emails, 99 are being blocked because the top one is not processing. Then I have to switch off the CF server, and delete the top file, restart the server only to find the problem has occured again a little further down the list. Any idea what could be causing this problem? And are there any solutions? Thanks. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL getting stuck in the SPOOL directory
:) This is what I've been doing. Unfortunately its not solving the root problem, and since I have no ideal why one email would get stuck, its tuff to find a solution. Any idea what might cause one email to block the whole list? Thanks. - Original Message - From: John Wilker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 1:18 PM Subject: RE: CFMAIL getting stuck in the SPOOL directory That is weird. But Dan is right, you'll still need to stop the service to delete the file. Before you do though either copy it somewhere or open it, and see if you can see what is wrong with it? If it's 22k then it should be sent or moved to the error directory. J. John Wilker Web Applications Consultant, and Author Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com more people are killed by donkeys than by airplane crashes each year -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 1:11 PM To: CF-Talk Subject: RE: CFMAIL getting stuck in the SPOOL directory You will have to stop the CF application service, then you can delete the file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 4:19 PM To: CF-Talk Subject: Re: CFMAIL getting stuck in the SPOOL directory Actually its not 0KB in size, its 22KB and when I try to delete it, I get a msg that says Cannot delete 11F0: There has been a sharing violation. The source or destination file may be in use. Any idea what could be causing this? Thanks. - Original Message - From: John Wilker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 12:47 PM Subject: RE: CFMAIL getting stuck in the SPOOL directory The one file is probably 0k in size right? It's a common bug in ColdFusion. You could put a script in place that will look in the spool dir for 0k files, then stop the service and delete the file real quick, then restart the service. Not ideal but the service should only be off a second. J. John Wilker Web Applications Consultant, and Author Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com more people are killed by donkeys than by airplane crashes each year -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 12:45 PM To: CF-Talk Subject: Re: CFMAIL getting stuck in the SPOOL directory Hi, I'm having problems with the top email in the SPOOL directory blocking all other emails in that directory. So if there are 100 emails, 99 are being blocked because the top one is not processing. Then I have to switch off the CF server, and delete the top file, restart the server only to find the problem has occured again a little further down the list. Any idea what could be causing this problem? And are there any solutions? Thanks. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MAX function problem
Try: CFQUERY datasource=Contacts name=GetNewUser SELECT MAX(ID) as MAXID FROM ContactInfo /CFQUERY Regards, Pardeep. - Original Message - From: S R [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 2:08 PM Subject: MAX function problem I keep getting an error resolving parameter MAXID when I do the following CFQUERY datasource=Contacts name=GetNewUser SELECT MAX(ID) FROM ContactInfo AS MAXID /CFQUERY CFSET UserID = #GetNewUser.MAXID# I've also tried CFSET UserID = '#GetNewUser.MAXID#' CFSET UserID = '#MAXID#' CFSET UserID = #MAXID# with the same error resulting. Sal _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Contracts
Try this one: I _ promise to pay you on time and fairly and squarely for the eminent work you do for me o beloved Cold Fusion programmer. Signed Print name: (Place thumb print and notary seal to right) Hope it helps. - Original Message - From: Brian Thornton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 2:37 PM Subject: Re: Contracts Eric or anyone else, Do you happen to have a contract template I could use? I would like to see what everyone else is using. - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 4:03 PM Subject: RE: Contracts I'm not as formal, but a discovery phase of the project is useful in establishing scope. -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 4:02 PM To: CF-Talk Subject: Contracts Question: I use a scope of work for starting contract work. What does everyone else use? Thanks, Brian __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL goes straight to UNDELIVERABLE
Anyone have any idea on why a lot of emails are going within Cold Fusion straight from the SPOOL folder to the UNDELIVR folder I don't know if its a problem in Cold Fusion or the email server Thanks __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusionc FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Re: How do you prevent web pages/images from being SAVED
Does anyone know how to prevent: 1 Preventing a web page from being saved when being viewed in a browser and 2 Preventing the images on the page from being saved Is there some technique or maybe a program that enables this? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusionb FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Re: CFMAIL goes straight to UNDELIVERABLE
Anyone have any idea on why a lot of emails are going within Cold Fusion straight from the SPOOL folder to the UNDELIVR folder I don't know if its a problem in Cold Fusion or the email server Thanks __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://wwwpennyhostcom/redirectcfm?adcode=coldfusionb FAQ: http://wwwthenetprofitscouk/coldfusion/faq Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/ Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists
Re: How do you get the ID number of newest record added to a table?
How do you get the row ID number of the newest record added to a table? I want to insert a record and then outout the info from that record by the autocreated row ID number, because there's no other unique identifier for the info in each record. Is there a function that tells you the highest row ID number, which consequently would be the newest and latest addition to that table? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do u add colums in SQL query and do a WHERE on the new column
Was wondering if anyone knows how to add up 4 columns in a query, give the result a new column name, and then use that new column name in the WHERE part of the query. Situation is where some customers are 30, 60, 90 or 120 past due. So I'm trying to add up the 30,60,90,120 column totals and save the result as a new column called TOTALOUTSTANDING Then we want to send emails to anyone where TOTALOUTSTANDING 5 (where the total outstanding is more than $5) I tried this script, but the dang thing never worked:( CFQUERY NAME=pastduenotice DATASOURCE=customers SELECT first_name, email_address, customer_number, total_due, (past_due_30) + (past_due_60) + (past_due_90) + (past_due_120) AS totaloutstanding FROM accountsreceivable where totaloutstanding 0 /CFQUERY Appreciate any enlightenment on this one:) __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Can CF connect to remote Sybase database?
Is it possible for CF to connect to a live remote Sybase database so one can run queries and create reports on live data. If so, how do you go about doing it and what are the security ramifications? Thanks. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do u add colums in SQL query and do a WHERE on the new co lumn
Hey guys, thanks for your help:) Creating the logic in the WHERE section solved the problem. Again, thanks a lot:) - Original Message - From: Bryan Love [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 13, 2002 1:50 PM Subject: RE: How do u add colums in SQL query and do a WHERE on the new co lumn I assume that past_due_30 must have a value if past_due_60 has a value... SELECT first_name, email_address, customer_number, total_due, (past_due_30 + past_due_60 + past_due_90 + past_due_120) AS totaloutstanding FROM accountsreceivable WHERE past_due_30 0 or if pst_due_30 is nullable... WHERE past_due_30 IS NOT NULL or if past_due_30 doesn't have to have have a value for past_due_60 to have a value... WHERE past_due_30 + past_due_60 + past_due_90 + past_due_120 0 +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 1:43 PM To: CF-Talk Subject: Re: How do u add colums in SQL query and do a WHERE on the new column Was wondering if anyone knows how to add up 4 columns in a query, give the result a new column name, and then use that new column name in the WHERE part of the query. Situation is where some customers are 30, 60, 90 or 120 past due. So I'm trying to add up the 30,60,90,120 column totals and save the result as a new column called TOTALOUTSTANDING Then we want to send emails to anyone where TOTALOUTSTANDING 5 (where the total outstanding is more than $5) I tried this script, but the dang thing never worked:( CFQUERY NAME=pastduenotice DATASOURCE=customers SELECT first_name, email_address, customer_number, total_due, (past_due_30) + (past_due_60) + (past_due_90) + (past_due_120) AS totaloutstanding FROM accountsreceivable where totaloutstanding 0 /CFQUERY Appreciate any enlightenment on this one:) __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do you get middle 4 numbers out of agent code number
This code below works great, but how bout if you wanted the second set of 4 numbers from the left. i.e. Lets say someone provides an agent number of ' 123456789123' and it needs to be split into 3 parts with 4 charcters each: Master=1234 Region=5678 Agent=9123 Because there is a signup process where a 12 digit number needs to be broken down into 3 pieces. Thanks. Can't you just use left and right? Like: cfset FORM.ccnumber = trim(FORM.ccnumber) cfset leftnumbers = left(FORM.ccnumber, len(FORM.ccnumber) - 4) cfset rightnumbers = right(FORM.ccnumber, 4) __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 5:14 PM To: CF-Talk Subject: Split up a credit card number? Need regex handout! Hello everyone, I need to take a given form field (numbers) and break it into 2 parts. Then insert one part, and cfmail the other. The number can be different lengths. For example: 3939 may get passed by a form field. I need to insert the 3939 to a DB, and cfmail the . I must admit that I'm stuck on this one, I can't even get a good working start. I can take the number and replace the first 4 digits with nothing, which will give me the second half. But then how to get the first 4 digits? Am I going about this the wrong way? Is there a better approach? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Wednesday, February 13, 2002, at 4:58:30 PM __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do you get middle 4 numbers out of agent code number
Thankyou very much, that worked like a charm. - Original Message - From: Steve Oliver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 13, 2002 3:22 PM Subject: RE: How do you get middle 4 numbers out of agent code number Then you would use Mid() Mid(string, start, length) Leftnumbers = left(string, 4) Middlenumbers = mid(string,5,4) Rightnumbers = right(string,4) __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 6:17 PM To: CF-Talk Subject: Re: How do you get middle 4 numbers out of agent code number This code below works great, but how bout if you wanted the second set of 4 numbers from the left. i.e. Lets say someone provides an agent number of ' 123456789123' and it needs to be split into 3 parts with 4 charcters each: Master=1234 Region=5678 Agent=9123 Because there is a signup process where a 12 digit number needs to be broken down into 3 pieces. Thanks. Can't you just use left and right? Like: cfset FORM.ccnumber = trim(FORM.ccnumber) cfset leftnumbers = left(FORM.ccnumber, len(FORM.ccnumber) - 4) cfset rightnumbers = right(FORM.ccnumber, 4) __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 5:14 PM To: CF-Talk Subject: Split up a credit card number? Need regex handout! Hello everyone, I need to take a given form field (numbers) and break it into 2 parts. Then insert one part, and cfmail the other. The number can be different lengths. For example: 3939 may get passed by a form field. I need to insert the 3939 to a DB, and cfmail the . I must admit that I'm stuck on this one, I can't even get a good working start. I can take the number and replace the first 4 digits with nothing, which will give me the second half. But then how to get the first 4 digits? Am I going about this the wrong way? Is there a better approach? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Wednesday, February 13, 2002, at 4:58:30 PM __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Linkpoint CF tag problem
Hi, does anyone here have any experience with the Linkpoint Cold Fusion tag. Their documentation is really poor and I can't figure out: 1. Precisely how you define the total amount for a transaction that does not have any shipping or tax info involved. 2. Which field provides the result of the transaction and 3. The variable codes of the transaction result, i.e. 0 = declined, 1 = approved, 2 = customer sucks, etc, etc Again, the documentation doesn't clarify any of these points and their online staff aren't able to help out so far. Thanks in advance if anyone has an idea on this. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Why is this Image tag not working - cfx_pwimageproc.dll tag
Has anyone tried this tag yet? I registered it as a CFX tag in Cold Fusion 5, tried using it according to the code provided, but it doesn't work. Anyone have any ideas on what the problem may be? Code used to simply resize was: cfx_pwimageproc infile=c:\inetpub\wwwroot\sites\buttontemplate.jpg set_width=300 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do you use UDFs in CF 5
I was looking at cflib.org at the various UDFs that can be downloaded. However, I'm not aware of how you use the UDFs. 1. Do you place them in the root of the site you're working in or the custom tags directory and 2. How do you call and use them as far as within your scripts. I haven't had a chance to check the docs on CF 5 yet, so would appreciate any feedback. Thanks. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do u insert data/time in SQL 2000
In SQL 2000, what code do you type in the default field so that the current date and time is inserted into a field. I have one field for DATE and another for TIME so we know the date and time a form was submitted. Thanks. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to make 'FIRSTNAME' appear as 'Firstname' - i.e. sentence case
Hi, does anyone know how to make FIRSTNAME from a database appear as Firstname for the purpose of sending emails to customers. It would look weird sending emails as: Dear FIRST NAME, So I'm finding it a challnge to format this properly as: Dear Firstname Appreciate any help. Thanks, Pardee. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Why CFHTTP not post if data come from multi-part form?
Confucious say: Why CFHTTP not post if data come from multi-part form? I have a CFHTTP script which executes perfectly if all the data submitted to it comes from only one form page. However if the data comes from a page that is the result of a multi-page form, for some reason it doesn't execute and post properly. Any idea what could be causing that. Same fields are present on the final page in both cases. I even put them on there in the same order, but no luck. It only will execute if the form is one page, and that doesn't make any sense. Appreciate any insights into this mystery, as perplexing perhaps as the Bermuda Triangle. ~~ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to take only a CUSTID number from XML code
How would you take out only the customer ID number from the following XML response from a CFHTTP post: This is the response that comes from the server we do the CFHTTP post to. ?xml version=1.0 encoding=utf-8? string xmlns=http://tempuri.org/;892028/string We need to take out only the '892028' number and insert it into our database. Right now it tries to insert all the XML code. The customer ID is always in the same place in the code as far as position in the code. Thanks in advance for any help. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Resolved: How to take only a CUSTID number from XML code
cfappreciate Dear Joseph, Thanks for your help, this script worked perfectly. I've never used CFSCRIPT before so this is a new experience. Again, thanks for your help because this was a real puzzler:) Best regards, Pardeep. /cfappreciate - Original Message - From: Joseph DeVore [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, December 14, 2001 2:38 PM Subject: RE: How to take only a CUSTID number from XML code Pardeep, The example code below will do what you need very quick and easy. cfscript // input string in='string xmlns=http://tempuri.org/;892028/string'; // parse string out=rereplacenocase(in, 'string([^]*)([^]*)/string', '\2','one'); /cfscript HTH, Joseph DeVore VeloxWeb Technologies -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 12:06 PM To: CF-Talk Subject: Re: How to take only a CUSTID number from XML code How would you take out only the customer ID number from the following XML response from a CFHTTP post: This is the response that comes from the server we do the CFHTTP post to. ?xml version=1.0 encoding=utf-8? string xmlns=http://tempuri.org/;892028/string We need to take out only the '892028' number and insert it into our database. Right now it tries to insert all the XML code. The customer ID is always in the same place in the code as far as position in the code. Thanks in advance for any help. ~~ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How do you insert 10 form fields into one database field?
Whats the best way to insert 10 form fields into one field in the server database via CFHTTP. Is it better to: 1. Do 10 separate insert statements or 2. Use just CFINSERT and let it occur autmatically or 3. Use a loop statement. Field name on form is phonenumber, there are 10 different ones, i.e. phonenumber1 phonenumber2 phonenumber3, etc, etc And all need to post into the field 'phonenumber' in the database as separate records (unique rows/records). Am also inserting with each number the custid so it a join can occur to the main customer table. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How do you concatenate 2 string variables into one with a space in the middle
Re: How do you concatenate 2 string variables into one with a space in the middle i.e. (area code) and (telephone number) - such as 858 999 into 858 999 to be inserted into one field in a database. Here's how I wrote the code thus far: Variable 1:cfparam name=areacode default=#BusphoneArea# Variable 2: cfparam name=telnum default=#Busphone# Then I try to concatenate em as follows, and find I have not only not succeeded but have in fact arrived at a place of dismal failure. cfparam name=cust_tel_num default=#areacode# #telnum# Appreciate any insights. Cheers aye, Pardee. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How do you parse an XML response
How would you parse the following XML response to a CFHTTP post to: 1. Extract and insert only the CUSTOMER ID number into the database and 2. also use it for a new CFHTTP post command in the same script? EXAMPLE RESPONSE FROM SERVER TO WHICH I POST VIA CFHTTP: ?xml version=1.0 encoding=utf-8? string xmlns=http://tempuri.org/;892028/string The only thing I want to extract is the 892028 number which is the new custID for a new long distance phone service customer. Then need to use that number to insert addl. telephone lines into another table on the vendors server. To insert 10 phone numbers, is it better to use 10 CFHTTP parameter variables in the script or use some loop logic? I have no experience with parsing text or loops. Thanks, Pardeep. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do u use mySQL with CF on Windows 2000
How do you get CF 4.5 to work with mySQL for Windows? Is there an ODBC driver or is there another way to connect? Thanks, Pardee. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:Problem converting expression result to a string in a URL
Am having a problem getting a variable to show up in a URL link. Can't figure out what the problem is: Error Occurred While Processing Request Error Diagnostic Information Expression result cannot be converted to a string Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, etc. must evaluate to a value that can be converted to a string for output or dynamic text accumulation purposes. Complex objects, such as queries, arrays, and COM/DCOM objects, cannot be represented as strings. The error occurred while processing an element with a general identifier of (#sideimage#), occupying document position (138:62) to (138:72). Date/Time: 12/05/01 15:52:55 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion processing pages with diff. extensions
How can you get Cold Fusion to process pages with diff. extensions, say for example like on CFextras their pages end with page.cfx I'm running Apache on Win 2000 with CF 4.5 Would the change take place in CF or in Apache? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do u dynamically attach files to emails?
I have a friend who needs to send resumes to a list of 20 companies he deals with. When he sends the email, he needs to attach a Word doc that is the relevant resume. I know how to do email merges in CF, but am having a problem enabling file attachments. Keep getting an error message following the examples in the books which says File does not exist - however the file does exist since I've checked the path, etc. Also, is there a way to use a BROWSE function to find the file intuitively rather than having to know the full path? Thanks, Pardee. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How do u send color text fallover emails
Need to send color and text emails, so that the recipient sees one of the two depending upon their email client. i.e. AOL users typically cannot see HTML emails. Does anyone know of a good solution or tag to accomplish this. The ones on the Allaire site so far are very buggy and don't work. Appreciate any tips. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Finally, a page reload solution that works:)
I finally got a solution that works well for page reloads if its of help to anyone: !--- Default value for refresh is null --- cfparam name=refresh default= !--- Refreshes page only if 'refresh' equals 1, upon refresh it doesn't --- cfif refresh eq 1 META HTTP-EQUIV=refresh CONTENT=0; URL=http://www.yoursite.com/yourpage.cfm?refresh=0; /cfif Regards, Pardee. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
No cache or page refresh
How do you refresh a page via code or prevent caching of a page? Have seen some other suggestions, but none of them have worked thus far. Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: No longer a Fusebox virgin, got Fused yesterday
Hey folks, my 2 cents. I just started using Fusebox 2 methodology, and I find its really helpful centralizing all the actions in one file. Its making it easier to organize and build the app, primarily because its easier to understand how all the different parts work with each other. So I've only been at this for a day, but so far I think I'm going to stick with this method. My conclusion is its just an organized filing system, and if it clicks and helps you work in a more organized manner, why not? If something else works better for you, more power to ya. Regards, Pardeep. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How do u prevent pages from caching or how do u auto-refresh pages?
Does anyone know how to prevent pages from caching in a browser? Or how to refresh pages in a manner that works in all the browsers? By refresh I don't mean you massage the page visualizing a Swedish model, but rather the page is reloaded along with any new versions of graphic files that have the same file name. Ideally a CF solution would be better, since some folks may not have javascript, but I'm open to anything that works. Thanks, Pardeep. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Can't send form data with spaces in Netscape 4.61
I'm unable to send form data with spaces in Netscape 4.61 Is there a way to URL encode it and then URL decode the message in the receiving file? Or is the solution to send to a redirect file with URL encode added to a URL going to the processing script? ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Mystery?!! Variables not being recognized via CFLOCATION
This is the actual error message even though the variable 'bannerfile' shows as being present in the URL with a value also. I'm totally puzzled by this: Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: bannerfile=#bannerfile# Error near line 2, column 7. Error resolving parameter BANNERFILE ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: 1.You have misspelled the parameter name, or 2.You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (CFSET), occupying document position (2:1) to (2:33). ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Flash vs. GIF/JPG for dynamic images?
Which is better and more efficient, if you want to dynamically change images for clients? Is it better to use a graphics tag or use Flash? I've found both to have their pros/cons so far. The graphics gifs/jpgs don't look too sharp on the fonts if you place text on a dark background. The Flash text doesn't look too good if you expand the size of the font for example in a banner. Any feedback appreciated. Regards, Pardeep. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Dynamically inserting text into Flash via Cold Fusion
Does anyone know how to get a variable from CFSET or a query into a text box in Flash. Would like to be able to dynamically update the text in the Flash movie. Have looked around and found nothing so far that does a decent job on explaining this process. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Dynamically inserting text into Flash via Cold Fusion
I looked there, but none of the samples sufficiently explain the process or methodology behind how this process works. They offer ready made examples, but now the expo. on how it works. Any addl. pointers would be appreciated. Thanks, Pardeep. - Original Message - From: Jim Priest [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 29, 2001 4:02 PM Subject: Re: Dynamically inserting text into Flash via Cold Fusion Check out http://www.flashcfm.com Lots of tutorials and sample code. Jim On Monday, October 29, 2001, 6:03:46 PM, one wrote: olc Does anyone know how to get a variable from CFSET or a query into a text box olc in Flash. olc Would like to be able to dynamically update the text in the Flash movie. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFX_printmoney tag
Does anyone know where one can find the holy CFX_printmoney tag? Just thought I'd lighten things up from all this Microsoft (referring to Bill Gate's personal organ) vs. Macromedia:) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to interact between CF Macromedia Generator
Does anyone have any experience in working with CF Generator or even the open source jGenerator? Am curious how one goes about interacting dynamically between the two. I know CF can be used to send variables to Generator, but don't have the foggies idea how that set up in Generator. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Web content management tools?
Does anyone know of a good tool other than Active Edit which enables a client to manage his own web page content directly through the browser. The probs I've had with Active Edit is that the documentation on how to use it is very poor to non-existent. Consequently I don't have the foggiest idea how good or bad the tool is. I'd welcome any other potential solutions at this point. Thanks, Pardeep. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cf and apache
You could try Merlin Apache at www.abriasoft.com There is a Windows and Linux version. - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 9:48 AM Subject: RE: cf and apache Is there anyone we can email about this to help it along a little? Just to let them know there are people out here who want it sooner rather than later. -Original Message- From: Justin Greene [mailto:[EMAIL PROTECTED]] Sent: 24 September 2001 22:52 To: CF-Talk Subject: RE: cf and apache Correct. -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 11:43 AM To: CF-Talk Subject: RE: cf and apache For the windows version of the module? -jesse -Original Message- From: Justin Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 11:16 AM To: CF-Talk Subject: RE: cf and apache After a few conversations MM agreed to compile it and said it would be available in a few weeks. That was at the end of August. I have asked for an update but have not gotten a reply. Justin -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 12:25 PM To: CF-Talk Subject: RE: cf and apache Actually, now that you mention it, I forgot about that EAPI thing going on. I get the error on startup (only when using the OpenSSL compiled version) about the module, but it's been running fine and we've been hitting it pretty hard. What's the latest on the replacement module? Which version of apache are you running and what platform? I have found that SSL on win32 with 1.3.20 apache required an EAPI Cold Fusion module and MM has not yet made it available (though they said that they would after the discussions on the list and some back and forth with their support people). Justin -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 22, 2001 9:43 PM To: CF-Talk Subject: RE: cf and apache Works great with SSL too. No problems. It was a little tricky setting it up the first time, but I'm using OpenSSL with no issues. And of course, the first time, I was trying to import certificates created with Netscape server. THAT was a fun thing to do. Works great so long as you do not need SSL. Been running it for almost 3 years without a problem. -Original Message- From: Ben Whalley [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 9:53 AM To: CF-Talk Subject: cf and apache How much experience do people have with CF and Apache? Anything to be aware of if switching from IIS. We are just about to buy a new box and with all these nightmares people are having with nimba etc thought it might be a good idea. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to dynamically auto generate images?
Does anyone know how to dynamically generate formatted images. i.e. 1. A client fills out a web site banner name in a form and presses submit 2. That automatically generates the banner image, with formatting rules like drop shadow, etc. I know Macromedia Generator does this, but its a very heavy price to pay in terms of server load and up front costs. Are there any other good alternatives? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HOw to auto generate images?
Hey folks, so far I found these two ASP solutions, however no tag in Cold Fusion. Surely that can't be right, there must be something in the wonderful world of Cold Fusion that allows us to do the same thing. Say it ain't so http://www.serverobjects.com/products.htm#aspimage http://www.websupergoo.com/detail/ig4-whatsnew.htm - this looks far more interesting in that it works with Photoshop. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to auto generate images?
Does anyone know how to dynamically generate formatted images. i.e. 1. A client fills out a web site banner name in a form and presses submit 2. That automatically generates the banner image, with formatting rules like drop shadow, etc. I know Macromedia Generator does this, but its a very heavy price to pay in terms of server load and up front costs. Are there any other good alternatives? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to auto generate images?
Does anyone know how to dynamically generate formatted images. i.e. 1. A client fills out a web site banner name in a form and presses submit 2. That automatically generates the banner image, with formatting rules like drop shadow, etc. I know Macromedia Generator does this, but its a very heavy price to pay in terms of server load and up front costs. Are there any other good alternatives? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
