RE: User Name and Password Routine
Agreed - security models vary tremendously. Sounds like you're just getting started though - I'd recommend checking out the CF_Login tag in the Dev Exchange for very basic protection (.cfm files only) to get started. From there, as Tony said - if you can provide more info on the application/security structure you'd like to create, there are lots of resources here to help provide some direction and details. Truman -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 12:06 PM To: CF-Talk Subject: RE: User Name and Password Routine Sean, That is a very open ended question. There are many ways to setup access control using db variables. You would have to divulge a little more information about your security schema and business needs. ie: - will you have multiple layers of access control or just one level of validation? - is this for an existing site (where you cannot restructure) or are you planning a new site where you can control directory structure? Any additional information will help get a thread going. :-) Tony Gruen -Original Message- From: Sean Percival [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 10:39 AM To: CF-Talk Subject: User Name and Password Routine All, Hey all, im glad I found this list, it seems to be a valuable resource. I'm currently creating a user name and password routine that interfaces with a access database. Does anyone have any experience with this or can anyone point me in a good direction to get started? Thanks, Sean Sean Percival Owner Paragon Matrix - Web and Graphic Design 877.498.6072 - phone [EMAIL PROTECTED] - email [EMAIL PROTECTED] - wireless email www.paragonmatrix.com - web ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: QUERY PROBLEM
Comparing dates are fun - here's a couple suggestions: -check your formatting of the date object you're comparing and format your where-clause date to be exactly the same format as appears in the DB (i.e. smalldate time, ODBC d/t obj. etc.); relying on the auto conversion within ODBC has yielded unpredictable results for me... -Make sure it's a Date/Time object in the DB... -Pass in (as defaults if necessary) all date/time elements that exist in the DB data (i.e. if seconds exist, have them in the compare value even if its :00... -If you want all games later than today, get rid of the = in your where clause(s) -If you only want the next (1) record, use the "top" function in the SQL to get the first record -It will help performance if you set up an index on your dates in the DB table... Hope these quick comments help. If I think of others I'll post 'em! Truman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 12:53 PM To: CF-Talk Subject: QUERY PROBLEM I am trying to pull the next baseball game from a schedule I have in an Access database. When it processes it pulls the next game to a degree. If there is a game today it will not pull that game. Example there is a game today 4/9/2001 and the ext game it displays is 4/10/2001 Any ideas? cfset today = dateformat(NOW(), 'm/d/') CFQUERY name="NextGame" datasource="#dsource#" maxrows="1" SELECT * FROM schedule WHERE gdate = #today# /CFQUERY ALSO HAD IT AS CFQUERY name="NextGame" datasource="#dsource#" maxrows="1" SELECT * FROM schedule WHERE gdate = NOW() /CFQUERY Thanks. Brian Hasselback [EMAIL PROTECTED] http://www.intent.net http://www.hasselback.com Web Hosting Development (502) 452-1851 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Numberformat question.
We just found a ready-made solution to the same problem. Check out Russ Michaels custom tag in the DevEx- cf_zerokiller found at the URL: http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34775F-2830-11D4-AA 9700508B94F380method=Full Does the trick. Too bad NumberFormat() isn't a little smarter. ;) Truman -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 2:15 PM To: CF-Talk Subject: RE: Numberformat question. Hatton; The code below will do exactly as you ask. Only on the first if statement where I have the mask as .9 change it to .99 and it works fine. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 12:44 PM To: CF-Talk Subject: RE: Numberformat question. This isn't pretty, however it does work. CFIF Len(ListLast(Item,".")) EQ 1 #NumberFormat(Item, "$999,999.9")# CFELSEIF Len(ListLast(Item,".")) EQ 2 #NumberFormat(Item, "$999,999.99")# CFELSEIF Len(ListLast(Item,".")) EQ 3 #NumberFormat(Item, "$999,999.999")# CFELSEIF Len(ListLast(Item,".")) EQ 4 #NumberFormat(Item, "$999,999.")# /CFIF Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 10:36 AM To: CF-Talk Subject: Numberformat question. I have a situation where I need to display a price with either 2, 3 or 4 digits after the decimal place. The database is storing the information properly, but I need to format the display to "trim" the output. For example, I have three prices for four items: Item 1 has a price of 45.9 Item 2 has a price of 9.99 Item 3 has a price of 2.985 Item 4 has a price of 0.4585 I need the price to display as $45.90 for Item 1, $9.99 for Item 2, $2.985 for item 3 and $0.4585 for item 4. I know I can't use DollarFormat, since it trims at two decimal places. The question is, how do I set up the NumberFormat to show the pricing properly when possible top-ends are up to $999,999,999.? TIA Hatton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to fast big query result on browser
TwoSelectsRelated may get you started, but it is JavaScript - with 21k items, you're going to run into a lot of issues; your HTML file will be huge and the JS is going to pinch a lot of memory and rendering processes for the browser... not going to be a fun UI no matter how you slice it on the client side. I'd consider pagination or providing a drill-down mechanism (if you have relational data as John mentioned) if not a search or index function by the first letter or something... BTW, I'll guarantee that a select or related select with that many options WILL blow up on a sMacintosh. T. -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 9:41 AM To: CF-Talk Subject: RE: How to fast big query result on browser I agree with Jason. I think many users would walk away from a site that asked them to use a selectbox with 21k items in it. Just think how long that would take just to read each option Crikey!! Are there any relationships with any other data? One thing to try if it's feasible is group the 21k items to another group of items, sort of like: Project Module Module Module Module Module Project Module Module etc... That way the user first selects a "Project" which then limits the next selectbox to just those items that belong under that particular project. I don't know if your data is or can be arranged like that but it's one idea. If so there is a handy tag, I've used a few times in the DevEx. called TwoSelectsRelated.. Very handy. J. John Wilker Web Applications Consultant Allaire Certified ColdFusion Developer Office: 909-943-8428 www.billtracker.org http://www.billtracker.org -Original Message- From: Jason Aden [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 8:16 AM To: CF-Talk Subject: RE: How to fast big query result on browser George, How is anyone going to use a select box with 21,000 options? Don't you think that's too many for someone to look through when making a selection in a select box? You should try getting some parameters from the user first and pass those to the query so you don't have so many options in one box. Have them enter the category, or maybe some sort of alphabetical search, but do something that will narrow down the query results. IMHO, you would never want to have more than 500 options in a select box (as an absolute limit). Jason Jason Aden Allaire Certified Developer [EMAIL PROTECTED] www.wwstudios.com -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 1:52 PM To: CF-Talk Subject: Re: How to fast big query result on browser about 21,000 options - Original Message - From: "Hayes, David" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 10:32 AM Subject: RE: How to fast big query result on browser How many options are you putting in your select box? -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 12:30 PM To: CF-Talk Subject: How to fast big query result on browser Hi there, I have one problem, I made a select box, the option items come from a query result, due to 20, 000 records, so the browser is very slow for that template, even I already cached query on server. If any one has a good sulotion? thx. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to fast big query result on browser
Perhaps the closing /option tag isn't understood properly by those old versions? Just a guess... Truman -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 2:30 PM To: CF-Talk Subject: RE: How to fast big query result on browser Speaking of Macs, select boxes seem to produce an amount of white space above the selected item equal to the number of items below the selected line - at least this seems to be the case in NS3,4 and IE4 for Mac. It occurs both with select and CFselect forms. Is this a Mac 'feature', or is it the browser or is it my code?? Tristram Charnley - [EMAIL PROTECTED] "If something is hard to do, its not worth doing!" Homer Simpson. -Original Message----- From: Truman Esmond III [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 17:26 To: CF-Talk Subject: RE: How to fast big query result on browser TwoSelectsRelated may get you started, but it is JavaScript - with 21k items, you're going to run into a lot of issues; your HTML file will be huge and the JS is going to pinch a lot of memory and rendering processes for the browser... not going to be a fun UI no matter how you slice it on the client side. I'd consider pagination or providing a drill-down mechanism (if you have relational data as John mentioned) if not a search or index function by the first letter or something... BTW, I'll guarantee that a select or related select with that many options WILL blow up on a sMacintosh. T. -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 9:41 AM To: CF-Talk Subject: RE: How to fast big query result on browser I agree with Jason. I think many users would walk away from a site that asked them to use a selectbox with 21k items in it. Just think how long that would take just to read each option Crikey!! Are there any relationships with any other data? One thing to try if it's feasible is group the 21k items to another group of items, sort of like: Project Module Module Module Module Module Project Module Module etc... That way the user first selects a "Project" which then limits the next selectbox to just those items that belong under that particular project. I don't know if your data is or can be arranged like that but it's one idea. If so there is a handy tag, I've used a few times in the DevEx. called TwoSelectsRelated.. Very handy. J. John Wilker Web Applications Consultant Allaire Certified ColdFusion Developer Office: 909-943-8428 www.billtracker.org http://www.billtracker.org -Original Message- From: Jason Aden [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 8:16 AM To: CF-Talk Subject: RE: How to fast big query result on browser George, How is anyone going to use a select box with 21,000 options? Don't you think that's too many for someone to look through when making a selection in a select box? You should try getting some parameters from the user first and pass those to the query so you don't have so many options in one box. Have them enter the category, or maybe some sort of alphabetical search, but do something that will narrow down the query results. IMHO, you would never want to have more than 500 options in a select box (as an absolute limit). Jason Jason Aden Allaire Certified Developer [EMAIL PROTECTED] www.wwstudios.com -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 1:52 PM To: CF-Talk Subject: Re: How to fast big query result on browser about 21,000 options - Original Message - From: "Hayes, David" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 10:32 AM Subject: RE: How to fast big query result on browser How many options are you putting in your select box? -Original Message- From: George Dong [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 12:30 PM To: CF-Talk Subject: How to fast big query result on browser Hi there, I have one problem, I made a select box, the option items come from a query result, due to 20, 000 records, so the browser is very slow for that template, even I already cached query on server. If any one has a good sulotion? thx. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does Anyone understand encrypt/decrypt??? [CF-Talk]
Check for ASCII values and/or ascii string length - I'll bet the string you're trying to decrypt has a hidden end-of-line or something that is causing the decrypt to fail. HTH, Truman -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 20, 2000 9:22 AM To: Cf-Talk Subject: Does Anyone understand encrypt/decrypt??? [CF-Talk] Greets, I am attempting to encrypt a text file and store it in an SQL table. First, I create a name, and then see if the file exists... cfset outfile = "\\web1\reports\cr_store\#answer3#" (where answer3 is the filename) cfif fileexists ("#outfile#") Then, read the file into a variable cffile action = "read" file="#outfile#" Variable="txtoutput" Create a key cfset key='1234567' Then encrypt it CFSET encrypted = encrypt(txtoutput, key) and then I store '#encrypted#' in a text field in an SQL7 table. Not bad so far... Now, when I try and view the file, I again set the key, cfset key='1234567' And retrieve the field from a query I ran cfset txtoutput = #get_report.report# then I attempt to decrypt the file cfset decrypted = decrypt(txtoutput, key) And I get the error... The value to be decrypted is no valid. Any ideas Marcus the Desperate -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: ColdFusion Server-side Source Control
Hmmm... That's where I seem to be heading as well. :( Good idea, not so good implementation. I'm going to poke around a bit more - I'll let everyone know if I get it to work. Thanks for the feedback Truman -Original Message- From: Milks, Jim [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 7:21 AM To: '[EMAIL PROTECTED]' Subject: RE: ColdFusion Server-side Source Control Yes I have some experience, and my conclusion is STAY AWAY! Vss and CF just don't seem to integrate well. We thought we had it solved, until we lost a day's worth of development. Our final conclusion was to simply run CF and VSS seperately and use Alt + Tab a lot. I would agree that the multiple projects appear to be the issue, but we never had enough time to invest in trying to solve it... Good luck.. JM -Original Message- From: Truman Esmond III To: [EMAIL PROTECTED] Sent: 24/08/00 7:43 PM Subject: ColdFusion Server-side Source Control Okay, I've spent enough time spinning my wheels on this by myself - any help is appreciated :) Anyone successfully implemented server-side source control through CF? Found better docs somewhere on this feature within CF? We've got source control set up through studio, but we're trying to have an internal development server connect to a client's VSS db, and have all of our local developers use RDS locally on that machine for this effort - the problem seemingly lies in that there are multiple projects and multiple working directories. The form in the CFAdmin only allows a single DB to be connected (and is kinda vague about exactly which .ini file to connect to) and only a single working directory. Any experiences, configurations and references to other documentation would be greatly appreciated! Secondly and similarly, has anyone tried using the CF server-side source control or even studio integrated source control using SourceGear's SourceOffSite? Looks like it *should* work the same (only faster) since their based on the same API... Truman -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IsDefined() Problem
The reason the quotes are there is that you want to check the existence of the NAME of the var, not the resolved value of your variable as the name of the variable you are checking for... If you were to use IsDefined(attributes.myvar) and the variable was NOT defined, you would get an error because CF tries to evaluate the variable name inside the function brackets, then determine if htere is a var name with the evaluated value. The IsDefined("attributes.myvar") way checks to see if the variable scoped and named "attributes.myvar" exists, which (generally) is how the function is used. This is a handy lesson to learn, as it applies to all the CF functions. Hope that makes sense! Truman -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 9:02 AM To: Cf-Talk Subject: RE: IsDefined() Problem Figured it out (taken me months!) I need to put quotes in, which seems a bit irish to me as all other functions (those I can think of off the top of my head) you don't put the quotes in when putting in a variable. Sorry to bother you! Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF Server-side visual sourcesafe
Okay, I've spent enough time spinning my wheels on this by myself. Anyone successfully implemented server-side source control through CF? Found better docs somewhere? We've got source control set up through studio, but we're trying to have an internal development server connect to a client's VSS db, and have all of our local developers use RDS locally on that machine for this effort - the problem seemingly lies in that there are multiple projects and multiple working directories. The form in the CFAdmin only allows a single DB to be connected (and is kinda vague about exactly which .ini file to connect to) and only a single working directory. Any experiences, configurations and references to other documentation would be greatly appreciated! Secondly and similarly, has anyone tried using the CF server-side source control or event studio integrated source control using SourceGear's SourceOffSite? Looks like it *should* work the same (only faster) since their based on the same API... Truman -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IsDefined() Problem
I knew as soon as I sent that that I missed a couple that don't do that... always exceptions to any rule. Sigh. Plus, the iif() function does it recursively, so... no, it's not a hard and fast rule, but for the majority (that fair? ;) of functions, that is the case. Truman -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 11:18 AM To: [EMAIL PROTECTED] Subject: Re: IsDefined() Problem Truman, Applies to MOST but not ALL functions. isarray , isstruct, structkeyexists come to mind as exceptions - Original Message - From: "Truman Esmond III" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:43 AM Subject: RE: IsDefined() Problem The reason the quotes are there is that you want to check the existence of the NAME of the var, not the resolved value of your variable as the name of the variable you are checking for... If you were to use IsDefined(attributes.myvar) and the variable was NOT defined, you would get an error because CF tries to evaluate the variable name inside the function brackets, then determine if htere is a var name with the evaluated value. The IsDefined("attributes.myvar") way checks to see if the variable scoped and named "attributes.myvar" exists, which (generally) is how the function is used. This is a handy lesson to learn, as it applies to all the CF functions. Hope that makes sense! Truman -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 9:02 AM To: Cf-Talk Subject: RE: IsDefined() Problem Figured it out (taken me months!) I need to put quotes in, which seems a bit irish to me as all other functions (those I can think of off the top of my head) you don't put the quotes in when putting in a variable. Sorry to bother you! Paul -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ColdFusion Server-side Source Control
Okay, I've spent enough time spinning my wheels on this by myself - any help is appreciated :) Anyone successfully implemented server-side source control through CF? Found better docs somewhere on this feature within CF? We've got source control set up through studio, but we're trying to have an internal development server connect to a client's VSS db, and have all of our local developers use RDS locally on that machine for this effort - the problem seemingly lies in that there are multiple projects and multiple working directories. The form in the CFAdmin only allows a single DB to be connected (and is kinda vague about exactly which .ini file to connect to) and only a single working directory. Any experiences, configurations and references to other documentation would be greatly appreciated! Secondly and similarly, has anyone tried using the CF server-side source control or even studio integrated source control using SourceGear's SourceOffSite? Looks like it *should* work the same (only faster) since their based on the same API... Truman -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: dynamically updating one select list based upon the selection in another
I would recommend Nate Weiss' CF_TwoSelectsRelated or CF_ThreeSelectsRelated tags which perform the functions you request; your preselections will be based on their order in the query rather than an absolute selection, but I think they'll do what your looking for. Truman -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 12:27 PM To: [EMAIL PROTECTED] Subject: dynamically updating one select list based upon the selection in another I have an update form in which the the user can choose an option from a select list. When this form is initially displayed, the current info from the database is automatically selected. This field happens to contain the names of various departments in our division. Each department has a default individual assigned to it (meaning that when a department is selected from the list, the information submitted will automatically be routed to the default person for that group). The field below that is a dynamically populated select list of all of the people in our division. If a user so chooses, they can override the default person assigned to a group, and specify someone else from this list. Now, here's what I want to do. When the form is first displayed, I want both the department select list AND the people list to have the current value in the db displayed (i.e. the department it will be routed to and the default contact person's name in that department). If, however, the user changes the name of the department to route to, I would like the list below it to automatically then select the default contact person's name for that department. In a nutshell, the first list will drive what is selected in the second list, but I want the second list to be independent (the first list will not change what is selected if I make a different selection in the second list). I'm assuming I will have to (ugh) use a javascript for this? Admittedly, I am neither a javascript guru nor a coldfusion guru. Can anyone provide me with some direction on this? Thanks in advance! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: track page hits
One way to manage this is to "trick" the stats program into capturing the query string, by using "/" as a delimiter rather than ? and THe latest formURL2attributes.cfm handles this translation. Using this method, your links to fuseactions would look like: http://www.foo.com/index.cfm/fuseaction/thefirstfuse/barID/235 I can't say I've used this in a large-scale environment but I have verified that StatsServer picks up on this; of course the flip side of the problem is that different attribute values after the fuseaction create a unique hit... HTH Truman -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 10:42 AM To: Ryan Cc: Cf-Talk Subject: RE: track page hits no I haven't... that bites... sometimes you get a lot of help, and sometimes you get ignored... Anyhow, I was hoping for something a little less taxing on the system, but my fusebox apps are designed so that by the fuseaction you can pretty much tell what page you're on... not always, but basically I was thinking of running a little script on each page that updated the count on that page in a table. I was also considering some other things, like building a client var that was carried from page to page... with the tokens etc... then I could only updated the page once per session... if I update then I've only got a smaller table, or I was toying with just adding the unique hits per session for each page with time etc... then we could run some reports on date/time page hits... maybe referrals... etc. maybe to go as far as doing something so we could tell how long they spent on the page... who knows... just hoping that there was some input from people, and possibly some examples or standing products... one of our poor customers would like to tell what is happening in his cart, but all he can do is count how many people go in... after that, who knows I'll keep digging though... later, Jason Egan -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 10:23 AM To: [EMAIL PROTECTED] Subject: Re: track page hits At 13:55 8/8/00 -0600, you wrote: Using the fusebox method, the index.cfm is hit a million times per session (you know what I mean)... Any suggestions on tracking the individual pages? For example, I have a fusebox cart - I would like to track each page in the cart so I can tell where/if the cart is being abandoned. Jason did you get any replies on this? I am interested in this too. Thanks, Ryan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.