Re: Cold Fusion Sever 4.5 and Windows XP Professional
HB I'm running CF4.5Ent/SqlServer2k with XP on my laptop and I haven't had any troubles at all. I've been really pleased with it all around, less the exciting installation process. Courtney Payne Sr Web Eng Digicon Corp, Washington, DC - Original Message - From: Double Down, Inc. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, October 27, 2001 11:54 PM Subject: Cold Fusion Sever 4.5 and Windows XP Professional Does anyone know of any problems with running Cold Fusion Server 4.5 and Windows XP Professional? Sincerely, HB ~~ 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: Avoid Intermedia.net
Yeah, I've had pretty good experiences with Intermedia.net. Besides a few server downtime issues of late, I've been satisfied with their service. And their support people are pretty prompt when responding to my e-mails. Courtney Payne, Sr. Developer - Contractor Digicon Corp Washington, DC - Original Message - From: "Ken Wilson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 12, 2001 7:17 PM Subject: RE: Avoid Intermedia.net My experience has been just the opposite of yours, both with regard to their personnel and the details of their account offerings and charges. While I know at least one of us (Bud, I believe) had performance issues with their servers, I've had excellent service and performance from them with clients who needed low-priced shared hosting for multiple domains. Not trying to trivialize whatever problems you encountered, but I hated to see their offerings mis-represented in a public forum. Ken Intermedia.net is another host provider to avoid. They don't allow subdomains under a single account. They also don't allow multiple domains under one parent account. They charge you full charge for each sub-domain cname and top-level domain name. Their people are also not very knowlegable and rude. ~~ 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: detect JS...
noscript meta http-equiv="refresh" content="0; URL=YouNeedToEnableScripting.cfm" /noscript Courtney Payne pro-village.com [EMAIL PROTECTED] - Original Message - From: "Neil Clark" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 19, 2001 12:05 PM Subject: detect JS... Yes: SCRIPT LANGUAGE="JavaScript"!-- alert('This is a JavaScript enabled browser'); //--/SCRIPT This isn't what I suspect you wanted to know. If you need to know on the server, then you could add extra information to any: Link: A HREF="apage.htm" onClick="this.href='apage.htm?JavaScript=enabled'".../A CGI request: A HREF="cgi_program.pl" onClick="this.href='cgi_program.pl?JavaScript=enabled'".../A Form: FORM NAME="myForm" ACTION="whatever.htm" INPUT NAME="JavaScript" VALUE="" TYPE="hidden" /FORM SCRIPT LANGUAGE="JavaScript"!-- document.myFormJavaScript.value = 'enabled'; //--/SCRIPT ! --- Neil Clark Senior Web Applications Engineer ColdFusion / Spectra / XML mcb digital [Allaire Premier Partner] Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.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: TextArea for IE vs Netscape
Code please... :-) Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 10:15 AM To: CF-Talk Subject: Re: TextArea for IE vs Netscape I have tried everything to clean up the code. It works fine in IE and Netscape 6, it has the nice box with the text and a vertical scroll bar. But, in Netscape 4.76 the text is just pasted all over the page with no nice scroll box, it's just ugly. Cami - Original Message - From: "Michael Thomas" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 1:21 AM Subject: Re: TextArea for IE vs Netscape Hmmm I hadnt thought of that one thats most likely. I just ran into this problem again very recently too, so its fresh in my head. I was using a stand alone button with an onclick event, so it never occured to me that I needed the form element wrapped around it. Looked in netscape, boom was right on top of it when it didnt show up. Netscape is strict like that ;) That could very well be his problem. Mike From: "avex" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: TextArea for IE vs Netscape Date: Fri, 15 Dec 2000 16:47:36 +1000 this may seem stpid but once we had that problem here. and someone forgot to add a form tag!! adding one fixed the problem.. i am sure this can't be your problem though... ;-) Any ideas why a nice clean textarea with scrollbars and readonly attributes looks fine in IE but looses everything in Netscape? TIA Cami ~~ 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: TextArea for IE vs Netscape
:-) Textarea needs to be inside your form tags. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 10:54 AM To: CF-Talk Subject: Re: TextArea for IE vs Netscape this is the abbreviated code without all the text in the text box HTML HEAD TITLEtest page/TITLE /HEAD body BACKGROUND = "img/background.gif" TEXT="#00" LINK=#00 ALINK=#99 VLINK=#33 h3 ALIGN="center"home page/h3 CENTER TEXTAREA NAME="ba" ROWS=6 COLS=60 some text /TEXTAREA FORM ACTION = "ba.cfm" METHOD = "post" input type="radio" name="bag" value="A"checkednbsp;nbsp;b1/b nbsp;nbsp;nbsp;nbsp;nbsp;input type="radio" name="bag" value="D" nbsp;nbsp;b2/b nbsp;nbsp;nbsp;nbsp;nbsp;input type="submit" value="Submit" /form /CENTER /BODY /HTML - Original Message - From: "Courtney Payne" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 9:32 AM Subject: RE: TextArea for IE vs Netscape Code please... :-) Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Cami Lawson [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 10:15 AM To: CF-Talk Subject: Re: TextArea for IE vs Netscape I have tried everything to clean up the code. It works fine in IE and Netscape 6, it has the nice box with the text and a vertical scroll bar. But, in Netscape 4.76 the text is just pasted all over the page with no nice scroll box, it's just ugly. Cami - Original Message - From: "Michael Thomas" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 1:21 AM Subject: Re: TextArea for IE vs Netscape Hmmm I hadnt thought of that one thats most likely. I just ran into this problem again very recently too, so its fresh in my head. I was using a stand alone button with an onclick event, so it never occured to me that I needed the form element wrapped around it. Looked in netscape, boom was right on top of it when it didnt show up. Netscape is strict like that ;) That could very well be his problem. Mike From: "avex" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: TextArea for IE vs Netscape Date: Fri, 15 Dec 2000 16:47:36 +1000 this may seem stpid but once we had that problem here. and someone forgot to add a form tag!! adding one fixed the problem.. i am sure this can't be your problem though... ;-) Any ideas why a nice clean textarea with scrollbars and readonly attributes looks fine in IE but looses everything in Netscape? TIA Cami ~~ 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: Order By Random?
Sure. Generate a random number in CF and run a SWITCH/CASE to determine which table column to order by. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Craig M. Rosenblum [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 3:24 PM To: CF-Talk Subject: Order By Random? Is there any way to have a query give the results in random order? This is for Oracle... ~~ 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: Cookie and Javascript detect
For javascript detect, look up the noscript tag. For a cookie check, attempt to set a cookie on one page with cfcookie and check for it's existence on a subsequent one. If it's there then... well, you know. :-) Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Park, Simon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 29, 2000 10:54 AM To: CF-Talk Subject: RE: Cookie and Javascript detect Benjamin Fitts [mailto:[EMAIL PROTECTED]] wrote: http://www.browserhawk.com I believe they even have a cfx tag listed in the allaire developers exchange. I checked Browserhawk out and there are some limitations with CF which they don't tell you about until you install the program. For example, in order to check for a cookie, they recommend that you create an ASP page that uses Browserhawk to check for the cookie and then does a re-direct to the proper CF page (I guess this stems from the CFCOOKIE-CFLOCATION situation that gets mentioned pretty regularly on this list). The site we are developing will eventually be on a Unix OS and I really don't want to mess with Chilisoft ASP. Any other thoughts? =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Simon Park Computer Systems Management, Inc. Ph: 703-823-4300 x119 205 South Whiting Street #201 fax: 703-823-4301 Alexandria, VA 22304 http://www.csmi.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 ~~ 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: form passes all fields, except one?
Missing an equal sign in the name attribute. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Tammy Schilling [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 22, 2000 11:06 AM To: CF-Talk Subject: form passes all fields, except one? --CF871434F10C748D047F62D1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, I'm struggling with a form and query problem. There are four form fields to be inserted into a table. All seem to pass just fine, except one. I can't figure out why. I've checked how I've spelled it in both templates and the database, even to the point of retyping it to be sure. This is the form field that won't seem to pass: FORM ACTION="process_newchild.cfm" METHOD="POST" INPUT TYPE="text" Name"Parent_ID" SIZE="5" MAXLENGTH="5" Mother's ID number This is the query that I'm using CFQUERY DATASOURCE="LLL" INSERT INTO Children (Parent_ID , FirstName, LastName, Birthday_DueDate) VALUES ('#form.Parent_ID#' , '#form.FirstName#', '#form.LastName#', '#form.Birthday_DueDate#') /cfquery This is the error that I get Error resolving parameter FORM.PARENT_ID The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while evaluating the expression: #form.Parent_ID# The error occurred while processing an element with a general identifier of (#form.Parent_ID#), occupying document position (7:10) to (7:25). Any idea what I'm doing wrong? Thanks! Tammy -- personal copy designs better living through computer graphics http://www.personal-copy.com 410 219 5300 --CF871434F10C748D047F62D1 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit !doctype html public "-//w3c//dtd html 4.0 transitional//en" html Hi all, I'm struggling with a form and query problem.nbsp; There are four form fields to be inserted into a table.nbsp; All seem to pass just fine, except one.nbsp; I can't figure out why.nbsp; I've checked how I've spelled it in both templates and the database, even to the point of retyping it to be sure. pbuThis is the form field that won't seem to pass:/u/b brlt;FORM ACTION="process_newchild.cfm" METHOD="POST" plt;INPUT TYPE="text" Name"Parent_ID" SIZE="5" MAXLENGTH="5" brMother's ID number pbuThis is the query that I'm using/u/b brlt;CFQUERY DATASOURCE="LLL" brINSERT INTO Children (Parent_ID , FirstName, LastName, Birthday_DueDate) brVALUES ('#form.Parent_ID#' , '#form.FirstName#', '#form.LastName#', '#form.Birthday_DueDate#') brlt;/cfquerybu/u/b pbuThis is the error that I get/u/b brError resolving parameter FORM.PARENT_ID pnbsp;The specified form field cannot be found. This problem is very likely due to the fact that you brnbsp;have misspelled the form field name. pnbsp;The error occurred while evaluating the expression: pnbsp;#form.Parent_ID# pnbsp;The error occurred while processing an element with a general identifier of brnbsp;(#form.Parent_ID#), occupying document position (7:10) to (7:25). brnbsp; pAny idea what I'm doing wrong? pThanks! pTammy br-- brpersonal copy designs brbetter living through computer graphics brA HREF="http://www.personal-copy.com"http://www.personal-copy.com/A br410 219 5300 brnbsp;/html --CF871434F10C748D047F62D1-- ~~ 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 ~~ 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: Application Timeout at Midnight
Greg, If you haven't already solved your problem, I have a suggestion. When you initialize your application variable, create another application variable and set it's value to Now(). Then, use something like... cfif NOT IsDefined("application.yourVar") OR application.dateVar NEQ Now() cfset application.yourVar = yaddayadda cfset application.dateVar = Now() /cfif Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 2:19 AM To: CF-Talk Subject: Application Timeout at Midnight This is a multi-part message in MIME format. --=_NextPart_000_0007_01C04EAA.65607140 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hey Guys: I have been using the CachedWithin() function to create a timeout for my = application variables. However, a client of mine will have a special = number associated with billing that changes every day and I was = wondering how to make the application variable that contains this number = to timeout exactly at midnight. Thanks, Greg --=_NextPart_000_0007_01C04EAA.65607140 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hey Guys:/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2I have been using the CachedWithin() = function to=20 create a timeout for my application variables.nbsp; However, a client = of mine=20 will have a special number associated with billing that changes every = day and I=20 was wondering how to make the application variable that contains this = number to=20 timeout exactly at midnight./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks,/FONT/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Greg/FONT/DIV/BODY/HTML --=_NextPart_000_0007_01C04EAA.65607140-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [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: text split into 2 columns
avex, With an arbitrary "splitting limit" of 700, something like this should work. Haven't tested it should point you in the right direction. cfif len(yourText) GT 700 cfset temp = int(len(yourText)/2) cfset boundary = Find(" ", yourText, temp) cfelse cfset boundary = len(yourText) /cfif table tr td valign="top" width="50%"#left(yourText, boundary)#/td cfif len(yourText) GT 700 td valign="top" width="50%"#right(yourText, len(yourText) - boundary + 1)#/td /cfif /tr /table Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: avex [mailto:[EMAIL PROTECTED]] Sent: Friday, November 10, 2000 2:52 AM To: CF-Talk Subject: text split into 2 columns Hi everyone. I am doing a site where I have a body of text (about a paragraph or two). What I want to do is to to split this into 2 columns instead of one. Can this be done dynamically? Eg, If the first column exceeds so many characters, then output the remainder in the second to get the text column effect? any help would be great! thanks chad Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Input type = arrrrh!
Gavin, If you're concerned about the field widths, what I usually do is specify the size attribute with Netscape in mind, then define a style 'on top of it' for my IE users. ex. input type="text" name="test" size=25 style="width: 200px" Netscape picks up the size=25 and ignores the style while the style takes *precedence* over the size attribute in IE. Using both settings combined you can get the fields to be the same width in both browsers. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 31, 2000 12:05 PM To: CF-Talk Subject: Input type = ah! I made this little thing: http://www.lightrodsoft.com/test/input.cfm those are examples of what this looks like on the listed types of browsers/computers form input type="text" size="25" /form anyone have any hints as to making this display more universal? thanks, Gavin Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF_DHTMLMenu
Go check out the DHTML menu systems at brainjar.com. Pretty cool stuff. Not a custom tag but not too dificult to implement. Very well documented and IE/Netscape-safe. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Laure Lunot [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 30, 2000 9:08 AM To: CF-Talk Subject: Re: CF_DHTMLMenu Is there another custom tag like CF_DHTMLMenu which works with both IE and Netscape ? It only works for IE.. alas.. Hi ! Does someone know how to use the Custom Tag "CF_DHTMLMenu" with Netscape? This tag is working ok with IE but with Netscape, it generates a javascript error. Laure Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)
Well, you can't do a numeric search on non-numeric values. Umm... I think I'd add a field/column to my result set -- using the QueryAddColumn() -- and, for each row, set this new field to the 'housenumber' field's *numeric* equivalent -- using the QuerySetCell() and Val() functions. Then sort on this, now numeric, field in my cf_querysort. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: CF-Talk [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 26, 2000 5:21 PM To: CF-Talk Subject: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !) o.k. I had a sorting problem yesterday but with the help of the Custom Tag CF_QuerySort I am able to sort a varchar-column in a numeric way. (This morning I thought at least !) Although right now it doesn't seem to work anymore, since in my housenumber field there are most likely values like 93-94 and 101B and so on. I don't know why exactly but he (CF) is telling me nonstop when I order via the housenumber-field in a numeric manner the following: --- Error Diagnostic Information In function ArraySort the array element at position 4 is not a numeric value The error occurred while evaluating the expression: Temp = ArraySort(MyArray, Attributes.SortType, Attributes.SortOrder) The error occurred while processing an element with a general identifier of (CFSET), occupying document position (39:1) to (39:76). --- Ideas why ? Uwe SD Solutions Lange Zeile 27 85435 Erding Fon: 08122/903791 Fax: 08122/903792 Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Power of 3
cfset nextPower = 3 cfloop from=1 to=#whatever# index="i" cfif i EQ nextPower ... your code to be executed only on every 3rd power ... cfset nextPower = (nextPower * 3) /cfif /cfloop Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 12:36 PM To: CF-Talk Subject: Power of 3 Anyone have an idea on how to check to see if a value is a power of 3? I have a loop that needs to fire an event at every power of three that it hits and I am having problems getting my brain around how I need to do this. My first thoughts are to have a loopcounter and each time around the counter is incremented check and see if the counter value is the Next power of three. The end effect is that the if statement is triggered the following intervals: 3,9,27,81... jon Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Power of 3
Yahh.. :-) Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Friday, October 27, 2000 2:10 PM To: CF-Talk Subject: RE: Power of 3 Okay, Okay, Quick Question can you give us a hint as to why you want this? __ Nathan Stanford ColdFusion Tips Plus [EMAIL PROTECTED] www.cftipsplus.com __ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: GUUID?
Yeah, wrap a couple of single quotes around your #trim(url.objectid)#. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 26, 2000 9:29 AM To: CF-Talk Subject: GUUID? Okay, strange behaviour with a GUUID in a WHERE clause. I have a GUUID (varname = url.ObjectID) : BBD17F3C-9ED3-11D4-845B00E0293D68BB which is in a SQLServer 7 table with varchar as a type - length 50 (it is trimmed on return, though not needed) In my CFQUERY I have thus : SELECT * FROMObjects WHERE ObjectID = #Trim(url.ObjectID)# when it runs, I get this error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near 'D3'. anyone? It is probably staring me in the face - like a data type is wrong or an apostrophe missing here and there, but I can't see it. Neil ! --- Neil Clark Senior Web Applications Engineer mcb digital Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.com --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: JavaScript 'this' question
Duncan, Kill the document.formName. Instead of... document.formName.obj.value Just use... obj.value Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Hays, Duncan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 25, 2000 9:34 AM To: CF-Talk Subject: JavaScript 'this' question I want to be able pass a validated value back to a form without explicitly assigning the value in JS and I can't figure it out or even whether it can be done. Something like: input type="text" name="field1" value="na" onChange="javascript:validate(this)" Then in js have: function validate(obj){ if (document.formName.obj.value == "field1"){ document.formName.ojb.value = 1; } else{ document.formName.obj.value = 2; } } When I do this I get errors saying that "document.formName.obj has no properties". Thanks Duncan Hays Peace Corps Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Jsstringformat
cfset safeString = Replace(evilString, "'", "\'", "All") (escape single quotes by replacing them with \') Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 7:46 PM To: CF-Talk Subject: Jsstringformat I've gotten in the habit of using jsstringformat in several of my apps. Now I've got one that I have to deploy in a CF 4.01 environment. Anyone out there have a custom tag or regex expression that will accomplish the same thing? TIA - Sean ~~ Sean Daniels Manager, Engineering (T): 207.439.6030 (C): 978.764.0799 ~~ http://www.dealforce.com http://www.mergernetwork.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: validating an empty field in enctype=multipart/form-data
Won't work in MacIE 4.5- browsers. I found out the hard way a few months ago with a client that insisted on using MacIE to upload images. Due to "bug" in MacIE 4.5-, the length of the file field is always 0 -- whether you select a file or not. Getting your users to use MacIE 5.0 will solve the problem. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 8:28 PM To: CF-Talk Subject: Re: validating an empty field in enctype="multipart/form-data" yep. That worked. Thanks on 10/16/00 5:09 PM, Owens, Howard at [EMAIL PROTECTED] wrote: On my response page, I validate with: cfif NOT Len(form.field) ERROR: Your file doesn't exist cfabort cfelse cffile /cfif -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Jsstringformat
Depends on what's in your string and what you're trying to do. Ex. If you have an HTML string ("Hello there.brbrHow are you?"), you'll want to replace occurances of br with \r (or \n). Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 17, 2000 9:18 AM To: CF-Talk Subject: RE: Jsstringformat cfset safeString = Replace(evilString, "'", "\'", "All") (escape single quotes by replacing them with \') But are single quotes the only evil things I need to watch out for? If so, woo hoo! But I kind of doubt it? - Sean ~~ Sean Daniels Manager, Engineering (T): 207.439.6030 (C): 978.764.0799 ~~ http://www.dealforce.com http://www.mergernetwork.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Who's cleverer than us?
Garry, I assure you that I don't have a definitive solution to your problem but the first thing that sort of jumped out at me was the cursor processing and its behavior during concurrent requests. It's been a while since I've had to do any sqlserver cursor work but from what I can remember, there were 'Browse' and 'Standard' cursors and the way their row-locking/concurrency behavior was different. May be something to look into. Whatever the issue, have you considered wrapping an exclusive lock around the SP call to ensure single-thread use? (even thought the DB should be handled by the DB) How long do these SPs normally take to execute? Can you define a common-denominator between them? Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Garry Viner [mailto:[EMAIL PROTECTED]] Sent: Monday, October 09, 2000 4:21 AM To: CF-Talk Subject: Who's cleverer than us? This is a multi-part message in MIME format. --=_NextPart_000_0048_01C0321D.AA1FE030 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi all Certainly the trickiest problem we've found yet... We are running some stored procs on our site, fairly complex and slightly time intensive. These incorporate parameters, temporary tables, update, deletes, inserts, selects and sometimes cursors. ie. basic proc stuff. The procs work fine when run by a single user, however we have noticed that when hit by concurrent sessions they go wierd. In these instances the procs seem to "terminate". They return no result set, but even more than that, they cease at different apparently random points within through the proc. If the page is refreshed, no problem. When we have mutliple users just hitting SQLServer (not running the proc through CF), no problem. When we run normal queries as opposed to procs through CF, no problem. But for some reason multiple hits on a proc from CF gives this problem. Could it be threading via ODBC that's causing the problem? It doesn't even give an error, but rather says there are no rows in the result set, which is patently not true. We've proven that even when this happens, the proc is getting run, and the parameters are being processed properly, so the best we can come up with is that a thread in the stored proc is getting terminated when another thread hits it. All CF sessions are locked (both write and read) and we have discovered that sessions are not being lost and are being handled correctly. Seems impossible to me, but I'm no expert on the back end stuff. I know you guys like to see code, but there doesn't seem to be much point. The code works just fine, and it's long and won't tell you anything that I haven't already. I'm just interested to know if anyone has heard of such a thing? Why would a proc be run but not get to the end, but equally not trigger an error? And how can we fix it? We are stumped with a capital 'st' TIA Garry --=_NextPart_000_0048_01C0321D.AA1FE030 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR/HEAD BODY DIVFONT face=3DArial size=3D2SPAN class=3D799310408-09102000Hi=20 all/SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D799310408-09102000/SPAN/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2SPAN = class=3D799310408-09102000Certainly the=20 trickiest problem we've found yet.../SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D799310408-09102000/SPAN/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2SPAN = class=3D799310408-09102000/SPAN/FONTFONT=20 face=3DArial size=3D2SPAN class=3D799310408-09102000We are running = some stored=20 procs on our site, fairly complex and slightly time intensive. These = incorporate=20 parameters, temporary tables, update, deletes, inserts, selects and = sometimes=20 cursors. ie. basic proc stuff./SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D799310408-09102000/SPAN/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2SPAN class=3D799310408-09102000The = procs work fine=20 when run by a single user, however we have noticed that when hit by = concurrent=20 sessions they go wierd.nbsp;In these instances the procs seem to = "terminate".=20 They return no result set, but even more than that, they ceasenbsp;at = different=20 apparently random pointsnbsp;within through the proc. If the page is = refreshed,=20 no problem. When we have mutliple users just hitting SQLServer (not = running the=20 proc through CF), no problem. When we run normal queries as opposed to = procs=20 through CF, no problem. But for some reason multiple hits on a proc from = CF=20 gives this problem. Could it be threading via ODBC that's causing the = problem?=20 It doesn't even give an error, but rather says
RE: Math Question
100 is 25% of X -- 100 / .25 = *400* Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: j p [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 03, 2000 1:44 PM To: CF-Talk Subject: OT: Math Question To the great CF masses... I need a math formula that will tell me what 'X' is. Example: 75 is 80% of X 100 is 25% of X Any mathmaticians out there... jp _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT: Java Script Question
This is true. However, I wouldn't think usernames would be considered sensitive info. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 8:09 AM To: [EMAIL PROTECTED] Subject: Re: OT: Java Script Question your database beforehand and (using WDDX) make it available to your JS so that you can do the check right there on the client, without having to hit the problem with that is anyone can get a list of your usernames just by looking at the source ~Justin MacCarthy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Javascript question!...sorry
Hey Andy, It just worked on my end. Can you post your code? Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 8:26 AM To: '[EMAIL PROTECTED]' Subject: RE: Javascript question!...sorry Yeh this works with hyperlinks but doesn't seem to work with images as submit buttons unless I'm doing something wring. Have you got it to work? -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message----- From: Courtney Payne [mailto:[EMAIL PROTECTED]] Sent: 08 September 2000 13:23 To: '[EMAIL PROTECTED]' Subject: RE: Javascript question!...sorry Something like this should work: SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript" !-- function change(that) { that.src = 'image2.jpg'; } function changeback(that) { that.src = 'image1.jpg'; } //-- /SCRIPT . . . form input type="image" onmouseout="changeback(this)" onmouseover="change(this)" name="theButton" src="image1.jpg" /form Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 8:07 AM To: CFTalk (E-mail) Subject: Javascript question!...sorry Again... I know I shouldn't ask this here but does anybody know if it is possible to have a mouseover on a form submit button (INPUT Type="image"). I have got my mouseovers working for hyperlinks ok but can't get ot to work for images acting as submit buttons on forms. My java script is very average at the best of timesyour help is apprecited!! Andy -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Javascript question!...sorry
Again, creating a mouseover on a form submit button (of type image) is very much doable. All you're doing is changing the object's (the submit button) .src attribute. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 8:35 AM To: '[EMAIL PROTECTED]' Subject: RE: Javascript question!...sorry Yeh this works with hyperlinks but doesn't seem to work with images as submit buttons unless I'm doing something wring. Have you got it to work? Hi Andy, I think, as Justin implied, the secret is to have the image just be an IMG not an INPUT and get the submit behaviour by calling submit() explicitly Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT: Java Script Question
Fred, we weren't given any background info on the app. The implications would be different if you're logging in to your web-based email acct than it would be if you're logging in to your eTrade trading account, of course. All good points Fred. Anything is possible. (Sidenote, if I had the persistance to go through the process you described, I'd get in anyway -- with or without the usernames.) ;-) Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 8:43 AM To: [EMAIL PROTECTED] Subject: Re: OT: Java Script Question Courtney, I hope your not suggesting they run a query of usernames and passwords, or even just the user names for that matter. They would be viewable in source. You might say "well its just usernames big deal". Okay I've now got a list of user names I know are on the system, I fire up my Shadow HackNCrack program, give it my nifty new list of usernames and point it to one of the many dictionairy files I have for passwords and use the http crack module and brute force the website. NOT only do I have a high degree of certainty that I'll eventually get in, I'm now generating 10s of 1000s of hits on the server draining resources from use by others gaining the added benefit of hacking your site AND performing a very mild DOS attack as after effect there by slowing down the rest of the site for others, even if only by a small degree. Disclaimer: I uhh don't have any of the above mentioned dictionary files and would never dream of doing the above mentioned techniques to anything but my own boxes. The names of software mentioned above was not changed, he lives in a foreign company and could probably use the business, although I'm not going to give a link to their site, even though the software is only $25 American for the "Shadow Advanced Network Tools", the "Shadow Advanced Local Tools" and the "Shadow HackandCrack" software suite. I also won't mention their Shadow Security Scanner either, which just went up to $100. The point is security is ALWAYS and issue, because as much as we'd all like to believe there really is no such thing as security, no matter how much we'd like to believe there is, but that's not an excuse to make it easy for them. Fred - Original Message - From: "Courtney Payne" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 08, 2000 8:05 AM Subject: RE: OT: Java Script Question DD, Just as a side note, you'll *have* to go back to the server (ie. your action page) to query and check login names unless, on your form page, you query your database beforehand and (using WDDX) make it available to your JS so that you can do the check right there on the client, without having to hit the server first. For what you're trying to do, though, the code provided will solve your issue just fine (would be placed on your action page). Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 11:07 PM To: [EMAIL PROTECTED]; House Of Fusion Subject: Re: OT: Java Script Question script !-- alert("Username taken, please try another") history.back(1) // -- /script At 01:25 PM 9/7/00 -0700, Double Down wrote: I would like to flash a java script alert box saying that a login name is already in use. This will happen on the submit and it will go to the action page to check the db. My question is can I have the alert box pop up on the form page so the person does not have to go back and re-enter all of their information. How do I do this? TIA DDINC --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- - Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseof
RE: HTML strip function
Use this regex function: REReplace(report, "[^]*", "", "All") Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Brandon Behrens [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 10:29 AM To: Cf-Talk@Houseoffusion. Com Subject: HTML strip function This is a multi-part message in MIME format. --=_NextPart_000_0073_01C018AE.0A58ECF0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hello, I was wondering if there is a built in function in CF to remove any HTML from a string. Thanks, Brandon Behrens Brandon Behrens The Internet Design Firm 512.451.5225 [EMAIL PROTECTED] http://www.theidf.com --=_NextPart_000_0073_01C018AE.0A58ECF0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40" head meta http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" meta name=3DProgId content=3DWord.Document meta name=3DGenerator content=3D"Microsoft Word 9" meta name=3DOriginator content=3D"Microsoft Word 9" link rel=3DFile-List href=3D"cid:[EMAIL PROTECTED]" !--[if gte mso 9]xml o:OfficeDocumentSettings o:DoNotRelyOnCSS/ /o:OfficeDocumentSettings /xml![endif]--!--[if gte mso 9]xml w:WordDocument w:ViewNormal/w:View w:Zoom0/w:Zoom w:DocumentKindDocumentEmail/w:DocumentKind w:EnvelopeVis/ /w:WordDocument /xml![endif]-- style !-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig {margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} span.EmailStyle15 {mso-style-type:personal-compose; mso-ansi-font-size:11.0pt; mso-ascii-font-family:"Times New Roman"; mso-hansi-font-family:"Times New Roman"; mso-bidi-font-family:Arial; color:black;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} -- /style /head body lang=3DEN-US style=3D'tab-interval:.5in' div class=3DSection1 p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 = color=3Dblack face=3D"Times New Roman"span = style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'Hello,o:p/o:p/s= pan/font/span/p p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 = color=3Dblack face=3D"Times New Roman"span = style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if = !supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 = color=3Dblack face=3D"Times New Roman"span = style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'I was wondering if there is a built in function in CF to remove any HTML = from a string.o:p/o:p/span/font/span/p p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 = color=3Dblack face=3D"Times New Roman"span = style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if = !supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 = color=3Dblack face=3D"Times New Roman"span = style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'Thanks,o:p/o:p/= span/font/span/p p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 = color=3Dblack face=3D"Times New Roman"span = style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if = !supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 = color=3Dblack face=3D"Times New Roman"span = style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'Brandon Behrenso:p/o:p/span/font/span/p p class=3DMsoNormalspan class=3DEmailStyle15font size=3D2 = color=3Dblack face=3D"Times New Roman"span = style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt'![if = !supportEmptyParas]nbsp;![endif]o:p/o:p/span/font/span/p p class=3DMsoAutoSig!--[if supportFields]font color=3Dblackspan=20 style=3D'color:black'span = style=3D'mso-element:field-begin'/spanspan=20 style=3D"mso-spacerun: yes"nbsp;/spanAUTOTEXTLIST \s quot;E-mail=20 Signaturequot; span = style=3D'mso-element:field-separator'/span/span/font![endif]--f= ont size=3D2 color=3Dblackspan = style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt; color:black'Brandon Behrens/span/fontfont size=3D2 = color=3Dblackspan style=3D'font-size:11.0pt;mso-bidi-font-size:12.0pt;color:black;mso-color= -alt:
RE: MULTIPLE COLUMN output problem!
Ok, try this. Didn't have the tables set up to test this against but it should point you in the right direction. !--- Get number of top-level categories for TD delimitting later --- cfquery name="GetNumCategories" ... SELECT DISTINCT(CategoryName) FROM [your table] /cfquery cfset numcategories = GetNumCategories.recordcount !--- Your query here --- cfquery name="GetAllCategories" ... . . . /cfquery !--- Since you can't use currentrow (because you're grouping), maintain your own category (top-level) counter --- cfset count = 0 !--- You're only gonna have 2 TDs in your table - one on the left, one on the right. --- table tr td valign="top" cfoutput query="GetAllCategories" group="CategoryName" cfset count = count + 1 !--- TD delimit check --- cfif count EQ ceiling(numcategories / 2) /tdtd valign="top" /cfif #CategoryName#br cfoutput #SubCategoryName# | /cfoutput brbr /cfoutput /td /tr /table Again, haven't tested this or anything... hope it helps. Courtney E. Payne, Developer Figleaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: Hassan Khawaja [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 12:45 PM To: [EMAIL PROTECTED] Subject: MULTIPLE COLUMN output problem! Hi all, I am experiencing a certain problem, and will try to explain it as well as I can. I have a list of links that I am trying to output in a 2 column format, very similar to Yahoo! main menu design. As you know there are main Categories listed with sub categories right underneath them. kind of like: NewsComputers - World, US..-Software, WWW... BusinessReference - B2B, Companies..- Encyclopedias, Lists.. Now, I have in my database 2 tables - categories, and sub-categories, which are linked together thru a category id. The idea is to ouput the categories with their subcategories with them in a 2 column format. I can output 2 columns correctly if I only ouput the categories. or if I just output the subcategory. However it gets all very hairy if join the tables and output using the GROUP parameter of CFOUTPUT. The problem arises when there are a dissimilar number of subcategories for each category. In my code it looks for cfif currentrow MOD columncount eq 0 to determine if the current row's MOD 2 is 0 to know if 2 columns have already been output, but when there are different no. of subcategories, this logic statement gets evaluated at the wrong point than the one I want it to. Right now it is printing 3 columns for one row and only one column for another, while the rest of the rows are alright with 2 columns. What I mean is that if a certain category has 1 sub-cat. and the other has 2 sub-cats, the output counts them as 3 rows total and instead of starting a new row after the category and its sub-cats have been output, it tries to start a new one as soon as 2 columns have been evaluated. So even though the 3rd row is still part of the main category, for the logic statement, it's a NEW row. Sample output: [ numbers are rowcount ] 1-Administration2-Daily Reports 1- Areas | 2- Divisions | 3-Data Entry 4-Help 3- Products | 4- About | 5-MDS6-MSDS 5- Areas | 6- Facilities | 7-Process Control9-Production10-Reports ***problem 7- Business | 8- Divisional | 9- Reports | 10-Data | *** 3 columns 11-SSOP 12-Safety 11- Tasks | 12- Data | 13-Sales* problem 13- Facilities | just 1 column*** To stop confusing you further, I am including the code snippet to accomplish this: !--- the query to gather the info --- cfquery name="mainpage" SELECT mnu_categories.category_id, mnu_categories.category_name, mnu_categories.category_url, mnu_sub_categories.sub_cat_id, mnu_sub_categories.sub_cat_name FROM mnu_categories,