Re: IIS Administration
- Original Message - From: Michael Ross [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 10:52 AM Subject: IIS Administration I need some help. Our end goal is to have users that are able to access IIS and create sites, edit sites all that fun stuff without being server administrators. So far we set up all the users and made them power users and granted operator so they can see the IIS stuff. But they are still unable to do anything serious in IIS.Can anyone point me in the right direction to do this. Thanks Mike Mike, Try http://www.intrafoundation.com/ihtk.html -- there is a number of cfx tags that will let you control IIS, nt users, etc. I have not used it, but I have heard it works well. There may be other things like this on the tag gallery, too. Tim P. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Locked Out
cflock scope=application type=READONLY timeout=10 cfwddx action=CFML2WDDX input=#application# output=temp cfwddx action=WDDX2CFML input=#temp# output=request.application !--- You can replace the above two lines with the faster cfset request.application = Duplicate(application) if the contents of the application scope are simple. Unfortunately, under CF5, Duplicate() tends to bomb when used with structures-of-arrays-of structures and so on. --- /cflock (4) Add the following to onrequestend.cfm: cflock scope=application type=EXCLUSIVE timeout=10 cfwddx action=CFML2WDDX input=#request,application# output=temp cfwddx action=WDDX2CFML input=#temp# output=application !--- cfset application = Duplicate(request.application) --- /cflock Roger, Just curious -- what is the purpose of serializing/deserializing it into wddx and back to CF? Couldn't you just use cfset request.application = Duplicate(application) ? (with the proper locking of course) Tim P. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Browser Printing Question
- Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 11, 2002 10:31 AM Subject: Browser Printing Question When printing from a browser is there anyway to disable the printer to not print the url and path at the bottom of the page? You might want to look at ScriptX from MeadCo -- they have an activex control that lets you control the formatting.. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: WDDX / Missing Struct Keys CFMX
Brook, I just ran into this last night. I was trying to serialize the Form structure into a wddx packet and saving that, but it would only save 10 fields maximum. To get around it -- I copied the from structure to a tmp variable and then serialized the tmp var instead of form and that seemed to work and get all the variables. cfset tmp = Duplicate(form) cfwddx action=cfml2wddx input=#tmp# output=frmStruct HTH, Tim P. - Original Message - From: Brook Davies [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 11, 2002 2:35 PM Subject: WDDX / Missing Struct Keys CFMX Hello, I have a structure that I am converting to WDDX and then storing in a DB. Upon retrieving it, the structure is missing several keys. I ran this test: !--- I start with a structure containing approx 20 key's --- cfdump var=#cleanFieldStruct# !--- convert the cleanfieldStruct into a WDDX packet for insertion into the DB --- cfwddx action=cfml2wddx input=#cleanFieldStruct# output=WddxData !--- convert it back for testing --- cfwddx action=wddx2cfml input=#WddxData# output=newCleanfieldstruct cfdump var=#newcleanFieldStruct# And this results in a struct with about 50% less keys that the original?! I can not see any commonalities between the missing struct keys. Its seems to skip 1 and then 2 at a time. One other thing I just noticed is that the resulting WDDX Structure contains a max of 10 struct keys. Each time I refresh the page, the resulting WDDX structure has a max of ten, apparently random keys from the original struct. Anybody familiar with this? Brook Davies ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Strange occurrence
Correct me if I am wrong, but I thought it was possible to hijack a session if a user knew another users cfid and cftoken variables. I have seen users pages get switched if a user emails another user a url to a page with the cfid and cftoken in the url line (e.g http://mydomain.com/file.cfm?cfid=1234cftoken=29282928) Would it be possible that the one user emailed the other user a link? I did have a lot of problems with session variables getting switched and with firewalls with CF 4 -- it has been a while and it could have been a locking issue at the time -- at any rate, there was a long thread in the CF forums about this and the only fix that I was able to come up with was to switch to client variables instead. You might want to search the cf forums, if the suggestions here didn't fix it for you. Tim P. - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 9:40 AM Subject: Strange occurrence One of the guys in my user group works for a firm that is very concerned with security. They recently ran across this situation. I've offered a couple of possible explanations, but I'm interested in any other possible explanation: -he wrote--- I had an occurrence today that was very strange. I have a CF 4.5.1 Server running on NT 4.0 using IIS 4.0 with the latest service packs installed. My site looks at an incoming request and if they don't already have session variables set (cached via cookies for 48 hours) they are given a password screen to log in with. Around 13:00 Central time today a remote user was attempting to log into the site. His profile in our database did not have him authorized to log in and he was denied access as expected. While speaking with our Service Desk who was attempting to log in as him locally his remote display brought up a page that would only have been displayed to the local Service Desk technician. To the best of my knowledge, there was no password information passed to the remote user (he still wasn't authorized at that point in our profile database.) How could he possibly received a page from our server that belonged to our internal technician? The remote user and the local tech are both situated behind two different firewalls from the server. I am at a total loss, and am hoping that someone may be able to shed some light. --- I'm thinking he's not getting the full story from the help desk g Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com mxc.blogspot.com ..no more brochures! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CSS2 and NetScape
I like http://www.blooberry.com -- it has a very nice css reference. Tim P. - Original Message - From: Robert Polickoski [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 1:48 PM Subject: OT: CSS2 and NetScape All, I apologize for t he off-topic post but I am having a terrible time finding another resource. I have a site on which I am using a CSS2 style sheet (validated) to format the content. IE6 displays it beautifully. NS messes it up copmpletely. I think it is because NS hasn't implemented the position attribute. Does anyone know of a good source of information or support, preferably free? If curious, the site is http://www.buildacourse.com . Thank you, Robert Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CF MX Query of Query Lower() Function
I believe qoq has a very limited set of functions available. To get around that, I set the original query to also retrieve the name in lower case and in my qoq, search on the lower case set field. e.g cfquery name=qry1 datasource=bar Select firstname, lower(firstname) as lower_first from mytable /cfquery cfquery name=qry2 dbtype=query Select firstname from qry1 where lower_first like '%mat' /cfquery HTH, Tim P. - Original Message - From: DDE [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 31, 2002 7:18 AM Subject: CF MX Query of Query Lower() Function Looks like the usage of Lower() function in a query of query does not work as in standard SQL. Simple example: if you have a table containing names ( first_name middle_name and last_name) the following query of query : cfquery name=myquery dbtype=query select * from myfirstquery where Lower(middle_name) like '%mat' cfquery gives the following error message: The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. In case on of the rows has no value for middle_name.. This SQL statement perfectly works in Oracle or other DB. Dominique ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: capturing a query
I've created the query as a variable and use the variable inside the cfquery: cfset sql = Select * from sometable where foo = '#form.bar#' Generated sql: #sql# cfquery name=foo datasource=bar #PreserveSingleQuotes(sql)# /cfquery HTH, Tim P. - Original Message - From: bajaria aslam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 9:01 AM Subject: capturing a query Hi List. When you have the debugging on, you can see that it shows the sql generated also. You may have #variableName# in the cfquery template, but finally when all the variables get resolved, you have a query that is sent to the database. That query can be seen when the debugging is on on the webpage. is there a way to capture that final query? i tried #cgi.QueryName# , but did not work. Any ideas? thanks list __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: OT cheap SSL
Anybody can get cert from any CA -- all you have to do is prove to them the business exists. It doesn't check to see if the business itself is trustworthy. I wouldn't hinge all my trust in a company based on where the cert came from. When I consider purchasing from an online vendor, I consider the company first -- the cert later. Look at all the Yahoo! shops -- most, if not all, use certs issued to Yahoo from RSA, but not the company itself. Just my .02 tim P. - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 25, 2002 5:22 AM Subject: Re: OT cheap SSL Chris Kief wrote: These guys are fantastic. A variety of different certs to suit your needs plus excellent customer service and fast turnaround (they have one that's $119 and emailed to you within a few minutes). http://www.geotrust.com Certificates serve both the purpose of securing a connection and identifying the operator of a server. Just any certificate will be sufficient to secure a connection, you can just use a self-issued certificate for that. However, to identify the operator the CA has to establish the identity of the person that asks for a certificate. Since I don't believe they can positively identify you to be the person you say to be within a few minutes I consider them insecure and have deleted their CA signing cert from my system. Thanx for the warning, Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Read from database and insert into string
Use ValueList() e.g cfset myList = ValueList(GetEnv.strVar) - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 12:33 PM Subject: Read from database and insert into string Hi, I need to read from my database the field strVar. I have 500+ entries. I need to read every line from the database, grab the contents of that field and put all the data into a variable called results. They must all be comma delimited. cfquery name=GetEnv datasource=database-name dbtype=ODBC SELECT strVar,strDestination FROMusers /cfquery Do I need to loop through it? Example: variable = var1,var2,var3,var4...etc --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Save form data before submit
This would be fairly easy to do -- create a hidden frame and set an onBlur or onChange event to change the location of the hidden frame to a .cfm page that processes the request. e.g input type=text name=sumpin onChange=document.hiddenFrame.location='processpage.cfm?action=savesomethin gfield=sumpinval=' + document.formname.sumpin.value iframe name=hiddenFrame width=0 height=0 Then have the processpage.cfm do what you need it to do Tim P. -Original Message- From: Paul Campano [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 9:30 PM To: CF-Talk Subject: Save form data before submit Is there a way I can save the data from a form field BEFORE the submit button is pressed? I thought I saw something awhile back that used javascript to save each line to a db onBlur ? Has anyone done this or have an idea on how it can be done? Thanks. Paul Campano ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Form upload MX bug?
Will, Worked fine for me -- you said you hit Submit Query but the value of the submit button should say Attach -- you sure you are browsing the right file or need to hit refresh or something? HTH, Tim P. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 28, 2002 6:56 PM To: CF-Talk Subject: Form upload MX bug? Hi, Not having much fun with MX tonight - probably because I'm porting my old 4.5 site over to MX. My latest problem is with form-uploads - using the exact, basic, same code as I have with my 4.5 sites just doesn't work with MX. User browses for file, locates it, presses Submit Query to send the form...and the file-field just clears itself, and nothing happens. Is this a known bug, or am I being thick again? cfform method=post action=index.cfm?site=addphoto enctype=multipart/form-data pinput type=File name=ThePhoto/p cfoutputinput type=hidden name=pid value=#url.pid#/cfoutput pfont color=RedbPlease note:/b only press the Attach button bonce!/b. It'll take up to a minute to send the file to us/font/p brinput type=submit value=Attach /cfform Any ideas? Will __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Javascript Validation for Form Selects in CF ?
To check the selected value of a select, use if (document.form.dlos[document.form.dlos.selectedIndex].value == '') etc. also, your file description select doesn't have a name. HTH, Tim P. - Original Message - From: Ian Vaughan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 6:14 AM Subject: Javascript Validation for Form Selects in CF ? Hi I am trying to add javascipt validation to my form fields before the data is submitted to the database via coldfusion, however it is not working correctly and would appreciate any help anybody on the list can give. I am not getting any javascript error messages it is just ignoring the fields that are left blank when they are required to have a value. In the example below the first two fields form.dltitle is a text input field and form.dlsummary is a text area field The form.area and form.dlos are select boxes, and these are the major problem how can these be validated so that the user must select an option from the list ?? This is the javascript SCRIPT LANGUAGE=JavaScript !-- Begin function checkFields() { missinginfo = ; if (document.form.dltitle.value == ) { missinginfo += \n - Title of the File Uploaded; } if (document.form.dlsummary.value == ) { missinginfo += \n - Descriptive Summary of Uploaded File; } if(document.form.area.value == 1){ missinginfo += \n - Please select option for Sel1; } if(document.form.dlos.value == 1){ missinginfo += \n - Please select option for Sel2; } if (missinginfo != ) { missinginfo =_\n + You failed to correctly fill in the:\n + missinginfo + \n_ + \nPlease re-enter the required details and submit again!; alert(missinginfo); return false; } else return true; } // End -- /script form action=dltestaction.cfm ENCTYPE=multipart/form-data method=post name=form id=Form onSubmit=return checkFields(); input name=dltitle class=mini size=40 onkeydown=onKeyDown=textCounter(this.form.dltitle,this.form.remLen,35); onKeyUp=textCounter(this.form.dltitle,this.form.remLen,35); MESSAGE=You must enter a shortened headline for this story to be displayed on the homepage REQUIRED=YESnbsp input readonly type=text name=remLen size=3 class=mini maxlength=3 value=35 font class=modtxtspan id=prev_texto_2characters left/span textarea name=dlsummary class=mini wrap=PHYSICAL rows=4 cols=50 onkeydown=onKeyDown=textCounter(this.form.dlsummary,this.form.remLen1,200); onKeyUp=textCounter(this.form.dlsummary,this.form.remLen1,200); required=YES message=You need to fill in the Comments field/textareanbsp input readonly class=mini type=text name=remLen1 size=3 maxlength=3 value=200 font class=modtxtspan id=prev_texto_2characters left/span /font select size=1 style=font-size: 7.0pt; width: 183px; height: 20px; option selectedSelect File Description ---gt;/option optionPrinter Drivers/option optionSoftware Drivers / Patches/option optionInternet Utilities / Tools/option optionSoftware/option optionDocument Viewers/option optionConfig Viewers/option /select select size=1 name=dlos style=font-size: 7.0pt; width: 183px; height: 20px; option selectedWhat Operating System -/option optionWindows 95/option optionWindows 98+/option optionWindows NT/option optionWindows 2000/option optionUnix/option optionLinux/option optionNot Applicable/option /select input type=submit name=submit value=Submit Form! /form __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Javascript Validation for Form Selects in CF ?
Ian, You have a couple of extra left curly braces after the check on dlos and area -- missinginfo += \n - Please select an operating system; } --- Remove this missinginfo += \n - Please select the required area; } --- and this one too. Tim P. - Original Message - From: Ian Vaughan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 9:06 AM Subject: Re: Javascript Validation for Form Selects in CF ? Changed the code to and added a name one of the form fields but a javascript syntx error is occuring? what could cause this in the code below?? SCRIPT LANGUAGE=JavaScript !-- Begin function checkFields() { missinginfo = ; if (document.form.dltitle.value == ) { missinginfo += \n - Title of the File Uploaded; } if (document.form.dlsummary.value == ) { missinginfo += \n - Descriptive Summary of Uploaded File; } if (document.form.dlos.selectedIndex == 0 || document.form.dlos.selectedIndex == 1) missinginfo += \n - Please select an operating system; } if (document.form.area.selectedIndex == 0 || document.form.area.selectedIndex == 1) missinginfo += \n - Please select the required area; } if (missinginfo != ) { missinginfo =_\n + You failed to correctly fill in the:\n + missinginfo + \n_ + \nPlease re-enter the required details and submit again!; alert(missinginfo); return false; } else return true; } // End -- - Original Message - From: Tim Painter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 11:53 AM Subject: Re: Javascript Validation for Form Selects in CF ? To check the selected value of a select, use if (document.form.dlos[document.form.dlos.selectedIndex].value == '') etc. also, your file description select doesn't have a name. HTH, Tim P. - Original Message - From: Ian Vaughan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 6:14 AM Subject: Javascript Validation for Form Selects in CF ? Hi I am trying to add javascipt validation to my form fields before the data is submitted to the database via coldfusion, however it is not working correctly and would appreciate any help anybody on the list can give. I am not getting any javascript error messages it is just ignoring the fields that are left blank when they are required to have a value. In the example below the first two fields form.dltitle is a text input field and form.dlsummary is a text area field The form.area and form.dlos are select boxes, and these are the major problem how can these be validated so that the user must select an option from the list ?? This is the javascript SCRIPT LANGUAGE=JavaScript !-- Begin function checkFields() { missinginfo = ; if (document.form.dltitle.value == ) { missinginfo += \n - Title of the File Uploaded; } if (document.form.dlsummary.value == ) { missinginfo += \n - Descriptive Summary of Uploaded File; } if(document.form.area.value == 1){ missinginfo += \n - Please select option for Sel1; } if(document.form.dlos.value == 1){ missinginfo += \n - Please select option for Sel2; } if (missinginfo != ) { missinginfo =_\n + You failed to correctly fill in the:\n + missinginfo + \n_ + \nPlease re-enter the required details and submit again!; alert(missinginfo); return false; } else return true; } // End -- /script form action=dltestaction.cfm ENCTYPE=multipart/form-data method=post name=form id=Form onSubmit=return checkFields(); input name=dltitle class=mini size=40 onkeydown=onKeyDown=textCounter(this.form.dltitle,this.form.remLen,35); onKeyUp=textCounter(this.form.dltitle,this.form.remLen,35); MESSAGE=You must enter a shortened headline for this story to be displayed on the homepage REQUIRED=YESnbsp input readonly type=text name=remLen size=3 class=mini maxlength=3 value=35 font class=modtxtspan id=prev_texto_2characters left/span textarea name=dlsummary class=mini wrap=PHYSICAL rows=4 cols=50 onkeydown=onKeyDown=textCounter(this.form.dlsummary,this.form.remLen1,200); onKeyUp=textCounter(this.form.dlsummary,this.form.remLen1,200); required=YES message=You need to fill in the Comments field/textareanbsp input readonly class=mini type=text name=remLen1 size=3 maxlength=3 value=200 font class=modtxtspan id=prev_texto_2characters left/span /font select size=1 style=font-size: 7.0pt; width: 183px; height: 20px; option selectedSelect File Description ---gt;/option optionPrinter Drivers/option optionSoftware Drivers / Patches/option optionInternet Utilities / Tools/option
Re: Rock Band needs a Codie
Also NAME is a reserved word in access -- you may need to rename that field to giglistname or when you do a select on it wrap it in [ ] Tim P. - Original Message - From: Michael Pool [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 4:20 PM Subject: Rock Band needs a Codie OK I give up. I know when I am beat. This is a simple one. I know this but I just can't get it to work for some reason. I saw something similar in an old post, but it was not informative enough. Here's the deal: I have 2 tables in a Rock Band's database. (annie.mdb) GIGLIST and GIGDATES I have a template page that I want to show TONIGHT'S SHOW data if there is a show tonight and IF NOT, then the NEXT SHOW date data. as I am sure you can tell by the extension, this is an ACCESS Database, I have the GIGDATE field set to a date field. (MM/DD/) Fields are as follows: GIGLISTTablename ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE GIGDATESTablename ID, GIGNAME, GIGDATE, GIGTIME (GIGNAME = giglist.name) So, let me reitterate I want to show all of the current variables for the show record that has tonight's date (if there is a show tonight) and set a variable NEXTSHOWTIME to either display the text Tonight's Show or set to Next Show if no show tonight and then show the next available showdate's recordset from the GIGDATES table and the corresponding venue location info from the GIGLIST table. GIGNAME=NAME in the GIGLIST table FREE MUSIC CD to the first one who sends me code that makes this thing work! Thanks! M. Pool [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: checkbox -- insert to database problem
Try scoping the variable in your cfparam: CFPARAM NAME = form.displayA DEFAULT = No tim P. -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 6:15 PM To: CF-Talk Subject: checkbox -- insert to database problem I'm having problems with checkboxes. I can't find what I'm doing wrong. I've read and reread my sources. I think I understand what to do -- but it still isn't working. PROBLEM: The checkboxes works when they are selected but don't when not. I understand that unselected checkboxes do not pass a value. I thought that CFPARAM would solve the problem. No!!! ERROR MSG below: . Error resolving parameter BFORM.DISPLAYA/BPPThe specified form field cannot be found... CODE: My user-fills-out-form-page.cfm is cfform name=eventsCalendar method=post action=submitEvent.cfm snip/snip input type=checkbox name=displayA value=Yes input type=checkbox name=displayB value=Yes input type=checkbox name=displayC value=Yes snip/snip /cfform My processing-page.cfm has CFPARAM NAME = displayA DEFAULT = No CFPARAM NAME = displayB DEFAULT = No CFPARAM NAME = displayC DEFAULT = No cfquery name=displayEvents datasource=eventsCalendar INSERT INTO displayEvents (displayA, displayB, displayC) VALUES ('#form.displayA#','#form.displayB#','#form.displayC#') /cfquery I must be missing something very simple. thanks for any clues. gilbert midonnet __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Stupid SQL Problem (in oracle)
You can use decode for that: Select count(decode(myfield,'Running',1,null)) as cnt_Running, count(decode(myfield,'Offline',1,null)) as cnt_Offline, count(decode(myfield,'Unknown',1,null)) as cnt_Unknown count(myfield) as total_Count (where myfield is the field that returns the Running, Offline or Unknown text) HTH, Tim P. - Original Message - From: Edwards Robert (air0rae) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 3:17 PM Subject: OT: Stupid SQL Problem (in oracle) I need some way to convert a word into a number. I know I've done it once before, but I can't remember what I did. For example, I have a query that will return something like the following: Machine1 Running Machine2Running Machine3Offline Machine4Running Machine5Offline Machine6Unknown I want to get some result like this: Running OfflineUnknownTotal 3 2 1 6 I know it has something to do with a sum and translating Running into 1, Offline into a 1 and Unknown into a 1, I just can't remember how I did it. This is an oracle 8i system I'm working with. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax: (502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Using IFRAMES ???
Ian, This cold be the z-order of the iframe, but some form elements (such as select) will always appear above the div, and the only workaround I found was to hide the form in its own div, like you discovered. This link may help: http://www.webreference.com/dhtml/diner/seethru/ - Original Message - From: Ian Vaughan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 09, 2002 5:13 AM Subject: OT : Using IFRAMES ??? I am using an IFRAME to display a news ticker, and the ticker works well, however I am having a problem with the overlay of some elements on the page, When an hiermenu drops down over the ticker the menu drops behind the ticker instead of above? Anybody have any ideas on how I can change the properties so the menus overlays the news ticker as it should? This is not a problem in IE 5.5 and above, it only occurs in earlier versions of the browser. The only workaround that I'm aware of is to hide the IFRAME like so: if (document.all !window.createPopup) document.all.myIFrame.style.visibility = hidden; That should hide the frame in IE4 and 5, but not 5.5. If IE4 compatability isn't an issue for you, use document.getElementById instead of document.all but have had little luck with this?, is there any other approach apart from IFrame to achieve the above such as DIV ?? The IFRAME I am using is iframe height=11 marginwidth=0 width=357 scrolling=no src=http://intranet.neath-porttalbot.gov.uk/scripts/ticker.252.stm; frameborder=0 marginheight=0/iframe Where would I specify what you suggest in the IFRAME i am using? I would appreciate your help Ian __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Variable Precedence
Jim, If you do not specify the scope of the variable, according to the docs, CF will search for it in this order: 1.. Local variables created using cfset and cfquery 2.. CGI 3.. File 4.. URL 5.. Form 6.. Cookie 7.. Client Supposedly, scoping your variables will improve speed as well, but I am not sure how much. I scope my variables anyway, just so I know where they are coming from. HTH, Tim P. - Original Message - From: Jim Taylor [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 06, 2002 2:47 PM Subject: Variable Precedence Is there a Precedence in the order Variable assignment. IE If for some reason you have variables named the same which one has Precedence. If So does any one have a list of the Variable Precedence. Thx Jim __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFDirectory Question
FileExists(): cfif FileExists(images/#sku#.gif) img src=images/#sku#.gif cfelseif FileExists(images/#sku#.jpg) img src=images/#sku#.gif /cfif Though I'd prefer Tonys method, so you don't have to do a lot of file checking. We use it a lot on a app here and haven't run into any performance problems, but a database solution would or course, be better. Tim P. - Original Message - From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 09, 2002 9:10 AM Subject: CFDirectory Question I have a shopping cart that I have created and the images can be either gif or jpg. Since I am dynamically pulling from the images folder, how can I check to see which image exists for a particular item. I am currently doing this: img src=images/#sku#.gif I need to be able to see if #sku#.gif exists or #sku#.jpg and then display the proper image. Any help would be greatly appreciated. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle and CF5
Stephenie, Oracle doesn't make anything real easy. There is no executable, what you need is the Oracle Universal Installer. If you have the Oracle Client installed, there should be a menu item called Oracle Installation Products. Click on the Universal Installer, and click Next... Then on the next screen for Source, click browse and find the products.jar file -- this should have been extraced from your driver download (in a Disk1\Stage\ directory in the location where you extracted the files) If you don't have that, then you would need to grab hold of an oracle product that has the installer on it -- the client is the best bet. There is a product for download on the Oracle site called Oracle Rdb ODBC Drivers that has the Installer included with the download -- these are not the drivers you need, most likely, but you it may be a quicker way to grab hold of the installer . HTH, Tim P. - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 5:36 PM Subject: RE: Oracle and CF5 Thanks, but did you have any troubles installing the drivers? I extracted them on the cf server, and read the readme.txt, it states that upon extraction of the zip file there will be an executable, which did not happen.. This is driver vs. 8.1.7.7 ~~ Stephenie |-Original Message- |From: Tim Painter [mailto:[EMAIL PROTECTED]] |Sent: Wednesday, September 04, 2002 5:10 PM |To: CF-Talk |Subject: Re: Oracle and CF5 | | |I've had a lot better luck using the Oracle ODBC driver |instead of the ms driver -- you'd have to download that |from oracle | |Tim P. | |- Original Message - |From: Stephenie Hamilton [EMAIL PROTECTED] |To: CF-Talk [EMAIL PROTECTED] |Sent: Wednesday, September 04, 2002 5:03 PM |Subject: Oracle and CF5 | | | I have a client who is running a dedicated CF5 server and |a dedicated | Oracle server. We can't get CF to talk to oracle. The |dsn's we setup | in the ODBC control panel verify, but not through CF and |CF tells me | ODBC Error Code = IM003 (Specified driver could not be loaded) | | | Specified driver could not be loaded due to system error |126 (MERANT | 3.70 ColdFusion OEM 32-BIT Oracle8). | | Neither the DSN with the merant driver nor the dsn with |the ms oracle | driver will verify through CF administrator... | | Anyone know anything about this? This is my first time |dealing with | oracle and it is driving me crazy! | | Oh yeah, this is a Win2k server | | ~~ | Stephenie | | | | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle and CF5
Honestly, I don't see much of a difference between using odbc and native , but the apps I am using with it have pretty small usage. If that is the only consideration for spending the extra money on enterprise, I'd probably stick with Pro. Others here may have some more real world experience that may dictate otherwise. HTH, Tim P. - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 10:08 AM Subject: RE: Oracle and CF5 Thanks! Ok, I have it installed, now lets see if I can get this to work! One thing I have been wondering, This is CF5 Pro.which does not have the native driver support...should I have the client upgrade to CF5 Enterprise, which does? ~~ __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfexecute problem
- Original Message - From: Web Master [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 9:17 PM Subject: Re: cfexecute problem I tried specifying the full path everywhere and I tried the cmd.exe option, still nothing. It may be a permissions issue. What sort of permissions does the cfexecute tag need? This is the first time I've ever tried to use cfexecute, but several of the other tags (like CFFILE) are working properly on this server. Thanks, Mike CFExecute will work in the context of the user account that the CF Service is running under. More likely the SYSTEM account, if you haven't configured CF to run under a particular account. Which could be an idea -- try configuring a particular account and have CF run under that account. HTH, Tim P. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Suppress OnRequestEnd.cfm output
I'd use the cgi.script_name variable and test for that to suppress it: e.g cfif cgi.script_name neq iframe_template.cfm Show output /cfif HTH, Tim P. p.s -- tell my father-in-law (Ron B) I said hello :) - Original Message - From: Yexley Robert D Contr Det 1 AFRL/WSI [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 2:59 PM Subject: Suppress OnRequestEnd.cfm output I have an OnRequestEnd.cfm file that I use for my application, and I find it to be very useful, but I have a few documents that are used for the contents of iframes on which I would like to be able to explicitly suppress the output of the OnRequestEnd.cfm file. Is there any way to do this at the document level? I've searched the archives, and haven't found much pertaining to this. Does anyone have any ideas? Thanks in advance. ::YEX:: ))) /* || Robert D. Yexley || Oracle Programmer/Analyst || Northrop Grumman IT || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle and CF5
I've had a lot better luck using the Oracle ODBC driver instead of the ms driver -- you'd have to download that from oracle Tim P. - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 5:03 PM Subject: Oracle and CF5 I have a client who is running a dedicated CF5 server and a dedicated Oracle server. We can't get CF to talk to oracle. The dsn's we setup in the ODBC control panel verify, but not through CF and CF tells me ODBC Error Code = IM003 (Specified driver could not be loaded) Specified driver could not be loaded due to system error 126 (MERANT 3.70 ColdFusion OEM 32-BIT Oracle8). Neither the DSN with the merant driver nor the dsn with the ms oracle driver will verify through CF administrator... Anyone know anything about this? This is my first time dealing with oracle and it is driving me crazy! Oh yeah, this is a Win2k server ~~ Stephenie __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS/CF5 Help: Server Application Error
Sounds like exactly the same thing that happened to me a few weeks ago. The problem was in IIS, the application protection settings in the properties for the directory was set to Medium -- we switched that to Low (IIS Process) and it worked fine after that. HTH, Tim P. -Original Message- From: Jon Block [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 25, 2002 2:10 AM To: CF-Talk Subject: IIS/CF5 Help: Server Application Error See if you can figure this one out: Had some trouble with a harddrive in my raid 5 configuration. I replaced it, but then had to do an emergency repair on Windows 2000 for some reason. I did that, and my system came up. IIS works with static html files, but IIS does not work with ColdFusion (v5). When I request a .cfm page, I get a Server Application Error and I can not figure out why the heck this is happening. I've tested CF with apache just to make sure CF is working, and it was sucessfull. Anybody have any suggestions?? It was working yesterday. grr. Thanks, Jon __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Variable names in CFMX
This is how Java handles it, so personally, I think it is neither a bug nor a feature, just we have to work with the way it is handled on the new platform. However, ISTR that Macr is going to address this in the next release. In the previous conversation, it was recommened to use Compare() or CompareNoCase() to get the desired result: cfif Compare(var1,var2) neq 0not equal/cfif Tim P. -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 25, 2002 1:31 AM To: CF-Talk Subject: RE: Variable names in CFMX Sorry, I didn't saw it. It's a bug or a feature? :o) I found it when dealing with dynamic variables name such as 1a,1b,1c,1d,2a,2b,2c,3d and so forth. I think this is a very common thing isn't? []'s Alex -- Mensagem original --- De : Christopher Olive [EMAIL PROTECTED] Para: CF-Talk [EMAIL PROTECTED] Cc : Data: Sun, 25 Aug 2002 01:26:47 -0400 Assunto : RE: Variable names in CFMX i believe that this came up in a previous thread. as a reprise, the D denotes decimal notation, and as such, is equal to 55 (in which th e decimal (as opposed to hex/octal) notation) is the default. -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 25, 2002 1:00 AM To: CF-Talk Subject: Re: Variable names in CFMX Hi folks, this is little bit offtopic but it's very weird: CFSET var1=55 CFSET var2=55D CFIF var1 EQ var2Equal!CFELSEDifferent/CFIF The CFMX outputs Equal... Does anybody have a clue about what migh t it be? This is syntax problem when converting it to Java? I didn't see any mention to that in the CFMX docs. By the way: CFMX still typeless? And what about when the CFMX code is converted to Java code? How the JIT decides which data type a variable has? Abraços! Alex -- Mensagem original --- De : Jim McAtee [EMAIL PROTECTED] Para: CF-Talk [EMAIL PROTECTED] Cc : Data: Sat, 24 Aug 2002 21:25:48 -0600 Assunto : Re: Variable names in CFMX Funny you should mention that. About a month ago I was trying to de vise a naming convention for CF variables used as constants in a particul ar application. I don't bother using variable prefixes in my applica ti ons, but was hoping to use a leading underscore to denote a constant. Of c ourse, in CF5 it was invalid. Jim - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, August 24, 2002 9:08 PM Subject: Re: Variable names in CFMX I agree that there's no meaning for them and it'll be even more co nfusing to people coming from other languages such as perl. Personally, I' m never going to use them. Even in another arcane naming convention. g On Saturday, August 24, 2002, at 07:22 , Michael Dinowitz wrot e: CFSET _new=1 CFSET $new=2 CFOUTPUT#_new# #$new#/CFOUTPUT Maybe it's in preparation for the VAX port? ;) I can think of no value whatsoever for allowing either of thes e. They do not contribute to readability and there's every chance that so me bright spark will come along and 'invent' some cryptic meaning for th em in yet another arcane naming convention :( __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Problem with \ in a Javascript/Query
Javascript will see the \ as an escape sequence -- if you double up the \, then it should retain it: A simple replace should do it: cfset tmpFile = \\somemachine\somedir\some.exe cfset tmpFile = Replace( tmpFile,\,\\,all) - Original Message - From: Edwards Robert (air0rae) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 22, 2002 9:28 AM Subject: Problem with \ in a Javascript/Query I have a page that populates a combo box via javascript. The data that is returned from a query is (quotes included) \\somemachine\somedir\some.exe. The Javascript sets the value via the code new Option('\\somemachine\somedir\some.exe','\\somemachine\somedir\some.exe' ) (that's the double quotes within single quotes if it's not too clear). The problem is, it translates out to \somemachine omedirsome.exe (the somedirectory begins with a t, so I'm thinking that it's translating it to a tab character). When I pass the selection to another page, it passes the tab and the formatting as translated, what I need is for the slashes and characters to be passed as that are in the DB. Is there anything I can do with regex or something to keep the slashes the way they are? Kind of like PreserveSingleQuotes. TIA, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax: (502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: More on building a site tracker
Thane, I don't believe that you will be able to run the javascript from the test2.cfm, probably a security issue. Also, you have your cfquery on the test2.cfm wrapped in a comment, so it won't be run - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 21, 2002 1:25 PM Subject: More on building a site tracker After a fair bit of reading and a lot of hair pulling, I have three files like this: Index.htm looks like this: html body Test page. script language=Javascript src=http://www.stuffbythane.com/SiteTracker/UpdatePageInfo.js;/script /body /html UpdatePageInfo.js looks like this: function Get_Referrer() { document.write(img src='http://www.stuffbythane.com/SiteTracker/test2.cfm?in=; + document.referrer + out= + document.location + '); document.write(/); document.write(script); alert(Get Referrer Running.); } Get_Referrer(); Test2.cfm looks like this: !--- CFQUERY name=test datasource=SiteTracker INSERT INTO Test(In, Out) VALUES ('#URL.In#', '#URL.Out#') /CFQUERY --- script language=javascript alert(Test2 running.); /script cfcontent type=image/GIF file=test.gif So far as I can tell, test2.cfm doesn't get called. Or if it does, it doesn't run. The Get Referrer Running alert appears, and the gif placeholder appears (with the proper properties) but no gif appears, and the Test2 Running alert doesn't come up, and nothing goes into the database. What am I doing wrong? T __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reading a text file
You might be able to use GetProfileString for that: cfset myvar = GetProfileString(c:\myinifile.ini,section,entry) -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 4:06 PM To: CF-Talk Subject: Reading a text file Anybody have a snippet of code that will read and parse the contents of a text file? An .ini file, perhaps, with key=value pairs on each line. Thanks. -- Al Everett Allied Office Supplies www.askallied.com mailto:[EMAIL PROTECTED] v: 973-594-3209 f: 973-594-3626 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Building a sitetracker
Just a thought -- why bother with using javascript and and iframe? stick the call to test.cfm in the application.cfm file and it should already be there. I am not sure what browsers you are targeting, but you could have a problem with old netscape browsers that don't support iframe. Tim P. - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 9:39 AM Subject: Building a sitetracker Still working on this sitetracker project, and I've gotten a bit further. I put the following code in the page to be tracked: iframe src=http://www.stuffbythane.com/sitetracker/test.cfm; width=220 height=100 And the test.cfm page looks like this: CFOUTPUT CFSET Page=CGI.path_info CFIF CGI.http_referer EQ CFSET ReferringPage=None CFELSE CFSET ReferringPage=CGI.http_referer /CFIF font size=-1 Page: #Page#BR Referrer: #ReferringPage#BR Referrer: #Form.referrer#BR IP Address: #CGI.Remote_addr#BR Host: #CGI.Remote_host#BR Sever: #CGI.server_name#BR Browser: #CGI.http_user_agent#BR/font/font /CFOUTPUT Of course, ReferringPage shows the page the iframe code is inserted into. I assume I could insert some javascript into the page I'm tracking that will pass document.referrer as a form variable, but I can't figure out how to do that. How would I pass the referring page information to the tracking page? T __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Building a sitetracker
That makes sense. Instead of an iframe, could you use an img tag instead, so that you would be compatible with other browsers, There is a great article here on using a gif as a data pipe: http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Essays/GIFAsPipe/ HTH, Tim P. - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 9:39 AM Subject: Building a sitetracker Still working on this sitetracker project, and I've gotten a bit further. I put the following code in the page to be tracked: iframe src=http://www.stuffbythane.com/sitetracker/test.cfm; width=220 height=100 And the test.cfm page looks like this: CFOUTPUT CFSET Page=CGI.path_info CFIF CGI.http_referer EQ CFSET ReferringPage=None CFELSE CFSET ReferringPage=CGI.http_referer /CFIF font size=-1 Page: #Page#BR Referrer: #ReferringPage#BR Referrer: #Form.referrer#BR IP Address: #CGI.Remote_addr#BR Host: #CGI.Remote_host#BR Sever: #CGI.server_name#BR Browser: #CGI.http_user_agent#BR/font/font /CFOUTPUT Of course, ReferringPage shows the page the iframe code is inserted into. I assume I could insert some javascript into the page I'm tracking that will pass document.referrer as a form variable, but I can't figure out how to do that. How would I pass the referring page information to the tracking page? T __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Re[2]: Someone must know about this...
I've been meaning to respond to the original post -- I had a similar problem on my XP Box. I originally installed a beta version of CFMX on my machine and I had installed it, but I neglected to delete the c:\Neo directory. Once I removed it and reinstalled everything is working fine now. HTH, Tim P. - Original Message - From: Critter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 19, 2002 12:03 PM Subject: Re[2]: Someone must know about this... oi Lee!! I was getting the same type of errors on my box..however when I tried to restart IIS, it would error out, all I could do was restart the box.. now -mx +5.0 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: limit cfoutput
If I may throw out another suggestion -- have your database do the work for you, so you are returning less data to the server -- might make the query run a little faster as well. Most db's have the same sort of Left() function as well. Select HTH, TimP -Original Message- From: Corey Yiap [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 17, 2002 11:23 PM To: CF-Talk Subject: limit cfoutput Does anyone know a way to limit the length of the output from cfoutput tag? I have a data field from db that is that set to MEMO, obviously it's more then 255 char. but I would like to only display the first 255 char. and add a read more... link to redirect it to a more descript page. thanks corey __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ANY Major Company using Cold Fusion
I can't believe I forgot this -- AutoTrader.com (the company I work for!) is using it internally and owns www.wwwheels.com which is using it for all the dealers there. Tim P. - Original Message - From: Weaver, Anthony [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 16, 2002 8:35 AM Subject: RE: ANY Major Company using Cold Fusion Limited Brands is a big Cold Fusion shop internally. Tony Weaver Limited Brands Technology Services Advanced Technology Group Senior Programmer/Analyst Phone: 614.415.7647 E-mail: [EMAIL PROTECTED] AURA SCIENCE / BATH BODY WORKS / EXPRESS / HENRI BENDEL / THE LIMITED NEW YORK COMPANY / VICTORIA'S SECRET / THE WHITE BARN CANDLE COMPANY -Original Message- From: Corrine Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:16 PM To: CF-Talk Subject: ANY Major Company using Cold Fusion I need some major companies that are using cold fusion. If you know of some please let me know. Thank you, Corrine Clark __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Microsoft Web Site Running Cold Fusion
Not really a Microsoft site, but www.win2000mag.com is Tim P. - Original Message - From: Corrine Clark [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 2:34 PM Subject: Microsoft Web Site Running Cold Fusion I am looking for a major Microsoft site that may be running Cold Fusion. Anyone know of one? Corrine Clark FSC __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ANY Major Company using Cold Fusion
Corrine, Some time ago, bCentral.com was a cf site and was consumed by msft -- I no longer see it on the site. Maybe that is what you were thinking of? Tim P. -Original Message- From: Corrine Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:55 PM To: CF-Talk Subject: RE: ANY Major Company using Cold Fusion Yes, and I had heard a rumor that Microsoft had bought a coldfusion site and not converted it. Must have been the winmag2000 site I guess. -Original Message- From: Shawn Kernes [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 4:42 PM To: CF-Talk Subject: RE: ANY Major Company using Cold Fusion why the question about Microsoft then? is the other option on the table ASP? -Original Message- From: Corrine Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 2:38 PM To: CF-Talk Subject: RE: ANY Major Company using Cold Fusion Yes that is what I am doing. Thank you for the information. -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 4:45 PM To: CF-Talk Subject: RE: ANY Major Company using Cold Fusion Corrine, it sounds like your trying to convince someone to use ColdFusion. You might want to check out http://www.cffaq.com/ for some ammo. _ Pete Freitag CTO, CFDEV.COM http://www.cfdev.com/ -Original Message- From: Corrine Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 5:16 PM To: CF-Talk Subject: ANY Major Company using Cold Fusion I need some major companies that are using cold fusion. If you know of some please let me know. Thank you, Corrine Clark __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfinvoke vs cfhttp
Folks, I've been helping a client get a proper response back from a webservice written in vb.net and because of the way the service was written, a particular method will not work using cfinvoke. It is supposed to return an xml document, but for some reason CFMX cannot handle it. As a workaround the service will also handle a http get or post, so I've used cfhttp to use the same service and get the xml that way. My client says it work temporarily, but is not stable enough to go live. I am not sure why... So my question to all of you is there any truth to this? Why would running a cfinvoke be any more stable than a cfhttp call? It seems to be that basically it is soft of doing the same thing behind the scenes.. My guess is that he has a sense that cfhttp is unreliable due to a lot of the problems it had back in the 4.x days. Thoughts? Thanks! Tim P. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfinvoke vs cfhttp
Thanks -- that's what I thought too. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 3:11 PM To: CF-Talk Subject: RE: cfinvoke vs cfhttp Unless I'm crazy, web services were meant to be (or are mainly) called by HTTP requests - so I don't know why the use of cfhttp would be cause for alarm. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Tim Painter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 3:04 PM To: CF-Talk Subject: cfinvoke vs cfhttp Folks, I've been helping a client get a proper response back from a webservice written in vb.net and because of the way the service was written, a particular method will not work using cfinvoke. It is supposed to return an xml document, but for some reason CFMX cannot handle it. As a workaround the service will also handle a http get or post, so I've used cfhttp to use the same service and get the xml that way. My client says it work temporarily, but is not stable enough to go live. I am not sure why... So my question to all of you is there any truth to this? Why would running a cfinvoke be any more stable than a cfhttp call? It seems to be that basically it is soft of doing the same thing behind the scenes.. My guess is that he has a sense that cfhttp is unreliable due to a lot of the problems it had back in the 4.x days. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfinvoke vs cfhttp
Well, I know for a fact that this service is called via http, but does that make cfinvoke inherently superior to using cfhttp? Tim P. -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 6:06 PM To: CF-Talk Subject: RE: cfinvoke vs cfhttp That is actually a common misconception. Web services can be implemented using a variety of protocols whether they be lower level like TCP or UDP, or higher level like HTTP or SMTP; they could even be binary marshalling protocols like RMI or JMS. Further, Web services can make use of a variety of wrappers from SOAP to XML-RPC or even WDDX and MRNXMP (Matt's Really Neat XML Marshalling Protocol). Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 12:11 PM To: CF-Talk Subject: RE: cfinvoke vs cfhttp Unless I'm crazy, web services were meant to be (or are mainly) called by HTTP requests - so I don't know why the use of cfhttp would be cause for alarm. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Tim Painter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 3:04 PM To: CF-Talk Subject: cfinvoke vs cfhttp Folks, I've been helping a client get a proper response back from a webservice written in vb.net and because of the way the service was written, a particular method will not work using cfinvoke. It is supposed to return an xml document, but for some reason CFMX cannot handle it. As a workaround the service will also handle a http get or post, so I've used cfhttp to use the same service and get the xml that way. My client says it work temporarily, but is not stable enough to go live. I am not sure why... So my question to all of you is there any truth to this? Why would running a cfinvoke be any more stable than a cfhttp call? It seems to be that basically it is soft of doing the same thing behind the scenes.. My guess is that he has a sense that cfhttp is unreliable due to a lot of the problems it had back in the 4.x days. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: javascript addition
You might try adding a ParseInt() function around the value as well: e.g. ParseInt(document.newBillingInfo.SCEPbilledAmount.value) + ParseInt(document.newBillingInfo.SCEPpenaltyAmount.value) etc... Tim P. - Original Message - From: Tim Do [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 23, 2002 12:35 PM Subject: javascript addition Hello, Can anybody show me how you would I would validate the sum of several text boxes? This is what I'm trying to use but not having luck.. thanks in advance. function validate() { if (document.newBillingInfo.SCEPbilledAmount.value + document.newBillingInfo.SCEPpenaltyAmount.value + document.newBillingInfo.SCEPdelinquentAmount.value != document.newBillingInfo.SCEPtotalAmount.value) { alert(The total Billing amount does not add up correctly, Please check the values.) document.newBillingInfo.SCEPbilledAmount.focus() return false; } return true; } __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX Pro and Oracle?
When you make the odbc connection, are you using the microsoft or Oracle driver? I'm using the Oracle driver here and have not had a problem with it. HTH, Tim P. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 1:01 PM To: CF-Talk Subject: CFMX Pro and Oracle? I'm trying to connect to an Oracle 9i db using CFMX Professional and a Windows ODBC socket connection. Is this possible or does it only work in Enterprise? I can make the Windows odbc connection, but CFMX is throwing errors trying to validate the datasource. I get this errmsg. Username, password, domain etc. are good. Connection verification failed for data source: OTEST []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX Pro and Oracle?
I'm not an expert either and I am using 8i -- I have a Microsoft ODBC for Oracle driver and an Oracle in OracleHomeDir I am using the latter. I know my version is the latest one for 8i, but that is about it. Wish I could help more... tim P. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 3:38 PM To: CF-Talk Subject: RE: CFMX Pro and Oracle? I'm going in thru the Windows ODBC control panel and using the Oracle driver that appeared there after I installed Oracle 9i. Is there some other way to do this? Another driver to d/l? I'm a complete Oracle newbie. --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: Tim Painter [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 17 Jul 2002 14:58:20 -0400 When you make the odbc connection, are you using the microsoft or Oracle driver? I'm using the Oracle driver here and have not had a problem with it. HTH, Tim P. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 1:01 PM To: CF-Talk Subject: CFMX Pro and Oracle? I'm trying to connect to an Oracle 9i db using CFMX Professional and a Windows ODBC socket connection. Is this possible or does it only work in Enterprise? I can make the Windows odbc connection, but CFMX is throwing errors trying to validate the datasource. I get this errmsg. Username, password, domain etc. are good. Connection verification failed for data source: OTEST []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Writing efficient CFIF statements
Stephen, I usually like to set things either true or false. (or 1 or 0). The true or false is a little more visual, I think -- so to use your example, I would do it like: cfif myQuery.RecordCount EQ 0 cfset QueryResults = false cfelse cfset QueryResults = true /cfif cfif QueryResults There are records cfelse No records to display /cfif This is reverse of yours (if there are no records, then the variable is false -- your example shows as true) To me it made more sense to have that variable false. Of course, you can bypass the whole cfif and use the myQuery.RecordCount and test whether that is true/false: cfif myQuery.recordcount There are records cfelse No records to display. /cfif - Original Message - From: Adams, Stephen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 5:08 AM Subject: Writing efficient CFIF statements ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I am trying to put more structure into my CF code. My idea is to separate the ColdFusion processing from the HTML structure and use CSS for the look of the site. I am trying to get an idea of what is the best way to separate the CF. I know that I could use custom tags, user defined function and if I was using MX, then components. But these are for code that can across used in multiple pages. What I am talking about is the CF for an individual page. What has all this to do with CFIF statements, well. I was thinking of setting a series of flags that are checked against in my HTML. The CFIF statements are there to check the value of these flags and amend the page depending on these flags. So I want to be able to write good efficient CFIF statements so that my code is up to speed. Here's an example of what I am talking about: !--- Default ColdFusion Parameters --- cfparam name=QueryResults default= type=string !--- ColdFusion Processing --- cfquery name=myQuery datasource=myDSN SELECT * FROMmyTable /cfquery !--- Sets flags --- cfif myQuery.RecordCount EQ 0 cfset QueryResults = 1 /cfif !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head titleUntitled/title /head body cfif QueryResults EQ 1 table cellspacing=2 cellpadding=2 tr td class=mainFontResults found./td /tr /table cfelse table cellspacing=2 cellpadding=2 tr td class=mainFontNo results found./td /tr /table /cfif /body /html This is a simple example, but it shows how I want to keep the processing separate at the top of the page. My question, finally, is how are CFIF statements best written if I want to code this way and or is there a better way of writing my CF code. Thanks. ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Writing efficient CFIF statements
IIF is slower. Couldn't you just do: cfset QueryResults = myQuery.Recordcount If recordcount is 0, it would be false anyway - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 6:36 AM Subject: RE: Writing efficient CFIF statements Looks cleaner, but isn't it slower? -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]] Sent: 16 July 2002 11:31 To: CF-Talk Subject: RE: Writing efficient CFIF statements Any opionions on: CFSET QueryResults = IIF(myQuery.RecordCount EQ 0, DE(False), DE(True)) ? Cheers, Hugo - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone: +46 8 7410451 UNEP GRID-Arendal Fax: +46 733 403285 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Tim Painter [mailto:[EMAIL PROTECTED]] | Sent: Tuesday, July 16, 2002 12:19 | To: CF-Talk | Subject: Re: Writing efficient CFIF statements | | | Stephen, |I usually like to set things either true or false. | (or 1 or 0). The true or false is a little more visual, I | think -- so to use your example, I would do it like: | | cfif myQuery.RecordCount EQ 0 |cfset QueryResults = false | cfelse | cfset QueryResults = true | /cfif | | cfif QueryResults |There are records | cfelse | No records to display | /cfif | | This is reverse of yours (if there are no records, then the | variable is false -- your example shows as true) To me it | made more sense to have that variable false. | | Of course, you can bypass the whole cfif and use the | myQuery.RecordCount and test whether that is true/false: | cfif myQuery.recordcount | There are records | cfelse | No records to display. | /cfif | | | | - Original Message - | From: Adams, Stephen [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Tuesday, July 16, 2002 5:08 AM | Subject: Writing efficient CFIF statements | | | | ** | WESTMINSTER CITY COUNCIL | Please refer to the disclaimer beneath this message | | ** | | Hi, | | I am trying to put more structure into my CF code. My idea | is to separate | the ColdFusion processing from the HTML structure and use | CSS for the look | of the site. I am trying to get an idea of what is the | best way to separate | the CF. I know that I could use custom tags, user defined | function and if I | was using MX, then components. But these are for code that | can across used | in multiple pages. What I am talking about is the CF for | an individual | page. | | What has all this to do with CFIF statements, well. I was | thinking of | setting a series of flags that are checked against in my | HTML. The CFIF | statements are there to check the value of these flags and | amend the page | depending on these flags. So I want to be able to write | good efficient CFIF | statements so that my code is up to speed. | | Here's an example of what I am talking about: | | !--- Default ColdFusion Parameters --- | cfparam name=QueryResults default= type=string | | !--- ColdFusion Processing --- | cfquery name=myQuery datasource=myDSN |SELECT * |FROMmyTable | /cfquery | | !--- Sets flags --- | cfif myQuery.RecordCount EQ 0 |cfset QueryResults = 1 | /cfif | | !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN | | html | head | titleUntitled/title | /head | | body | |cfif QueryResults EQ 1 | table cellspacing=2 cellpadding=2 |tr | td class=mainFontResults found./td |/tr | /table |cfelse | table cellspacing=2 cellpadding=2 |tr | td class=mainFontNo results found./td |/tr | /table |/cfif | /body | /html | | This is a simple example, but it shows how I want to keep | the processing | separate at the top of the page. | | My question, finally, is how are CFIF statements best | written if I want to | code this way and or is there a better way of writing my CF code. | | Thanks. | | | | ** | Westminster City Council switchboard: | +44 20 7641 6000 | | ** | This E-Mail may contain information which is | privileged, confidential and protected from | disclosure. If you
Re: Writing efficient CFIF statements
I just tested it on MX and it works the same. Tim P. - Original Message - From: Stephen Moretti [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 7:05 AM Subject: Re: Writing efficient CFIF statements Looks cleaner, but isn't it slower? Any opionions on: CFSET QueryResults = IIF(myQuery.RecordCount EQ 0, DE(False), DE(True)) IIF is supposed to be a little inefficient, but its like all these things. Its probably take a couple of milliseconds longer, so it really makes no difference. I'm not sure I agree with the looks cleaner comment though. Sure, its on one line, but its not the easiest thing to read. I use IIF a reasonable amount, but given the choice. I'd go with cfscript instead To be honest, in Stephen's simple case, you don't need the logic to set QueryResults to true or false, you can just do this. cfif myQuery.RecordCount !--- Got some records --- cfelse !--- Got no records --- /cfif CF will take anything that is greater than 0 to be TRUE and 0 to be FALSE. (Haven't checked what happens with negative numbers in a while, so couldn't possibly comment) A word of warning about this though You'd be better using myQuery.RecordCount GT 0, as I'm not sure that CFMX will take myQuery.RecordCount as a BOOLEAN when it is greater than 1. Regards Stephen __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfdev
There is a freeware program called Irfanview that lets you save graphics as icon files. I cant seem to get to the site (http://www.ifranview.com) right now but Tucows has it. HTH, Tim P. - Original Message - From: Kodjo Ackah [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 7:40 AM Subject: RE: cfdev John, I've been dying to get this for my site too. Budget constraints means I will have to create my design myself. Please let me know how you intend to proceed with this. I've been there and its cool. Kodjo ackah Principal Consultant concrete-media.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: nuther lockin Q?
I thought that putting a cflocation inside a cflock was a bad thing to do -- doesn't it lock up the server or something? In that case, I'd set a temp variable to the value of the session variable inside the cflock and test that: cflock type=readonly scope=session timeout=10 cfif not len(session.auth.iUserID) cfset tempGO = true cfelse cfset tempGO = false /cflock cfif tempGo cflocation url=../logout.cfm?reason=sessiontimeout addtoken=no /cfif Or am I wrong? Tim P. - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 08, 2002 2:12 PM Subject: Re: nuther lockin Q? oi CF-Talk,!! I've got this on a few pages: cfif not isDefined(Session.Auth.iUserID) or Session.Auth.iUserID eq cflocation url=../logout.cfm?reason=sessiontimeout addtoken=no /cfif would that still qualify for a lock? and if so would I just lock the whole cfif ? Yes and yes... Personally I would try and make sure that your session.auth.iUserID is always defined ( likely using a cfparam in an exclusive session-scope cflock in the application.cfm or fbx_settings.cfm ), so that this then becomes cflock type=readonly scope=session timeout=10 cfif not len(session.auth.iUserID) cflocation url=... /cfif /cflock Though mine may only be one of many opinions... I personally never like to use Isdefined(varname) or varname eq as a logical expression ... it strikes me as being more work than necessary and possibly ( if however unlikely ) less reliable ... If nothing else, you might want to trim the variable before comparing it to ... hth Isaac Dealey www.turnkey.to 954-776-0046 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AOL Problems
Well, I used to run into an issue where if they were on a virtual host and did not have a dedicated IP address, AOL users running old clients may not be able to see the site. This was due to AOL not supporting HTTP 1.1 -- I haven't seen that in a while though. Tim P. - Original Message - From: Kreig Zimmerman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 21, 2002 11:36 AM Subject: Re: AOL Problems - Original Message - From: Eric Homa To: CF-Talk Sent: Thursday, June 20, 2002 12:02 PM Subject: AOL Problems Hi, Does anyone out there have experience with an AOL client? I have a customer whose site works fine for him at his office and also for the many other clients that use the site but when he goes home and uses AOL he complains that pages don't load. He says that he gets blank screens. Anyone experience any of this or know which tags might cause this? Thanks, Eric Homa __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOT : Leading 0's in csv file
I'm building a csv file and the data has a leading 0 in front -- for example: 0123,0456,0789 etc... When I bring it into excel, it shows as 123 , 456 , 789 etc. Is there any way I can output the .csv so that it retains that leading 0 when I bring it into excel? (My gut feeling is no, but I thought that maybe someone else here has run into that before) Thanks! Tim P. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SOT : Leading 0's in csv file
That is what I thought too -- the .csv is fine, just excel. We did try the apostrophe, but they don't like it when it shows up in the file.. What we may do is replace the 0 with the letter O -- Thanks for the help! Tim P. - Original Message - From: Philip Arnold - ASP [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 11:52 AM Subject: RE: SOT : Leading 0's in csv file I'm building a csv file and the data has a leading 0 in front -- for example: 0123,0456,0789 etc... When I bring it into excel, it shows as 123 , 456 , 789 etc. Is there any way I can output the .csv so that it retains that leading 0 when I bring it into excel? (My gut feeling is no, but I thought that maybe someone else here has run into that before) The problem isn't the CSV, but Excel TRYING to be friendly What you've got to do is force Excel into seeing it as text - try putting an apostrophe (') in front of the numbers Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** 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. ** __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WYSIWYG HTML editors (a'la soEditor) for Macs ?
Don't know if this will work, but try http://editize.com/index.php -- they have a java based editor that may fit the bill. Tim P. - Original Message - From: James Sleeman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 11, 2002 9:26 PM Subject: WYSIWYG HTML editors (a'la soEditor) for Macs ? Hi all, we have a client, who despite our best efforts ( :-) ) is steadfastly Macintosh. They won't purchase a PC, they won't even purchase Virtual PC. Now, in many of our administration systems we use soEditor (lite, not that it matters), which works wonderfully under IE on windows, and doesn't on anything else (understandably, it uses IE components). This client really really really wants similar functionality for thier next site, but still refuses to get Virtual PC (soEditor works fine under Virtual PC, or so I hear from other clients). Does any body know of any comparable WYSIWYG editors that will function on a Mac platform (either IE or NS/Moz) ? --- James Sleeman __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFPop Attachment weirdness...
We are using the cfpop tag to do a simple display and I am having trouble showing the number of attachments. There is one particular individual that when they send an attachment, it always shows up as 0 attachments. Funny thing is, if I forward that email to myself, or attach that same attachment, it shows up fine. Would there be something with his email client (Using Outlook Express 5, which is what I was using as well)? Code below: cfpop action=GetAll name=GetMessages server=mail.x. username=xxx password=xxx attachmentpath=d:\somepath\test generateuniquefilenames=yes cfoutput query=GetMessages Getting Msg #MsgNum# of #GetMessages.recordcount# br From: #GetMessages.from# br Subject: #GetMessages.subject# br cfset NumAttachments = ListLen(GetMessages.Attachments) Number of Attachments: #NumAttachments# br br /cfoutput Thanks! Tim P. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Oracle Exporting Table structures
Paul, I am not sure how to do it automatically in Oracle, but have you ever looked at TOAD? This is a great front-end tool for Oracle. You can create scripts to export tables and data in there. There is a freeware version at http://www.toadsoft.com HTH, Tim P. - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 11:43 AM Subject: OT: Oracle Exporting Table structures I have built a number of tables in Oracle and want to export the CREATE Table sql files. I know you can do this in MS SQL and in MySQL (some of the front ends). But where in oracle can you create these types of documents? (or can you?) Thanks Paul Giesenhagen QuillDesign __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTTP 500 Errors
Just a funny aside -- a couple of months ago, we had a heck of a time getting CF to work on a server, and after calls to MM/Allaire, we had to call microsoft support. When we attempted to show the IIS tech support guy the error we were getting (specified module could not be found) , he kept saying -- That's not the error I am seeing -- I see 500 - Internal Server error, etc.. When I told him to turn off the friendly http error messages, he said What's that? and I had to explain it to him and actually show him how to turn it off in IE. sad but true. Tim P. - Original Message - From: John Beynon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 5:00 AM Subject: RE: HTTP 500 Errors Funnily enough my hosted site on intermedia.net did this this morning, restarting the server sorted it out. M$ site is it's usual helpful self: 500 - Internal server error. You see this error message for a wide variety of server-side errors. Your event viewer logs may contain more information about why this error occurs. Additionally, you can disable friendly HTTP error messages to receive a detailed description of the error. For additional information about how to disable friendly HTTP error messages, click the article number below to view the article in the Microsoft Knowledge Base: Q294807 HOWTO: Disable Internet Explorer 5 'Show Friendly HTTP Error Messages' Feature on the Server Side John. From: Marlon Moyer [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 21:55 To: CF-Talk Subject: HTTP 500 Errors Suddenly my site is starting to experience 500 errors for only certain users, and meanwhile other users can log in and out with no problems. There's really not any way of this site being too busy as it's and application for field offices so there's only 1 or 2 users at a time. Any ideas? Marlon __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: hiermenus
I just ran into a similar problem, but with form elements. Don't know if you have seen this, but here is a good link on the behaviour of them: http://www.webreference.com/dhtml/diner/seethru/index.html Tim P. - Original Message - From: phumes1 [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 21, 2002 2:19 PM Subject: hiermenus Hi, I'm using the hiermenus in my application. I have two frames and my top navigation has the dropdown menus. The top frame is only 60 pixels in height but when I move the cursor over the link the popup menu stays within that frame. Is there a way with v4.1.1. to have the dropdown menu overlay the frames? http://www.webreference.com/dhtml/hiermenus/ +--- + Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +--- -+ __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Determine if file is there
FileExists() e.g cfif FileExists(c:\inetpub\wwwroot\somefile.cfm) true cfelse false /cfif - Original Message - From: Nick McClure [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:58 AM Subject: Determine if file is there Is there an easy way, without reading the entire file to determine if a file exsists on the server? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: web hosts
Jennifer, I have a shared host at Crystaltech for over a year now and I have never had a problem with them. I only had to email support once about something and they had responded back within an hour. Whenever any maintenance work or scheduled downtime needs to be done, they inform you with a lot of advance notice. Tim P. - Original Message - From: Jennifer Larkin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 01, 2002 1:45 AM Subject: Re: web hosts At 12:10 AM 5/1/02 -0500, you wrote: CRYSTALTECH... period.. Media3 loads down their servers with many clients ... some people have good luck, but if you get stuck on a system with multiple heavy users, you are out of luck. I have been with crystaltech dedicated servers for over a year and they have been incredible! I don't think it's fair to compare a shared server solution with a dedicated server solution, but I appreciate your comments anyway. Now available in a San Francisco Bay Area near you! http://www.blivit.org/mr_urc/index.cfm http://www.blivit.org/mr_urc/resume.cfm __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Equivalent to cffile under ASP ?
You can use the FileSystem object to do most of it (renaming, creating, etc) Uploading is a different beast. Here is a list of asp upload components: http://www.aspfaq.com/show.asp?id=2189 You might also want to check aspfaq.com for other filesystem faqs as well. Tim P. - Original Message - From: cf-talk [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 22, 2002 1:31 PM Subject: OT: Equivalent to cffile under ASP ? Hi list, almost totally OT. I know. But is there an easy (and cheap) function/tag for MS-ASP (.asp) which covers the cffile-feature ? I have searched quite a while but couldn't find an appropriate one. Uwe __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: using != in a filed with a null value
Couldnt you use Where ContactCNT != 'Do Not Contact' OR ContactCNT is NULL HTH, Tim P. - Original Message - From: Ben Densmore [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 1:06 PM Subject: using != in a filed with a null value Can someone tell me if there is a better way to write a query than using !=? I have a field in my database that stores info on how many times a sales person has contacted a customer or if the customer ordered or if the customer has requested to not be contacted. I am running a query that shows this field but now want to change my query to only display customers that either haven't been contacted or ones that haven't ordrered, so I added in my query Where ContactCNT != 'Do Not Contact' which works, but if there is a null value in my database field the query doesn't grab those either, so if we had 100 people in our database for todays date and none of them had been contacted, so the value in that field is null our system won't show anything at all. Can someone tell me an alternative, if there is one to writing the query this way? Would I be better off setting a default value of 0 in the database field. I'm using SQL Server 7, just in case someone asks. Thanks, Ben __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cffile - probs with spaces in file name
After the file is uploaded, you should be able to use the #cffile.serverFile# variable to get the filename that was saved on the server. Can you use that to delete it? cffile action=delete file=D:\VirtualSites\test_\ccsbt\documents_directory\#cffile.serverFile# HTH, Tim P. -Original Message- From: Seamus Campbell [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 7:25 PM To: CF-Talk Subject: cffile - probs with spaces in file name Hi I'm having a problem with CFFILE that I hope someone may be able to help me with I'm uploading and deleting files. If a file is uploaded with spaces in the file name - it cannot be deleted - gives this error: Unable to delete the file 'D:\Virtual Sites\test_\ccsbt\documents_directory\Copy test.pdf.' The system cannot find the file specified. (error 2) If I put the same file up with no spaces there is no problem. The file name on the server actually puts an underscore in the space Any clues on how to fix this MTIA Seamus __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: preservesinglequotes() for entire query?
Can't you just set the sql for your query as a string and enclose it? e.g cfset sql = Select foo from bar where field1 = 'foo' and field2 = 'bar' cfquery name=blah datasource=blahblah #PreserveSingleQuotes(sql)# /cfquery -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 8:26 PM To: CF-Talk Subject: preservesinglequotes() for entire query? Is there an easy way to stop an entire cfquery from automatically quoting each variable? I would normally use preserveSingleQuotes(), but I have a query where I need to do it for every variable and was wondering if there is an easier way? jon __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: capture close browser event
You can use the OnUnload event in the body tag to run something. body OnUnload = window.open('logout.cfm','logout_href'); - Original Message - From: Mak Wing Lok [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 12, 2002 7:21 AM Subject: capture close browser event is there a way where we can capture the event when a user close a browser? or when the user close a browser the CF application will execute a cf page? for example logout.cfm? i try using the code below : SCRIPT FOR=WINDOW EVENT=ONBEFOREUNLOAD LANGUAGE=JAVASCRIPT window.open('logout.cfm','logout_href') /CFSCRIPT but eventually the code above will be executed whenever a page is refresh or changed, i'm following the tutorial from cfvault.com but it does not really work the way i want, yes, i managed to logout the user when the browser is closed but i logout the user too whenever a page is changed. any help? -- - Pharmaniaga Berhad, your integrated healthcare provider www.pharmaniaga.com.my www.ehealth4all.com, your most convenient way to healthcare, everyday... The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential or privileged material. If you received this in error, please contact the sender and delete the material from any computer. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. -- - __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfgraph in 5.0 ??
What OS are you running it on? It won't run under Win98. - Original Message - From: Paul Ihrig [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 9:18 AM Subject: cfgraph in 5.0 ?? ok, this should be pretty simple but no matter what i do i cant get this silly thing to work. just hangs. is there any thing i need to do? thanks -paul __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-based Weblog?
There is also the cflog tag new in CF 5. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 9:29 AM To: CF-Talk Subject: CF-based Weblog? Anyone out there know of a ColdFusion-based Weblog tool? Portent Interactive Helping clients build customer relationships on the web since 1995 Consulting, design, development, measurement http://www.portentinteractive.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I need printable reports in browser from Oracle (must be an alter native to Crystal#!@?#!!?
I have the exact same problem you do, except my bosses won't allow me to go a different route. (We already spent the money, so we are going to use it.) I was looking at intelliview not too long ago and it looks pretty interesting. The only drawback is that there is a client that needs to be installed. I talked with a sales rep and they had mentioned there was a browser plug-in that was in beta. You may want to give them a look. (They are much cheaper too, by the way) http://www.intelliview.com Good Luck! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 5:11 AM To: CF-Talk Subject: I need printable reports in browser from Oracle (must be an alter native to Crystal#!@?#!!? There must be a good reporting tool out there. At the moment we use Crystal to produce them and it's active-x viewer app to display and print them. But Crystal is a dog, that fs up every server we have installed it on and you have to install on the web server to get the viewer to work, despite the fact that you're not supposed to need to. Plus it's inflexible and limited in terms of the reports it produces. Short of writing reports in CF and using something to turn them into PDF's, what else is there? There must be something? Please tell me there's any easy answer to this. ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Kiosks
Just to chime in here -- You can run internet explorer in kiosk mode. Just run iexplore - k http://myurl; I created a totally web based application that is shown on a 48 monitor using a java servlet. CF would have worked just as well, but I was told to do it java. However, my app does not have a lot of user interaction, so it really depends on what you need to do. HTH, Tim P. -Original Message- From: chris.alvarado [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 6:16 PM To: CF-Talk Subject: Kiosks Currently in development we have an application that will be accessed from some type of Kiosk device. Does anyone out there have any recommendations on any hardware that should be looked at? It would be nice if the client device could browse a web page so that the application could be programmed in CF. any help would be greatly appreciated, -chris.alvarado [application.developer] 4 Guys Interactive, Inc. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFREPORT and Error 500
Crystal Reports professional comes with a 5 user license agreement that will allow up to 5 reports run at a time. I have not used cfreport with Crystal, but I have used ASP and I know with ASP, the licenses can get eaten up pretty quick. (Crystal keeps track of the open objects and will not allow any more to be launched past your license) We had to purchase a universal connector license or something like that to allow our company access. It was not very cheap at all and we have around 500 users.I inherited this project after the decision to use Crystal was made and they won't tell me how much they spent on it. All I know is that they weren't real happy when I suggested we dump Crystal and go with a straight CF/ASP/JSP solution. Needless to say, I am stuck with it for a while Good Luck! Tim P. - Original Message - From: Gieseman, Athelene [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 8:09 PM Subject: RE: CFREPORT and Error 500 I use Crystal 8.0 web page server. It's very easy to pass information from CF to the Crystal report. The following is an example of what I've done that has worked for me: cflocation url=http://kcweb/firmdaily/isweb/ISBudget/PO.rpt?Prompt0=#FindPO#; FindPO is the variable I'm sending from CF. It is the first Prompt variable in the report. If I were to send another, I'd add it to the end as Prompt1. E.g.: cflocation url=http://kcweb/firmdaily/isweb/ISBudget/PO.rpt?Prompt0=#FindPO#Prompt1=# TheOtherVariable# This has worked reliably for me. One word of caution though. I understand from someone on another list that version 8.5 requires a license for each person who runs a report off of the web page server. I haven't verified with Seagate. But if it's true, it would be way too expensive for us to use (with about 1000 users.) Maybe someone on this list can answer if they've used the latest version and if there is a licensing issue. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 1:14 PM To: CF-Talk Subject: Re: CFREPORT and Error 500 In the CF Forums you can find a lot about using CFReport. Last I checked the tag was depreciated since version 5 of Crystal Reports. Crystal has it's own webserver product now. Crystal seems to have spent a good deal of time integrating their product with ASP. I also remember some undocumented features to the CFReport tag you must use to pass parameters to the newer versions. Check the Forums. I hope the info is still there. If not, send me a direct email and I'll dig about my own archives for some of the examples I downloaded. Keep in mind that Crystal is on version 8 now. CFReport is meant to work with Version 5. Hope that helps. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/02/02 01:25PM I am trying to pass a variable to CFREPORT and I continue to receive the following. There is very little on the Allaire discussion forums about this. I am running CF 5 and CR 8.5. I thought the previous problems regarding CFREPORT has been fixed in CF 5. Anyone have an idea on this? Error Diagnostic Information Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 500 ocurred (Not enough memory for operation.). Crystal Library = C:\WINNT\system32\CRPE32.DLL (2/10/2001 1:43) DLL Version = 8.80, Engine Version = 8.80 The error occurred while processing an element with a general identifier of (CFREPORT), occupying document position (9:1) to (9:59). Date/Time: 04/02/02 11:02:09 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; T312461) Remote Address: 129.43.39.167 Alan L. Wolf MCSE, MCP, MCP + I SAIC Frederick PO Box B Bldg 458 Frederick, Maryland 21702 [EMAIL PROTECTED] 301-846-5479 (V) 301-846-6886 (F) __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: compilation error from POST????
Check any cf code right above that line. You may have forgot to put a closing bracket or parentheses. Tim P. -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 5:37 PM To: CF-Talk Subject: compilation error from POST Hello everyone, For some reason, CF gives me an error with this line: FORM ACTION=https://myotjersite.cfm; METHOD=post I'm I missing something all of a sudden?? I've got a closing form tag too. Just in time compilation error Invalid parser construct found on line 184 at position 15. ColdFusion was looking at the following text: POST Invalid expression format. The usual cause is an error in the expression structure. Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Composed on Tuesday, April 02, 2002, at 5:34:07 PM __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Update Increment Value
How about Update myTable Set myIntField = myIntField + 1 Where id = something - Original Message - From: Eric J Hoffman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 01, 2002 11:29 AM Subject: SQL Update Increment Value Is there a way to increment an int field in sql via the update statement without doing a select query in cf, then an update? Thanks for filling the hole. Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfgraph...revisited...
That's kind of what I did -- use cfsavecontent to save the url then use cfhttp to go get it: !--- Use the new cfsavecontent tag to capture the dynamically generated url to the graph --- cfsavecontent variable=SavedGraphUrl cfgraph type=pie title=Pie chart of something titlefont=Arial fileformat=jpg cfgraphdata item=First Value value=200 color=Blue cfgraphdata item=Second color=Red value=100 cfgraphdata item=3 color=Green value=50 cfgraphdata item=4 color=Yellow value=25 /cfgraph /cfsavecontent This is the saved graph: br cfoutput#SavedGraphUrl#/cfoutput !--- Create a variable for the cfhttp: --- cfset NewSavedGraphUrl = SavedGraphUrl !--- This removes the img src tag from the url to be used in the cfhttp call --- cfset NewSavedGraphUrl = Replace(NewSavedGraphUrl,'img src=', ,All) cfset NewSavedGraphUrl = Replace(NewSavedGraphUrl,'',,All) !--- Go get image using cfhttp --- cfhttp method=GET url=http://127.0.0.1#NewSavedGraphUrl#; path=c:\Inetpub\wwwroot\ file=test1.jpg /cfhttp - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 10:58 AM Subject: RE: cfgraph...revisited... I know that CFGRAPH returns a dynamically generated file (either flash or jpg). Is there any way to get it to write that file instead? Thanks! I don't think there's anything analogous to the offline generator functionality provided in the standalone Generator product. So, you'll have to rig something up yourself, probably. You could use CFHTTP to fetch the file, I suppose, although that's kind of a roundabout way of doing it. 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFREPORT error again!!! dll's grrrrrr..
Paul, Are you passing any parameters to the report? I get that error a lot if the parameters are not in the same order as they are on the report. Either that or the username/password is wrong. Granted, I have not used it with CF. HTH, Tim P. - Original Message - From: Paul Ihrig [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 9:30 AM Subject: CFREPORT error again!!! dll's grr.. cfstudio 5 crystal 8 i have it loaded on my local machine with local server i cant get this piece of crystal to work! i have read every thing i can find. most articles said to delete this or move that dll.. but none of it seems to work for me! any ideas??? thank you! -paul Error Diagnostic Information Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 534 ocurred (Error detected by database DLL.). Crystal Library = C:\WINNT\system32\CRPE32.DLL (2/10/2001 1:43) DLL Version = 8.80, Engine Version = 8.80 The error occurred while processing an element with a general identifier of (CFREPORT), occupying document position (9:1) to (9:125). Date/Time: 03/20/02 06:28:04 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) Remote Address: 10.232.1.20 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: getting values out of numbered form fields
Look at the Evaluate function -- e.g cfset strSQL = strSQL ID = Evaluate(PrintID#pos#) or - Original Message - From: Michael Wolter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 4:04 PM Subject: getting values out of numbered form fields I have a set of forms that allow the user to search a database, display matching records and then lets the user select specific records to print. The search displays matches in a form with check boxes for each record. So I need to loop through these numbered form fields, but I don't know how many there might be. The code I have is: cfloop condition=isdefined(chkPrint#pos#) cfset strSQL = strSQL ID = PrintID#pos# or cfset pos = pos + 1 /cfloop The part where I am checking for the existence of the field seems to work, but I can't figure out how to pull in the values from these fields and add them to my string. Thanks in advance for any insights. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Michael Wolter [EMAIL PROTECTED] | | Administrative Programmer/Analyst Carlisle, PA 17013 | | Dickinson College, Computer Services (717) 245-1527 | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFsetting through a loop - brainfart
Could you use a cfparam to default a value, just in case the user did not answer the question? e.g cfparam name=level#i# value= Then CF will have a value if it is not defined.. Tim P. - Original Message - From: Erika Foster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 4:33 PM Subject: CFsetting through a loop - brainfart Hi - this has got to be an easy fix. I've got a dynamic form sending a dynamic amount of fields to a Query. The form fields Level#i# are radio buttons. Here's the code: cfloop index=i from=1 to=#x# cfset thisskillid = Evaluate(Skillidi) cfset thislevel = Evaluate(level i) cfset thisempid = #empid# cfquery name=getanswer datasource=personnel SELECT empid, skillid FROM tblMatrix WHERE empid=#thisempid# and skillid=#thisskillid# /cfquery cfif #getanswer.recordcount# is 0 cfquery name=insertrow datasource=personnel INSERT INTO tblMatrix (empid, skillid, skilllevel) VALUES (#empid#, #thisskillid#, #thislevel#) /cfquery cfelse cfquery name=updaterow datasource=personnel UPDATE tblMatrix SET skilllevel=#thislevel# WHERE empid=#thisempid# AND skillid=#thisskillid# /cfquery /cfif /cfloop The problem is that if the the user doesn't answer that particular question, say they don't answer the first question - then this is the error: An error occurred while evaluating the expression: thislevel = Evaluate(level i) Error near line 12, column 8. -- -- An error has occurred while processing the expression: level1 Error near line 1, column 1. -- -- Error resolving parameter LEVEL1 Okay, so how do I cfset Level#i# = ?? That snippet gives me an Invalid Parser Construct error, pointing to the first #. This has to be easy... its not coming to me and I've wasted far too much time on this little bit of code. Thanks in advance, Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Form question
Not sure if this is what you are looking for, but if you have Adobe Acrobat, you can save it as pdf and create a form on top of it. The rub is that the user has to use Adobe reader to view/post the form. Tim P. - Original Message - From: Braver, Ben [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 01, 2001 1:06 PM Subject: OT: Form question Hi gang, I have no problem with using HTML forms or CFFORM to create forms. But I'm being asked to convert an existing paper-style MS Word document to a web form where info can be captured and emailed. My question is: is there a way to overlay form elements onto an existing doc saved as HTML without doing the form over from scratch? Thanks. Ben Braver Information Technology Ultramar Inc. Golden Eagle Refinery 150 Solano Way Martinez, CA 94553-1487 (925) 370-3673 voice (925) 370-3393 fax (510) 716-2557 pager [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Concatenate 2 Queries
If you are using CF 5, you can use UNION with the new Query of a query to do that. cfquery name=Query3 dbtype=query Select foo from Query1 UNION Select foo from Query2 /cfquery - Original Message - From: Ken Monroe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 01, 2001 10:00 AM Subject: Concatenate 2 Queries Hello! Is there a way to combine (concatenate) 2 different queries *without* using the QueryNew, QueryAddRow, QuerySetCell stuff? Something like QueryCat(Query1, Query2). ?? Thx ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: query on query help
Bruce, I have run into a number of bugs with the QoQ -- I know that there is a bug using MIN -- I recall seeing a post on the allaire forums about it. IIRC, the problem is if you have a where clause it is ignored. I don't know if this is the case with the COUNT() function, but may be related. I did run into a problem where the QoQ is case-sensitive. E.g FirstQuery: Select Names from UserTable Where Name = 'john' (Returns 1 record -- name is 'John') QoQ: Select Names from FirstQuery Where Name = 'john' Returns 0 records -- but Select Names from FirstQuery Where Name = 'John' will return the record. HTH, Tim P. - Original Message - From: Bruce, Rodney [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 30, 2001 7:20 PM Subject: query on query help Hello all I am just starting to work with trying to query a query. I am trying to count items and was wondering what I am doing wrong and why these two queries would give different results: CFQUERY name=query1 DBTYPE=qMain SELECT count (*) as total FROM qMain WHERE Storeid = #var1# and Catid= #var2#; /CFQUERY CFQUERY name=query2 DBTYPE=qMain SELECT id2 FROM qMain WHERE Storeid = #var1# and Catid= #var2#; /CFQUERY CFOUTPUT #query1.total# should equal #query2.recordcount# /CFOUTPUT But they are not equal. Total will give me the total of all items in all Catids that are in Storeid. (i.e. if Catid 1 has 5 and Catid 2 had 6 total = 11) Recordcount gives me the number of items in each Catid (which is what I want). (Recordcount would = 5 for Catid 1 and 6 for Catid 2). What am I missing that I am getting two different answers here? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Resizing images
Hamid, I used Image Robot from Jasc (www.jasc.com) . It has a command line feature that I use in conjunction with cfexecute to resize a bunch of images. It is more appropriate for doing a batch at a time. It doesn't work well running multiple instances at a time. I have seen the cfx_image tag thrown around a bit as well, but I have never used it. Tim P. - Original Message - From: Hamid Hossain [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 31, 2001 5:16 AM Subject: Resizing images Hi, I want to be able to resize gif, jpg or bmp pictures with coldfusion. Any help. Regards, Hamid Hossain ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Current CF Hosting Leaders?
I like crystaltech.com. Never had a problem and response is quick. Tim P. - Original Message - From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 12:46 PM Subject: Current CF Hosting Leaders? I know this topic comes up over and over again, but, it is important and conditions may change over time. So, who are the current best of breed commercial CF hosting ISPs? For example, I need a host with: CF, ACCESS and/or SQL-Server, Cybercash tags, secure server, etc. at low volumes. Would like to avoid, if possible, the expense of a dedicated server. Need extremely high reliability and ease of maintenance. Good support. Any current recommendations greatly appreciated. Richard Colman ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Friday Afternoon Macromedia Styleee
Just saw this one today: http://www.electrotank.com/games/playGames.cfm?gameID=31 Great little putt-putt golf game and the site is in CF! Tim P. - Original Message - From: John McCosker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 27, 2001 9:39 AM Subject: Friday Afternoon Macromedia Styleee I thought that since we are all now Macromedia customers we could do a spot the best Dynamic flash site. (does not have to be CF driven, not sure what this one is to be honest) Thought I'd start the ball rolling with http://www.2advanced.com This site grabbed me by the short and curlys, well impressed, its well out there. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Service Pack 2 Problems?
We are about to install windows 2000 service pack 2. Anyone have any problems with this on their CF servers? I haven't heard of any, but just wanted to be sure. Tim P. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Service Pack 2 Problems?
Thanks. To be sure -- are you referring to the Cold Fusion Service pack 2? We have that one installed. It was the Windows 2000 Service pack2 that I was concerned with. Tim P. - Original Message - From: Steven A. del Sol [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 27, 2001 1:32 PM Subject: Re: Service Pack 2 Problems? Originally there was a problem with the MDAC's in SP2. I think MM made changes in CF5 and in SP2 of CF 4.5. I can send more detail on this if needed. Steven A. del Sol I think the At 11:08 AM 7/27/2001 -0400, you wrote: We are about to install windows 2000 service pack 2. Anyone have any problems with this on their CF servers? I haven't heard of any, but just wanted to be sure. Tim P. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Designing for large screens
You're probably right. Unfortunately, there are no settings that I can tweak with the monitor that will affect that. The monitor stretches the output to fill the screen and I found that setting it at 800 x 600 gives it the best quality. - Original Message - From: Philip Arnold - ASP [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 23, 2001 3:18 PM Subject: RE: Designing for large screens I just set it up this afternoon and I have it set at 800 x 600. I am running the browser in kiosk mode so it will fill the whole screen with no toolbars, etc. I twiddled around with it this afternoon and figured out the proper dimensions at this resolution. 800x600 isn't 16x9, it's 4x3 Does your graphics card know it's a wide screen? Maybe the graphics card can't handle that scale - if it was truly 16x9 it should be 1066x600 or 800x450 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Designing for large screens
Absolutely!! Thanks -- that was the track I was headed down. It's nice to know I was heading in the right direction. Tim P. - Original Message - From: Philip Arnold - ASP [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 24, 2001 6:38 AM Subject: RE: Designing for large screens You're probably right. Unfortunately, there are no settings that I can tweak with the monitor that will affect that. The monitor stretches the output to fill the screen and I found that setting it at 800 x 600 gives it the best quality. Here's what I'd do Build a version that is squashed for normal screens and use a slightly squashed font (like Verdana) - then when the 16x9 screen stretches it, it will look OK Instead of building it and saying It'll be stretched, I can live with that, build it specifically for that screen and say it's only for this screen, so I can have it look rubbish on normal screens It'll be loads of running back and forth while testing, but it's the end result which is the most important, right? 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Designing for large screens
I was given the task to create a web page that will be shown on a 42 monitor. It is a wide screen with a 16 x 9 ratio (unlike the 4 x 3 ratio of normal monitors). I am having a hard time figuring out proper widths and heights for images, etc -- does anyone have any good resources on tips or tricks on designing for this medium? Thanks! Tim P. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Designing for large screens
I just set it up this afternoon and I have it set at 800 x 600. I am running the browser in kiosk mode so it will fill the whole screen with no toolbars, etc. I twiddled around with it this afternoon and figured out the proper dimensions at this resolution. thanks! Tim P. - Original Message - From: Philip Arnold - ASP [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 23, 2001 2:49 PM Subject: RE: Designing for large screens I was given the task to create a web page that will be shown on a 42 monitor. It is a wide screen with a 16 x 9 ratio (unlike the 4 x 3 ratio of normal monitors). I am having a hard time figuring out proper widths and heights for images, etc -- does anyone have any good resources on tips or tricks on designing for this medium? This sounds like the type of request our clients give us; I want the logo to be about 2 wide What resolution? The screen resolution is the most important thing here - if the graphics card is running at the right res, then it's only the browser width you have to worry about - try un-maximising your browser and set it to the same scale that your display screen will be... If the person running the screen says Well, it's 42 inches wide you have to wonder if they think that a 42 TV screen shows different pictures than a 28 TV screen... 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS and the Code Red Worm
Bill, We had 3 servers with the patch installed and it did not fix the problem. We had to manually remove the .ida and .idq mappings and it has been fine since. There were a few others on our local CF users group list that had to manually remove them as well. Tim P. - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 8:02 PM Subject: Re: IIS and the Code Red Worm OK ... two hours past since installing the microsoft patch found at: http://www.microsoft.com/technet/security/bulletin/MS01-033.asp for the affected NT 4.0 IIS 4 server and the web publishing service is still up and running. I did not unmap any extention or any other action except to install the patch and reboot. Cheers, Bill In a message dated 7/19/01 7:56:23 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: OK. I have slept since I unmapped the .htr extension. I think that was on NT 4. Now I don't remember where to go to disable these extensions..or if I ever knew. Anyway I'm installing windows 2000 sp2 waiting for it to reboot at the moment. Where are the ida, idq, htr hiding. I've been there before but I haven't been able to unearth them again. Jeff Craig ~~ 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: Fusebox and cfswitch
Jason, In a long running thread on the cf forums, a couple of users attributed cfswitch to eventually hanging the server. However they were looping over the cfswitch a few thousand times, so I find that suspect. I had read on Forta's site that cfswitch is faster than using a lot of cfif/cfelseif/ as well. (if you have more than 3 or more cases to evaluate). Tim P. - Original Message - From: Jason Dowdell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 20, 2001 10:59 AM Subject: Fusebox and cfswitch Hi all, I am considering implementing the fusebox methadology on all my new projects but wanted to throw something out to all of you and get your feedback. I have heard that on heavily trafficked sites that all of the cfswitch's bog down the apps performance. I have also heard some possible workarounds for this. Here's one... 1. Use this on index.cfm cfinclude template=#attributes.fuseaction#.cfm Will this work even if I'm using attributes.XFB.fuseaction? Does this workaround make sense to you experienced fuseboxers? Is there any merit to the bogging down of the application? Your comments would be much appreciated as I'm going crazy in spaghetti code :) Regards, Jason -- Jason Dowdell CF_Developer e-mail: [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: Me Vs. Counters
Michael, IMO, rolling your own might be a more accurate count. I had a similar problem counting hits to .pdf files. (For some reason, some adobe readers will register double hits to the same file -- this was well over a year ago, so it may have changed since then). Anyway, what I ended up doing is basically setting a cookie on the user with the filename and date -- I checked that with the request to the file and if the user had already requested it that day, then don't register a hit, otherwise, register a hit. Since your site has a lot of pictures, I wouldn't try to set a cookie for every picture and that would be a lot of traffic going back and forth, so a client or session variable might be better in that regard. Tim P. - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 5:09 PM Subject: Me Vs. Counters I'm trying to find the best way to count hits on multiple files on a photoshare site. Each photo (jpeg) is called using a .cfm page (to include the next/prev interface and photo details) like this: http://www.imvamp.com/photoshare/?action=browsegrid=Pokimonphid=1787 colid =1cols=3 Questions: 1. Is there a better solution then to include a CFQUERYUPDATE/CFQUERY in the bottom of each page to count hits? 2. Is it possible to somehow use IIS log files to intereprt hits better? (we have LOG visit turned on on those resources) 3. If that's the only solution, can someone explain how can I make use of the cftry/cfcatch thing on the CFQUERYUPDATE section so that if an erro occur in the update process to the db will be down, users will still see the image without a cf error. Thanks! Michael. http://share.imvamp.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: how do i condense this?
Would this work for you? cfif (Now() GT GetSubjects.BegQuarter) and (Now() LT GetSubjects.DistributionDate) cfset client.GradingPeriod = GetSubjects.Quarter INPUT TYPE=Text NAME=Grade VALUE=#Grade# cfelse #UCase(Grade)# /cfif - Original Message - From: Janine Jakim [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 8:54 AM Subject: how do i condense this? I have a display page that I want the user to update if it is the current quarter. How do I make my code more efficient then this stuff I have??? The only way I've gotten it to work is when I hard code the quarter- what's the best way to get rid of all of these cfif/cfelseif statements? Thanks for any help CFLOOP INDEX=X FROM=1 TO=#ListLen(Quarter)# CFIF (Now() GT GetSubjects.BegQuarter) and (Now() LT GetSubjects.DistributionDate) and (GetSubjects.Quarter EQ 1) CFSET CLIENT.GradingPeriod=1 INPUT TYPE=Text NAME=Grade VALUE=#Grade# CFELSEIF (Now() GT GetSubjects.BegQuarter) and (Now() LT GetSubjects.DistributionDate) and (GetSubjects.Quarter EQ 2) CFSET CLIENT.GradingPeriod=2 INPUT TYPE=Text NAME=Grade VALUE=#Grade# CFELSEIF (Now() GT GetSubjects.BegQuarter) and (Now() LT GetSubjects.DistributionDate) and (GetSubjects.Quarter EQ 3) CFSET CLIENT.GradingPeriod=3 INPUT TYPE=Text NAME=Grade VALUE=#Grade# CFELSEIF (Now() GT GetSubjects.BegQuarter) and (Now() LT GetSubjects.DistributionDate) and (GetSubjects.Quarter EQ 4) CFSET CLIENT.GradingPeriod=4 INPUT TYPE=Text NAME=Grade VALUE=#Grade# CFELSE#UCase(Grade)# /CFIF -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 8:45 AM To: CF-Talk Subject: RE: Scoping Variable CF automatically will search up if you only use q. If you don't want that, then specify URL.Q, or Variables.Q, or whatever. If you _want_ it to scope up, just use q. == = Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 9:35 AM To: CF-Talk Subject: Scoping Variable how do I enforce CF to use only url.q and not simply q i.e - how to ask cf to search for scoping on every variable? where is it in the administrator? Thanks, Michael ~~ 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: UUID Woes
Norman, I remember seeing a custom function (for CF 5) on http://www.cflib.org/ that has a CreateGUID function that creates it in microsoft form It is in the StrLib library. HTH, Tim P. - Original Message - From: Norman Elton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 16, 2001 8:16 PM Subject: UUID Woes I'm starting to use UUIDs as primary keys, and they work great. Using Ingres, I just stored them as strings, and indexed them to be primary keys. According to the Ingres gurus, this wasn't a big deal. I was happy to see that MS SQL 2000 has native support for UUIDs. Unfortunately, their idea of a UUID is a bit different from ColdFusion: MS SQL: ---- ColdFusion: ---xxx Needless to say, SQL won't accept ColdFusion's UUIDs. Does anyone know a way to get around this and allow ColdFusion to specify UUIDs to SQL? Thanks! Norman Elton ~~ 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: Review: CF 5.0
I think that the review is a little dated -- as far as I know, there is no CFSQL tag -- it was just incorporated as part of CFQUERY . It does seem to fly much faster on my local machine, fwiw. There is a performance brief on Macromedia's site that explains how they got the figure. http://www.macromedia.com/software/coldfusion/productinfo/performance_brief/ cf5_perf_brief.pdf Tim P. - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 16, 2001 9:39 AM Subject: Re: Review: CF 5.0 I particularly find this interesting: On Windows 2000, Macromedia benchmarks indicate that ColdFusion Server 5 processes page requests up to 5 times faster than ColdFusion Server 4.5.1. Anyone have any real life experiences on how much faster it REALLY is? How about on NT? -- 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: Javascript Function
Here's something that I recently did: script language=Javascript function AddMe() { var total; total = 0; num1 = parseInt(form1.number1.value); if (isNaN(num1) == 0) { total = total + num1; } num2 = parseInt(form1.number2.value); if (isNaN(num2) == 0) { total = total + num2; } num3 = parseInt(form1.number3.value); if (isNaN(num3) == 0) { total = total + num3; } form1.total.value = total; } /script form name=form1 method=post Number 1 input type=text name=number1 onblur=javascript:AddMe()br Number 2 input type=text name=number2 onblur=javascript:AddMe()br Number 3 input type=text name=number3 onblur=javascript:AddMe()br Your total : input type=text name=total /form - Original Message - From: Jerry Staple [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 4:10 AM Subject: Javascript Function Hi, Could anyone inform me of any javascript function that takes the total of numbers entered into a textbox and displays them in another? eg form name=form1 Item a = 2 (number in text box) Item b = 3 Item c = 4 Total = 9 (this total is generated by adding the items in the textboxes above) /form Any help will much apreciated Jerry Staple ~~ 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: QuerySetCell on CF 5
Scott, I'm using CF 5 Professional, and I am using it in an app here with no problems. Could you post the code? Tim P. - Original Message - From: Scott Van Vliet [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 3:15 PM Subject: QuerySetCell on CF 5 Have any of you had prolems with the QuerySetCell() function on CF Server 5. I just upgraded to CF 5EE this morning, and I am having problems on pages that use this function. Here is the error: snip Unhandled System exception ! The error occurred while processing an element with a general identifier of (CFSET), occupying document position (51:4) to (51:135) /snip Any help would be greatly appreciated! -- scott van vliet -- senior web engingeer juxt interactive 9497525898202 [EMAIL PROTECTED] www.juxtinteractive.com In uniqueness is the preservation of mankind... - Greg Graffin ~~ 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: cflocation killing session vars
You don't have a type attribute in your cflock -- could it not be setting it at all because of this? Cflock scope=SESSION timeout=15 type=exclusive cfset session.localads = 1 /cflock - Original Message - From: W Luke [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 7:31 AM Subject: cflocation killing session vars Hi, I usually use Client variables in this application, but in this instance I need to use a session variable which will then be killed off when the browser closes. Basically I have something like this setup: Cflock scope=SESSION timeout=15 cfset session.localads = 1 /cflock cflocation url=#new_address# addtoken=no When the user is taken #new_address#, session.localads doesn't exist - how come? Thanks -- Will new media discussion for Berkshire -=- http://bnm.lukrative.com local classifieds -=- http://www.localbounty.com e: [EMAIL PROTECTED] icq: 31099745 ~~ 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
Hello!
Forgive the post, but I haven't received anything for days now, but I see posts in the archive at the HOF, is there something wrong on the list? Tim P. ~~ 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: Weird Session Timeouts
How is your memory on your server? I had a problem recently where my server's ram maxed out and it stomped all over the session variables. It was timing out my sessions every couple of *seconds*. Incidently, I switched them over to client variables (cookie based) and I haven't had a problem since. - Original Message - From: Norman Elton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 15, 2001 9:01 AM Subject: Weird Session Timeouts This one's got me stumped. In my application.cfm, I've got... CFAPPLICATION NAME=PansophyPrd CLIENTMANAGEMENT=Yes SESSIONMANAGEMENT=Yes SETCLIENTCOOKIES=Yes SESSIONTIMEOUT=#CreateTimeSpan(0,8,0,0)# APPLICATIONTIMEOUT=#CreateTimeSpan(0,8,0,0)# Seems right to me. Technically there shouldn't be quotes are the createtimespans, but it doesn't seem to make any difference. In CF Administrator, the maximum session timeout is 10 hours, the default is 20 minutes. The catch is, sessions seem to time out within an hour. Perhaps it's somehow using the 20 minute default (I was away from my desk the entire hour). This has happened before on other servers, and it certainly troubling. Any advice? Thanks Norman Elton ~~ 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: Doubled Form fields
I seem to recall seeing that as a bug that was fixed in the 4.5.2 service pack. If you don't have it, try installing it and see if that fixes the problem. Tim P. - Original Message - From: Craig Bowes [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 11, 2001 9:43 AM Subject: Doubled Form fields Hey all. Has anyone had the problem of form fields doubling? Occasionally, when I submit this one form, it doubles all the form fields. For example, if I have a hidden form field called userid and its value is 3, the form passes it to the next page as 3,3. The form is has its enctype= multipart-form/data so it can do file uploads, but I don't know if that has anything to do with it. Anyone run into this before? Please email me at [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] instead of hitting reply because I don't check this account that much. -Craig ~~ 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 5 Cfgraph problem
You need to put the attribute fileformat in there. I think by default it uses Flash, but that only works if you have Generator installed. Put a fileformat=jpg or fileformat=png and it should work fine. - Original Message - From: Jim Watkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 11:58 PM Subject: CF 5 Cfgraph problem Should the following code draw a simple pie graph when executed? Or do i need something else? cfgraph type=pie title=Income by Department cfgraphdata item=New Vehicle Sales value=50 cfgraphdata item=Used Vehicle Sales value=25 cfgraphdata item=Leasing value=30 cfgraphdata item=Service value=40 /cfgraph Jim Watkins http://www.ngtcollege.org ~~ 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 5 Cfgraph problem More Info
I believe what they meant to say is that the cfgraph tag requires JRun server and generator, if you want to produce *flash* type graphs. I can generate png and jpg graphs with no problem. I do not have Jrun server and generator installed on my machine. These are separate products from Allaire/MM. Also, the documentation states you can generate .gif files, but you can't. Tim P. - Original Message - From: Jim Watkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 08, 2001 7:54 AM Subject: Re: CF 5 Cfgraph problem More Info The documentations states: The cfgraph tag requires the JRun server and the Macromedia Generator server, which install with ColdFusion. So I assume Generator was installed. - Original Message - From: Jim Watkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 08, 2001 7:35 AM Subject: Re: CF 5 Cfgraph problem I installed CF 5.0 subscription download and Generator was never mentioned. Where do I get Generator to install it? - Original Message - From: Tim Painter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 08, 2001 6:10 AM Subject: Re: CF 5 Cfgraph problem You need to put the attribute fileformat in there. I think by default it uses Flash, but that only works if you have Generator installed. Put a fileformat=jpg or fileformat=png and it should work fine. - Original Message - From: Jim Watkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 11:58 PM Subject: CF 5 Cfgraph problem Should the following code draw a simple pie graph when executed? Or do i need something else? cfgraph type=pie title=Income by Department cfgraphdata item=New Vehicle Sales value=50 cfgraphdata item=Used Vehicle Sales value=25 cfgraphdata item=Leasing value=30 cfgraphdata item=Service value=40 /cfgraph Jim Watkins http://www.ngtcollege.org ~~ 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