FW: Search engine safe urls in CFMX
Hi Can anyone tell me how you turn urls into search engine safe urls in Coldfusion Mx i.e TURN index.cfm?user=Joe Bloggsbgcolor=bluecounty=2 INTO index.cfm/user=Joe Bloggs/bgcolor=blue/county=2 etc etc Thanks in Advance Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W biznet-solutions.com ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2003. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Access /SQL Server
Hi, We have recently migrated an access database to sql server 2000. The transfer has gone great and the site runs quicker in 98% of the site However there is one page (around 1500 lines of code) which carries out allot of calculations and references 2 tables with about 20 records in each of them. We have found that the page still runs quicker in an access database than a sql server db, we have also checked indexes and created stored procedure for a number of the queries. Can anyone tell me what we should check for as currently it is running about 3 times slower? TIA Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Access /SQL Server
Andy, It is only selecting data and it is running on the same server as the access versions? We would appreciate any advice. Jerry -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 22 April 2002 16:13 To: CF-Talk Subject: RE: Access /SQL Server Sounds like the majority processing on this page is CF. Check the debugging output and see how long the SQL queries take. If your SQL queries are taking a noticable abmount of time then I'd suggest ensuring that your indexes are correct and that your Transact SQL is effecient. Without seeing the code it's hard to suggest what it is. Is this page inserting/updating/or deleting data? if so your indexes will increase the time it takes to execute the SQL statement and hence the page as all of your indexes have to be rebuilt when an action other than a select is performed on the table. -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 22 April 2002 16:08 To: CF-Talk Subject: Access /SQL Server Hi, We have recently migrated an access database to sql server 2000. The transfer has gone great and the site runs quicker in 98% of the site However there is one page (around 1500 lines of code) which carries out allot of calculations and references 2 tables with about 20 records in each of them. We have found that the page still runs quicker in an access database than a sql server db, we have also checked indexes and created stored procedure for a number of the queries. Can anyone tell me what we should check for as currently it is running about 3 times slower? TIA Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** __ 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
Stored Process
Hi , I am transferring few queries into stored procedures but I have come across a stumbling block, and would be grateful if anyone could advise, for example: I am gathering a list of all countries on one page and sending them to the action page as a list, what I have is a query select * from country where country_id in (#url.countries#). This works fine in cfquery of course, but when I put it into a stored procedure it doesn't like the list of id's being passed in and only expects one value. I.E. cfstoredproc procedure=sp_countries datasource=geographical RETURNCODE=YES cfprocparam type=In dbvarname=@country value=#url.countries# cfsqltype=CF_SQL_INTEGER cfprocresult name=Sp_Countries /cfstoredproc You may be thinking what would I want to put this in a stored procedure for, but above is only an example but the principle is what im after. How do you pass a list into a stored procedure. Many Thanks In advance Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.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: Stored Process
Adrian, Im not sure as I am new to stored procedures.What do you think it should be ? -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 16 April 2002 11:43 To: CF-Talk Subject: RE: Stored Process cfsqltype=CF_SQL_INTEGER is that correct?? -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 16 April 2002 11:31 To: CF-Talk Subject: Stored Process Hi , I am transferring few queries into stored procedures but I have come across a stumbling block, and would be grateful if anyone could advise, for example: I am gathering a list of all countries on one page and sending them to the action page as a list, what I have is a query select * from country where country_id in (#url.countries#). This works fine in cfquery of course, but when I put it into a stored procedure it doesn't like the list of id's being passed in and only expects one value. I.E. cfstoredproc procedure=sp_countries datasource=geographical RETURNCODE=YES cfprocparam type=In dbvarname=@country value=#url.countries# cfsqltype=CF_SQL_INTEGER cfprocresult name=Sp_Countries /cfstoredproc You may be thinking what would I want to put this in a stored procedure for, but above is only an example but the principle is what im after. How do you pass a list into a stored procedure. Many Thanks In advance Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.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: Stored Process
Thanks very Much Mike -Original Message- From: Mike Bruce [mailto:[EMAIL PROTECTED]] Sent: 16 April 2002 12:07 To: CF-Talk Subject: Re: Stored Process Unfortunately building an 'in' statement in a stored procedure is not as straight forward as one would like. You can not simply pass in a list and SQL know what you are trying to do. You can, however, build the SQL statement and then call the spExecuteSQL to run the new SQL -- CREATE PROC myStoredProc @myString varchar100 AS DECLARE @SQLStatement SET @SQLStatement = 'select * from country where country_id in (' @myString ')' EXEC spExecuteSQL @SQLStatement --- Check Books online to verify the syntax. Mike Bruce - Original Message - From: Jerry Staple [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 6:52 AM Subject: RE: Stored Process Adrian, Im not sure as I am new to stored procedures.What do you think it should be ? -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 16 April 2002 11:43 To: CF-Talk Subject: RE: Stored Process cfsqltype=CF_SQL_INTEGER is that correct?? -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 16 April 2002 11:31 To: CF-Talk Subject: Stored Process Hi , I am transferring few queries into stored procedures but I have come across a stumbling block, and would be grateful if anyone could advise, for example: I am gathering a list of all countries on one page and sending them to the action page as a list, what I have is a query select * from country where country_id in (#url.countries#). This works fine in cfquery of course, but when I put it into a stored procedure it doesn't like the list of id's being passed in and only expects one value. I.E. cfstoredproc procedure=sp_countries datasource=geographical RETURNCODE=YES cfprocparam type=In dbvarname=@country value=#url.countries# cfsqltype=CF_SQL_INTEGER cfprocresult name=Sp_Countries /cfstoredproc You may be thinking what would I want to put this in a stored procedure for, but above is only an example but the principle is what im after. How do you pass a list into a stored procedure. Many Thanks In advance Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.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
CFGRAPH
Hi Does anyone know how to add multiple lines as the valuecolumn on a line type graph?? TIA Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** __ 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
VXML/CF Guru Required
Hi, Does anyone have any experience at all with coldfusion and vxml? if so! could I contact you directly to ask you a few questions. Thanks in Advance Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** __ 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: ISP Caching
JL We had problems but not with client vars but with sessions. Some users were stating that there profiles were swapping and vice versa even though the session vars were locked.We put it down to the proxy servers caching the page. To rectify the problem we just attached a random number on the end of the urls to trick the server thinking its a newer page etc. set the randrange function in the application.cfm and then attach the variable to the end of your urls. Works great. Cheers Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com -Original Message- From: J L [mailto:[EMAIL PROTECTED]] Sent: 05 April 2002 03:58 To: CF-Talk Subject: ISP Caching Hi all, I just want to see who else is having this problem. We are using CF 5, client vars, and cookies. Basically the problem is that one of our users from A can log in as one of our users from B. And that B user can log in as that A user. What i mean log in here is that they use bookmark to go to our secure website (username and password protected) and the website shows up A's name in B's machine and shows up B's name in A's machine. That A user can also log in as one of our European users. All of our users do not share URLs, usernames/passwords or anything like that. We use client vars to maintain states. CFID/CFTOKEn are not showing up in the URL. Members of our group state that it's the ISP caching problem. That's why our users can log in as other users. I am wondering whether any of you guys have this problem. And does anybody know about this ISP caching thing? Thanks in advance. JL ___ Get the FREE email that has everyone talking at http://www.mail2world.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Creating update statements on the fly
Try This UPDATE tablename SET blah = '#form.blah#' cfif isDefined(attributes.String1) ,string1 = attributes.String1 /cfif cfif isDefined(attributes.String2) ,string2 = attributes.String2 /cfif cfif isDefined(attributes.String3) ,string3 = attributes.String3 /cfif WHERE theid = #form.theid# with regards to create the set you are going to have to set a flag with what you want to update i.e. if the update button is clicked or a hidden form value is equal to something if you explain the scenario I will be able to advise you better but the above will give you the ability to create a dynamic update statement without worrying about the ,. Cheers Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] W biznet-solutions.com http://www.biznet-solutions.com/ From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]] Sent: 29 March 2002 16:10 To: CF-Talk Subject: Creating update statements on the fly HI, I wanted to create a Update statement on the fly. For creating a Select statement on the fly I have used Select * from tablename Where 0=0 cfif isDefined(attributes.String1) and String1 = attributes.String1 /cfif How can I achieve this for update statement as I couldn't figure out where to put Set statement and the last line with out coma(',') in my statement. Thanks in advance. Sudheer Chakka. __ 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: Exporting data to Excel spreadsheet
Have a look at http://www.cfcomet.com/cfcomet/ its a great resource site for cf and integration for ms office products. enjoy Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED]] Sent: 03 April 2002 08:23 To: CF-Talk Subject: Exporting data to Excel spreadsheet At one of my clients, the content providers each look after an allocated part of the data used for displaying information on the web site. They want to be able to export their data to a spreadsheet so they can review it and update it off line. These are not IT people but experts in their various consumer fields. They want me to put a button in their admin areas for each category of comsumer data so it will export the data for them automatically. I was going to do it this way and I wondered if there was a better way: (1) Have a spreadsheet already attached to CF as a datasource. (2) Use a CFQuery to delete all the records in that datasource. (3) CFQUERY the SQL7 table the content provider wants to export (4) loop through the query, inserting the data into the (now blank) spreadsheet. (5) Use CFMail to email the spreadsheet to the user (getting their email address from their logon details). I seem to remember a function or a tag that output the results of a query into spreadsheet format but I can't find any reference to it any more. Can anyone enlighten me? Is this the easiest way? Will CFMail be able to send the spread sheet or will I need to unlock it from the server first? in which case, how can i do that automatically? Cheers, Mike Kear AFP Webworks, Windsor, NSW, Australia __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
Anyone for a spot of VXML
Hi, I have started top dabble in voice driven apps integrated with Cf.This is not a problem the problem is I am currently using voicegenie (usa) to process the vxml through their vxml gateway (great service). The app runs on our own servers but I dial up a number to access the app, because I am just dabbling with Vxml it would be too expensive to run our own vxml gateway at present.As we are based in Belfast the accounts department has started to look at my phone calls to the usa with horror,and I can see my wages disappear in front of my very eyes. Does anyone know of a similar service that voicegenie provides except a bit closer to home i.e. the Glorious UK. Many Thanks Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** __ 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: Anyone for a spot of VXML
Cheers Rich -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 28 March 2002 10:20 To: CF-Talk Subject: RE: Anyone for a spot of VXML Jerry, BeVocal have a UK gateway (actually dials up over the pond but you get charged UK rates) check it: http://cafe.bevocal.com/ I used them for some trial apps and it worked quite well. -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 28 March 2002 09:32 To: CF-Talk Subject: Anyone for a spot of VXML Hi, I have started top dabble in voice driven apps integrated with Cf.This is not a problem the problem is I am currently using voicegenie (usa) to process the vxml through their vxml gateway (great service). The app runs on our own servers but I dial up a number to access the app, because I am just dabbling with Vxml it would be too expensive to run our own vxml gateway at present.As we are based in Belfast the accounts department has started to look at my phone calls to the usa with horror,and I can see my wages disappear in front of my very eyes. Does anyone know of a similar service that voicegenie provides except a bit closer to home i.e. the Glorious UK. Many Thanks Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com ** ** ** If you are not the intended recipient, or person responsible for delivering it to the intended recipient, you are not authorized to and must not disclose, copy, distribute or retain this message or any part of it. The opinions / views / comments on this e-mail do not necessarily reflect any views or policies of biznet The recipient should check this email and any attachments for the presence of viruses. biznet accepts no liability for any damage caused by any virus transmitted by this email. biznet 2001. ** ** ** __ 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: Select list values
Mike Try this as your last option: OPTION value= CFIF AppMenuID eq Selected/CFIF[None selected]/OPTION Jerry Staple Web Application Developer Certified Coldfusion (5.0) Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] W www.biznet-solutions.com -Original Message- From: Office [mailto:[EMAIL PROTECTED]] Sent: 28 March 2002 22:42 To: CF-Talk Subject: Select list values I'm populating an SQL7 table with possible numeric values AppMenuID using a look up list from a web form. The field can also be left null. It puts the correct value or null into the table but the form dosn't show that null has been selected for the record next time I come back. How do I get this to work. Thanks for any tips Mike Peters NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz SELECT name=AppMenuID size=1 OPTION CFIF AppMenuID IS 1Selected/CFIF value=1Messages/OPTION OPTION CFIF AppMenuID IS 4Selected/CFIF value=4My Groups/OPTION OPTION CFIF AppMenuID IS 2Selected/CFIF value=2Personal/OPTION OPTION CFIF AppMenuID IS 3Selected/CFIF value=3Submit/OPTION OPTION CFIF AppMenuID IS 5Selected/CFIF value=5Tasks/OPTION OPTION CFIF AppMenuID IS NullSelected/CFIF value=[None selected]/OPTION /SELECT -- __ 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: columnlist
Or Queryname.Columnlist Jerry Staple Web Application Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] W biznet-solutions.com http://www.biznet-solutions.com/ -Original Message- From: Nate Smith [mailto:[EMAIL PROTECTED]] Sent: 05 October 2001 15:45 To: CF-Talk Subject: RE: columnlist I'm not sure if there is a way to return the column names from a query result set in the query order. However, if you just want to get ALL the column names from the table in the correct order, you could use this query. This works for SQL Server where TABLENAME is the name of the table that you want the column information. I'm not certain about any other servers. SELECTname FROM syscolumns WHERE (id =(SELECT id FROM sysobjects WHERE name = 'TABLENAME')) ORDER BY colorder - Nate Smith, Lead Developer Macromedia Coldfusion 5 Certified Professional Macromedia Certified Web Site Developer [EMAIL PROTECTED] www.doceus.com -Original Message- From: saro cf [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 6:43 PM To: CF-Talk Subject: columnlist How to preserve the ordering of columnlist returned by cfquery. By default it is ordering by alphabetical. I need the same column order specified in table. -Saro -- saro cf [EMAIL PROTECTED] - email (818) 630-2340 x6093 - voicemail/fax ~~ 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: 2 Submit Buttons on one form
Mark Try This Within your form:: form action=submit within itself or wherever action =Post 1st Submit =input type=Submit 2nd Submit = input type=Button onClick=changeSubmit(); /form script language=JavaScript function changeSubmit(){ // New page to submit to document.forms[0].action = 'Wherever.cfm?whatever=#what#'; document.forms[0].submit(); } /script Hope it Helps Jerry Staple Web Application Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] W biznet-solutions.com http://www.biznet-solutions.com/ -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: 02 October 2001 16:23 To: CF-Talk Subject: 2 Submit Buttons on one form Is it possible to place two submit buttons on one form, each button calling a different action (template). If so, how would it be done? Thanks, Mark ~~ 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
CF Certification
Anyone with any advice for the CF Certified Developer exam? Thanks in Advance Jerry Staple Web Application Developer http://www.biznetprojects.co.uk/complogo.gif Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] W http://www.biznet-solutions.com/ biznet-solutions.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: CF5 Pro SN
Lets give it a rest eh !! Jerry Staple Web Application Developer Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] W biznet-solutions.com http://www.biznet-solutions.com/ -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: 30 August 2001 16:10 To: CF-Talk Subject: RE: CF5 Pro SN It may not be illegal strictly but, it isn't cricket and certainly isn't etiquette. Regardless of whether anyone here would use it (I think we are all intelligent people here) Perhaps posting the serial number was a mistake altought looking at the guys name (i.e. Warez) I would suggest not. -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: 30 August 2001 11:41 To: CF-Talk Subject: RE: CF5 Pro SN Lets not get anal here. Maybe giving your serial to someone is not illegal per say - as it is just string of numbers and letters - but why would you want to? If you are arguing the toss about whether giving information is illegal or not - can I have your bank details and credit card numbers? remember it is not illegal to do so. come one, put your money where your mouth is. N ~~ 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: Help with sql server
Hi I had that trouble a couple of weeks ago try this: Open up cf administrator Locate your Data base and double click on it; 1.Make sure the server name is correct. 2.Tick the use trusted connection 3.Type the name of your db into the login info. Try that, hope it helps All the Best Jerry Staple Web Application Developer Biznet Solutions 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] W biznet-solutions.com http://www.biznet-solutions.com/ -Original Message- From: Neo Fusion [mailto:[EMAIL PROTECTED]] Sent: 06 August 2001 05:08 To: CF-Talk Subject: Help with sql server I have converted a access database to sql server 7.0 my tables have not changed but everytime i try and access any page that has a database call i recieve the following error ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'report2s'. SQL = SELECT picture, lastupdated, id FROM report2s WHERE ((id)=4 Or (id)=5 Or (id)=6) Data Source = xx The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (3:55) in the template file e:\inetpub\wwwroot\evisions\index.cfm. Date/Time: 08/06/01 00:04:38 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 127.0.0.1 ~~ 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
SQL Server 7.0 Advice
Morning, Could anyone give me any feedback on the following: We have a SQL Server say for example SQL1 based in Belfast, and another SQL Server SQL2 Based in Dublin. What i need to do is write a stored procedure from a database in SQL1 Table1 to insert data into SQL2 Table2,i have a few ideas but any tips and feedback would be most apreciated. Thanks In Advance Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.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
SQL SERVER 7
Afternoon or Morning, Could anyone give me any feedback on the following: We have a SQL Server say for example SQL1 based in Belfast, and another SQL Server SQL2 Based in London. What i need to do is write a stored procedure from a database in SQL1 Table1 to insert data into SQL2 Table2,i have a few ideas but any tips and feedback would be most apreciated. Thanks In Advance Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.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: cfmail
Yes Make Sure you send it as type=html Jerry Staple Web Application Developer http://www.biznetprojects.co.uk/complogo.gif Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] W http://www.biznet-solutions.com/ biznet-solutions.com -Original Message- From: Jones, Becky [ mailto:[EMAIL PROTECTED]] Sent: 31 July 2001 16:47 To: CF-Talk Subject: cfmail is there a way to put td tags in the cfmail tag to make the formatting prettier? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
SQL SERVER 7
Hi, Could anyone give me any feedback on the following: We have a SQL Server say for example SQL1 based in Belfast, and another SQL Server SQL2 Based in London. What i need to do is write a stored procedure from a database in SQL1 Table1 to insert data into SQL2 Table2,i have a few ideas but any tips and feedback would be most apreciated. Thanks In Advance Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.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
SQL 7.0 linking Tables to Access
Hi Can any one inform me of a way to link from a SQL Db to an access db table?The access table in future will be transfered to SQL 7,but not yet. I know about the import etc but i would like the SQL database to be linked to a live Access Table. Any Ideas?? Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.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
Cancel: SQL 7.0 linking Tables to Access
Sorted! -Original Message- From: Jerry Staple Sent: 29 July 2001 07:57 To: CF-Talk Subject: SQL 7.0 linking Tables to Access Hi Can any one inform me of a way to link from a SQL Db to an access db table?The access table in future will be transfered to SQL 7,but not yet. I know about the import etc but i would like the SQL database to be linked to a live Access Table. Any Ideas?? Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.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
SQL 7.0 linking to Access
Hi Can any one inform me of a way to link from a SQL Db to an access db table?The access table in future will be transfered to SQL 7,but not yet. I know about the import etc but i would like the SQL database to be linked to a live Access Table. Any Ideas?? Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.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
Test Ignore
Please Ignore Just Testing Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.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
JavaScript Function
Hi, Could anyone give me advice on the following function? Ive got 2 Select boxes with Years as the value for each,so that the user can pick dates from to etc. ie From select name=YearFrom 1999 up to 2030 to select name=YearTo1999 up to 2030 what i require is a function (Onsubmit) that makes sure that the year to is not less than the year from,throwing up an alert box. Many Thanks in Advance Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.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: JavaScript Function
Thanks Tony! great Job! All the Best Jerry -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: 23 July 2001 15:58 To: CF-Talk Subject: Re: JavaScript Function I don't know exactly how to do this, but I'm a big fan of preventing wrong entry in the first place. You should be able to, when the YearFrom is selected, rewrite the contents of the YearTo select box to begin at the YearFrom selected. This way, it would be impossible to overlap. Just a thought. ;p Could anyone give me advice on the following function? Ive got 2 Select boxes with Years as the value for each,so that the user can pick dates from to etc. ie From select name=YearFrom 1999 up to 2030 to select name=YearTo1999 up to 2030 what i require is a function (Onsubmit) that makes sure that the year to is not less than the year from,throwing up an alert box. Many Thanks in Advance Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.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: Any CF 5 hosts out there
Dick, We are a company based in Belfast who specialise in coldfusion development and hosting! if you would like more information or details,dont hesitate to contact me direct. All the Best Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 [EMAIL PROTECTED] www.biznet-solutions.com -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 22 July 2001 01:18 To: CF-Talk Subject: Any CF 5 hosts out there I have a new client that will be moving to CF from Perl (subset). I would like to move him to CF 5 if it is reliable and I can find a CF5 host. Comments, suggestions. TIA Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this list monitored?
Well Said: Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 19 July 2001 13:24 To: CF-Talk Subject: RE: Is this list monitored? Jeez.some of you people are far too highly strung. The guy apologised. I've never seen a post like it before on this list, and it was only his opinion. And at the end of the day, you can moderate your self. If you don't like the sound of a topic, don't read it. Nowcan we get back to cf related stuff?? Will -Original Message- From: Skyward Internet Technology [mailto:[EMAIL PROTECTED]] Sent: 19 July 2001 12:55 To: CF-Talk Subject: Re: Is this list monitored? OK - let's moderate this list. Judith, you can approve or disapprove every single post (I'm sure you've got nothing else better to do), so now, instead of our posts coming up in a timely manner, each one will take hours - except that in the case of Judith being on vacation or sick, it will take days to weeks. Folks, it was one stupid post, by someone who had a brain fart. - a person that has drooled all over us with their apology - and we can't get over it? Man, some of us must not have enough work to do . . . . . Dave - Original Message - From: Debbie McDaniel [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 7:45 AM Subject: Is this list monitored? Hi All, Recently there was a political thread on this list which made mention of our President. I need to know if this list is monitored? If so, how did this get through? I would hate to have my company inform me that I need to unsubscribe because of issues like this. I have subscribed to this list for some time, and I've seen some stuff really off base, but this one took the cake. I would hate to lose a valuable resource. TIA, Debbie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: scatter graph solution
Deanna, You could always get Chart Fx its a great graphing package and very easily implemented withinn CF pages, but its certainly not free,although you can download trial copies. http://www.softwarefx.com/ Regards Jerry Staple -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: 17 July 2001 17:50 To: CF-Talk Subject: scatter graph solution Hi Folks, We haven't upgraded to 5.0 yet, and I have a client that wants a scatter graph (or a line graph), but not a bar graph. I'm pretty sure there's no easy way to do this for free. So, I've now been charged with figuring out if we should buy some add on (like Corda), or wait to complete this project until we have 5.0 installed (hopefully in the fall). Thoughts, anyone? Thanks! -Deanna Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Kill the President
Whats this got to do with Cold Fusion anyway? Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 18 July 2001 10:43 To: CF-Talk Subject: Kill the President Sorry if I ruffle anyone's feathers here not a CF topic, but I watched the 9 0'clock news last night on BBC 1 and watched an interview with the President of the United States, George Bush. This morning we have all been discussing the future career of this man and we all agree it will probably be short lived if America does realise what they have sitting in the presidential armchair. A man during his Judicial Congress career in Texas, managed to break all records and have more Death Row prisoners put to death by 4 times during his residency. Now as the President of the United States, Bush has made it quite clear he is not interested in the quick turn around to Global warming as is the rest of the World, he has declined to get involved with Northern Ireland after so much hard work with the Clinton Administration, his involvement and stance with the middle east peace process has not been made clear, and the most worrying is that he has decided to set the world back 15 years by re-establishing a Nuclear presence. To quote the President, I have said before to the rest of the world there is no more cold war, but America must protect itself from a rogue dictator What kind of signals is this sending out to the rest of the world, especially China? Its not so long ago only in the job by a few weeks he started to play hard ball against China, when their reconnaissance aircraft was forced to land after infringing Chinese airspace, their plane never recovered and America forced to apologize. Two years ago India and Afghanistan proceeded to test nuclear missiles and America opposed with the rest of Europe intensely, a global united stance, a sense of security and lack of desire for Military confrontations, Bush has decided to scrap this idea and restock on nuclear arms. Where is the political responsibility and consistency of America going, to be seen to be undoing all the hard work of a previous administration that sent America to it pest political and economical climate for decades, if even hasten to say ever can only be seen as a dictatorship in its own right. George Bush is not smart enough to be president, he lacks in humility, he is not political sound and what's worrying is if he continues to create a global stir someone could effectively try to kill the president. JMC ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Kill the President
cfif #George Bush# neq Cold Fusion Developer script alert ('#What the F*** has george Bush gotta do with Cold Fusion anyway?'); /script /cfif Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 18 July 2001 10:43 To: CF-Talk Subject: Kill the President Sorry if I ruffle anyone's feathers here not a CF topic, but I watched the 9 0'clock news last night on BBC 1 and watched an interview with the President of the United States, George Bush. This morning we have all been discussing the future career of this man and we all agree it will probably be short lived if America does realise what they have sitting in the presidential armchair. A man during his Judicial Congress career in Texas, managed to break all records and have more Death Row prisoners put to death by 4 times during his residency. Now as the President of the United States, Bush has made it quite clear he is not interested in the quick turn around to Global warming as is the rest of the World, he has declined to get involved with Northern Ireland after so much hard work with the Clinton Administration, his involvement and stance with the middle east peace process has not been made clear, and the most worrying is that he has decided to set the world back 15 years by re-establishing a Nuclear presence. To quote the President, I have said before to the rest of the world there is no more cold war, but America must protect itself from a rogue dictator What kind of signals is this sending out to the rest of the world, especially China? Its not so long ago only in the job by a few weeks he started to play hard ball against China, when their reconnaissance aircraft was forced to land after infringing Chinese airspace, their plane never recovered and America forced to apologize. Two years ago India and Afghanistan proceeded to test nuclear missiles and America opposed with the rest of Europe intensely, a global united stance, a sense of security and lack of desire for Military confrontations, Bush has decided to scrap this idea and restock on nuclear arms. Where is the political responsibility and consistency of America going, to be seen to be undoing all the hard work of a previous administration that sent America to it pest political and economical climate for decades, if even hasten to say ever can only be seen as a dictatorship in its own right. George Bush is not smart enough to be president, he lacks in humility, he is not political sound and what's worrying is if he continues to create a global stir someone could effectively try to kill the president. JMC ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Kill the President
I knew someone was going to say that Gary but i wondered who would be the first.! Congratulations! You have won 2 tickets to see S CLUB7 in concert.Lucky Lad. #George_Bush# All the Best Jerry -Original Message- From: Gary Longford [mailto:[EMAIL PROTECTED]] Sent: 18 July 2001 13:08 To: CF-Talk Subject: RE: Kill the President At point I would point out that you shouldn't really put spaces in variables names. Grin :) Gary Longford Senior Web/Database Developer -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 18 July 2001 12:48 To: CF-Talk Subject: RE: Kill the President cfif #George Bush# neq Cold Fusion Developer script alert ('#What the F*** has george Bush gotta do with Cold Fusion anyway?'); /script /cfif Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 18 July 2001 10:43 To: CF-Talk Subject: Kill the President Sorry if I ruffle anyone's feathers here not a CF topic, but I watched the 9 0'clock news last night on BBC 1 and watched an interview with the President of the United States, George Bush. This morning we have all been discussing the future career of this man and we all agree it will probably be short lived if America does realise what they have sitting in the presidential armchair. A man during his Judicial Congress career in Texas, managed to break all records and have more Death Row prisoners put to death by 4 times during his residency. Now as the President of the United States, Bush has made it quite clear he is not interested in the quick turn around to Global warming as is the rest of the World, he has declined to get involved with Northern Ireland after so much hard work with the Clinton Administration, his involvement and stance with the middle east peace process has not been made clear, and the most worrying is that he has decided to set the world back 15 years by re-establishing a Nuclear presence. To quote the President, I have said before to the rest of the world there is no more cold war, but America must protect itself from a rogue dictator What kind of signals is this sending out to the rest of the world, especially China? Its not so long ago only in the job by a few weeks he started to play hard ball against China, when their reconnaissance aircraft was forced to land after infringing Chinese airspace, their plane never recovered and America forced to apologize. Two years ago India and Afghanistan proceeded to test nuclear missiles and America opposed with the rest of Europe intensely, a global united stance, a sense of security and lack of desire for Military confrontations, Bush has decided to scrap this idea and restock on nuclear arms. Where is the political responsibility and consistency of America going, to be seen to be undoing all the hard work of a previous administration that sent America to it pest political and economical climate for decades, if even hasten to say ever can only be seen as a dictatorship in its own right. George Bush is not smart enough to be president, he lacks in humility, he is not political sound and what's worrying is if he continues to create a global stir someone could effectively try to kill the president. JMC ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple Select boxes
Carlo, Why not use the onchange event of the select box1 to submit the form within itself and then use a query to pull out the relevant data for select box2. Kind Regards Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com -Original Message- From: Carlo van Wyk [mailto:[EMAIL PROTECTED]] Sent: 18 July 2001 14:36 To: CF-Talk Subject: Multiple Select boxes Hi I would like to have 2 dropdown select boxes. Both the dropdown boxes' values will be from a database. If you select the first dropdown box, the second dropdown box values will be populated according to the value obtained from the first dropdown box. ie. Select Car Select Model I tried to use an example that uses javascript, but i get problems as these two select boxes will be used inside an existing form. Surely one must be able to do this in coldfusion without javascript - maybe with cflocate? Any examples or help will be appreciated. Regards, Carlo van Wyk ColdFusion Developer SOLVE Consulting [w] www.solve.co.za [c] +27 83 454 3533 [t] +27 21 447 1108 [f] +27 21 447 1128 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Output Field Names
Hi, Does anyone know if there is anyway that you can output the Field names (Column Names) for a specific table in a cfquery?(using access db). Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Javascript Dillema
Hi Could anyone help me with this dillemma,Here goes: Ive got two multiple select boxes(Named List1 and List2) with buttons to transfer values across from List1 to list 2 which works fine.I have also got another multiple select box named Fields within the same form, this is the dillema: When i select a value in List1 i want to submit the form within itself and pass the value of list one (Bu_ID), which then based on the( Bu_id) it will query a table in the data base and pull out details for that (Bu_id) and display the details in the Fields multiple select box. But ther are only 3 events on a select boxonBluronChangeonClick??? A picture Paints a Thousand words so here it is: http://www.biznetprojects.co.uk/CountrySelect.cfm Many Thanks Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascript Dillema
Thanks Stephen ill try that! Cheers Jerry -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 17 July 2001 12:48 To: CF-Talk Subject: RE: Javascript Dillema Jerry, When i select a value in List1 i want to submit the form within itself and pass the value of list one (Bu_ID), which then based on the( Bu_id) it will query a table in the data base and pull out details for that (Bu_id) and display the details in the Fields multiple select box. But ther are only 3 events on a select boxonBluronChangeonClick??? How about making it a part of the function that is run when you click the or buttons to add the country to the list? Stephen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Javascript Function
Hi, Could anyone inform me of any javascript function that takes the total of numbers entered into a textbox and displays them in another? eg form name=form1 Item a = 2 (number in text box) Item b = 3 Item c = 4 Total = 9 (this total is generated by adding the items in the textboxes above) /form Any help will much apreciated Jerry Staple ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: pay rates
Hi, We are a company based in Belfast which specialise in Coldfusion development and also Coldfusion hosting.We have developed similar applications to the one that you have explained,if you would like any advice or costs etc send me an email. Regards Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: 11 July 2001 16:39 To: CF-Talk Subject: pay rates Hi Everyone, I need some advice on the going pay rates for a person working on a Cold Fusion project. I'm going to have a meeting today with some people who want a website that will advertise themselves but will allow their clients to login and view the work in progress on the various projects they've been working on. So, for example, if I am one of these people's clients I can go online and view the look of the brochure they have designed or the copywrite material they have wrote and comment on it right there. Anyway, the application would have a SQL Server backend probably be about 20 pages. I am also going to do the graphic design. I am also going to research a cold fusion ISP for them. Which ones out there are the best in terms of stability and support? So I guess I can divide it into 3 parts: hourly rate for CF developer: hourly rate for Database Developer (or is this included in the CF developer area): hourly rate for an HTML programmer: Hourly rate for a designer: maybe I'm going about it wrong. I don't know I need some guidance so I don't get ripped off. Thank yo so much Sal ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
JavaScript
Hi, Could anyone inform me of any javascript function that takes the total of numbers entered into a textbox and displays them in another? eg form name=form1 Item a = 2 (number in text box) Item b = 3 Item c = 4 Total = 9 (this total is generated by adding the items in the textboxes above) /form Any help will much apreciated Jerry Staple Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Data Validation
Hi, Could anyone inform me of the best javascript function to validate a textbox, so that only a number can be entered. Many Thanks Jerry Staple ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Data Validation
Thanks Very Much. Jerry -Orig inal Message- From: Alistair Davidson [mailto:[EMAIL PROTECTED]] Sent: 05 July 2001 09:12 To: CF-Talk Subject: RE: Data Validation jerry, how about parseFloat() or parseInt(), depending on whether you only want integers? something like function check_numeric( obj ) { // parseInt() returns NaN (Not a Number) // if it can't parse an integer out of the string if( isNaN( obj.value.parseInt() ) ) { alert( That is not a number! ); obj.focus(); return false; } else return true; } and your input box can check this onblur (when it loses focus) like so - input name=numberbox type=text .. onblur=check_numeric(this); or you can check it in the form.onsubmit() - form .. onsubmit=return(check_numeric( numberbox )); A good reference for JS (and VBS) functions can be found at http://msdn.microsoft.com/scripting/default.htm Hope that helps Alistair Davidson Senior Web Developer Rocom New Media http://www.rocomx.net -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 05 July 2001 09:07 To: CF-Talk Subject: Data Validation Hi, Could anyone inform me of the best javascript function to validate a textbox, so that only a number can be entered. Many Thanks Jerry Staple ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Data Validation
Cheers Stephen Thats the Ticket. Cheers Jerry -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 05 July 2001 09:23 To: CF-Talk Subject: RE: Data Validation Jerry, Could anyone inform me of the best javascript function to validate a textbox, so that only a number can be entered. The JS function you are after is : isNaN() Its actually is not a number. So you need to do something like : if (isNaN(document.myform.myfield.value)) { alert(You did not enter a number); return false; } Hope this helps Regards Stephen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Data Validation
Stephen i have used the following function: script language=JavaScript function check_numeric() { if (isNaN(document.forms[0].test.value)) { alert(Please enter a Numeric Value); return false; } else{ return true; } } /script and then the textbox: input type=text name=test align=middle size=10 maxlength=20 value=#Numerical# style=background-color:ccff00; color:44;font-type:arial; onblur=check_numeric(this); However when i enter a numeric value it comes up with the error as well? Could you enlighten me. Many Thanks Jerry -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 05 July 2001 09:23 To: CF-Talk Subject: RE: Data Validation Jerry, Could anyone inform me of the best javascript function to validate a textbox, so that only a number can be entered. The JS function you are after is : isNaN() Its actually is not a number. So you need to do something like : if (isNaN(document.myform.myfield.value)) { alert(You did not enter a number); return false; } Hope this helps Regards Stephen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Data Validation
Hi, Could someone inform me the best Javascript fucntion to check the value of a textbox and to make sure the value entered is a number. Much Apreciated Jerry Staple ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Data Validation
Hi, Could someone inform me the best Javascript fucntion to check the value of a textbox and to make sure the value entered is a number. Much Apreciated Jerry Staple ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Data Validation
Thanks Very Much for that Gary. Kind Regards Jerry -Original Message- From: Gary Longford [mailto:[EMAIL PROTECTED]] Sent: 05 July 2001 15:13 To: CF-Talk Subject: RE: Data Validation Jerry, Here's one I wrote earlier, hope it helps: function CheckIsNumber(objCheck) { var strStartFormat = .+-0123456789; var strNumberFormat = .0123456789; var strCheckChar; var blnDecimal = false; var blnDigits = false; if (objCheck.length == 0) return true; strCheckChar = strStartFormat.indexOf(objCheck.charAt(0)) if (strCheckChar == 0) blnDecimal = true; else if (strCheckChar 0) return false; for (var i = 1; i objCheck.length; i++) { strCheckChar strNumberFormat.indexOf(objCheck.charAt(i)) if (strCheckChar 0) return false; else if (strCheckChar == 0) { if (blnDecimal) // Second decimal. return false; else blnDecimal = true; } else blnDigits = true; } return true; } If you need to go one stage further to integer add this one: function tmo_IsInteger(objCheck) { var strDecimalFormat = .; var strCheckChar; if (objCheck.length == 0) return true; strCheckChar = objCheck.indexOf(strDecimalFormat) if (strCheckChar 1) return CheckIsNumber(objCheck); else return false; } Try that. Gary -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 03 July 2001 09:39 To: CF-Talk Subject: Data Validation Hi, Could someone inform me the best Javascript fucntion to check the value of a textbox and to make sure the value entered is a number. Much Apreciated Jerry Staple ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Purchasing a copy of ColdFusion Server in the UK
We are Resellers of all Macromedia and Allaire products.. Regards Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 04 July 2001 10:51 To: CF-Talk Subject: RE: Purchasing a copy of ColdFusion Server in the UK Anyone know where I can purchase a copy of ColdFusion Server in the UK? http://www.highlander.co.uk Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Data Validation
Greetings I am designing a form that has a numeric field that has to have a number between a Min Max range.I Know about the CFFORM and min max validation,also the dreamweaver validat form behaviour,Are there any Other ways? Regards Jerry Staple Web Applications Developer Biznet Solutions 133 - 137 Lisburn Road Belfast BT9 7AG www.biznet-solutions.com [EMAIL PROTECTED] Tel: +44 (0)28 90205652 Fax: +44 (0)28 9022 3223 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
White Space
Hi Could anyone tell me the Best way to strip out white space from a string?? Much Appreciated Jerry Staple Web Applications Developer Biznet Solutions 133 - 137 Lisburn Road Belfast BT9 7AG www.biznet-solutions.com [EMAIL PROTECTED] Tel: +44 (0)28 90205652 Fax: +44 (0)28 9022 3223 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: White Space
Hi Dick Ive tried the following code but to no avail: cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)# cfset Questions = ReReplace(#OutputList.Question#, [#White#]+, , All) td height=10 width=25% background=white-rect.gif div align=centerfont face=Arial, Helvetica, sans-serif size=2font color=Blacknowrapb#Questions#/b/div /td Any Ideas Cheers Jerry -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 10 June 2001 11:19 To: CF-Talk Subject: Re: White Space Oops, you said white space, not space! try cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)# cfset string = ReReplace(String, [#White#]+, , All) cfset string = ReReplace(String, +, , All) HTH Dick At 10:15 AM +0100 6/10/01, Jerry Staple wrote: Hi Could anyone tell me the Best way to strip out white space from a string?? Much Appreciated Jerry Staple ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: White Space
Hi Dick Ive tried the following code but to no avail: cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)# cfset Questions = ReReplace(#OutputList.Question#, [#White#]+, , All) td height=10 width=25% background=white-rect.gif div align=centerfont face=Arial, Helvetica, sans-serif size=2font color=Blacknowrapb#Questions#/b/div /td IE The question Output will be somrething Like Service Company in ordewr to insert into a database i would like to replace with either ServiceCompany or Service_Company Any Ideas Cheers Jerry -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 10 June 2001 11:19 To: CF-Talk Subject: Re: White Space Oops, you said white space, not space! try cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)# cfset string = ReReplace(String, [#White#]+, , All) cfset string = ReReplace(String, +, , All) HTH Dick At 10:15 AM +0100 6/10/01, Jerry Staple wrote: Hi Could anyone tell me the Best way to strip out white space from a string?? Much Appreciated Jerry Staple ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: White Space
Dick Thats Just The Ticket! Thanks Very Much All the Best Jerry -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 10 June 2001 12:35 To: CF-Talk Subject: RE: White Space Try cfset White = #Chr(9)##Chr(10)##Chr(11)##Chr(12)##Chr(13)# cfset Questions = ReReplace(#OutputList.Question#, [ #white#]*, ,All) This will remove all spaces and white space. Better for db insertion would be: cfset Questions = ReReplaceNoCase(#OutputList.Question#, [^0-9A-Z_]*, ,All) which kills all punctuation except the underscore. HTH Dick At 11:42 AM +0100 6/10/01, Jerry Staple wrote: Hi Dick Ive tried the following code but to no avail: cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)# cfset Questions = ReReplace(#OutputList.Question#, [#White#]+, , All) td height=10 width=25% background=white-rect.gif div align=centerfont face=Arial, Helvetica, sans-serif size=2font color=Blacknowrapb#Questions#/b/div /td IE The question Output will be somrething Like Service Company in ordewr to insert into a database i would like to replace with either ServiceCompany or Service_Company Any Ideas Cheers Jerry -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 10 June 2001 11:19 To: CF-Talk Subject: Re: White Space Oops, you said white space, not space! try cfset White = #Chr(9)##Chr(10)##Chr(13)##Chr(32)# cfset string = ReReplace(String, [#White#]+, , All) cfset string = ReReplace(String, +, , All) HTH Dick At 10:15 AM +0100 6/10/01, Jerry Staple wrote: Hi Could anyone tell me the Best way to strip out white space from a string?? Much Appreciated Jerry Staple ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Order by: Access 2000 Question
Hi How do i go about setting up the CFGRAPH tag from scratch ??? Regards Jerry -Original Message- From: Ann Harrell [mailto:[EMAIL PROTECTED]] Sent: 06 June 2001 06:18 To: CF-Talk Subject: RE: Order by: Access 2000 Question Thaks! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 11:56 PM To: CF-Talk Subject: Re: Order by: Access 2000 Question That's because Statecount is not a *real* column. If you change it to ORDER BY 2 or ORDER BY Count(State) you should be OK. Ann Harrell [EMAIL PROTECTED] on 06-06-2001 02:26:33 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: Order by: Access 2000 Question I have a graph that uses a Access 2000 query. You can see it at the link. It won't let me ORDER BY StateCount Here is the error if I add Order by Statecount after group by: Error Diagnostic Information ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly. SQL = SELECT state, COUNT (state) AS StateCount FROM Wobinfo GROUP BY state Order by StateCount Data Source = WOBBERSMET The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (3:50) in the template file C:\INETPUB\WWWROOT\WOB\STATEDATA.CFM. http://ann.bourbon.hoosierlink.net/Wob/StateData.cfm cfquery name=GetStates datasource=WobbersMet SELECT state, COUNT (state) AS StateCount FROM Wobinfo GROUP BY state /cfquery CFGRAPH TYPE=BAR QUERY=GetStates VALUECOLUMN=StateCount ITEMCOLUMN=State SHOWVALUELABEL=Yes VALUELOCATION=ON BAR SCALEFROM=0 SCALETO=10 TITLE=Wobbers By State FILEFORMAT=Flash GRAPHHEIGHT=500 GRAPHWIDTH=700 BACKGROUNDCOLOR=white DEPTH=10 COLORLIST=red,green,blue,yellow,orange, fuchsia, teal, Lime GRIDLINES=4 /cfgraph /body /html Ann Harrell Harrell Computer Enterprises Phone: 219.342.0618 eFax: 603.843.9212 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Newbie-CF trying to process Hex numbers :-)
Try this Take the hash out of all the hex numbers ie #ccff00 change to either ccff00 or place another hash in front ##ccff00. Hope this helps Jerry Staple -Original Message- From: Gina K. Anderson [mailto:[EMAIL PROTECTED]] Sent: 30 May 2001 20:20 To: CF-Talk Subject: Newbie-CF trying to process Hex numbers :-) Hi all, Have been learning CF, and going through the book ColdFusion 4.0 Web Application Construction Kit. Short story is I got bored with white background and black text, and started doing my own app instead of the example in the book, using background colors, text colors, and CSS, etc. Okay, now I have a problem ;) CF is trying to process my hex numbers, and I can't figure out how to fix it. I am trying to update records, using #Trim(ColumnName)#. My code can be found here: http://www.sitediva.com/code.txt When I passed the ContactID to this page through a link on another page, I got this error: - Error Diagnostic Information Just in time compilation error Invalid parser construct found on line 38 at position 23. ColdFusion was looking at the following text: Invalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was static text occupying document position (29:28) to (38:15). The specific sequence of files included or processed is: C:\AddressBook\update_biz_form.cfm --- So I go to the line, and it's the body bgcolor=#FF text=#00 tag, the after the first hex number. I stripped out the hex numbers, then it gets stuck on the next one, tr bgcolor=#99 ... I can't find anything in the book that talks about this, can anyone help? Thanks, Gina ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do I stop users going back after logging out
Try This On your log out button or whatever send it to a page which kills the session and then redirects them wherever: Paste this on your linked page cfscript StructClear(session); /cfscript cfscript StructClear(application); /cfscript cflocation url=Wherever.cfm Good Luck Jerry -Original Message- From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]] Sent: 31 May 2001 08:11 To: CF-Talk Subject: How do I stop users going back after logging out When A user logs out of my application they can still press the back button to view the pages of my application how can I prevent this? Webmaster Rule Number One: When a potential employer/client asks you if you've ever worked with XYZ software running on platform ABC, say yes quickly and with great assurance. Then run home, fire up the Net, and figure out what the hell they were talking about * -Original Message- * From: John Lucas [mailto:[EMAIL PROTECTED]] * Sent: Thursday, May 31, 2001 4:04 AM * To: CF-Talk * Subject: RE: Newbie-CF trying to process Hex numbers :-) * * * Sorry, I guess I should have been more clear * * #something# is ok. * * #FF is not ok. * ##FF is ok * FFF is ok * * -Original Message- * From: Gina K. Anderson [mailto:[EMAIL PROTECTED]] * Sent: Wednesday, May 30, 2001 2:20 PM * To: CF-Talk * Subject: Newbie-CF trying to process Hex numbers :-) * * * Hi all, * * Have been learning CF, and going through the book ColdFusion 4.0 Web * Application * Construction Kit. Short story is I got bored with white * background and black * text, and started doing my own app instead of the example in the * book, using * background colors, text colors, and CSS, etc. * * Okay, now I have a problem ;) CF is trying to process my hex * numbers, and I * can't figure out how to fix it. I am trying to update records, using * #Trim(ColumnName)#. My code can be found here: * * http://www.sitediva.com/code.txt * * When I passed the ContactID to this page through a link on another page, I * got * this error: * * - * Error Diagnostic Information * Just in time compilation error * * Invalid parser construct found on line 38 at position 23. ColdFusion was * looking * at the following text: * * * Invalid expression format. The usual cause is an error in the expression * structure. * The last successfully parsed CFML construct was static text occupying * document * position (29:28) to (38:15). * * The specific sequence of files included or processed is: * C:\AddressBook\update_biz_form.cfm * --- * * So I go to the line, and it's the body bgcolor=#FF text=#00 * tag, * the after the first hex number. I stripped out the hex numbers, then it * gets * stuck on the next one, tr bgcolor=#99 ... * * I can't find anything in the book that talks about this, can anyone help? * * Thanks, * Gina * ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do I stop users going back after logging out
Try This Paste in the top of the page CFHEADER Name=Expires Value=#Now()# CFHEADER NAME=pragma VALUE=no-cache Good Luck Jerry Staple -Original Message- From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]] Sent: 31 May 2001 13:10 To: CF-Talk Subject: RE: How do I stop users going back after logging out Exactly know hoa I can achieve that in CF? Webmaster Rule Number One: When a potential employer/client asks you if you've ever worked with XYZ software running on platform ABC, say yes quickly and with great assurance. Then run home, fire up the Net, and figure out what the hell they were talking about * -Original Message- * From: Tony Schreiber [mailto:[EMAIL PROTECTED]] * Sent: Thursday, May 31, 2001 2:37 PM * To: CF-Talk * Subject: Re: How do I stop users going back after logging out * * * I think what you want is content that expires as soon as it's set. This * drives me nuts on some sites. As soon as I hit back - This Page Has * Expired. Ug! * * When A user logs out of my application they can still press the * back button * to view the pages of my application how can I prevent this? * * Webmaster Rule Number One: * When a potential employer/client asks you if you've ever worked with XYZ * software running on platform ABC, say yes quickly and with great * assurance. Then run home, fire up the Net, and figure out what * the hell they * were talking about * * * * -Original Message- * * From: John Lucas [mailto:[EMAIL PROTECTED]] * * Sent: Thursday, May 31, 2001 4:04 AM * * To: CF-Talk * * Subject: RE: Newbie-CF trying to process Hex numbers :-) * * * * * * Sorry, I guess I should have been more clear * * * * #something# is ok. * * * * #FF is not ok. * * ##FF is ok * * FFF is ok * * * * -Original Message- * * From: Gina K. Anderson [mailto:[EMAIL PROTECTED]] * * Sent: Wednesday, May 30, 2001 2:20 PM * * To: CF-Talk * * Subject: Newbie-CF trying to process Hex numbers :-) * * * * * * Hi all, * * * * Have been learning CF, and going through the book ColdFusion 4.0 Web * * Application * * Construction Kit. Short story is I got bored with white * * background and black * * text, and started doing my own app instead of the example in the * * book, using * * background colors, text colors, and CSS, etc. * * * * Okay, now I have a problem ;) CF is trying to process my hex * * numbers, and I * * can't figure out how to fix it. I am trying to update records, using * * #Trim(ColumnName)#. My code can be found here: * * * * http://www.sitediva.com/code.txt * * * * When I passed the ContactID to this page through a link on * another page, I * * got * * this error: * * * * - * * Error Diagnostic Information * * Just in time compilation error * * * * Invalid parser construct found on line 38 at position 23. * ColdFusion was * * looking * * at the following text: * * * * * * Invalid expression format. The usual cause is an error in the * expression * * structure. * * The last successfully parsed CFML construct was static text occupying * * document * * position (29:28) to (38:15). * * * * The specific sequence of files included or processed is: * * C:\AddressBook\update_biz_form.cfm * * --- * * * * So I go to the line, and it's the body bgcolor=#FF * text=#00 * * tag, * * the after the first hex number. I stripped out the hex * numbers, then it * * gets * * stuck on the next one, tr bgcolor=#99 ... * * * * I can't find anything in the book that talks about this, can * anyone help? * * * * Thanks, * * Gina * * * * ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Logon Attempts
Could anyone inform tell me what would be the best way to implement a logon page where the user gets 3 attempts to logon,after the 3 attempts the user is directed elsewhere.I have tried setting a variable on the application page then adding +1 when it goes to the Logon_Action.cfm but to no avail. Help Regards Jerry Staple Web Applications Developer Biznet Solutions 133 - 137 Lisburn Road Belfast BT9 7AG www.biznet-solutions.com Tel: +44 (0)28 90205652 Fax: +44 (0)28 9022 3223 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Logon Attempts
Cheers Jerry Staple -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: 29 May 2001 10:39 To: CF-Talk Subject: RE: Logon Attempts Try putting this in the top of your template. Make sure your session variables are turned on in the application.cfm file. cfparam name=session.login_attempts default=0 cfset session.login_attempts=session.login_attempts+1 cfif session.login_attempts gt 3 cflocation url = whatever.cfm /cfif Mark Warrick - Fusioneers.com Email: [EMAIL PROTECTED] Phone: 714-547-5386 http://www.fusioneers.com http://www.warrick.net === -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 12:36 AM To: CF-Talk Subject: Logon Attempts Could anyone inform tell me what would be the best way to implement a logon page where the user gets 3 attempts to logon,after the 3 attempts the user is directed elsewhere.I have tried setting a variable on the application page then adding +1 when it goes to the Logon_Action.cfm but to no avail. Help Regards Jerry Staple Web Applications Developer Biznet Solutions 133 - 137 Lisburn Road Belfast BT9 7AG www.biznet-solutions.com Tel: +44 (0)28 90205652 Fax: +44 (0)28 9022 3223 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists