Re: Radio Button
yuphere goes.. cfparam name=radMyRadioButton default=Value From Database input type=radio name=radMyRadioButton value=1 cfif radMyRadioButton eq 1checked/cfif input type=radio name=radMyRadioButton value=2 cfif radMyRadioButton eq 2checked/cfif Ta Da! ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Steven Lancaster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 8:28 AM Subject: Radio Button Is there any way to take a value out of a database and see if it matches a value on a radio button and if it does to check that radio button? I have 3 radio buttons. I need to look at the values and see if they match whichever one matches I need to have that radio button checked. I know this probably and idiotic question (sorry). Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 713-328-2532 (Office) 713-328-2150 (Fax) 832-259-3010 (Cell) mailto:[EMAIL PROTECTED] http://www.corelab.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Radio Button
Hey Steven, If the form will be posted and do some sort of server-side error checking (and re-shown with errors if any are found) then my method (back a few posts) is the one to go with. This is because my method initializes the var for the radio button which then passes it's new or unchanged value into the error checking process (when form is posted). If errors are found the form can be re-displayed with the users input and a list of errors. By using the looping/iif/de method the radio buttons will always revert to the value in the database as opposed to the value selected by the user after the initial display of the form. my 2 cents ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Steven Lancaster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 9:02 AM Subject: RE: Radio Button I looked it up (sorry). I tried to use the iif but I can't get it to work. I will send a snippet and you can see what I am trying to do. cfloop query=check input type=radio name=status value=Not Assigned Yet #IIf(status is Not Assigned Yet, de(checked) ,de ())# font face=Arial, Helvetica, sans-serif color=#FFbNot Assigned Yet/b/font/td /tr tr td input type=radio name=status value=Work in Progress #IIf(status is Work in Progress, de(checked) ,de ())# bfont face=Arial, Helvetica, sans-serifWork In Progress/font/b/td /tr tr td input type=radio name=status value=Completed or Closed #IIf(status is Completed or Closed, de(checked) ,de ())# font face=Arial, Helvetica, sans-serif color=#009900bCompleted / Closed/b/font/td /tr /cfloop Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 713-328-2532 (Office) 713-328-2150 (Fax) 832-259-3010 (Cell) mailto:[EMAIL PROTECTED] http://www.corelab.com -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 11:03 AM To: CF-Talk Subject: RE: Radio Button Delayed Evaluation.. It's a function. Lee -Original Message- From: Steven Lancaster [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 8:50 AM To: CF-Talk Subject: RE: Radio Button what does iif and de stand for? I understand what it is doing, I just don't understand the syntax. Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 713-328-2532 (Office) 713-328-2150 (Fax) 832-259-3010 (Cell) mailto:[EMAIL PROTECTED] http://www.corelab.com -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 10:48 AM To: CF-Talk Subject: RE: Radio Button Is there any way to take a value out of a database and see if it matches a value on a radio button and if it does to check that radio button? I have 3 radio buttons. I need to look at the values and see if they match whichever one matches I need to have that radio button checked. I know this probably and idiotic question (sorry). CFIF or IIF() cfloop query=myQuery input type=radio name=myName value=1 #iif(myField is 1,de(checked),de())# 1br /cfloop You get the idea 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. ** ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: TextArea wrapping
check the wrap attribute...some may have it and other may not (thus defaulting to virtual I think) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 2:04 PM Subject: TextArea wrapping I need to figure out why some textareas are limited in my table to the width of 100% while others just go way over. Is there something I could be missing. The contents of the text area are sentences not solid strings so you would think it could wrap? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fax into database
There are ways of doing this, but the OCR software would have to be damn good. The fax is turned into a TIFF image (special multi page fax TIFF) which can then be OCR'd...parsed...and inserted into the DB. The downside of course is that the OCR may not work right which could cause your parsing script to failblah blah blah If you are only grabbing a small nugget of info off the faxed page, you could have some unique identifying characters around the text you want to parse outthat would help with finding it (no garuntees as to the final OCR'd text) HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Tracy Bost [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 14, 2001 9:47 AM Subject: Fax into database I may be trying to reach too far here, but I'm wondering if anyone has attempted to parse a fax to a pc insert into database as to eliminate all the data entry, or if even i its possible. If anyone has any ideas,suggestions, please let me know. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Query Problem
I'd add in some AND WHATEVER BrandIF Field IS NOT NULL to weed out the NULL records Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Brian Ferrigno [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 2:39 PM Subject: SQL Query Problem I am having a problem trying to think of the correct SQL statement I need. It's late in the day and my brain is completely fried. What I am tring to do is get the average price of one column based a an ID that is passed to the SQL query. For example if a BrandID of 1 is passed into the query it should output an average price of $4.00 The problem arises when one of the BrandID(BNID) columns doesn't contain any of the #ID# numbers in it. The value that it returns is NULL which causes the rest of the SQL statement to return NULL as a result even if the other columns contain at least one #ID# in the BNID column. For example passing a BrandID of 24 will return a resultset of NULL because it is not in the second or third BRANDID column. Hopefully I made some sense. Below is the partial table design and SQL statements I am using in my script. Any help would be great. TABLE DESIGN BNID1_3 Price1_3 BNID2_3 Price2_3 BNID3_3 Price3_3 1 $2.0010 $0.001 $5.00 24 $0.001 $5.0023 $0.00 SQL STATEMENT select (select avg(Price1_3) from temp1 where BNID1_3=#ID#)+ (select avg(Price2_3) from temp1 where BNID2_3=#ID#)+ (select avg(Price3_3) from temp1 where BNID3_3=#ID#) AS AVGPRICE ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Converting an Access 97 db to an Access 200 db?
should be just fine as long as you have the latest version of MDAC installed Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Christian Abad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 10:57 AM Subject: Converting an Access 97 db to an Access 200 db? Folks: For one of our ColdFusion apps, we are contemplating upgrading one of our Access 97 databases to an Access 2000 database. Has anyone had any experience doing this? Thoughts, comments and suggestions are welcome! Thanks, Christian N. Abad ColdFusion Web Developer Bank of America - eCommerce Technology ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Converting an Access 97 db to an Access 200 db?
Microsoft Data Access Components (latest will be installed if you have latest version of IE or at least 5.5) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Christian Abad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 11:13 AM Subject: RE: Converting an Access 97 db to an Access 200 db? MDAC? -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 2:04 PM To: CF-Talk Subject: Re: Converting an Access 97 db to an Access 200 db? should be just fine as long as you have the latest version of MDAC installed Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Christian Abad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 16, 2001 10:57 AM Subject: Converting an Access 97 db to an Access 200 db? Folks: For one of our ColdFusion apps, we are contemplating upgrading one of our Access 97 databases to an Access 2000 database. Has anyone had any experience doing this? Thoughts, comments and suggestions are welcome! Thanks, Christian N. Abad ColdFusion Web Developer Bank of America - eCommerce Technology ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fusebox - opinions?
Hey all, Lets see I started doing Fusebox before there was a Fusebox and quickly dropped it. It seemed to produce an extremely messy control document (I guess it's always index.cfm nowadays?). About a year or 2 after it really started to spread throughout the CF community I joined a few Fusebox lists and lurked for a bit. I was shocked to find all the wasted effort writing custom tags and workarounds just to use the method!! I say if you write an application in a logical fashion and comment everything, then any other developer can work on it just as easily as you can. The bonus is you can write it faster than in Fusebox. my 2 cents...flame away ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Douglas L. Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, November 17, 2001 10:22 AM Subject: Re: Fusebox - opinions? Here is a few opinions... Pros 1. FB is great on large scale apps, this allows several developers to have production on a single site and allows for specialty type of production. IE: the DBA can work on queries, while the CF programmer works on the front end of things etc. 2. Code reuse..With the FB methodology, queries can be more like stored procedures, where the front end and backend remain somewhat seperate from eachother. This allows for the front end to be modified without a hitch. Cons 1. Not the greatest thing for smaller applications, unless you are an unorganized person. You can probably code faster without it if you are making a small app. 2. Jumping back and forth between all the folders that is used to keep track of your application. IE: _dsp, _act, _scripts, _css, _qry, _images etc etc. If you are doing the site by yourself, this can become tiresome. First you have to look at your index.cfm to see what query you were using on a particular page and then go to the _qry folder to find the file All said, I think the pros out weight the cons and would suggest it to pretty much anyone who is developing large apps and has a team of developers working on a site. The book(fusebox methodologies and techniques) is a so so reader, some things are over emphasised and not really to the meat of the matter. It is a good way to learn the basics, and it did help me to understand what FB could do for me. The downloadable e-book is well woth the $$, but would not suggest paying for the actual book. DB - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, November 17, 2001 8:28 AM Subject: Re: Fusebox - opinions? 1.Fusebox is a coding methodology. It's like picking a certain writing style. It trys to maximize code reuse by structuring the way you write your code. It also lends itself to self documentation. I've seen most of the presentations on www.fusebox.org and understand what Fusebox is (otherwise I really wouldn't be considering learning it!!) - I was more after opinions about using it from people who have some depth of experience with it - pros and cons type of thing. 2.there is a great book on fusebox called 'Fusebox: mothodology and techniques' by steve nelson and craig girard. I know this book is around - I had just read so-so to bad reviews on Amazon.com. You say it's great - why? Any other opinions? Thanks for any feedback, - Gyrus ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fusebox - opinions?
Go Zac! Canada! Canada! Canada! ;-) Hey Zac remember ServisNet :-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Zac Belado [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 19, 2001 12:06 PM Subject: RE: Fusebox - opinions? If you are looking to try and instill good disciplines and readability in your code Fusebox is also good for that. This presumes that the developers know fusebox. You could also get this same benefit from documenting your methods and making sure your developers follow a single standard. Fusebox doesn't bring anything to development (in these terms) that any other documented methodology would. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fusebox - opinions?
Oh ya..and BTW...I agree with ZacFusebox may have some good concepts, but it just doesn't work in all cases and can certainly cause unwanted complexity my 2 cents Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 19, 2001 12:12 PM Subject: Re: Fusebox - opinions? Go Zac! Canada! Canada! Canada! ;-) Hey Zac remember ServisNet :-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Zac Belado [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 19, 2001 12:06 PM Subject: RE: Fusebox - opinions? If you are looking to try and instill good disciplines and readability in your code Fusebox is also good for that. This presumes that the developers know fusebox. You could also get this same benefit from documenting your methods and making sure your developers follow a single standard. Fusebox doesn't bring anything to development (in these terms) that any other documented methodology would. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fusebox - opinions?
Here Here! Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 19, 2001 3:32 PM Subject: RE: Fusebox - opinions? Yes, but any developer worth his salt should be able to pick up a *documented* methodology and work within it given an hour or so to look over the documentation. I was on a project, where the first thing they did was have me sit down with the lead developer. He dictated everything from the directory structure of the project to the casing (I.E. upper / lower case of the letters ) to use for SQL statements. I took notes, and there was never a problem. In addition to a methodology, properly documented code should be easily picked up. At 03:05 PM 11/19/2001 -0500, you wrote: The problem with making your own methodology up is that only the people you have taight it to will know it, the benefit of fusebox and any other popular methodology is that there are support forums, sample applications, and white papers that you can work off of. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 3:06 PM To: CF-Talk Subject: RE: Fusebox - opinions? If you are looking to try and instill good disciplines and readability in your code Fusebox is also good for that. This presumes that the developers know fusebox. You could also get this same benefit from documenting your methods and making sure your developers follow a single standard. Fusebox doesn't bring anything to development (in these terms) that any other documented methodology would. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Passing Form Variable forward
Number 5 needs more input? (like some sample code..plz) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Angel Stewart [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 19, 2001 4:02 PM Subject: Passing Form Variable forward Under what circumstances would a form variable NOT be passed forward from one form to the next upon Form Submit? I have a form that contains SEVERAL dynamically generated fields, that need to all be passed forward. However for some reason certain fields just aren't being detected by the ACTION form. If I pass these fields on the URL line, it works. But why should I have to do this? -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: VTM Files
Ummm...are you talking CF Studio? It already has a colour picker built in ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Steve Reich [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 5:26 PM Subject: VTM Files Does anyone know of any online resources for writing .vtm files? Specifically, I'm looking for a way to have a color picker popup for the user to select a color. Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: VTM Files
ah...gotcha Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Steve Reich [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 6:00 PM Subject: Re: VTM Files Ummm...are you talking CF Studio? It already has a colour picker built in I realize that, but when the user selects 'Edit Tag' and pulls up the tageditor dialog, I want them to fill one of the fields with a color value. How can I access the color picker from within the VTM? Thanks, Steve ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Suppressing white space
Are you using style sheets? If so and you are using the line-height' attribute then that will cause some scary white space in Netscape HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Douglas L. Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 8:09 PM Subject: Suppressing white space I have a page that when rendered in netscape, has about 1000 lines of whitespace. what is the best way to suppress it? I have enabled suppress whitespace in CF Admin, but no help. CF_SIGNATURE NAME=Douglas L. Brown EMAIL=[EMAIL PROTECTED] PHONE=714.538.6611 WEB=http://www.carnivorepc.com; ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: innerHTML
Well for starters innerHTML only works in IE :-( Is price a CF variable or a JavaScript variable? If it's CF then you need the good old #price# in there. You can also ditch the = (price); and make it = #price#; HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Douglas L. Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 10:43 AM Subject: OT: innerHTML I have a script that calculates price and I need it to set the innerHTML of a tag, I thought I could just say show_price_top.innerHTML = (price); but that dont work, It works if I just say show_price_top.innerHTML = (price); but it just puts the string value of price in the field Here is the field. span class=showPriceB NAME=show_price_top ID=show_price_top/B/span Can someone help? CF_SIGNATURE NAME=Douglas L. Brown EMAIL=[EMAIL PROTECTED] PHONE=714.538.6611 WEB=http://www.carnivorepc.com; ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: innerHTML
ditch the around price Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Douglas L. Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 10:55 AM Subject: Re: innerHTML Well it is a JS variable, how would this be accomplished? DB - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 10:45 AM Subject: Re: innerHTML Well for starters innerHTML only works in IE :-( Is price a CF variable or a JavaScript variable? If it's CF then you need the good old #price# in there. You can also ditch the = (price); and make it = #price#; HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Douglas L. Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 10:43 AM Subject: OT: innerHTML I have a script that calculates price and I need it to set the innerHTML of a tag, I thought I could just say show_price_top.innerHTML = (price); but that dont work, It works if I just say show_price_top.innerHTML = (price); but it just puts the string value of price in the field Here is the field. span class=showPriceB NAME=show_price_top ID=show_price_top/B/span Can someone help? CF_SIGNATURE NAME=Douglas L. Brown EMAIL=[EMAIL PROTECTED] PHONE=714.538.6611 WEB=http://www.carnivorepc.com; ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: innerHTML
or remove the 2 sets of at the +'s Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Douglas L. Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 11:05 AM Subject: Re: innerHTML Thnks for the help. I finally got it, I had to do show_price_top.innerHTML = ( + total + ); DB - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 10:53 AM Subject: Re: innerHTML ditch the around price Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Douglas L. Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 10:55 AM Subject: Re: innerHTML Well it is a JS variable, how would this be accomplished? DB - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 10:45 AM Subject: Re: innerHTML Well for starters innerHTML only works in IE :-( Is price a CF variable or a JavaScript variable? If it's CF then you need the good old #price# in there. You can also ditch the = (price); and make it = #price#; HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Douglas L. Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 10:43 AM Subject: OT: innerHTML I have a script that calculates price and I need it to set the innerHTML of a tag, I thought I could just say show_price_top.innerHTML = (price); but that dont work, It works if I just say show_price_top.innerHTML = (price); but it just puts the string value of price in the field Here is the field. span class=showPriceB NAME=show_price_top ID=show_price_top/B/span Can someone help? CF_SIGNATURE NAME=Douglas L. Brown EMAIL=[EMAIL PROTECTED] PHONE=714.538.6611 WEB=http://www.carnivorepc.com; ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Stylesheets output formatting
I'd use the semi colon as a delimiter in a list and insert an ASCII carriage return after each semi colon my 2 cents Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Benjamin Falloon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 9:33 PM Subject: CF Stylesheets output formatting Hi all, I'm making a dynamic style sheet control panel to allow the administrator of my site make changes to the style definitions of my site. My question is this: Besides using just using cfsetting enablecfoutputonly=Yes to output just the styles, is there a way to have the output (ie. the linked stylesheet) page have formatting without using HTML elements like breaktags? I want to avoid having any HTML in the actual style sheet which is called styles.cfm, but I want to have a certain degree of formating for my own reference. At the moment, the output looks like this: Body { color : 00; font-family : Arial,Helvetica,Geneva,Swiss,SunSans-Regular; font-size : 12px; font-weight : Normal; font-style : Normal; text-decoration : None; } But I would prefer it to look like this: Body { color : 00; font-family : Arial,Helvetica,Geneva,Swiss,SunSans-Regular; font-size : 12px; font-weight : Normal; font-style : Normal; text decoration : None; } Does anyone know of a tag/method of making the cartridge returns in the actual script show up in the output without resorting to p or br tags? Thanks in advance, Benjamin Falloon ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: hosting recommendations
Well they have been up over a yeartheir support is stellar...their prices are dirt cheap especially if you're in the US because they are here in Canada. www.wedohosting.com talk to Lyle MacGregor or Dave Davies (tell 'em Electric Edge sent ya...then ya get really good service) HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: lsellers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 26, 2001 1:05 PM Subject: hosting recommendations 'ello. Was looking around for a new host for intrafoundation.com. (My current host's new management software is really ticking me off.) 2gb traffic a month avg. 8 email accounts. cf asp required. 1 or more odbc. relatively low stress website. cc gateway soft and cfx/com allowance usage required (though I'm not using any cfx's or com's on it at the moment). Some place reliable (2+ years up) but laid back. Cheap's good too. ;-) Thanks, --min ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMODULE and odd display behavior
in this particular tag it's the :caller scope. That said it does the same thing with ALL cfmodule calls that display something (i.e. a link). Yes I've checked for duplicate tags...the answer is no. Single use of tag outside of a cfloop = dual display Multiple use of tag inside a cfloop = fine and dandy Single use inside a cfloop = fine and dandy except I have to use the loop = ggghhh Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Won Lee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 26, 2001 4:02 PM Subject: RE: CFMODULE and odd display behavior waht scopoe do you set the formated string in? do you have output twice? Seeing the code would really help. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 7:02 PM To: CF-Talk Subject: CFMODULE and odd display behavior Hey Folks, OK I found this bug/glitch quite a while agoposted it to some lists...never really got a decent resolution. So here we go again beacuse it's driving me up the wall ;-) I got tired of relying on hosting tech support to put custom tags in place, so I use CFMODULE instead. The Problem: I have many tags that do many things, but we'll go with a simple example. A tag to take a phone number and format it based on length...not rocket science. Now when I call the tag (using cfmodule) to format a phone number (input string...process...display) I will get the phone number displaying twice (once in the table where it should be and again at the bottom of the page). Now if I loop over a bunch of records and use the tag for each record all is well. So my solution up till now when displaying a single record is to wrap the cfmodule call in a cfloop from 1 to 1 which makes the extra output vanish. Well I'm starting to find other odd display things that cfmodule seems to be doing...so it's time to nail this puppy once and for all. Any thoughts? experiences? comments? TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMODULE and odd display behavior
I could post the code, but I'd have to post about 10 tags worth plus where I'm using it. Basically I've narrowed it down to an issue with CFMODULE because when I call the tags the good old fashioned way (from custom tags dir in cf server) then all is well. Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Tangorre, Michael T. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 26, 2001 3:57 PM Subject: RE: CFMODULE and odd display behavior Could you post the code? -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 7:02 PM To: CF-Talk Subject: CFMODULE and odd display behavior Hey Folks, OK I found this bug/glitch quite a while agoposted it to some lists...never really got a decent resolution. So here we go again beacuse it's driving me up the wall ;-) I got tired of relying on hosting tech support to put custom tags in place, so I use CFMODULE instead. The Problem: I have many tags that do many things, but we'll go with a simple example. A tag to take a phone number and format it based on length...not rocket science. Now when I call the tag (using cfmodule) to format a phone number (input string...process...display) I will get the phone number displaying twice (once in the table where it should be and again at the bottom of the page). Now if I loop over a bunch of records and use the tag for each record all is well. So my solution up till now when displaying a single record is to wrap the cfmodule call in a cfloop from 1 to 1 which makes the extra output vanish. Well I'm starting to find other odd display things that cfmodule seems to be doing...so it's time to nail this puppy once and for all. Any thoughts? experiences? comments? TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMODULE and odd display behavior
Ahhh Dave I think you may have something thereDOH! I was using the second method without testing for start and end. I'll change it up and see how she flys ;-) Thanks Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 26, 2001 4:32 PM Subject: RE: CFMODULE and odd display behavior Basically I've narrowed it down to an issue with CFMODULE because when I call the tags the good old fashioned way (from custom tags dir in cf server) then all is well. Are you doing something like this: cfmodule template=foo.com .../cfmodule or this: cfmodule template=foo.com ... / If so, that calls the custom tag twice. Within the custom tag itself, you can detect whether it's being called by the opening or the closing tag by looking to see whether the variable ThisTag.ExecutionMode is start or end. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMODULE and odd display behavior
Thanks again to Dave Watts at Fig Leaf...that did the tricknow the find and replace begins ;-) cf_red_face value=I'm a shmuck for not seeing that ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 26, 2001 4:32 PM Subject: RE: CFMODULE and odd display behavior Basically I've narrowed it down to an issue with CFMODULE because when I call the tags the good old fashioned way (from custom tags dir in cf server) then all is well. Are you doing something like this: cfmodule template=foo.com .../cfmodule or this: cfmodule template=foo.com ... / If so, that calls the custom tag twice. Within the custom tag itself, you can detect whether it's being called by the opening or the closing tag by looking to see whether the variable ThisTag.ExecutionMode is start or end. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: SQL Server upgrade (7-2000)
Hey All, Sorry for the OT, but has anybody had any glitches upgrading from SQL Server 7 to SQL Server 2000 (database side not CF)? Specifically loss of data or anything nasty when just installing over top SQL Server 7? TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Why aren't there more CF programmers out there?
FrontPage huh.somebody needs a smack upside the head ;-) Well I don't have a count for ya, but if a company like eBay will launch a site called Half.com using CF that should be good enough for anybody. Oh and you can tell this genius that CF wins most comparison tests against PHP and ASP etc. because it is the most portable and scalable. I'll stop now and let the likely stream of outrage to follow ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Justin Hansen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 2:40 PM Subject: Why aren't there more CF programmers out there? A higher up said If ColdFusion was so easy to learn why aren't there more CF programmers out there? So what do I tell him? How many CF Developers are there? How many sites use CF? Is there a Macromedia rep in the house? He thinks FrontPage is the way to go Let the games begin! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Easier way to have a drop down selected
What? Huh? One more time in English please ;-) Admin side? What's that? Are you talking about having a select box select the country that was selected (and then inserted by ID into the DB) by a user after the fact (i.e. display the record that was inserted)?? Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Robert Everland [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 9:43 AM Subject: Easier way to have a drop down selected Ok I have this drop down box that lists every country out there, the problem is after someone has selected it, I want the admin side to show which one has been selected, while also showing the rest of them. I have done this but doing a huch cfcase statement that goes from 1 - whatever and if it is a vertain one selected it sets a number, then the select box has a cfif in there to see if that number has been turned on. Does anyone have a simple solution, or is my solution the only way there is. Robert Everland III Dixon Ticonderoga ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Windows NT error #1450 occurred.
Go to Googleclick on groups...type in exact error messageta da! I find SoooOOO many resolutions to errors etc. there HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 7:10 AM Subject: RE: Windows NT error #1450 occurred. The only reference to that error I found was here. http://www.allaire.com/Handlers/index.cfm?ID=1659Method=Full -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 10:04 AM To: CF-Talk Subject: Windows NT error #1450 occurred. Windows NT error #1450 occurred. Anybody no what causes this error? TIA Don ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Server upgrade (7-2000)
Excellentthanks Bill Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Bill Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 9:57 AM Subject: RE: SQL Server upgrade (7-2000) We have had problems doing our upgrade. After the software is installed SQL runs some scripts that upgrade the various tables. Ours would fail with the message Error executing script upgrade.sql (1). After talking to MicroSoft support the only solution is to uninstall SQL7 and then install SQL2000 as a clean install. What we did that finally worked was: 1. Stop SQL7 2. Copy all database and log files into another directory. 3. Uninstalled SQL7 4. Installed SQL2000 5. Copied all of the database and log files into the new data and log directories (ours were on different drives). 6. Recreated all users from the old system keeping passwords etc. 7. Attached each database into the server. The only issue we had was we had 2 purchased programs that had special security settings and stored procedures in the master database. We had to manually recreate this information. One thing that helped was each of the programs had a utility that once we gave the admin user rights to master would recreate all of the security settings needed for each user. But all of our internal programs worked like a dream without any special work. Bill Grover Supervisor, IS EU Services, Inc. 649 N Horners Ln Rockville MD 20850 Phone: 301-424-3300 x396 FAX:301-424-3300 x1396# E-Mail: [EMAIL PROTECTED] -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 6:39 PM To: CF-Talk Subject: OT: SQL Server upgrade (7-2000) Hey All, Sorry for the OT, but has anybody had any glitches upgrading from SQL Server 7 to SQL Server 2000 (database side not CF)? Specifically loss of data or anything nasty when just installing over top SQL Server 7? TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT- Hosting recommendations
take a look at WeDoHosting.com -great support -just about finished their web based admin stuff (domain and e-mail control etc.) -CF and SQL Server 2000 Oh ya and Canadian pricesas low as $9.95/month (about $6 US) HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 6:47 PM Subject: OT- Hosting recommendations I'm looking to move my smaller clients to a new hosting company, because of support issues and restrictions on what I can and can't do where I am now. There are about 20 domains involved, and I'm thinking of using Sitebysize.com in Texas. Has anyone had any experience with them? What I need are: CF, SQLServer, ability to control my domains, mail accounts, etc myself from the web, low cost (which rules out any Australian hosting companies), and a responsive support department (my biggest complaint about my current host). Cheers, Mike Kear AFP Webworks, Windsor, NSW, Australia. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: sql icon
print screen and paste into PhotoShop ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Joshua Tipton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 12:01 PM Subject: sql icon In enterprise manager beside each database there is a cylinder icon. Does anyone know where I can get this icon? Josh ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfif shorthand
I'm working on some code that uses a shorthand (I guess...) cfif style quite a bit. I have tried to stay away from doing this since it makes the code harder to read, so I never really took the time to figure it out. For instance... cfif query.recordCount Is this testing for the existence of the query or if it is greater than zero? for zero recordcount not existence cfif len(query.date) This particular one has me scratching my head, it never seems to test negative in the code, but what is it testing for? testing that the date has a length (i.e. if there is a date then it will test true and proceed...boolean test...true/false...length or not) Could someone please fill me in here... jon ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WAP and CFM
Well I just started delving into WAP about 30 minutes ago and I'd say that ya you probably can. CF seems to integrate quite nicely...so you could fire up cfpop and cfmail and away you go (yes overly simplified...but hey anything is possible) ;-) I've already done basic stuff like running queries and displaying resultsworking on form processing now Good luck and keep me informed cause I want to do the same thing and more! Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Mookie Bear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 30, 2001 10:06 AM Subject: WAP and CFM hey guys, please tell me if this is possible. I want to create a WAP application where my friends, who have internet-capable cell phones, are able to do such things, as, check email! The reason I wanna do this is so that they dont have to pay for email service. Or is the email service already included as part of their internet service? Then I would have no problem ditching this project hehe. I was just thinking of some WAP service i can make that the cell phone company offers, but for free! ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ArraySort rarararar!!
Sweet! Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 30, 2001 11:01 AM Subject: RE: ArraySort rarararar!! Dude, where's my car? -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 2:01 PM To: CF-Talk Subject: RE: ArraySort rarararar!! Dude, the 3rd parameter is not required :-) -Original Message- From: Mookie Bear [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 1:57 PM To: CF-Talk Subject: Re: ArraySort rarararar!! hey dude, the arraysort function takes 3 arguments. you only provided the first 2. the last argument is the sort order. possible values are asc and desc. BAHEHEHE!! rarararar!! From: Adkins, Randy [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: ArraySort Date: Fri, 30 Nov 2001 13:45:12 -0500 This is something that I serious MUST be overlooking. Eyes are bloodshot right now from coding. I have a 2 dimential array such as follows: myArray[1][1] = 'JOHN' myArray[1][2] = 'DOE' myArray[1][3] = '[EMAIL PROTECTED]' mailto:'[EMAIL PROTECTED]' myArray[1][4] = 'TEXAS' myArray[1][5] = 'USA' myArray[2][1] = 'BARRY' myArray[2][2] = 'JOHNSON' myArray[2][3] = '[EMAIL PROTECTED]' mailto:'[EMAIL PROTECTED]' myArray[2][4] = 'CALIFORNIA' myArray[2][5] = 'USA' I need to SORT the array before outputting the data. Sounds simple right??? It should come out: BARRY JOHNSON JOHN DOE When using the command: cfset sortit = ArraySort(myarray,textnocase) Question #1: When using the ArraySort, it should evaluate all the dimensions with in the array for sorting, correct? OR does it only sort on ONE dimension? Question #2: When using the command above, why do I get the following error: Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: sortit = ArraySort(myarray,textnocase) Error near line 245, column 8. The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you may be trying to use a query variable in a CFIF tag. This was possible under Cold Fusion 2.0 but is an error under later versions. Randy Adkins Tech Lead - Novient SRA International [EMAIL PROTECTED] (703) 803-1677 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WAP and CFM
nope...nothin to do...as long as you make it a .cfm file and use cfcontent to use the right MIME typ for WAP (CFCONTENT TYPE=text/vnd.wap.wml) HTH BTW I can now process forms etc. this is SO cool ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: ehoma [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 30, 2001 11:15 AM Subject: Re: WAP and CFM Do I need a special server to serve-up WAP or will my current web server do the job? Currently using O'reilly Web Site Pro on an NT 4.0 box. I see that Cold Fusion already supports WAP, so I don't think I need to re-configure CF. Eric Homa - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 30, 2001 10:18 AM Subject: Re: WAP and CFM Well I just started delving into WAP about 30 minutes ago and I'd say that ya you probably can. CF seems to integrate quite nicely...so you could fire up cfpop and cfmail and away you go (yes overly simplified...but hey anything is possible) ;-) I've already done basic stuff like running queries and displaying resultsworking on form processing now Good luck and keep me informed cause I want to do the same thing and more! Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: Mookie Bear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 30, 2001 10:06 AM Subject: WAP and CFM hey guys, please tell me if this is possible. I want to create a WAP application where my friends, who have internet-capable cell phones, are able to do such things, as, check email! The reason I wanna do this is so that they dont have to pay for email service. Or is the email service already included as part of their internet service? Then I would have no problem ditching this project hehe. I was just thinking of some WAP service i can make that the cell phone company offers, but for free! ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Arrgghhh! cfpop trouble=True
That error usually means CF Server needs a restart. Not that that solves your problem, but it may have just been a hiccup (or your code has issues). HTH ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: what is going on??
Do you mean you just can't see the CF code in view source (which you shouldn't be able to) or the actual CF code is being removed from the file itself? Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
Hey All, cf_rant I just had an mazingly frustrating experiences with one of the blackhole database maintainers (ordb.org). These folks think they are doing favours by helping ISP's to block mail server IPs that are running open relays (allow spammers to send using that mail server), but their implementation SUCKS! The Scenario: I'm running a development box with IMS as a mail server (and hosting a client's domain during development). After about 8 months with no mail issues whatsoever I receive a bunch of spam test messages from ORDB.org and then get a message saying that my mai lever was an open relay and had been added to their database. This database is provided to ISPs so they can block ALL mail coming from the IP addresses in it. SOOOOO ORDB thinks it's best to just add my IP with NO warning and no chance to fix the issue before getting blacklisted. Well that bit of strong arming shut down my mail server and my client couldn't send any mail (BTW my logs show that no spam EVER went through the system). You then have to try and fix the problem (not easy in IMS) and submit your IP for re-testing (which they say takes 5-10 hours...reality was 12 plus hrs). If you haven't closed the relay then you have to try again (which I had to do). My client was without e-mail for over 2 days. I had to get rid of IMS and found a GREAT free mail servr that allows SMTP authentication (Argo Soft...get it). My communications with ORDB were less than fruitful. They didn't care that my mail service was interrupted and said they don't give you a warning because then more spam would get through (which there was none). So these guys would rather innocent people lose their mail service instead of allowing a few more spams through...geesh. To top it off they hide behind the well it;s the ISPs that block you..we just provide them with the database of IPs. Which transaltes to He didn't have to use the gun I handed him!! Well their predecesor ORBS had 2 legal injunctions against them and had to shut down. I'm sure if they continue to stop valid mail service that someone with the time and money will go after them too...awww what a shame *insert eveil grin here* /cf_rant Thanks for listening...and get ArgoSoft's mail serversuper easy to use and install Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
Go Paris! I think we see eye-to-eye ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
Ahh yes...blacklisting is fine BUT They should give you a few days grace to fix the issue before they do it. A little more spam won't hurt anyone and the grace period means that the valid users of the mail server don't have their service interuppted as a result of the blacklisting without notification. Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
yup..but they are gone apparently..the lawyer got 'em Now can I hear a big w what a shame ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
To go back to your gun analogy, we are restricted in possession and use of guns in order to reduce the likelihood of homicides. Otherwise, I should be able to carry a locked and loaded gun anywhere I choose. open relay MX's lying around will be picked up by spammers and used as weapons. Running an open relay is inexcusable. Len And shutting people down with no warning is also inexusable Bryan http://MenAndMice.com/DNS-training http://BIND8NT.MEIway.com : ISC BIND 8.2.4 for NT4 W2K http://IMGate.MEIway.com : Build free, hi-perf, anti-abuse mail gateways ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
Geesh...glad I don't work for you ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
It's the fact that the legit folks get nailed as well. Listen..we all agree that spam is evil...we all agree that mail servers should not be open.BUT is it so bad to give the folks running the server a chance to fix it first?? My issue is that once found to be open it is incredibly difficult to get off the blacklist. This means that legit folks can be without mail for a long time. Even if ORDB continues to aid in stopping legit mail, they could at least invest in some decent hardware and bandwidth. I mean 5-10 hours to test a mail server is so ridiculous it's not funny. If they are going to keep it up then the test should be avble to be performed in a matter of minutes and not hours. They suckI'm right...so na na na na naaa ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
You're comparing what an organization like ORDB does to a virusgee I guess your are coming around to my view ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
Well Len thanks for calling me lazy and incompetent. Until I got blacklisted I did not know about open relays. So how does that put me in either category? The mail server I was running had no documentation about the possible abuse of or even the existence of open relays. I'm the first to admit that my face was red when I found out that the situation existed and I dropped everything else I was doing and fixed it immeadiately. I can guarantee you that had I received a warning, it would certainly would have energized me to deal with the situation. Please watch those blanket statements in the future...because I am far from lazy or incompetent...you weenie ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
Yup..I'll take the hit...I should have done more research. The fact still remains that groups like ORDB are going too far in their approach to SPAM Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: exchange rates
Hey All, Just wondering if anyone knows of some good places to nab daily exchange rates from (say with CFHTTTP to grab and then stuff in a db)?? TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
You got it Paris..nobody's perfecteven us lazy incompetent folks need help sometimes ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
h..voluntarily breaking the law you meanthe predecessor to ORDB was ORBS (from Aussie Land) and they got shut down after having two successful legal injunction brought against them. Anyhoo...I'm sure we've beaten this subject to death and nothing is going to change until someone with deep pocktes and some time on there hands sues these guys just like the last ones. Lets put this puppy to rest nowwe're all right in our own little worlds ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
Ditto Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SPAM lists?
Exactly my point Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Disconnecting Data Sources for Upload?
This is a bit of a bubblegum solution, but you can have your client run a lock killing query just prior to upload. Just setup a quesry that they can navigate to in their browser (I call it qLockKiller.cfm). The SQL should be something like SELECT something FROM nothing. That will cause a db error and unlock Access (remove the .ldb file). Sometimes the query needs to be run afew times. I'd suggest doing this at non-peak times as somebody could hit the db again in the time it takes to fire up the FTP and send up the db. All that said...clients should not mess with uploading databases over top live ones...transaction will inevitably happen between the download and upload and thus data will be lost. Best solution is to set CF admin to only allow SELECT statements durring this process so no data can be altered. Of course this requires access to CF admin which is not always easy if hosted in a shared environment. HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Allaire Alliance Partner www.allaire.com - Original Message - From: John McKown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 12:36 PM Subject: Disconnecting Data Sources for Upload? Customer has Access database that he uploads to CF Server via FTP. Access database is a datasource for his site. When site is being viewed, he cannot upload a newer copy of the database because the file is locked. Any creative solutions besides disconnect the datasource? John McKown, President Delaware.Net, Inc. 28 Old Rudnick Lane Dover, DE 19901 e-mail: [EMAIL PROTECTED] phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 cell: 302-363-0071 icq: 1812513 ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Web Based Training Applications
try www.serebra.com I'm not sure if they have (available to the outside world) exactly what you're looking for, but I know they use CF and they do a tonne of e-education. Talk to Tony Brandnerhe should be able to answer your questions HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Dave Clay [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 21, 2002 9:25 AM Subject: Web Based Training Applications I am looking for an application or company that has developed a professional/enterprise level web based training application in CF. Any suggestions. Your help is appreciated. Dave Clay Trusjoist.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: List of Cities
I'd love to take a look at those UDFs. Do they work with any lat/long values? I'm asking because I have a DB with US zips and Canadian postal codes all with lat/long values (to about 5 decimals I think). The distance calculation that I found is a pig to put it midly, so hopefully the UDFs can help me out ;-) TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Tom Nunamaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 11:08 AM Subject: RE: List of Cities The US Census agency has a free listing of lat/lon for zip codes at http://ftp.census.gov/geo/www/gazetteer/places.html I wrote a bunch of UDF's for latlon calculations and posted them at cflib.org about two weeks ago. I see they are still sitting in the submission queue. Why does it take two weeks to get to it guys? If anyone needs the UDF's sooner, I can dig them out of the code I'm using at www.morervs.com. Look at http://www.morervs.com/fb3/index.cfm?fuseaction=search.home and try the distance search. I think that's the kind of thing you're after. I haven't seen how others do this but my solution was based on the fact that one degree of latitude is always equal to 60 nautical miles. You take the distance for the radius of the search and convert it to nautical miles. Then add that many degrees in a box around the starting point. If my search was 138 statute miles (about 120 Nautical miles), the 120 nautical miles is 2 degrees of arc at the earth's surface (Assuming the earth is a perfect sphere). Do an SQL query to filter out the vast majority of records that fall outside of the box surrounding your origin... Something like Select * From myzipcodedata Where lat between (targetlat-dist/(60*1.15)) and (targetlat+dist/(60*1.15)) AND lon between (targetlon-dist/(60*1.15)) and (targetlon+dist/(60*1.15)) This leaves you with a rectangle that's CLOSE to a radius search. All that's left to do is to loop through these records and actually calculate the distance and throw out the ones that exceed your search distance. One degree of longitude is only equal to 60 NM at the equator. The farther North you go, the smaller the distance gets until you get to the poles where it's zero. Your initial box to filter records out is actually somewhat larger than your search distance but it will never be smaller than your search distance. If someone has a better way, I'd love to see it but this method works fairly quickly. Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:29 PM To: CF-Talk Subject: RE: List of Cities Hi, There are zipcode lists with LAT and LONG coordinates for each zipcode. http://www.zipinfo.com/products/products.htm You can calculate your route's slope, distance and direction using the codes, and then look up intersection paths in the DB. Hope that helps. I've done this before, and it is actually pretty exciting when it starts working ;) - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 9:57 AM To: CF-Talk Subject: List of Cities I am faced with a rather interesting challenge. I will be working on an application that will help a company increase efficiency in shipping goods around the company. The company has its own fleet of shipping vehicles but occasional will use independents for small loads. What I need to figure out is if independent x from zip code z1 is driving to zip code z2 what cities/towns does the route pass through or close to (within 2 miles). TIA, Duane __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: access query?
Yes I'd check that format. '#start_time#''#start_ampm#' For starters you would want something more like '#start_time# #start_ampm#' (note the 1 set of single quotes). That said it may still not be correct. I'd look into using the CreatODBCDateFormat().it will solve your problems providing you are passing it valid date/time data. Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Phillip Broussard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 25, 2002 1:46 PM Subject: RE: access query? I would take a look at this '#start_time#''#start_ampm#', It doesn't look like a correct date/time fromat to me but I could be wrong. Phillip -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 1:04 PM To: CF-Talk Subject: access query? I have not messes with access before, and I am getting the following error. ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. Here is my query CFQUERY DATASOURCE=iec NAME=insert_classes INSERT INTO classes ( class_title, (text) class_location, (text) start_date, (date/time) cost, (currency) start_time, (date/time) end_time, (date/time) is_current ) (text) VALUES ( '#title#', '#location#', #date#, #cost#, '#start_time#''#start_ampm#', '#end_time#''#end_ampm#', '#is_current#' ) /CFQUERY Success is a journey, not a destination!! Doug Brown __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IP Address Locator
It is incredibly easy to reverse a charge. If you call a cc company and tell them that the charge trying to be reveresed is something you say you didn't buy, they will reverse the charge with almost no questions (not speaking from experience...but from info from bankers). The deal is that cc companies don't care and don't want to deal with the huge battle that could come from getting entangled between the merchant and the customer. That's why cc transactions online can be frauded SO easily. HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 25, 2002 6:19 PM Subject: Re: IP Address Locator How can you reverse a credit card transaction once it's been processed already? I've had credit card merchant account and have never seen this happen before. Thanks, Nathaniel Indonesia is notorious for credit card fraud. I have some friends in the musical instrument business and from bitter experience, they either have a rule Don't Do Business In Indonesia or Get The Greenbacks Before Dealing With Indonesian Customers. What happens is an apparently legit credit card transaction comes through, the money is deposited in the account, the instrument is put on an aircraft, then the credit card transaction is reversed and the guy has lost his expensive instrument (can be US$8000 or more) AND the money. I pass this on as a warning to everyone else. Make sure you have a procedure to intercept any automatic orders, so you don't send anything off to Indonesia without having the money in the bag and locked away where they can't get it. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks Nathaniel Horwitz mailto:[EMAIL PROTECTED] AIM: NRHorwitz Fax: 510-573-2298 Web Site: http://www.nathanielhorwitz.com What separates winning from losing is the head. The brain sometimes doesn't believe in the power of the body __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF 5 help docs for Studio 4.5.x??
Hey All, Once upon a time in a galaxy far far away I heard about being able to download the help docs for CF 5 for use in Studio 4.5.x.anybody know where? perhaps the Jedi Master ;-) TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF 5 help docs for Studio 4.5.x??
Well the link was there and it worked great...thanks guys ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 8:20 AM Subject: RE: CF 5 help docs for Studio 4.5.x?? Query - Dave, did you find a link to this from the site, or did you have it bookmarked. I think we may have lost the 'link' to it from the web site. I typed Studio Tag Update into the Search field. You're right, though; I couldn't find an actual link to it, even searching via Google. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERYPARAM dbname attribute
Hey All, The CF docs seem to be lacking an explanation of the dbname attribute for CFQUERYPARAM. Now the obvious is that it is for naming the database (wow I amaze myself sometimes). That said, doesn't the datasource take care of this? is there a benefit to using the attribute? is it just a typo in the docs? why is the sky blue? ;-) TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Studio 5 help docs for Studio 4.5.2?
Hey All, Once upon a time in a galaxy far far away I heard about being able to download the help docs for CF 5 for use in Studio 4.5.x.anybody know where? perhaps the Jedi Master ;-) TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Studio 5 help docs for Studio 4.5.2?
Please ignore this post...I posted it yesterday...I have the answer now...geesh time to rag on my ISP...that took WAY too long ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 25, 2002 2:02 PM Subject: Studio 5 help docs for Studio 4.5.2? Hey All, Once upon a time in a galaxy far far away I heard about being able to download the help docs for CF 5 for use in Studio 4.5.x.anybody know where? perhaps the Jedi Master ;-) TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Can CFRegistry read another computer's info?
Little OT, but I keep seeing reference to the Resource Toolkit. I have found info on it, but can't get any definite methods of getting my grubby little hands on it. Any thoughts? links? TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Locked
This can also mean that the database is corrupted. Try opening the DB and compacting and repairing it. Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 8:56 AM Subject: Locked Been getting this error on a certain site. Normally it is due to have the table in design mode. But this isn't the case this time. Can anyone shed some light as to why else this happens? Thanks! ODBC Error Code = S1000 (General error)PP [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'machine'.PPpThe error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (432:1) to (432:46)./pPP __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Inserting a delimited list into a database
and don't forget the semicolon after the SQL statement to seperate the SQL for each iteration of the loop ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 2:11 PM Subject: Re: RE: Inserting a delimited list into a database In addition, if you want to reduce your database calls, you can alway s do: cfquery datasource=Software Updates name=serverUpdate CFLOOP INDEX=ServerID LIST=#servers# DELIMITER= , INSERT INTO [update] (log_id, server) VALUES (#logQuery.id#,#ServerID#) /CFLOOP /cfquery That way, you're only doing one db call, that has multiple statemen ts within it. Also, you should wrap the dynamic variables in the insert statement with cfqueryparam tags. - Original Message - From: Matthew Walker [EMAIL PROTECTED] Date: Wednesday, February 27, 2002 3:07 pm Subject: RE: Inserting a delimited list into a database Hey ho! The problem is having a table called Update! Try wrapping [] around update. -Original Message- From: Jake Munson [mailto:[EMAIL PROTECTED]] Sent: Thursday, 28 February 2002 10:47 am To: CF-Talk Subject: Inserting a delimited list into a database I have a form that returns a comma delimited list of numbers from some checkboxes that each have the same name. I want to be able to insert a new record in a database for each checkbox that was checked in my form. I figured that if I used a list loop based on my checkbox list, that I could have a SQL query insert a record for each value in the list. But it keeps giving me an error on the insert query. Is it not possible to put a cfquery into a loop? Is there a better way to do this? Below is my code. Below that is the error I get. CFLOOP INDEX=ServerID LIST=#servers# DELIM ITER=, cfquery datasource=Software Updates name=serverUp date INSERT INTO update (log_id, server) VALUES (#logQuery.id#,#ServerID#) /cfquery /CFLOOP [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position... I thought that maybe the problem was that I didn't have a cfoutput around the #ServerID#, but that wasn't the probl em either. Thanks for the help. -Jake __ _ ___ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! ___ _ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb ar=lists __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Inserting a delimited list into a database
ahhh yes..but reusable code..portability ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Visual Equation Building
Hey All, OK I'll do my bets to explain what I'm trying to accomplish: I want to build a tool that allows the user to visually build an equation. The building blocks for the equation are essentially fields in a database. I'd like to display these building blocks in a list and give the user the ability to pass them into a workspace on the page that will hold the equation. Ideally I'd like to allow the user to drag and drop the building blocks into the workspace, but I suppose passing them via a link and some JavaScript would suffice. I also need to give the user a way of passing operators (+,-,*,/,[,]) to the workspace to help build the equation. Another hook is that I need to ultimately store the IDs of the records of the building blocks when I store the finished equation. I have some ideas, but I thought before I head down those paths, I'd see if anyone else had any input. Thanks in advance for any comments/help/hysterical laughter ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Visual Equation Building
Yup...that's along the lines of what I'm after (and I've thought of something along those lines), but I'm not sure if it will be user friendly enough. Any other thoughts folks? mabye CF and Flash? Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 28, 2002 10:27 AM Subject: RE: Visual Equation Building OTTOMH, What about two select boxes, one containing a list of fields, and one containing operators. Use the onChange event to fire off some Javascript to concatenate each building block to the current equation. Then have the javascript put the updated equation to a textarea or something like that. Behind the scenes you can track the IDs in a variable and put it in a database when the user is done (maybe a button to click). Does that sound like what you are looking for? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 1:26 PM To: CF-Talk Subject: Visual Equation Building Hey All, OK I'll do my bets to explain what I'm trying to accomplish: I want to build a tool that allows the user to visually build an equation. The building blocks for the equation are essentially fields in a database. I'd like to display these building blocks in a list and give the user the ability to pass them into a workspace on the page that will hold the equation. Ideally I'd like to allow the user to drag and drop the building blocks into the workspace, but I suppose passing them via a link and some JavaScript would suffice. I also need to give the user a way of passing operators (+,-,*,/,[,]) to the workspace to help build the equation. Another hook is that I need to ultimately store the IDs of the records of the building blocks when I store the finished equation. I have some ideas, but I thought before I head down those paths, I'd see if anyone else had any input. Thanks in advance for any comments/help/hysterical laughter ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Flash Connector Kit issues
Hi All, I'm trying to get the Flash Connector Kit examples to run and I'm having some problems. I've changed the path from localhost to the domain I'm hosting in the Flash ActionScripts of the examples and that works fine. I can browse to the greeting exampletype in my name...hit try itand then I get. A script in this movie is causing Flash Player to run slowly. If it continues to run, your computer may become unresponsive. Do you want to abort the script? Anybody else run across this one? TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Flash Connector Kit issues
I'm just trying to get the examples that come with the connector kit working. Please tell me that Macromedia didn't ship broken examples. I'm brand spankin new to this, so if you have something a tad more detailed to look for in the ActionScript I'd be very grateful. From what I've found so far a lot of people have had this same issue, but none of the forums have shown how to deal with it. HELP!!! ;-) TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Scott Van Vliet [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 01, 2002 12:38 PM Subject: RE: Flash Connector Kit issues This usually happens when you have an infinite loop in the Flash Player. Check you ActionScript to verify that you are not hanging up while trying to connect to the server. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 10:06 AM To: CF-Talk Subject: Flash Connector Kit issues Hi All, I'm trying to get the Flash Connector Kit examples to run and I'm having some problems. I've changed the path from localhost to the domain I'm hosting in the Flash ActionScripts of the examples and that works fine. I can browse to the greeting exampletype in my name...hit try itand then I get. A script in this movie is causing Flash Player to run slowly. If it continues to run, your computer may become unresponsive. Do you want to abort the script? Anybody else run across this one? TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: a little about the future
I've been dangling CF/Flash teasers in fornt of some local companies and they are flipping out about the potential. So I guess we as developers could throw our opinions at this latest announcement until our fingers are red and raw or we could be happy that the folks that pay us to build applications like the idea ;-) Cheers Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Declan Maher [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 04, 2002 8:57 AM Subject: RE: a little about the future http://www.microsoft.com/net/ -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: 04 March 2002 16:57 To: CF-Talk Subject: RE: a little about the future This .NET stuff you speak of, tell me more. At 11:51 AM 3/4/2002 -0500, you wrote: Tech related to CF and which tells a bit more about Neo (publicly). Fits with this list a bit more. Macromedia ColdFusion MX, which can be used in conjunction with Microsoft .NET, Java application servers, and web services, will provide developers with the fastest and easiest way to create rich applications with Macromedia Flash MX. In addition, developers will be able to use a new server gateway technology to build Macromedia Flash applications that work directly with leading application servers and web services. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: IIS 5 FTP Security Issue
Hi All, Sorry for the OT post, but my head is getting sore from banging it against my wall ;-) I'm trying to restrict FTP access in IIS to 1 IP address. Seems easy right ;-) Well the whole dang directory security tab is grayed out (disabled) in IIS which makes it quite difficult to add an IP. Thanks very very very much for any help anyone can give BTW it's Win 2K Professional Cheers Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS 5 FTP Security Issue
Thanks all for the tips. Yup it looks like Professional doesn't play nice with IP restrictions. Geesh so much software out there will say This feature only available with the XYZ version. But of course asking M$ to add something as user friendly as that would be out of the question ;-) OK I'm done...and BTW I grabbed the ArgoSoft FTP Server (www.argosoft.com) which took about 1 minute to install and configure...now that's easy. I use their mail server and it made closing my open relay just as simple...FREE FREE FREE ;-) Cheers Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Joel Blanchette [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 04, 2002 12:39 PM Subject: RE: IIS 5 FTP Security Issue I don't think u can set directory security in Professional..Only server. == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 2:18 PM To: CF-Talk Subject: OT: IIS 5 FTP Security Issue Hi All, Sorry for the OT post, but my head is getting sore from banging it against my wall ;-) I'm trying to restrict FTP access in IIS to 1 IP address. Seems easy right ;-) Well the whole dang directory security tab is grayed out (disabled) in IIS which makes it quite difficult to add an IP. Thanks very very very much for any help anyone can give BTW it's Win 2K Professional Cheers Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS 5 FTP Security Issue
Thanks for the heads up. So far ArgoSoft has been great...but that was the mail server ;-) Cheers Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 04, 2002 12:52 PM Subject: RE: IIS 5 FTP Security Issue Careful... Have tried playing with some of the freebies and they're typically wonderful on the admin side, but buggy/full-o-holes on the user/security side. Haven't had any direct experience with Argosoft's software. But have tried many others, and have always ended up back with Serv-U. It just works... Period. Have NEVER had a crash with it, and the author is on his list all the time, and VERY responsive. Frankly, not sure why anyone would bother with anything else. Just my .02. Lee | -Original Message- | From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] | Sent: Monday, March 04, 2002 12:55 PM | To: CF-Talk | Subject: Re: IIS 5 FTP Security Issue | | | Thanks all for the tips. Yup it looks like Professional | doesn't play nice with IP restrictions. Geesh so much | software out there will say This feature only available with | the XYZ version. But of course asking M$ to add something | as user friendly as that would be out of the question ;-) | | OK I'm done...and BTW I grabbed the ArgoSoft FTP Server | (www.argosoft.com) which took about 1 minute to install and | configure...now that's easy. I use their mail server and it | made closing my open relay just as simple...FREE FREE FREE ;-) | | Cheers | | Bryan Stevenson | VP Director of E-Commerce Development | Electric Edge Systems Group Inc. | p. 250.920.8830 | e. [EMAIL PROTECTED] | - | Macromedia Associate Partner | www.macromedia.com | - | Vancouver Island ColdFusion Users Group | Founder Director | www.cfug-vancouverisland.com | | - Original Message - | From: Joel Blanchette [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Monday, March 04, 2002 12:39 PM | Subject: RE: IIS 5 FTP Security Issue | | | I don't think u can set directory security in Professional..Only | server. | | | | == | Joel Blanchette | IT and System Specialist | Point of Impact Technologies Inc. | Tel: (204) 989-0013 | Email: [EMAIL PROTECTED] == | | | -Original Message- | From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] | Sent: Monday, March 04, 2002 2:18 PM | To: CF-Talk | Subject: OT: IIS 5 FTP Security Issue | | | Hi All, | | Sorry for the OT post, but my head is getting sore from banging it | against my wall ;-) | | I'm trying to restrict FTP access in IIS to 1 IP address. | Seems easy | right ;-) | | Well the whole dang directory security tab is grayed out | (disabled) in | IIS which makes it quite difficult to add an IP. | | Thanks very very very much for any help anyone can give | | BTW it's Win 2K Professional | | Cheers | | Bryan Stevenson | VP Director of E-Commerce Development | Electric Edge Systems Group Inc. | p. 250.920.8830 | e. [EMAIL PROTECTED] | - | Macromedia Associate Partner | www.macromedia.com | - | Vancouver Island ColdFusion Users Group | Founder Director | www.cfug-vancouverisland.com | | | __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: suggestion on complicated form design.
How about simply allowing them to add name/age/sex combos 1 at a time until they are done (like adding items to an invoice). If you don't want to hit the server for each combo addition, you can you can add each combo to JavaScript arrays and display using DHTML (commit the whole whack at once when they are done adding). HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Jeff Fongemie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 7:49 AM Subject: suggestion on complicated form design. Hello cf-talk, I'm about to build a fairly complicated form. It will require a getting a list of names, and the age and sex of each person. I will need to enforce the age and sex requirement of each name listed. Option 1. Build a form with lots many fields for name, age and sex. Once submitted, check for a value in the name field, then check for a value in the age and sex field. If there is a value in a name field, and no age or sex fields, give them the form back to fix. This sounds like a ton of work. Will need up to 12 names on the form. Option2. Ask how many names they will give, then provide a dynamic form with exactly the number of fields they need. Enforce everything. Anyother suggestions? This sounds like a real nightmare. Any tips or suggestions before I dive into this would be most appreciated! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Wednesday, March 06, 2002, at 10:43:55 AM __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Spiders and Cold Fusion
Yup they are correct (although some engines are making headway in that area). Go to Forta.com and find Ben's article on making your site search engine accessible. Actually this same topic flew through the list yesterday...so check the archives. HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Chad Gray [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 1:56 PM Subject: Spiders and Cold Fusion One of out clients has hired an Internet Marketing company to help get them more hits. I just got a call from one of their reps, and they were trying to tell me Cold Fusion will not work with search engine spiders because the pages are fused together. I was ready to laugh in her face. Does anyone know of problems with CF and Search Engine spiders? She wants us to generate an alternative site that is static. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Debugging issues
Are the appropriate IP addresses listed in CF Admin still the IPs of the computers trying to view the pages (i.e. could they have been re-assigned)? Just trying to clarify ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Morgan, Thomas J. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 08, 2002 4:55 AM Subject: Debugging issues Out of nowhere, debugging information at the bottom of our CF pages has stopped showing up on two separate servers. I checked the settings in CF Admin. and the appropriate IP addresses are listed in the box. I have stopped and re-started the services, but no luck. Has anyone seen this happen before? Thanks for any help. Thomas J. Morgan Research Triangle Institute 3040 Cornwallis Road RTP, NC 27709 (919)541-7414 [EMAIL PROTECTED] Http:\\www.rti.org __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFLOOP and CFOUTPUT
This one came through the list abouyt a month ago, so you may want to check the archives. The basic result was that CFLOOP is the way to go. Personally I wrap my entire page in CFOUTPUT tags and always use CFLOOP to output queries etc. IMHO it makes the code easier to read becaue I don't have to open and close CFOUTPUT tags everytime I want to output a query or variable. The potential downside to my method is that CF has to parse all the code inside my wrapping CFOUTPUTs. This issue was also discussed and I beleive the consensus was that the additional parsing time was minimal and acceptable (providing you don't have thousands of lines of code). HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Park, Simon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 08, 2002 7:13 AM Subject: CFLOOP and CFOUTPUT I know that the prevailing wisdom is that CFOUTPUT with the Query attribute is faster than CFLOOPing over a query. However, in Forta's CF 5 Certification Study Guide, he states that CFLOOP performs better (p. 37 and 374). Has CF 5 improved the performance of CFLOOP (Steve Drcuker referred to it as the CF tag of death in CF 3) so that it performs better than CFOUTPUT with a query attribute? =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Simon Park Computer Systems Management, Inc. Ph: 703-823-4300 x119 205 South Whiting Street #201 fax: 703-823-4301 Alexandria, VA 22304 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL in a CFIF
Yes it can be done SELECT * FROM MyTable WHERE cfif MyVar eq ThisValue SomeField = This cfelse SomeField = ThisOtherValue /cfif ORDER BY SomeField HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 1:29 PM Subject: SQL in a CFIF How would write a select statement within a CFIF statement. 1. Can it be done? 2. What is the Syntax? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL in a CFIF
Looks like you need an IN clause SELECT * FROM MyTable WHERE cfif MyVar has 1 item MyField = #MyVar# cfelseif MyVar has more than 1 item MyField IN (#MyVar#) /cfif Does that do it for ya? Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 1:53 PM Subject: RE: SQL in a CFIF Let me give an understanding of what I am doing. I have a variable that is passing one or up to three numbers. The numbers are passed like this: 1, 2, 3 or 1 or 1,2. My problem is I need to check to see if the the number is listed in the #variable#. so That I can go from there. My application works as long as my variable is only passing one number. If it passes 2 numbers my query doesn't like it. I have a query based on the variable 2 being in there. Any help would be appreciated. I am going crazy trying to figure it out. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Brendan Avery [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:43 PM To: CF-Talk Subject: RE: SQL in a CFIF you can not have your cfif conditional execute on the database-side; but you can put cfif and other cftags inside a cfquery tag-pair. for example if you had a page that had to display some item from your database, you could use a cfif to decide whether to pull an item by id or if no id is specified, pull the default item: cfquery name=iteminfo datasource=mydsn SELECT TOP 1 * FROM tbl_Merchandise WHERE cfparam name=currentitem default= cfif currentitem IS NOT id=#currentitem# cfelse default='y' /cfif /cfquery but it is important to note that the cftags, including the cfif are processed before the query itself is sent to the sql server, so all this happens within cf. -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 13:30 To: CF-Talk Subject: SQL in a CFIF How would write a select statement within a CFIF statement. 1. Can it be done? 2. What is the Syntax? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL in a CFIF
Like I said use: WHERE ll_userroles.userroles_id IN '#org_dlo#' instead of WHERE ll_userroles.userroles_id = '#org_dlo#' Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 2:20 PM Subject: RE: SQL in a CFIF #org_dlo# can equal on of three numbers at this point. When they update the database the ID's change so this time it may be 18, 20, 21 next week it may be 1, 2, 3 and so on and so forth. I need to create everything so that if the ID's change the application will function exactly the same way without any interruption. CFIF IsDefined(dlo_org) CFIF Len(dlo_org) GT 0 TD VALIGN=top ALIGN=left FONT SIZE=-1 cfoutput cfquery name=getDloOrganization datasource=#application.lldbDatasource# SELECT DISTINCT InitCap(ll_userroles.userroles) || ' - ' || ll_organization.description as description FROM ll_userroles, ll_useruserroles, ll_user_org, ll_organization WHERE ll_userroles.userroles_id = '#org_dlo#' AND ll_userroles.userroles_id = ll_useruserroles.userroles_id AND ll_useruserroles.useruserroles_id = ll_user_org.useruserroles_id AND ll_user_org.org_id = ll_organization.org_id /cfquery /cfoutput cfoutput query=getDloOrganization #description# /cfoutput CFELSE nbsp; /CFIF /FONT /TD /CFIF Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:14 PM To: CF-Talk Subject: RE: SQL in a CFIF Ok ... I have no idea what that means. Perhaps you should post some actual code. Mark -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:07 PM To: CF-Talk Subject: RE: SQL in a CFIF Yeah but the 1 or 2 or 3 is dynamic and may not always be the same. If I have the ability to run a query I can figure out which one I need. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:08 PM To: CF-Talk Subject: RE: SQL in a CFIF Use Listfind Cfif Listfind(varName, 1) do A cfelseif Listfind(varName, 2) do B /cfif Listfind will work without throwing an error - even if the VarName is an empty string. Mark -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:54 PM To: CF-Talk Subject: RE: SQL in a CFIF Let me give an understanding of what I am doing. I have a variable that is passing one or up to three numbers. The numbers are passed like this: 1, 2, 3 or 1 or 1,2. My problem is I need to check to see if the the number is listed in the #variable#. so That I can go from there. My application works as long as my variable is only passing one number. If it passes 2 numbers my query doesn't like it. I have a query based on the variable 2 being in there. Any help would be appreciated. I am going crazy trying to figure it out. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Brendan Avery [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:43 PM To: CF-Talk Subject: RE: SQL in a CFIF you can not have your cfif conditional execute on the database-side; but you can put cfif and other cftags inside a cfquery tag-pair. for example if you had a page that had to display some item from your database, you could use a cfif to decide whether to pull an item by id or if no id is specified, pull the default item: cfquery name=iteminfo datasource=mydsn SELECT TOP 1 * FROM tbl_Merchandise WHERE cfparam name=currentitem default= cfif currentitem IS NOT id=#currentitem# cfelse default='y' /cfif /cfquery but it is important to note that the cftags, including the cfif are processed before the query itself is sent to the sql server, so all this happens within cf. -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 13:30 To: CF-Talk Subject: SQL in a CFIF How would write a select statement within a CFIF statement. 1. Can it be done? 2. What is the Syntax? Steven Lancaster Barrios Technology NASA/JSC 281-244
Re: SQL in a CFIF
Sorry that should be: WHERE ll_userroles.userroles_id IN (#org_dlo#) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 2:26 PM Subject: Re: SQL in a CFIF Like I said use: WHERE ll_userroles.userroles_id IN '#org_dlo#' instead of WHERE ll_userroles.userroles_id = '#org_dlo#' Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 2:20 PM Subject: RE: SQL in a CFIF #org_dlo# can equal on of three numbers at this point. When they update the database the ID's change so this time it may be 18, 20, 21 next week it may be 1, 2, 3 and so on and so forth. I need to create everything so that if the ID's change the application will function exactly the same way without any interruption. CFIF IsDefined(dlo_org) CFIF Len(dlo_org) GT 0 TD VALIGN=top ALIGN=left FONT SIZE=-1 cfoutput cfquery name=getDloOrganization datasource=#application.lldbDatasource# SELECT DISTINCT InitCap(ll_userroles.userroles) || ' - ' || ll_organization.description as description FROM ll_userroles, ll_useruserroles, ll_user_org, ll_organization WHERE ll_userroles.userroles_id = '#org_dlo#' AND ll_userroles.userroles_id = ll_useruserroles.userroles_id AND ll_useruserroles.useruserroles_id = ll_user_org.useruserroles_id AND ll_user_org.org_id = ll_organization.org_id /cfquery /cfoutput cfoutput query=getDloOrganization #description# /cfoutput CFELSE nbsp; /CFIF /FONT /TD /CFIF Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:14 PM To: CF-Talk Subject: RE: SQL in a CFIF Ok ... I have no idea what that means. Perhaps you should post some actual code. Mark -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:07 PM To: CF-Talk Subject: RE: SQL in a CFIF Yeah but the 1 or 2 or 3 is dynamic and may not always be the same. If I have the ability to run a query I can figure out which one I need. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:08 PM To: CF-Talk Subject: RE: SQL in a CFIF Use Listfind Cfif Listfind(varName, 1) do A cfelseif Listfind(varName, 2) do B /cfif Listfind will work without throwing an error - even if the VarName is an empty string. Mark -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:54 PM To: CF-Talk Subject: RE: SQL in a CFIF Let me give an understanding of what I am doing. I have a variable that is passing one or up to three numbers. The numbers are passed like this: 1, 2, 3 or 1 or 1,2. My problem is I need to check to see if the the number is listed in the #variable#. so That I can go from there. My application works as long as my variable is only passing one number. If it passes 2 numbers my query doesn't like it. I have a query based on the variable 2 being in there. Any help would be appreciated. I am going crazy trying to figure it out. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Brendan Avery [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:43 PM To: CF-Talk Subject: RE: SQL in a CFIF you can not have your cfif conditional execute on the database-side; but you can put cfif and other cftags inside a cfquery tag-pair. for example if you had a page that had to display some item from your database, you could use a cfif to decide whether to pull an item by id or if no id
Re: CF Certification
Hm. Macromedia's Certification Department is working on a new certification exam for the next release of ColdFusion. We expect to release this exam in August 2002. So I guess that means that the next relase of CF will be out before or around August 2002. I thought MM wasn't going to tell us when it was coming out, but ya can't have an exam without a product now can you ;-) Thanks Ben Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERYPARAM and dates
Hey All, I'm using CFQUERYPARAM to try and insert a date into SQL Server 2K and I'm getting this error: ODBC Error Code = S1C00 (Driver not capable) [Microsoft][ODBC SQL Server Driver]Optional feature not implemented The code looks like this: cfqueryparam value=#Now()# cfsqltype=cf_sql_date (I've also tried #CreateODBCDate(Now())# for value) Any thoughts? BTW CF 5 Enterprise on Win2K Prof. TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT New window
My mistake. I had tried that code before and thought I didn't like it because it refreshed. Turns out I just wanted the window always on top so I ditched it ;-) For now it's good enough because the user can click the link in the main window again and will re-pop the window instead of just reloading in the task bar. Ultimately I want to keep it on top but without timed refreshes...but I'm not sure if it's doable. Thanks all for the replies ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Dave Hannum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 15, 2002 11:42 AM Subject: Re: OT New window That does not cause the window to refresh. That just brings it to the front when it loads. Dave - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 15, 2002 2:29 PM Subject: Re: OT New window That throws the window into a constant state of refreshing..that's what I don't want ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Dave Hannum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 15, 2002 11:11 AM Subject: Re: OT New window BODY onLoad=window.focus() Dave - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 15, 2002 1:59 PM Subject: Re: OT New window On this line of pop-ups. I'm looking for code to always keep the window on top without constantly refreshing it (because the user needs to do stuff in the window...not just for display...refrehes kill form selections). If nobody can help there, then does anybody have code that will re-pop the window if the link in the main window is clicked again (i.e. bring it out of the task bar if it's been minimized). TIA all ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 15, 2002 10:50 AM Subject: Re: OT New window call the OpenWindow function with at timestamp as the title openWindow(strURL, new Date(), intWidth, intHeight); Ray Bujarski [EMAIL PROTECTED] on 03/15/2002 12:41:14 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: OT New window I am using the following code to open a new window. However when one window has already been spawned from the opener, any more new windows simply re-use the same one. I need to open a new window every time, (My users REALLY want to annoy themselves;-) Can anyone tell me how to get the below code to do such a thing? SCRIPT LANGUAGE=javascript !-- function OpenWindow(strURL, strTitle, intWidth, intHeight) { var intWindowLeft var intWindowTop var msgWindow // find out the numbers to center the screen. intWindowLeft = (screen.width - intWidth) / 2; intWindowTop = (screen.height - intHeight) / 2; msgWindow = window.open(strURL,strTitle,'toolbar=0,location=0,directories=0,status=0,men ubar=0,scrollbars=0,resi zable=0,width ' + intWidth + ',height=' + intHeight + ',left=' + intWindowLeft + ',top=' + intWindowTop); } //-- /SCRIPT Thanks! Ray Bujarski 858-845-7669 858-636-9900 pgr [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfqueryparam problem
The value for the ? will be shown after the query in the debugging output labelled Parameter # 1. All is well...don't fret ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Jason Davis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 16, 2002 1:36 PM Subject: cfqueryparam problem I'm trying to perfom the following: cfquery name=Get_email datasource=users dbtype=odbc SELECT TOP 1 User_Name FROM Users WHERE User_Email='cfqueryparam value=#Form.User_Email#' /cfquery while outputting cfoutput query=Get_email#User_Name#/cfoutput I'm receiving this: ? (MSSQL 2K). when I replace the cfqueryparam with: [EMAIL PROTECTED], I see the right answer. Is there a known issue or something I misunderstood on string w/ cfqueryparam? Thanks. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Database locked by admin?
Compact and Repair your databaseit's corrupted :-( Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: David Grabbe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, March 17, 2002 9:49 AM Subject: Database locked by admin? I am getting an error message about my database being locked by 'admin' and was wondering if anyone out there has any suggestions: Message: ODBC Error Code = S1000 (General error)P Native error code: -1102 SQLState: S1000 Detail: [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'MYMACHINE'.PPData Source = mydatasourceP In the archives I found that this may be because the database is corrupt -- I've run the compression/correction option on it (MS-Access database), but this keeps happening. The database this error occurs on is my visitors log -- for every page hit I write out a record w/ the HTTP referrer, USER_AGENT, date/time, etc. The website isn't high-volume at all (i.e. averaging around 1000 page hits/day), but when these errors come up IS when there are a relatively large number of page requests (for this website) within a short period of time. ODBC problem? MDAC? Need to upgrade to SQL server? :) TIA, David David Grabbe Manager, Information Systems Church of the Great God [EMAIL PROTECTED] http://www.cgg.org __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Flash MX
Hey Scott, I'm on the beta too and would love to see what you're working onmabye catch me offlist? Cheers Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Scott Van Vliet [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, March 17, 2002 5:43 PM Subject: RE: Flash MX Agreed! I am on the beta, and have built some really cool apps with it already. -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 3:36 PM To: CF-Talk Subject: Flash MX Well I must say that I just about peed myself after just trying out flash MX for the first time. This is so awesome No more floaters to get in the way, better use of the timeline etc..the list just goes on and on and on..kind of like the Energizer Macromedia Bunny !!!:) Success is a journey, not a destination!! Doug Brown __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Advice and opinion on client who has a problem paying bills
Time to chime in ;-) I haven't read all the posts, but this seems to be a common problem (been there a few times). We recently put together an e-business development guide (http://www.electricedgesystems.com/guide.cfm?pg=guide) to hand to potential new clients. It answers a lot of their technical question AND covers how the development process will and should proceed (also focuses those clients that walk in and want a websiteand thenhehe). It's that part that may help lay the groundwork for a lot of folks out there that run into the how should I handle this client stuff. All I can say is I've been burned in a few different ways and now I make people sign NDAs, get a deposit up front, always do a system requirements and technical design doc, and live by change request forms ;-) HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Jerry Johnson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 18, 2002 7:57 AM Subject: RE: OT: Advice and opinion on client who has a problem paying bills To push it a little farther, I go 50% to start and 50% on delivery on contracting jobs. And I normally bid the work so that the first 50% covers my costs. So (almost inevitably) as the second half payment drags on, I don't care so much. If you manage expectations, and clearly define maintenance vs enhancement work, clients usually pay off in the end. And the few that don't typically treat all their vendors that way. A little bit of Chamber of Commerce discussion can save you lots of legal fees. And remember, you can always back out any changes the client hasn't paid for if you keep good records and use some form of version control. Jerry Johnson [EMAIL PROTECTED] 03/17/02 01:03PM Very true. Almost every client over the years has not blinked at a retainer fee to start the work. We go the route of designers: 33 down, 33 acceptance of mock, 33 upon delivery to server...or it doesn't go live. The only ones we have had complain were the ones who would try to take us for a ride. Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -Original Message- From: laszlo [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 16, 2002 1:39 PM To: CF-Talk Subject: Re: OT: Advice and opinion on client who has a problem paying bills Very well said, Mark. In addition: - Many times these kind of things are what I call the mismatch of expectations and is not necessarily implies that any of the parties is a 'bad guy'. Therefore, a 'contract' is always a must. I like writing the scope of work together with the client: He knows what he wants, I know what can be done. We (developers) hate to do this kind of work, but if you are an independent consultant, it's a must. I usually charge hourly rate for writing up specs, even if I go for a fixed bid. The reason is, that I cannot give a fix price, before the spec is cast in stone, but I know, that a detailed spec is going to take time, otherwise it's useless. - I also strongly advocate to maintain a 'retainer' fee. And while some clients are not crazy about it, you can explain them why it is necessary. If a client plainly rejects the retainer idea, it's my experience, that they may not plan to keep the balance up-to-date. So I usually don't deal with them. Sorry, if some of this was OT, but felt like I can share some of the things I learned during the 25+ years of consulting. Regards, laszlo __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: alternating rows
cfloop query=MyQuery !--- set var(s) for alternating row colour --- cfset TextBack = iif(currentrow mod 2, DE(blue), DE(green)) tr td bgcolor=#TextBack#gsgssd/td /tr /cfloop Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Justin Hansen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 18, 2002 10:51 AM Subject: RE: alternating rows This is what I use... trcfif qryName.currentrow mod 2 EQ 0 class=altRow/cfif Justin Hansen -- Uhlig Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 12:31 PM To: CF-Talk Subject: alternating rows Does anyone remember the quick way to alternate row colors when using MOD on a recorcount? Mike __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Flash MX and CF5
Doug, Flash MX will make that process WAY easier ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 9:20 AM Subject: Flash MX and CF5 We prob need a CF-flashTalk list, but in the meantime I am just now beginning my journey into dynamic content in flash, and was wondering if someone had an idea of how to populate a combo box from a query... I have this so far, please help. Query CFQUERY DATASOURCE=carnivore NAME=mfg_list SELECT * FROM mfg /CFQUERY CFSET myList = ValueList(mfg_list.mfgid,,) CFOUTPUTmfg=#myList#/CFOUTPUT Flash Button action on (release) { loadVariablesNum(http://www.carnivorepc.com/console/qry/qry_mfg_list.cfm;, 0, GET); mfgList.addItem(mfg); } Success is a journey, not a destination!! Doug Brown __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Search Engine Placement Service
try www.stepforth.com Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Haggerty, Michael A. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 8:43 AM Subject: OT: Search Engine Placement Service I have a client who is looking to boost his site's search engine rankings. Does anyone have any experience with search engine placement services? I am looking for one that either has a good track record or will guarantee results. This site has a product serving a niche market, and the last company I worked with charged a lot and produced very little. M __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Terms+Conditions for packaged web app
I'd be sure to be paid well for the development because I have seen MANY of these types of deals tank. The developer gives the client a cut rate on initial development because they think that all the sign-ups will come after and they make their extra $ setting up the template sites. The problem is that those sign-ups never happen (or to a much lesser degree than expected). So just be aware that all may not be as rosy as it seems. As far as protecting your code from being copied and deployed elsewhere without your knowledge The easiest way is to not turn over the code. Being that you would be the only folks touching the backend to create these template sites...why not be the only ones with FTP access to the code on the live server ;-) I don't have any contracts specific to this situation...sorry Good Luck Cheers Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 8:46 AM Subject: Terms+Conditions for packaged web app We've been asked by a client (a design agency) to put together a ColdFusion web app that is basically a template for generating dynamic microsites. We're looking at something that can have up to 10 pages, a limit to the amount of text and images that can be uploaded, modular design, a customisable contact form, etc. Your basic consultant/small company brochure/contact site that's completely controlled from a CF backend. The deal is, we get a one-off fee for developing it, then get a nominal fee for throwing each one together as the orders come through. Throwing each one together will hopefully take next to no time, if we build the template in a nice modular, adaptable fashion. Obviously we want to protect ourselves against this handy little app being carried off and used all over the place without our knowing about it or being paid. We'll be doing some stuff that will prevent non-coders from being able to steal it, but we want some legal protection (for what it's worth) just in case. Are there any templates out there for a contract/terms and conditions for this sort of web app deal that anyone would recommend? Hints tips about doing this kind of work? We're UK-based, if that makes any difference. Any pointers gratefully received :) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Encryption
for passwords use MD5 (CFX_HASH) - one way hash for CC you need 2 way encryption (encrypt/decrypt) - check archives for this hot debate ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 8:50 AM Subject: Encryption Anyone have a good way of encrypting data in to a SQL server DB? I am looking for something reputable and reliable. It would have to handle credit cards and passwords. Thanks, Neil __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: action script e-list
I'd love a list like that tooand any decent Action Script tutorials Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 9:34 AM Subject: OT: action script e-list Anyone know of a good action script email list for a friend of mine? -mK __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MS Access - Updating a date value broke
change #dateformat(now(),MM/DD/)# to #CreateODBCDate(Now())# for just date with 12:00AM for time OR to #CreateODBCDateTime(Now())# to get current date and time HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Brian Fox [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 10:32 AM Subject: MS Access - Updating a date value broke Hi - Here's a query that is run against a Microsoft Access database. It has been working fine for a few years now, but has suddenly broke. Starting this month, Access is recording the DATE_SUBMITTED as a time value, usually around 12:00 AM, instead of a date. The last recorded correct date is 1/8/2002. Anyone know what would cause this? cfquery name=ClassSubmit datasource=facultygrade update courses set WEB_STATUS=2,DATE_SUBMITTED=#dateformat(now(),MM/DD/)# Where CRN='#attributes.crn#' and (INSTRUCTOR_ID_1='#User#' or INSTRUCTOR_ID_2='#User#' or INSTRUCTOR_ID_3='#User#') /cfquery Thanks, Brian __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Inserting CFIF into CFINPUT
It may be an extra # around that tag and nothing to do with the tag (I can't see anything wrong excpet the use of # around GEC.Sex is not required). HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Angel Stewart [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:06 AM Subject: Inserting CFIF into CFINPUT Hey all, I want to make a CFINPUT Radio button checked or unchecked depending on the value of a variable from the database. Simple right? Yup..I thought so too. So why doesn't it work? cfinput type=Radio name=sex value=Male cfif #GEC.Sex# eq Male CHECKED = TRUE /CFIF I get this error: --- Just in time compilation error Invalid token found on line 52 at position 67. ColdFusion was looking at the following text: Invalid expression element. The usual cause of this error is a misspelling in the expression text. The last successfully parsed CFML construct was a CFINPUT tag occupying document position (52:21) to (52:28). --- Any ideas on what I'm doing wrong? I expect it to be some simple syntax error. -Gel __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERYPARAM and IN clauses
Hey All, Just wondering what the consensus is on using CFQUERYPARAM and IN clauses with a list of integers? What's the best (if any) cfsqltype to use? Should the value still be in brackets ()? Thanks Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFQUERYPARAM and IN clauses
DOH! TGIF cause it's time to RTFM IMHOLOL Thanks Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 22, 2002 1:20 PM Subject: Re: CFQUERYPARAM and IN clauses There's a list attribute for that tag. - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] Date: Friday, March 22, 2002 2:18 pm Subject: CFQUERYPARAM and IN clauses Hey All, Just wondering what the consensus is on using CFQUERYPARAM and IN clauses with a list of integers? What's the best (if any) cfsqltype to use? Should the value still be in brackets ()? Thanks Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Invalid Cast Specification? WTF?
Hey Gel, Did you ever get that cast specification error figured out? It just hit me too ;-) TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Angel Stewart [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 22, 2002 6:45 AM Subject: Invalid Cast Specification? WTF? ___ ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification (null) Data Source = RACE SQL = UPDATE event_cat SET `category` = ?, `cost` = ?, `max_age` = ?, `min_age` = ?, `sex` = ?, `type` = ? WHERE `cat_id` = ? Data Source = RACE The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (13:2) to (16:174) in the template file __ What in the WORLD is this?!?? Yes some fields are blank...but..none of them are set to no Nulls or something like that. What does this error mean? First time I am seeing it. -Gel __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists