Recursive function and Hierarchical navigation
I'm trying to build a dynamic hierarchical navigation system using thew following table structure ID NAME PARENT_ID 1 category1 0 2 category1_1 1 3 category1_2 1 4 category1_1_1 2 5 category1_1_2 2 6 category2 0 7 category3 0 I would like to be able to do some sort of recursive process and put this information into a structure to output to a page. i.e. category1 category1.category1_1 category1.category1_2 category1.category1_1.category1_1_1 category1.category1_1.category1_1_2 category2 category3 I've got the following code but I'm getting stuck on the recursive bit. cfset startpoint = 0 cfset tree = StructNew() cfset getlevel=getchildren(startpoint) cffunction name=getchildren cfargument name=parentID cfset var qry_tree= cfquery datasource=#application.dsn# name=qry_tree SELECT * FROM test WHERE Parent_ID= #arguments.parentid# /cfquery cfoutput cfloop query=qry_tree cfset name2=category currentrow cfset tree[category#currentrow#] = qry_tree.name /cfloop /cfoutput /cffunction cfdump var=#tree# Any advice on how to build the hierarchical structure? Would a CFC be better? Thanks in advance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: css idiot question
I don't use the onmouseover clause very often, but why are you using td1 and not this. Also -- there should be semicolons after you set the bg color on the actions. -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Tony Weeg [mailto:[EMAIL PROTECTED] | Sent: Wednesday, June 02, 2004 06:22 | To: CF-Talk | Subject: css idiot question | | maybe its just too late, but why does this div not change | background and font color, when mouseover'ed | | div | style=background:#53;width:100%;height:100%; | | > | > | id=td1 | | New Applicant | | /div | | thanks! | | tony | | r e v o l u t i o n w e b d e s i g n | [EMAIL PROTECTED] | www.revolutionwebdesign.com | | its only looks good to those who can see bad as well -anonymous | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: nevermind again...RE: css idiot question
Tony, you should check out using css for the whole shebang, using the :hover pseudo class. You need a little fix for IE though: http://www.htmldog.com/articles/suckerfish/hover/ -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Tony Weeg [mailto:[EMAIL PROTECTED] | Sent: Wednesday, June 02, 2004 06:26 | To: CF-Talk | Subject: nevermind again...RE: css idiot question | | it never fails...post and figure out, sendbuttonitis | | div style=background:#53;width:100%;height:100%; | > | 00'; | > | id=td1 | New Applicant | /div | | thanks anyway! | | tony | | Tony Weeg | sr. web applications architect | navtrak, inc. | [EMAIL PROTECTED] | 410.548.2337 | www.navtrak.net | | -Original Message- | From: Tony Weeg [mailto:[EMAIL PROTECTED] | Sent: Wednesday, June 02, 2004 12:22 AM | To: CF-Talk | Subject: css idiot question | | | maybe its just too late, but why does this div not change | background and | font color, when mouseover'ed | | div | style=background:#53;width:100%;height:100%; | | > | > | id=td1 | | New Applicant | | /div | | thanks! | | tony | | r e v o l u t i o n w e b d e s i g n | [EMAIL PROTECTED] | www.revolutionwebdesign.com | | its only looks good to those who can see bad as well | -anonymous | | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: css idiot question
div style=background-color:#53; width:100%; height:100%; > this.style.color='#00'; > this.style.color='#ff'; id=td1 New Applicant /div -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: woensdag 2 juni 2004 6:22 To: CF-Talk Subject: css idiot question maybe its just too late, but why does this div not change background and font color, when mouseover'ed div style=background:#53;width:100%;height:100%; > id=td1 New Applicant /div thanks! tony r e v o l u t i o n w e b d e s i g n [EMAIL PROTECTED] www.revolutionwebdesign.com its only looks good to those who can see bad as well -anonymous [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Difficult SQL Question
If your db supports it, you can use INTERSECT SELECT TicketID FROM fields WHERE FieldID = 1 AND Value = '5' INTERSECT SELECT TicketID FROM fields WHERE FieldID = 2 AND Value = 'Hello' Alternatively you could use group by (supposing (TicketID, FieldID) is unique) SELECT TicketID FROM fields WHERE 0 = 1 OR (FieldID = 1 AND Value = '5') OR (FieldID = 2 AND Value = 'Hello') GROUP BY TicketID HAVING COUNT(TicketID) = 2 You can also use subqueries SELECT * FROM tickets WHERE 0 = 0 AND TicketID IN ( SELECT TicketID FROM fields WHERE FieldID = 1 AND Value = '5' ) AND TicketID IN ( SELECT TicketID FROM fields WHERE FieldID = 2 AND Value = 'Hello' ) I didn't want to type to much, so there are some modifications you should make to the code: - Use cfqueryparam everywhere - Don't use SELECT * but specify the columns you want - In the group by example COUNT() has to be the number of fields you want to search on -Original Message- From: Cedric Villat [mailto:[EMAIL PROTECTED] Sent: woensdag 2 juni 2004 2:01 To: CF-Talk Subject: Difficult SQL Question Ok, I have a bit of a problem with some SQL I'm trying to build. I have a table of Tickets, and then a table with a list of fields that are associated with tickets. Here are some values for the fields table: What I want to do is select the TicketID's that have a (FieldID = 1 AND Value LIKE 'Hello') AND (FieldID = 2 AND Value = 5). In this case I would want Ticket #1 returned. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Recursive function and Hierarchical navigation
I don't do it recursively, but use the fact that structs are passed by reference. I query the table and loop it twice: cfscript function makeStruct(id, name, parent_id){ var stNew = StructNew(); stNew.id = id; stNew.name = name; stNew.parent_id = parent_id; stNew.aChildren = ArrayNew(); return stNew; } stTree = StructNew(); stTree.aChildren = ArrayNew(); /cfscript cfquery datasource=#application.dsn# name=qTree SELECT ID, NAME, PARENT_ID FROM test ORDER BY whatEverYouWant /cfquery !--- first loop: create structs --- cfloop query=qTree cfset stTree[qTree.id] = makeStruct(qTree.id,qTree.name,qTree.parent_id) /cfloop !--- second loop: create hierarchy --- cfloop query=qTree cfif qTree.parent_id IS 0 cfset ArrayAppend(stTree.aChildren,stTree[qTree.id] cfelse cfset ArrayAppend(stTree[qTree.parent_id].aChildren,stTree[qTree.id] /cfif /cfloop You start with stTree.aChildren for the first level. This array contains structures with all the info on the element (id, name, parent_id) and an array aChildren (can be empty) with the children. And so on. If you have a lot of elements, don't try dumping the structure. But because structs are passed by reference, this doesn't take much more place in memory than the query. You will probably need a recursive UDF or CT to write the html. -Original Message- From: Paul Wilson [mailto:[EMAIL PROTECTED] Sent: woensdag 2 juni 2004 8:22 To: CF-Talk Subject: Recursive function and Hierarchical navigation I'm trying to build a dynamic hierarchical navigation system using thew following table structure ID NAME PARENT_ID 1 category1 0 2 category1_1 1 3 category1_2 1 4 category1_1_1 2 5 category1_1_2 2 6 category2 0 7 category3 0 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Recursive function and Hierarchical navigation
I didn't test the code, so there could be some errors in it. I've already spottet one. This should read ArrayNew(1) stNew.aChildren = ArrayNew(); stTree.aChildren = ArrayNew(); [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Coldfusion and MX
Hi Vishnu, how's the studying going ;) I used the Macromedia Dev centre Flash remoting demo to get me started, find it here http://www.macromedia.com/devnet/mx/coldfusion/articles/startremoting.html John. -Original Message- From: vishnu prasad [mailto:[EMAIL PROTECTED] Sent: 02 June 2004 05:27 To: CF-Talk Subject: Coldfusion and MX Hi All i am new to Flash i like to develop and application using flash and coldfusion if anyone familar with that will u pls tell me how to develop simple application regards Vishnu Prasad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Recursive function and Hierarchical navigation
This is SQL-Server specific: http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm If you want some general discussions on the topic google for celkoand trees or hierarchical or nested sets HTH Dick On Jun 1, 2004, at 11:22 PM, Paul Wilson wrote: I'm trying to build a dynamic hierarchical navigation system using thew following table structure ID NAME PARENT_ID 1 category1 0 2 category1_1 1 3 category1_2 1 4 category1_1_1 2 5 category1_1_2 2 6 category2 0 7 category3 0 I would like to be able to do some sort of recursive process and put this information into a structure to output to a page. i.e. category1 category1.category1_1 category1.category1_2 category1.category1_1.category1_1_1 category1.category1_1.category1_1_2 category2 category3 I've got the following code but I'm getting stuck on the recursive bit. cfset startpoint = 0 cfset tree = StructNew() cfset getlevel=getchildren(startpoint) cffunction name=getchildren cfargument name=parentID cfset var qry_tree= cfquery datasource=#application.dsn# name=qry_tree SELECT * FROM test WHERE Parent_ID = #arguments.parentid# /cfquery cfoutput cfloop query=qry_tree cfset name2=category currentrow cfset tree[category#currentrow#] = qry_tree.name /cfloop /cfoutput /cffunction cfdump var=#tree# Any advice on how to build the hierarchical structure? Would a CFC be better? Thanks in advance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: deleting db entries..
yes id is my unique primary key.I tried adding a cfoutput to display it, and it is correct. I started without the LIMIT 1, but had the same exact results.So I stuck it in there in hopes it would take care of the problem. -Mike -Original Message- From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tue, 1 Jun 2004 18:16:36 -0400 Subject: RE: deleting db entries.. I know its advised against deleting database entries, but where am I going wrong here? There's absolutely nothing wrong with deleting unwanted database records. This statement works, but deletes all table entries rather than the id of the one specfied.. The only thing I can think of is it is a query inside of another query.. Total brainfart here.. cfquery datasource=mysql DELETE FROM table_name WHERE id = #entrytodelete# LIMIT 1 /cfquery Is the id field a primary key? If not, are there duplicate values within that field? (Or, perhaps more appropriately, were there duplicate values before you ran your DELETE statement?) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Difficult SQL Question
Cedric Villat wrote: Ok, I have a bit of a problem with some SQL I'm trying to build. I have a table of Tickets, and then a table with a list of fields that are associated with tickets. Here are some values for the fields table: TicketIDFieldIDValue 11 Hello 12 5 21 Hello 23 Boo 32 5 What I want to do is select the TicketID's that have a (FieldID = 1 AND Value LIKE 'Hello') AND (FieldID = 2 AND Value = 5). In this case I would want Ticket #1 returned. But obviously, this string does not work in the WHERE clause of my query. What I'm wanting to create is a search where people can search different FieldID's and their values, and ONLY those TicketID's matching ALL of the specified fields/values will be returned. I'm having no luck doing this as each value/field pair is its own row. Besides using CF to manipulate the data, can I do this in SQL? http://lists.mysql.com/mysql/157925 Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Blackstone - Toronto CFUG notes
From the sound of the proposed changes/updates, I would imagine MM would definitely want us to put out some heavy word of mouth. Great free advertising targeting several other developer communities on a reason to switch. Of course there is still the issue of server licensing pricing to consider here... Cutter Tony Weeg wrote: oh. whatev. cool. -Original Message- From: Alexander Sherwood [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 2:27 PM To: CF-Talk Subject: RE: Blackstone - Toronto CFUG notes At 02:18 PM 6/1/2004, you wrote: does ben want people to spill the beans on his tour talks? just wondering? yes. he blogged the question who will spill the beans first?. besides, no NDA was offered! Fair game! -Original Message- From: Alexander Sherwood [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 2:13 PM To: CF-Talk Subject: Re: Blackstone - Toronto CFUG notes At 01:18 PM 6/1/2004, you wrote: Thanks for taking the time to post this, Dharmesh! Question.what, specifically, did Ben mention about changes to CFCs, and what other XML functions are planned? Thanks again! Just some notes from Ben's presentation last night at the Toronto CFUG meeting. Please find them in rough notes format. I can try and elaborate on request. By no means every little detail was gathered. I am sure others who attended can fill in the gaps. - Lots more xml functions. - xmlValidate(), xmlparse() - changes to CFC -- Alex Sherwood PHS Collection Agency THE COLLECTORS P:813-283-4579 F:301.664.6834 W: www.phs-net.com -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:165148This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=808.728.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=39 c69017.jpg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Recommendation for a book about writing documentation
UML is only a small part of requirements specifications. A good book on UML is: Fundamentals of Object-Oriented Design in UML (Page-Jones) A good book on requirements specifications, as well as software process and documentation in general is: Software Engineering: A Practioner's Approach (Pressman) Cutter Won Lee wrote: At 10:51 6/1/2004 -0600, you wrote: What your asking for falls under the category of Technical Writing.When I was studying programming in school, the Technical Writing class was required.It covered a number of points like knowing who the target audience is, how to present step by step instructions, etc. A quick google search for technical writing returns 7,090,000 results (http://www.google.ca/search?q=technical+writingie=UTF-8hl=enbtnG=Google+Searchmeta=). There should be enough in there to get you started or at least help you narrow down your search. HTH Shawn -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 10:41 AM To: CF-Talk Subject: RE: Recommendation for a book about writing documentation I am looking for something about writing both requirement documentation as well as user manulas. Mostly requirement documentation, the manual writing tips would be a nice bonus in a book. I can also always get 2. TK The de facto standard in the OOP world for user requirement documentation is UML or more specifically Use Cases. Since this is a CF list I'm going to assume that you mean requirement docs for a CF app. Building Web Applications with UML by Jim Conallen is the book I read that is specifically targeted for Web Applications. There are some other books about UML from the AW library but none of the others are specifically targeted for web applications. The Use Cases should translate easily into a user manual as all the actors (login types) and actions should are already defined before the system is built out. On a personal note, I strongly urge you to consider the time vs reward aspect. While I recognize the need for some type of documentation, I question the value of UML for small to medium sites especially if there is a learning curve associated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Return value from function has extra space
I have a function that takes a string, manipulates (encrypts, etc.) it and returns it. For Example: #encode(value=Test string)# Result: blahblahblah When I output the result directly to the screen: CFOUTPUT#encode(value='Test String')#CFOUTPUT Result: blahblahblah The result has an extra space at the beginning.When I output the value from within the function, the result doesn't have the space. When I assign the returned value to a variable and output the variable: CFSET dummy = encode(value='Test String') CFOUTPUT#dummy#/CFOUTPUT Result: blahblahblah The result is fine. Any thoughts on why the output the result of the function directly would result in the extra space? I am dumbfounded...or just dumb ;-) Thanks, Brian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Coldfusion and MX
Vishnu, You might start with some of the tutorials on the MM site, as well as those at FlashCFM.com Cutter vishnu prasad wrote: Hi All i am new to Flash i like to develop and application using flash and coldfusion if anyone familar with that will u pls tell me how to develop simple application regards Vishnu Prasad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Return value from function has extra space
Did you write your UDF w/ cffunction? Did you forget output=false in the cffunction tag? If you did forget, or set it to true, you will get extra white space. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Return value from function has extra space
Raymond- Looks like I was just dumb ;-)It works like a champ, thanks for the quick response! Brian -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 8:18 AM To: CF-Talk Subject: RE: Return value from function has extra space Did you write your UDF w/ cffunction? Did you forget output=false in the cffunction tag? If you did forget, or set it to true, you will get extra white space. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Recursive function and Hierarchical navigation
How do you return a record set like this back to ColdFusion? Do you just use a cfquery tag? I tried the example, and it's much faster than what we are currently doing, but how do I handle it on the ColdFusion side? This is SQL-Server specific: http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm If you want some general discussions on the topic google for celkoand trees or hierarchical or nested sets HTH Dick On Jun 1, 2004, at 11:22 PM, Paul Wilson wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: mssql NULL
From: Tony Weeg this errors. cfif NOT (isDefined(form.notqualifiedId) and IsMSSQLGUID(form.notqualifiedId)) cfset form.notqualifiedId = NULL /cfif I want to send null to the database as the value. can this be done, so that I can then, in turn, do this. update accounts set notQualifiedId = #form.notQualifiedId# where accountNumber = 1 Three things 1) CFQUERYPARAM 2) CFQUERYPARAM 3) CFQUERYPARAM I thought it was that important that I'd mention it 3 times... CFQUERYPARAM has a NULL attribute where you can set a logical option to see if you want it to pass NULL to the database Otherwise, can you send the URL of the form, so I can set form.notQualifiedID to be 1; drop table accounts // [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Recursive function and Hierarchical navigation
Yeah! Play with it in a SQL GUI until you get it the way you want it, then enclose it within cfquery.../cfquery tags. Most of these (Celko's) techniques are quite fast -- seems a little odd at first, but it compensates for RDBMS's inherent weakness when handling hierarchical data. I suggest you include lotsa' comments to explain what why. HTH Dick On Jun 2, 2004, at 5:28 AM, Nicholas Watson wrote: How do you return a record set like this back to ColdFusion? Do you just use a cfquery tag? I tried the example, and it's much faster than what we are currently doing, but how do I handle it on the ColdFusion side? This is SQL-Server specific: http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm If you want some general discussions on the topic google for celko and trees or hierarchical or nested sets HTH Dick On Jun 1, 2004, at 11:22 PM, Paul Wilson wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: mssql NULL
Or even better cfparam name=form.notqualifiedId default= update accounts set NOTQUALIFIEDID = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form.notqualifiedId# null=#YesNoFormat(NOT IsMSSQLGUID(form.notqualifiedId))# where accountNumber = 1 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: woensdag 2 juni 2004 5:58 To: CF-Talk Subject: RE: mssql NULL well, self... do this... this works: cfif NOT (isDefined(form.notqualifiedId) and IsMSSQLGUID(form.notqualifiedId)) cfset form.notqualifiedId = NULL /cfif then in the sql statement... update accounts set NOTQUALIFIEDID = cfif form.notqualifiedId is NULLNULL, cfelse'#form.notqualifiedId#',/cfif where accountNumber = 1 :) wow self, good stuff. (apart from cfqueryparam, but im preventing bad data in the capturing of the data) thanks anyway, good night. tony Tony Weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] 410.548.2337 www.navtrak.net -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 11:47 PM To: CF-Talk Subject: mssql NULL this errors. cfif NOT (isDefined(form.notqualifiedId) and IsMSSQLGUID(form.notqualifiedId)) cfset form.notqualifiedId = NULL /cfif I want to send null to the database as the value. can this be done, so that I can then, in turn, do this. update accounts set notQualifiedId = #form.notQualifiedId# where accountNumber = 1 thanks. tony r e v o l u t i o n w e b d e s i g n [EMAIL PROTECTED] www.revolutionwebdesign.com its only looks good to those who can see bad as well -anonymous [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ArrayLen
Hello all, I've got an easy one (for yall anyway).I'm trying to loop through an array and check a value...but I'm doing somnething syntactically incorect...I've looked and output the value but I still don't understand what's going on.Here's what I've got: cfloop From=1 to=ArrayLen(S1Array) index=i cfif s1 EQ S1Array[i] AND S3Array[i] EQ 0 cfset hasSibling = true hasSibling: #hasSibling#br /cfif /cfloop it's complaining: The value of the attribute TO is invalid. The value cannot be converted to a numeric because it is not a simple value.Simple values are booleans, numbers, strings, and date-time values when I output ArrayLen(S1Array) I get 7...so I know that this is a valid array and should be a number?What am I doing wrong? Thank you - Frank --- The Preceeding Email Has Been Scanned and Verified By QBOS Security Systems --- QBOS, Inc. 14275 Midway Rd.Suite 220 Addison, TX 75001 972.233.5066 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ArrayLen
need #'s around functions when they are part of that looping mechanism. tw -- Original Message -- From: Frank Dewey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Wed, 2 Jun 2004 07:47:50 -0500 Hello all, I've got an easy one (for yall anyway).I'm trying to loop through an array and check a value...but I'm doing somnething syntactically incorect...I've looked and output the value but I still don't understand what's going on.Here's what I've got: cfloop From=1 to=ArrayLen(S1Array) index=i cfif s1 EQ S1Array[i] AND S3Array[i] EQ 0 cfset hasSibling = true hasSibling: #hasSibling#br /cfif /cfloop it's complaining: The value of the attribute TO is invalid. The value cannot be converted to a numeric because it is not a simple value.Simple values are booleans, numbers, strings, and date-time values when I output ArrayLen(S1Array) I get 7...so I know that this is a valid array and should be a number?What am I doing wrong? Thank you - Frank --- The Preceeding Email Has Been Scanned and Verified By QBOS Security Systems --- QBOS, Inc. 14275 Midway Rd.Suite 220 Addison, TX 75001 972.233.5066 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ArrayLen
From: Frank Dewey I've got an easy one (for yall anyway).I'm trying to loop through an array and check a value...but I'm doing somnething syntactically incorect...I've looked and output the value but I still don't understand what's going on.Here's what I've got: cfloop From=1 to=ArrayLen(S1Array) index=i cfif s1 EQ S1Array[i] AND S3Array[i] EQ 0 cfset hasSibling = true hasSibling: #hasSibling#br /cfif /cfloop You're missing the #'s cfloop From=1 to=#ArrayLen(S1Array)# index=i [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ArrayLen
Actually, I've just figured it out...I forgot that #s go in the quotes Regards - Frank From: Frank Dewey [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 7:48 AM To: CF-Talk Subject: ArrayLen Hello all, I've got an easy one (for yall anyway).I'm trying to loop through an array and check a value...but I'm doing somnething syntactically incorect...I've looked and output the value but I still don't understand what's going on.Here's what I've got: cfloop From=1 to=ArrayLen(S1Array) index=i cfif s1 EQ S1Array[i] AND S3Array[i] EQ 0 cfset hasSibling = true hasSibling: #hasSibling#br /cfif /cfloop it's complaining: The value of the attribute TO is invalid. The value cannot be converted to a numeric because it is not a simple value.Simple values are booleans, numbers, strings, and date-time values when I output ArrayLen(S1Array) I get 7...so I know that this is a valid array and should be a number?What am I doing wrong? Thank you - Frank --- The Preceeding Email Has Been Scanned and Verified By QBOS Security Systems --- QBOS, Inc. 14275 Midway Rd.Suite 220 Addison, TX 75001 972.233.5066 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ArrayLen
tw, Thanx for the quick reply...I figured it out and sent an emai as soon as I did...but you had already replied!My email server is a little slow getting out From: tony weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 7:50 AM To: CF-Talk Subject: Re: ArrayLen need #'s around functions when they are part of that looping mechanism. tw -- Original Message -- From: Frank Dewey [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Wed, 2 Jun 2004 07:47:50 -0500 Hello all, I've got an easy one (for yall anyway).I'm trying to loop through an array and check a value...but I'm doing somnething syntactically incorect...I've looked and output the value but I still don't understand what's going on.Here's what I've got: cfloop From=1 to=ArrayLen(S1Array) index=i cfif s1 EQ S1Array[i] AND S3Array[i] EQ 0 cfset hasSibling = true hasSibling: #hasSibling#br /cfif /cfloop it's complaining: The value of the attribute TO is invalid. The value cannot be converted to a numeric because it is not a simple value.Simple values are booleans, numbers, strings, and date-time values when I output ArrayLen(S1Array) I get 7...so I know that this is a valid array and should be a number?What am I doing wrong? Thank you - Frank --- The Preceeding Email Has Been Scanned and Verified By QBOS Security Systems --- QBOS, Inc. 14275 Midway Rd.Suite 220 Addison, TX 75001 972.233.5066 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ArrayLen
thanx for the quick responce Phillip...I'm a beggining CF programmer and I forgot about thos dang #s! From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 7:57 AM To: CF-Talk Subject: RE: ArrayLen From: Frank Dewey I've got an easy one (for yall anyway).I'm trying to loop through an array and check a value...but I'm doing somnething syntactically incorect...I've looked and output the value but I still don't understand what's going on.Here's what I've got: cfloop From=1 to=ArrayLen(S1Array) index=i cfif s1 EQ S1Array[i] AND S3Array[i] EQ 0 cfset hasSibling = true hasSibling: #hasSibling#br /cfif /cfloop You're missing the #'s cfloop From=1 to=#ArrayLen(S1Array)# index=i [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Array error
Why do I get this error?: An error occurred while evaluating the _expression_: session.item[variables.arrayLength+1][1]=form.qty Error resolving parameter VARIABLES.ARRAYLENGTH. The specified variable name cannot be found. for the bold line below. I'n new to arrays so any insight would be great! Thanks. Robert at HWW ¿ cfset session.item[variables.arrayLength+1][1]=form.qty cfset session.item[variables.arrayLength+1][2]=form.item cfset session.item[variables.arrayLength+1][3]=form.priceeach CFLOOP from=1 to=#arraylen(session.item)# index=i step=1 table border=0 cellspacing=0 width=440 cellpadding=2 tr td width=70 bgcolor=##FFF3CC align=center font face=Arial size=2#session.item[i][1]#/font /td td width=300 bgcolor=##FFF3CC align=center font face=Arial size=2#session.item[i][2]#/font /td td width=70 bgcolor=##FFF3CC align=center font face=Arial size=2#session.item[i][3]#/font /td td width=70 bgcolor=##FFF3CC align=center font face=Arial size=2 a href="" img src="" alt=REMOVE border=0/a/font /td /td /tr /table /cfloop [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Array error
Well the obvious question is - are you sure variables.arrayLength exists? It must not. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: loginstorage
Bah, that's it...checked version and its 6,0,0,48097 ... Do you know if 6.1 breaks anything from 6.0? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 5:38 PM To: CF-Talk Subject: RE: loginstorage I think you must be using MC 6.0 instead. Do you get a simular error trying to use the wrap() function? If so - definitely 6.0. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: loginstorage
6.0 - 6.1 is an incredibly painless upgrade. Make a backup, of course, but you should find the process wonderfully uneventful. --- Ben _ From: Coleman, Brian [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 9:31 AM To: CF-Talk Subject: RE: loginstorage Bah, that's it...checked version and its 6,0,0,48097 ... Do you know if 6.1 breaks anything from 6.0? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 5:38 PM To: CF-Talk Subject: RE: loginstorage I think you must be using MC 6.0 instead. Do you get a simular error trying to use the wrap() function? If so - definitely 6.0. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
rualivecftalk
speak to me cftalk, are you alive today tony r e v o l u t i o n w e b d e s i g n [EMAIL PROTECTED] www.revolutionwebdesign.com its only looks good to those who can see bad as well -anonymous [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: rualivecftalk
7 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 9:45 AM To: CF-Talk Subject: rualivecftalk speak to me cftalk, are you alive today tony r e v o l u t i o n w e b d e s i g n [EMAIL PROTECTED] www.revolutionwebdesign.com its only looks good to those who can see bad as well -anonymous _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: rualivecftalk
On Jun 2, 2004, at 9:45 AM, Tony Weeg wrote: speak to me cftalk, are you alive today No. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Adding a timestamp to images
As a follow-up.The DRK 4 has a cf wrapper to the Java Advanced Image api in it that does exactly what I was wanting and more.Oh well, at least I learned something in the process. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: rualivecftalk
From: Tony Weeg speak to me cftalk, are you alive today You've already asked one question (and had answers) and answered a question yourself... What makes you think that the list is dead? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: rualivecftalk
because i havent gotten your reply, and had to go the hof site to get it :) and mike tangorre isnt getting emails from the list. and its cloudy out. any more reasons necessary? me [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Adding a timestamp to images
And that is more valuable than money - Original Message - From: Marlon Moyer To: CF-Talk Sent: Wednesday, June 02, 2004 10:08 AM Subject: Re: Adding a timestamp to images As a follow-up.The DRK 4 has a cf wrapper to the Java Advanced Image api in it that does exactly what I was wanting and more.Oh well, at least I learned something in the process. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: rualivecftalk
All your list are belong to us. -- Howard Fore, [EMAIL PROTECTED] On Jun 2, 2004, at 9:45 AM, Tony Weeg wrote: speak to me cftalk, are you alive today [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Returning XML via webservice, cont
Dear List, I saw this thread a few days ago, about returning an XML document as a string from a CFC.I tried using returntype=any and the toString() function - neither worked.What ends up happening is that the XML document gets returned as a WDDX packet.Is it possible to just return it as a string, with no further changes? Here is the XML doc: http://www.graddiv.ucsb.edu/ssoNavigation.xml Here is the simplified CFC code: cfcomponent extends=base cffunction name=getNavigation access=remote returntype=void output=false cffile action="" file=#path#ssoNavigation.xml variable=myString / cfreturn toString(myString) / /cffunction /cfcomponent The cfc is located here: http://www.graddiv.ucsb.edu/sso.cfc Thanks! Chris -- *** Chris Dempsey Director, Information Services UCSB Graduate Division Quis custodiet ipsos custodies [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
DataLabelFormat and CFX_GraphicsServer
We have an internal CF5 application that uses the CFX_GraphicsServer (version 1, I believe) that I'm using on a new page. I'm having some issues with a bar graph and labeling the data. Here's the code for the tag I'm using: CFX_GraphicsServer graphType=3 gridStyle=3 graphBackStyle=0 leftTitle=¥Balance Due¥ leftTitleStyle=1 bottomTitle=¥Days in A/R¥ subTitleFontSize=100 height=250 width=550 barGap_2d=20 backColor=15 domain=#the_domain# query=getData DB_DataSets=balanceTotal db_xLabelSet=daysText db_urlSets=url dataLabels=1 dataLabelFormat=0.00 LabelYFormat=\#currencyUnit#0.00\M DB_dataLabelSets=balanceTotal That should display a 2-d vertical bar graph with the each bar labeled with the data value.Now, my 2 issues: 1) We want a 3-d bar graph, but when I go to a 3-d bar graph (graphType=4), the data labels disappear. Can 3-d bar graphs show data labels? The documentation doesn't mention such a restriction. 2) On the 2-d bar graph, the data comes out as something like .92345201 (it's in millions of euros, hence the long decimal value).We'd like to format it similar to CF's DecimalFormat. (with only 2 digits after the decimal)That works for the LabelYFormat attribute we have, but I can't seem to get any variation of dataLabelFormat to work.No matter what I do, the data comes across in the same long value.Any idea why that might happen? Thanks! Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: rualivecftalk
At 10:15 AM 6/2/2004, you wrote: All your list are belong to us. Yes CF-Talk is alive because it runs on the best CFML framework: FuseBox .dsp files. -- Howard Fore, [EMAIL PROTECTED] On Jun 2, 2004, at 9:45 AM, Tony Weeg wrote: speak to me cftalk, are you alive today -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:165252This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=808.728.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=38 511ffe7.jpg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: rualivecftalk
dude. are you nuts. that's like throwing gas on a fire. debate war.down.no fusebox is best war please. tony Tony Weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] 410.548.2337 www.navtrak.net -Original Message- From: Alexander Sherwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 10:28 AM To: CF-Talk Subject: Re: rualivecftalk At 10:15 AM 6/2/2004, you wrote: All your list are belong to us. Yes CF-Talk is alive because it runs on the best CFML framework: FuseBox .dsp files. -- Howard Fore, [EMAIL PROTECTED] On Jun 2, 2004, at 9:45 AM, Tony Weeg wrote: speak to me cftalk, are you alive today -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:165252This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=808.728.4 Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=38 511ffe7.jpg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: rualivecftalk
any more reasons necessary? Yes, some too zeleous spam filter. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Returning XML via webservice, cont
Why is your function return type void it should be string if you want to return a string[Tom Kitta] . Change it to string and give it a go. TK -Original Message- From: Chris Dempsey [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 10:24 AM To: CF-Talk Subject: Returning XML via webservice, cont Dear List, I saw this thread a few days ago, about returning an XML document as a string from a CFC.I tried using returntype=any and the toString() function - neither worked.What ends up happening is that the XML document gets returned as a WDDX packet.Is it possible to just return it as a string, with no further changes? Here is the XML doc: http://www.graddiv.ucsb.edu/ssoNavigation.xml Here is the simplified CFC code: cfcomponent extends=base cffunction name=getNavigation access=remote returntype=void output=false cffile action="" file=#path#ssoNavigation.xml variable=myString / cfreturn toString(myString) / /cffunction /cfcomponent The cfc is located here: http://www.graddiv.ucsb.edu/sso.cfc Thanks! Chris -- *** Chris Dempsey Director, Information Services UCSB Graduate Division Quis custodiet ipsos custodies [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
(DONE) RE: rualivecftalk
im getting some now, but its sporadic, seems good tho, for past 10 min. we shall see. anyway, thanks. tony Tony Weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] 410.548.2337 www.navtrak.net -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 10:29 AM To: CF-Talk Subject: Re: rualivecftalk any more reasons necessary? Yes, some too zeleous spam filter. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: rualivecftalk
At 10:30 AM 6/2/2004, you wrote: dude. are you nuts. that's like throwing gas on a fire. debate war.down.no fusebox is best war please. But it's true. CFMX works best with FuseDoc'ed FuseBox 4.0 .qry and .dsp files. tony Tony Weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] 410.548.2337 www.navtrak.net -Original Message- From: Alexander Sherwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 10:28 AM To: CF-Talk Subject: Re: rualivecftalk At 10:15 AM 6/2/2004, you wrote: All your list are belong to us. Yes CF-Talk is alive because it runs on the best CFML framework: FuseBox .dsp files. -- Howard Fore, [EMAIL PROTECTED] On Jun 2, 2004, at 9:45 AM, Tony Weeg wrote: speak to me cftalk, are you alive today -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:165252This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=808.728.4 Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=38 511ffe7.jpg -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:165256This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=808.728.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=38 [] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: rualivecftalk
From: Alexander Sherwood Yes CF-Talk is alive because it runs on the best CFML framework: FuseBox .dsp files. I thought most of it was handled by the IMS mail server [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Tiny urls from HoF site
funny. i built the same kinda thing, and am about to launch @ www.antiwrap.com coming soon :) see ya. tw Maybe I'm just the last guy to find out about this and everyone knows already, but I found this today hiding at the bottom of Michael's web site. http://houseoffusion.com/tinyurl.cfm Kinda cool.Is this for general use or just a temp experiment/toy? Cheers, -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: rualivecftalk
On Jun 2, 2004, at 10:30 AM, Tony Weeg wrote: debate war.down.no fusebox is best war please. But it is! :^) -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: rualivecftalk
Yes CF-Talk is alive because it runs on the best CFML framework: FuseBox .dsp files. more like most cumbersome framework ... :P hehehe (bring it on!) - Greg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: rualivecftalk
At 10:40 AM 6/2/2004, you wrote: From: Alexander Sherwood Yes CF-Talk is alive because it runs on the best CFML framework: FuseBox .dsp files. I thought most of it was handled by the IMS mail server Yes, but the IMS Mail Server is built on a OOP-based inherited has a (not is a) relationship model that runs on FuseBox .fbx config files. -- Alex Sherwood PHS Collection Agency THE COLLECTORS P:813-283-4579 F:301.664.6834 W: www.phs-net.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Error on Array
Why am I getting this error? What does it mean please? An error occurred while evaluating the _expression_: session.item=#ArrayDeleteAt(session.item,1)# Parameter 1 of function ArrayDeleteAt which is now YES must be an array. The error occurred while processing an element with a general identifier of (CFSET), I want to delete a row in the Array and am using this code after user clicks the remove button: CFIF IsDefined(form.remove.x) CFSET session.item=#ArrayDeleteAt(session.item,1)# /cfif Roberto O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Error on Array
At 10:51 AM 6/2/2004, you wrote: Why am I getting this error? What does it mean please? An error occurred while evaluating the _expression_: session.item=#ArrayDeleteAt(session.item,1)# Parameter 1 of function ArrayDeleteAt which is now YES must be an array. The error occurred while processing an element with a general identifier of (CFSET), Id the variable session.item an Array? I want to delete a row in the Array and am using this code after user clicks the remove button: CFIF IsDefined(form.remove.x) CFSET session.item=#ArrayDeleteAt(session.item,1)# /cfif Roberto O. -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:165266This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=808.728.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=38 52e7722.jpg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Returning XML via webservice, cont
Oops, wrong version of the function.Here is the right code: cffunction name=getNavigation2 access=remote returntype=any output=false cffile action="" file=D:\inetpub\wwwroot\ssoNavigation.xml variable=myString / cfreturn toString(myString) / /cffunction On Wed, 2 Jun 2004, Tom Kitta wrote: Why is your function return type void it should be string if you want to return a string[Tom Kitta] . Change it to string and give it a go. TK -Original Message- From: Chris Dempsey [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 10:24 AM To: CF-Talk Subject: Returning XML via webservice, cont Dear List, I saw this thread a few days ago, about returning an XML document as a string from a CFC.I tried using returntype=any and the toString() function - neither worked.What ends up happening is that the XML document gets returned as a WDDX packet.Is it possible to just return it as a string, with no further changes? Here is the XML doc: http://www.graddiv.ucsb.edu/ssoNavigation.xml Here is the simplified CFC code: cfcomponent extends=base cffunction name=getNavigation access=remote returntype=void output=false cffile action="" file=#path#ssoNavigation.xml variable=myString / cfreturn toString(myString) / /cffunction /cfcomponent The cfc is located here: http://www.graddiv.ucsb.edu/sso.cfc Thanks! Chris -- *** Chris Dempsey Director, Information Services UCSB Graduate Division Quis custodiet ipsos custodies [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
caching..
Shouldnt setting the template cache size in administraor to 0 prevent caching? This server is just for my testing, and I don't want anything cached. I deleted a file, but coldfusion seems to of cached it because it still displays even though the file doesnt exist! -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: caching..
you want to worry about trusted cache. template cache, I don't think, produces the problem ur seeing, or maybe it does and just not in my experimentation. tony Tony Weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] 410.548.2337 www.navtrak.net -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 11:06 AM To: CF-Talk Subject: caching.. Shouldnt setting the template cache size in administraor to 0 prevent caching? This server is just for my testing, and I don't want anything cached. I deleted a file, but coldfusion seems to of cached it because it still displays even though the file doesnt exist! -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: Error on Array
Original Message: From: Robert Orlini Why am I getting this error? What does it mean please? An error occurred while evaluating the _expression_: session.item=#ArrayDeleteAt(session.item,1)# Parameter 1 of function ArrayDeleteAt which is now YES must be an array. The error occurred while processing an element with a general identifier of (CFSET), I want to delete a row in the Array and am using this code after user clicks the remove button: CFIF IsDefined(form.remove.x) CFSET session.item=#ArrayDeleteAt(session.item,1)# /cfif ArrayDeleteAt() returns Yes when it completes.So, in your code, once you delete from the array once, session.item is no longer an array, but is Yes. So, the next time that ArrayDeleteAt() code runs, session.item is not an array and throws the error you got. Change your cfset to something like cfset tmp = ArrayDeleteAt(session.item,1) (I'm not sure, but I don't even think you need the tmp = in there, but I always do it to be safe) Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFQUERY - MySQL Chicken and Egg
Ah... so the truth comes out - as the Gestapo said to the grandfather clock ... ve haf vays to make you tock... -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 7:52 AM To: CF-Talk Subject: RE: CFQUERY - MySQL Chicken and Egg I'm a liar, I admit it. You can create new databases through CF DSNs with MySQL as well.You can issue a CREATE DATABASE name from any connection that was authenticated via an account with sufficient privileges.However, since it seemed unlikely Nick had already created a different database and set up a DNS to it, I didn't want to confuse the issue. Cheers, barneyb -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 5:43 AM To: CF-Talk Subject: RE: CFQUERY - MySQL Chicken and Egg Not exactly true that you have to use the native interface for all rdbms's.In MsSQL (and other rdbms's)if you have the proper permissions you can create multiple databases and use them from a single datasource. The reason it's not often done is that you must know something about the physical location of the .mdf and .ldf files because MSSQL requires a location to be specifified.You must also change around the typical syntax and include the db name in your queries (dbname.username.tablename instead of just tablename or username.tablename).And you have to futz with the permissions. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Redirect to page based on URL...
I have a client the currently has two domain names pointing to the same site.They've now asked me to redirect one of the names to a specific file down inside the site. I'm pretty sure this is something that I can do with cfhttp or one of the related tags, but I'm not exactly sure how to pull this off.. www.name1.com would go to www.mysite.com/index.cfm page as normal www.name2.com would redirect to www.mysite.com/somefolder/somefile.cfm Pointers? Thanks in advance. -- Les Mizzell --- Do geeks die when exposed to sunlight? --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Error on Array
Because ArrayDeleteAt doesn't return an array but a boolean! If you run the code twice, the array has disappeared. Just do cfset tmp = ArrayDeleteAt(session.item,1) -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: woensdag 2 juni 2004 16:52 To: CF-Talk Subject: Error on Array Why am I getting this error? What does it mean please? An error occurred while evaluating the _expression_: session.item=#ArrayDeleteAt(session.item,1)# Parameter 1 of function ArrayDeleteAt which is now YES must be an array. The error occurred while processing an element with a general identifier of (CFSET), I want to delete a row in the Array and am using this code after user clicks the remove button: CFIF IsDefined(form.remove.x) CFSET session.item=#ArrayDeleteAt(session.item,1)# /cfif Roberto O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Redirect to page based on URL...
If you need to use CF, you can probably utilize CGI.SERVER_NAME which should have the host name.Otherwise, you can set something up in IIS. CFHTTP isn't needed for this, and probably wouldn't be much help, especially if you are utilizing state for anything. Cfif findNoCase(name2.com,cgi.server_name)cflocation /cfif -dov _ From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 11:08 AM To: CF-Talk Subject: Redirect to page based on URL... I have a client the currently has two domain names pointing to the same site.They've now asked me to redirect one of the names to a specific file down inside the site. I'm pretty sure this is something that I can do with cfhttp or one of the related tags, but I'm not exactly sure how to pull this off.. www.name1.com would go to www.mysite.com/index.cfm page as normal www.name2.com would redirect to www.mysite.com/somefolder/somefile.cfm Pointers? Thanks in advance. -- Les Mizzell --- Do geeks die when exposed to sunlight? --- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Redirect to page based on URL...
You can do it simply: cfif (#cgi.server_name# EQ www.name1.com) cflocation url=""> cfelseif (#cgi.server_name# EQ www.name2.com) cflocation url=""> /cfif Eric _ From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 11:08 AM To: CF-Talk Subject: Redirect to page based on URL... I have a client the currently has two domain names pointing to the same site.They've now asked me to redirect one of the names to a specific file down inside the site. I'm pretty sure this is something that I can do with cfhttp or one of the related tags, but I'm not exactly sure how to pull this off.. www.name1.com would go to www.mysite.com/index.cfm page as normal www.name2.com would redirect to www.mysite.com/somefolder/somefile.cfm Pointers? Thanks in advance. -- Les Mizzell --- Do geeks die when exposed to sunlight? --- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Redirect to page based on URL...
So in your top level default file you'd have something like: cfswitch _expression_=#cgi.server_name# cfcase value=www.name1.com cflocation url=""> /cfcase cfcase value=www.name2.com cflocation url=""> /cfcase /cfswitch You'll need to make sure that you name1 relocates to a different file than the default one else you'll setup an infinite loop and it'll get nasty, That help? John. -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: 02 June 2004 16:08 To: CF-Talk Subject: Redirect to page based on URL... I have a client the currently has two domain names pointing to the same site.They've now asked me to redirect one of the names to a specific file down inside the site. I'm pretty sure this is something that I can do with cfhttp or one of the related tags, but I'm not exactly sure how to pull this off.. www.name1.com would go to www.mysite.com/index.cfm page as normal www.name2.com would redirect to www.mysite.com/somefolder/somefile.cfm Pointers? Thanks in advance. -- Les Mizzell --- Do geeks die when exposed to sunlight? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Redirect to page based on URL...
#cgi.HTTP_HOST# is probably what you're looking for. Do something simple like: cfif #cgi.http_host# EQ name2.com OR #cgi.http_host EQ www.name2.com cflocation url="" / /cfif I'm not 100% certain on it though, I don't have anything like that set up on our server. Note that I don't think #CGI.SERVER_NAME# is what you want - that's the name of the domain configured in the web server, whereas #cgi.http_host# I would imagine would store the hostname portion of the URL.Of course I could be completely wrong ;) How is name2.com set to point to the site - via DNS and a static IP address or a virtual host on the server?If the server knows of the domain and handles it via a virtual host then #cgi.server_name# ought to also work, otherwise I think you need to use #cgi.host_name#. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Difficult SQL Question
Thanks Pascal, I'll give these a shot. Cedric Subject: Difficult SQL Question From: Pascal Peters [EMAIL PROTECTED] Date: Wed, 2 Jun 2004 10:31:02 +0200 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=32925forumid=4#165218 If your db supports it, you can use INTERSECT SELECT TicketID FROM fields WHERE FieldID = 1 AND Value = '5' INTERSECT SELECT TicketID FROM fields WHERE FieldID = 2 AND Value = 'Hello' Alternatively you could use group by (supposing (TicketID, FieldID) is unique) SELECT TicketID FROM fields WHERE 0 = 1 OR (FieldID = 1 AND Value = '5') OR (FieldID = 2 AND Value = 'Hello') GROUP BY TicketID HAVING COUNT(TicketID) = 2 You can also use subqueries SELECT * FROM tickets WHERE 0 = 0 AND TicketID IN ( SELECT TicketID FROM fields WHERE FieldID = 1 AND Value = '5' ) AND TicketID IN ( SELECT TicketID FROM fields WHERE FieldID = 2 AND Value = 'Hello' ) I didn't want to type to much, so there are some modifications you should make to the code: - Use cfqueryparam everywhere - Don't use SELECT * but specify the columns you want - In the group by example COUNT() has to be the number of fields you want to search on -Original Message- From: Cedric Villat [mailto:[EMAIL PROTECTED] Sent: woensdag 2 juni 2004 2:01 To: CF-Talk Subject: Difficult SQL Question Ok, I have a bit of a problem with some SQL I'm trying to build. I have a table of Tickets, and then a table with a list of fields that are associated with tickets. Here are some values for the fields table: What I want to do is select the TicketID's that have a (FieldID = 1 AND Value LIKE 'Hello') AND (FieldID = 2 AND Value = 5). In this case I would want Ticket #1 returned. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFX_ConsoleCommand and CFX_Execute
I'm trying to find an alternative to cfexecute (which doesn't work well with some commands, I've found), and I'm now looking at CFX_ConsoleCommand and CFX_Execute (both at http://www.intrafoundation.com/coldfusion.html). Two questions: How do these tags differ, and what do I do with the downloads? It looks like they're in C++ source code, which I don't know how to configure and compile, etc. Is this really what I'm expected to do? Can anyone compile these for me and send me the dll, or is that not even possible? Any tips? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Output formatting question
I have the following code. Everything works fine but when I output to the web page the first line appears to be right justified. I tried putting an align left in the td tag on the first line but that was even worse. I simply want to have a Image field with a caption text that is all data driven. td width=600 height=375 valign=top bgcolor=ff cfoutput h3#getpage.header#/h3 p cfif #getpage.image# NEQ '' div style=float:right; table width=275 tr td width=5/td td align=leftimg src="" border=0br cfset formattedcap=replace(#getpage.image_cap#,#chr(10)#,BR,ALL)font size=1 color=66 #formattedcap# /font /td /tr /table /div /cfif cfset formattedcontent=replace(#getpage.content#,#chr(10)#,BR,ALL)#formattedcontent# /p /cfoutput pnbsp;/p /td [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: css idiot question
Dear Tony, This should be the correct syntax (although I personally do not like parts of code here an there on elements) . div style=background:#53;width:100%;height:100%; > > id=td1 New Applicant /div this refers to the DIV element directly :-) _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 6:22 AM To: CF-Talk Subject: css idiot question maybe its just too late, but why does this div not change background and font color, when mouseover'ed div style=background:#53;width:100%;height:100%; > id=td1 New Applicant /div thanks! tony r e v o l u t i o n w e b d e s i g n [EMAIL PROTECTED] www.revolutionwebdesign.com its only looks good to those who can see bad as well -anonymous _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFX_ConsoleCommand and CFX_Execute
Your install them as CFX custom tags. They do come with the DLL. you need. If you mail me off list I can send you an Updated DLL what will allow you to get Output 1 2 out in the return. Cheers _ Mr Kev McCabe Senior ETV Developer, British Sky Broadcasting First Floor North East, West Cross House Grant Way Isleworth Middlesex TW7 5QD [EMAIL PROTECTED] http://www.sky.com http://www.sky.com/ tel: +44 (0) 20 7941 5329 fax: +44 (0) 20 7941 5243 _ -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: 02 June 2004 16:59 To: CF-Talk Subject: CFX_ConsoleCommand and CFX_Execute I'm trying to find an alternative to cfexecute (which doesn't work well with some commands, I've found), and I'm now looking at CFX_ConsoleCommand and CFX_Execute (both at http://www.intrafoundation.com/coldfusion.html). Two questions: How do these tags differ, and what do I do with the downloads? It looks like they're in C++ source code, which I don't know how to configure and compile, etc. Is this really what I'm expected to do? Can anyone compile these for me and send me the dll, or is that not even possible? Any tips? Thanks, Jamie _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFX_ConsoleCommand and CFX_Execute
Based on your signature Kev, is Sky Active etc running on CF? -Original Message- From: Kev McCabe [mailto:[EMAIL PROTECTED] Sent: 02 June 2004 17:07 To: CF-Talk Subject: RE: CFX_ConsoleCommand and CFX_Execute Your install them as CFX custom tags. They do come with the DLL. you need. If you mail me off list I can send you an Updated DLL what will allow you to get Output 1 2 out in the return. Cheers _ Mr Kev McCabe Senior ETV Developer, British Sky Broadcasting First Floor North East, West Cross House Grant Way Isleworth Middlesex TW7 5QD [EMAIL PROTECTED] http://www.sky.com http://www.sky.com/ tel: +44 (0) 20 7941 5329 fax: +44 (0) 20 7941 5243 _ -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: 02 June 2004 16:59 To: CF-Talk Subject: CFX_ConsoleCommand and CFX_Execute I'm trying to find an alternative to cfexecute (which doesn't work well with some commands, I've found), and I'm now looking at CFX_ConsoleCommand and CFX_Execute (both at http://www.intrafoundation.com/coldfusion.html). Two questions: How do these tags differ, and what do I do with the downloads? It looks like they're in C++ source code, which I don't know how to configure and compile, etc. Is this really what I'm expected to do? Can anyone compile these for me and send me the dll, or is that not even possible? Any tips? Thanks, Jamie _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Recursive function and Hierarchical navigation
If you have the option of using SQL Server, try to create a stored procedure and return all records at once as raw data. Use ColdFusion to regain hierarchy, for ex. using structures and arrays, and you will have the highest performance available. It is all about minimizing database calls :-) _ From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 2:40 PM To: CF-Talk Subject: Re: Recursive function and Hierarchical navigation Yeah! Play with it in a SQL GUI until you get it the way you want it, then enclose it within cfquery.../cfquery tags. Most of these (Celko's) techniques are quite fast -- seems a little odd at first, but it compensates for RDBMS's inherent weakness when handling hierarchical data. I suggest you include lotsa' comments to explain what why. HTH Dick On Jun 2, 2004, at 5:28 AM, Nicholas Watson wrote: How do you return a record set like this back to ColdFusion? Do you just use a cfquery tag? I tried the example, and it's much faster than what we are currently doing, but how do I handle it on the ColdFusion side? This is SQL-Server specific: http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm If you want some general discussions on the topic google for celkoand trees or hierarchical or nested sets HTH Dick On Jun 1, 2004, at 11:22 PM, Paul Wilson wrote: _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Array error
Dear Robert, What does this code return to you? cfif IsDefined(variables.arrayLength) Variable exists cfelse Variable does not exist /cfif _ From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 3:11 PM To: CF-Talk Subject: Array error Why do I get this error?: An error occurred while evaluating the _expression_: session.item[variables.arrayLength+1][1]=form.qty Error resolving parameter VARIABLES.ARRAYLENGTH. The specified variable name cannot be found. for the bold line below. I'n new to arrays so any insight would be great! Thanks. Robert at HWW ¿ cfset session.item[variables.arrayLength+1][1]=form.qty cfset session.item[variables.arrayLength+1][2]=form.item cfset session.item[variables.arrayLength+1][3]=form.priceeach CFLOOP from=1 to=#arraylen(session.item)# index=i step=1 table border=0 cellspacing=0 width=440 cellpadding=2 tr td width=70 bgcolor=##FFF3CC align=center font face=Arial size=2#session.item[i][1]#/font /td td width=300 bgcolor=##FFF3CC align=center font face=Arial size=2#session.item[i][2]#/font /td td width=70 bgcolor=##FFF3CC align=center font face=Arial size=2#session.item[i][3]#/font /td td width=70 bgcolor=##FFF3CC align=center font face=Arial size=2 a href="" img src="" alt=REMOVE border=0/a/font /td /td /tr /table /cfloop _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Output formatting question
The float:right is the culprit. An easier way to accomplish what you are trying is to use a master container with two containers within it: 1 for the image, 1 for the caption. div class=image-caption-container div class=imagesome image/div div class=caption span class=captionsome caption text/span /div /div Then apply your styles to the master container to position both the image abd captio... And use the span tag's class attribute to control the font color and such... It will clean up your code below quite nicely. HTH, Mike I have the following code. Everything works fine but when I output to the web page the first line appears to be right justified. I tried putting an align left in the td tag on the first line but that was even worse. I simply want to have a Image field with a caption text that is all data driven. td width=600 height=375 valign=top bgcolor=ff cfoutput h3#getpage.header#/h3 p cfif #getpage.image# NEQ '' div style=float:right; table width=275 tr td width=5/td td align=leftimg src="" border=0br cfset formattedcap=replace(#getpage.image_cap#,#chr(10)#,BR,A LL)font size=1 color=66 #formattedcap# /font /td /tr /table /div /cfif cfset formattedcontent=replace(#getpage.content#,#chr(10)#,BR, ALL)#formattedcontent# /p /cfoutput pnbsp;/p /td [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Coldfusion and MX
vishnu prasad wrote: i am new to Flash i like to develop and application using flash and coldfusion if anyone familar with that will u pls tell me how to develop simple I highly recommend Jeanette Stallons book.. http://www.amazon.com/exec/obidos/ASIN/0321238346/arboinc It mirrors the RIA Flash training course that she developed for Macromedia (and the pre-conference one day training class she taught at last year's MAX conference). That'll help you a lot from the Flash side of things. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Returning XML via webservice, cont
I have tryed your function, with code: cffunction name=getNavigation access=remote returntype=any output=false cffile action="" file=c:\inetpub\wwwroot\tk\gb\data\data1.xml variable=myString cfreturn xmlFormat(toString(myString)) /cffunction Works fine. Try to copy above exactly, maybe it is your / at the tag ends. Check the actual XML file, what is in it. Etc. Function works fine on CF6.1 TK http://www.tomkitta.com -Original Message- From: Christopher Dempsey [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 11:03 AM To: CF-Talk Subject: RE: Returning XML via webservice, cont Oops, wrong version of the function.Here is the right code: cffunction name=getNavigation2 access=remote returntype=any output=false cffile action="" file=D:\inetpub\wwwroot\ssoNavigation.xml variable=myString / cfreturn toString(myString) / /cffunction On Wed, 2 Jun 2004, Tom Kitta wrote: Why is your function return type void it should be string if you want to return a string[Tom Kitta] . Change it to string and give it a go. TK -Original Message- From: Chris Dempsey [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 10:24 AM To: CF-Talk Subject: Returning XML via webservice, cont Dear List, I saw this thread a few days ago, about returning an XML document as a string from a CFC.I tried using returntype=any and the toString() function - neither worked.What ends up happening is that the XML document gets returned as a WDDX packet.Is it possible to just return it as a string, with no further changes? Here is the XML doc: http://www.graddiv.ucsb.edu/ssoNavigation.xml Here is the simplified CFC code: cfcomponent extends=base cffunction name=getNavigation access=remote returntype=void output=false cffile action="" file=#path#ssoNavigation.xml variable=myString / cfreturn toString(myString) / /cffunction /cfcomponent The cfc is located here: http://www.graddiv.ucsb.edu/sso.cfc Thanks! Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Output formatting question
This would do style type=text/css #wrap{ position:relative; width:600; height:375; background:#fff; } #subwrap{ position:absolute; right:0; top:0; } #subwrap img{ margin:0 0 0 5px; border:0; } /style div id=wrap h3my subject/h3 div id=subwrap img src="" / /div /div _ From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 6:21 PM To: CF-Talk Subject: RE: Output formatting question The float:right is the culprit. An easier way to accomplish what you are trying is to use a master container with two containers within it: 1 for the image, 1 for the caption. div class=image-caption-container div class=imagesome image/div div class=caption span class=captionsome caption text/span /div /div Then apply your styles to the master container to position both the image abd captio... And use the span tag's class attribute to control the font color and such... It will clean up your code below quite nicely. HTH, Mike I have the following code. Everything works fine but when I output to the web page the first line appears to be right justified. I tried putting an align left in the td tag on the first line but that was even worse. I simply want to have a Image field with a caption text that is all data driven. td width=600 height=375 valign=top bgcolor=ff cfoutput h3#getpage.header#/h3 p cfif #getpage.image# NEQ '' div style=float:right; table width=275 tr td width=5/td td align=leftimg src="" border=0br cfset formattedcap=replace(#getpage.image_cap#,#chr(10)#,BR,A LL)font size=1 color=66 #formattedcap# /font /td /tr /table /div /cfif cfset formattedcontent=replace(#getpage.content#,#chr(10)#,BR, ALL)#formattedcontent# /p /cfoutput pnbsp;/p /td _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: caching..
Mike, What are the caching settings in your browser? If you do not load very much images dynamically(because of a MSIE bug) you should consider changing it to every visit to the page :) If you have trusted cache off, then ColdFusion is not the one who is giving you troubles. Also try to call the template with different url variables. Just dummy variables. Like index.cfm?a=b _ From: techmike [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 5:06 PM To: CF-Talk Subject: caching.. Shouldnt setting the template cache size in administraor to 0 prevent caching? This server is just for my testing, and I don't want anything cached. I deleted a file, but coldfusion seems to of cached it because it still displays even though the file doesnt exist! -Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
[Stats] CF-Talk: May 2004
Searchable archives for this list are available at http://www.listsearch.com/cf-talk.lasso CF-Talk Stats May, 2004 Note: Up/Down % as compared with April, 2004 Posts:3236 (Up0%) Authors:388 (Down 8%) Threads:646 (Up1%) Top 20 Contributors by Number of Posts -- Tony Weeg 120 Dave Watts117 Pascal Peters 87 Philip Arnold 81 Barney Boisvert78 Chunshen (Don) Li72 Dick Applebaum64 Claude Schneegans57 Thomas Chiverton 51 Burns, John D 48 Matt Robertson47 Daniel Kessler37 Dave Carabetta36 Ian Skinner36 Paul Vernon35 Bryan F. Hogan34 cf coder34 Rick Root33 Jochem van Dieten33 Robert Orlini 32 Top 20 Threads by Number of Posts -- Mach-II 52 Email Problem 34 CFMX Certification34 MS Access as a backend database 34 good error.cfm template33 CFFILE33 SOT - Last nights NYCFUG meeting.29 ColdFusion Developer Edition 28 help with string manipulation (Find,Replace)28 Huge dropdown list of names...type in name as well as selecting...27 Securing CF Apps against SQL Injection Cross Site Scripting 26 Challenge/Response and IIS Security24 Blue Dragon / Coral / CFMX23 oracle unique id or identity 23 Again Java CFX23 Microsoft acknowledges CF!22 PL/SQL stumper22 functions22 ugly truth 22 CFMODULE does not expose data?20 Top 20 Search Terms by Number of Requests -- SQL1 -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFX_ConsoleCommand and CFX_Execute
On Wed, 2 Jun 2004 17:07:04 +0100, in cf-talk you wrote: Your install them as CFX custom tags. They do come with the DLL. you need. Ack, you're right. I was looking in subdirectories that I thought were the root. :-/ If you mail me off list I can send you an Updated DLL what will allow you to get Output 1 2 out in the return. Okay, once I figure out what that means (and if I need it), I'll send you an email. Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFX_ConsoleCommand and CFX_Execute
Based on your signature Kev, is Sky Active etc running on CF? If Kev won't comment, then I'd better not either. But this is what Jeremy Allaire says: http://www.meetthemakers.com/conversations/allaire/2/ (second-last paragraph) Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Error on Array
Thanks Peter and others. How do I delete the entire ID? Here is my Array which I should have sent also sorry: cfset session.item[variables.arrayLength+1][1]=form.qty cfset session.item[variables.arrayLength+1][2]=form.item cfset session.item[variables.arrayLength+1][3]=form.priceeach I think cfset tmp = ArrayDeleteAt(session.item,1) just deletes the first item?? Robert O. -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 11:12 AM To: CF-Talk Subject: RE: Error on Array Because ArrayDeleteAt doesn't return an array but a boolean! If you run the code twice, the array has disappeared. Just do cfset tmp = ArrayDeleteAt(session.item,1) -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: woensdag 2 juni 2004 16:52 To: CF-Talk Subject: Error on Array Why am I getting this error? What does it mean please? An error occurred while evaluating the _expression_: session.item=#ArrayDeleteAt(session.item,1)# Parameter 1 of function ArrayDeleteAt which is now YES must be an array. The error occurred while processing an element with a general identifier of (CFSET), I want to delete a row in the Array and am using this code after user clicks the remove button: CFIF IsDefined(form.remove.x) CFSET session.item=#ArrayDeleteAt(session.item,1)# /cfif Roberto O. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: rualivecftalk
Yes CF-Talk is alive because it runs on the best CFML framework: FuseBox .dsp files. 1. I don't use fusebox and havn't since we created it in 98. No knock against it but I don't have a personal need for it. 2. This thread is ended. If anyone needs to see if the list is live, please just go to the archives (posted at the bottom of every message) and check the daily threads. -- Howard Fore, [EMAIL PROTECTED] On Jun 2, 2004, at 9:45 AM, Tony Weeg wrote: speak to me cftalk, are you alive today -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:165252This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=808.728.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=38 511ffe7.jpg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: cffun tickets
i have 2 cffun tickets, anyone want to go at a discount? make me an offer please reply to [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Structs Question
I was wondering if someone would be willing to point me to a good reference for building structs from queries. I have a product catalog that I am working on, and I think that I need to use a struct to get this to display correctly. The out put will look like this: First row will contain an empty cell, then x number of cells that represent sizes (sm-4xl) next row, first cell will have a color, then the price for each size of that color under the corresponding size. Thanks, Bruce [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: caching..
I'm using one of the nightly builds of Mozilla Firefox but it does the same in IE 6 also. Works with whatever varibles, in fact the template accesses a database and I've even queried the database thru the template..but the template doesnt exist..:) -Mike -Original Message- From: Micha Schopman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wed, 2 Jun 2004 18:22:14 +0200 Subject: RE: caching.. Mike, What are the caching settings in your browser? If you do not load very much images dynamically(because of a MSIE bug) you should consider changing it to every visit to the page :) If you have trusted cache off, then ColdFusion is not the one who is giving you troubles. Also try to call the template with different url variables. Just dummy variables. Like index.cfm?a=b _ From: techmike [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 5:06 PM To: CF-Talk Subject: caching.. Shouldnt setting the template cache size in administraor to 0 prevent caching? This server is just for my testing, and I don't want anything cached. I deleted a file, but coldfusion seems to of cached it because it still displays even though the file doesnt exist! -Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: rualivecftalk
At 01:02 PM 6/2/2004, you wrote: Yes CF-Talk is alive because it runs on the best CFML framework: FuseBox .dsp files. 1. I don't use fusebox and havn't since we created it in 98. No knock against it but I don't have a personal need for it. Sorry Mike. I couldn't resist. When someone asks R U Alive CF-Talk, there's no better way than to respond with a bit of inflamatory Use FuseBox or die verbage. I wholeheartedly know that CF-Talk is NOT run on FuseBox or some other Framework for that matter! I was hoping the vague reference to .dsp files would provide the [wink wink] needed, but some took this literally! On the other hand, I find that OnTap framework is better then fuseboxKIDDING! 2. This thread is ended. If anyone needs to see if the list is live, please just go to the archives (posted at the bottom of every message) and check the daily threads. -- Alex Sherwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFX_ConsoleCommand and CFX_Execute
MMM, One feels there could be an NDA here from my end . So I all I can say mm CF Coming to a Screen near you.(UK and EIRE) Sorry but Corporate stuff stops me from responding on a List ;-) _ Mr Kev McCabe Senior ETV Developer, Interactive Technology Development Application Development Team British Sky Broadcasting First Floor North East, West Cross House Grant Way Isleworth Middlesex TW7 5QD Email:[EMAIL PROTECTED] Web: http://www.sky.com http://www.sky.com/ Tel: +44 (0) 20 7941 5329 Fax: +44 (0) 20 7941 5243 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
upload a file explanation
I was given a piece of code that works, but I don't understand why it works, so I'm looking for an explanation. This code uploads a file and if it's too large, it directly the user to an error page.I know that the file has to be uploaded into memory before it can check file size but I don't see how the cfif check on the file size afterwards either comments or tosses the file upload.It does. cfif isdefined(Form.NewFile) cftry cfset CurrentDir=GetDirectoryFromPath(ExpandPath(*.*)) cffile action=""> filefield=NewFile destination=/#CurrentDir#/CrsMat/ accept=application/vnd.ms-powerpoint nameconflict=MakeUnique !--- if an unauthorized file type upload is attempted --- cfcatch type=Any cflocation url="" addtoken=No /cfcatch /cftry !--- check the CGI environment variable Content_Length to make sure the file being uploaded is less than 10 MB in size.If it is not, halt processing --- CFIF Val(CGI.CONTENT_LENGTH) GT 10485760 cflocation url="" addtoken=No CFABORT /CFIF There's no commit or anything like that after this.It just displays some of the cgi file-info. So how does this file size check, which happens after the file upload into memory, either ok or not-ok the file upload?I just don't get it. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Structs Question
use the SQL Luke!LOL!Yeah, try building SQL to do this, you can then use the GROUP attribute of cfoutput to display it correctly. a result set like this blk,sm,10 blk,med,15 blk,lg,20 wht,sm,10 wht,med,15 wht,lg,20 can be displayed as blk,10,15,20 wht,10,15,20 Doug -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 1:07 PM To: CF-Talk Subject: Structs Question I was wondering if someone would be willing to point me to a good reference for building structs from queries. I have a product catalog that I am working on, and I think that I need to use a struct to get this to display correctly. The out put will look like this: First row will contain an empty cell, then x number of cells that represent sizes (sm-4xl) next row, first cell will have a color, then the price for each size of that color under the corresponding size. Thanks, Bruce _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: css idiot question
actually, object.style.backgroundColor use the humback or camelback or whatever the term is for CSS properties in DHTML.So, for a style element named foo-goo-zoo, this becomes fooGooZoo in DHTML http://msdn.microsoft.com/workshop/author/dhtml/reference/properties/backgroundcolor.asp?frame=true is one decent ref for this stuff Doug -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 1:26 PM To: CF-Talk Subject: Re: css idiot question try this syntax td1.style.background='' i always catch myself using css syntax in js style changes too : ) - Original Message - From: Tony Weeg To: CF-Talk Sent: Wednesday, June 02, 2004 12:22 AM Subject: css idiot question maybe its just too late, but why does this div not change background and font color, when mouseover'ed div style=background:#53;width:100%;height:100%; > id=td1 New Applicant /div thanks! tony r e v o l u t i o n w e b d e s i g n [EMAIL PROTECTED] www.revolutionwebdesign.com its only looks good to those who can see bad as well -anonymous _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Returning XML via webservice, cont
Tom, I tried what you recommended, I have tried your method below, and it didn't work quite right.It still returns a WDDX packet, but now all of the XML is escaped.The XML file is at http://www.graddiv.ucsb.edu/ssoNavigation.xml and I am calling the below code with http://www.graddiv.ucsb.edu/sso.cfc?method=getNavigation Here is the code now.I tried it without using the closing / and it had no effect. cffunction name=getNavigation access=remote returntype=any displayname=Get SSO navigation XML document hint=This method retrieves an XML document used for SSO navigation bar. output=false cffile action="" file=D:\inetpub\wwwroot\ssoNavigation.xml variable=myString / cfreturn toString(myString) / /cffunction Totally bizarre.Also tried restarting the CF service and clearing the browser cache, no effect. Thanks, Chris cffunction name=getNavigation access=remote returntype=any output=false cffile action="" file=c:\inetpub\wwwroot\tk\gb\data\data1.xml variable=myString cfreturn xmlFormat(toString(myString)) /cffunction Works fine. Try to copy above exactly, maybe it is your / at the tag ends. Check the actual XML file, what is in it. Etc. Function works fine on CF6.1 TK http://www.tomkitta.com -- *** Chris Dempsey Director, Information Services UCSB Graduate Division Quis custodiet ipsos custodies [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Array error
I get: 1 Variable does not exist Robert O. -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 12:18 PM To: CF-Talk Subject: RE: Array error Dear Robert, What does this code return to you? cfif IsDefined('variables.arrayLength') Variable exists cfelse Variable does not exist /cfif _ From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 3:11 PM To: CF-Talk Subject: Array error Why do I get this error?: An error occurred while evaluating the _expression_: session.item[variables.arrayLength+1][1]=form.qty Error resolving parameter VARIABLES.ARRAYLENGTH. The specified variable name cannot be found. for the bold line below. I'n new to arrays so any insight would be great! Thanks. Robert at HWW ¿ cfset session.item[variables.arrayLength+1][1]=form.qty cfset session.item[variables.arrayLength+1][2]=form.item cfset session.item[variables.arrayLength+1][3]=form.priceeach CFLOOP from=1 to=#arraylen(session.item)# index=i step=1 table border=0 cellspacing=0 width=440 cellpadding=2 tr td width=70 bgcolor=##FFF3CC align=center font face=Arial size=2#session.item[i][1]#/font /td td width=300 bgcolor=##FFF3CC align=center font face=Arial size=2#session.item[i][2]#/font /td td width=70 bgcolor=##FFF3CC align=center font face=Arial size=2#session.item[i][3]#/font /td td width=70 bgcolor=##FFF3CC align=center font face=Arial size=2 a href="" img src="" alt=REMOVE border=0/a/font /td /td /tr /table /cfloop _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: css idiot question
twas exactly what I did...and fixed. thanks! tony Tony Weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] 410.548.2337 www.navtrak.net -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 1:26 PM To: CF-Talk Subject: Re: css idiot question try this syntax td1.style.background='' i always catch myself using css syntax in js style changes too : ) - Original Message - From: Tony Weeg To: CF-Talk Sent: Wednesday, June 02, 2004 12:22 AM Subject: css idiot question maybe its just too late, but why does this div not change background and font color, when mouseover'ed div style=background:#53;width:100%;height:100%; > id=td1 New Applicant /div thanks! tony r e v o l u t i o n w e b d e s i g n [EMAIL PROTECTED] www.revolutionwebdesign.com its only looks good to those who can see bad as well -anonymous [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Error on Array
No, it deletes the entire first row. Pascal -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: woensdag 2 juni 2004 18:56 To: CF-Talk Subject: RE: Error on Array Thanks Peter and others. How do I delete the entire ID? Here is my Array which I should have sent also sorry: cfset session.item[variables.arrayLength+1][1]=form.qty cfset session.item[variables.arrayLength+1][2]=form.item cfset session.item[variables.arrayLength+1][3]=form.priceeach I think cfset tmp = ArrayDeleteAt(session.item,1) just deletes the first item?? Robert O. -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 11:12 AM To: CF-Talk Subject: RE: Error on Array Because ArrayDeleteAt doesn't return an array but a boolean! If you run the code twice, the array has disappeared. Just do cfset tmp = ArrayDeleteAt(session.item,1) -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: woensdag 2 juni 2004 16:52 To: CF-Talk Subject: Error on Array Why am I getting this error? What does it mean please? An error occurred while evaluating the _expression_: session.item=#ArrayDeleteAt(session.item,1)# Parameter 1 of function ArrayDeleteAt which is now YES must be an array. The error occurred while processing an element with a general identifier of (CFSET), I want to delete a row in the Array and am using this code after user clicks the remove button: CFIF IsDefined(form.remove.x) CFSET session.item=#ArrayDeleteAt(session.item,1)# /cfif Roberto O. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Array error
So, where do you set the var arrayLength? Probably never Set it and your code will work. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: woensdag 2 juni 2004 19:31 To: CF-Talk Subject: RE: Array error I get: 1 Variable does not exist Robert O. -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 12:18 PM To: CF-Talk Subject: RE: Array error Dear Robert, What does this code return to you? cfif IsDefined('variables.arrayLength') Variable exists cfelse Variable does not exist /cfif [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: loginstorage
6.0 - 6.1 is an incredibly painless upgrade. Make a backup, of course, but you should find the process wonderfully uneventful. I happen to know a lot of people that would disagree with this - there were lots of problems with the database drivers shipped with 6.1. You'll want to test, just like with any other upgrade, and you'll want to either download the latest drivers from MM or vendor-specific drivers. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: upload a file explanation
cffile action=""> filefield=NewFile destination=/#CurrentDir#/CrsMat/ accept=application/vnd.ms-powerpoint nameconflict=MakeUnique This bit stores the file. CFIF Val(CGI.CONTENT_LENGTH) GT 10485760 cflocation url=""> addtoken=No CFABORT /CFIF This bit redirects to another fuseaction if the filesize is too big. The file is still stored in the destination folder as seen above, but no further processing on it is done. --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Returning XML via webservice, cont
I tryed the links you supplied and I got what I expected. Can you send me what you get as your browser response? Maybe you need to clear browser cache or something. I looked at the XML raw and one returned by your CFC call and they are the same minus the formatting of the actual XML (mine doesn't have the line feeds). Check it out and tell me whatever it works now, if it works for me it should for you, right? TK -Original Message- From: Christopher Dempsey [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 1:33 PM To: CF-Talk Subject: RE: Returning XML via webservice, cont Tom, I tried what you recommended, I have tried your method below, and it didn't work quite right.It still returns a WDDX packet, but now all of the XML is escaped.The XML file is at http://www.graddiv.ucsb.edu/ssoNavigation.xml and I am calling the below code with http://www.graddiv.ucsb.edu/sso.cfc?method=getNavigation Here is the code now.I tried it without using the closing / and it had no effect. cffunction name=getNavigation access=remote returntype=any displayname=Get SSO navigation XML document hint=This method retrieves an XML document used for SSO navigation bar. output=false cffile action="" file=D:\inetpub\wwwroot\ssoNavigation.xml variable=myString / cfreturn toString(myString) / /cffunction Totally bizarre.Also tried restarting the CF service and clearing the browser cache, no effect. Thanks, Chri [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: cffun tickets REVISION
sorry but there is only 1 cffun ticket available if still interested reply to [EMAIL PROTECTED] will answer back after i take kids too pool thanks sorry bout that i have 2 cffun tickets, anyone want to go at a discount? make me an offer please reply to [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]