I have 6 GMAIL invitations too.
If you want GMAIL, just respond off-list to this address.If you respond on-list I wont give them to you. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT:i have 6 Gmail invite
Hi all sorry to post thiw message in CF_talk ,i mailed to Michael regarding the invite ,so far i did't get any mail .so i am posting it here ,please reply to me offlist to [EMAIL PROTECTED] regards Vishnu Prasad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Auto-Login
On Thu, 2 Sep 2004 12:24:25 -0400, Dave Watts [EMAIL PROTECTED] wrote: If you're using Windows and Internet Explorer on your client machines, and IIS on your server, and the clients and server are within the same domain, you can configure IE to automatically provide domain login credentials to IIS, which can then be accessed via CGI or CFLOGIN within CFMX. Can you not do this now with Firefox as well? I'm pretty sure this is what we're doing at work. I'll have to check on Monday... -- Kay Smoljak http://kay.smoljak.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Anyone looking for a java WYSIWYG online textarea replacement...
On Thu, 2 Sep 2004 14:18:16 -0500, Marlon Moyer [EMAIL PROTECTED] wrote: Found this one this morning.I have to say, it is pretty small. http://www.kevinroth.com/rte/demo.htm Unfortunately, this one doesn't create standards-compliant html. -- Kay Smoljak http://kay.smoljak.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
XML Testing
How do you test to see if an XML variable is defined or not?I have tried IsDefined, but it errors out. Basically I am testing to see if the XML code has an error block, if everything is fine,this variable is NOT valid #xmlresponse.error.err.xmlText#IF there is a problem, it is and it is the error response code.So what I would like to do is FIRST check to see if this variable exists ... Any suggestions? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: XML Testing
you can use isdefeind(xmlresponse.error.err.xmlText) (remeber this stuff is picky about case so make sure case is right) Or if you will have multiple errors you might try cfset errors = xmlsearch(xmlresponse,//err) cfloop from=1 to=#arraylen(errors)# index=idx /cfloop Adam H On Sun, 5 Sep 2004 10:54:53 -0500, Paul Giesenhagen [EMAIL PROTECTED] wrote: How do you test to see if an XML variable is defined or not?I have tried IsDefined, but it errors out. Basically I am testing to see if the XML code has an error block, if everything is fine,this variable is NOT valid #xmlresponse.error.err.xmlText#IF there is a problem, it is and it is the error response code.So what I would like to do is FIRST check to see if this variable exists ... Any suggestions? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: XML Testing
Hi. You can use the StructKeyExists as the example below shows. cfscript myXMLDocument = XmlParse(cfhttp.fileContent); selectedElements = XmlSearch(myXMLDocument, /rdf:RDF/:item); noItems = ArrayLen(selectedElements); for(index = 1;index lt noItems;index = index + 1) { if(StructKeyExists(selectedElements[index],description)) . if exists code else . else exists code } cfscript Andrew - Original Message - From: Adam Haskell [EMAIL PROTECTED] Date: Sun, 5 Sep 2004 09:05:06 -0700 Subject: Re: XML Testing To: CF-Talk [EMAIL PROTECTED] you can use isdefeind(xmlresponse.error.err.xmlText) (remeber this stuff is picky about case so make sure case is right) Or if you will have multiple errors you might try cfset errors = xmlsearch(xmlresponse,//err) cfloop from=1 to=#arraylen(errors)# index=idx /cfloop Adam H On Sun, 5 Sep 2004 10:54:53 -0500, Paul Giesenhagen [EMAIL PROTECTED] wrote: How do you test to see if an XML variable is defined or not?I have tried IsDefined, but it errors out. Basically I am testing to see if the XML code has an error block, if everything is fine,this variable is NOT valid #xmlresponse.error.err.xmlText#IF there is a problem, it is and it is the error response code.So what I would like to do is FIRST check to see if this variable exists ... Any suggestions? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
I have 6 gmail invites, email me OFF-LIST for an invite.
DO NOT REPLY TO THIS EMAIL!!! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Auto-Login
Can you not do this now with Firefox as well? I'm pretty sure this is what we're doing at work. I'll have to check on Monday... I don't know about Firefox; I'm using Mozilla 1.7. With Mozilla, you can send usernames and passwords to IIS sites using Windows Authentication, but you have to type them in - it won't automatically use your local login information as IE will. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- netstat report
You were right, none of those PC from internal network can access the website with domain. but if you are right about the another DNS server for internal requests, how it was working fine before. I never added the domains in the host file before. and as soon as website is up, it was opening from all the pcs on network, and there was no DNS that time either. thanks Can you use the domain names on other PCs on the network and see the sites properly? Here, we're behind a firewall using NAT... port forwarding... Presently, I cannot use domain nameswith other PCs on the network. If I do, I just get the firewall box. But the external world has access without trouble. (I'm waiting for this to be fixed) I was told we needed another DNS server to serve internal requests. As I am not the network admin, I have not resolved this problem. So, on the webserver here, I cannot access the site by domain name, even if I'm on the server (the actual box the request comes to) because of the NAT box. Just thought I would throw that out there... Yves - Original Message - From: Asim Manzur [EMAIL PROTECTED] Date: Fri, 03 Sep 2004 09:40:23 -0400 Subject: Re: OT- netstat report To: CF-Talk [EMAIL PROTECTED] Yes I ping the domain from the same machine, and got response. I ping the external static ip, got response. I ping the internal ip, got response. I ping the computer name, got response. infact I ping outside the network and got response as well. thanks On Friday 03 Sep 2004 13:10 pm, Asim Manzur wrote: If I open it as a localhost from the same machine, yes then the website opened, but if I open it with domain, the website is not getting open from this machine, and rest of the world can open. Check the DNS. Can this machine 'ping' it's own real world address (as both an IP and a name) ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Fusebox
if you want fb4 tutorials, check my blog out, http://www.beynon.org.uk/index.cfm?fuseaction=blog.showmode=catcatid=8C3B9E31-802D-00D5-73ADB5D764E60C74 i have started a series of LearnFB articles starting from the most basic, only up to lesson3 at the moment - more will follow shortly, and i'll be publishing updated fusebox4.1 version when it's released, and when i'm back from the conference in 2 weeks!!! :) jb. On Sat, 4 Sep 2004 21:36:00 -0700, Dick Applebaum [EMAIL PROTECTED] wrote: This is very good advice. The only thing I would add is that standards are empowering, and they are, by their nature limiting [of creativity]. But, having used a standard [fusebox] you have realized beneits, and you are in a advantageous position to migrate to its [r]evolutionary replacement. Stated more explicitly, [the standards] ASCII, BASIC, ForTran and CoBOL (and the 8080 CPU) have created he shoulders upon which we stand today (with mini-revolutions from NCR, ALWAC, Xerox, Amiga and Apple). Exploit a standard for what it is -- but do not be mesmerized by it! Dick On Sep 4, 2004, at 8:28 PM, Steven Brownlee wrote: Andrew: It is better to use {insert methodology here} because of the standards, protocols and consistency that it provides to all of the developers of your application.{insert methodology here} is NOT inherently better than a system that you come up with on your own, it simply saves you time in two areas.First, you don't have to waste huge amounts of time designing and documenting your own application coding practices.Secondly, using {insert methodology here} can drastically reduce the time and money spent training a new memeber of the development team.Assuming that the new developer knows {insert methodology here}, of course.Most any deeply experienced architect - not just a developer - will tell you that any methodology is better than having none.Developers are the ones that will defend their choice with religious zeal.As a consultant on many projects using a vast array of coding languages, I strongly assert that a company that adheres even to the most simple of standards is way ahead of the game. My personal favorites are: Mach II - http://www.mach-ii.com/ cfObjects - https://sourceforge.net/projects/cfobjects/ Fusebox - http://www.fusebox.org/ _ From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: Friday, September 03, 2004 6:43 PM To: CF-Talk Subject: Fusebox Hi Everyone. We are just about to start a major new project, well actually a complete upgrade from the ground up of an old project, but I have been looking at doing it in a much more structured way and I wanted some opinion about using Fusebox. We have never used it before, but we are all highly experienced CF programmers (5+ years). What I'm really looking for is some explaining of why it is better to use the Fusebox method than just straight forward CF. Also, can anyone point me in the direction of a good online introduction to Fusebox as there doesn't seem to be much on the Fusebox website. Thanks Andrew. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Calling a .Net control from ColdFusion
Hi Josen, We might have another solution for you. What if you could use CFML tags directly in ASP.NET pages? Put another way, what if you could turn any CFML page into an ASP.NET page simply by changing the .cfm extension to .aspx? Then you could mix .NET controls and CFML code in the same page, which is what I think you really want, the only difference is they'd have the .aspx extension instead of .cfm. Is this something you'd be interested in? Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Vince Bonfanti [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 7:16 PM To: CF-Talk Subject: RE: Calling a .Net control from ColdFusion You can use BlueDragon for .NET and then include ASPX pages that contain custom controls from CFML like this (note the use of the PAGE attribute instead of TEMPLATE): cfinclude page=RoundedCorners.aspx Or, you can do it from CFSCRIPT like this: cfscript GetPageContext.include( RoundedCorners.aspx ); /cfscript It's not the same as call the .NET control directly, but it's probably as close as you're going to get. The technology preview release of BlueDragon.NET is available for download from here: http://www.newatlanta.com/products/bluedragon/index.cfm Something else cool you'll be able to do with BlueDragon.NET (but that's not in the technology preview) is include CFML pages from ASPX pages, like this: cf:include template=myInclude.cfm runat=server/ Or, you'll be able to invoke CFML custom tags from within ASPX pages like this: cf:module name=myTags.myCustomTag runat=server/ You'll be able to nest CFML custom tag calls and use the CFASSOCIATE tag just as you normally would. Or, how about invoking CFCs from within ASPX pages: cf:object component=myComponent variable=myCfc runat=server/ cf:invoke component=#myCfc# method=myMethod runat=server/ The point is, if you'll developed your CFML based on reusable components such as CFINCLUDE, CFML custom tags, and CFCs, you can resue those components from ASPX pages. This will allow you to write ASPX pages using all the great custom controls they've created, and still use most of your existing CFML. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Josen Ruiseco [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 3:51 PM To: CF-Talk Subject: Calling a .Net control from ColdFusion I found a very cool .net control here: http://scottonwriting.net/demos/RoundedCorners.aspx and want to use the functionality of it in my cf pages. Is it possible to call a .net control and use it within coldFusion and if so, how? If not possible, does anyone know of any cf component that does this? Josen GoMotorBids.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Fusebox
Hi John. Thanks for the point, but I already found them and completed all three. Anyone else how is looking, these are excellent tutorial, very easy to follow and I would recommend them highly. Andrew. - Original Message - From: John Beynon [EMAIL PROTECTED] Date: Sun, 5 Sep 2004 19:27:01 +0100 Subject: Re: Fusebox To: CF-Talk [EMAIL PROTECTED] if you want fb4 tutorials, check my blog out, http://www.beynon.org.uk/index.cfm?fuseaction=blog.showmode=catcatid=8C3B9E31-802D-00D5-73ADB5D764E60C74 i have started a series of LearnFB articles starting from the most basic, only up to lesson3 at the moment - more will follow shortly, and i'll be publishing updated fusebox4.1 version when it's released, and when i'm back from the conference in 2 weeks!!! :) jb. On Sat, 4 Sep 2004 21:36:00 -0700, Dick Applebaum [EMAIL PROTECTED] wrote: This is very good advice. The only thing I would add is that standards are empowering, and they are, by their nature limiting [of creativity]. But, having used a standard [fusebox] you have realized beneits, and you are in a advantageous position to migrate to its [r]evolutionary replacement. Stated more explicitly, [the standards] ASCII, BASIC, ForTran and CoBOL (and the 8080 CPU) have created he shoulders upon which we stand today (with mini-revolutions from NCR, ALWAC, Xerox, Amiga and Apple). Exploit a standard for what it is -- but do not be mesmerized by it! Dick On Sep 4, 2004, at 8:28 PM, Steven Brownlee wrote: Andrew: It is better to use {insert methodology here} because of the standards, protocols and consistency that it provides to all of the developers of your application.{insert methodology here} is NOT inherently better than a system that you come up with on your own, it simply saves you time in two areas.First, you don't have to waste huge amounts of time designing and documenting your own application coding practices.Secondly, using {insert methodology here} can drastically reduce the time and money spent training a new memeber of the development team.Assuming that the new developer knows {insert methodology here}, of course.Most any deeply experienced architect - not just a developer - will tell you that any methodology is better than having none.Developers are the ones that will defend their choice with religious zeal.As a consultant on many projects using a vast array of coding languages, I strongly assert that a company that adheres even to the most simple of standards is way ahead of the game. My personal favorites are: Mach II - http://www.mach-ii.com/ cfObjects - https://sourceforge.net/projects/cfobjects/ Fusebox - http://www.fusebox.org/ _ From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: Friday, September 03, 2004 6:43 PM To: CF-Talk Subject: Fusebox Hi Everyone. We are just about to start a major new project, well actually a complete upgrade from the ground up of an old project, but I have been looking at doing it in a much more structured way and I wanted some opinion about using Fusebox. We have never used it before, but we are all highly experienced CF programmers (5+ years). What I'm really looking for is some explaining of why it is better to use the Fusebox method than just straight forward CF. Also, can anyone point me in the direction of a good online introduction to Fusebox as there doesn't seem to be much on the Fusebox website. Thanks Andrew. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Calling a .Net control from ColdFusion
Is that something that blueDragon does?Sounds good! Vince Bonfanti wrote: Hi Josen, We might have another solution for you. What if you could use CFML tags directly in ASP.NET pages? Put another way, what if you could turn any CFML page into an ASP.NET page simply by changing the .cfm extension to .aspx? Then you could mix .NET controls and CFML code in the same page, which is what I think you really want, the only difference is they'd have the .aspx extension instead of .cfm. Is this something you'd be interested in? Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Vince Bonfanti [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 7:16 PM To: CF-Talk Subject: RE: Calling a .Net control from ColdFusion You can use BlueDragon for .NET and then include ASPX pages that contain custom controls from CFML like this (note the use of the PAGE attribute instead of TEMPLATE): cfinclude page=RoundedCorners.aspx Or, you can do it from CFSCRIPT like this: cfscript GetPageContext.include( RoundedCorners.aspx ); /cfscript It's not the same as call the .NET control directly, but it's probably as close as you're going to get. The technology preview release of BlueDragon.NET is available for download from here: http://www.newatlanta.com/products/bluedragon/index.cfm Something else cool you'll be able to do with BlueDragon.NET (but that's not in the technology preview) is include CFML pages from ASPX pages, like this: cf:include template=myInclude.cfm runat=server/ Or, you'll be able to invoke CFML custom tags from within ASPX pages like this: cf:module name=myTags.myCustomTag runat=server/ You'll be able to nest CFML custom tag calls and use the CFASSOCIATE tag just as you normally would. Or, how about invoking CFCs from within ASPX pages: cf:object component=myComponent variable=myCfc runat=server/ cf:invoke component=#myCfc# method=myMethod runat=server/ The point is, if you'll developed your CFML based on reusable components such as CFINCLUDE, CFML custom tags, and CFCs, you can resue those components from ASPX pages. This will allow you to write ASPX pages using all the great custom controls they've created, and still use most of your existing CFML. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Josen Ruiseco [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 3:51 PM To: CF-Talk Subject: Calling a .Net control from ColdFusion I found a very cool .net control here: http://scottonwriting.net/demos/RoundedCorners.aspx and want to use the functionality of it in my cf pages. Is it possible to call a .net control and use it within coldFusion and if so, how? If not possible, does anyone know of any cf component that does this? Josen GoMotorBids.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Calling a .Net control from ColdFusion
It's something we're working on that should be available in the BlueDragon 6.2 public beta to be released later this month. (BlueDragon 6.2 is primarily for delivering BlueDragon.NET, but will also include an update to the Java editions). Vince _ From: Josh [mailto:[EMAIL PROTECTED] Sent: Sunday, September 05, 2004 4:15 PM To: CF-Talk Subject: Re: Calling a .Net control from ColdFusion Is that something that blueDragon does?Sounds good! Vince Bonfanti wrote: Hi Josen, We might have another solution for you. What if you could use CFML tags directly in ASP.NET pages? Put another way, what if you could turn any CFML page into an ASP.NET page simply by changing the .cfm extension to .aspx? Then you could mix .NET controls and CFML code in the same page, which is what I think you really want, the only difference is they'd have the .aspx extension instead of .cfm. Is this something you'd be interested in? Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Vince Bonfanti [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 7:16 PM To: CF-Talk Subject: RE: Calling a .Net control from ColdFusion You can use BlueDragon for .NET and then include ASPX pages that contain custom controls from CFML like this (note the use of the PAGE attribute instead of TEMPLATE): cfinclude page=RoundedCorners.aspx Or, you can do it from CFSCRIPT like this: cfscript GetPageContext.include( RoundedCorners.aspx ); /cfscript It's not the same as call the .NET control directly, but it's probably as close as you're going to get. The technology preview release of BlueDragon.NET is available for download from here: http://www.newatlanta.com/products/bluedragon/index.cfm Something else cool you'll be able to do with BlueDragon.NET (but that's not in the technology preview) is include CFML pages from ASPX pages, like this: cf:include template=myInclude.cfm runat=server/ Or, you'll be able to invoke CFML custom tags from within ASPX pages like this: cf:module name=myTags.myCustomTag runat=server/ You'll be able to nest CFML custom tag calls and use the CFASSOCIATE tag just as you normally would. Or, how about invoking CFCs from within ASPX pages: cf:object component=myComponent variable=myCfc runat=server/ cf:invoke component=#myCfc# method=myMethod runat=server/ The point is, if you'll developed your CFML based on reusable components such as CFINCLUDE, CFML custom tags, and CFCs, you can resue those components from ASPX pages. This will allow you to write ASPX pages using all the great custom controls they've created, and still use most of your existing CFML. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Josen Ruiseco [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 3:51 PM To: CF-Talk Subject: Calling a .Net control from ColdFusion I found a very cool .net control here: http://scottonwriting.net/demos/RoundedCorners.aspx and want to use the functionality of it in my cf pages. Is it possible to call a .net control and use it within coldFusion and if so, how? If not possible, does anyone know of any cf component that does this? Josen GoMotorBids.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT - farcry CMS
Hi sorry for SOT... Anybody know how to run multiple sites inside only one Farcry installation? Thanx [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SOT - farcry CMS
Go to http://farcry.daemon.com.au/ and subscribe to the Far Cry list - you should get some help there. ++ Kevin Parker Web Services Manager WorkCover Corporation p: 08 8233 2548 m: 0418 806 166 e: [EMAIL PROTECTED] w: www.workcover.com ++ -Original Message- From: Marco Antonio C. Santos [mailto:[EMAIL PROTECTED] Sent: Monday, 6 September 2004 7:17 AM To: CF-Talk Subject: SOT - farcry CMS Hi sorry for SOT... Anybody know how to run multiple sites inside only one Farcry installation? Thanx _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Circuit Mapping Error
I'm trying to take my circuit structures and hard code them in order to test the speed difference (since I've heard this can dramatically increases the speed of 'some' apps) but keep getting the following error and I'm stumped..Oh btw, I'm using the updated fuseQ fileset. Error Diagnostic Information--- An error occurred while evaluating the _expression_: fusebox.currentPath = techspedition_.Circuits.PhysicalPath[fusebox.homecircuit Error near line 290, column 8. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Circuit Mapping Error
Let's try that againabout half of my message(including the link) was truncated for whatever reason ... *fingers crossed* I'm trying to take my circuit structures and hard code them in order to test the speed difference (since I've heard this can dramatically increases the speed of 'some' apps) but keep getting the following error and I'm stumped..Oh btw, I'm using the updated fuseQ fileset. Error Diagnostic Information--- An error occurred while evaluating the _expression_: fusebox.currentPath = techspedition_.Circuits.PhysicalPath[fusebox.homecircuit Error near line 290, column 8. You can see the working structure and my failed attempt here... http://www.cwc.co.nz/broken_circuit_mapping.txt I don't see any typos or errors, and certainly nothing that would cause this. I've also tried replacing C:/inetpub/wwwroot with the REAL physical path of this app I.E. D:\[path to domain here]\cwc.co.nz\intranet to no avail. Any ideas All help greatly appreciated TIA Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
escaping character
Hi - I am trying to insert a string as text into an access db, but I having trouble, as the string includes a character. The query in my debug screen looks like this: INSERT INTO scripts ( SRXNO, SDISPDATE, PTITLE, PFIRSTNAME, PSURNAME, PADDRESS, PSUBURB, PPOSTCODE, PMEDICARE, PMEDICDATE, PCONCTYPE, PCONCNO, PCONCVDATE, PSAFENTNO, PREPATNO, SDOCPRESNO, SDOCNAME, SDRUGDESC, SALTDESC, SQTY, SAUTHORITY, SSIGS, SWARDNO ) VALUES ( '', '21-Jul-04', 'MR', 'x', 'xx', 'xxx', 'x', 'x', 'xx', 'x', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', '', x', 'BLEOMYCIN (BL) INJ 15', '000 i.u.', --- this is where my problem is, the text string that should be here is: BLEOMYCIN (BL) INJ 15000 i.u. 'BLEOMYCIN SULFATE', '2', 'FALSE', 'for 21/7' ) I am importing into an access db from a csv file supplied from a pharmacy, so I cannot choose the formatting of this data, this is what I have to work with. I just don't know what it is breaking the string at the '000 i.u. I can only assume it is because the string has double quotes in it Thanks in advance. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping character
Actually - I have just found the issue. I am using the listfix udf :- http://www.cflib.org/udf.cfm/listfix The problem is that, the string I was trying to insert actually has a single comma in the csv file:- BLEOMYCIN (BL) INJ 15,000 i.u. Is there anyway to exclude listfix from picking this up as a separate field ?? My code is: cffile action="" file=#ExpandPath('/pharma/uploads')#/Book1.csv variable=csvData !--- cfset csvData = Replace(csvData, ,,, , ,, ALL) --- cfset csvData = #listfix(csvData)# Should I be using the commented code instead Thanks again The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Displaying a dynamic map - how?
I have a prospective client - a real estate developer who has a subdivision we're proposing a site for. He wants a map of his subdivision and wants to have the colours of the various blocks change depending on their sale status showing in a query when the page is called. (i.e. sold, available,on holding deposit etc). What's the best way to be changing the colours of the blocks, given that they're not rectangular and all different sizes? Before you yell FLASH REMOTING!it's CF5.0 only, not CFMX so flash remoting isn't an option. IS DHTML a way to go here, with layers changing colour based on the value of the 'status' field?or perhaps CSS? How would you do it in flash without using remoting? Any ideas? -- Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Displaying a dynamic map - how?
You could still do it in flash and cf using the loadVars() function. ?? Ricardo Mike Kear wrote: I have a prospective client - a real estate developer who has a subdivision we're proposing a site for. He wants a map of his subdivision and wants to have the colours of the various blocks change depending on their sale status showing in a query when the page is called. (i.e. sold, available,on holding deposit etc). What's the best way to be changing the colours of the blocks, given that they're not rectangular and all different sizes? Before you yell FLASH REMOTING!it's CF5.0 only, not CFMX so flash remoting isn't an option. IS DHTML a way to go here, with layers changing colour based on the value of the 'status' field?or perhaps CSS? How would you do it in flash without using remoting? Any ideas? -- Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Displaying a dynamic map - how?
You can use Remoting in CF 5.0 - but you'd have to buy it.There are also several other methods to transfer information to Flash - you can use loadvars, pass in information as URL variables or as attributes in the Flash call in your HTML. Depending how irregular the patterns are you might be able to get away with DHTML.I've done this two ways in the past: 1) Instead of changing the color of the whole shape just pick a highlight color (in this it might be the roads or the homes for example, not the whole block).You can then make that part of the image transparent and let a settable background color show through.This is nice if the shapes are regular enough to allow for things not to overlap much. From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Monday, September 06, 2004 12:46 AM To: CF-Talk Subject: Displaying a dynamic map - how? I have a prospective client - a real estate developer who has a subdivision we're proposing a site for. He wants a map of his subdivision and wants to have the colours of the various blocks change depending on their sale status showing in a query when the page is called. (i.e. sold, available,on holding deposit etc). What's the best way to be changing the colours of the blocks, given that they're not rectangular and all different sizes? Before you yell FLASH REMOTING!it's CF5.0 only, not CFMX so flash remoting isn't an option. IS DHTML a way to go here, with layers changing colour based on the value of the 'status' field?or perhaps CSS? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]