Re: Advanced Security
Hi! Have you found a solution? Cause i need to do something similar! I have people logging in. So what i thought i'd do was divide the people to groups according to their level of access. Then check on each page before displaying it if they are one of those that are allowed access to that page or not. what do you think?! Heidi --- Vance Duke <[EMAIL PROTECTED]> wrote: > I have a Security context with all Domain Users > allowed the access the > application. No problem there. NOW, I want to > limit a part of the > application to just a certain subset of domain users > setup in a User Group. > Those users would have access to the main part of > the application, but also > need access to the HR functions. Do I need to set > up another security context and Authorize them > against that context also (in > other words, 2 CFAuthenticate statements)? Or how > would I do that? How do > I know that they are part of that User Group when > they log in? > > Thanks for the help, > Vance Duke > > > > ~~ 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: CFHTTP Problem
> Here is the problem: > > On another dev server (this one running IIS 5 and CF 4.5.1 SP2) the CFHTTP > throws an error indicating "the file is not in ASCII text format and cannot > be rendered" right after the POST operation. Any ideas? I'm experiencing exactly the same problem, I'm getting the same error message. If you solved this could you let me know how. Would be eternally gratefull. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 10 March 2001 20:49 To: CF-Talk Subject: RE: CFHTTP Problem > On our production server and dev server (both running Apache and CF 4.5.1 > SP2) I call an application on an external server via CFHTTP with POST as > the method and one form variable that contains XML. I get the results > back and take care of them accordingly. No problems. > > Here is the problem: > > On another dev server (this one running IIS 5 and CF 4.5.1 SP2) the CFHTTP > throws an error indicating "the file is not in ASCII text format and cannot > be rendered" right after the POST operation. Any ideas? Are you sure the IIS machine is 4.5.1 SP2? It sounds like an issue that was fixed in 4.5.1 I had the same problem a while back on a 4.0.1 machine, so I just switched to the 4.5.1 machine and it worked fine Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion Timesheet application
Carlo, my xperience is write one for yourself; its much easier and mosre cost effective as you can modify it to the exact requirements of muppet managers. The time you spend on other peoples code to make it work for you is a waste of time... $0.02 N http://www.mcbdigital.com [EMAIL PROTECTED] ---> ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfloop for 2 list?!!!
hi.. i hav a prob. here. i hav a tool to key in remarks for mulitple users. Eg. Page1.cfm #p_arrival_remarks# So in page2.cfm... how can i insert the remarks into the database using the respective username.?? i cant use as it can only use for 1 list... another prob.. i try CFOUTPUT the 2 list... #p_username#,#p_arrival_remarks# and notice that if theres no input for remarks.. both list length doesnt match.. any advice how i shld go abt doing it?!! thanx in advance, han ~~ 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: Any recommendations on an E-commerce software?
I'll second this one. It really is awesome for the price. You're client will love it as well, as one of its major selling points is that it also manages orders off line through a very user friendly interface. The front-end is 'good enough' and runs using a combination of html(product display) and perl(ordering process). The backend is a PC based application that enables the user to maintain products and product hierachies, manage orders (packing lists, invoicing, back ordering, order line exports etc). I've used it on sites with over 10,000 products. It even provides its own Java encryption if you don't want to connect to a payment service. You can also install it so your client can only manage orders and is not involved in the upload of products. This can be very important if you have a fiddly site you don't want them to mess up. It will not remember old orders... I really can't recommend this strongly enough. It really is amazing value for money. There is one downside. The application manages all its content within a one directory. This can cause you problems if you are attempting to add CF functionality into the shop. The only way I found to do this was to ensure that all .htm files were also served by the CF server. That really was my only gripe with it. You americans have a look at http://www.actinic.com Adam -Original Message- From: Martin Sutton [SMTP:[EMAIL PROTECTED]] Sent: 12 March 2001 16:06 To: CF-Talk Subject:RE: Any recommendations on an E-commerce software? Actinic is a simple to configure/use off the shelf e-commerce package...www.actinic.co.uk Hope that helps. ~~ 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: cffile and mapped or UNC drives
> Just the application server. Don't forget about RDS if you want to use that across servers - it's service must have a different login too Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to pass javascript variable to a cf tag?
> i am using a inside a javascript function. Question is how do i > pass the javascript variable to the cfquery? > this is an example of the code. > > function ChangeSelect(value) > { > > select family_name || ' ' || given_name as name > from table where > company_code = 'the javascript variable' > > } You know, I never get tired of saying this... CF=Server Side JS=Client Side You need to pass the JS variables to the server to use them, you can't just assume that it'll work on the page - CF compiles the page and then sends it to the browser where JS runs If you want to pass things back, either put them in a URL variable or put them in a FORM Remember that this will fall flat on it's face if the user either has JS turned off or is behind a fire-wall that doesn't allow JS Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Project Mgmt for CF development?
Michael You're not missing the boat at all! Exactly what we've done. Our Intranet/extranet contains a timesheet and a scheduler. Project managers within the company create and manage projects using the scheduler by specifying start date and deadline of projects. The scheduler then calculates the deadlines for various stages of the project (Outline, Design Development, etc) Tasks can then be assigned in each stage to various staff. Each staff member fills in a timesheet at the end of the weeek. The combination of these 2 components allows us to produce stats telling us how much time we are spending on projects compared with how much time we allocated for them. Also how well deadlines get met and it also helps to manage people's workload. All this was written in house using CF. We felt that something like MS Project was too restrictive and needed something more tailored to the way we operate. A -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: BORKMAN Lee [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 05:17 To: CF-Talk Subject: RE: Project Mgmt for CF development? Yeah, we did that here, and next month we are rolling out an application that lets people send electronic letters to each other. You should see it! Very impressive considering our core business is building roads. All in all, I'd recommend your philosophy as a great approach to problem solving;-) LBB. -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 10:55 AM To: CF-Talk Subject: Re: Project Mgmt for CF development? Why not just write and in house program that will do all of what you want, and then alot more? Or am I missing the boat here? IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Responding to Post's
Why cant people respond to the post in the appropriate post note and not mix match things, ?? Just a question, not trying to start a flame war or something, just seems that lately alot of this is happening, then again maybe its just me. ~~ 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: cfloop for 2 list?!!!
insteadof using a list, dynamically name your input forms, then in your cfoutput, u can output those forms. like #Form.Question1# #Form.Remark1# #Form.Question1# #Form.Remark1# - Original Message - From: han peng <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Tuesday, March 13, 2001 4:32 AM Subject: cfloop for 2 list?!!! > hi.. i hav a prob. here. i hav a tool to key in remarks for mulitple users. > Eg. Page1.cfm > > > > #p_arrival_remarks# > > > > > > So in page2.cfm... > how can i insert the remarks into the database using the respective username.?? > > i cant use > as it can only use for 1 list... > > another prob.. i try CFOUTPUT the 2 list... #p_username#,#p_arrival_remarks# > and notice that if theres no input for remarks.. both list length doesnt match.. > > any advice how i shld go abt doing it?!! > > thanx in advance, > han > > > > ~~ 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: cfloop for 2 list?!!!
For inserting the remarks into the DB simply suffix your textarea variable with the ID number or some unique value that would indicate the record they are putting the remarks to. Example: -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 5:32 AM To: CF-Talk Subject: cfloop for 2 list?!!! #p_arrival_remarks# ON PAGE2.CFM IF INSERTING INTO A NEW TABLE: insert into remarksTable(remark_id,Username,remarks) values(#form.ID#,'#form.p_username#','#form.p_arrivale_remarks#') IF UPDATING THE TABLE WITH THE REMARKS UPDATE remarksTable Set Remarks = '#form.P-arrival_remarks#' Where Part_info_ID = #form.ID# This UPDATE is assuming you have a UNIQUE Identifier within the table. Else you will have to determine the unique record by some means of combining fields. hi.. i hav a prob. here. i hav a tool to key in remarks for mulitple users. Eg. Page1.cfm #p_arrival_remarks# So in page2.cfm... how can i insert the remarks into the database using the respective username.?? i cant use as it can only use for 1 list... another prob.. i try CFOUTPUT the 2 list... #p_username#,#p_arrival_remarks# and notice that if theres no input for remarks.. both list length doesnt match.. any advice how i shld go abt doing it?!! thanx in advance, han ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can CF work with a FileMakerPro database?
>If you decide to take the project and the database is >going to be access by the Internet public, make sure its the FM Pro 5 >Unlimited version. The standard FM Pro 5 has a '10 IPs per 12 hour' limit. Surely if it was being accessed through CF it would only be via one IP - The IP of the CF-Server machine... ~~ 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: Advanced Security
The procedure is that you would create a set of UserObject rules within the security context, assign users/groups access rights to the userObject rule, and within your application check to see if the user has permission using the isAuthorized() function. Regards, Steve Drucker CEO Fig Leaf Software http://www.figleaf.com -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 3:27 AM To: CF-Talk Subject: Re: Advanced Security Hi! Have you found a solution? Cause i need to do something similar! I have people logging in. So what i thought i'd do was divide the people to groups according to their level of access. Then check on each page before displaying it if they are one of those that are allowed access to that page or not. what do you think?! Heidi --- Vance Duke <[EMAIL PROTECTED]> wrote: > I have a Security context with all Domain Users > allowed the access the > application. No problem there. NOW, I want to > limit a part of the > application to just a certain subset of domain users > setup in a User Group. > Those users would have access to the main part of > the application, but also > need access to the HR functions. Do I need to set > up another security context and Authorize them > against that context also (in > other words, 2 CFAuthenticate statements)? Or how > would I do that? How do > I know that they are part of that User Group when > they log in? > > Thanks for the help, > Vance Duke > > > > ~~ 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: Responding to Post's
Okay, tell me more -- what are you talking about -- what is "the appropriate post note" -- I don't have an "any key" either. ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Michael [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 6:28 AM To: CF-Talk Subject:OT: Responding to Post's Why cant people respond to the post in the appropriate post note and not mix match things, ?? Just a question, not trying to start a flame war or something, just seems that lately alot of this is happening, then again maybe its just me. ~~ 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: Project Mgmt for CF development?
You also have to remember that this information is vital in planning a production schedule for a company. Just imagine what it would be like to schedule 5 projects between 7 developers over a period of 2 months without any idea how long it takes for the developers to complete something. It lets team leads and/or Directors schedule projects based off of historical data. All in all the more you keep track or your time the more you forget you are doing it the future, and the data that you are collecting is invaluable to a Web Application Development company. Especially for budgeting, bidding, and scheduling. just my .02 Jeff Gombala - Original Message - From: "Andy Ewings" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 13, 2001 6:11 AM Subject: RE: Project Mgmt for CF development? > Michael > > You're not missing the boat at all! Exactly what we've done. Our > Intranet/extranet contains a timesheet and a scheduler. Project managers > within the company create and manage projects using the scheduler by > specifying start date and deadline of projects. The scheduler then > calculates the deadlines for various stages of the project (Outline, Design > Development, etc) Tasks can then be assigned in each stage to various > staff. Each staff member fills in a timesheet at the end of the weeek. The > combination of these 2 components allows us to produce stats telling us how > much time we are spending on projects compared with how much time we > allocated for them. Also how well deadlines get met and it also helps to > manage people's workload. All this was written in house using CF. We felt > that something like MS Project was too restrictive and needed something more > tailored to the way we operate. > > A > > -- > Andrew Ewings > Project Manager > Thoughtbubble Ltd > http://www.thoughtbubble.net > -- > United Kingdom > http://www.thoughtbubble.co.uk/ > Tel: +44 (0) 20 7387 8890 > -- > New Zealand > http://www.thoughtbubble.co.nz/ > Tel: +64 (0) 9 488 9131 > -- > The information in this email and in any attachments is confidential and > intended solely for the attention and use of the named addressee(s). Any > views or opinions presented are solely those of the author and do not > necessarily represent those of Thoughtbubble. This information may be > subject to legal, professional or other privilege and further distribution > of it is strictly prohibited without our authority. If you are not the > intended recipient, you are not authorised to disclose, copy, distribute, or > retain this message. Please notify us on +44 (0)207 387 8890. > > > > -Original Message- > From: BORKMAN Lee [mailto:[EMAIL PROTECTED]] > Sent: 13 March 2001 05:17 > To: CF-Talk > Subject: RE: Project Mgmt for CF development? > > > Yeah, we did that here, and next month we are rolling out an application > that lets people send electronic letters to each other. You should see it! > Very impressive considering our core business is building roads. > > All in all, I'd recommend your philosophy as a great approach to problem > solving;-) > > LBB. > > -Original Message- > From: Michael [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 13, 2001 10:55 AM > To: CF-Talk > Subject: Re: Project Mgmt for CF development? > > > Why not just write and in house program that will do all of what you want, > and then alot more? > > Or am I missing the boat here? > > > > IMPORTANT NOTICE: > This e-mail and any attachment to it is intended only to be read or used by > the named addressee. It is confidential and may contain legally privileged > information. No confidentiality or privilege is waived or lost by any > mistaken transmission to you. If you receive this e-mail in error, please > immediately delete it from your system and notify the sender. You must not > disclose, copy or use any part of this e-mail if you are not the intended > recipient. The RTA is not responsible for any unauthorised alterations to > this e-mail or attachment to it. > ~~ 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
nesting queries
I have 3 queries. But when i try to nest the cfoutput tags i get an error that says this in to allowed. how do you use the cfoutput tags to output your information if the data to your second and third query is dependent upon the info from the first? here are my first 2 queries. SELECT * FROM tblEmployees WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' AND tblEmployees.Office LIKE '%' AND tblEmployees.Office LIKE '#office#%' ORDER BY tblEmployees.lname SELECT * from tblEquipment WHERE EquipID = #iEquipID# I want to be able to have one table that i can put the information all together. any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: nesting queries
You can place a CFOUTPUT at the very top of the Queries and instead of using CFOUTPUT QUERY, use a CFLOOP Query just make sure when you are outputing the query results you use the prefix for the given query Example: CFOUPUT CFLOOP QUERY=Query1 #Query1.MYFIELD# CFLOOP Query=Query2 #Query2.MyField# CFLOOP Query=Query3 #Query3.MyField# Also make sure you close the loops when needed to reduce the looping through unneeded records. HTH -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:58 AM To: CF-Talk Subject: nesting queries I have 3 queries. But when i try to nest the cfoutput tags i get an error that says this in to allowed. how do you use the cfoutput tags to output your information if the data to your second and third query is dependent upon the info from the first? here are my first 2 queries. SELECT * FROM tblEmployees WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' AND tblEmployees.Office LIKE '%' AND tblEmployees.Office LIKE '#office#%' ORDER BY tblEmployees.lname SELECT * from tblEquipment WHERE EquipID = #iEquipID# I want to be able to have one table that i can put the information all together. any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: Responding to Post's
All I am saying is if responding to a message respond to the message in that message's header, like this one "Arden Weiss" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Okay, tell me more -- what are you talking about -- what is "the appropriate post note" -- I don't have an "any key" either. > > ^ > / \__ >(@\___ > / O > /(_/ > /_/ > Whoof... > 410-757-3487 > > -Original Message- > From: Michael [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, March 13, 2001 6:28 AM > To: CF-Talk > Subject: OT: Responding to Post's > > Why cant people respond to the post in the appropriate post note and not mix > match things, ?? > > Just a question, not trying to start a flame war or something, just seems > that lately alot of this is happening, then again maybe its just me. > ~~ 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: nesting queries
it's a matter of how u do your query. in this case, u do one query, and use agreggratataacrap functions. sorry i have stutter problems. the thing is, u have to call out every column individually, instead of using the asterisk *. here is an example. notice i am using aliases SELECT a.EMPID, a.LName, a.FName, a.Office, a.address, b.EquipID, b.description, b.callnumber FROM tblEmployess a, tblEquipment b WHERE a.FName LIKE '#fname#%' AND a.LName LIKE '#lname#%' AND a.Office LIKE '%' AND a.Office LIKE '#office#%' AND a.EMPID = b.EquipID ORDER BY a.lname just try something like that,adn u can output all that information in one cfoutput - Original Message - From: Jones, Becky <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Tuesday, March 13, 2001 7:57 AM Subject: nesting queries > I have 3 queries. But when i try to nest the cfoutput tags i get an error > that says this in to allowed. > how do you use the cfoutput tags to output your information if the data to > your second and third query is dependent upon the info from the first? > here are my first 2 queries. > > > SELECT * FROM tblEmployees > WHERE > tblEmployees.FName LIKE '#fname#%' > AND tblEmployees.LName LIKE '#lname#%' > > AND tblEmployees.Office LIKE '%' > > AND tblEmployees.Office LIKE '#office#%' > > ORDER BY tblEmployees.lname > > > > > SELECT * from tblEquipment > WHERE EquipID = #iEquipID# > > I want to be able to have one table that i can put the information all > together. any ideas? > > > * > This e-mail, including any attachments, is intended for the > receipt and use by the intended addressee(s), and may contain > confidential and privileged information. If you are not an intended > recipient of this e-mail, you are hereby notified that any unauthorized > use or distribution of this e-mail is strictly prohibited. > > > > ~~ 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: Advanced Security
Thanks Steve. That helped immensely. And that it worked and pointed me in the right direction. Thanks, Vance Duke - Original Message - From: "Steve Drucker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 13, 2001 7:34 AM Subject: RE: Advanced Security > The procedure is that you would create a set of UserObject rules within the > security context, assign users/groups access rights to the userObject rule, > and within your application check to see if the user has permission using > the isAuthorized() function. > > Regards, > Steve Drucker > CEO > Fig Leaf Software > http://www.figleaf.com > > > -Original Message- > From: Heidi Belal [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 13, 2001 3:27 AM > To: CF-Talk > Subject: Re: Advanced Security > > > Hi! > Have you found a solution? Cause i need to do > something similar! > I have people logging in. So what i thought i'd do > was divide the people to groups according to their > level of access. Then check on each page before > displaying it if they are one of those that are > allowed access to that page or not. > what do you think?! > Heidi > > --- Vance Duke <[EMAIL PROTECTED]> wrote: > > I have a Security context with all Domain Users > > allowed the access the > > application. No problem there. NOW, I want to > > limit a part of the > > application to just a certain subset of domain users > > setup in a User Group. > > Those users would have access to the main part of > > the application, but also > > need access to the HR functions. Do I need to set > > up another security context and Authorize them > > against that context also (in > > other words, 2 CFAuthenticate statements)? Or how > > would I do that? How do > > I know that they are part of that User Group when > > they log in? > > > > Thanks for the help, > > Vance Duke > > > > > > > > > ~~ 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: Any recommendations on an E-commerce software?
Which is? All I could find is: "Actinic e-store solutions begin at less than $500." which suggests the price is $495 per store. Which is fine. I just find it annoying to find it hard to find the price. best, paul At 10:07 AM 3/13/01 +, you wrote: >I'll second this one. It really is awesome for the price. ~~ 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
SNMP and CF
Is there a way to monitor CF using SNMP right now? ~~ 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: Project Mgmt for CF development?
Some one who has access to a Polling System... if you would I would like to see how many people use a project mgmt system and which ones... HOWEVER Let's not all respond to the list... in fact if you want Respond to me and I will add up the responses. To: [EMAIL PROTECTED] Subject: Project Mgmt System Poll After I get 100+ responses I will send out a results... or if the responses quit coming in. > -Original Message- > From: Jeff Gombala [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, March 13, 2001 7:52 AM > To: CF-Talk > Subject: Re: Project Mgmt for CF development? > > You also have to remember that this information is vital in planning a > production schedule for a company. Just imagine what it would be like to > schedule 5 projects between 7 developers over a period of 2 months without > any idea how long it takes for the developers to complete something. It > lets team leads and/or Directors schedule projects based off of historical > data. All in all the more you keep track or your time the more you forget > you are doing it the future, and the data that you are collecting is > invaluable to a Web Application Development company. Especially for > budgeting, bidding, and scheduling. > > just my .02 > > Jeff Gombala > > - Original Message - > From: "Andy Ewings" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, March 13, 2001 6:11 AM > Subject: RE: Project Mgmt for CF development? > > > > Michael > > > > You're not missing the boat at all! Exactly what we've done. Our > > Intranet/extranet contains a timesheet and a scheduler. Project > managers > > within the company create and manage projects using the scheduler by > > specifying start date and deadline of projects. The scheduler then > > calculates the deadlines for various stages of the project (Outline, > Design > > Development, etc) Tasks can then be assigned in each stage to > various > > staff. Each staff member fills in a timesheet at the end of the weeek. > The > > combination of these 2 components allows us to produce stats telling us > how > > much time we are spending on projects compared with how much time we > > allocated for them. Also how well deadlines get met and it also helps > to > > manage people's workload. All this was written in house using CF. We > felt > > that something like MS Project was too restrictive and needed something > more > > tailored to the way we operate. > > > > A > > > > -- > > Andrew Ewings > > Project Manager > > Thoughtbubble Ltd > > http://www.thoughtbubble.net > > -- > > United Kingdom > > http://www.thoughtbubble.co.uk/ > > Tel: +44 (0) 20 7387 8890 > > -- > > New Zealand > > http://www.thoughtbubble.co.nz/ > > Tel: +64 (0) 9 488 9131 > > -- > > The information in this email and in any attachments is confidential and > > intended solely for the attention and use of the named addressee(s). Any > > views or opinions presented are solely those of the author and do not > > necessarily represent those of Thoughtbubble. This information may be > > subject to legal, professional or other privilege and further > distribution > > of it is strictly prohibited without our authority. If you are not the > > intended recipient, you are not authorised to disclose, copy, > distribute, > or > > retain this message. Please notify us on +44 (0)207 387 8890. > > > > > > > > -Original Message- > > From: BORKMAN Lee [mailto:[EMAIL PROTECTED]] > > Sent: 13 March 2001 05:17 > > To: CF-Talk > > Subject: RE: Project Mgmt for CF development? > > > > > > Yeah, we did that here, and next month we are rolling out an application > > that lets people send electronic letters to each other. You should see > it! > > Very impressive considering our core business is building roads. > > > > All in all, I'd recommend your philosophy as a great approach to problem > > solving;-) > > > > LBB. > > > > -Original Message- > > From: Michael [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, March 13, 2001 10:55 AM > > To: CF-Talk > > Subject: Re: Project Mgmt for CF development? > > > > > > Why not just write and in house program that will do all of what you > want, > > and then alot more? > > > > Or am I missing the boat here? > > > > > > > > IMPORTANT NOTICE: > > This e-mail and any attachment to it is intended only to be read or used > by > > the named addressee. It is confidential and may contain legally > privileged > > information. No confidentiality or privilege is waived or lost by any > > mistaken transmission to you. If you receive this e-mail in error, > please > > immediately delete it from your system and notify the sender. You must > not > > disclose, copy or use any part of this e-mai
RE: nesting queries
i tried that and i only get results from the first query... #qryAllEmp.FName# #strSpace# #qryAllEmp.MI# #StrSpace# #qryAllEmp.LName# #qryAllEmp.Dept# #qryAllEmp.Office##qryAllEmp.Floor##qryAllEmp.Phone# Equipment: #qryEquipment.Description# -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:58 AM To: CF-Talk Subject: RE: nesting queries You can place a CFOUTPUT at the very top of the Queries and instead of using CFOUTPUT QUERY, use a CFLOOP Query just make sure when you are outputing the query results you use the prefix for the given query Example: CFOUPUT CFLOOP QUERY=Query1 #Query1.MYFIELD# CFLOOP Query=Query2 #Query2.MyField# CFLOOP Query=Query3 #Query3.MyField# Also make sure you close the loops when needed to reduce the looping through unneeded records. HTH -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:58 AM To: CF-Talk Subject: nesting queries I have 3 queries. But when i try to nest the cfoutput tags i get an error that says this in to allowed. how do you use the cfoutput tags to output your information if the data to your second and third query is dependent upon the info from the first? here are my first 2 queries. SELECT * FROM tblEmployees WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' AND tblEmployees.Office LIKE '%' AND tblEmployees.Office LIKE '#office#%' ORDER BY tblEmployees.lname SELECT * from tblEquipment WHERE EquipID = #iEquipID# I want to be able to have one table that i can put the information all together. any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
faulty join?
Hi, I'm trying to display (kayak) class information on a web page. I have 3 tables, one for class description (primary key "classID"), one for class prerequisites (primary key "prereqID"), and one for class schedule (primary key "scheduleID"). I have slimmed down the query and the output below. It only sorta works. I get a single output of the description, and a single output of the location/date (no repeats), but something goes wrong with the prereq's. If there is class with three prerequisites, say #1 #2 and #5, then the output loop for that class yields #5 #1 #2, #1 #2 #5, and #1 #5 #2. I only want the list of prerequisites to show up once. I've tried a bunch of stuff, but I'm obviously just guessing. Does anybody have a suggestion toward what I'm doing wrong? Thanks in advance, Megan SELECT class.classID, class.content, class_schedule.scheduleID, class_schedule.location, class_schedule.date, class_prereq.prereqID, class_prereq.prereq FROM class, class_schedule, class_prereq WHERE (pagename = 'classes_sea' and class.classID=class_schedule.classID and class_prereq.classID=class.classID) ORDER by rank, class_schedule.location, class_schedule.date class: #content# #prereq# #location#, #date# Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: nesting queries
Then it is possible that the 2nd Query returns no records, Can you show me both queries -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 9:45 AM To: CF-Talk Subject: RE: nesting queries i tried that and i only get results from the first query... #qryAllEmp.FName# #strSpace# #qryAllEmp.MI# #StrSpace# #qryAllEmp.LName# #qryAllEmp.Dept# #qryAllEmp.Office##qryAllEmp.Floor##qryAllEmp.Phone# Equipment: #qryEquipment.Description# -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:58 AM To: CF-Talk Subject: RE: nesting queries You can place a CFOUTPUT at the very top of the Queries and instead of using CFOUTPUT QUERY, use a CFLOOP Query just make sure when you are outputing the query results you use the prefix for the given query Example: CFOUPUT CFLOOP QUERY=Query1 #Query1.MYFIELD# CFLOOP Query=Query2 #Query2.MyField# CFLOOP Query=Query3 #Query3.MyField# Also make sure you close the loops when needed to reduce the looping through unneeded records. HTH -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:58 AM To: CF-Talk Subject: nesting queries I have 3 queries. But when i try to nest the cfoutput tags i get an error that says this in to allowed. how do you use the cfoutput tags to output your information if the data to your second and third query is dependent upon the info from the first? here are my first 2 queries. SELECT * FROM tblEmployees WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' AND tblEmployees.Office LIKE '%' AND tblEmployees.Office LIKE '#office#%' ORDER BY tblEmployees.lname SELECT * from tblEquipment WHERE EquipID = #iEquipID# I want to be able to have one table that i can put the information all together. any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: nesting queries
sure, i checked the database for one specific person that i know has information in the equipment table so the info is there..i just cant get it out! :) qry one: SELECT * FROM tblEmployees WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' AND tblEmployees.Office LIKE '%' AND tblEmployees.Office LIKE '#office#%' ORDER BY tblEmployees.lname qry two: SELECT * from tblEquipment WHERE EquipID = #iEquipID# -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 9:49 AM To: CF-Talk Subject: RE: nesting queries Then it is possible that the 2nd Query returns no records, Can you show me both queries -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 9:45 AM To: CF-Talk Subject: RE: nesting queries i tried that and i only get results from the first query... #qryAllEmp.FName# #strSpace# #qryAllEmp.MI# #StrSpace# #qryAllEmp.LName# #qryAllEmp.Dept# #qryAllEmp.Office##qryAllEmp.Floor##qryAllEmp.Phone# Equipment: #qryEquipment.Description# -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:58 AM To: CF-Talk Subject: RE: nesting queries You can place a CFOUTPUT at the very top of the Queries and instead of using CFOUTPUT QUERY, use a CFLOOP Query just make sure when you are outputing the query results you use the prefix for the given query Example: CFOUPUT CFLOOP QUERY=Query1 #Query1.MYFIELD# CFLOOP Query=Query2 #Query2.MyField# CFLOOP Query=Query3 #Query3.MyField# Also make sure you close the loops when needed to reduce the looping through unneeded records. HTH -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:58 AM To: CF-Talk Subject: nesting queries I have 3 queries. But when i try to nest the cfoutput tags i get an error that says this in to allowed. how do you use the cfoutput tags to output your information if the data to your second and third query is dependent upon the info from the first? here are my first 2 queries. SELECT * FROM tblEmployees WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' AND tblEmployees.Office LIKE '%' AND tblEmployees.Office LIKE '#office#%' ORDER BY tblEmployees.lname SELECT * from tblEquipment WHERE EquipID = #iEquipID# I want to be able to have one table that i can put the information all together. any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: faulty join?
Hi, Megan You will get the prereq list for each distinct schedule date for the class; I'm assuming your query is returning 3 dates for the class. Dave -Original Message- From: megan sherman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 9:02 AM To: CF-Talk Subject: faulty join? Hi, I'm trying to display (kayak) class information on a web page. I have 3 tables, one for class description (primary key "classID"), one for class prerequisites (primary key "prereqID"), and one for class schedule (primary key "scheduleID"). I have slimmed down the query and the output below. It only sorta works. I get a single output of the description, and a single output of the location/date (no repeats), but something goes wrong with the prereq's. If there is class with three prerequisites, say #1 #2 and #5, then the output loop for that class yields #5 #1 #2, #1 #2 #5, and #1 #5 #2. I only want the list of prerequisites to show up once. I've tried a bunch of stuff, but I'm obviously just guessing. Does anybody have a suggestion toward what I'm doing wrong? Thanks in advance, Megan SELECT class.classID, class.content, class_schedule.scheduleID, class_schedule.location, class_schedule.date, class_prereq.prereqID, class_prereq.prereq FROM class, class_schedule, class_prereq WHERE (pagename = 'classes_sea' and class.classID=class_schedule.classID and class_prereq.classID=class.classID) ORDER by rank, class_schedule.location, class_schedule.date class: #content# #prereq# #location#, #date# Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: nesting queries
Considering that do a simple join on the two tables to obtain results in one recordset. Thus: One Query: cfouput query=qyrAllEmp All variables would be: qryAllEmp.fieldnames Then you only need one CFOUTPUT and No CFLOOPS Also considering that within the Equipment table that EquipID is actually the Employee ID from the Employee Table. By what you showed in this statement is is. Somewhat odd, I would think that the EquipID would be the indtifier for the Equipment not the employee. SELECT tblEmployees.FieldOne,tblEmployees.FieldTwo,tblEquipment.Description FROM tblEmployees, tblEquipment WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' AND tblEmployees.Office LIKE '%' AND tblEmployees.Office LIKE '#office#%' AND tblEmployees.EMPID = tblEquipment.EquipID ORDER BY tblEmployees.lname -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 10:01 AM To: CF-Talk Subject: RE: nesting queries sure, i checked the database for one specific person that i know has information in the equipment table so the info is there..i just cant get it out! :) qry one: SELECT * FROM tblEmployees WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' AND tblEmployees.Office LIKE '%' AND tblEmployees.Office LIKE '#office#%' ORDER BY tblEmployees.lname qry two: SELECT * from tblEquipment WHERE EquipID = #iEquipID# -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 9:49 AM To: CF-Talk Subject: RE: nesting queries Then it is possible that the 2nd Query returns no records, Can you show me both queries -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 9:45 AM To: CF-Talk Subject: RE: nesting queries i tried that and i only get results from the first query... #qryAllEmp.FName# #strSpace# #qryAllEmp.MI# #StrSpace# #qryAllEmp.LName# #qryAllEmp.Dept# #qryAllEmp.Office##qryAllEmp.Floor##qryAllEmp.Phone# Equipment: #qryEquipment.Description# -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:58 AM To: CF-Talk Subject: RE: nesting queries You can place a CFOUTPUT at the very top of the Queries and instead of using CFOUTPUT QUERY, use a CFLOOP Query just make sure when you are outputing the query results you use the prefix for the given query Example: CFOUPUT CFLOOP QUERY=Query1 #Query1.MYFIELD# CFLOOP Query=Query2 #Query2.MyField# CFLOOP Query=Query3 #Query3.MyField# Also make sure you close the loops when needed to reduce the looping through unneeded records. HTH -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:58 AM To: CF-Talk Subject: nesting queries I have 3 queries. But when i try to nest the cfoutput tags i get an error that says this in to allowed. how do you use the cfoutput tags to output your information if the data to your second and third query is dependent upon the info from the first? here are my first 2 queries. SELECT * FROM tblEmployees WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' AND tblEmployees.Office LIKE '%' AND tblEmployees.Office LIKE '#office#%' ORDER BY tblEmployees.lname SELECT * from tblEquipment WHERE EquipID = #iEquipID# I want to be able to have one table that i can put the information all together. any ideas? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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:
OT/Summary: DB Server Upgrade Dilemma
I've been wrestling with whether to upgrade a Compaq Proliant 6000 or get a new server entirely. We're preparing to drastically increase the size and use of our database and I need to make a decision. We're running Oracle 8.0.5 on NT4 SP6 right now. The 6000 is a 1x 400mhz Xeon 512k. (it was here when I got here...) For about $1300 I can add three more Xeons and make it a 4-cpu server and was going to rebuild using Win2k AS. My basic question was what's better? 4 x 400mhz or 2 x 800mhz? Everyone I talked to seemed to agree that for this purpose (database, particularly Oracle), the 4 cpu setup would be better, especially for simultaneous access among clients. And given that for $1300, it's still on a redundant power supply machine with a raid drive array and all that good heavy duty server stuff that I wouldn't be able to get in a dual 800mhz machine for less than $4k... Thoughts, comments, suggestions? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.linktoss.com ___The Fastest Way to Send a Link to Anyone! http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.cfug-sfl.org ___South Florida Cold Fusion Users Group http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion ~~ 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
Javascript IsDefined
Hi Folks, What is the Javascript equivalent to the Cold Fusion IsDefined function? (or does one even exist?!) TIA, - - - Jeanne ~~ 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: nesting queries
i tried doing that first. but the problem i run into is that i want to have Prev/next buttons. and when i loop thru, it minuses one of the applications/equipment for an indivual person each time it loops. inotherwords...say for me i have 3 pieces of equipment. my record count shows that i have 3 records not one. and if i click on the next button it will have my name minus a piece of equipment. and so on. so i thought maybe doing seperate queries would help with the record counting. but i guess that is another issue. -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 10:03 AM To: CF-Talk Subject: RE: nesting queries Considering that do a simple join on the two tables to obtain results in one recordset. Thus: One Query: cfouput query=qyrAllEmp All variables would be: qryAllEmp.fieldnames Then you only need one CFOUTPUT and No CFLOOPS Also considering that within the Equipment table that EquipID is actually the Employee ID from the Employee Table. By what you showed in this statement is is. Somewhat odd, I would think that the EquipID would be the indtifier for the Equipment not the employee. SELECT tblEmployees.FieldOne,tblEmployees.FieldTwo,tblEquipment.Description FROM tblEmployees, tblEquipment WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' AND tblEmployees.Office LIKE '%' AND tblEmployees.Office LIKE '#office#%' AND tblEmployees.EMPID = tblEquipment.EquipID ORDER BY tblEmployees.lname -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 10:01 AM To: CF-Talk Subject: RE: nesting queries sure, i checked the database for one specific person that i know has information in the equipment table so the info is there..i just cant get it out! :) qry one: SELECT * FROM tblEmployees WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' AND tblEmployees.Office LIKE '%' AND tblEmployees.Office LIKE '#office#%' ORDER BY tblEmployees.lname qry two: SELECT * from tblEquipment WHERE EquipID = #iEquipID# -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 9:49 AM To: CF-Talk Subject: RE: nesting queries Then it is possible that the 2nd Query returns no records, Can you show me both queries -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 9:45 AM To: CF-Talk Subject: RE: nesting queries i tried that and i only get results from the first query... #qryAllEmp.FName# #strSpace# #qryAllEmp.MI# #StrSpace# #qryAllEmp.LName# #qryAllEmp.Dept# #qryAllEmp.Office##qryAllEmp.Floor##qryAllEmp.Phone# Equipment: #qryEquipment.Description# -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:58 AM To: CF-Talk Subject: RE: nesting queries You can place a CFOUTPUT at the very top of the Queries and instead of using CFOUTPUT QUERY, use a CFLOOP Query just make sure when you are outputing the query results you use the prefix for the given query Example: CFOUPUT CFLOOP QUERY=Query1 #Query1.MYFIELD# CFLOOP Query=Query2 #Query2.MyField# CFLOOP Query=Query3 #Query3.MyField# Also make sure you close the loops when needed to reduce the looping through unneeded records. HTH -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:58 AM To: CF-Talk Subject: nesting queries I have 3 queries. But when i try to nest the cfoutput tags i get an error that says this in to allowed. how do you use the cfoutput tags to output your information if the data to your second and third query is dependent upon the info from the first? here are my first 2 queries. SELECT * FROM tblEmployees WHERE tblEmployees.FName LIKE '#fname#%' AND tblEmployees.LName LIKE '#lname#%' AND tblEmployees.Office LIKE '%' AND tblEmployees.Office LIKE '#office#%' ORDER BY tblEmployees.lname SELECT * from tblEquipment WHERE EquipID = #iEquipID# I want to be able to have on
RE: Javascript IsDefined
You can use the "typeof" operator. if (typeof myVarName == "undefined"){ } -Original Message- From: Jeanne Sarfaty Glazer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 9:27 AM To: CF-Talk Subject: Javascript IsDefined Hi Folks, What is the Javascript equivalent to the Cold Fusion IsDefined function? (or does one even exist?!) TIA, - - - Jeanne ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascript IsDefined
JS doesn't inherently have isDefined... The functions that follow should help you though Michael Rosario Internet Applications Dev [EMAIL PROTECTED] ** // DESCRIPTION:Returns the value named in a URL parameter // PARAMS: strName is a string naming the what you want // EXAMPLE:If window.location.href ="../../somePage?screenid=cm100&action=doSomething" // getURLValue("action") will return "doSomething" function getURLValue(strName) { returnValue = null; params = window.location.search; temp = params.substring(1,params.length); //Kill off the '?' valuePairList = temp.split("&"); for(i=0; imailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 10:27 AM To: CF-Talk Subject: Javascript IsDefined Hi Folks, What is the Javascript equivalent to the Cold Fusion IsDefined function? (or does one even exist?!) TIA, - - - Jeanne ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascript IsDefined
why not use this... For variable x do: if (x) then balh blah blah IIRC, in JavaScript, if a var is 'defined', then a conditional returns true. ie: if (document.layers) then blah blah - Douglas Knudsen Leveraged Technologies Group Alltel AIS 678-351-6063 Got Linux? http://linuxmall.com From: [EMAIL PROTECTED] AT INTERNET on 03/13/2001 10:32 AM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: RE: Javascript IsDefined JS doesn't inherently have isDefined... The functions that follow should help you though Michael Rosario Internet Applications Dev [EMAIL PROTECTED] ** ** ** // DESCRIPTION: Returns the value named in a URL parameter // PARAMS: strName is a string naming the what you want // EXAMPLE: If window.location.href ="../../somePage?screenid=cm100&action=doSomething" // getURLValue("action") will return "doSomething" function getURLValue(strName) { returnValue = null; params = window.location.search; temp = params.substring(1,params.length); //Kill off the '?' valuePairList = temp.split("&"); for(i=0; imailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 10:27 AM To: CF-Talk Subject: Javascript IsDefined Hi Folks, What is the Javascript equivalent to the Cold Fusion IsDefined function? (or does one even exist?!) TIA, - - - Jeanne ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Studio 4.5.2 Memory Leak?
CF Studio 4.5.2 Memory Leak? My question is my fellow employees and I seem to be having lots of problems with memory when we have CF Studio 4.5.2 open. Even if we boot up a machine and don't do anything more then open CF Studio 4.5.2 and leave the machine open all day it will lock up before the day is out. Has anyone else had this problem? Is Allaire addressing this problem? Is the a fix for this problem? Nathan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio 4.5.2 Memory Leak?
I have never experienced a problem with my studio 4.5.2 and I run it with my database open, email, browser, and adobe photoshop. I am running on a 2000 professional and never had a problem. -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 9:50 AM To: CF-Talk Subject: CF Studio 4.5.2 Memory Leak? CF Studio 4.5.2 Memory Leak? My question is my fellow employees and I seem to be having lots of problems with memory when we have CF Studio 4.5.2 open. Even if we boot up a machine and don't do anything more then open CF Studio 4.5.2 and leave the machine open all day it will lock up before the day is out. Has anyone else had this problem? Is Allaire addressing this problem? Is the a fix for this problem? Nathan ~~ 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
cfexecute and prompts
I am trying to run a program with . The problem I am having is that the program has a prompt built into it. Every time I run it via it gets to the prompt and just sits there waiting on an answer. Does have any provisions for skipping over things like this? Is there any way at all to get past the prompt programmatically? Todd Ashworth -- Web Application Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] ~~ 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: [cfexecute and prompts]
yes. post your code. "Todd Ashworth" <[EMAIL PROTECTED]> wrote: I am trying to run a program with . The problem I am having is that the program has a prompt built into it. Every time I run it via it gets to the prompt and just sits there waiting on an answer. Does have any provisions for skipping over things like this? Is there any way at all to get past the prompt programmatically? Todd Ashworth -- Web Application Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Studio 4.5.2 Memory Leak?
What OS? How much memory? We are running 4.5.1 and 4.5.2 on NT4 SP6 and 128MB of ram on PIIIs. Version 4.5.1 tends to freak out if it is run all day, but not 4.5.2. - Douglas Knudsen Leveraged Technologies Group Alltel AIS 678-351-6063 Got Linux? http://linuxmall.com From: [EMAIL PROTECTED] AT INTERNET on 03/13/2001 10:49 AM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: CF Studio 4.5.2 Memory Leak? CF Studio 4.5.2 Memory Leak? My question is my fellow employees and I seem to be having lots of problems with memory when we have CF Studio 4.5.2 open. Even if we boot up a machine and don't do anything more then open CF Studio 4.5.2 and leave the machine open all day it will lock up before the day is out. Has anyone else had this problem? Is Allaire addressing this problem? Is the a fix for this problem? Nathan ~~ 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
Thanks for the info: migration from NT4 to Solaris
Thanks a lot ! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Studio 4.5.2 Memory Leak?
If you send a query requests to the CF Server and it returns a large number of records I've seen studio lock up. But thats about it Corrine Clark wrote: > > I have never experienced a problem with my studio 4.5.2 and I run it with my > database open, email, browser, and adobe photoshop. I am running on a 2000 > professional and never had a problem. > > -Original Message- > From: Nathan Stanford [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 13, 2001 9:50 AM > To: CF-Talk > Subject: CF Studio 4.5.2 Memory Leak? > > CF Studio 4.5.2 Memory Leak? > > My question is my fellow employees and I seem to be having lots of problems > with memory when we have CF Studio 4.5.2 open. Even if we boot up a > machine and don't do anything more then open CF Studio 4.5.2 and leave the > machine open all day it will lock up before the day is out. > > Has anyone else had this problem? > > Is Allaire addressing this problem? > > Is the a fix for this problem? > > Nathan > ~~ 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: Project Mgmt for CF development?
Did you ever think that this information might be necessary to bill clients? Or to allocate resources to projects efficiently? Or to make accurate estimates of project completion dates? Or to forecast hiring needs? (I'm not saying your manager wasn't an asshole :-) I didn't know the guy. Just that tracking this information, while annoying, can be very useful, and often meets a lot of resistance from the 'creative' talent) At 09:06 PM 3/12/01 -0800, laszlo wrote: >>>..we use a time keeping system, where developers enter how much >>>hours they worked on for certain tasks on a certain day >Many years ago I worked for an asshole manager who's primary task was to do this. >I was in charge to write the stupid 'time-tracking' app.. >Needless to say, creative programmers were forced to spend more time maintaining >their 'progress report' and >justifying their hours than working on the actual project. >It just didn't not make any other sence, than the guy covered his behind in front of >the 'upper' management. >There is a certain level of trust/enpowerment, managers should exercise or they are >just out of touch... >Unfortunately, there are still way too may of them out there with way too much power. > >just my 2c's, >laszlo > >Phoeun Pha wrote: > >> here at work we use a time keeping system, where developers enter how much >> hours they worked on for certain tasks on a certain day (tasks, developers >> can be added/deleted/edited). u also enter the allotted time for that >> certain task, and if it goes over, the hours put into that task turns red. >> u can also view reports, so u can get a better look at how far along the >> project is going, and get a good idea of how long it will take u to do >> certain things. in the end, u learn how to manage time better. oh i >> forgot, that u can also add new projects. >> >> i also recommend a web based bug-list, where testers can report bugs, and >> check off bugs that have been fixed. u know, display who reported the bug, >> when it was tested, description, stuff like that. oh, also u can upload a >> screen shot! To make it even cooler, allow users to only mess with one >> part(s) of the bug list, so that way another person can use the buglist >> (with those parts missing)! (i've coded that kinda stuff several times). >> >> how about running a frame containing email throughout your app? it wil only >> contain the subject of the email, but it would be convenient if i had access >> to it at all times. u can set it to refresh every 20 seconds or 40 minutes >> or whatever (or allow the user to do it). and when they get new email they >> see it, and make it play a loud annoying sound, and they click on a link, >> and a javascript pop up window shows up with the message. >> >> how about another frame to the left that displays the name of all developers >> currently working on the project at that moment? click on their name, and a >> java applet shows up and u can send them a message, or have a little chat. >> but why do that when u have MSN messenger??? nevermind! >> >> -Original Message- >> From: Leighton Tebay [mailto:[EMAIL PROTECTED]] >> Sent: Monday, March 12, 2001 4:34 PM >> To: CF-Talk >> Subject: OT: Project Mgmt for CF development? >> >> We are feeling the need to implement a project managment/collaboration >> software. Outlook just doesn't cut it. >> >> What do you recommend for web app development? >> >> Leighton Tebay >> >> - Original Message - >> From: "Bryan Love" <[EMAIL PROTECTED]> >> To: "CF-Talk" <[EMAIL PROTECTED]> >> Sent: Monday, March 12, 2001 4:06 PM >> Subject: RE: Any recommendations on an E-commerce software? >> >> > How bout a fully fuseboxed, scalable commerce app available with open >> > source? >> > >> > for a demo go here: >> > http://writtenword.adhost.com/blove/Admin/ >> > >> > Uname: demo >> > Pword: demo >> > >> > >> > Bryan Love ACP >> > Internet Application Developer >> > [EMAIL PROTECTED] >> > >> > >> > >> > -Original Message- >> > From: Ashley Hart [mailto:[EMAIL PROTECTED]] >> > Sent: Monday, March 12, 2001 7:55 AM >> > To: CF-Talk >> > Subject: Any recommendations on an E-commerce software? >> > >> > >> > Hi, >> > >> > I have a client that has a limited budget and can't afford for us to >> > build them an e-commerce store from scratch, so I wanted to find out if >> > anyone knew a good software that had admin reports, allowed for design, >> > product and layout setup customization, and allowed repeat customers to >> > have an account setup that they could view what they bought in the past, >> > saved all of their account information, including their credit cards >> > (like Amazon). I used Miva Merchant once, and it was awful. >> > >> > -ashley >> > >> > >> >> > ~~ 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/ Unsu
Re: [cfexecute and prompts]
Basicly what I am doing is having someone upload a zip file which I can then unzip using a command line program. The first thing the command line program does upon being executed is ask a question and wait for a response. Since the execution can never be completed, it just sits in memory forever. Todd Ashworth -- Web Application Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] - Original Message - From: "Alex" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 13, 2001 10:56 AM Subject: Re: [cfexecute and prompts] | yes. post your code. | | "Todd Ashworth" <[EMAIL PROTECTED]> wrote: | I am trying to run a program with . The problem I am having is | that the program has a prompt built into it. Every time I run it via | it gets to the prompt and just sits there waiting on an answer. | Does have any provisions for skipping over things like this? Is | there any way at all to get past the prompt programmatically? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio 4.5.2 Memory Leak?
My version of CF Studio 4.5.2 is very touchy - I've had to re-install it three times over the past 3 months, sometimes the RDS does not link and fails completely with a "can't find library" file error, other days the code checker falls over completely, refusing to run - (but if I open the previous 4.1 version and run code checker it works - then go back to 4.5.2 and re-run code validator it then works), also I can be running CF Studio on its own (with nothing else open) on a PIII 650 with 256mb of RAM and with nearly 1gig of virtual mem and it warns me that my memory is running low J -Original Message- From: Lewis Steven [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 16:01 To: CF-Talk Subject: Re: CF Studio 4.5.2 Memory Leak? If you send a query requests to the CF Server and it returns a large number of records I've seen studio lock up. But thats about it Corrine Clark wrote: > > I have never experienced a problem with my studio 4.5.2 and I run it with my > database open, email, browser, and adobe photoshop. I am running on a 2000 > professional and never had a problem. > > -Original Message- > From: Nathan Stanford [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 13, 2001 9:50 AM > To: CF-Talk > Subject: CF Studio 4.5.2 Memory Leak? > > CF Studio 4.5.2 Memory Leak? > > My question is my fellow employees and I seem to be having lots of problems > with memory when we have CF Studio 4.5.2 open. Even if we boot up a > machine and don't do anything more then open CF Studio 4.5.2 and leave the > machine open all day it will lock up before the day is out. > > Has anyone else had this problem? > > Is Allaire addressing this problem? > > Is the a fix for this problem? > > Nathan > ~~ 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
First crack at commerce, sort of.
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C0ABD9.673F79C0 Content-Type: text/plain; charset="iso-8859-1" Hi All, I have a number of small clients who mostly have very basic Cold Fusion driven sites. I have a potential new client (a Deli) who has corporate customers that want to have access his menus and place orders online. He does not yet want full blown e-commerce with CC transactions but does want to allow about 1,000 users into the site to place orders on a daily basis. For my smaller sites I have used Access 2000 and have not had problems. With this new client I have concerns regarding concurrent hits to the DB to pull menu items and to capture and archive orders. Most things I have read state that Access 97 is not to be used for even moderate traffic sites, but I have seen claims by MicroSoft that Access 2000 is more robust. Is this just hype? Should my menus, order info, and security all be kept in separate databases? If anyone has any other advice based on my scenario I'd love to hear it. Brian Kortland Cyberplugs.com --_=_NextPart_001_01C0ABD9.673F79C0 Content-Type: text/html; charset="iso-8859-1" First crack at commerce, sort of. Hi All, I have a number of small clients who mostly have very basic Cold Fusion driven sites. I have a potential new client (a Deli) who has corporate customers that want to have access his menus and place orders online. He does not yet want full blown e-commerce with CC transactions but does want to allow about 1,000 users into the site to place orders on a daily basis. For my smaller sites I have used Access 2000 and have not had problems. With this new client I have concerns regarding concurrent hits to the DB to pull menu items and to capture and archive orders. Most things I have read state that Access 97 is not to be used for even moderate traffic sites, but I have seen claims by MicroSoft that Access 2000 is more robust. Is this just hype? Should my menus, order info, and security all be kept in separate databases? If anyone has any other advice based on my scenario I'd love to hear it. Brian Kortland Cyberplugs.com --_=_NextPart_001_01C0ABD9.673F79C0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfloop
>From a select box I am selecting a single vehicle or all vehicles and pass the parameter to a second template which determines my vairables type of existence, SELECT callsign, vowner, dt, Lat, Lon, Speed, Direction, Veh_Reg FROMdbo.vehicles WHERE vowner = 222 SELECT callsign, vowner, dt, Lat, Lon, Speed, Direction, Veh_Reg FROMdbo.vehicles WHERE callsign = '#form.callsign#' Then I am passing to a second server to get the vehicle positioning, I wanted to do this the proper way with cfhttp, but due to buggy problems with 4.5.1 and cfhttp I have done it this way, http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#&data=#data #&zoom=#zoom#&x=#qry_getVeichle.lon#&y=#qry_getVeichle.lat#&symbol=#qry_getV eichle.lon#,#qry_getVeichle.lat#,target,#callsign#"> This is fine for one vehicle, but for multable I still only get the first vehicle in the recordset, even though I loop through my query for the existence of all. If I test my looped query like so, http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#&data=#data #&zoom=#zoom#&x=#qry_getVeichle.lon#&y=#qry_getVeichle.lat#&symbol=#qry_getV eichle.lon#,#qry_getVeichle.lat#,target,#callsign#"> the obvious happens I get multable vehieles displayed but on multible maps, (I know, duuu!!) so I think that my problem lies somewhere around startrow="#start#" endrow="#max#" which works fine when outputting to html or else the problems with the 'mapview.exe' which would be a completely different issue. If some one could send me in the right direction with my cfloop though, it would be mighty appreciated. Thanx world.. ~~ 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: cfexecute and prompts
Not unless the program in question accepts paramaters from the command line. -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 15:55 To: CF-Talk Subject: cfexecute and prompts I am trying to run a program with . The problem I am having is that the program has a prompt built into it. Every time I run it via it gets to the prompt and just sits there waiting on an answer. Does have any provisions for skipping over things like this? Is there any way at all to get past the prompt programmatically? Todd Ashworth -- Web Application Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] ~~ 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
Ben Forta tonite!! in Dallas
Just wanted to post this message in case there's anyone in here who would be interested in attending tonite's meeting of the Dallas/Fort Worth ColdFusion User Group, where Ben will be speaking. For details go to www.dfwcfug.org -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: [cfexecute and prompts]]
write a DOS batch file and call that from cfexecute. you need 2 files ..1)the *.bat and 2)a text file that is just a y and carriage return ex. *.bat wzunzip stuffvariable < y.txt "Todd Ashworth" <[EMAIL PROTECTED]> wrote: Basicly what I am doing is having someone upload a zip file which I can then unzip using a command line program. The first thing the command line program does upon being executed is ask a question and wait for a response. Since the execution can never be completed, it just sits in memory forever. Todd Ashworth -- Web Application Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] - Original Message - From: "Alex" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 13, 2001 10:56 AM Subject: Re: [cfexecute and prompts] | yes. post your code. | | "Todd Ashworth" <[EMAIL PROTECTED]> wrote: | I am trying to run a program with . The problem I am having is | that the program has a prompt built into it. Every time I run it via | it gets to the prompt and just sits there waiting on an answer. | Does have any provisions for skipping over things like this? Is | there any way at all to get past the prompt programmatically? ~~ 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: cfloop
Have you tried Or use a CFLoop http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#&data=#data #&zoom=#zoom#&x=#qry_getVeichle.lon#&y=#qry_getVeichle.lat#&symbol=#qry_getV eichle.lon#,#qry_getVeichle.lat#,target,#callsign#"> Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 16:19 To: CF-Talk Subject: cfloop >From a select box I am selecting a single vehicle or all vehicles and pass the parameter to a second template which determines my vairables type of existence, SELECT callsign, vowner, dt, Lat, Lon, Speed, Direction, Veh_Reg FROMdbo.vehicles WHERE vowner = 222 SELECT callsign, vowner, dt, Lat, Lon, Speed, Direction, Veh_Reg FROMdbo.vehicles WHERE callsign = '#form.callsign#' Then I am passing to a second server to get the vehicle positioning, I wanted to do this the proper way with cfhttp, but due to buggy problems with 4.5.1 and cfhttp I have done it this way, http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#&data=#data #&zoom=#zoom#&x=#qry_getVeichle.lon#&y=#qry_getVeichle.lat#&symbol=#qry_getV eichle.lon#,#qry_getVeichle.lat#,target,#callsign#"> This is fine for one vehicle, but for multable I still only get the first vehicle in the recordset, even though I loop through my query for the existence of all. If I test my looped query like so, http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#&data=#data #&zoom=#zoom#&x=#qry_getVeichle.lon#&y=#qry_getVeichle.lat#&symbol=#qry_getV eichle.lon#,#qry_getVeichle.lat#,target,#callsign#"> the obvious happens I get multable vehieles displayed but on multible maps, (I know, duuu!!) so I think that my problem lies somewhere around startrow="#start#" endrow="#max#" which works fine when outputting to html or else the problems with the 'mapview.exe' which would be a completely different issue. If some one could send me in the right direction with my cfloop though, it would be mighty appreciated. Thanx world.. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Who's the Moderator of this List?
This seems like a silly question and please don't yell at me for asking, but I was looking for a moderator's direct email address and name and couldn't find one, here or on the website. (I have over 4000 CF_Talk emails, and I searched through all of them) although, not knowing the person's actual name was a hindrance. Sorry in advance for an extra email in your box, Erika AIM: WebErika5 Yahoo: WebErika MSN: WebErika AskMe.com Expert: WebErika Erika L. Walker Vice President RUWebby, LLC 201-370-4272 (c) 973-244-9120 (o) 153 Rutgers Lane Parsippany, NJ 07054 Website Design/Programming Database Integration Allaire Partner - ColdFusion ~~ 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: Responding to Post's
Get It - Got It - Good <:-)) ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Michael [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 9:14 AM To: CF-Talk Subject:Re: Responding to Post's All I am saying is if responding to a message respond to the message in that message's header, like this one "Arden Weiss" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Okay, tell me more -- what are you talking about -- what is "the appropriate post note" -- I don't have an "any key" either. > > ^ > / \__ >(@\___ > / O > /(_/ > /_/ > Whoof... > 410-757-3487 > > -Original Message- > From: Michael [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, March 13, 2001 6:28 AM > To: CF-Talk > Subject: OT: Responding to Post's > > Why cant people respond to the post in the appropriate post note and not mix > match things, ?? > > Just a question, not trying to start a flame war or something, just seems > that lately alot of this is happening, then again maybe its just me. > ~~ 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: nesting queries
At the risk of having seventeen other people tell you how to do it... All that this code... does is: Try using instead. Also if you want to create a query based on another query, you have to loop over the first query, create the new query, and then output that query: SELECT * FROM myTable ORDER BY myField asc SELECT * FROM table WHERE aField = '#query1.myfield#' #Query2.aField# However, this is not efficient as there are going to be the same number of database calls as there are records returned in the first query! Try to use the database to return a much more useful result set (if you're using MS SQL Server that means a stored procedure - ask if you're not sure). If you can then output the resultset once, you only need to go to the database once and you only need to output it once (and it's a lot easier on ColdFusion too!). I hope this makes sense! Paul Paul Johnston PJ Net Solutions Ltd E: [EMAIL PROTECTED] M: 07866 573013 - Original Message - From: "Jones, Becky" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 13, 2001 1:57 PM Subject: nesting queries > I have 3 queries. But when i try to nest the cfoutput tags i get an error > that says this in to allowed. > how do you use the cfoutput tags to output your information if the data to > your second and third query is dependent upon the info from the first? > here are my first 2 queries. > > > SELECT * FROM tblEmployees > WHERE > tblEmployees.FName LIKE '#fname#%' > AND tblEmployees.LName LIKE '#lname#%' > > AND tblEmployees.Office LIKE '%' > > AND tblEmployees.Office LIKE '#office#%' > > ORDER BY tblEmployees.lname > > > > > SELECT * from tblEquipment > WHERE EquipID = #iEquipID# > > I want to be able to have one table that i can put the information all > together. any ideas? > > > * > This e-mail, including any attachments, is intended for the > receipt and use by the intended addressee(s), and may contain > confidential and privileged information. If you are not an intended > recipient of this e-mail, you are hereby notified that any unauthorized > use or distribution of this e-mail is strictly prohibited. > > > > ~~ 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: Who's the Moderator of this List?
Michael Dinowitz Publisher: Fusion Authority weekly news alert (www.fusionauthority.com/alert) Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc. (www.houseoffusion.com) - Original Message - From: "Erika L Walker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 13, 2001 11:38 AM Subject: OT: Who's the Moderator of this List? > This seems like a silly question and please don't yell at me for asking, but > I was looking for a moderator's direct email address and name and couldn't > find one, here or on the website. (I have over 4000 CF_Talk emails, and I > searched through all of them) although, not knowing the person's actual name > was a hindrance. > > Sorry in advance for an extra email in your box, > > Erika > > > > AIM: WebErika5 > Yahoo: WebErika > MSN: WebErika > AskMe.com Expert: WebErika > > Erika L. Walker > Vice President > RUWebby, LLC > 201-370-4272 (c) > 973-244-9120 (o) > 153 Rutgers Lane > Parsippany, NJ 07054 > > Website Design/Programming > Database Integration > Allaire Partner - ColdFusion > > > > > > ~~ 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: Who's the Moderator of this List?
Michael Dinowitz [[EMAIL PROTECTED]] -Original Message- From: Erika L Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:39 AM To: CF-Talk Subject: OT: Who's the Moderator of this List? This seems like a silly question and please don't yell at me for asking, but I was looking for a moderator's direct email address and name and couldn't find one, here or on the website. (I have over 4000 CF_Talk emails, and I searched through all of them) although, not knowing the person's actual name was a hindrance. Sorry in advance for an extra email in your box, Erika AIM: WebErika5 Yahoo: WebErika MSN: WebErika AskMe.com Expert: WebErika Erika L. Walker Vice President RUWebby, LLC 201-370-4272 (c) 973-244-9120 (o) 153 Rutgers Lane Parsippany, NJ 07054 Website Design/Programming Database Integration Allaire Partner - ColdFusion ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Studio 4.5.2 Memory Leak?
Nathan, When I have Studio and Server running all day I also have my system lock up. This has become quite annoying especially at the end of a long day. - Original Message - From: "Nathan Stanford" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 13, 2001 9:49 AM Subject: CF Studio 4.5.2 Memory Leak? > CF Studio 4.5.2 Memory Leak? > > My question is my fellow employees and I seem to be having lots of problems > with memory when we have CF Studio 4.5.2 open. Even if we boot up a > machine and don't do anything more then open CF Studio 4.5.2 and leave the > machine open all day it will lock up before the day is out. > > Has anyone else had this problem? > > Is Allaire addressing this problem? > > Is the a fix for this problem? > > Nathan > > ~~ 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: First crack at commerce, sort of.
go with SQL or mysql -Original Message- From: Kortland, Brian [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 10:20 AM To: CF-Talk Subject: First crack at commerce, sort of. This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C0ABD9.673F79C0 Content-Type: text/plain; charset="iso-8859-1" Hi All, I have a number of small clients who mostly have very basic Cold Fusion driven sites. I have a potential new client (a Deli) who has corporate customers that want to have access his menus and place orders online. He does not yet want full blown e-commerce with CC transactions but does want to allow about 1,000 users into the site to place orders on a daily basis. For my smaller sites I have used Access 2000 and have not had problems. With this new client I have concerns regarding concurrent hits to the DB to pull menu items and to capture and archive orders. Most things I have read state that Access 97 is not to be used for even moderate traffic sites, but I have seen claims by MicroSoft that Access 2000 is more robust. Is this just hype? Should my menus, order info, and security all be kept in separate databases? If anyone has any other advice based on my scenario I'd love to hear it. Brian Kortland Cyberplugs.com --_=_NextPart_001_01C0ABD9.673F79C0 Content-Type: text/html; charset="iso-8859-1" First crack at commerce, sort of. Hi All, I have a number of small clients who mostly have very basic Cold Fusion driven sites. I have a potential new client (a Deli) who has corporate customers that want to have access his menus and place orders online. He does not yet want full blown e-commerce with CC transactions but does want to allow about 1,000 users into the site to place orders on a daily basis. For my smaller sites I have used Access 2000 and have not had problems. With this new client I have concerns regarding concurrent hits to the DB to pull menu items and to capture and archive orders. Most things I have read state that Access 97 is not to be used for even moderate traffic sites, but I have seen claims by MicroSoft that Access 2000 is more robust. Is this just hype? Should my menus, order info, and security all be kept in separate databases? If anyone has any other advice based on my scenario I'd love to hear it. Brian Kortland Cyberplugs.com --_=_NextPart_001_01C0ABD9.673F79C0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Server log errors
I have a setup of 4 servers - 2 web servers (NT & IIS) and 2 database servers (SQL 7), one active and one passive. The web servers are load balanced but both use the actyive SQL machine. Sometimes both CF servers die and by looking at the error logs it appears that SQL Server is deadlocking. What is the likely cause of this? Will it be a coding issue? In the CF server log I get a meesage saying: "Error","TID=67","03/13/01","09:40:58","ExprParser: CFuncIsDefined::DoIt: unknown".followed by: "Error","TID=67","03/13/01","09:40:58","Unexpected exception while processing a tag with a general identifier of (CFIF), occupying document position (32:1) to (32:40), while executing template file D:\www\connexions\Application.cfm" The line of code in question it is complaining about in the application.cfm is: CF then restarts itself and the same thing happens again but on a different line in the application.cfm. This time line 47 which is: Anyone had this happen before? A -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. ~~ 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: First crack at commerce, sort of.
I agree that you should use a true DBMS if possible, but Access can probably be made to work Ok for just 1000 users.I would consider switching away from Access if you have more than 5-10 simultaneous connections, or more than a 100-200k records. If you use Access, make judicious use of cached queries and other optimizations as much as possible. Kevin >>> [EMAIL PROTECTED] 03/13/01 08:49AM >>> go with SQL or mysql -Original Message- From: Kortland, Brian [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 10:20 AM To: CF-Talk Subject: First crack at commerce, sort of. This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C0ABD9.673F79C0 Content-Type: text/plain; charset="iso-8859-1" Hi All, I have a number of small clients who mostly have very basic Cold Fusion driven sites. I have a potential new client (a Deli) who has corporate customers that want to have access his menus and place orders online. He does not yet want full blown e-commerce with CC transactions but does want to allow about 1,000 users into the site to place orders on a daily basis. For my smaller sites I have used Access 2000 and have not had problems. With this new client I have concerns regarding concurrent hits to the DB to pull menu items and to capture and archive orders. Most things I have read state that Access 97 is not to be used for even moderate traffic sites, but I have seen claims by MicroSoft that Access 2000 is more robust. Is this just hype? Should my menus, order info, and security all be kept in separate databases? If anyone has any other advice based on my scenario I'd love to hear it. Brian Kortland Cyberplugs.com --_=_NextPart_001_01C0ABD9.673F79C0 Content-Type: text/html; charset="iso-8859-1" First crack at commerce, sort of. Hi All, I have a number of small clients who mostly have very basic Cold Fusion driven sites. I have a potential new client (a Deli) who has corporate customers that want to have access his menus and place orders online. He does not yet want full blown e-commerce with CC transactions but does want to allow about 1,000 users into the site to place orders on a daily basis. For my smaller sites I have used Access 2000 and have not had problems. With this new client I have concerns regarding concurrent hits to the DB to pull menu items and to capture and archive orders. Most things I have read state that Access 97 is not to be used for even moderate traffic sites, but I have seen claims by MicroSoft that Access 2000 is more robust. Is this just hype? Should my menus, order info, and security all be kept in separate databases? If anyone has any other advice based on my scenario I'd love to hear it. Brian Kortland Cyberplugs.com --_=_NextPart_001_01C0ABD9.673F79C0-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Crashes my server?
hello all, I am using the CF_EmbedFields tag in a 3 part form. the first day that I used it everything worked fine. however now when I run that form. (3 days latter with NO changes to the site) my cfserver.exe ends up taking up 95% of the CPU usage (this is running local). has anyone else ever ran into this before? here is the code that I have used it in just in case you see something that might be doing this: Thanks for the help/input. if you need more than what I have given I will post it. Thanks, --> --> --> Jay Patton Web Design / Application Design Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com * "Trust Everyone But Always Cut The Cards." * ~~ 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: First crack at commerce, sort of.
I would use SQL or MySQL for this NOT! Access Jay Patton Web Design / Application Design Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com - Original Message - From: "Kortland, Brian" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 13, 2001 9:19 AM Subject: First crack at commerce, sort of. > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > --_=_NextPart_001_01C0ABD9.673F79C0 > Content-Type: text/plain; > charset="iso-8859-1" > > Hi All, > > I have a number of small clients who mostly have very basic Cold Fusion > driven sites. I have a potential new client (a Deli) who has corporate > customers that want to have access his menus and place orders online. He > does not yet want full blown e-commerce with CC transactions but does want > to allow about 1,000 users into the site to place orders on a daily basis. > For my smaller sites I have used Access 2000 and have not had problems. With > this new client I have concerns regarding concurrent hits to the DB to pull > menu items and to capture and archive orders. Most things I have read state > that Access 97 is not to be used for even moderate traffic sites, but I have > seen claims by MicroSoft that Access 2000 is more robust. Is this just hype? > > Should my menus, order info, and security all be kept in separate databases? > > If anyone has any other advice based on my scenario I'd love to hear it. > > Brian Kortland > Cyberplugs.com > > --_=_NextPart_001_01C0ABD9.673F79C0 > Content-Type: text/html; > charset="iso-8859-1" > > > > > > > First crack at commerce, sort of. > > > > Hi All, > > > I have a number of small clients who mostly have very basic Cold Fusion > driven sites. I have a potential new client (a Deli) who has corporate > customers that want to have access his menus and place orders online. He > does not yet want full blown e-commerce with CC transactions but does want > to allow about 1,000 users into the site to place orders on a daily basis. > For my smaller sites I have used Access 2000 and have not had problems. With > this new client I have concerns regarding concurrent hits to the DB to pull > menu items and to capture and archive orders. Most things I have read state > that Access 97 is not to be used for even moderate traffic sites, but I have > seen claims by MicroSoft that Access 2000 is more robust. Is this just hype? > > > Should my menus, order info, and security all be kept in separate databases? > > > If anyone has any other advice based on my scenario I'd love to hear it. > > > Brian Kortland > Cyberplugs.com > > > > > --_=_NextPart_001_01C0ABD9.673F79C0-- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Studio 4.5.2 Memory Leak?
Any time I have brought this issue up with Allaire or their distributors, they just look at me with scorn, as though I am some kind of fool and say "well you should be using Win2000" and the implied rest of the sentence seems to be "... instead of that childs toy you are using." My answer is, .. there are a lot of reasons I might be using Win98 on one machine, Win95 on another and Win2000 on a third. And it doesnt matter, because Allaire's specs don't say studio needs Win2K to work. It says specifically, that it works on Win95,98, and win2K. So it's my contention that Studio (all versions since 4.0.1, the first I've used) breach the Australian Sale Of Goods Act as being not of merchantable quality and unfit for the purpose for which they're sold. It could be a brilliant app, and even with all its faults I still use it, but I think it's poor value at about 50% more than Microsoft Office. And they don't seem to be doing anything at all about the issues. They even had the hide to send my client a bill for more than 50% of the original price as renewal of the subscription. And they hadn't done anything at all for the first year's! They need a session or two with Ralph Nader I reckon. Cheers, Mike Kear AFP Webworks, Windsor, NSW, Australia On Tue, 13 Mar 2001, Douglas Knudsen wrote: > > > What OS? How much memory? We are running 4.5.1 and 4.5.2 on NT4 SP6 > and 128MB of ram on PIIIs. Version 4.5.1 tends to freak out if it is > run all day, but not 4.5.2. > > > - > Douglas Knudsen > Leveraged Technologies Group > Alltel AIS > 678-351-6063 > Got Linux? http://linuxmall.com > > > > > From: [EMAIL PROTECTED] AT INTERNET on 03/13/2001 10:49 AM > > To: [EMAIL PROTECTED] AT INTERNET@CCMAIL > cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) > > Subject: CF Studio 4.5.2 Memory Leak? > > > CF Studio 4.5.2 Memory Leak? > > My question is my fellow employees and I seem to be having lots of > problems > with memory when we have CF Studio 4.5.2 open. Even if we boot up a > machine and don't do anything more then open CF Studio 4.5.2 and leave > the > machine open all day it will lock up before the day is out. > > Has anyone else had this problem? > > Is Allaire addressing this problem? > > Is the a fix for this problem? > > Nathan > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio 4.5.2 Memory Leak?
CFSTUIDO 4.5.2 is not the most stable app in the world, and is very easy to crash (try closing a window with JS in the internal browser - and watch those error messages!!!) but as far as memory holes go, its not nearly as bad as previous versions (I've been working with it for 2 days and I'm only upto 25Mb VM usage) I think if anything though, overall stability is no better, if not worse - but I'm not sure if this is studio, or MMC for ent manger running on NT - together they require me to reboot every couple of days.. Also - since upgrading to IE 5.5, memory usage seems to have gone through the roof... oten using over 50MB within a few hours of booting... -Original Message- From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 16:54 To: CF-Talk Subject: Re: CF Studio 4.5.2 Memory Leak? Nathan, When I have Studio and Server running all day I also have my system lock up. This has become quite annoying especially at the end of a long day. - Original Message - From: "Nathan Stanford" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 13, 2001 9:49 AM Subject: CF Studio 4.5.2 Memory Leak? > CF Studio 4.5.2 Memory Leak? > > My question is my fellow employees and I seem to be having lots of problems > with memory when we have CF Studio 4.5.2 open. Even if we boot up a > machine and don't do anything more then open CF Studio 4.5.2 and leave the > machine open all day it will lock up before the day is out. > > Has anyone else had this problem? > > Is Allaire addressing this problem? > > Is the a fix for this problem? > > Nathan > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio 4.5.2 Memory Leak?
If you do a search on Allaire's own ColdFusion Forum's in the CF Studio area you get 32 notes about this problem. April 1999 is the first request about the problem and the fact that using projects increases the problem. A Allaire Employee said that the project deployment increases the memory usage. There were some comments that it is not a Leak just a Memory Hog. When CF Studio tends to take more memory then PhotoShop then I think this needs fixed. Nathan P.S. I will see Ben tonight at the DFWCFUG Meeting. > -Original Message- > From: Michael S. Kimmett [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, March 13, 2001 10:54 AM > To: CF-Talk > Subject: Re: CF Studio 4.5.2 Memory Leak? > > Nathan, > > When I have Studio and Server running all day I also have my system lock > up. > This has become quite annoying especially at the end of a long day. > > > - Original Message - > From: "Nathan Stanford" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, March 13, 2001 9:49 AM > Subject: CF Studio 4.5.2 Memory Leak? > > > > CF Studio 4.5.2 Memory Leak? > > > > My question is my fellow employees and I seem to be having lots of > problems > > with memory when we have CF Studio 4.5.2 open. Even if we boot up a > > machine and don't do anything more then open CF Studio 4.5.2 and leave > the > > machine open all day it will lock up before the day is out. > > > > Has anyone else had this problem? > > > > Is Allaire addressing this problem? > > > > Is the a fix for this problem? > > > > Nathan > > > > > ~~ 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
one more Paradox question...
Ok we are going to be connecting to a Paradox 4.5 systemyes i knowoldbut besides that, i know that the M$ ODBC driver will lock the tables and mess everything up... :oP so has anyone worked with this and found a better ODBC driver? TIA Kevin ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] <> ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio 4.5.2 Memory Leak?
If it crashes and eats through memory don't use it and certainly don't purchase it! There are many good programmer editors out there. UltraEdit, MultiEdit, and the list goes on and on, give your money to something that is stable and is not counterproductive. Most of these editors have demos or eval copies and can be customized to do whatever you like. I have even read that the new multiedit integrates into studio, not sure I would want that but hey maybe it makes studio more stable. Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascript IsDefined
The correct syntax is if (typeof(myvarname) == "undefined") { [do your stuff] } |-Original Message- |From: Hayes, David [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, March 13, 2001 10:32 AM |To: CF-Talk |Subject: RE: Javascript IsDefined | | |You can use the "typeof" operator. | |if (typeof myVarName == "undefined"){ | |} | |-Original Message- |From: Jeanne Sarfaty Glazer [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, March 13, 2001 9:27 AM |To: CF-Talk |Subject: Javascript IsDefined | | |Hi Folks, | |What is the Javascript equivalent to the Cold Fusion IsDefined |function? |(or does one even exist?!) | |TIA, |- - - Jeanne | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: parsing form submission into an html file?
I have in the past used CFFILE to generate .htm files - what exactly are you wanting to do??? -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 01:48 To: CF-Talk Subject: parsing form submission into an html file? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 does anyone know of a way to create an html file from a form submission, or to insert the form fields into a template and save the result as an html file? I can't find anything on the net, and cffile seems to not be what I need. - -- Jon Tillman http://www.eruditum.org finger [EMAIL PROTECTED] to annoy the MPAA To be yourself, in a world that tries, night and day, to make you just like everybody else - is to fight the greatest battle there ever is to fight, and never stop fighting. --e.e. cummings -BEGIN PGP SIGNATURE- Version: PGP 6.5.1i iQA/AwUBOqg2Vtga7tZtnIOtEQJKDACgq6xlHux9uAaJd8mXljcgylUGMcAAn0xj K/bfzq+xEIRNVqU+6203y4Xs =RuM9 -END PGP SIGNATURE- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio 4.5.2 Memory Leak?
> CFSTUIDO 4.5.2 is not the most stable app in the world, and is > very easy to > crash (try closing a window with JS in the internal browser - and watch > those error messages!!!) I'm sorry, but "Well DUH!" - how are you meant to close a window that's built in to the system? > Also - since upgrading to IE 5.5, memory usage seems to have gone through > the roof... oten using over 50MB within a few hours of booting... We've had to dump IE5.5 from most of our machines as it's so hungry - combine that with WindowsMe and you've got a REAL winner... *** Standard Joke time *** The only way you could call Studio 4.5.2 stable is if you put a horse in it! Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio 4.5.2 Memory Leak?
I have fought this problem for some time now. I could not get CFS to be happy under windows 9x. But, windows 2000 seems to handle the CFS MUCH better. I found a solution that works very well for me: Windows 2000 196MB RAM CF Studio 4.5.2 It is very stable. And believe me I hammer CF studio and the entire system very very hard. I will very often have 14+ larger apps open at the same time (i.e. outlook, pcanywhere, word, excel, multi sessions of SQL mangers, Access, Query32, winamp and the list goes on.) Rock solid... I reboot once a week. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Richard Kuryk [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 11:46 AM To: CF-Talk Subject: RE: CF Studio 4.5.2 Memory Leak? If it crashes and eats through memory don't use it and certainly don't purchase it! There are many good programmer editors out there. UltraEdit, MultiEdit, and the list goes on and on, give your money to something that is stable and is not counterproductive. Most of these editors have demos or eval copies and can be customized to do whatever you like. I have even read that the new multiedit integrates into studio, not sure I would want that but hey maybe it makes studio more stable. Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Access '97 repair log?
Hi, Just fixed a DB in Access 97 using the Repair function - is it possible to see a log of what it fixed? Thanks Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
(Review) Conditional loops
I just did some more tests and I've got some more interesting results. The test was to compare conditional loops between the CFLOOP and the two conditional loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT statments were about twice as fast as the CFLOOP statment. This was my expected results. It looks like the only loop that is faster outside of CFSCRIPT is the for loop (from-to). For those who want to test my code and see my results, I've pasted it below. To do a real test, try a loop count of 1000, 1 or even higher. while (loopcount LTE 1000) loopcount=loopcount+1; do loopcount=loopcount+1; while (loopcount LTE 1000); CF-#cf# While - #wh# do-#do# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio 4.5.2 Memory Leak?
>-Original Message- >> CFSTUIDO 4.5.2 is not the most stable app in the world, and is >> very easy to >> crash (try closing a window with JS in the internal browser - and watch >> those error messages!!!) >I'm sorry, but "Well DUH!" - how are you meant to close a window that's >built in to the system? Of course I'd not expect it to work - but I would expect it to gracefully inform you, instead of crashing quite so dramatically - I laughed reading the error messages you get... I'd expect it to popup something like "You really are a thick T*** - do you really expect to be able to do that within studio" Just a little bit more basic exception handling would be nice.. >> Also - since upgrading to IE 5.5, memory usage seems to have gone through >> the roof... oten using over 50MB within a few hours of booting... >We've had to dump IE5.5 from most of our machines as it's so hungry - >combine that with WindowsMe and you've got a REAL winner... Arggg... I'm on NT4 with 128mb at work - and generally it takes about 1.5 days between reboots... I'm on 2000 at home with IE5 and 384Mb, and generally the only time I need to reboot is when I install / uninstall some old S/W - my system is often up for weeks at a time... I was going to upgrade to IE5.5 at home - but I think I might give it a miss now... I really dont like win9x (ME inc) at all... Had to install single user CF Server and PWS on a 98 laptop for a client yesterday - should have taken max 1/2 hour - but due to win98 crashing at 99.9% of the way through installing CF, in total I installed it 4 times (and removed it 3 times). Add to that, as soon as the machine tried to restart, it fatally locked up - and no task manager to kill the problem tasks - had to powerdown and restart (scandisk found an error on the disk at least once on reboot...) If I had my own way - all the machines would have 2k on them... although I might have a job on my laptop (cyrix 586 120 with 16Mb ram and a 750Mb HD!) >*** Standard Joke time *** >The only way you could call Studio 4.5.2 stable is if you put a horse in it! Not bad :) ~~ 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
OLE DB vs. ODBC
Hi, I've been told in the past that when using CF server and SQL Server to use OLE DB instead of ODBC when connecting to databases. I've never been told why? Is it faster? Another thing is they use ODBC where I work to connect to SQL Server databases and are asking me to create a test so that they can see the differences between the two. Which kind of tests would you create and is there going to be that much of a difference to show them? Thanks SalGet your FREE download of MSN Explorer at http://explorer.msn.com">http://explorer.msn.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
TID errorlist
Well, the post I sent to Allaire looking for the list of "TID" errors (and I was thinking, maybe the definitions/solutions) came and went without an answer. Any one here know if there is such an animal? What prompted me to ask was a TID=4100 error on a linux server. (not mine) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: (Review) Conditional loops
What do make of this then??? CFLOOP is (fairly substantially) quicker when you have 1,000,000 repetitions... 1,000,000 repetitions: CF-34781 While - 50079 do-50391 100,000 repetitions: === CF-3360 While - 1859 do-1813 10,000 repetitions: == CF-343 While - 172 do-188 1,000 repetitions: CF-46 While - 16 do-16 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 18:26 To: CF-Talk Subject: (Review) Conditional loops I just did some more tests and I've got some more interesting results. The test was to compare conditional loops between the CFLOOP and the two conditional loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT statments were about twice as fast as the CFLOOP statment. This was my expected results. It looks like the only loop that is faster outside of CFSCRIPT is the for loop (from-to). For those who want to test my code and see my results, I've pasted it below. To do a real test, try a loop count of 1000, 1 or even higher. while (loopcount LTE 1000) loopcount=loopcount+1; do loopcount=loopcount+1; while (loopcount LTE 1000); CF-#cf# While - #wh# do-#do# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: (Review) Conditional loops
My understanding was that loops inside a CFSCRIPT slowed considerably when the loop included the evaluation of a variable. Like this: loopcount=0; loopend=1000 <--- New start=GetTickCount(); do loopcount=loopcount+1; while (loopcount LTE loopend);<--- Changed do=gettickcount()-start >>> [EMAIL PROTECTED] 03/13/01 10:25AM >>> I just did some more tests and I've got some more interesting results. The test was to compare conditional loops between the CFLOOP and the two conditional loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT statments were about twice as fast as the CFLOOP statment. This was my expected results. It looks like the only loop that is faster outside of CFSCRIPT is the for loop (from-to). For those who want to test my code and see my results, I've pasted it below. To do a real test, try a loop count of 1000, 1 or even higher. while (loopcount LTE 1000) loopcount=loopcount+1; do loopcount=loopcount+1; while (loopcount LTE 1000); CF-#cf# While - #wh# do-#do# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: (Review) Conditional loops
Me thinks you are wrong... Did you remember to change the loop count in the CFLOOP to 1,000,000 as well? Your results are awfully close to those of the 100,000 group. 1,000,000 on my machine... PIII 600MHz 782MB RAM *** CF-44063 While - 28562 do-25297 These results are inline with all the others. Twice as fast in CFSCRIPT. *** Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 11:37 AM To: CF-Talk Subject: RE: (Review) Conditional loops What do make of this then??? CFLOOP is (fairly substantially) quicker when you have 1,000,000 repetitions... 1,000,000 repetitions: CF-34781 While - 50079 do-50391 100,000 repetitions: === CF-3360 While - 1859 do-1813 10,000 repetitions: == CF-343 While - 172 do-188 1,000 repetitions: CF-46 While - 16 do-16 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 18:26 To: CF-Talk Subject: (Review) Conditional loops I just did some more tests and I've got some more interesting results. The test was to compare conditional loops between the CFLOOP and the two conditional loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT statments were about twice as fast as the CFLOOP statment. This was my expected results. It looks like the only loop that is faster outside of CFSCRIPT is the for loop (from-to). For those who want to test my code and see my results, I've pasted it below. To do a real test, try a loop count of 1000, 1 or even higher. while (loopcount LTE 1000) loopcount=loopcount+1; do loopcount=loopcount+1; while (loopcount LTE 1000); CF-#cf# While - #wh# do-#do# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: (Review) Conditional loops
Yeah - I checked that... ran it again: CF-33671 While - 27625 do-18782 must have been some other factor... -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 18:49 To: CF-Talk Subject: RE: (Review) Conditional loops Me thinks you are wrong... Did you remember to change the loop count in the CFLOOP to 1,000,000 as well? Your results are awfully close to those of the 100,000 group. 1,000,000 on my machine... PIII 600MHz 782MB RAM *** CF-44063 While - 28562 do-25297 These results are inline with all the others. Twice as fast in CFSCRIPT. *** Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 11:37 AM To: CF-Talk Subject: RE: (Review) Conditional loops What do make of this then??? CFLOOP is (fairly substantially) quicker when you have 1,000,000 repetitions... 1,000,000 repetitions: CF-34781 While - 50079 do-50391 100,000 repetitions: === CF-3360 While - 1859 do-1813 10,000 repetitions: == CF-343 While - 172 do-188 1,000 repetitions: CF-46 While - 16 do-16 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 18:26 To: CF-Talk Subject: (Review) Conditional loops I just did some more tests and I've got some more interesting results. The test was to compare conditional loops between the CFLOOP and the two conditional loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT statments were about twice as fast as the CFLOOP statment. This was my expected results. It looks like the only loop that is faster outside of CFSCRIPT is the for loop (from-to). For those who want to test my code and see my results, I've pasted it below. To do a real test, try a loop count of 1000, 1 or even higher. while (loopcount LTE 1000) loopcount=loopcount+1; do loopcount=loopcount+1; while (loopcount LTE 1000); CF-#cf# While - #wh# do-#do# ~~ 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
Linking to URLs with Ampersands
Hello, For our Web site, I use a ColdFusion redirect page to display a legal disclaimer when linking to external sites. To have this redirect text appear in the template before the user leaves our site, I must use the following format for a link tag: http://www.leg.s tate.co.us/2001/inetcbill.nsf/fsbillcont/F0ACA8F6AE0D6AE7872569BC005A272F?Op en&file=001_rn2.pdf" TARGET="_blank"> Since ColdFusion uses the ampersand to define variables, I am running into trouble linking to Web sites that use ampersands in their URLs. Because of the two variables previously defined in this tag, any of the URL after (and including) an ampersand is deleted. So, the above URL would be truncated to: http://www.leg.state.co.us/2001/inetcbill.nsf/fsbillcont/F0ACA8F6AE0D6AE7872 569BC005A272F?Open Thus, rendering my link useless. I have tried using CFOUTPUT tags, using two ampersands, and using the HTML code for an ampersand to replace the ampersand in the URL. None of these options have worked. Since the redirect page isn't something I can just *not* use, I am wondering if any of you have found an alternative way to deal with this issue. Thanks in advance! Terra Durrant On-Line Specialist American Collectors Association (952) 928-8000, ext. 755 www.collector.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascript IsDefined
Actually typeof is an operator, not a function, so it is generally used the way Dave described. -Original Message- From: Patricia Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 11:51 AM To: CF-Talk Subject: RE: Javascript IsDefined The correct syntax is if (typeof(myvarname) == "undefined") { [do your stuff] } |-Original Message- |From: Hayes, David [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, March 13, 2001 10:32 AM |To: CF-Talk |Subject: RE: Javascript IsDefined | | |You can use the "typeof" operator. | |if (typeof myVarName == "undefined"){ | |} | ~~ 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: First crack at commerce, sort of.
I'd recommend taking a look at MSDE, which is essentially the engine behind SQL Server, just without the pretty front end, and it easily upgrades to full-blown SQL Server. You can use Access as the front end, but under the scenes, it's SQL Server. I say that because it may or may not be cost-justifiable to go to SQL Server for those (potentially) rare situations when the concurrency is too much for Access. That's true for MySQL also, since you'd need to buy a second box (if you use the recommended version, which is on Linux). However, I agree that your primary focus should be on how your code is written: on a properly optimized site, concurrency won't be much of a problem. I'll take a well written site using Access over a poorly written site with SQL Server any day of the week. Not to mention configuration headaches (You mean I was supposed to put a password on "sa"? doh) Whatever you do, don't fall prey to the typical IT argument of simply throwing more hardware/software at a problem, as opposed to analyzing all of the variables and finding the proper solution for your specific situation. -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Jay Patton wrote: > I would use SQL or MySQL for this NOT! Access > > Jay Patton > Web Design / Application Design > Web Pro USA > 406.549.3337 ext. 203 > 1.888.5WEBPRO > www.webpro-usa.com > - Original Message - > From: "Kortland, Brian" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, March 13, 2001 9:19 AM > Subject: First crack at commerce, sort of. > > > This message is in MIME format. Since your mail reader does not understand > > this format, some or all of this message may not be legible. > > > > --_=_NextPart_001_01C0ABD9.673F79C0 > > Content-Type: text/plain; > > charset="iso-8859-1" > > > > Hi All, > > > > I have a number of small clients who mostly have very basic Cold Fusion > > driven sites. I have a potential new client (a Deli) who has corporate > > customers that want to have access his menus and place orders online. He > > does not yet want full blown e-commerce with CC transactions but does want > > to allow about 1,000 users into the site to place orders on a daily basis. > > For my smaller sites I have used Access 2000 and have not had problems. > With > > this new client I have concerns regarding concurrent hits to the DB to > pull > > menu items and to capture and archive orders. Most things I have read > state > > that Access 97 is not to be used for even moderate traffic sites, but I > have > > seen claims by MicroSoft that Access 2000 is more robust. Is this just > hype? > > > > Should my menus, order info, and security all be kept in separate > databases? > > > > If anyone has any other advice based on my scenario I'd love to hear it. > > > > Brian Kortland > > Cyberplugs.com > > > > --_=_NextPart_001_01C0ABD9.673F79C0 > > Content-Type: text/html; > > charset="iso-8859-1" > > > > > > > > > > > > > > First crack at commerce, sort of. > > > > > > > > Hi All, > > > > > > I have a number of small clients who mostly have very > basic Cold Fusion > > driven sites. I have a potential new client (a Deli) who > has corporate > > customers that want to have access his menus and place > orders online. He > > does not yet want full blown e-commerce with CC > transactions but does want > > to allow about 1,000 users into the site to place orders > on a daily basis. > > For my smaller sites I have used Access 2000 and have not > had problems. With > > this new client I have concerns regarding concurrent hits > to the DB to pull > > menu items and to capture and archive orders. Most things > I have read state > > that Access 97 is not to be used for even moderate > traffic sites, but I have > > seen claims by MicroSoft that Access 2000 is more robust. > Is this just hype? > > > > > > Should my menus, order info, and security all be kept in > separate databases? > > > > > > If anyone has any other advice based on my scenario I'd > love to hear it. > > > > > > Brian Kortland > > Cyberplugs.com > > > > > > > > > > --_=_NextPart_001_01C0ABD9.673F79C0-- > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: one more Paradox question...
Try http://www.merant.com/ Joe Hoffman mailto:[EMAIL PROTECTED] National Institutes of Health Center for Information Technology Division of Computer System Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 12:31 PM To: CF-Talk Subject: one more Paradox question... Ok we are going to be connecting to a Paradox 4.5 systemyes i knowoldbut besides that, i know that the M$ ODBC driver will lock the tables and mess everything up... :oP so has anyone worked with this and found a better ODBC driver? TIA Kevin ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] <> ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascript IsDefined
Ah... I stand corrected. I'll have to give that way a shot. The person who informed me of it used that syntax and it's worked for me but now I know better. |-Original Message- |From: Caulfield, Michael [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, March 13, 2001 2:11 PM |To: CF-Talk |Subject: RE: Javascript IsDefined | | |Actually typeof is an operator, not a function, so it is |generally used the |way Dave described. | |-Original Message- |From: Patricia Lee [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, March 13, 2001 11:51 AM |To: CF-Talk |Subject: RE: Javascript IsDefined | | |The correct syntax is |if (typeof(myvarname) == "undefined") { | [do your stuff] |} | ||-Original Message- ||From: Hayes, David [mailto:[EMAIL PROTECTED]] ||Sent: Tuesday, March 13, 2001 10:32 AM ||To: CF-Talk ||Subject: RE: Javascript IsDefined || || ||You can use the "typeof" operator. || ||if (typeof myVarName == "undefined"){ || ||} || | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
What Version of LDAP server to use for Win 2000
Question for those of you using the LDAP server and CF. What version are you using for Win 2000? I looked at the Netscape site, and version 4.12 and 4.13 of iPlanet Directory Server (the successor to the LDAP server) is not supported for Win 2000; and version 5, which does support Win 2000, is still beta. I am looking to try it out and play with it and would like some insight for what version people are running on Win 2000. Thanks, Vance Duke ~~ 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: Linking to URLs with Ampersands
Just use urlencodedformat() around the URl. in your case: http://www.leg.s tate.co.us/2001/inetcbill.nsf/fsbillcont/F0ACA8F6AE0D6AE7872569BC005A272F?Op en&file=001_rn2.pdf)#" TARGET="_blank"> Another possibility, and the way I always use, is to hold all of the links in a database. In your situation, just pass the link ID, and look it up on the redirect page. I do this to keep track of how many times people click a link, as well as let people rate the links' importance. see virtualtrials.com/links.cfm for it in action! Al Musella, DPM A1webs.com At 01:06 PM 3/13/2001 -0600, you wrote: >Hello, > >For our Web site, I use a ColdFusion redirect page to display a legal >disclaimer when linking to external sites. To have this redirect text >appear in the template before the user leaves our site, I must use the >following format for a link tag: > >HREF="#Session.TemplatePath#&Template=Redirect.cfm&Location=http://www.leg.s >tate.co.us/2001/inetcbill.nsf/fsbillcont/F0ACA8F6AE0D6AE7872569BC005A272F?Op >en&file=001_rn2.pdf" TARGET="_blank"> > >Since ColdFusion uses the ampersand to define variables, I am running into >trouble linking to Web sites that use ampersands in their URLs. Because of >the two variables previously defined in this tag, any of the URL after (and >including) an ampersand is deleted. So, the above URL would be truncated >to: > >http://www.leg.state.co.us/2001/inetcbill.nsf/fsbillcont/F0ACA8F6AE0D6AE7872 >569BC005A272F?Open > >Thus, rendering my link useless. I have tried using CFOUTPUT tags, using >two ampersands, and using the HTML code for an ampersand to replace the >ampersand in the URL. None of these options have worked. Since the >redirect page isn't something I can just *not* use, I am wondering if any of >you have found an alternative way to deal with this issue. > >Thanks in advance! > >Terra Durrant >On-Line Specialist >American Collectors Association >(952) 928-8000, ext. 755 >www.collector.com > > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SNMP and CF
I dont believe there will be until version 5 comes out. The current beta does include the MIB scripts though. I am not 100% on this, but the current CF 4.5 Enterprise does include a cluster monitoring utitlity that might be able to be used to monitor CF server. I saw it once, and it had a lot of information about the servers on the screen. I think the best way for now would be to monitor the cfserver processs through Windows SNMP... jon - Original Message - From: "Lewis Steven" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 13, 2001 9:30 AM Subject: SNMP and CF > Is there a way to monitor CF using SNMP right now? > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: (Review) Conditional loops
I tried out your suggestion of using an evaluation vs. a variable rather than against a number and the results moved from CFSCRIPT being twice as fast to it only being about a third as fast. I only tested on 1,000 and 10,000. > > My understanding was that loops inside a CFSCRIPT slowed considerably when the > loop included the evaluation of a variable. > > Like this: > > > loopcount=0; > loopend=1000 <--- New > start=GetTickCount(); > > > do > loopcount=loopcount+1; > while (loopcount LTE loopend);<--- Changed > do=gettickcount()-start > > ~~ 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
Form Fields cleared on Back
Im going nuts trying to figure this one out, I have a form with about 110 fields (ya i know), there is lots of server side validation, if an input error occurs I CFABORT and give the user a JavaScript back button to go back an correct the input. On some users PC the form gets cleared on other PC's it does not. I also use some of the CF built in validation (_required) so the user has to use the browser back button, same thing happens on some of these peoples browsers. Of coarse it does not happen on mine. I setup a few test forms for the problems users and it things work ok. These users are all using IE 5.x, any one else have such problems, could it be the large number of INPUT fields? any browser settings? registry settings? Voodoo dances? anything? Thanks,Adrian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What Version of LDAP server to use for Win 2000
Isn't that thingy called Active Directory LDAP compliant? Not suggesting using it, just thinking outloud here. - Douglas Knudsen Leveraged Technologies Group 678-351-6063 Got Linux? http://linuxmall.com From: [EMAIL PROTECTED] AT INTERNET on 03/13/2001 02:34 PM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: What Version of LDAP server to use for Win 2000 Question for those of you using the LDAP server and CF. What version are you using for Win 2000? I looked at the Netscape site, and version 4.12 and 4.13 of iPlanet Directory Server (the successor to the LDAP server) is not supported for Win 2000; and version 5, which does support Win 2000, is still beta. I am looking to try it out and play with it and would like some insight for what version people are running on Win 2000. Thanks, Vance Duke ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Form Fields cleared on Back
I've found that this is something that happens on IE5. Netscape doesn't do this. The only way I've gotten around is to painstakingly include a bunch of 'hidden' form fields that way when the user presses the back button it repopulates the form. >From: "Adrian Cesana" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Form Fields cleared on Back >Date: Tue, 13 Mar 2001 11:46:49 -0800 > >Im going nuts trying to figure this one out, I have a form with about 110 >fields (ya i know), there is lots of server side validation, if an input >error occurs I CFABORT and give the user a JavaScript back button to go >back >an correct the input. On some users PC the form gets cleared on other PC's >it does not. I also use some of the CF built in validation (_required) so >the user has to use the browser back button, same thing happens on some of >these peoples browsers. Of coarse it does not happen on mine. I setup a >few test forms for the problems users and it things work ok. These users >are all using IE 5.x, any one else have such problems, could it be the >large >number of INPUT fields? any browser settings? registry settings? Voodoo >dances? anything? > >Thanks,Adrian > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: (Review) Conditional loops
1,000,000 on my machine... PIII 750MHz 512MB RAM === CF-64360 While - 34062 do-31563 -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 12:49 PM To: CF-Talk Subject: RE: (Review) Conditional loops Me thinks you are wrong... Did you remember to change the loop count in the CFLOOP to 1,000,000 as well? Your results are awfully close to those of the 100,000 group. 1,000,000 on my machine... PIII 600MHz 782MB RAM *** CF-44063 While - 28562 do-25297 These results are inline with all the others. Twice as fast in CFSCRIPT. *** Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 11:37 AM To: CF-Talk Subject: RE: (Review) Conditional loops What do make of this then??? CFLOOP is (fairly substantially) quicker when you have 1,000,000 repetitions... 1,000,000 repetitions: CF-34781 While - 50079 do-50391 100,000 repetitions: === CF-3360 While - 1859 do-1813 10,000 repetitions: == CF-343 While - 172 do-188 1,000 repetitions: CF-46 While - 16 do-16 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 18:26 To: CF-Talk Subject: (Review) Conditional loops I just did some more tests and I've got some more interesting results. The test was to compare conditional loops between the CFLOOP and the two conditional loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT statments were about twice as fast as the CFLOOP statment. This was my expected results. It looks like the only loop that is faster outside of CFSCRIPT is the for loop (from-to). For those who want to test my code and see my results, I've pasted it below. To do a real test, try a loop count of 1000, 1 or even higher. while (loopcount LTE 1000) loopcount=loopcount+1; do loopcount=loopcount+1; while (loopcount LTE 1000); CF-#cf# While - #wh# do-#do# ~~ 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
Another Note RE: CF Studio 4.5.2 Memory Leak?
Not to keep this going but I have observed one other problem. when you deploy a project and it scrolls through line by line the speed at which it deploys changes if you drag the results window away from the bottom of CF Studio An example I did was to minimize the window to one line of text and it took 10 sec then I almost maxed out the window and it to 1min and 1 sec Then I minimized it to where you could not see the text and it took 9 sec? What is up with this? Nathan > -Original Message- > From: Daniel Lancelot [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, March 13, 2001 12:25 PM > To: CF-Talk > Subject: RE: CF Studio 4.5.2 Memory Leak? > > >-Original Message- > >> CFSTUIDO 4.5.2 is not the most stable app in the world, and is > >> very easy to > >> crash (try closing a window with JS in the internal browser - and watch > >> those error messages!!!) > > >I'm sorry, but "Well DUH!" - how are you meant to close a window that's > >built in to the system? > > Of course I'd not expect it to work - but I would expect it to gracefully > inform you, instead of crashing quite so dramatically - I laughed reading > the error messages you get... > > I'd expect it to popup something like "You really are a thick T*** - do > you > really expect to be able to do that within studio" > > Just a little bit more basic exception handling would be nice.. > > >> Also - since upgrading to IE 5.5, memory usage seems to have gone > through > >> the roof... oten using over 50MB within a few hours of booting... > > >We've had to dump IE5.5 from most of our machines as it's so hungry - > >combine that with WindowsMe and you've got a REAL winner... > > Arggg... > I'm on NT4 with 128mb at work - and generally it takes about 1.5 days > between reboots... > I'm on 2000 at home with IE5 and 384Mb, and generally the only time I > need > to reboot is when I install / uninstall some old S/W - my system is often > up > for weeks at a time... > > I was going to upgrade to IE5.5 at home - but I think I might give it a > miss > now... > > I really dont like win9x (ME inc) at all... > Had to install single user CF Server and PWS on a 98 laptop for a client > yesterday - should have taken max 1/2 hour - but due to win98 crashing at > 99.9% of the way through installing CF, in total I installed it 4 times > (and > removed it 3 times). > Add to that, as soon as the machine tried to restart, it fatally locked up > - > and no task manager to kill the problem tasks - had to powerdown and > restart > (scandisk found an error on the disk at least once on reboot...) > > If I had my own way - all the machines would have 2k on them... although I > might have a job on my laptop (cyrix 586 120 with 16Mb ram and a 750Mb > HD!) > > >*** Standard Joke time *** > >The only way you could call Studio 4.5.2 stable is if you put a horse in > it! > > Not bad :) > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: (Review) Conditional loops
I forgot to mention that I'm running CF5.0. So that may have influenced the results. I'll have to try again on a 4.5.2 machine. Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 1:51 PM To: CF-Talk Subject: RE: (Review) Conditional loops 1,000,000 on my machine... PIII 750MHz 512MB RAM === CF-64360 While - 34062 do-31563 -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 12:49 PM To: CF-Talk Subject: RE: (Review) Conditional loops Me thinks you are wrong... Did you remember to change the loop count in the CFLOOP to 1,000,000 as well? Your results are awfully close to those of the 100,000 group. 1,000,000 on my machine... PIII 600MHz 782MB RAM *** CF-44063 While - 28562 do-25297 These results are inline with all the others. Twice as fast in CFSCRIPT. *** Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 11:37 AM To: CF-Talk Subject: RE: (Review) Conditional loops What do make of this then??? CFLOOP is (fairly substantially) quicker when you have 1,000,000 repetitions... 1,000,000 repetitions: CF-34781 While - 50079 do-50391 100,000 repetitions: === CF-3360 While - 1859 do-1813 10,000 repetitions: == CF-343 While - 172 do-188 1,000 repetitions: CF-46 While - 16 do-16 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 18:26 To: CF-Talk Subject: (Review) Conditional loops I just did some more tests and I've got some more interesting results. The test was to compare conditional loops between the CFLOOP and the two conditional loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT statments were about twice as fast as the CFLOOP statment. This was my expected results. It looks like the only loop that is faster outside of CFSCRIPT is the for loop (from-to). For those who want to test my code and see my results, I've pasted it below. To do a real test, try a loop count of 1000, 1 or even higher. while (loopcount LTE 1000) loopcount=loopcount+1; do loopcount=loopcount+1; while (loopcount LTE 1000); CF-#cf# While - #wh# do-#do# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Fields cleared on Back
it is DEFINITLEY the large number of input fields. i had a problem like that once, where i allowed the admin to enter different events for different artists as many times as they wanted. anything about 20 times made the page work wierd, so i limited to 10 times only. hehe -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 1:47 PM To: CF-Talk Subject: Form Fields cleared on Back Im going nuts trying to figure this one out, I have a form with about 110 fields (ya i know), there is lots of server side validation, if an input error occurs I CFABORT and give the user a JavaScript back button to go back an correct the input. On some users PC the form gets cleared on other PC's it does not. I also use some of the CF built in validation (_required) so the user has to use the browser back button, same thing happens on some of these peoples browsers. Of coarse it does not happen on mine. I setup a few test forms for the problems users and it things work ok. These users are all using IE 5.x, any one else have such problems, could it be the large number of INPUT fields? any browser settings? registry settings? Voodoo dances? anything? Thanks,Adrian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Fields cleared on Back
What type of inputs are they? I know that IE will clear password fields when you hit the browser back button. Jason Jason Aden Allaire Certified Developer [EMAIL PROTECTED] www.wwstudios.com > -Original Message- > From: Adrian Cesana [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 13, 2001 2:47 PM > To: CF-Talk > Subject: Form Fields cleared on Back > > > Im going nuts trying to figure this one out, I have a form with about 110 > fields (ya i know), there is lots of server side validation, if an input > error occurs I CFABORT and give the user a JavaScript back button > to go back > an correct the input. On some users PC the form gets cleared on > other PC's > it does not. I also use some of the CF built in validation (_required) so > the user has to use the browser back button, same thing happens on some of > these peoples browsers. Of coarse it does not happen on mine. I setup a > few test forms for the problems users and it things work ok. These users > are all using IE 5.x, any one else have such problems, could it > be the large > number of INPUT fields? any browser settings? registry settings? Voodoo > dances? anything? > > Thanks,Adrian > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Fields cleared on Back
The way I do it is to first create a structure with all of the form field preloads (if editing a record) or all blank values (if a new record). I use this struct to populate the form fields. Then, if there's an error detected upon submittal, I load the form data into the struct (so it'll keep their new entries), and save the struct in a session variable. I also save any error messages in a session variable. That way, when I reload the form, I just check to see if the session variables are defined, and if they are, display the error messages and grab the struct from the session variable to re-populate the form fields. (I also make sure to clear the session variable once the validation passes, so they don't get any incorrect error messages if they go back to the form.) Eric -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 11:51 AM To: CF-Talk Subject: Re: Form Fields cleared on Back I've found that this is something that happens on IE5. Netscape doesn't do this. The only way I've gotten around is to painstakingly include a bunch of 'hidden' form fields that way when the user presses the back button it repopulates the form. >From: "Adrian Cesana" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Form Fields cleared on Back >Date: Tue, 13 Mar 2001 11:46:49 -0800 > >Im going nuts trying to figure this one out, I have a form with about 110 >fields (ya i know), there is lots of server side validation, if an input >error occurs I CFABORT and give the user a JavaScript back button to go >back >an correct the input. On some users PC the form gets cleared on other PC's >it does not. I also use some of the CF built in validation (_required) so >the user has to use the browser back button, same thing happens on some of >these peoples browsers. Of coarse it does not happen on mine. I setup a >few test forms for the problems users and it things work ok. These users >are all using IE 5.x, any one else have such problems, could it be the >large >number of INPUT fields? any browser settings? registry settings? Voodoo >dances? anything? > >Thanks,Adrian > > > > ~~ 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
Broken Images / Testing for file existence
I have an application where I list several items on a page and display an image for that item based on a reference number (ie, productnum+.jpg). The database table does not tell me whether there is an image for that item and there are many that do have one. I'd like to display an alternate image (or nothing at all) when there is no image present, but I can't see using an for every item for 50 or so on a page. Plus, I can't even do that because I'm grabbing the images from a different server via http only (http://otherserver/path/number.jpg>)... How can I avoid displaying broken images? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.linktoss.com ___The Fastest Way to Send a Link to Anyone! http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.cfug-sfl.org ___South Florida Cold Fusion Users Group http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Fields cleared on Back
I've come up with a very handy solution to this... IF you use fusebox try this (I call it stacking): the ACT_DELETEBUGS.CFM template only runs if the form fields from DSP_BUGLIST.CFM are defined (if the form has been submitted). Inside the action fuse is where the form validation occurrs. At the end of this fuse I check to see if an error occurred - relocate to the next step if no errors, otherwise drop right on through where the form will appear again populated with it's own values. In DSP_BUGLIST.CFM you'll need to put an if statement to default the form values for the first time through. Works like a charm! Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 11:47 AM To: CF-Talk Subject: Form Fields cleared on Back Im going nuts trying to figure this one out, I have a form with about 110 fields (ya i know), there is lots of server side validation, if an input error occurs I CFABORT and give the user a JavaScript back button to go back an correct the input. On some users PC the form gets cleared on other PC's it does not. I also use some of the CF built in validation (_required) so the user has to use the browser back button, same thing happens on some of these peoples browsers. Of coarse it does not happen on mine. I setup a few test forms for the problems users and it things work ok. These users are all using IE 5.x, any one else have such problems, could it be the large number of INPUT fields? any browser settings? registry settings? Voodoo dances? anything? Thanks,Adrian ~~ 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