Re: Check value of form check box for CFMAIL
On 2/14/01, Jeff Davis penned: OK I need to check the value of a check box to see if it has been checked so I can pass the info in my CFMAIL tag. This is what I have so far: CFIF #bannerads# EQ 1 I want Banner Ads /CFIF Can anyone tell me if this right? If the checkbox isn't checked, it will return an error. cfif isdefined('bannerads') I want banner ads /cfif -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
HELP wap !!!!!!!
Hi... I have been working with cold fusion for over 2 years in India and i have an requirement where in i have to send mails to my customers to their wireless systems I would like to know what are the various ways i can send mails to their cell phones and also what technology i will have to learn to implement it myself or is their any code i can outsource for evaluation purpose Could any one help me out please ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JavaScript?
Does anyone have a good javascript that will allow you to type ina startDate and endDate and it will calculate the number of days inbetween and populate a 3rd form field on the fly? Chris This is the calculation http://developer.irt.org/script/2.htm You can do the rest with onChange or onBlur events. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SimpleMessageBoard now available
Like the tab code. Could see this having a lot of uses. Adam -Original Message- From: Tony Schreiber [SMTP:[EMAIL PROTECTED]] Sent: 13 February 2001 22:14 To: CF-Talk Subject:RE: SimpleMessageBoard now available That's what I said ;p At last..a functional..UBB-like free message board. Rejoice! :) -Gel -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Kevin Langevin had told me many people on this list were awaiting the release of Simple Message Board. Well, it's available! http://www.simplemessageboard.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CAN I combine Verity results with a standard query?
I'm trying to run a standard CFQUERY search using results found in a VERITY query. Heres what my code looks like: For some reason, I keep coming up with no results! What am I doing wrong? Any suggestions? --- CFSEARCH name = "GetResults" collection = "#SearchCollection#" criteria = "#ResumeKeyword#" !--- Make a List of results--- CFSET ResumeResults="" CFOUTPUT QUERY="getresults" CFSET ResumeResults=ListAppend(ResumeResults, "#getfilefrompath(key)#") /cfoutput CFQUERY DATASOURCE="Stars" NAME="Talent" SELECT * FROM Talent WHERE TalentID=TalentID AND Resume IN ('#ResumeResults#') /cfquery OK, first of all, I'm assuming that Resume was the KEY that was built in the CFIndex, if not, this won't work... Next, if Resume is a text field it needs apostrophies around each entry, so your ListAppend() needs to be; CFSET ResumeResults=ListAppend(ResumeResults, "'#getfilefrompath(key)#'") And then the WHERE needs to be; AND Resume IN (#PreserveSingleQuotes(ResumeResults)#) The reason for the PreserveSingleQuotes() is that they need to be escaped or they won't be recognised by SQL... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: Dave Levin [mailto:[EMAIL PROTECTED]] Sent: 13 February 2001 23:32 To: CF-Talk Subject: CAN I combine Verity results with a standard query? - Thanks, Dave :) [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
404 Error
This is a multi-part message in MIME format. --DF5FC63736D5ED85F5E527F7 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, Anyone knows how to set up customized error page in CF 4.0 for 404 Error OR Page Not Fount OR HTTP/1.0 404 Object Not Found. Thanks in advance, Dacha. --DF5FC63736D5ED85F5E527F7 Content-Type: text/x-vcard; charset=us-ascii; name="zamex.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for ZAMEX Content-Disposition: attachment; filename="zamex.vcf" begin:vcard n:Hrkalovic;Danilo tel;cell:+381 63 365 834 tel;work:+381 11 8013 496 x-mozilla-html:FALSE org:ZAMEX - web design promotion adr:;;Gnjionska II/5;Beograd;;11253;Yugoslavia version:2.1 email;internet:[EMAIL PROTECTED] title:Web Konsultant fn:Danilo Hrkalovic end:vcard --DF5FC63736D5ED85F5E527F7-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfincluding application.cfm
Howdy all. I'm in a situation where I'm going to need parameters set in an application.cfm of one of my programs, but I'm going to be installing into a directory that already has a program running in it with an application.cfm. I'd rather not touch the other developer's files, so I don't want to combine the 2 application.cfm files. I've look and there doesn't seem to be any conflicting variables set. So my question. If the files that I need to access my application.cfm are in the top directory, are there any pitfalls to placing my application.cfm in a subdirectory and just cfincluding it in the top of my templates? Thanks. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 404 Error
its not a CF error - its from your webserver - in IIS uder properties for a site theres a section for default error templates on one of the tabs... -Original Message- From: ZAMEX [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 11:51 To: CF-Talk Subject: 404 Error This is a multi-part message in MIME format. --DF5FC63736D5ED85F5E527F7 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, Anyone knows how to set up customized error page in CF 4.0 for 404 Error OR Page Not Fount OR HTTP/1.0 404 Object Not Found. Thanks in advance, Dacha. --DF5FC63736D5ED85F5E527F7 Content-Type: text/x-vcard; charset=us-ascii; name="zamex.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for ZAMEX Content-Disposition: attachment; filename="zamex.vcf" begin:vcard n:Hrkalovic;Danilo tel;cell:+381 63 365 834 tel;work:+381 11 8013 496 x-mozilla-html:FALSE org:ZAMEX - web design promotion adr:;;Gnjionska II/5;Beograd;;11253;Yugoslavia version:2.1 email;internet:[EMAIL PROTECTED] title:Web Konsultant fn:Danilo Hrkalovic end:vcard --DF5FC63736D5ED85F5E527F7-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfincluding application.cfm
There is no problem at all ...u can go ahead - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 5:25 PM Subject: cfincluding application.cfm Howdy all. I'm in a situation where I'm going to need parameters set in an application.cfm of one of my programs, but I'm going to be installing into a directory that already has a program running in it with an application.cfm. I'd rather not touch the other developer's files, so I don't want to combine the 2 application.cfm files. I've look and there doesn't seem to be any conflicting variables set. So my question. If the files that I need to access my application.cfm are in the top directory, are there any pitfalls to placing my application.cfm in a subdirectory and just cfincluding it in the top of my templates? Thanks. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Dave's Burning Rant, Part Deux
- Original Message - From: "Michael" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 9:37 PM Subject: Re: OT: Dave's Burning Rant, Part Deux My gosh, get over it already, stop beating a dead horse cause that is what is going on here. I respectfully disagree. If it were a dead horse, the "professionals" on this list would stop becoming infected with these stupid viruses. It's education and the principle here. If you're going to be a professional, become educated about the industry you're a professional in. IMHO Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem with session variables not working
I have a production server that's running 4.0 which does not allow session and client variables to work. I have enabled them on the server and double checked my cfapplication tags to ensure the client and session management are set to 'Yes'. What else could be the problem. It is only specific to this one machine? Where else should I look? Thanks, Eric V. Hodge Web Developer CelTek Systems, LLC @phone: 703.927.5750 @fax: 703.567.3085 @homepage: www.CelTekSystems.com @email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with session variables not working
Hi, CF 4.0 has a bug in that it identifies the session not by the combination of CFID and CFTOKEN, but, just by CFID alone. In case you indeed checked all settings and CFAPPLICATION tags, I'd go for an update to at least 4.01. Ummm... maybe unneccessary to ask, but, you're not trying to pass session or client variables from one application to another, are you? HTH, Chris --Original Message-- From: "Eric V. Hodge" [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: February 14, 2001 12:39:54 PM GMT Subject: Problem with session variables not working I have a production server that's running 4.0 which does not allow session and client variables to work. I have enabled them on the server and double checked my cfapplication tags to ensure the client and session management are set to 'Yes'. What else could be the problem. It is only specific to this one machine? Where else should I look? Thanks, Eric V. Hodge Web Developer CelTek Systems, LLC @phone: 703.927.5750 @fax: 703.567.3085 @homepage: www.CelTekSystems.com @email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfincluding application.cfm
Nope .. I do it all the time. Todd Ashworth Web Application Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] (p) (803) 328-2868 (f) - Original Message - From: "Bud" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 6:55 AM Subject: cfincluding application.cfm Howdy all. I'm in a situation where I'm going to need parameters set in an application.cfm of one of my programs, but I'm going to be installing into a directory that already has a program running in it with an application.cfm. I'd rather not touch the other developer's files, so I don't want to combine the 2 application.cfm files. I've look and there doesn't seem to be any conflicting variables set. So my question. If the files that I need to access my application.cfm are in the top directory, are there any pitfalls to placing my application.cfm in a subdirectory and just cfincluding it in the top of my templates? Thanks. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Problem with session variables not working
Thanks for the advice. I will recommend an upgrade to the CF server then. I am not trying to pass variables between apps, just trying to get session variables to work within a single app. Thanks. -Eric - Original Message - From: "Christoph Schmitz" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 7:51 AM Subject: RE: Problem with session variables not working Hi, CF 4.0 has a bug in that it identifies the session not by the combination of CFID and CFTOKEN, but, just by CFID alone. In case you indeed checked all settings and CFAPPLICATION tags, I'd go for an update to at least 4.01. Ummm... maybe unneccessary to ask, but, you're not trying to pass session or client variables from one application to another, are you? HTH, Chris --Original Message-- From: "Eric V. Hodge" [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: February 14, 2001 12:39:54 PM GMT Subject: Problem with session variables not working I have a production server that's running 4.0 which does not allow session and client variables to work. I have enabled them on the server and double checked my cfapplication tags to ensure the client and session management are set to 'Yes'. What else could be the problem. It is only specific to this one machine? Where else should I look? Thanks, Eric V. Hodge Web Developer CelTek Systems, LLC @phone: 703.927.5750 @fax: 703.567.3085 @homepage: www.CelTekSystems.com @email: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: as400 connection
The Company that puts it out is called Hit Software. Their web site is http://www.hitsw.com . We have used it at a couple of clients for VB apps. Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x123 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -Original Message- From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 18:23 To: CF-Talk Subject: Re: as400 connection Please, and thanks. - Original Message - From: Peter J. MacDonald [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 12:17 AM Subject: RE: as400 connection Yes, it could talk AS400. There are some ODBC's out there for it. There is also an OLE DB driver that is more stable. I could get the name of the OLE DB driver if you need it I do not have it handy right now. Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x123 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -Original Message- From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] Sent: Monday, February 12, 2001 23:11 To: CF-Talk Subject: as400 connection hi people, did anyone know that if it is possible for CF server to "talk" to AS/400 machine? advise needed, thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SimpleMessageBoard now available
Other than installing CFX_Make_Tree, if I need it, does my ISP have to do anything to allow or enable this application? --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Dateformat behaviour
Have a strange behaviour of DateFormat() function. Look at the following code and the results below. In my opinion CF could give me an error message on the second line (invalid date) but certainly not invert the day and month as it does! Your comments? Dominique cfoutput TABLE border="1" TR TDDateformat("01/12/2000","mmdd")/TD TD#Dateformat("01/12/2000","mmdd")#/TD/TR TR TDDateformat("13/12/2000","mmdd")/TD TD#Dateformat("13/12/2000","mmdd")# /TD/TR/TABLE/P /CFOUTPUT/P Dateformat("01/12/2000","mmdd") 2112 Dateformat("13/12/2000","mmdd") 20001213 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFIF Conditional Code.
Ok i have a repeat region that shows every one that has voted on an admin page. If some one hase vote twice, i want there to be a delete button next to there name, for the admin to only delete duplicate data. i am trying to understand conditional cfif staments to do this. IF EmployeeID = EmployeedID AwardsID AwardsID then show a delete button. that seems simple to me. but in the master record every empID would Be equal to itself. so then i should see if its primamry key 'AwardsID' is equal to itself? IF not show the delete button'? sounds right. i am probably missing the logic here. any advice, would be great. quickly searching through the wack book. Thank You -paul !--- All i want to do is to show a DELETE button if the Record has a Duplicate entry. --- CFIF (TotalNum.EmployeeID EQ #TotalNum.EmployeeID#) AND (TotalNum.Awards_ID NEQ #TotalNum.Awards_ID#) form name="form1" method="POST" action="#MM_editAction#" input type="submit" name="Submit" value="Delete Duplicate Vote" input type="hidden" name="MM_delete" value="true" input type="hidden" name="MM_recordId" value="#TotalNum.Awards_ID#" /form /CFIF -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: (Admin) mailing code
Thanks! I thot you also had an app that archived each message. How is this done? Are you leaving them on the server and accessing them there? best, paul At 11:59 PM 2/13/01 -0500, you wrote: http://www.houseoffusion.com/upload/cleanmail.txt http://www.houseoffusion.com/upload/monitor.txt The first is the template I use to take a message from the pop stream and clean it as well as grab important data from it so I can keep message and reference IDs. The second template is my monitor template that sends me an email on any error that happens on my site. Makes for really great debugging. The 'joiner' template that actually retreives the messages and sends them are not being posted. They're standard anyway (other than the custom locking). The custom locking is below: CFLOCK scope="SERVER" type="READONLY" timeout="10" CFIF Not IsDefined('Server.bLock') CFSET Server.bLock=0 CFSET Server.dTime=TimeFormat(now()) /CFIF CFIF IsDefined('UnLock') CFSET Server.bLock=0 CFSET Server.dTime=TimeFormat(now()) /CFIF CFIF Server.bLock AND DateDiff('n', Server.dTime, Now()) LT 10 LockedCFABORT CFELSE CFSET Server.bLock=1 CFSET Server.dTime=TimeFormat(now()) /CFIF /CFLOCK ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Urgent.... please help...
Hi all, I am using session variables in my application and session timeout is 24 hours. But my session times out before that. And also some of the variables time out and some of them don't. How do i overcome with this problem. We have 4.0 server with 2000/IIS and this is happening on my production site. I tried to store it in database even then it's happening. Can anyone help me out. This is very urgent Thanks Vani ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Excel to SQL7
I'm using DTS(Data Transformation Services) to import an excel file to SQL 7. My problem is that DTS throws an error on numbers and dates unless the field in the SQL table is VarChar. It will not put a number into a number or a date into a date because everthing in Excel is viewed as a string. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFIF Conditional Code.
uh, check to see if the current records id == previous records id. That would easily indicate a repeat. Cheers! -- Douglas Knudsen LTT, that's Leveraged Technologies Team [EMAIL PROTECTED] Got Linux? http://linuxmall.com From: [EMAIL PROTECTED] AT INTERNET on 02/14/2001 09:02 AM To: Douglas Knudsen/ATL/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: Subject: CFIF Conditional Code. Ok i have a repeat region that shows every one that has voted on an admin page. If some one hase vote twice, i want there to be a delete button next to there name, for the admin to only delete duplicate data. i am trying to understand conditional cfif staments to do this. IF EmployeeID = EmployeedID AwardsID AwardsID then show a delete button. that seems simple to me. but in the master record every empID would Be equal to itself. so then i should see if its primamry key 'AwardsID' is equal to itself? IF not show the delete button'? sounds right. i am probably missing the logic here. any advice, would be great. quickly searching through the wack book. Thank You -paul !--- All i want to do is to show a DELETE button if the Record has a Duplicate entry. --- CFIF (TotalNum.EmployeeID EQ #TotalNum.EmployeeID#) AND (TotalNum.Awards_ID NEQ #TotalNum.Awards_ID#) form name="form1" method="POST" action="#MM_editAction#" input type="submit" name="Submit" value="Delete Duplicate Vote" input type="hidden" name="MM_delete" value="true" input type="hidden" name="MM_recordId" value="#TotalNum.Awards_ID#" /form /CFIF -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax: 614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 404 Error
that will only work with htm, iis will still display the defaul 404 when a non-existant cfm page is called...to make iis use a custom cfm page for cfm 404's, you need to go into iis, under home directory tab, towards the bottom where the application settings are, configuration tab, then edit the app mappings for .cfm, check the box "check that file exists" then if the file does not exist, iis will use your custom cfm page. -- Stephenie Hamilton Senior ColdFusion Administrator Express Technologies, Inc. want CF_Freedom? try CFXHosting.com -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 6:58 AM To: CF-Talk Subject: RE: 404 Error its not a CF error - its from your webserver - in IIS uder properties for a site theres a section for default error templates on one of the tabs... -Original Message- From: ZAMEX [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 11:51 To: CF-Talk Subject: 404 Error This is a multi-part message in MIME format. --DF5FC63736D5ED85F5E527F7 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, Anyone knows how to set up customized error page in CF 4.0 for 404 Error OR Page Not Fount OR HTTP/1.0 404 Object Not Found. Thanks in advance, Dacha. --DF5FC63736D5ED85F5E527F7 Content-Type: text/x-vcard; charset=us-ascii; name="zamex.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for ZAMEX Content-Disposition: attachment; filename="zamex.vcf" begin:vcard n:Hrkalovic;Danilo tel;cell:+381 63 365 834 tel;work:+381 11 8013 496 x-mozilla-html:FALSE org:ZAMEX - web design promotion adr:;;Gnjionska II/5;Beograd;;11253;Yugoslavia version:2.1 email;internet:[EMAIL PROTECTED] title:Web Konsultant fn:Danilo Hrkalovic end:vcard --DF5FC63736D5ED85F5E527F7-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Urgent.... please help...
No even the max time out on my server is the same.. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 8:30 AM To: CF-Talk Subject: RE: Urgent please help... Sounds like you are exceeding the max timeout setup in the CFAdmin. Duane -Original Message- From: Vani Kolli [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:05 AM To: CF-Talk Subject: Urgent please help... Hi all, I am using session variables in my application and session timeout is 24 hours. But my session times out before that. And also some of the variables time out and some of them don't. How do i overcome with this problem. We have 4.0 server with 2000/IIS and this is happening on my production site. I tried to store it in database even then it's happening. Can anyone help me out. This is very urgent Thanks Vani ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP wap !!!!!!!
you can do it one of three ways; 1) send an email to the phone based on their mobile ID. you need to know what the domain is for the mail accounts each carrier assigns. then you need to collect the mobile IDs of the users. you would send an email to something like [EMAIL PROTECTED] where 1...0 is their number and mail.carrier.com is the mail domain. on the infrastructure side, the carrier sends your email to the phone using SMS. 2) some carriers have web-based forms you can fill out with the user's mobile ID and a message and the application will send a SMS message right to the phone without the SMTP intermediate step. you can write an application that sends HTTP POSTs to whatever forms you need to to communicate with your users wirelessly. 3) set up relationships with the carriers you need and get approval to post directly to their SMS gateways. --dylan -Original Message- From: Vikram-burlee [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 12:33 AM To: CF-Talk Subject: HELP wap !!! Hi... I have been working with cold fusion for over 2 years in India and i have an requirement where in i have to send mails to my customers to their wireless systems I would like to know what are the various ways i can send mails to their cell phones and also what technology i will have to learn to implement it myself or is their any code i can outsource for evaluation purpose Could any one help me out please ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP wap !!!!!!!
as a follow-up...there's a coldfusion wireless discussion list. you can sign up at; www.bromby.com/cfwireless -Original Message- From: Vikram-burlee [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 12:33 AM To: CF-Talk Subject: HELP wap !!! Hi... I have been working with cold fusion for over 2 years in India and i have an requirement where in i have to send mails to my customers to their wireless systems I would like to know what are the various ways i can send mails to their cell phones and also what technology i will have to learn to implement it myself or is their any code i can outsource for evaluation purpose Could any one help me out please ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Urgent.... please help...
i second that, sounds exactly like you need to look at your CFADMIN settings Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303 IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorized alterations to this e-mail or attachment to it - Original Message - From: "Duane Boudreau" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 9:30 AM Subject: RE: Urgent please help... Sounds like you are exceeding the max timeout setup in the CFAdmin. Duane -Original Message- From: Vani Kolli [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:05 AM To: CF-Talk Subject: Urgent please help... Hi all, I am using session variables in my application and session timeout is 24 hours. But my session times out before that. And also some of the variables time out and some of them don't. How do i overcome with this problem. We have 4.0 server with 2000/IIS and this is happening on my production site. I tried to store it in database even then it's happening. Can anyone help me out. This is very urgent Thanks Vani ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio 4.5 crash
Thanks Sandra - I did everything you said and it works for me now too. What a royal pain but at least I'm on track. Thanks again! Date: Mon, 12 Feb 2001 09:08:57 -0800 From: "Sandra Clark" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: CF Studio 4.5 crash Message-ID: [EMAIL PROTECTED] Hi Melanie. I had a lot of problems with 4.5.2 after upgrading the same way you did. What I ended up doing was uninstalling CF 4.0 and 4.5.x from my machine, deleting all the directories (saved all my snippets of course) and going through the registry and deleting anything that referenced either homesite or cfstudio 4.0 or 4.5. I rebooted my machine, reinstalled 4.5.2 (just need your old 4.5.x serial number for it) and finally things calmed down. I am still having RDS and project problems but those seem to be standard. At least I can work now. btw, I am running this on win2k server. Your mileage may vary. -Original Message- From: Smith, Melanie [mailto:[EMAIL PROTECTED]] Sent: Monday, February 12, 2001 6:11 AM To: CF-Talk Subject: CF Studio 4.5 crash OK Studio 4.0 was working relatively well (ok the occasional fatal exception but still I could get my work done), so I decided to upgrade to 4.5.1. It seemed to work for a while and then whenever I got in it would beep upon entry and hang. I clicked on the local resource tab and get "can't access this folder, path is too long". Then all he-doublehockeysticks breaks out - hangs, fatal exception, the works. Have to reboot. My first thought was "great - good thing I still have 4.0" But upon checking, now 4.0 was doing the same thing. I took 4.0 off, took 4.5 off, reinstalled 4.5.1, ran the Allaire download to upgrade it to the latest 4.5.2, and still the same problem. I can get to the RDS tab and everything looks fine there, but if I retrieve any files and try to save back to anywhere I get the above message. Any ideas on what path it's talking about that's too long? I'm kicking myself for not staying with 4.0. Thanks in advance for any insight anyone can provide. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Brio Portal
well, we have a new CF project here that will interface with a Brio Portal, so I am just wondering if anyone here has worked with both together. i just ask for reference in case i run into a problem. i'm reviewing the api now for brio. well, if nothing else it will be interesting... Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Urgent.... please help...
Have you restarted the CF services since the values were changed in CFAdmin? - Original Message - From: "Vani Kolli" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 2:28 PM Subject: RE: Urgent please help... No even the max time out on my server is the same.. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 8:30 AM To: CF-Talk Subject: RE: Urgent please help... Sounds like you are exceeding the max timeout setup in the CFAdmin. Duane -Original Message- From: Vani Kolli [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:05 AM To: CF-Talk Subject: Urgent please help... Hi all, I am using session variables in my application and session timeout is 24 hours. But my session times out before that. And also some of the variables time out and some of them don't. How do i overcome with this problem. We have 4.0 server with 2000/IIS and this is happening on my production site. I tried to store it in database even then it's happening. Can anyone help me out. This is very urgent Thanks Vani ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP wap !!!!!!!
Check out textNow by http://www.redrocksoftware.com/US/index.htm also look into unofficial tags that utilise free sms gateways like quios.com and lycos.co.uk Russell Brown Internet Application Developer Freeserve.com Plc, PO Box 452, Leeds LS2 7EY Telephone: 0113 207 1203 -Original Message- From: Vikram-burlee [mailto:[EMAIL PROTECTED]] Sent: 09 February 2001 08:33 To: CF-Talk Subject: HELP wap !!! Hi... I have been working with cold fusion for over 2 years in India and i have an requirement where in i have to send mails to my customers to their wireless systems I would like to know what are the various ways i can send mails to their cell phones and also what technology i will have to learn to implement it myself or is their any code i can outsource for evaluation purpose Could any one help me out please ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
REPOST: Weird pcode error (please! help!)
Can *anyone* shed any light on this? Please? Help! Sometime yesterday around 19:49, my CF Server started throwing pcode errors by the hundreds, like this: unknown exception condition PCodeRuntimeContextImp::setVariableThe error occurred while processing an element with a general identifier of (CFSCHEDULE), occupying document position (3:1) to (5:13).Date/Time: 02/11/01 21:51:28Browser: Remote Address: Template: C:\CFUSION\Scripts\cfexectask.cfmQuery String: TASK=check for db upload (all of them in cfschedule processing) .and right about the same time, this simple piece of code: CFQUERY NAME="Getcarbrands" DATASOURCE="dsn" SELECT distinct Merk FROM Cars /CFQUERY SELECT name="Merk" CFOUTPUT QUERY="Getcarbrands" OPTION VALUE="#Merk#"#Merk#/OPTION /cfoutput /SELECT started throwing this exception: QUERY The QUERY attribute of the tag does not specify the name of an available query The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (270:1) to (270:31) I have ab-so-lu-te-ly no idea why this happened, and a simple cycle of CF apparently took care of the problem. Any ideas why this would happen? It *is* one of our only remaining CF 4.0.1 servers, but it has plenty RAM HD and it has been running for some time without that particular problem ever cropping up before. Michel Vuijlsteke Netpoint NV ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP wap !!!!!!!
There's also a carrier in Switzerland that lets you send SMS messages via a predefined email template, it works really nicely in CF and means that your users don't have to be signed up for mobile email. Let me know if you want the details ;o) -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 2:47 PM To: CF-Talk Subject: RE: HELP wap !!! you can do it one of three ways; 1) send an email to the phone based on their mobile ID. you need to know what the domain is for the mail accounts each carrier assigns. then you need to collect the mobile IDs of the users. you would send an email to something like [EMAIL PROTECTED] where 1...0 is their number and mail.carrier.com is the mail domain. on the infrastructure side, the carrier sends your email to the phone using SMS. 2) some carriers have web-based forms you can fill out with the user's mobile ID and a message and the application will send a SMS message right to the phone without the SMTP intermediate step. you can write an application that sends HTTP POSTs to whatever forms you need to to communicate with your users wirelessly. 3) set up relationships with the carriers you need and get approval to post directly to their SMS gateways. --dylan -Original Message- From: Vikram-burlee [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 12:33 AM To: CF-Talk Subject: HELP wap !!! Hi... I have been working with cold fusion for over 2 years in India and i have an requirement where in i have to send mails to my customers to their wireless systems I would like to know what are the various ways i can send mails to their cell phones and also what technology i will have to learn to implement it myself or is their any code i can outsource for evaluation purpose Could any one help me out please ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Urgent.... please help...
Check for invalid numbers in the time out settings. I got bit in the behind by putting a 60 in the minutes parameter in the createtimespan function. For 24 hours use: CreateTimeSpan(1, 0, 0, 0) not CreateTimeSpan(0, 24, 0, 0) Duane -Original Message- From: Vani Kolli [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:29 AM To: CF-Talk Subject: RE: Urgent please help... No even the max time out on my server is the same.. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 8:30 AM To: CF-Talk Subject: RE: Urgent please help... Sounds like you are exceeding the max timeout setup in the CFAdmin. Duane -Original Message- From: Vani Kolli [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:05 AM To: CF-Talk Subject: Urgent please help... Hi all, I am using session variables in my application and session timeout is 24 hours. But my session times out before that. And also some of the variables time out and some of them don't. How do i overcome with this problem. We have 4.0 server with 2000/IIS and this is happening on my production site. I tried to store it in database even then it's happening. Can anyone help me out. This is very urgent Thanks Vani ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Connecting to Lotus Notes
Anybody know about or has done this type connection using CF? Best Regards, Adam Reynolds ColdFusion Web Developer ISMG Development, Unilever London ( +44 20 7822 5450 (ext 5450) m: +44 7973 386620 * [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF Conditional Code.
two thoughts 1. What about checking to see if they have already voted during the voting process and put up a message saying they have already voted. You could then show them their current vote and ask if they want to change it. 2. If you don't do option 1, can you use a SELECT DISTINCT in your query based on EmployeeID so you end up with only one vote per employee? HTH Stephen -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:03 AM To: CF-Talk Subject: CFIF Conditional Code. Ok i have a repeat region that shows every one that has voted on an admin page. If some one hase vote twice, i want there to be a delete button next to there name, for the admin to only delete duplicate data. i am trying to understand conditional cfif staments to do this. IF EmployeeID = EmployeedID AwardsID AwardsID then show a delete button. that seems simple to me. but in the master record every empID would Be equal to itself. so then i should see if its primamry key 'AwardsID' is equal to itself? IF not show the delete button'? sounds right. i am probably missing the logic here. any advice, would be great. quickly searching through the wack book. Thank You -paul !--- All i want to do is to show a DELETE button if the Record has a Duplicate entry. --- CFIF (TotalNum.EmployeeID EQ #TotalNum.EmployeeID#) AND (TotalNum.Awards_ID NEQ #TotalNum.Awards_ID#) form name="form1" method="POST" action="#MM_editAction#" input type="submit" name="Submit" value="Delete Duplicate Vote" input type="hidden" name="MM_delete" value="true" input type="hidden" name="MM_recordId" value="#TotalNum.Awards_ID#" /form /CFIF -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Check value of form check box for CFMAIL
Yes, you must check that the checkbox is defined. Unchecked checkboxes essentially do not exist when passed. CFIF IsDefined('Form.CheckBox')I want banner ads./CFIF The value doesn't matter. Unless you have multiple checkboxes with the same name. For example: INPUT TYPE="checkbox" NAME="BannerAds" VALUE="Porn" Porn INPUT TYPE="checkbox" NAME="BannerAds" VALUE="Affiliate" Affiliate INPUT TYPE="checkbox" NAME="BannerAds" VALUE="Visa" Visa INPUT TYPE="checkbox" NAME="BannerAds" VALUE="Free" Free Any checked boxes will result in a comma separated list being passed for BannerAds. So if the first and last boxes were checked, BannerAds would equal "Porn,Free". I think you'll need to check that it's defined (IsDefined("checkbox")) first... otherwise the if test will fail if it hasn't been checked. I may be wrong though!! :^) From: "Kevin Mansel" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 13 Feb 2001 22:48:32 -0800 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Check value of form check box for CFMAIL Jeff, If you want to test if it has been checked you can do it this way... input type=checkbox value="bannerad" name="checkbox" cfif #FORM.checkbox# IS "bannerad" I want banner ads /cfif Kevin Mansel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SimpleMessageBoard now available
Thank you. I made that available separately. Like the tab code. Could see this having a lot of uses. Adam -Original Message- From: Tony Schreiber [SMTP:[EMAIL PROTECTED]] Sent: 13 February 2001 22:14 To: CF-Talk Subject: RE: SimpleMessageBoard now available That's what I said ;p At last..a functional..UBB-like free message board. Rejoice! :) -Gel -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Kevin Langevin had told me many people on this list were awaiting the release of Simple Message Board. Well, it's available! http://www.simplemessageboard.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SimpleMessageBoard now available
Like you said, you don't need CFX_Make_Tree unless you want it. In fact, I'm working on not needing it in the next release. Other than setting up a datasource, you shouldn't need anything else. Other than installing CFX_Make_Tree, if I need it, does my ISP have to do anything to allow or enable this application? --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Urgent.... please help...
no.. do i have to -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:07 AM To: CF-Talk Subject: Re: Urgent please help... Have you restarted the CF services since the values were changed in CFAdmin? - Original Message - From: "Vani Kolli" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 2:28 PM Subject: RE: Urgent please help... No even the max time out on my server is the same.. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 8:30 AM To: CF-Talk Subject: RE: Urgent please help... Sounds like you are exceeding the max timeout setup in the CFAdmin. Duane -Original Message- From: Vani Kolli [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:05 AM To: CF-Talk Subject: Urgent please help... Hi all, I am using session variables in my application and session timeout is 24 hours. But my session times out before that. And also some of the variables time out and some of them don't. How do i overcome with this problem. We have 4.0 server with 2000/IIS and this is happening on my production site. I tried to store it in database even then it's happening. Can anyone help me out. This is very urgent Thanks Vani ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: REPOST: Weird pcode error (please! help!)
Need to put in a dbtype. ODBC OLE ... Joshua Tipton -Original Message- From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 10:10 AM To: CF-Talk Subject: REPOST: Weird pcode error (please! help!) Can *anyone* shed any light on this? Please? Help! Sometime yesterday around 19:49, my CF Server started throwing pcode errors by the hundreds, like this: unknown exception condition PCodeRuntimeContextImp::setVariableThe error occurred while processing an element with a general identifier of (CFSCHEDULE), occupying document position (3:1) to (5:13).Date/Time: 02/11/01 21:51:28Browser: Remote Address: Template: C:\CFUSION\Scripts\cfexectask.cfmQuery String: TASK=check for db upload (all of them in cfschedule processing) ..and right about the same time, this simple piece of code: CFQUERY NAME="Getcarbrands" DATASOURCE="dsn" SELECT distinct Merk FROM Cars /CFQUERY SELECT name="Merk" CFOUTPUT QUERY="Getcarbrands" OPTION VALUE="#Merk#"#Merk#/OPTION /cfoutput /SELECT started throwing this exception: QUERY The QUERY attribute of the tag does not specify the name of an available query The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (270:1) to (270:31) I have ab-so-lu-te-ly no idea why this happened, and a simple cycle of CF apparently took care of the problem. Any ideas why this would happen? It *is* one of our only remaining CF 4.0.1 servers, but it has plenty RAM HD and it has been running for some time without that particular problem ever cropping up before. Michel Vuijlsteke Netpoint NV ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFIF Conditional Code.
On 2/14/01, Paul Ihrig penned: i am trying to understand conditional cfif staments to do this. IF EmployeeID = EmployeedID AwardsID AwardsID then show a delete button. that seems simple to me. but in the master record every empID would Be equal to itself. so then i should see if its primamry key 'AwardsID' is equal to itself? IF not show the delete button'? You could do: cfquery name="getvotes" select employeeid, awardsid from awards Then group the output: cfoutput query="getvotes" group="employeeid"cfset votecount = 0 cfoutputcfset votecount = votecount + 1/cfoutput cfif votecount GT 1 Show delete button input type = hidden name="employeeid" value="#employeeid" input type = hidden name=awardsid" value="#awardsid" /cfif /cfoutput Then: delete from awards where employeeid = #form.employeeid# and awardsid #form.awardsid# There are other ways of doing it where you could pass a list of employeeids and awardsids and delete all except the main ones with one click. I think a better option would be on the vote page. Check for the employeeid and if the recordcount is 1, then run an update query instead of an insert query. That way they can change their vote. Or if you don't want them to change their vote, then tell them Sorry, you voted. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP wap !!!!!!!
I'd like deatils of this very much please.:-) Russell Brown Internet Application Developer Freeserve.com Plc, PO Box 452, Leeds LS2 7EY Telephone: 0113 207 1203 -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 15:15 To: CF-Talk Subject: RE: HELP wap !!! There's also a carrier in Switzerland that lets you send SMS messages via a predefined email template, it works really nicely in CF and means that your users don't have to be signed up for mobile email. Let me know if you want the details ;o) -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 2:47 PM To: CF-Talk Subject: RE: HELP wap !!! you can do it one of three ways; 1) send an email to the phone based on their mobile ID. you need to know what the domain is for the mail accounts each carrier assigns. then you need to collect the mobile IDs of the users. you would send an email to something like [EMAIL PROTECTED] where 1...0 is their number and mail.carrier.com is the mail domain. on the infrastructure side, the carrier sends your email to the phone using SMS. 2) some carriers have web-based forms you can fill out with the user's mobile ID and a message and the application will send a SMS message right to the phone without the SMTP intermediate step. you can write an application that sends HTTP POSTs to whatever forms you need to to communicate with your users wirelessly. 3) set up relationships with the carriers you need and get approval to post directly to their SMS gateways. --dylan -Original Message- From: Vikram-burlee [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 12:33 AM To: CF-Talk Subject: HELP wap !!! Hi... I have been working with cold fusion for over 2 years in India and i have an requirement where in i have to send mails to my customers to their wireless systems I would like to know what are the various ways i can send mails to their cell phones and also what technology i will have to learn to implement it myself or is their any code i can outsource for evaluation purpose Could any one help me out please ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Excel to SQL7
To further elaborate. I guess I was hoping that DTS would be stateless in much the same way CF is. Where string data that passes all of the rules of being a number could be used as a number. One thing that could work is putting the Excel data into a temp file and then using CF to loop through that file and insert the records into the destination file. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Urgent.... please help...
looks like i missed one point here. Our productions servers are in load balancing environment. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:15 AM To: CF-Talk Subject: RE: Urgent please help... Check for invalid numbers in the time out settings. I got bit in the behind by putting a 60 in the minutes parameter in the createtimespan function. For 24 hours use: CreateTimeSpan(1, 0, 0, 0) not CreateTimeSpan(0, 24, 0, 0) Duane -Original Message- From: Vani Kolli [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:29 AM To: CF-Talk Subject: RE: Urgent please help... No even the max time out on my server is the same.. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 8:30 AM To: CF-Talk Subject: RE: Urgent please help... Sounds like you are exceeding the max timeout setup in the CFAdmin. Duane -Original Message- From: Vani Kolli [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:05 AM To: CF-Talk Subject: Urgent please help... Hi all, I am using session variables in my application and session timeout is 24 hours. But my session times out before that. And also some of the variables time out and some of them don't. How do i overcome with this problem. We have 4.0 server with 2000/IIS and this is happening on my production site. I tried to store it in database even then it's happening. Can anyone help me out. This is very urgent Thanks Vani ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Connecting to Lotus Notes
Long time ago I tried this. There was a little Note ODBC connector and I could read data. Had a hell of time writing data into a DB but given enough time you can probably figure it out. Thanks, Neil - Original Message - From: "Adam Reynolds" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 10:21 AM Subject: Connecting to Lotus Notes Anybody know about or has done this type connection using CF? Best Regards, Adam Reynolds ColdFusion Web Developer ISMG Development, Unilever London ( +44 20 7822 5450 (ext 5450) m: +44 7973 386620 * [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: as400 connection : error still
check your port number, default is 446. Mak Wing Lok wrote: hi, i tried with your steps below but get a different error : db2 = connect to ILSDB user MS007 using PASSWORD SQL10012N An unexpected operating system error was received while loading the specified library "libddcs.a". SQLSTATE=42724 i did restart the DB manager according the DB2 connect manual but it did not work, what seem to caused the above error, is it my Solaris or AS400?, and how to solve it? thanks. mak wl - Original Message - From: "James Taavon" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 12:27 AM Subject: Re: as400 connection Ok, here is what you need to do: - Make sure you are running DB2 Connect Version 5 Fixpak 6 on your Solaris Server. - From DB2 Connect create a catalog for your database - At the command prompt type the following - catalog tcpip node "as400 or any name" remote "as400 hostname or ip address" server "port number" - catalog database "dbname" as "dbalias" at node "same as previous line" authentication dcs - catalog dcs database "dbname" as "dbalias" - connect to the database using an assigned username and password to check if cataloging was successful Then once the connection is confirmed go into your CF Administrator and setup your connection with a username a password, then test. The connection should be successful. If you have anymore questions, let me know. Mak Wing Lok wrote: my CF server is sitting on Sun Solaris server, what should i do then? did client server come with an Unix version? - Original Message - From: Robert Everland III [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 12:24 PM Subject: RE: as400 connection Yes you use client access's built in odbc connection. Very easy, kind of slow but I haven't really had too much problems with it. Getting AS/400 SQL should speed up everything though, with stored procedures and all. Bob Everland -Original Message- From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] Sent: Monday, February 12, 2001 11:11 PM To: CF-Talk Subject: as400 connection hi people, did anyone know that if it is possible for CF server to "talk" to AS/400 machine? advise needed, thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 404 Error
Dacha, If you have enabled session variables, this is easy. In your application.cfm page insert this code below your cfapplication... CFERROR TYPE="Request" TEMPLATE="error.cfm" MAILTO="[EMAIL PROTECTED]" Then be sure to have a custom error.cfm page within that directory scope. It is important to note that CFSERVER will not process anything but html on the error page. Tony Gruen -Original Message- From: ZAMEX [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 3:51 AM To: CF-Talk Subject: 404 Error This is a multi-part message in MIME format. --DF5FC63736D5ED85F5E527F7 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, Anyone knows how to set up customized error page in CF 4.0 for 404 Error OR Page Not Fount OR HTTP/1.0 404 Object Not Found. Thanks in advance, Dacha. --DF5FC63736D5ED85F5E527F7 Content-Type: text/x-vcard; charset=us-ascii; name="zamex.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for ZAMEX Content-Disposition: attachment; filename="zamex.vcf" begin:vcard n:Hrkalovic;Danilo tel;cell:+381 63 365 834 tel;work:+381 11 8013 496 x-mozilla-html:FALSE org:ZAMEX - web design promotion adr:;;Gnjionska II/5;Beograd;;11253;Yugoslavia version:2.1 email;internet:[EMAIL PROTECTED] title:Web Konsultant fn:Danilo Hrkalovic end:vcard --DF5FC63736D5ED85F5E527F7-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFCOOKIE help
Hi, Silly question...I know that a page can't set a cookie if it has a CFLOCATION on it, but will it set it if the cookie is defined in an included page, but the calling page has a redirect? What if I redirect with JavaScript? Jim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
What are some options for generating large outputs
A user has specifically requested to see the results of a query where the resulting output is 32,000 or more records. It takes more than 15 minutes to generate the huge HTML table that is currently being generated, the server is slowed down during this time, the potential for thread conflicts occur, etc. We also are aware that some versions of browsers that have severe problems attempting to display or print massive sized tables. An attempt was made to turn this data into html data which was then imported into Excel as an alternate means of display - Excel then reported with 'out of memory' after an hour So what are some alternatives? Perhaps generation of an Excel spreadsheet directly - except does anyone know of a Solaris ColdFusion tag that runs efficiently and generates an Excel compatible spreadsheet? What are some alternatives means of presenting massive amounts of tabular data? -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dateformat behaviour
actually, it looks like DateFormat is helping you out by assuming that the second date you supply is the "european" style of mm/dd/. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: INGECOM - D. Delcomminette [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:05 AM To: CF-Talk Subject: Dateformat behaviour Have a strange behaviour of DateFormat() function. Look at the following code and the results below. In my opinion CF could give me an error message on the second line (invalid date) but certainly not invert the day and month as it does! Your comments? Dominique cfoutput TABLE border="1" TR TDDateformat("01/12/2000","mmdd")/TD TD#Dateformat("01/12/2000","mmdd")#/TD/TR TR TDDateformat("13/12/2000","mmdd")/TD TD#Dateformat("13/12/2000","mmdd")# /TD/TR/TABLE/P /CFOUTPUT/P Dateformat("01/12/2000","mmdd") 2112 Dateformat("13/12/2000","mmdd") 20001213 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Opening Adobe Acrobat form from CF page with SSL
In our app we have a PDF that we open from a CF page and populate with a bunch of data as a sort of preview so they can look at it before printing. We've never had a problem with this functionality until we put it on a setup with separate CF and SQL (using Microsoft SQL 7) servers and turned on SSL. Turn SSL off, works fine. It won't even launch Adobe. Has anyone run into this before? Any ideas? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Charting Technology?
I am looking for something that will do charting like flow charts, network diagrams, process diagrams, that will work with CF and can be dynamic. I have looked at SVG by Adobe, and though it is XML, it is a bit clugy. Is there anything else out there that someone can at least point at so I can take a look. Also, if you have done some of these before, I would be interested in seeing a sample code to get me started evaluating it. Thanks, Vance Duke Sr. Cold Fusion Developer ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP wap !!!!!!!
The link below should provide all the info you need ;o) http://www.novelsoft.ch/sms-center/e/services.html HtH -= Ed -Original Message- From: Russell Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 3:50 PM To: CF-Talk Subject: RE: HELP wap !!! I'd like deatils of this very much please.:-) Russell Brown Internet Application Developer Freeserve.com Plc, PO Box 452, Leeds LS2 7EY Telephone: 0113 207 1203 -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 15:15 To: CF-Talk Subject: RE: HELP wap !!! There's also a carrier in Switzerland that lets you send SMS messages via a predefined email template, it works really nicely in CF and means that your users don't have to be signed up for mobile email. Let me know if you want the details ;o) -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 2:47 PM To: CF-Talk Subject: RE: HELP wap !!! you can do it one of three ways; 1) send an email to the phone based on their mobile ID. you need to know what the domain is for the mail accounts each carrier assigns. then you need to collect the mobile IDs of the users. you would send an email to something like [EMAIL PROTECTED] where 1...0 is their number and mail.carrier.com is the mail domain. on the infrastructure side, the carrier sends your email to the phone using SMS. 2) some carriers have web-based forms you can fill out with the user's mobile ID and a message and the application will send a SMS message right to the phone without the SMTP intermediate step. you can write an application that sends HTTP POSTs to whatever forms you need to to communicate with your users wirelessly. 3) set up relationships with the carriers you need and get approval to post directly to their SMS gateways. --dylan -Original Message- From: Vikram-burlee [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 12:33 AM To: CF-Talk Subject: HELP wap !!! Hi... I have been working with cold fusion for over 2 years in India and i have an requirement where in i have to send mails to my customers to their wireless systems I would like to know what are the various ways i can send mails to their cell phones and also what technology i will have to learn to implement it myself or is their any code i can outsource for evaluation purpose Could any one help me out please ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Clearing CF Admin log files
How can I clear the CF Admin log files? Is it safe to delete those log files in cfusion/log? Thanks for your help. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Excel to SQL7
To further elaborate. I guess I was hoping that DTS would be stateless in much the same way CF is. Where string data that passes all of the rules of being a number could be used as a number. One thing that could work is putting the Excel data into a temp file and then using CF to loop through that file and insert the records into the destination file. DTS uses a variant of the ODBC Excel driver, and as such if a field numeric at the top, it MUST be numeric all the way down Two ways around this; Copy the columns to force them to be text =Mid("'"A1,2,Len(A1)) Copy the data into an Access database with all fields as text, then import this rather than the Excel Not clean, but both work Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Connecting to Lotus Notes
One of our developers here has done this. I can't find the code though, sorry. You have to install the Notes client on the server to get the ODBC drivers to setup the DSN. You can read and write, but according to this developer you can't use CFTRANSACTION. Cheers! -- Douglas Knudsen LTT, that's Leveraged Technologies Team [EMAIL PROTECTED] Got Linux? http://linuxmall.com From: [EMAIL PROTECTED] AT INTERNET on 02/14/2001 10:21 AM To: Douglas Knudsen/ATL/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: Subject: Connecting to Lotus Notes Anybody know about or has done this type connection using CF? Best Regards, Adam Reynolds ColdFusion Web Developer ISMG Development, Unilever London ( +44 20 7822 5450 (ext 5450) m: +44 7973 386620 * [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Using excel as a data source????
I set up cold fusion with an excel file but I can't seem to find any documentation on how to perform a query on the file. I have tried referencing it my the excel sheet name and by file name. Please Help Thanks Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dateformat behaviour
DateFormat assumes US date formats by default - it is effectivelt a hardwired US locale specific version of LSDateFormat. I would recommend that you set your locale using SetLocale("English (UK)") [or whatever] and then use the locale specific versions of the date and time manipulation functions. Steve -Original Message- From: INGECOM - D. Delcomminette [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 14:05 To: CF-Talk Subject: Dateformat behaviour Have a strange behaviour of DateFormat() function. Look at the following code and the results below. In my opinion CF could give me an error message on the second line (invalid date) but certainly not invert the day and month as it does! Your comments? Dominique cfoutput TABLE border="1" TR TDDateformat("01/12/2000","mmdd")/TD TD#Dateformat("01/12/2000","mmdd")#/TD/TR TR TDDateformat("13/12/2000","mmdd")/TD TD#Dateformat("13/12/2000","mmdd")# /TD/TR/TABLE/P /CFOUTPUT/P Dateformat("01/12/2000","mmdd") 2112 Dateformat("13/12/2000","mmdd") 20001213 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFCOOKIE help
javascript redirect is fine as it occurs after the page has been through cf server and is then sent to browser, rendered, redirected via JS . Russell Brown Internet Application Developer Freeserve.com Plc, PO Box 452, Leeds LS2 7EY Telephone: 0113 207 1203 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 16:18 To: CF-Talk Subject: CFCOOKIE help Hi, Silly question...I know that a page can't set a cookie if it has a CFLOCATION on it, but will it set it if the cookie is defined in an included page, but the calling page has a redirect? What if I redirect with JavaScript? Jim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
(Article) Numeric lookups in Structures
From the depths of the FRB comes the voice of the prophet. He speaks words of wisdom for those who wish to listen. The words spoken now concern using numbers as a lookup index in a structure rather than text. This will be written up as a paper on www.fusionauthority.com. The Book of Michael says: An associative array is an alternative name for a structure. It also points to the ability of a structure to resemble an array in all ways. All you have to remember is that the lookup keys have to be text. HR CFSCRIPT // create an array with one dimension aTest=ArrayNew(1); // create a standard structure sTest=StructNew(); // load the array with data using the standard set syntax aTest[1]="first"; aTest[2]="second"; /* load the structure with data using associative array syntax. Notice that the numeric lookup id is surrounded by single quotes. This causes ColdFusion to treat it as text and will therefore be 'legal' as a structure lookup. Path lookups in this case will always fail i.e. sTest.1 */ sTest['1']="first"; sTest['2']="second"; /CFSCRIPT !--- Results to show that the test is working properly --- CFOUTPUT #aTest[1]#BR #aTest[2]#BR #sTest['1']#BR #sTest['2']#BR /CFOUTPUT ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFCOOKIE help
Silly question... Doubtful. :) I know that a page can't set a cookie if it has a CFLOCATION on it, but will it set it if the cookie is defined in an included page, but the calling page has a redirect? No, it will not. The issue with CFLOCATION is that ColdFusion aborts the normal processing of the client request and simply sends a redirect back to the browser. Fortunately, you can overcome this with the following tip: http://www.teamallaire.com/tutorials/index.cfm?fuseaction=displaytopicid=01 3 Instead of using the CFLOCATION tag, write the HTTP header manually. This is actually more like the process you would have to go through in other scripting languages like as Perl. What if I redirect with JavaScript? That will work, though your more dependent on the client than you would be with the above solution as more browsers support HTTP redirection as compared to JavaScript. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What are some options for generating large outputs
what db are you running against? ColdFusion 5.0 which is scheduled to be released in Q2, will actually display the records to the browser as it is retrieving them. But since your issue obviously requires an immediate solution, I recommend using a stored procedure to return 'n' records at a time. This would require using cursors in your stored proc to control what comes back. --- "Larry W. Virden" [EMAIL PROTECTED] wrote: A user has specifically requested to see the results of a query where the resulting output is 32,000 or more records. It takes more than 15 minutes to generate the huge HTML table that is currently being generated, the server is slowed down during this time, the potential for thread conflicts occur, etc. We also are aware that some versions of browsers that have severe problems attempting to display or print massive sized tables. An attempt was made to turn this data into html data which was then imported into Excel as an alternate means of display - Excel then reported with 'out of memory' after an hour So what are some alternatives? Perhaps generation of an Excel spreadsheet directly - except does anyone know of a Solaris ColdFusion tag that runs efficiently and generates an Excel compatible spreadsheet? What are some alternatives means of presenting massive amounts of tabular data? -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What are some options for generating large outputs
Did you try outputing it as a comma delimited (or some other delimiter) csv file.? I had a simillar problem a while back and doing it as a delimited file was an awful lot quicker. Just a thought. -= Ed -Original Message- From: Larry W. Virden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 4:17 PM To: CF-Talk Subject: What are some options for generating large outputs A user has specifically requested to see the results of a query where the resulting output is 32,000 or more records. It takes more than 15 minutes to generate the huge HTML table that is currently being generated, the server is slowed down during this time, the potential for thread conflicts occur, etc. We also are aware that some versions of browsers that have severe problems attempting to display or print massive sized tables. An attempt was made to turn this data into html data which was then imported into Excel as an alternate means of display - Excel then reported with 'out of memory' after an hour So what are some alternatives? Perhaps generation of an Excel spreadsheet directly - except does anyone know of a Solaris ColdFusion tag that runs efficiently and generates an Excel compatible spreadsheet? What are some alternatives means of presenting massive amounts of tabular data? -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What are some options for generating large outputs
Have you considered generating a comma separated file and then importing to Excel? This is how I've had to manage it in the past when working in a UNIX environment. No fancy hooks into MSOffice via COM. ;-( Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Larry W. Virden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:17 AM To: CF-Talk Subject: What are some options for generating large outputs A user has specifically requested to see the results of a query where the resulting output is 32,000 or more records. It takes more than 15 minutes to generate the huge HTML table that is currently being generated, the server is slowed down during this time, the potential for thread conflicts occur, etc. We also are aware that some versions of browsers that have severe problems attempting to display or print massive sized tables. An attempt was made to turn this data into html data which was then imported into Excel as an alternate means of display - Excel then reported with 'out of memory' after an hour So what are some alternatives? Perhaps generation of an Excel spreadsheet directly - except does anyone know of a Solaris ColdFusion tag that runs efficiently and generates an Excel compatible spreadsheet? What are some alternatives means of presenting massive amounts of tabular data? -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFCOOKIE help
I do that very thing with a Javascript redirect to get around the cfloacation problem. It works fine. Harry Wagner Dept A63S AP14B 847 937-8882 JMilks [EMAIL PROTECTED] 02/14/2001 10:54 AM Please respond to cf-talk To: cf-talk [EMAIL PROTECTED] cc: Subject: CFCOOKIE help Hi, Silly question...I know that a page can't set a cookie if it has a CFLOCATION on it, but will it set it if the cookie is defined in an included page, but the calling page has a redirect? What if I redirect with JavaScript? Jim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What are some options for generating large outputs
You could generate a CSV file (comma-separated values) which Excel can open. Excel does have a relatively low (~ 250) limit on the number of columns that it will handle with a CSV file, and I've only created files with ~ 1000 rows. Anyway, CF + Unix tools can easily create a valid CSV file. -Original Message- From: Larry W. Virden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 11:17 AM To: CF-Talk Subject: What are some options for generating large outputs A user has specifically requested to see the results of a query where the resulting output is 32,000 or more records. It takes more than 15 minutes to generate the huge HTML table that is currently being generated, the server is slowed down during this time, the potential for thread conflicts occur, etc. We also are aware that some versions of browsers that have severe problems attempting to display or print massive sized tables. An attempt was made to turn this data into html data which was then imported into Excel as an alternate means of display - Excel then reported with 'out of memory' after an hour So what are some alternatives? Perhaps generation of an Excel spreadsheet directly - except does anyone know of a Solaris ColdFusion tag that runs efficiently and generates an Excel compatible spreadsheet? What are some alternatives means of presenting massive amounts of tabular data? -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What are some options for generating large outputs
What is the database you are using? You could write a SQL statement to extract the information and save it to a simple text file in a CSV format then import it to excel. Remember that depending on what version of excel you are using effects how many rows it can import. Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x123 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -Original Message- From: Larry W. Virden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 11:17 To: CF-Talk Subject: What are some options for generating large outputs A user has specifically requested to see the results of a query where the resulting output is 32,000 or more records. It takes more than 15 minutes to generate the huge HTML table that is currently being generated, the server is slowed down during this time, the potential for thread conflicts occur, etc. We also are aware that some versions of browsers that have severe problems attempting to display or print massive sized tables. An attempt was made to turn this data into html data which was then imported into Excel as an alternate means of display - Excel then reported with 'out of memory' after an hour So what are some alternatives? Perhaps generation of an Excel spreadsheet directly - except does anyone know of a Solaris ColdFusion tag that runs efficiently and generates an Excel compatible spreadsheet? What are some alternatives means of presenting massive amounts of tabular data? -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What are some options for generating large outputs
Just generate a .cvs (Comma delimites) text file and do a cfcontent into excel with it. Works like a charm here. Dave - Original Message - From: "Larry W. Virden" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 11:17 AM Subject: What are some options for generating large outputs A user has specifically requested to see the results of a query where the resulting output is 32,000 or more records. It takes more than 15 minutes to generate the huge HTML table that is currently being generated, the server is slowed down during this time, the potential for thread conflicts occur, etc. We also are aware that some versions of browsers that have severe problems attempting to display or print massive sized tables. An attempt was made to turn this data into html data which was then imported into Excel as an alternate means of display - Excel then reported with 'out of memory' after an hour So what are some alternatives? Perhaps generation of an Excel spreadsheet directly - except does anyone know of a Solaris ColdFusion tag that runs efficiently and generates an Excel compatible spreadsheet? What are some alternatives means of presenting massive amounts of tabular data? -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Extending CFFORM
Its not that CFFORM can not be extended, its that people have not read the depths of the docs. CFFORM can be seen as being composed of 4 things. The first is the ability to create standard form tags dynamically. The second is to use pre-built javascript validation libraries. The third is to use pre-built Java form elements. The fourth is to define YOUR OWN java form elements. When thinking about extending CFFORM, people tend to forget that they can add their own Javascript validation scripts to extend tha abilities. They also forget (or usually don't know) that using the CFAPPLET tag will allow them to take a java applet that has a specific variable name or two and just 'plug it into' a CFFORM. In all my time using CF, I've only seen two custom Java CFFORM applets. The first is the calculator that I showed off in my CFFORM chapter in the WACK (vol 23). The other is a demo applet that ships with the CF docs. Unfortunatly (or fortunatly), this is all moot now as Harpoon will be taking over for most, if not all of the java applets in CF and will probably become the 'standard' for extending CFFORM. The only reason I write this is because someone mentioned that a negative with CF is that it dosn't allow CFFORM to be extended. p.s. on his other mention of CFOBJECT not supporting the asp model, this is not a part of the COM specification. Its something MS added in for their own use. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What are some options for generating large outputs
Crystal Reports ..? PDF ...? www.activePDF.com / www.digapp.com (probably the best ..) Guess it kinds of depends on how complex the layout of the data reports are Steve - Original Message - From: "Larry W. Virden" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 8:17 AM Subject: What are some options for generating large outputs A user has specifically requested to see the results of a query where the resulting output is 32,000 or more records. It takes more than 15 minutes to generate the huge HTML table that is currently being generated, the server is slowed down during this time, the potential for thread conflicts occur, etc. We also are aware that some versions of browsers that have severe problems attempting to display or print massive sized tables. An attempt was made to turn this data into html data which was then imported into Excel as an alternate means of display - Excel then reported with 'out of memory' after an hour So what are some alternatives? Perhaps generation of an Excel spreadsheet directly - except does anyone know of a Solaris ColdFusion tag that runs efficiently and generates an Excel compatible spreadsheet? What are some alternatives means of presenting massive amounts of tabular data? -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: IIS 4.0 integration with VSS 6.0
Anybody out there had any experience installing MS Visual Sourcesafe 6.0 and integrating it with IIS 4.0? All the documentation I can find points to an install option (in VSS install) that seems to have existed in VSS 5.0 but does not exist in VSS 6.0. Am I missing something obvious? Answers off-list would be appreciated. Thanks in advance and sorry about the OT :o) will - William H. Bowen Web Solutions Consultant misterbowen.com 425.423.0794 Voice 425.740.0183 FAX ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP wap !!!!!!!
Great, thanks Russell Brown Internet Application Developer Freeserve.com Plc, PO Box 452, Leeds LS2 7EY Telephone: 0113 207 1203 -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 16:36 To: CF-Talk Subject: RE: HELP wap !!! The link below should provide all the info you need ;o) http://www.novelsoft.ch/sms-center/e/services.html HtH -= Ed -Original Message- From: Russell Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 3:50 PM To: CF-Talk Subject: RE: HELP wap !!! I'd like deatils of this very much please.:-) Russell Brown Internet Application Developer Freeserve.com Plc, PO Box 452, Leeds LS2 7EY Telephone: 0113 207 1203 -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 15:15 To: CF-Talk Subject: RE: HELP wap !!! There's also a carrier in Switzerland that lets you send SMS messages via a predefined email template, it works really nicely in CF and means that your users don't have to be signed up for mobile email. Let me know if you want the details ;o) -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 2:47 PM To: CF-Talk Subject: RE: HELP wap !!! you can do it one of three ways; 1) send an email to the phone based on their mobile ID. you need to know what the domain is for the mail accounts each carrier assigns. then you need to collect the mobile IDs of the users. you would send an email to something like [EMAIL PROTECTED] where 1...0 is their number and mail.carrier.com is the mail domain. on the infrastructure side, the carrier sends your email to the phone using SMS. 2) some carriers have web-based forms you can fill out with the user's mobile ID and a message and the application will send a SMS message right to the phone without the SMTP intermediate step. you can write an application that sends HTTP POSTs to whatever forms you need to to communicate with your users wirelessly. 3) set up relationships with the carriers you need and get approval to post directly to their SMS gateways. --dylan -Original Message- From: Vikram-burlee [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 12:33 AM To: CF-Talk Subject: HELP wap !!! Hi... I have been working with cold fusion for over 2 years in India and i have an requirement where in i have to send mails to my customers to their wireless systems I would like to know what are the various ways i can send mails to their cell phones and also what technology i will have to learn to implement it myself or is their any code i can outsource for evaluation purpose Could any one help me out please ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What are some options for generating large outputs
Larry, The best option I can think of is to use CFScript for the output, and put the data inside of pre/pre tags so that you can format without having a table...I can't tell you how much time this would save but it would reduce the overhead used by the table...however you won't have any nice formatting with it :) Example code... cfquery name="myquery" datasource="mydsn"SELECT username, firstname, lastname FROM biglist ORDER BY username/cfquery pre cfscript WriteOutput(" Username First Name Last Name\n"); for(i=1;i LE myquery.recordcount;i=i+1) { WriteOutput(" #myquery.username[i]# #myquery.firstname[i]# #myquery.lastname[i]\n"); } /cfscript /pre Chris Maloney -Original Message- From: Larry W. Virden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 10:17 AM To: CF-Talk Subject: What are some options for generating large outputs A user has specifically requested to see the results of a query where the resulting output is 32,000 or more records. It takes more than 15 minutes to generate the huge HTML table that is currently being generated, the server is slowed down during this time, the potential for thread conflicts occur, etc. We also are aware that some versions of browsers that have severe problems attempting to display or print massive sized tables. An attempt was made to turn this data into html data which was then imported into Excel as an alternate means of display - Excel then reported with 'out of memory' after an hour So what are some alternatives? Perhaps generation of an Excel spreadsheet directly - except does anyone know of a Solaris ColdFusion tag that runs efficiently and generates an Excel compatible spreadsheet? What are some alternatives means of presenting massive amounts of tabular data? -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Parsing Headache (Removing Multiple Images)
OK.. I am writing a tag with CFHTTP to blah, blah, blah... it works fine. Now I want to port my application to the Palm Pilot so I want to remove the images from the output. Here's my line of thinking at the moment... cfscript output = #Trim(CFHTTP.FileContent)#; imageStart =#Find("img", output, 1)#; imageEnd = #Find("", output, imageStart)#; imageLen = imageEnd - imageStart + 1; output = #Replace(output, Mid(output, imageStart, imageLen), "", "ONE")#; /cfscript This works great in removing the first image. My Question: How can I loop this some how to remove all images without knowing how many are on the page? Fortunatly there are only 1-3 per page. I've been racking my brain for hours over this one.. any takers? Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: JavaScript?
Does anyone have a good javascript that will allow you to type ina startDate and endDate and it will calculate the number of days inbetween and populate a 3rd form field on the fly? any help would be appreciated. Since you asked I guess I'll post my quarterly reminder that there is an excellant javascript mailing list that was spawned by a CF-Talk member (me). It's called JS-Jive and has proven to be every bit as valuable as this list has been. You can find out more at http://groups.yahoo.com/group/JS-Jive or subscribe by sending a blank email to mailto:[EMAIL PROTECTED]. I ton of us are in this group so I invite one and all to join us! HTH, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Parsing Headache (Removing Multiple Images)
It's like lighting up a cigerette right as your meal comes... I figured it out (but am open to a better solution is anyone has one...) cfloop condition="#Find("img", output, 1)#" cfscript imageStart =#Find("img", output, 1)#; imageEnd = #Find("", output, imageStart)#; imageLen = imageEnd - imageStart + 1; output = #Replace(output, Mid(output, imageStart, imageLen), "", "ONE")#; /cfscript /cfloop Thanks, Steve "Steve Reich" [EMAIL PROTECTED] wrote in message 3a8ac460$[EMAIL PROTECTED]">news:3a8ac460$[EMAIL PROTECTED]... OK.. I am writing a tag with CFHTTP to blah, blah, blah... it works fine. Now I want to port my application to the Palm Pilot so I want to remove the images from the output. Here's my line of thinking at the moment... cfscript output = #Trim(CFHTTP.FileContent)#; imageStart =#Find("img", output, 1)#; imageEnd = #Find("", output, imageStart)#; imageLen = imageEnd - imageStart + 1; output = #Replace(output, Mid(output, imageStart, imageLen), "", "ONE")#; /cfscript This works great in removing the first image. My Question: How can I loop this some how to remove all images without knowing how many are on the page? Fortunatly there are only 1-3 per page. I've been racking my brain for hours over this one.. any takers? Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Clarification on Security Sandboxes
Ok, lemme see if I have this straight on advanced security ColdFusion sandboxes: The work on policies that you specify in the CF Admin Operating system sandboxes: Work with the operating system, banking on the username and password specified to determine what all users have. Now a question: If I want to give any given app a different set of Operating system rules (for example User A with an OS Security sandbox has access to this directory A, but not that directory B, but in another app user B, with an OS Security Sandbox has access to directory B, but not Directory A) how would I program this and enforce throughout? This can't be done using Cold Fusion (every app must obey the rules, regardless of programming). So how could I do this? Gregory Harris Web Developer The Stirling Bridge Group, LLC *We Engineer Internet Business Solutions* TEL: (949) 707-1534 FAX: (949) 707-1535 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using excel as a data source????
I set up cold fusion with an excel file but I can't seem to find any documentation on how to perform a query on the file. I have tried referencing it my the excel sheet name and by file name. Please Help OK, here's how it would be used; The ODBC source points to the file The "table name" is the sheet name with a $ on the end, but always put square brackets around it; [Sheet1$] Row 1 MUST, I repeat, MUST be the column names Once a column is decided upon (setting in the ODBC) for it's data type, it's GOT to be that datatype, other types will be ignored (i.e. putting some text in a column that starts as numeric will return a NULL) Formatting for visual needs means nothing to ODBC, it's the actual data which determines it's type - you must FORCE it to be text if you want text On this point, unless you want to release the ODBC before you upload, then use an Access database and Link Table to point to it, but the same ODBC limitations apply How to force a cell to be text; You need a "copy" column beside it and put the following formula into it; =Mid("'"a2,2,Len(a2)) Assuming that A2 is the cell that contains the original data Also, Sometimes you get blank rows at the bottom of the table, these DO count as rows - so be very careful about this... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Custom Tags for CF Logs
Any recommendations on tags for viewing th CF Logs? I downloaded Ben Forta's CFX tag but it seems that the latest version was only meant for version 3 of CF...=P I like the way this tag works though, returns results as query results thus I can manipulate them myself. Can anyone recommend something similar? -chris.alvarado [developer] - VerticalNet This message is intended only for the use of the Addressee(s) and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, dissemination of this communication is prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify [EMAIL PROTECTED] immediately. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Convert and joining on date
Hi All, In a query I am working on I am trying to do a join based on date, but all dates are stored as -mm-dd hh:mm:ss (small date) and I want to join based on -mm-dd. I can not find any actual samples in SQL BOL on using the CONVERT function to format dates. Can some lend a hand? cfquery SELECT SUM(t1.f1) AS totF1, SUM(t2.f2) AS totF2, FROM t1, t2 WHERECONVERT(t1.datefield,?) = CONVERT(t2.datefield,?) /cfquery ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What are some options for generating large outputs
A user has specifically requested to see the results of a query where the resulting output is 32,000 or more records. It takes more than 15 minutes to generate the huge HTML table that is currently being generated, the server is slowed down during this time, the potential for thread conflicts occur, etc. We also are aware that some versions of browsers that have severe problems attempting to display or print massive sized tables. An attempt was made to turn this data into html data which was then imported into Excel as an alternate means of display - Excel then reported with 'out of memory' after an hour So what are some alternatives? Perhaps generation of an Excel spreadsheet directly - except does anyone know of a Solaris ColdFusion tag that runs efficiently and generates an Excel compatible spreadsheet? What are some alternatives means of presenting massive amounts of tabular data? You really have two problems here. 1. How should you generate large reports? 2. What format should you use for these large reports? Question 2 is easiest to answer, so I'll start with that one. As some other people here have already suggested, CSV works fine for this. Question 1 is more serious. Whenever you generate large reports with CF, you may severely affect the performance of your server, as you've discovered. The key to success with these tasks is to minimize the amount of work that gets done when someone requests a report - the work done at "runtime". There are lots of ways you can do this. You could create a scheduled task that generates the report during off-peak hours. You could use something other than CF, which is best used for tasks that require runtime work. For example, you might be able to write code in the database to output your query to a file. You could migrate this functionality to a different server, so that it doesn't affect people using the CF server. In some cases, using denormalized data stores such as OLAP might help. There are lots of options here - the key, again, is to figure out which will put the least amount of work on CF while CF is being used by others. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What are some options for generating large outputs
Re: what db are you running against Oracle 8.1.6.2 for SPARC Solaris Subset display is one of the many variations we've discussed. I was hoping to find something 'outside the box' to suggest. Looks like we are covering the normal bases. Thank you to all! -- Larry W. Virden URL: mailto:[EMAIL PROTECTED] URL: http://www.purl.org/net/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What are some options for generating large outputs
Re: csv Well, I suggested outputting as csv - I even suggested using cfexecute to call a perl app to create a binary excel file, or to call oracle reports, or to try to generate a PDF with the data in it smile. I was just hoping someone would look at this and say something like "silly rabbit, large query output needed implies using solaris sparc cf_specialty_tag_that_we_somehow_missed" ... -- Larry W. Virden URL: mailto:[EMAIL PROTECTED] URL: http://www.purl.org/net/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dateformat behaviour
I think what's happening is that you're misusing the dateformat() function: it expects a date object, but you're passing it a string. DateFormat() misguidedly (IMHO) does its best to convert the string into a date, first using the US month/day/year format, and when that fails, it tries the english day/month/year format. Once it has a something it can use as a date then it formats it to the mask you specify. To avoid this sort of thing, always pass around dates as actual date objects, and only use the DateFormat when dumping a date onto a page, and when you need to do dB stuff then CreateODBCDate should do the trick. If you have users inputting dates, then as _soon_ as you get them, use CreateDate() to create a date object. This way you know that any dates you are handling are date objects rather than strings, and you shouldn't run into this sort of unexpected behaviour. HTH. Bert -Original Message- From: INGECOM - D. Delcomminette [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 14:05 To: CF-Talk Subject: Dateformat behaviour Have a strange behaviour of DateFormat() function. Look at the following code and the results below. In my opinion CF could give me an error message on the second line (invalid date) but certainly not invert the day and month as it does! Your comments? Dominique cfoutput TABLE border="1" TR TDDateformat("01/12/2000","mmdd")/TD TD#Dateformat("01/12/2000","mmdd")#/TD/TR TR TDDateformat("13/12/2000","mmdd")/TD TD#Dateformat("13/12/2000","mmdd")# /TD/TR/TABLE/P /CFOUTPUT/P Dateformat("01/12/2000","mmdd") 2112 Dateformat("13/12/2000","mmdd") 20001213 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hey Dave when can we see your email code
Welcome to America. Anyways, I do agree. Jeremy Allen elliptIQ Inc. -Original Message- From: Shawnea Carter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 9:53 AM To: CF-Talk Subject: Re: Hey Dave when can we see your email code Folks, It is time for a fact check: Michael D. VOLUNTEERS his server space, his time, his bandwidth ON TOP OF running is own site, magazine and contracting to support his family. I personally don't know how they guy has time to BREATHE much less respond to 3,000 individual requests for code. I am certain that when he has TIME he will post it a place where you guys can get to it. In the interim - get off of his back. Sorry to be harsh but this is about the 20th time this week (and the 20,000th time since I joined this list) that I have seen people be less than gracious to our host. cf_steps_of_soapbox Shawnea Carter - Original Message - From: "paul smith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 9:31 AM Subject: RE: Hey Dave when can we see your email code Yes, Michael, I too, had asked for the code earlier and am not sure if you noticed my request. best, paul At 11:46 AM 2/13/01 +, you wrote: Just thought I'd jump on the bandwagon. Could you send me the code as well please. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 13 February 2001 01:33 To: CF-Talk Subject: Re: Hey Dave when can we see your email code Um, the names Michael. Dave's a different guy. I'm sending the code now. Your getting the error monitor template that I use for auto-email of ALL site based errors and the template I use to 'clean' the email and make it ready to be placed into the DB and to be sent. I rem a couple weeks ago you asked if anyone wanted to see the code you use for HOF to email you off list, I did but haven't heard anything. I have seen a few people ask about your code. I would definitely be interested in taking a look at it if the offer still stands. Bob Everland ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Clearing CF Admin log files
If you don't need them, it is safe to delete them. - Original Message - From: "river" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 9:41 AM Subject: Clearing CF Admin log files How can I clear the CF Admin log files? Is it safe to delete those log files in cfusion/log? Thanks for your help. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFSCRIPT
Sorry if this is a dumb question, but i'm curious about CFSCRIPT. what language is the script written in? i've seen some examples that look like javascript, but i haven't been able to determine for sure what language is being used. Also, if anyone can point me to a source where i can learn more about it and why/where/when to use it, i'd appreciate it. thanks. david ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: WINNT/TASK could not start
Does anybody here experience a message "COULD NOT START" status on your scheduled WINNT tasks? I don't know where to fix this? Can somebody let me know if they experience this and know how to fix it. Thank you. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Convert and joining on date
Got it, a little more digging did the trick. CONVERT(char(12), t1.date1, 107) = CONVERT(char(12), t2.date2, 107) -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 1:17 PM To: CFTalk Subject: SQL Convert and joining on date Hi All, In a query I am working on I am trying to do a join based on date, but all dates are stored as -mm-dd hh:mm:ss (small date) and I want to join based on -mm-dd. I can not find any actual samples in SQL BOL on using the CONVERT function to format dates. Can some lend a hand? cfquery SELECT SUM(t1.f1) AS totF1, SUM(t2.f2) AS totF2, FROM t1, t2 WHERECONVERT(t1.datefield,?) = CONVERT(t2.datefield,?) /cfquery ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: REPOST: Weird pcode error (please! help!)
Really? Can anyone confirm that not putting a dbtype in cfquery causes cfschedule to throw PCode exceptions? -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 4:41 PM To: CF-Talk Subject: RE: REPOST: Weird pcode error (please! help!) Need to put in a dbtype. ODBC OLE ... Joshua Tipton -Original Message- From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 10:10 AM To: CF-Talk Subject: REPOST: Weird pcode error (please! help!) Can *anyone* shed any light on this? Please? Help! Sometime yesterday around 19:49, my CF Server started throwing pcode errors by the hundreds, like this: unknown exception condition PCodeRuntimeContextImp::setVariableThe error occurred while processing an element with a general identifier of (CFSCHEDULE), occupying document position (3:1) to (5:13).Date/Time: 02/11/01 21:51:28Browser: Remote Address: Template: C:\CFUSION\Scripts\cfexectask.cfmQuery String: TASK=check for db upload (all of them in cfschedule processing) ..and right about the same time, this simple piece of code: CFQUERY NAME="Getcarbrands" DATASOURCE="dsn" SELECT distinct Merk FROM Cars /CFQUERY SELECT name="Merk" CFOUTPUT QUERY="Getcarbrands" OPTION VALUE="#Merk#"#Merk#/OPTION /cfoutput /SELECT started throwing this exception: QUERY The QUERY attribute of the tag does not specify the name of an available query The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (270:1) to (270:31) I have ab-so-lu-te-ly no idea why this happened, and a simple cycle of CF apparently took care of the problem. Any ideas why this would happen? It *is* one of our only remaining CF 4.0.1 servers, but it has plenty RAM HD and it has been running for some time without that particular problem ever cropping up before. Michel Vuijlsteke Netpoint NV ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Parsing Headache (Removing Multiple Images)
Steve, Why not try something easier: cfscript output = Trim(CFHTTP.FileContent); output = REReplaceNoCase(output, "img[^/]+[/]?", "", "all"); /cfscript Best, Seva Petrov Senior Developer TheSquare.com -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 12:44 PM To: CF-Talk Subject: Parsing Headache (Removing Multiple Images) OK.. I am writing a tag with CFHTTP to blah, blah, blah... it works fine. Now I want to port my application to the Palm Pilot so I want to remove the images from the output. Here's my line of thinking at the moment... cfscript output = #Trim(CFHTTP.FileContent)#; imageStart =#Find("img", output, 1)#; imageEnd = #Find("", output, imageStart)#; imageLen = imageEnd - imageStart + 1; output = #Replace(output, Mid(output, imageStart, imageLen), "", "ONE")#; /cfscript This works great in removing the first image. My Question: How can I loop this some how to remove all images without knowing how many are on the page? Fortunatly there are only 1-3 per page. I've been racking my brain for hours over this one.. any takers? Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Parsing Headache (Removing Multiple Images)
REreplace(page,"img.*[^]","","ALL") or something??? Justin -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 5:44 PM To: CF-Talk Subject: Parsing Headache (Removing Multiple Images) OK.. I am writing a tag with CFHTTP to blah, blah, blah... it works fine. Now I want to port my application to the Palm Pilot so I want to remove the images from the output. Here's my line of thinking at the moment... cfscript output = #Trim(CFHTTP.FileContent)#; imageStart =#Find("img", output, 1)#; imageEnd = #Find("", output, imageStart)#; imageLen = imageEnd - imageStart + 1; output = #Replace(output, Mid(output, imageStart, imageLen), "", "ONE")#; /cfscript This works great in removing the first image. My Question: How can I loop this some how to remove all images without knowing how many are on the page? Fortunatly there are only 1-3 per page. I've been racking my brain for hours over this one.. any takers? Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Installing an ActiveX control in Netscape
Have you looked at NCompass plug-in? I am not sure if they still make it, but thats what we use for problems similiar to yours. Dave Adams CFUG Ottawa - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 09, 2001 8:57 AM Subject: OT: Installing an ActiveX control in Netscape I have an ActiveX control that I need to be cross-browser. I have a plug-in for Netscape that will allow the control to be run, but unfortunately it will not install the control first... the only way I can currently do it is to force the user to view the page first in IE and then the control will work (via the plug-in) in Netscape. Can anyone tell me if there is a way to force an ActiveX control (it is a .cab file containing an .ocx and an ..inf) to install? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Parsing Headache (Removing Multiple Images)
Steve Try: cfhttp method="get" URL="http://apple.excite.com/" cfset cleanText = ReReplaceNoCase(CFHTTP.FileContent, "IMG[^]*", "", "ALL") cfoutput#cleanText#/cfoutput HTH Dick At 12:44 PM -0500 2/14/01, Steve Reich wrote: OK.. I am writing a tag with CFHTTP to blah, blah, blah... it works fine. Now I want to port my application to the Palm Pilot so I want to remove the images from the output. Here's my line of thinking at the moment... cfscript output = #Trim(CFHTTP.FileContent)#; imageStart =#Find("img", output, 1)#; imageEnd = #Find("", output, imageStart)#; imageLen = imageEnd - imageStart + 1; output = #Replace(output, Mid(output, imageStart, imageLen), "", "ONE")#; /cfscript This works great in removing the first image. My Question: How can I loop this some how to remove all images without knowing how many are on the page? Fortunatly there are only 1-3 per page. I've been racking my brain for hours over this one.. any takers? Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Parsing Headache (Removing Multiple Images)
At 12:44 PM 2/14/01 -0500, you wrote: OK.. I am writing a tag with CFHTTP to blah, blah, blah... it works fine. Now I want to port my application to the Palm Pilot so I want to remove the images from the output. Here's my line of thinking at the moment... cfscript output = #Trim(CFHTTP.FileContent)#; imageStart =#Find("img", output, 1)#; imageEnd = #Find("", output, imageStart)#; imageLen = imageEnd - imageStart + 1; output = #Replace(output, Mid(output, imageStart, imageLen), "", "ONE")#; /cfscript This works great in removing the first image. My Question: How can I loop this some how to remove all images without knowing how many are on the page? Fortunatly there are only 1-3 per page. I've been racking my brain for hours over this one.. any takers? It seems that you could use REReplace and a regular expression to strip out any images, although it would take me a little work to come up with a proper regex. Now announcing my newly updated website http://www.blivit.org/mr_urc/index.cfm Resume: http://www.blivit.org/mr_urc/resume.cfm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Urgent.... please help...
On paper? No I don't think you do, but I have had several of CF's settings not take full effect until the service was restarted, even when the paper said is wasn't needed. I would give it a try and see what happens, worst case is that your sites are offline for 10 seconds while you stop and restart the service, do it at 2am and no body will notice. - Original Message - From: "Vani Kolli" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 3:19 PM Subject: RE: Urgent please help... no.. do i have to -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:07 AM To: CF-Talk Subject: Re: Urgent please help... Have you restarted the CF services since the values were changed in CFAdmin? - Original Message - From: "Vani Kolli" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 2:28 PM Subject: RE: Urgent please help... No even the max time out on my server is the same.. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 8:30 AM To: CF-Talk Subject: RE: Urgent please help... Sounds like you are exceeding the max timeout setup in the CFAdmin. Duane -Original Message- From: Vani Kolli [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:05 AM To: CF-Talk Subject: Urgent please help... Hi all, I am using session variables in my application and session timeout is 24 hours. But my session times out before that. And also some of the variables time out and some of them don't. How do i overcome with this problem. We have 4.0 server with 2000/IIS and this is happening on my production site. I tried to store it in database even then it's happening. Can anyone help me out. This is very urgent Thanks Vani ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
PDFs, Linotronic PS Drivers, Forms and Adobe Licensing
So this guy says to me. It's be cool if ... I think I heard some comments on using Adobe Distiller on an Internet Server is in violation of the Adobe license for Distiller? Is this true? Here is what I am thinking. We create a basic site with an info centre to post how to's and help etc. We have downloads for people to use, basically we'll kick start a community driven file sharing centre. The documents available for download will be document design templates in the myriad of available formats, quark, word, whatever. We want to be able to create a printable format document and have decided on PDF. We want to dynamically generate the print document on the server, as a proof to the creator, and as a distributable print document to the digital printer. And also include a basic work docket as well, type of paper, shipping information etc. More or less, without actually seeing it work is to output to a common post script format (created using a free linotronic PS driver?) to be uploaded to the server using a form. Distiller can be used to watch the upload directory, and automatically create the PDF. After creation, a ticket is sent to the creator to approve the PDF for printing. Once approved we distribute to the printer for printing. So Question 1: What are the licensing issues regarding the use of Distiller on a public Server? Question 2: Performance? Question 3: Other Alternatives? Question 4: Current examples of people doing something similar. Question 5: Is there a way to programmatically enhance the print driver to automatically post the PS to the Internet Server? Other Alternatives? Implementations? Thanks Eric ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Document to PS, Form to CF, Distiller to PDF ...
So this guy says to me. It's be cool if ... I think I heard some comments on using Adobe Distiller on an Internet Server is in violation of the Adobe license for Distiller? Is this true? Here is what I am thinking. We create a basic site with an info centre to post how to's and help etc. We have downloads for people to use, basically we'll kick start a community driven file sharing centre. The documents available for download will be document design templates in the myriad of available formats, quark, word, whatever. We want to be able to create a printable format document and have decided on PDF. We want to dynamically generate the print document on the server, as a proof to the creator, and as a distributable print document to the digital printer. And also include a basic work docket as well, type of paper, shipping information etc. More or less, without actually seeing it work is to output to a common post script format (created using a free linotronic PS driver?) to be uploaded to the server using a form. Distiller can be used to watch the upload directory, and automatically create the PDF. After creation, a ticket is sent to the creator to approve the PDF for printing. Once approved we distribute to the printer for printing. So Question 1: What are the licensing issues regarding the use of Distiller on a public Server? Question 2: Performance? Question 3: Other Alternatives? Question 4: Current examples of people doing something similar. Question 5: Is there a way to programmatically enhance the print driver to automatically post the PS to the Internet Server? Other Alternatives? Implementations? Thanks Eric ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Custom Tags for CF Logs
I haven't had great luck with any of the other existing tags/applications out there. I've had the best luck with LogViewer. However, the new price tag on it is difficult to justify. There is a new tag debuting in ColdFusion 5 called CFLOG. Hopefully, this will simplify the task a bit and promote some better application built for managing the ColdFusion log files. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Chris Alvarado [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 1:16 PM To: CF-Talk Subject: Custom Tags for CF Logs Any recommendations on tags for viewing th CF Logs? I downloaded Ben Forta's CFX tag but it seems that the latest version was only meant for version 3 of CF...=P I like the way this tag works though, returns results as query results thus I can manipulate them myself. Can anyone recommend something similar? -chris.alvarado [developer] - VerticalNet This message is intended only for the use of the Addressee(s) and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, dissemination of this communication is prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify [EMAIL PROTECTED] immediately. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists