RE: SQL regex select
Yes, in MSSQL Select * from myTable where myColumn like '[a-z]iger' so you can build up regular expresions like that, Jason Lees Development Team Leader National Express. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: 24 September 2003 14:27 To: CF-Talk Subject: SQL regex select I have an application where I want to select rows from a table where the rows match according to a simple regex. For example, say I have the word "tiger" - I would want to select rows with values like: t* * ? tiger t??er Is this possible? Thanks, Howie ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138272 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: re"
You dont say what DB to use, but with MSSQL I suppose you could have a look up of invalid entries in another SQL table so that your query reads INSERT INTO strfields ( var, destination ) VALUES ( , ) where not in (select Prohibited from ProhibitedTable) Table ProhibitedTable is defined as create table [ProhibitedTable { WordID int not null] Prohibited varchar (25) } Then if you make WordId a Prinary key, and auto increment this should solve the problem. It may need some fine tuning but should work. this also save you having to hard code each prohibited word, and also will allow in definate expansion, Jason Lees Development Team Leader National Express. -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 18 September 2003 15:36 To: CF-Talk Subject: re" INSERT INTO strfields ( var, destination ) VALUES ( , ) ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137494 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: [OT] ShittyCode.Com (Launched new site last night, feedback p lease!)
Just remember - one mans cr*p is anothers gold I have to agree with the comments made by Micheal and Calvin. As for some of the examples, they are not so much sh*t code, more like lack of knowledge, besides we've all dont things like espcially when switching between several development languages & environments. PS - as for sh*t the auto page reload is totally superflous, good job your not on a slow dialup connection when viewing this site as you'd nver get to see the page Jason Lees Development Team Leader National Express. -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: 11 September 2003 09:26 To: CF-Talk Subject: Re: [OT] ShittyCode.Com (Launched new site last night, feedback please!) I agree with Michael completely. And in fact, this isn't something I need to let be appearing in my browser or email client at work, we do have clients walk through our building fairly often. It's flat out unprofessional sounding and doesn't belong in this forum. - Calvni - Original Message - From: "Michael Dinowitz" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 10, 2003 4:00 PM Subject: Re: [OT] ShittyCode.Com (Launched new site last night, feedback please!) > Well, let me see: > 1. I think the name just sucks. If your trying to make a positive statement of > proper code use, a name of that sort will turn off many of those who need such a > statement. > 2. Site reviews and such are something for CF-OT or CF-Community. Talking about > good code concepts would fit here, but that's not what your doing. > 3. You can't run such a site without constant editorial review. > 4. Your examples are rather off. Take the one about pound signs. The usage of > them are subjective in the case you gave and the use of queryname. in the CFIF > is not representative of the initial example (which would have to be inside a > CFOUTPUT or CFLOOP to access the query object. I could go on, but the point is > made. > Bad code is subjective in many cases. Indentation, use of pounds, use of > CFSCRIPT vs. CFTags, etc. are all based on personal use. If I use > function test() > { > return 1 > } > and someone else says that > function test(){ > return 1 > } > is the right way, we're not talking bad code, we're talking code religion. > 5. Religion is NOT ON TOPIC for this list. > > > Last night, I launched a new site, it can be seen at: > > > > http://www.shittycode.com > > > > I wanted to see if I could get some feedback on the site, the concept, and > maybe even the name! :) > > > > Thanks, > > Pablo Varando > > http://www.easycfm.com > > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Anyone going to MAX in November?
anyone have any details on this please, As I'd be interested to go. Jason Lees Development Team Leader National Express. -Original Message- From: Cathy Taylor [mailto:[EMAIL PROTECTED] Sent: 09 September 2003 15:09 To: CF-Talk Subject: Anyone going to MAX in November? I'm probably going too, though it sure is far away (when will they have it in DC again??). I'm waiting for my time to be approved by my client (I'll pony up the rest). I'm also hoping there's snow so I can fit in some skiing without the fam along (one advantage to traveling to the conference - a week ALONE in a hotel!! Woohoo!). Cathy >I'll probably be going. I'm really not excited about the location, but the >new MX2004 was pretty much the deciding factor for me. > >-Kevin > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: sql question
I think this should work, select Id,count(Id) from mytable group by Id having count(id)>1 It will also show you how many of each Id's you have, you can naturally add a where clause if you want. Jason Lees Development Team Leader National Express. -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: 19 August 2003 15:10 To: CF-Talk Subject: sql question i would like to write a sql query that can find where a certain 'id' has a duplicate. i don't want to see the ids where there is only one instance of it. (for example, show me 20010001 if there are 2 of them in the db, and don't show me 20010002 if there is only one of them in the db). anyone have any suggestions? thanks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Auto generate form fields problem...
I believe this may work, as I do somethink simular with parsing through dynamic Form variables. Jason Lees Development Team Leader National Express. -Original Message- From: Bruce H. Beinert [mailto:[EMAIL PROTECTED] Sent: 31 July 2003 08:52 To: CF-Talk Subject: Auto generate form fields problem... Hi, I am trying to auto generate form fields and can't seem to get the last part right. I want to set the value of the input box as the variable but can't figure out how to do it... Obviously what happens is the value is set to "call_letters_1" instead what I want which is #call_letters_1# I have tried a bunch of different things none of which work and just throw errors. Any ideas??? Thanks! #i#. -- Bruce H. Beinert p.808-637-0727<>m.917-627-4035 Web Development and Consulting: http://www.siliconmaui.com Weblog: http://www.bruceandwende.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX & .Net Remoting
All, Has anyone used .Net remoting with CFMX, and is it possible? If you have any experience can you pass on any helpfull tips for accessing and creating the objects TIA Jason Lees Development Team Leader National Express. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: numbers too big
No specific proof, but thinking about it logially International dialing allow 4 for Expansion (there aer some 3 digit codes), For Regional Exchanges allow 4 digits ( Regions), Local Exchanges allow 4 digits, that leaves you five digits spare for individual phones. That would give you countries, Regions/Country, Local Exchanges 9 Phones/Exchange. Therefore you could use a bigint (64 bit number) to hold the data. Personally I think these numbers allow for quite a large range. Jason Lees Development Team Leader National Express. -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED] Sent: 13 June 2003 15:57 To: CF-Talk Subject: Re: numbers too big Can you confirm this? I would need hard proof. I appreciate the insight however. Mike - Original Message - From: "Jason Lees (National Express)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 10:48 AM Subject: RE: numbers too big > Why 30 digits?, I'm not aware of any numbers of greater than 20 digits, even > with the International diaing code. > > Jason Lees > Development Team Leader > National Express. > > > -Original Message- > From: Michael Tangorre [mailto:[EMAIL PROTECTED] > Sent: 13 June 2003 15:25 > To: CF-Talk > Subject: numbers too big > > > I have some really large number ranges that I need to store in a SQL Server > 2K DB. > > The numbers are of the following size: > > range start > 00 > > range end > 99 > > That was one generic example. Basically the number represents a phone number > range and I have a range for each country in the world that has telephone > service. What would be the best way to store it these ranges so that I can > run a query that says, select country name where #phoneNumber# is within > the range. > > I tried inporting the values in as bigints.. no dice, by the way this info > is coming in from an excel sheet. > > > Thanks, > > Michael Tangorre > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: numbers too big
Why 30 digits?, I'm not aware of any numbers of greater than 20 digits, even with the International diaing code. Jason Lees Development Team Leader National Express. -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED] Sent: 13 June 2003 15:25 To: CF-Talk Subject: numbers too big I have some really large number ranges that I need to store in a SQL Server 2K DB. The numbers are of the following size: range start 00 range end 99 That was one generic example. Basically the number represents a phone number range and I have a range for each country in the world that has telephone service. What would be the best way to store it these ranges so that I can run a query that says, select country name where #phoneNumber# is within the range. I tried inporting the values in as bigints.. no dice, by the way this info is coming in from an excel sheet. Thanks, Michael Tangorre ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: TSQL Script to replicate a db?
You could use the Scripting wizard in the Enterprise manager. To do this Select the DB right click, and select Script DB, this gives you the necessary wizard to get everything, SP's, tables, Indexes etc. Jason Lees Development Team Leader National Express Systems. -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] Sent: 18 March 2003 14:47 To: CF-Talk Subject: TSQL Script to replicate a db? Hi All, I have a SQL2K db in a shared hosting environment at CFDynamics.com. Each time I need to duplicate the db (intranet db) for my clients I just use the export tool and export it to another client's db. The problem is that each time I do this I have to go back and set up the autonumber fields on every single table which takes a long time. Does anyone know of a way to take my existing db and use a wizard to create either a stored procedure or a bunch of sql statements that will recreate all of the tables and relationships of my db? Thanks, Jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MSDE on Office XP CD - where is Enterprise Manager?
I didnt get it from anywhere, It was part of the installation. What type of install did you do? >From what I can remember theres three option, Client Tools only, DB & Client Tools, or DB Only. If you didnt install the tools option that might be the reason. Jason Lees Development Team Leader National Express Systems. -Original Message- From: Nick de Voil [mailto:[EMAIL PROTECTED] Sent: 18 March 2003 09:07 To: CF-Talk Subject: Re: MSDE on Office XP CD - where is Enterprise Manager? Thanks Jason. So - stupid question - that means you have a file called "C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC" ? I don't. Where did you get it from? Nick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: MSDE on Office XP CD - where is Enterprise Manager?
This is the Short cut I use to start EM C:\WINNT\SYSTEM32\MMC.EXE /s "C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC" Jason Lees Development Team Leader National Express Systems. -Original Message- From: Nick de Voil [mailto:[EMAIL PROTECTED] Sent: 18 March 2003 08:44 To: CF-Talk Subject: Re: MSDE on Office XP CD - where is Enterprise Manager? > It had one on Windows 98. Well, let me rephrase that. I have MSDE on my W98 machine and also EM, and if EM isn't part of MSDE where did I get it I wonder... don't remember. Using isql for development is fine for a manly man like me ;-) but also I wanted to use EM to administer a remote SQL Server DB, which would be rather painful with isql, if indeed it's possible. What should I use instead? Any suggestions? Nick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: Using createUUID()
Heres a URL on how the UUID is defined http://www.dsps.net/uuid.html (the Colour coding leaves something to be desired but...) Just glancing at the document suggests that this will be a unique number, as it uses the Mac address of the PC to generate it. there are 3.4028236692093846346337460743177e+38 combinations (2^128). Jason Lees Development Team Leader National Express Systems. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:51 To: CF-Talk Subject: RE: Using createUUID() Ignore my last post...ASCII has more than 36 characters...the point still holds though. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:48 To: CF-Talk Subject: RE: Using createUUID() If you only use 4 characters then there are only roughly (10+26) to the power of 4 = 1679616 different combinations... this is a relatively low number which may or may not be considered unique enough for your purposes. With only 100,000 records you already have nearly a 6% chance of a collision. André -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:34 To: CF-Talk Subject: RE: Using createUUID() not sure what the odds could be : its not 1 in a thousand, I see your point, but in this instance, just include more chars or add your own rand function... though, Rand again but definition is not 'unique', there is a chance you could get the same ID. N -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() but not the first four...the whole uuid in and of itself, would be, however, you could conceivably get the same striking everything but the first four ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. "AFAIK" -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),"mmdd")##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
The point of a UUID is not to use the first four characters, but to use the whole ID Jason Lees Development Team Leader National Express Systems. -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() Ok , run Mid(CreateUUID(),1,4) a few times and see what you get. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. "AFAIK" -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),"mmdd")##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JS problem
Can't you just use if ((isNan(myField.value)) || myField.Value==0){ window.alert("- The Quantity you entered is invalid"); myField.Focus(); return false; } else return true; Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: 06 March 2003 14:58 To: CF-Talk Subject: JS problem To clarify my earlier post. This is what I've been trying to no avail function CheckCartQty(myField) { var ErrMsg = ""; // Validate that the Quantities in the Cart are numbers if ((isNan(document.CartForm.myField.value)) || (document.CartForm.myField.value == 0)) { ErrMsg = ErrMsg + "- The Quantity you entered is invalid\n"; } if (ErrMsg.length > 0) { window.alert(ErrMsg); document.CartForm.myField.focus(); return false; } else { return true; } } RE: I am calling a function onBlur of a text field... to validate that the text entered is a number... of course... this list of text fields is being generated dynamically... (shopping cart quantities). If I pass a parameter, like so, CheckQty(someFieldName) how do I check that in the function... Like so, document.CartForm.PARAMETER.value ,it wont let me use the name of the parameter... do I have to build a string or something? Emmet ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: CFMX 100% utilization
Sorry, we're a bit rushed switching back to the old production server. webserver - IIS DB - MSSQL 2K, SP3 with the Generic Windows ODBC drivers. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: 05 March 2003 10:24 To: CF-Talk Subject: Re: CFMX 100% utilization On Wednesday, Mar 5, 2003, at 02:02 US/Pacific, Jason Lees (National Express) wrote: > We've just moved a development website over to the production server. > > The problem is that after about 2 hours, the production server just > went > keeled over with 100% CPU. This didnt happen on the development server What web server / version? What database / version / drivers? Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX 100% utilization
All, We've just moved a development website over to the production server. The problem is that after about 2 hours, the production server just went keeled over with 100% CPU. This didnt happen on the development server The production server win 2K, twin Xeon processor, with hyper threading. Any one any Ideas? TIA. Jason Lees Development Team Leader National Express Coaches Ltd. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: Strange characters after MX upgrade
Thats what I would assume. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Phillip Cave [mailto:[EMAIL PROTECTED] Sent: 28 February 2003 14:52 To: CF-Talk Subject: RE: Strange characters after MX upgrade Thanks. It's the first one under SQL Server-Specific Issues. But, doesn't this mean it's supposed to be fixed in updater 2? Phillip -Original Message----- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 9:35 AM To: CF-Talk Subject: RE: Strange characters after MX upgrade There are several prbolems with CFMX and DB's, the simplest way is for you to check the following URL for a list of Known Issues, http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx _updater.html#newissues Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Phillip Cave [mailto:[EMAIL PROTECTED] Sent: 28 February 2003 14:30 To: CF-Talk Subject: Strange characters after MX upgrade Has anyone experienced problems with inserting and updating nText fields after upgrading to CFMX. We have a system that worked fine until the upgrade. Now the system will sometimes (and I mean randomly) insert chr(25) 'end of medium' characters where apostrophes are supposed to be. The queries are quite simple. Insert or update . Eweb v2.6.0.6 is used for the form control by the way. Before and after examples are below (notice It's and I'm): Before: Thank you, Mr. President, and Mr. Vice President, for inviting me here today. It's good to know that you both are working hard and using your leadership to strengthen Social Security. I'm from Oklahoma City, and am currently a Junior at Howard, an historically black university here in Washington, DC. After: Thank you, Mr. President, and Mr. Vice President, for inviting me here today. Its good to know that you both are working hard and using your leadership to strengthen Social Security. Im from Oklahoma City, and am currently a Junior at Howard, an historically black university here in Washington, DC. Thanks, Phillip Phillip Cave ColdFusion Developer Carol/Trevelyan Strategy Group 202.448.5212 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: Strange characters after MX upgrade
There are several prbolems with CFMX and DB's, the simplest way is for you to check the following URL for a list of Known Issues, http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx _updater.html#newissues Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Phillip Cave [mailto:[EMAIL PROTECTED] Sent: 28 February 2003 14:30 To: CF-Talk Subject: Strange characters after MX upgrade Has anyone experienced problems with inserting and updating nText fields after upgrading to CFMX. We have a system that worked fine until the upgrade. Now the system will sometimes (and I mean randomly) insert chr(25) 'end of medium' characters where apostrophes are supposed to be. The queries are quite simple. Insert or update . Eweb v2.6.0.6 is used for the form control by the way. Before and after examples are below (notice It's and I'm): Before: Thank you, Mr. President, and Mr. Vice President, for inviting me here today. It's good to know that you both are working hard and using your leadership to strengthen Social Security. I'm from Oklahoma City, and am currently a Junior at Howard, an historically black university here in Washington, DC. After: Thank you, Mr. President, and Mr. Vice President, for inviting me here today. Its good to know that you both are working hard and using your leadership to strengthen Social Security. Im from Oklahoma City, and am currently a Junior at Howard, an historically black university here in Washington, DC. Thanks, Phillip Phillip Cave ColdFusion Developer Carol/Trevelyan Strategy Group 202.448.5212 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX behaving Strangely
A couple of days ago I got this error (unable to load library null). It's when we try to do the 1 second waits when we are waiting for a Smartnet reply - we call a C++ cfx library functon. I had to resurrect cfadmin support on webserver4 (which had been lost for no known reason). I reset everything, reimported the library, stopped and restarted CF and all was then fine. One thing to note, though, is that I've yet to stop CF MX cleanly using 'services' - it has always come up with an error 1053 - the service did not respond in a timely fashion. However, it seems to restart ok after a 1053. I just got the null library error again when trying to run enq3. This time cfadmin was fine; I checked the cfx settings, everything was fine. I stopped CF (got error 1053) restarted it and now enq3 works. Conclusion, CF MX was stuffed and had corrupted the link to this permanently loaded library. I'm not aware of any peculiar errors happening recently. We're getting plenty of syntax errors and such, but nothing low level (I've checked the logs) that I can see. One other worrying feature is something I've not noticed when I use IE 5.0, and I'm going backwards and forwards through enquiries and bookings like a demon. Quite often - 2 or 3 times a day - I will get an IE lock and it almost always seems to be when I click on 'back' (browser button, not our back button). I deliberately left one like this overnight, and it did not recover. Task manager reports it as 'not responding' and I have to end task. If anyone has any time to spare I'd be grateful if they could check out the macromedia website and see if there are any known CF MX issues and any issued patches. Many Thanks in Advance PS - we're using OS - Win2k Server, Jason Lees Development Team Leader National Express Coaches Ltd. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: BlueDragon for .NET (was: CF - PHP comparisons?)
I was thinking the same thing. It'll save having .Net Webservices etc, I also hope it might Open up full COM+ transactions etc. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: 14 February 2003 15:32 To: CF-Talk Subject: RE: BlueDragon for .NET (was: CF - PHP comparisons?) Wow - I'm looking forward to seeing it. I would love to have some of the classes I use in .NET available to CFML. Think about the ease of report generation using Crystal Reports.NET with BD.NET. Easy report generation was a major factor in switching to .NET. I love to use CFML as well, so this is the best of both worlds. Will I be able to write BD.NET in Visual Studio (with intellisense, help files, etc.)? Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Vince Bonfanti [mailto:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 9:55 AM To: CF-Talk Subject: RE: BlueDragon for .NET (was: CF - PHP comparisons?) BlueDragon for .NET is coded to the standard .NET Framework APIs (just as BlueDragon for J2EE is coded to standard Java APIs). It's not a re-implementation of the .NET Framework (which Microsoft's patents are intended to prevent), but requires that the .NET Framework be installed in order to use it (which Microsoft will like, because it means you have to buy Windows to run BlueDragon for .NET). So no impact on BlueDragon at all. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com > -Original Message- > From: Ken Wilson [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 14, 2003 9:40 AM > To: CF-Talk > Subject: RE: CF - PHP comparisons? > > > Vince, > > Have you had opportunity yet to review/consider the > implications of Microsoft's patent efforts on .NET and how > they will impact BlueDragon for .NET? Just curious what your > take on all that is. > > Ken > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF - PHP comparisons?
Where can I find out more about Bluedragon? Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Vince Bonfanti [mailto:[EMAIL PROTECTED]] Sent: 14 February 2003 14:20 To: CF-Talk Subject: RE: CF - PHP comparisons? Hi Mike, I tend to agree with your comments regarding the "richness" of PHP. If you do a straight comparison of PHP and CFML's built-in functions then they seem pretty equal. However, one thing that's changed in the CFML world with the introduction of CFMX and BlueDragon is that you now have seamless access to the full set of Java APIs from CFML. With the release of BlueDragon for .NET you'll similarly have seamless access to the full .NET Framework (APIs) from within CFML. In effect, the set of CFML functions is being expanded to include all of the Java APIs or all of the .NET APIs, depending on which platform you prefer. It seems to me that since PHP is not built on either of the two major "platform" technologies (Java or .NET), it's "richness" is going to suffer in comparison as CFML developers learn to take advantage of the integration with Java and .NET. Also, look at the way CFMX leveraged the Java platform to implement web services support (via Apache Axis). PHP is not going to be able to take advantage of the underlying platform technology the way CFMX did; instead they're going to have to implement their own solution "from scratch". It seems to me that this will be a major disadvantage of PHP. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com > -Original Message- > From: Mike Alberts [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 14, 2003 3:33 AM > To: CF-Talk > Subject: CF - PHP comparisons? > > > Since I develop with both CF and php, I guess I'll add my .02... > > Also respectfully to you Dave, this is NOT a terrible > comparison. With the exception of the part about user defined > functions, the comparison seems pretty valid to me, even > though it is quite old. > > In addition, php has made great strides in the last couple of > years: There are at least 3 very good IDE's for php (Zend > Studio, Nusphere PhpEd and Activestate Komodo), as well as > some decent simple code editors (php coder/Maguma Studio, etc. > > Zend has done some other great things for php, like code > encryption, acceleration, caching, etc. Granted these > products are not free, but their new 'Small Business Program' > lets you get all of that stuff with the IDE for a $295 > lifetime payment. This is an absolute bargain. > > Now I still love the CF language, and it's what I prefer to > code in, for its ability to let me get projects done quickly. > But over the years of using CF I've developed my own > 'methodology', that implements the Application Framework, as > well as some other ways of doing things that are sort of like > Fusebox (only simpler). I've personally found that I can use > this same framework in php as well, and the only thing that > changes is the syntax of the language. Many things in php > (switch/case for example) are almost identical in both > languages (using the CF version with cfscript tags of course). > > And don't think that php isn't 'rich'. More than once I've > sat down to write a function in php and realized part way > through that there was already a built in function to > accomplish the task. > > To me, it all boils down to what Sean said both > languages have their strengths and weaknesses. Use the right > tool for the task at hand. I'm not even going to comment on > ASP (ugh), but php is a fine tool in its own right and even > though it does take longer to develop with than CF (for me), > it still allows me to do some cool stuff for clients, which > makes them (and me) happy. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: Proper SQL statements
Use a strored procedure to do both jobs, Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: 06 February 2003 15:23 To: CF-Talk Subject: Proper SQL statements Is there a better more efficient way of writing these 2 queries such as combining them into a single query? I will eventually convert it into a stored procedure. SELECT COUNT(*) AS RecsAvailable FROM tbl_reports_FlapList DELETE FROM tbl_reports_FlapList WHERE FlapListID IN (SELECT FlapListID FROM tbl_reports_FlapList) Regards, Dave Bosky Sr. Multimedia Web Designer Horry Telephone Cooperative, Inc. office: (843)369-8613 [EMAIL PROTECTED] HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX & .NET
I have them both runing on the same PC, although its my main development PC. so I dont know how it would react on a Win2k Server etc. And I've not seen any so far. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: 05 February 2003 15:00 To: CF-Talk Subject: CFMX & .NET I know there is an enormous anti-MS sentiment here, but I'm curious is anyone as installed the .NET framework on the same box running CFMX. If so, how was performance affected? I've always done one or the other, but I'm thinking of combining them both, although I can foresee conflict out the arse. Any thoughts? War stories? Recommendations? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Logins and Users Logged In
To update the on login DB I think the SQL is update usersetup set logged_in=1 where Username = '#Session.Username#' and on logout update usersetup set logged_in=0 where Username = '#Session.Username#' This assumes that you dont have users with the same username. You may also want to investigate putting it into a stored procedure to reduce the CF load, but have a chat with your DBA about it. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 04 February 2003 09:30 To: CF-Talk Subject: Re: CF Logins and Users Logged In Hi Thanks for the excellent replies I have a log off feature which is a little piece of javascript function confirmDelete(aURL) { if (confirm("W A R N I N G ! Are you sure you wish to log off")){ document.location=aURL; } } Log Out which sends the user to logoff.cfm. Contained in logoff.cfm is the following CF Code Which ends their session. Both ideas seem very usefull, just would like to implement the most consistent and efficient method, so I would appreciate your views on the best example to use? Using Jasons example I would add another field to my Oracle usertable called logged_in. However how would I set that field when the user logs in Any code examples of how to achieve the above ?? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: CF Logins and Users Logged In
Its fairly straight forward, the problem is when they dont log out cleanly, The simplist way is to have another column in your user table called Logged_In and set it to 1 when logged on, and 0 on a clean logout To find the count simply run the following script. Select count(Logged_in) from usersetup where logged_in=1 I think you might be able to use Jscript to get round the problem of a messy application closure (ie closing the browser), but I'm not sure. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 04 February 2003 08:49 To: CF-Talk Subject: CF Logins and Users Logged In Hi Does anybody on the list know how I can implement a feature on my Intranet site thats shows how many users are currently logged. I.E. There are currently 5 users on the site. Any ideas on how to implement this ? This is what I have at the moment .. The user enters their username/password to log into the Intranet - this checks against the database below SELECT * FROM usersetup WHERE Username = '#form.Username#' AND Password = '#form.Password#' If correct session variables are created and you enter the homepage. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: Webservices in CFMX
The way we do the invoke is inside a cfloop, as we first query a Database to get locations to search through, then loop through the record set for Each Pair of locations/for a set of given days. At no point is the page refreshed, could this be the problem with CF? The reason we do this is so that we can build up a data base of operational days between certain locations so that we can display the results to the customer to find the day/s when a particular route is in operation. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 17:07 To: CF-Talk Subject: Re: Webservices in CFMX On Wednesday, Jan 29, 2003, at 01:36 US/Pacific, Jason Lees (National Express) wrote: > I've just been doing some load testing connecting from CFMX to an > Inhouse > webservice application. Everything is running ok until about 300 > transactions have been processed, CFMX then throws the following error How are you actually doing the load testing? Are you creating a .cfm that loops over a cfinvoke webservice=... or are you doing something more complex? Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Webservices in CFMX
All, I've just been doing some load testing connecting from CFMX to an Inhouse webservice application. Everything is running ok until about 300 transactions have been processed, CFMX then throws the following error Object reference not set to an instance of an object. at JourneySearch.JourneySearch.SingleJourneySearch(String FromLocation, String ToLocation, String JourneyDate, String JourneyTime) However if we connect through to the webservice using the browser through http it works ok. Has anyone seen this before? or got any ideas on how to solve the problem? Jason Lees Development Team Leader National Express Coaches Ltd. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Book reviews
check out the Ben forta books published by Macromedia press (ISDN nos - 0-321-12516-9, and 0-321-12710-2], they're both quite good, Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 14:40 To: CF-Talk Subject: Book reviews Hello, We are getting ready to migrate to CFMX and I went to a local B&N to take a look at what's out. I was quite dissapointed, it's all the same stuff just updated to say MX on the cover. Are there any advanced books out there? Thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Stealing content?
Its called scrapping or syndication, depending on the books you read. to accomplish syndication, you use the tag, However this is technically illegal without the Website owners permission as they own legal copyright on the material. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 12:38 To: CF-Talk Subject: Stealing content? I was talking to someone the other day about ColdFusion, and they said "Oh yeah, and it has that feature that allows you to steal content." I've never heard of that - what feature would that be? T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Loop Errors
the simple answer about the nested tags is whats the point? and so the parser catches the nested tags as a coding error. Its like doing #myVar1# #MyVar2# Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 16:25 To: CF-Talk Subject: Re: Loop Errors Thanks For the replies Taking them in no particular order Jason Lees said "Well for a start you dont neet to nest the 's" Why don't I need to nest the cfoutputs? Jeff Garza and Mosh Teitelbaum picked up on the same point, jeff said.. "I beleive that you have referenced the query wrong. Try: " I know what you are saying however, the query is linked to the output of the actual select shown below Select ATA Code #category# If you look at my code you should see this.. Jerry Johnson said " ChapterArray#category#[#i#] = #category#; ChapterArrayVal#category#[#i#] = "#catno# #category#"; " why do you think I dont need this?? The code I am using is based on the code below , which works but I think they were using two tables I am only using one table?? From this you may be able to solve some of these problems??? ---ORIGINAL-- Untitled SELECT a.ata_chapter, a.ata_title, b.ata_section, b.ATA_TITLE SubTitle FROM ata_codes a, ata_sub_codes b WHERE a.ata_chapter = b.ata_chapter ORDER BY a.ata_chapter, b.ata_section <!-- // For each chapter, create an array to hold the sections. // Each chapter array will be identified by the ATA_Chapter <cfoutput query="rsATA1" group="ATA_Chapter"> // Create the array ChapterArray#ATA_Chapter# = new Array(); ChapterArrayVal#ATA_Chapter# = new Array(); <cfset i = 0> // Populate the array <cfoutput> <cfset i = i + 1> ChapterArray#ATA_Chapter#[#i#] = #ATA_Chapter#; ChapterArrayVal#ATA_Chapter#[#i#] = "#ata_section# #SubTitle#"; </cfoutput> </cfoutput> // Function to populate the ATA_Sub_Codes for the ATA_Code selected function PopulateATASubCode() { // Only process the function if the first item is not selected. var indx = document.InsertForm.ATACode.selectedIndex; if (indx != 0) { // Find the Chapter var ThisChapter = document.InsertForm.ATACode[indx].value; // Set the length of the ATA_Sub_Codes drop down equal to the length of the Chapter's array var len; len = eval("ChapterArray" + ThisChapter + ".length"); document.InsertForm.ATA_SubCode.length = len; // Put 'Select' as the first option in the SubCode drop-down document.InsertForm.ATA_SubCode[0].value = ""; document.InsertForm.ATA_SubCode[0].text = "Select ATA Sub Code"; document.InsertForm.ATA_SubCode[0].selected = true; // Loop through the chapter's array and populate the SubCode drop down. for (i=1; i<len; i++) { document.InsertForm.ATA_SubCode.value = eval("ChapterArray" + ThisChapter + ""); document.InsertForm.ATA_SubCode.text = eval("ChapterArrayVal" + ThisChapter + ""); } } } //--> Requirements Database Add Requirement Select ATA Code #ATA_Chapter# #ATA_Title# Select ATA Sub Code - Original Message - From: "Jason Lees (National Express)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 06, 2003 3:55 PM Subject: RE: Loop Errors > Well for a start you dont neet to nest the 's > > > Jason Lees > Development Team Leader > National Express Coaches Ltd. > > > > -Original Message- > From: Ian Vaughan [mailto:[EMAIL PROTECTED]] > Sent: 06 January 2003 15:50 > To: CF-Talk > Subject: Loop Errors > > > Does anybody have any ideas on why I am getting a loop error from my code > below I cant see why this is happening, any suggestions would be most > helpful thanks... > > Error Occurred While Processing Request > Error Diagnostic Information > Loop error > > > The error occurred while processing an element with a general identifier of > (CFOUTPUT), occupying document position (23:1) to (23:42). > > > Date/Time: Mon Jan 06 15:49:37 2003 > Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) > Remote Address: 121.100.25.2 > > > > > > > > Untitled > > > > > > SELECT a.category, a.catno, a.parent_level, b.category, b.catno, > b.parent_level > FROM category_menu a, category_menu b > > WHERE a.parent_level = b.catno > > ORDER BY a.category, b.category > > > > <!-- > // For each chapter, create an array to hold the sections. > // Each chapter array will be identified by the ATA_Chapter > <cfoutput query="rsATA1" group="category"> &g
RE: Loop Errors
Well for a start you dont neet to nest the 's Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 15:50 To: CF-Talk Subject: Loop Errors Does anybody have any ideas on why I am getting a loop error from my code below I cant see why this is happening, any suggestions would be most helpful thanks... Error Occurred While Processing Request Error Diagnostic Information Loop error The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (23:1) to (23:42). Date/Time: Mon Jan 06 15:49:37 2003 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: 121.100.25.2 Untitled SELECT a.category, a.catno, a.parent_level, b.category, b.catno, b.parent_level FROM category_menu a, category_menu b WHERE a.parent_level = b.catno ORDER BY a.category, b.category Requirements Database Add Requirement Select ATA Code #category# Select ATA Sub Code ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS CF?
If it happens it happens, being a developer I'll use whatever tool's I'm told to use either by Clients or the company I work for at the time. As for if MS buys MM personally I can see it happening, based on the aqusitions its made over the years, and also the fact that the only tools MS have for web design are Front Page and ASP.Net, and they arnt the easiest to use. Well thats my two penneth. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Len Conrad [mailto:[EMAIL PROTECTED]] Sent: 23 December 2002 10:07 To: CF-Talk Subject: MS CF? http://theregister.co.uk/content/4/28667.html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Page Breaks for Printing
We use page breaks, and its a simple tag extention of the classic paragraph Tag The Complication is deciding on the location to place the Tag. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: 19 December 2002 14:03 To: CF-Talk Subject: Page Breaks for Printing Has anyone figured out how to make page breaks for printing? I.E. have the user click one button to print all of the new orders. Each order on a separate piece of 8.5x11 paper. Javascript? Generate a PDF? Thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Is Coldfusion REALLY multi threaded?
It might not Be CF thats causing the problem, its most likley the DB thats escalating the Lock to a full table lock and thus preventing other users from running the queries until the table is free. Also try moving the DB onto another server, as we had a simular problem, with ingres and moving the CF app to a new server solved the problem. Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 16:23 To: CF-Talk Subject: Fw: Is Coldfusion REALLY multi threaded? - Original Message - From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 4:14 PM Subject: Re: Is Coldfusion REALLY multi threaded? > Stephen Richards wrote: > > > > We have 24 connections at the moment, as reported by the database. (can't > > use netstat because the CF server is running on the same machine as the > > database, so it's a unix socket rather than port 5423. > > And how many of them are idle? In the mean time you might want to get > somebody to look at that query, since 2 minutes is rather long. > how do I tell which ones are active? Yep, I agree with you about the query, and we're taking action on that, but it still raises the point that CF is unresponsive while a query is executing, and I am sure it is not supposed to be. And the more users log on, the worse it is going to become. - Stephen Richards 020 7903 3226 -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Passing objects from CFMX to Webservices
All, I have two webservices both written in VB.Net, one generates a Journey Object, which I can parse quite easily in CFMX, however I need to be able to pass part of the object back into another webservice after a selection is made, the receiving webservice is expecting the same object type I'm passing back. The following code give me a Jave Lang Exception error - 'Could not perform web service invocation "fareSearch" because java.lang.IllegalArgumentException: argument type mismatch)' http://jlees1/FareSearch/FareSearch.asmx?wsdl"; method="fareSearch" returnvariable="Fares"> I've tried all using the argumentcollection in the cfinvoke, which gives me the error - 'Cannot remove properties from a java object' I've conisdered redeveloping the webservice to use flat strings, but I'd Ideally like a neater solution, hence the reasons for using a webservice and objects) Can anybody offer me any pointers on what to try next Many thanks in advance for all your help. Jason Lees Systems Developer National Express Coaches Ltd. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: Checking SESSION variable
Use the find function . but from the example that could be ambigious, as there could be more than one mywork2 in different sub folders. Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 16:08 To: CF-Talk Subject: Checking SESSION variable Hi, I have session variable that contains the directory name "session.strFileName". I also have another session variable "session.ShowMe" that contains multiple directory names (comma-delimited) which i'm setting from my database. Basically, i need to check if the directory "session.strFileName" exists in the variable "session.showme". Example: session.strfilename = 'mywork' session.showme = 'c:\temp\dir1,c:\temp\dir2,c:\temp\mywork,c:\temp\mywork2' --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Webservices that return Collections
All, Im not a full time CF Coder, This is just to enable me a proof of concept for some external contractor who are sceptical about the use of webservices. The CFDump tag works a treat, I can use this to get all the details I need. Many thanks, Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 29 November 2002 10:51 To: CF-Talk Subject: RE: Webservices that return Collections Is it a valid ColdFusion recognised structure? The others are correct, if you use CFDUMP you should be able to find out if if the structure is valid for CF to intepret etc... I would assume though that this should get the values out (though it probably wont, as its Friday and I am putting in little effort ;): #webservice[Journeys][1][JourneyDetail][LegCount][Duration][Legs][1].LegDate # also, try and run an #isStruct(YOURSERVICE)# to determine if its a valid structure... It really shouldnt be difficult to get at the values if it is! Neil -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: 29 November 2002 10:39 To: CF-Talk Subject: Webservices that return Collections All, I have written a Webservice in .Net that produces an Object Collection, the basic structure is Journeys(Index).JourneyDetail.LegCount .Duration .Legs(Index).LegData I would like to know how I can loop through this structure so it can be output in to a table, I've tried using CFloop to loop round the collection, but it throw errors, My Code is http://localhost/JourneySearch/JourneySearch.asmx?wsdl"; method="JourneySearch" returnvariable="Journeys"> #JourneyDetail.LegCount# I get the following error returned by CF - You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. The Error Occurred in C:\Inetpub\wwwroot\test1\Test.cfm: line 21 19 : 20 : 21 :#JourneyDetail.LegCount# 22 : 23 : Can anybody give me some pointers, please Jason Lees Systems Developer National Express Coaches Ltd. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Webservices that return Collections
All, I have written a Webservice in .Net that produces an Object Collection, the basic structure is Journeys(Index).JourneyDetail.LegCount .Duration .Legs(Index).LegData I would like to know how I can loop through this structure so it can be output in to a table, I've tried using CFloop to loop round the collection, but it throw errors, My Code is http://localhost/JourneySearch/JourneySearch.asmx?wsdl"; method="JourneySearch" returnvariable="Journeys"> #JourneyDetail.LegCount# I get the following error returned by CF - You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members. The Error Occurred in C:\Inetpub\wwwroot\test1\Test.cfm: line 21 19 : 20 : 21 :#JourneyDetail.LegCount# 22 : 23 : Can anybody give me some pointers, please Jason Lees Systems Developer National Express Coaches Ltd. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: Alternating Row Colours & Number Listing in CFOutput
Cant you just use the CurrentRow variable, for the record number display? Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 27 November 2002 16:39 To: CF-Talk Subject: Alternating Row Colours & Number Listing in CFOutput Hi I am using the following script to display the latest 5 records from the database table, and alternate the colour of each row, from white to grey. This works, but how to I add a number listing with each record so the latest record would have a number 1. next to it the seconf record would have number 2 then number 3 etc. If you look at the code attached and the second CFIF statement you will see that at present I have hard coded a number 1 and number 2, so in the results at present it is bringing back 1.) Record Name 2.) Record Name 1.) Record Name 2.) Record Name 1.) Record Name How to I make this dynamic in Coldfusion so it is a number listing of 1 to 5??? TIA Ian 1. 2 #linktitle# #linktitle# ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: Checking a float
As CF is a loosly typed language you could simply do --whole bathrooms --partial bathrooms Question is though how do you have .5 of a bathroom, isnt this like half a hole? Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] Sent: 18 November 2002 15:28 To: CF-Talk Subject: Checking a float A have a float field in a db to store the number of bathrooms for a property ( 1.5 bathrooms, 3 bathrooms). My question is, how do I check to see if there is a non zero value after the decimal? I want it to show: 1.5 bathrooms 3 bathrooms and not: 1.5 bathrooms 3.0 bathrooms Any help is greatly appreciated. Cutter Falcon Knives ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: calling a dll from an sql stored proc
Hi John, I've just spoken with our MS SQL Guru and hes not aware of any way of accesing a VB created Dll through MS SQL. The only way he intimated it could be done was by writing an xp_ wrapper in c++ for the VB library. Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: John McCosker [mailto:J.McCosker@;andronics.co.uk] Sent: 15 November 2002 13:17 To: CF-Talk Subject: calling a dll from an sql stored proc Greetings, Has anyone called a dll from a stored procedure, I am aware you can create custom stored procs that are dll's but the sql API only understands dll's in c or c++, I want to write it in VB. The problem is with a trigger, that when an update occurrs I need it to create a recordset and loop throug it performing calculations from the recordset then inserting the results into a new table, this can be done with a Cursor, but is very slow and I have been told is very resource intensive on sql server. We don't want to do this as the trigger will be called often. An alternative would be if a stored proc could call a flat file, i.e. a cfm or asp page and then do the maipulation here. We have thought of a third alternative which will work, send an email to an INBOX via sgl server and have the inbox agent call the dll, but the result has a latency due to the email request. Would appreciate any thoughts, Respectfully, J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFX tags
Mark, To the best of my knowledge you need to define the CFX tag on the local server, and have a local copy or a mapped drive to the location of the CFX tags on the other server. Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: Mark Leder [mailto:mel@;markleder.com] Sent: 14 November 2002 13:42 To: CF-Talk Subject: CFX tags Hi All, Can CFX tags installed on one CFServer be called from a second server / site which doesn't have the tags installed on its CFServer? Thanks, Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFOBJECT and conversion from ASP
Coms not dead yet as you say theres too many older applications using it, but the way forward is webservices, which is basically a newer version of Com without the all the hassles. With reagrd the problem try myMethod = myObject.item("title"); myMethod = "title"; Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: Joshua O'Connor-Rose [mailto:whifflebat@;hotmail.com] Sent: 12 November 2002 15:57 To: CF-Talk Subject: CFOBJECT and conversion from ASP OK so COM is dead, I would like to see the thread. Do you have a link. That would also imply that no one uses it anymore. Anyway the office I'm developing for is using all that dead stuff. I have been advocating replacing what they have with Verity and hopefully that is what the system will convert to. But right now . . . I'm a slave to a contract. In response to your suggestion (thanks for the post) myObject = myObject.item("title"); myObject = "title"; This throws an error "the parameter is incorrect" on this line: myObject = myObject.item("title"); which I assume is coming from the object itself. So that doesn't work either. (It as if the object won't accept the name of the option without an assignment operator). Any other ideas? or am I going to have to use asp? -Joshua O'Connor-Rose -All is Good ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFOBJECT and conversion from ASP
Joshua, I think this will work, Or With anObject=CreateObject("Com","NextPage.NPOptions")' myMethod=anObject.Item("title"); myMethod="Title"; Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: Joshua O'Connor-Rose [mailto:whifflebat@;hotmail.com] Sent: 12 November 2002 16:08 To: CF-Talk Subject: CFOBJECT and conversion from ASP New to the list. Not to ColdFusion The contract I'm working on is using NextPage NXT3 to manage documents. They want to do some management of the NextPage environment through the ColdFusion system. (Never mind that Verity is better it has been discussed) NextPage has provided developers with com objects so that collections can be built by using the objects. One of these objects is merely used to define options and is created like this In asp Set objNPOptions = Server.CreateObject("NextPage.NPOptions") to create the name value pairs the command is this: objNPOptions("title") = "Title" or objNPOptions.item("title") = "Title" I've been trying to convert this into cold fusion but my conversion bombs when I attempt the same Can't use a function on the left side of an assignment. (sigh) The unfortunate thing is the NPOptions object is required to set the options for other objects like objSiteAdmin.CreateInfobase objNPOptions, "name", "c:\filename.nfo" aka in ColdFusion I tried structures and arrays but it seems that NPOptions is an object that the other com objects are expecting -from the desk of Joshua O'Connor-Rose -All is good ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Studio MX
My understanding is that there is no longer a CF Studio, its now fully integrated with Dreamweaver MX. Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: Owens, Howard [mailto:HOwens@;insidevc.com] Sent: 07 November 2002 20:49 To: CF-Talk Subject: Studio MX I'm trying to decide the best upgrade path ... Some time in the next year, we'll upgrade our servers to MX, so I will want to upgrade my development environment, too. Currently, I have Studio5 and the dev version of the server for 5.0. I also have UltraDev, but rarely use it. I do all of my coding (and very little design) in Studio. That's the way I like it. Should I upgrade to Studio MX? Will I like it if I love the current version of Studio, or does the "homesite" aspect of Studio disappear? If it does, but I get MX anyway, can I retain the install of Studio5 (without any hassle, such as fussing with the registry), or does MX overwrite/take over 5? Should I upgrade to the latest version of HomeSite instead? I assume there is a demo/single-license version of MX server I can download. Would my best option be to just stick with Studio5 and download the MX server? If I do this, is there some place I can get VTMs and help files and documentation for new tags? Thanks. H. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
Using .Net Object with CF Server MX
All, Has anybody succesfully managed to interface Microsoft .NET DLL's with CF MX? If so can you provide me with some pointers please. Many thanks in Advance. Jason Lees Systems Developer National Express Coaches Ltd. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: is this list dead?
This is the first one i've had in over a week!!! I thought the list was Dead!! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Erika L. Walker [mailto:[EMAIL PROTECTED]] Sent: 02 July 2001 16:53 To: CF-Talk Subject: RE: is this list dead? I'm getting posts, but not as many as we used to get. :( Erika (with a *K*) "Those who love deeply never grow old; they may die of old age, but they die young." - Sir Arthur Wing Pinero - Macromedia ColdFusion 5.0 Certified Developer - < Just passed!! WooHoo - -Original Message- From: Mike Sullivan [mailto:[EMAIL PROTECTED]] Sent: Monday, July 02, 2001 10:57 AM To: CF-Talk Subject: is this list dead? I haven't seen a post in quite some time now. Mike ~~ 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: ignore an error??
you could use the CFParam to set it to an empty string. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: 07 June 2001 16:10 To: CF-Talk Subject: ignore an error?? I recieve the following error: An error occurred while evaluating the expression: #url.techID# Page User Came From: http://www.site.com/Code.cfm?exitID=8&techID=94 I was wondering how to ignore or bypass this error because the techID does get passed and the code executes. But I always get an error email report and on some machines the error message DOES display causing the code to bomb. ~~ 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: Preserve ampersand tagged data (SGML)
Use the reverse of UrlDecode(encodedUrlString) Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 06 June 2001 15:05 To: CF-Talk Subject: RE: Preserve ampersand tagged data (SGML) Thanks Another question. I need to extract the complete path using the CGI.HTTP_REFERER in my template but when I output the line the string is encoded for use in URL's. What I need is the exact path without the encoding to be passed into my Output: dir=d%3A%5Cdirectory%5Csub-directory\ Require: d:\directory\subdirectory\ Is there another way of getting this output without using the "Replace" function? At 02:37 PM 6/6/01 +0100, you wrote: >HTMLEditFormat() > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: 06 June 2001 12:58 > > To: CF-Talk > > Subject: RE: Preserve ampersand tagged data (SGML) > > > > > > > > I'm using > french accented characters. > > > > Is there a CF function to preserve ampersand stuff ? > > > > Here is a little snippet from the datafile that has the SGML entity for a > > accented character "çais" > > > > > > > > Disponible en français > > > > > > > > > > When outputted in a I want the text to appear AS IS. I don't > > want the "cedil" translated into the ASCII character. > > > > > > > > Disponible en français > > > > > > > > > > > ~~ 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: Challenging dillemma (double values?)
you can youse a hidden field in the page and pass that into the Javascript function and just add the part item into it, with a comma so its a commer delmited list, just remember to remove the last Commer from the List. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Michel Gagnon [mailto:[EMAIL PROTECTED]] Sent: 06 June 2001 14:16 To: CF-Talk Subject: Challenging dillemma (double values?) Hi! I have a little challenging question for you. I have a "build your own computer system" page where customers can choose what parts they want in their system. There is a javascript that calculates everything on the fly. This javascript needs to have the price as the value: #PartName# But, I also need to pass the partID to the server, not the price. Is there a way that we could have the best of both world? The calculating javascript and the PartID's to send to the server? ~~ 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: profanity checker(again)
you could check to see if there is a valid caracter before and/or after the profanity, it Saturday would find turd then check back and find that there is no space or full stop, and then check forward for the same. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 06 June 2001 13:56 To: CF-Talk Subject: profanity checker(again) Hi all, I emailed the list regarding this a few weeks ago, but an interesting problem has now come up. I have some code that pulls a list of profanities from a db table, then checks them against a form feild submitted by a user. Any words that match are asterisked out. All well and good. But, when someone entered Saturday, the code returned Saay!! Yers, turd is in the database! What I want to know is this. How would I look at changing this so that whilst turd would be picked up and returned as , saturday is not?? Any ideas? Code is below. TIA Will SELECT ID, badword, rate1 FROM tbl_profanity ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF 5 Eval
Go to http://www.macromedia.com/go/cfpromo/ As far as I can understand its available now. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 06 June 2001 11:06 To: CF-Talk Subject: RE: CF 5 Eval When exactly is cf5 (enterprise) released, does anyone know? -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 7:46 AM To: CF-Talk Subject: RE: CF 5 Eval I'm currently evaluating it, and this sounds like it could be extremly usefull, please forward any information. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: 06 June 2001 07:44 To: CF-Talk Subject: CF 5 Eval Is anyone else evaluating or currently using CF 5? I have got some examples I would like to share with you about getting tons of user defined functions to run in memory instead of having to load them at the top of ever page. It is kind of the same effect you would get from caching a query except with a function instead. Anyway before I go into it. Anybody? Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF 5 Eval
I'm currently evaluating it, and this sounds like it could be extremly usefull, please forward any information. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: 06 June 2001 07:44 To: CF-Talk Subject: CF 5 Eval Is anyone else evaluating or currently using CF 5? I have got some examples I would like to share with you about getting tons of user defined functions to run in memory instead of having to load them at the top of ever page. It is kind of the same effect you would get from caching a query except with a function instead. Anyway before I go into it. Anybody? Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development ~~ 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: CF5.0 Tag CFFlush
Thanks, Just tried that, changed from a cookie to the Registry and it appears to be working a bit better. Whats the best way to store client vars, Registry or DB Table? Thanks. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: 05 June 2001 14:42 To: CF-Talk Subject: Re: CF5.0 Tag CFFlush If you are using client variables, and have specified cookies as storage, then you have an implied call to CFCOOKIE or a similar construct being included for you by CF. If you change your client variable storage to something other than cookie, it will probably work. DC - Original Message - From: "Jason Lees (National Express)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 05, 2001 09:13 Subject: RE: CF5.0 Tag CFFlush > > Thanks, > > I've checked the code for that and there is nothing except standard CFML & > HTML tags, ie no CFCookie, cflocation, or any other such tags. > > Just to check I used this on a page that is a 90% block. and > still the same. > > > Jason Lees > National Express > Email : [EMAIL PROTECTED] > > > -Original Message- > From: Ulf Unger [mailto:[EMAIL PROTECTED]] > Sent: 05 June 2001 14:15 > To: CF-Talk > Subject: AW: CF5.0 Tag CFFlush > > > Hi Jason, > > I've read in the documentation that you can't use any ColdFusion-Tag that > modifies the HTTP-Header (e.g. Cookies..) after you have used the . > > Hope that helps. > > Ulf > -Ursprüngliche Nachricht- > Von: Jason Lees (National Express) > [mailto:[EMAIL PROTECTED]] > Gesendet: Dienstag, 5. Juni 2001 14:54 > An: CF-Talk > Betreff: CF5.0 Tag CFFlush > > > > Hi All, > > I'm just evaluating Coldfusion 5.0, at the moment I'm experimenting with the > new tag, But every time I get an error at the end of the page, > > Error attempting to store global client values. > The amount of data you have stored in global client variables is too long. > The Cookie header has already been sent to the client, most likely because a > CFFLUSH tag has been executed. > the tag reads > > Does anybody have any Ideas A)Why this happens, and B) how do I stop it > happening. > > The application uses a Cookie as the Client storage method, > > any help appreciated. > > Thanks > > > Jason Lees > National Express > Email : [EMAIL PROTECTED] > > ### > This document is intended for, and should only be read by, those persons to > whom it is addressed. Its contents are confidential and if you have received > this message in error, please notify us immediately by telephone on 0121 609 > 6301 > and delete all records of the message from your computer. Any form of > reproduction, > dissemination, copying, disclosure, modification, distribution and / or > publication of this message without our prior written consent is strictly > prohibited. Neither the author of this message nor their employers accept > legal responsibility for the contents of the message. Any views or opinions > presented are solely those of the author. > If you have any queries please contact [EMAIL PROTECTED] > > ## > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5.0 Tag CFFlush
Thanks, I've checked the code for that and there is nothing except standard CFML & HTML tags, ie no CFCookie, cflocation, or any other such tags. Just to check I used this on a page that is a 90% block. and still the same. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Ulf Unger [mailto:[EMAIL PROTECTED]] Sent: 05 June 2001 14:15 To: CF-Talk Subject: AW: CF5.0 Tag CFFlush Hi Jason, I've read in the documentation that you can't use any ColdFusion-Tag that modifies the HTTP-Header (e.g. Cookies..) after you have used the . Hope that helps. Ulf -Ursprüngliche Nachricht----- Von: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 5. Juni 2001 14:54 An: CF-Talk Betreff: CF5.0 Tag CFFlush Hi All, I'm just evaluating Coldfusion 5.0, at the moment I'm experimenting with the new tag, But every time I get an error at the end of the page, Error attempting to store global client values. The amount of data you have stored in global client variables is too long. The Cookie header has already been sent to the client, most likely because a CFFLUSH tag has been executed. the tag reads Does anybody have any Ideas A)Why this happens, and B) how do I stop it happening. The application uses a Cookie as the Client storage method, any help appreciated. Thanks Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF5.0 Tag CFFlush
Hi All, I'm just evaluating Coldfusion 5.0, at the moment I'm experimenting with the new tag, But every time I get an error at the end of the page, Error attempting to store global client values. The amount of data you have stored in global client variables is too long. The Cookie header has already been sent to the client, most likely because a CFFLUSH tag has been executed. the tag reads Does anybody have any Ideas A)Why this happens, and B) how do I stop it happening. The application uses a Cookie as the Client storage method, any help appreciated. Thanks Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Use interactive CF debugger!!! : was VeRy tricky evaluate()
Surely the Array a has not been defined, therefore a will always either be a null or length=0. Have you Evaluating the Session Variable as the Array? I think this should work, or somthing very simular #evaluate("session.my" & url.grid & "[" & i & "]")# Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 14:42 To: CF-Talk Subject: RE: Use interactive CF debugger!!! : was VeRy tricky evaluate() After many many attempts i still have not got it working this may be due to the fact that i'm not sure exactly how it is supposed to work. Do you have an tips/pointers? Thanks Kola -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 14:24 To: CF-Talk Subject: Use interactive CF debugger!!! : was VeRy tricky evaluate() Seems to me the only way you could find your way out of this one is to use the cfstudio step through debugging. You may be doing so already but I get the impression not many cf developers use this, perhaps because it can be temperamental. But I've found it invaluable now I've got it working. It can save you mountains of time and brain ache. I'd recommend spending the time to get it running. I had it working on a stand-alone but I'd been led to believe it wouldn't work well on a network, but it does, sometimes it takes a few attempts to connect. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 29 May 2001 16:45 To: CF-Talk Subject: VeRy tricky evaluate() I'm in a complex situation here which gives NO ERRORS but doesn't seem to work right. please help. My project has several unique sections (where the key=grid) Every user can upload several images to each group. everytime he uploads at least 1 file to a new group, I'm assigning him a session array variable that is called: "session.my#url.grid#": then I give him the upload form. after each upload, I'm appending the array with the new file: and now I want to display back the upload form, but with a list of the files he already uploaded: first I'm moving the session array into a local variable: then I'm looping without worrying for locking: Files that were uploaded to #url.grid#: #a[i]# the a array keeps being EMPTY all the time. I'm checking that with this: You haven't uploaded any pictures to #url.grid# yet. note that I don't want to : a. query the db everytime to get the list of files that was uploaded. b. limit the session timout to 1 minute Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What's with this?
Doesn't June only have 30 days!!!!! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 14:11 To: CF-Talk Subject: What's with this? I have this bit of code... and I'm getting this error on date1 In the function CreateDate(year, month, day) the combination of the arguments, which are 2001- 6-31, have resulted in an invalid date value. The valid range of dates approximately covers the period between 100 AD and AD WHY? Steven D Dworman --- Cold Fusion Programmer Web Applications Developer ComSpec International phone: 248.647.8841 cell: 734.972.9676 --- http://www.comspec-intnl.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: How do I parse strings?
hi Bill, This should do what you want more or less, it uses CF Script, Except this will also check for the Existing CR&LF characters and bearck naturally. It will search backwards for the last space before a word rather than search forward. Amend Linelength to match requirements. The Output is in TmpActual which is an Array. iLine is the Line count Amend it from 2 to 1, Theres also probably a better way to do this, but it works, iLine=2; LineLength=64 TmpActual=Arraynew(1); MsgOperator=Replace(Form.Message,Chr(10),"}","ALL"); MsgOperator=Replace(MsgOperator,Chr(13),"}","ALL"); while (len(MsgOperator) gt 0){ TmpNote=""; if (len(MsgOperator) gt LineLength) TmpNote=Mid(MsgOperator,1,LineLength); else TmpNote=Mid(MsgOperator,1,len(MsgOperator)); pos=Find("}}",TmpNote,1)-1; if (pos lte 0){ pos=Len(TmpNote); if (pos eq LineLength){ for (pos;pos gt 0 and Mid(TmpNote,pos,1) neq " ";pos=pos-1); if (pos eq 0) pos=Len(TmpNote); } } Miss_Line=FALSE; if (Find("}}",TmpNote,1) eq 1){ pos=2; Miss_Line=TRUE; } if (not Miss_Line){ TmpActual[iline]= Ljustify(Mid(TmpNote,1,pos),LineLength); iLine=iLine+1; } if (Find("}}",TmpNote,1) gte 0) pos=pos+2; else pos=pos+1; MsgOperator=Mid(MsgOperator,pos-1,len(MsgOperator)); } iLine=iLine-1; HTH Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Bill Poff [mailto:[EMAIL PROTECTED]] Sent: 30 May 2001 15:45 To: CF-Talk Subject: How do I parse strings? Hello fellow CFers, I'm trying to process a "textarea" variable and break it up into lines of aprox 70-80 characters in length for transmission as a text formatted email message. Can someone help me with the code to parse the variable into lines so that I can insert a #CHR(13)##CHR(10)# at the end of every line. The challenge is to break between words. Thanks. --Bill ~~ 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: whitespace
I had a similar problem, so I used the tag and this reduced page size by as much as 25%, unfortunatly you can't use querys or custom tags in a block so there are limitations and Debuging can be a hand full. I would suggest writting the page normally in CF then converting as much as possible into a CFScript tag. HTH. Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: nagesh [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 8:09 PM To: CF-Talk Subject: whitespace hi all, i really fed up with the white space which is generated in the text file by coldfusion(4.5). This happens when client(outlook) is reading the data which is in output tags and trying to write into the text(log) file. Do we have anything by which we can remove/trim the white space before it goes to text file. Because the problem here is with the white space the size of the file is getting increased like anything. I know about tag. but i want something powerful than that. Any ideas would be greatly appreciated. Thanks nagesh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can I retrieve the peripherals attached to a 'puter?
If you goto the M$ page http://windowsupdate.microsoft.com/ and click on the products Update, and it appears that this goes and searches the registry. So It is Possible, Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: 25 May 2001 15:33 To: CF-Talk Subject: Can I retrieve the peripherals attached to a 'puter? Does anyone know if it is possible to query the system registry of a visitor's system in an effort to retrieve the names of peripherals attached to it? i.e. HP2000 printer, Iomega zip drive, Panasonic CD Writer... How about with VB? anyone...anyone... ~~ 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: CFGRID with list box?
Probably not, M$ seems to have gone off java since sun won its law suite against them, besides Sun is developing Java faster than M$ or Netscapecan keep up, they're currently working 1.4 at the moment which by all accounts is a major overhaul. Beside M$ is too busy trying to push its .net development suite, so chances are that it wont. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: 25 May 2001 14:13 To: CF-Talk Subject: RE: CFGRID with list box? Arrggh..what are the chances that the new JRE will be bundled with future MS OS updates or something like that? Will IE6.0 have it standard? -Gel -Original Message- From: Jason Lees (National Express) Latest JRE Environment (1.3.1) is about 5.5MB, It is ideal for Intranets, but a problemif your Network Admin has a god complex where hes locked all machines to Normal Users Installing software, even off the intranet!!! ~~ 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: CFGRID with list box?
Latest JRE Environment (1.3.1) is about 5.5MB, It is ideal for Intranets, but a problemif your Network Admin has a god complex where hes locked all machines to Normal Users Installing software, even off the intranet!!! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 25 May 2001 13:43 To: CF-Talk Subject: Re: CFGRID with list box? * Team Allaire * > Ya but -- Correct me if I'm wrong -- I've been told that the new CFGRID > involves a five mb download the first time it is used -- which makes it's > usefullnees nil for most applications -- those that still want to be > functional on a 56k line. if you mean the latest JRE, i think its even bigger than that ;-) BUT if you want to use any java stuff from cf5, that's one bullet you gotta bite. we gagged at first but on our intranet it cleared up several pesky java problems (nothing to do w/cf). now we're pushing it all our intranet sites. if thats not for you, then i guess dhtml is one recourse. think there's a cheap tag in the gallery cf_jsgrid or something like that... ~~ 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: SLightly OT - a time formula
Try this Therefore with 400 Mins you get Hours=int(400/60)=6 Mins=400 Mod 6= 40 Back Calc = (6*60)+40=360+40=400 Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 22 May 2001 14:46 To: CF-Talk Subject: SLightly OT - a time formula Hi all, This is slightly OT, but refers to a cf project so I guess it is relevant in a way. Does anyone know a formula for calculating time. I have numbers of minutes, and need to calculate the time in hours and minutes from these. For example, I have the figure of 400 minutes. I need to calculate how many hours and minutes this is. Dividing by 60 won't do the job, it gives an answer of 6.. What I need is a formula that will give me the correct answer: 6hrs 40minutes. Anyone know a nice formula for calculating this? TIA Will ~~ 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
Configuring CF45 for Java
Hi All, The problem I am experiencing is that I have developed a Java Applet that creates a Menu system, It works fine on the development macine with Java installed but when I check on another Machine there I get a Class not found Exception. I have assumed that this is becuase CF isn't set up to run JVM and doesnt have the necessary classes on the system. Is this true? and How do you configure the Java settings in CF4.5 so that you can utilise classes? Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OpenIngres Database
I've Just spoken to our resident Ingres expert, and his opinion is that you need to use a DB procedure to do it. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 18:37 To: CF-Talk Subject: OpenIngres Database Help! Does anyone know if there's a way to make an auto- incrementing number field in a CA OpenIngres database? Thanks! Norman Elton ~~ 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
Way OT:Java Mailing Lists
Hi All, Can anybody recommend a good JAVA Mailing list like CF-Talk. TIA Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: query error
Do You realy need the ; at the end of the Query? Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 11:36 To: CF-Talk Subject: query error Hello, Must be having a brain spasm todayI am getting this error message: Message: ODBC Error Code = S1000 (General error) Error Code: -3035 SQL State: S1000 Detail: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. SQL = "INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (32, 'hhdf', 'hsdfhdfh', 1, 14/05/01);" This is the query that seems to be causing the problem: INSERT INTO tbl_threads (operaID, thread_title, thread_body, thread_author, thread_time) VALUES (#url.operaID#, '#Form.thread_title#', '#Form.thread_body#', #checkauthor.authorID#, #dadate#); Any ideas anyone? TIA Will ~~ 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: Changing Default Site error page
sorry, this is what I meant, I must start being more precise.. Any Ideas? Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: 02 May 2001 19:59 To: CF-Talk Subject: RE: Changing Default Site error page He said "when CF Server has been shut down". If the CF server isn't running, how could it process the site wide error handler? I think he's asking about this error: Error Diagnostic Information An error occurred while attempting to establish a connection to the service. The most likely cause of this problem is that the service is not currently running. You can use the 'Services' Control Panel to verify that the service is running and to restart it if necessary. Windows NT error number 2 occurred. Any way to replace that with a friendlier message? Bob -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: May 2, 2001 12:29 PM To: CF-Talk Subject: Re: Changing Default Site error page * Team Allaire * How did you set up the site wide error handler? It has to be the 'true path' to the template. i.e. c:\htdocs\error.cfm > > Hi All, > > is there any way to change the default displayed page when CF Server has > been shut down? at the moment we get an Error Diagnostic page and want to > change this to a more freindly solution. > > We have tried Using the CF Site wide error option in the administrator > settings but this doesn't work. > > Does anyone have any ideas?? > > Jason Lees > National Express > Systems Department. > E-Mail : [EMAIL PROTECTED] > > > ### > This document is intended for, and should only be read by, those persons to > whom it is addressed. Its contents are confidential and if you have received > this message in error, please notify us immediately by telephone on 0121 609 6301 > and delete all records of the message from your computer. Any form of reproduction, > dissemination, copying, disclosure, modification, distribution and / or > publication of this message without our prior written consent is strictly > prohibited. Neither the author of this message nor their employers accept > legal responsibility for the contents of the message. Any views or opinions > presented are solely those of the author. > If you have any queries please contact [EMAIL PROTECTED] > > ## > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Changing Default Site error page
Hi All, is there any way to change the default displayed page when CF Server has been shut down? at the moment we get an Error Diagnostic page and want to change this to a more freindly solution. We have tried Using the CF Site wide error option in the administrator settings but this doesn't work. Does anyone have any ideas?? Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update in CFquery is failing, somone code check this ?
Cant see anything wrong with the syntax, have you tried removing the spaces before and after all the ='s in the query string,shouldn't make a difference but worth trying. is the DSN correct? Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 4:22 PM To: CF-Talk Subject: RE: Update in CFquery is failing, somone code check this ? > I think you might find that the Skill field is now 2 and not > 1 Re-read your > e-mail, > > Technically the critera you want to update doesn't exist any > more there for > no record therefore an Error. Shame that the error is 'syntax error', and not 'no records updated', which iirc wont be reported 'cuase its OK for an update to not update anything. Anyway, its still a bug, now fixed, so thanks for spotting it :-) Dont suppose you've secretly found out where the syntax error is ? ~~ 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: Update in CFquery is failing, somone code check this ?
I think you might find that the Skill field is now 2 and not 1 Re-read your e-mail, 'The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine.' Technically the critera you want to update doesn't exist any more there for no record therefore an Error. QED Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 11:43 AM To: CF-Talk Subject: Update in CFquery is failing, somone code check this ? I have: update con_list set note = 'dr' where userid = #session.userid# and skill = #form.skill# And it is dieing with: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. SQL = "update con_list set note = 'dr' where userid = 32715281 and skill = 1" Data Source = "PS_SKILLS" and I cant sport the error. The previous query (update con_list set skill_level=2 where userid = 32715281 and skill=1) on the same datasource finishes fine. Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 It's not a job, it's an adventure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Time off by an hour?
Same thing happens on our system running CF server 4.5.1 and windows NT4 SP 4 Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 2:26 PM To: CF-Talk Subject: RE: CF Time off by an hour? This is a problem with old apps compiled with a broken C++ library. I suggest you upgrade CF / NT to more recent versions / patches. -Original Message- From: Scott Becker [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 2:08 PM To: CF-Talk Subject: CF Time off by an hour? Our Windows NT 4 Server, running Cold Fusion 4.01 switched over with daylight savings time, yet Cold Fusion seems to still be an hour off.. The system time itself is correct, but running a script which outputs #now()# reports an hour behind. Has anybody else encountered this problem and have a fix for it? We've rebooted the machine, as well as stopped and started the Cold Fusion services, but it doesn't seem to have any effect... Thanks, Scott Becker Web Developer : ConnectWise, Inc. www.ConnectWise.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: ASCII for Tab
I think it would be better to chr(9) in he replace statement, Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 13:11 To: CF-Talk Subject: Re: ASCII for Tab So it would be in a replace statement. Is this correct? Thanks, Dave - Original Message - From: "Jason Lees (National Express)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 06, 2001 8:06 AM Subject: RE: ASCII for Tab > > I belive its ASCII '9' > > > Jason Lees > National Express > Email : [EMAIL PROTECTED] > > > -Original Message- > From: Dave Hannum [mailto:[EMAIL PROTECTED]] > Sent: 06 April 2001 13:01 > To: CF-Talk > Subject: ASCII for Tab > > > 'Mornin, > > Can anybody tell me what the ASCII for 'Tab' is so I can remove them? > > Thanks > Dave > ~~ 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: ASCII for Tab
I belive its ASCII '9' Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 13:01 To: CF-Talk Subject: ASCII for Tab 'Mornin, Can anybody tell me what the ASCII for 'Tab' is so I can remove them? Thanks Dave ~~ 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: Oddness with cfqueryparam
Fair comment, Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 2:23 PM To: CF-Talk Subject: RE: Oddness with cfqueryparam > Personally I've never used the CFQueryparam tag, but Surely the query should > read, :goes to a web site you've written and types into a form box: wibble';drop table *;select * where lastname='wibble Oops... > LastName like '%#form.what#%' ORDER BY LastName ASC Yes, unsurprisingly that works, but I need to clean the user input up, and I dont fancy writting my own sanatiser... -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:55 PM To: CF-Talk Subject: Oddness with cfqueryparam cfqueryparam doesnt seem to be doing as expected: SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts WHERE LastName like '%%' ORDER BY LastName ASC Debugging shows Form Fields: FIELDNAMES=WHAT WHAT=ch and the query as SQL = SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts WHERE LastName like '%?%' ORDER BY LastName ASC What gives ? Shouldnt cfqueryparam sanatise the string (for " and ; etc.) ? Regards, Thomas Chiverton, Intranet Architect and Desktop Analyst Office: 01565 757 909 As a GUI, reality in useless... ~~ 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: Oddness with cfqueryparam
Personally I've never used the CFQueryparam tag, but Surely the query should read, SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts WHERE LastName like '%#form.what#%' ORDER BY LastName ASC Jason Lees E-Mail:[EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:55 PM To: CF-Talk Subject: Oddness with cfqueryparam cfqueryparam doesnt seem to be doing as expected: SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts WHERE LastName like '%%' ORDER BY LastName ASC Debugging shows Form Fields: FIELDNAMES=WHAT WHAT=ch and the query as SQL = SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts WHERE LastName like '%?%' ORDER BY LastName ASC What gives ? Shouldnt cfqueryparam sanatise the string (for " and ; etc.) ? Regards, Thomas Chiverton, Intranet Architect and Desktop Analyst Office: 01565 757 909 As a GUI, reality in useless... ~~ 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: date range search
Give this one a try, Select * >From My Table where OrderDate >= '#CreateODBCDateTime(startdate+TimeFormat("00:00:00"))#' and OrderDate <= '#CreateODBCDateTime(enddate+TimeFormat("23:59:00"))#' -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 4:55 PM To: CF-Talk Subject: RE: date range search Thanks for the suggestion. It didn't work though. I have a form with a dropdown menu. Can dates in an Access table between: 01/01/00 and 01/01/01 be searched ? - Using my code: SELECT * FROM wwebsales where orderdate between #startdate# and #enddate# --- I can the following error: ODBC Error Code = 22012 (Division by zero) [Microsoft][ODBC Microsoft Access Driver]Division by zero (null) SQL = "SELECT * FROM wwebsales where orderdate between 01/01/00 and 01/01/01" Data Source = "wwebsales" -- Thanks. Robert O. >-Original Message- >From: Lamon, Alec [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, April 03, 2001 3:04 PM >To: CF-Talk >Subject: RE: date range search > > >I think you want to use the CreateODBCDate() function to create >your start and end dates. > > > >Then refer to those in your query *without* 's. (the >CreateODBCDate() function puts them in for you): > > > >SELECT * FROM wwebsales >where orderdate between #startdate# and #enddate# > > >> -Original Message- ~~ 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: Please Help
Its also Ideal way to learn Java Script. At least thats how I taught myself Java script. Another benefit is that I also managed to cut the output page sizes down by as much as 50%!!! Remember why reinvent the wheel. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 3:51 PM To: CF-Talk Subject: RE: Please Help I like that suggestion. It's naughty, but makes sense!! ;) Will -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED]] Sent: 04 April 2001 13:27 To: CF-Talk Subject: Re: Please Help ...use . Call the page in your browser then view source. You will see all the JavaScript you will need for validating forms. Copy and paste away Not the most ethical solution, but a solution none the less. - Douglas Knudsen Leveraged Technologies Group Alltel AIS 678-351-6063 Got Linux? http://linuxmall.com From: [EMAIL PROTECTED] AT INTERNET on 04/03/2001 06:11 PM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: Please Help I am in desperate need of a simple validation of two types of form fields. 1. Date field (not a cfform just a plain form) - must validate that data entered is a date 2. Number field (not a cfform just a plain form) - must validate that data entered is a number Thanks Stephanie ~~ 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: Looping through a Query in CFSCRIPT
Thanks for all the help, I've tried the solution and it works, I forgot that effectivly the query is a structured array. I need a break/holiday or caffine injection. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Hayes, David [mailto:[EMAIL PROTECTED]] Sent: 03 April 2001 16:19 To: CF-Talk Subject: RE: Looping through a Query in CFSCRIPT for(myCounter=1; myCounter LTE myQuery.recordcount; myCounter = myCounter + 1){ writeOutput(myQuery.myFieldName[myCounter] & ''); }; -Original Message----- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 9:55 AM To: CF-Talk Subject: Looping through a Query in CFSCRIPT Hi all, Is it possible to loop through the results of a CFQuery structure? and Has anybody got an example of how its done TIA. Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Looping through a Query in CFSCRIPT
Hi all, Is it possible to loop through the results of a CFQuery structure? and Has anybody got an example of how its done TIA. Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Displaying yes/no field dynamically in checkboxes?
try something like this. Checked > Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: P@tty Ayers [mailto:[EMAIL PROTECTED]] Sent: 03 April 2001 14:22 To: CF-Talk Subject: Displaying yes/no field dynamically in checkboxes? Friends, I would much appreciate any help with a problem I'm stuck on. I'm writing a page that will allow my client to edit a record. I've got it so that the page queries the table and inserts the values from the record specified by the numeric variable passed to it. The numeric fields, text fields and memo fields appear, but I can't figure out how to make the checkboxes display a check when the yes/no field is "yes". Here's my code (below), such as it currently is. UltraDev wrote some of it and I wrote the rest. The first few yes/no fields are "cabinHottub", "cabinJettedtub", "cabinFireplace" and "cabinPets". I would be grateful for any help; thanks very much in advance. P@tty Ayers SELECT * FROM cabinQuery WHERE cabinID = #rsEdit__varcabintoedit# Edit a Record Page Cabin Name: Location (City): Distance from Asheville: Number of Bedrooms: Number of Bathrooms: Sleeps: Hot tub: Jetted tub: Fireplace: Pet-friendly: Nightly Rate: $ Weekly Rate: $ Bedroom 1: Bedroom 2: Bedroom 3: Bedroom 4: Bedroom 5: Sleep Sofa: Loft: Dishwasher: Microwave: Air Conditioning: Stereo/CD Player: TV: VCR: Washer/Dryer: Deck/Porch: Grill: View: Fireplace Style: Description: #cabinsDescription# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Variables not being passed on selected machines
Have you Checked that the form method is set to post? Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 March 2001 11:57 To: CF-Talk Subject: Form Variables not being passed on selected machines All of a sudden, I have a situation where form variables are not being passed to the action template of a fairly basic form. Out of 300 users, I guess a handful of them get an error when the action template tries to evaluate the variables. I've checked the security settings in Explorer and they seem ok. Some have IE4 some have IE5 running on NT4. There is no pattern with the browser version. Any ideas? Craig Wilson Business Analyst Business Applications VOLKSWAGEN FINANCIAL SERVICES (UK) LIMITED Work: +44 (0)1908 485229 Fax:+44 (0)1908 549296 Mail: mailto:[EMAIL PROTECTED] ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT:Converting CFML to WML
Hi All, Is it an easy job to convert CFML pages to WML? Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this possible?
Just done some refining of the code. This will work, as long as you are holding the validation results in a Query. THe previosu version doesn't work because I was assuming that Item2 was an object, but its not its a literal. function Check_Items(Item1,Item2){ if (Item1.value!='') return; if (Item1.value!=Item2){ alert ("These contradict the DB") Item1.focus(); } return; } Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: 26 March 2001 15:34 To: CF-Talk Subject: Is this possible? Hey all, Is it possible to determine what a user has inputted in a form BEFORE the form is submitted? What I would like to do is IF a user makes a selection in the form that conflicts with information already in the db, I want to have a javascript popup alert them to the discrepancy and have them verify if they want to continue. Otherwise, just a regular submit button would be displayed. I have the javascript alert/confirm working alright, but I can't figure out how to get it to check the formfields and only display conditionally. I don't even think this is possible, considering that CF is server-side and essentially what I want to do is have CF determine what was selected BEFORE it is submitted. Is there a way I can determine this with JavaScript (I'm not very good at JS, so "baby steps", please ;). I know I could do this within CF and just have the form submit to an interim confirmation page, but I would rather do this on the client. Thanks! Terri ~~ 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 possible?
what Terri could so is query the DB on loading the page, then validate the answers with a simple JS function. function Check_Items(Item1,Item2){ if (Item1.value!=Item2.value){ alert ("These contradict the DB") Item1.setfocus(); } return; } then in the page this should work, you might have to wrap round a CFOutput, round the Input tag. In theory it should work, give it a try and let me know. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: 26 March 2001 16:00 To: CF-Talk Subject: RE: Is this possible? But Terri wants to compare the client-side form element values to what's in the db. In order to do this, she'll have to get the db info into JS. She could query for the data and then convert it to JS via CFWDDX ACTION=CFML2JS. -David On Monday, March 26, 2001 6:40 AM, Dylan Bromby [SMTP:[EMAIL PROTECTED]] wrote: > yes you can do this. you can reference the form elements by object name. you > don't have to submit the form to validate or check values. you can do it > using onFocus and/or onBlur. > > -Original Message- > From: Terri Stocke [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 26, 2001 6:34 AM > To: CF-Talk > Subject: Is this possible? > > > Hey all, > > Is it possible to determine what a user has inputted in a form BEFORE the > form is submitted? What I would like to do is IF a user makes a selection in > the form that conflicts with information already in the db, I want to have a > javascript popup alert them to the discrepancy and have them verify if they > want to continue. Otherwise, just a regular submit button would be > displayed. > > I have the javascript alert/confirm working alright, but I can't figure out > how to get it to check the formfields and only display conditionally. I > don't even think this is possible, considering that CF is server-side and > essentially what I want to do is have CF determine what was selected BEFORE > it is submitted. Is there a way I can determine this with JavaScript (I'm > not very good at JS, so "baby steps", please ;). > > I know I could do this within CF and just have the form submit to an interim > confirmation page, but I would rather do this on the client. > > Thanks! > Terri > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Status in UK
CF is not as big in the UK as it is in the states, also most companies tend to train there own IT staff in CF as its quite easy to use. If yopu are looking for contract work It might be worth registering with a couple of recruitment agencies, they may well be able to place you much easier and quicker, I would suggest Computer Futures (www.computerfutures.co.uk), mainly becuase they have offices nationwide. I had an interview with Novasoft myself, about a year ago, I wasn't impressed with what they where offering. Good Luck, Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 26 March 2001 09:44 To: CF-Talk Subject: CF Status in UK Hi, Could anybody tell me how is ColdFusion doing in UK? Is it not in demand here now? Actually, I came here in UK from India on 29th Jan., 2001 as a Software Consultant through NovaSoft Info. Tech. (Europe) Ltd. (http://www.novasoftinfo.co.uk and http://www.novasoftinfo.com). They hire Software Professionals from India and place them here on Contract basis. My main skills are ColdFusion. I am having 2 yrs exp. in ColdFusion with SQL, Access, JavaScript, HTML, and Dreamweaver etc. I have developed 10 sites using ColdFusion. Now almost two months have been completed and I am still on Bench. Not only myself, there are other 4 ColdFusion professionals they are also on bench. NovaSoft is not able to place anybody. What they are saying is that there is no market for ColdFusion in UK now and the situation will remain same for next 5-6 months atleast. I have already wasted almost 2 months for the process for coming to UK and 2 months on bench and if the situation is going to remain for next 5-6 months, it is going to spoil my career very badly. Moreover, company might take some harsh decisions also. I am in great dilemma now-a-days. Could you please tell me the status of ColdFusion in UK or could anybody guide me overcoming this problem? Any kind of help/suggestion is welcome. Thanks and Regards, Rajesh Kumar For Valentine's Day shop by Brand, Product, Price, Store and Location! http://shop.storerunner.com/shop.asp?pdef=home&trsid=3080 ~~ 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: Help please
Dont just stick to Web based tools, get to grips with conventional programming languages as well, such as VB, C++, JAVA. and others. Even if its just a matter of installing a standard edition of the software and getting to grips with the syntax and format and quirks of the language. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 15:33 To: CF-Talk Subject: Re: Help please Personally, my advice is to learn everything. That way you can go one way or the other. Makes you available for multiple jobs, as well as some places that need multiple skills. At this point and time, most of the work appears to be in ASP, and there's a healthy chunk of Perl out there. Though you don't wait until you need to a job to learn these skills; it's hard to learn enough fast enough. Always think forwards. "Suggest a way out"? McDonald's is always hiring. :) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Venkata Ramakrishna wrote: > Hi gang, > Iam a Cf guy since 1.5 years.I changed my company > expecting a assignment in US.As the market slowed down > there,my new employer is making me sit at his place. > The problem is that he don't have any CF work and the > other teams wont allow me inside their domain. > > Should i stick with CF or change to some other > domain?Whats the trend at US? > Can someone suggest a way out until the US markets > gear up again? > > Expecting some serious suggestions. > > Thank you. > > Ramakrishna > ~~ 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: Calling Custom Tags in
I thought as much but just wanted to make sure I'd not missed an undocumented feature. Roll on CF5.0!!!!! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 12:51 To: CF-Talk Subject: RE: Calling Custom Tags in > How would you convert the CF_Foo into the cfscript block? You can't. :| You can't use any cf tags within cfscript One of the many limitations of cfscript - which is a shame. --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- > -Original Message----- > From: Jason Lees (National Express) > [mailto:[EMAIL PROTECTED]] > Sent: 23 March 2001 12:59 > To: CF-Talk > Subject: Calling Custom Tags in > > > > Hi All, > > In CF Version 4.5 is it possible to call a custom Tag from with in a > CFScript block > > EG > > > > > > the x^2 = #y# > > How would you convert the CF_Foo into the cfscript block? > > > Jason Lees > National Express > Email : [EMAIL PROTECTED] > > ### > This document is intended for, and should only be read by, > those persons to > whom it is addressed. Its contents are confidential and if > you have received > this message in error, please notify us immediately by > telephone on 0121 609 6301 > and delete all records of the message from your computer. Any > form of reproduction, > dissemination, copying, disclosure, modification, > distribution and / or > publication of this message without our prior written consent > is strictly > prohibited. Neither the author of this message nor their > employers accept > legal responsibility for the contents of the message. Any > views or opinions > presented are solely those of the author. > If you have any queries please contact > [EMAIL PROTECTED] > > ## > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Calling Custom Tags in
Hi All, In CF Version 4.5 is it possible to call a custom Tag from with in a CFScript block EG the x^2 = #y# How would you convert the CF_Foo into the cfscript block? Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [EMAIL PROTECTED] ## ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: loop in
Sorry I've had my 'C++' and Java hat on recently and forgot that CF doesnt like the k++. My fault. use k=k+1 and replace 0 with 1, should work then. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]] Sent: 22 March 2001 16:02 To: CF-Talk Subject: RE: loop in It won't work, besides, for CF, array start with 1 not 0. Thanks though. Mei -Original Message----- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 10:45 AM To: CF-Talk Subject: RE: loop in cant you use a arrayYes=Arraynew(1); for (k=0;k lte varlength;k++) arrayYes[k]=(#SomeNum[k]#/#othernum[k]#)*100; Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]] Sent: 22 March 2001 15:33 To: CF-Talk Subject: loop in Can someone please tell me where I can find the resource about how to loop inside instead of ? My problem is: I have use the combination of arrayYes = ArrayNew(1); // someNum and otherNum has been defined and assigned values in the same pages before with template, but when I run it, it says: can not convert number... // when I look up CF book, it says, 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: loop in
cant you use a arrayYes=Arraynew(1); for (k=0;k lte varlength;k++) arrayYes[k]=(#SomeNum[k]#/#othernum[k]#)*100; Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]] Sent: 22 March 2001 15:33 To: CF-Talk Subject: loop in Can someone please tell me where I can find the resource about how to loop inside instead of ? My problem is: I have use the combination of arrayYes = ArrayNew(1); // someNum and otherNum has been defined and assigned values in the same pages before with template, but when I run it, it says: can not convert number... // when I look up CF book, it says, 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: HTML problem
Try the reverse, Ie make the image 1024x768 then use HTML to shrink to 800x600. This should solve the problem, it may be a little blured I'm not sure. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: 22 March 2001 08:22 To: CF-Talk Subject: HTML problem Hi All, This is not a javascript or coldfusion question, but i thought someone might be able to help and/or suggest something. I'm creating this web page, that our graphics designer has already designed using photoshop for 800X600 resolution. He cut up the images using Fireworks and has given them to me. Now our problem is this: We want the images to enlarge to fit to screen when we use a higher resolution. What i did was i put them in a table and made the table width 100% so that it fits to screen. When i did that the table stretched to fit to screen but the images stayed the same size and i had these big white gaps inbetween each image. I then tried specifying the images width=100% so that it can stretch as well. What happened was it did stretch but the resolution went way down and the images were really fuzzy. So, my question is, is there a way to get the images to stretch but still stay clear? or does our graphics designer have to redo the images with a higher resolution in mind? Thanks! Heidi = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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: Previous date
use the function CreateTimeSpan Yesterday=DateFormat(Now()-CreatetimeSpan(1,0,0,0),"MM/DD/YY") Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: monika kon [mailto:[EMAIL PROTECTED]] Sent: 21 March 2001 16:03 To: CF-Talk Subject: Previous date Hi ! Can any one please tell me how can I display the previous date. For example if today is '03/21/01' then I have to display '03/20/01'. Is there any function which I can use. Shally ~~ 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: Win2k
So Far we've not had any problems with the CF on a Win2k server (+1Month), but the hits are quiet low. However I've seen posts from others on the lists that have noted problems though. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 21 March 2001 15:31 To: CF-Talk Subject: Win2k Anyone had any experience of Coldfusion (proffesional) running on a 2K server ? We're thinking of moving to that from NT4, and was wundering if there were any issues (speed, lag etc.) that would make this a Good Thing, or weather it all just gets rosy and faster ? Regards, Thomas Chiverton, Intranet Architect and Desktop Analyst Office: 01565 757 909 As a GUI, reality in useless... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [RE: To ASP or not to ASP]
Why not take the best of both worlds and cerate templates that use CF and ASP!! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: 21 March 2001 15:24 To: CF-Talk Subject: RE: [RE: To ASP or not to ASP] Especially if they live in Trinidad where most IT firms don't even know what COld Fusion is :) -Gel www.carigamer.com -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Anyone who relies solely on CF for marketability is in trouble already. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can we do another select on a cfquery resultset?
as far as I'm aware this facility is Only available in CF5.0, unless you loop through the entire collection. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: 21 March 2001 12:54 To: CF-Talk Subject: Can we do another select on a cfquery resultset? hi i was juz wondering if it is possible to do a select on the resultset returned from ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfloop
Have you tried Or use a CFLoop http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#&data=#data #&zoom=#zoom#&x=#qry_getVeichle.lon#&y=#qry_getVeichle.lat#&symbol=#qry_getV eichle.lon#,#qry_getVeichle.lat#,target,#callsign#"> Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 16:19 To: CF-Talk Subject: cfloop >From a select box I am selecting a single vehicle or all vehicles and pass the parameter to a second template which determines my vairables type of existence, SELECT callsign, vowner, dt, Lat, Lon, Speed, Direction, Veh_Reg FROMdbo.vehicles WHERE vowner = 222 SELECT callsign, vowner, dt, Lat, Lon, Speed, Direction, Veh_Reg FROMdbo.vehicles WHERE callsign = '#form.callsign#' Then I am passing to a second server to get the vehicle positioning, I wanted to do this the proper way with cfhttp, but due to buggy problems with 4.5.1 and cfhttp I have done it this way, http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#&data=#data #&zoom=#zoom#&x=#qry_getVeichle.lon#&y=#qry_getVeichle.lat#&symbol=#qry_getV eichle.lon#,#qry_getVeichle.lat#,target,#callsign#"> This is fine for one vehicle, but for multable I still only get the first vehicle in the recordset, even though I loop through my query for the existence of all. If I test my looped query like so, http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#&data=#data #&zoom=#zoom#&x=#qry_getVeichle.lon#&y=#qry_getVeichle.lat#&symbol=#qry_getV eichle.lon#,#qry_getVeichle.lat#,target,#callsign#"> the obvious happens I get multable vehieles displayed but on multible maps, (I know, duuu!!) so I think that my problem lies somewhere around startrow="#start#" endrow="#max#" which works fine when outputting to html or else the problems with the 'mapview.exe' which would be a completely different issue. If some one could send me in the right direction with my cfloop though, it would be mighty appreciated. Thanx world.. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Converting Docs and Powerpoint files to html or pdf using CF?
You can always run them through dreamweaver before commiting them to disk (esp the word files). Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: 07 March 2001 14:37 To: CF-Talk Subject: Re: Converting Docs and Powerpoint files to html or pdf using CF? > If they are using Word or Powerpoint 2000 all they have to do si save the > file as an HTML file. Have you ever looked at the quality of the code that method generates? ~~ 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