Element DSN.USERS is undefined in THIS
Hello,
I have this call:
cfset APPLICATION.objects.db =
CreateObject('component','components.db').init(dsn_users='users',dsn_guestbook=guestbook,dsn_irama=irama,maxStringLength=25)
This is the method definition:
cffunction name=init access=public output=no returntype=any
cfargument name=dsn_users required=false default=users
cfargument name=dsn_guestbook required=false default=guestbook
cfargument name=dsn_irama required=false default=irama
cfargument name=maxStringLength required=false default=25
cfset this.dsn.users=#arguments.dsn_users#
cfset this.dsn.guestbook=#arguments.dsn_guestbook#
cfset this.dsn.irama=#arguments.dsn_irama#
cfset this.maxStringLength=#arguments.maxStringLength#
cfreturn this
/cffunction
When later I call another method in this cfc and refer to the value of
this.dsn.users I get the errormessage:
Element DSN.USERS is undefined in THIS
Strange because:
a) I set the value of this.dns. in the init method _and_ return it;
b) the init method has a returnvalue of any (path.of.component or this
gives same result);
c) when cfdumping the variable that holds the reference to the cfc it is not
empty - all the methods are there. Seems like it's lost it's instance data...
Does anybody know whats wrong here?
Thanks,
Marc
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303813
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Element DSN.USERS is undefined in THIS
Try putting cfset THIS.DSN = StructNew() before the other variable
assignments.
On Sun, Apr 20, 2008 at 5:14 PM, marc -- [EMAIL PROTECTED] wrote:
Hello,
I have this call:
cfset APPLICATION.objects.db =
CreateObject('component','components.db').init(dsn_users='users',dsn_guestbook=guestbook,dsn_irama=irama,maxStringLength=25)
This is the method definition:
cffunction name=init access=public output=no returntype=any
cfargument name=dsn_users required=false default=users
cfargument name=dsn_guestbook required=false default=guestbook
cfargument name=dsn_irama required=false default=irama
cfargument name=maxStringLength required=false default=25
cfset this.dsn.users=#arguments.dsn_users#
cfset this.dsn.guestbook=#arguments.dsn_guestbook#
cfset this.dsn.irama=#arguments.dsn_irama#
cfset this.maxStringLength=#arguments.maxStringLength#
cfreturn this
/cffunction
When later I call another method in this cfc and refer to the value of
this.dsn.users I get the errormessage:
Element DSN.USERS is undefined in THIS
Strange because:
a) I set the value of this.dns. in the init method _and_ return it;
b) the init method has a returnvalue of any (path.of.component or this
gives same result);
c) when cfdumping the variable that holds the reference to the cfc it is not
empty - all the methods are there. Seems like it's lost it's instance data...
Does anybody know whats wrong here?
Thanks,
Marc
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303814
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8.0 clustering - quick question.
I think one requirement for session replication is to turn on J2EE sessions - do you have that on? On Sat, April 19, 2008 13:30, WebSite CFtalk wrote: Hello, I'm struggling with a cluster setup. (IIS6/CF8, 2 servers with 2 instances each) The problem is session replication - tons of errors regarding session replication failed in the logs: 19/04 19:01:40 error Setup of session replication failed. [2]java.io.StreamCorruptedException: unexpected end of block data And a lot of these: 19/04 19:01:40 error unexpected end of block data java.io.StreamCorruptedException: unexpected end of block data As soon as I turn off session replication the errors disappear. This also happens when running a cluster with 2 instances on one server - i.e. no network trouble. One thing is unclear (or obvious?..) in the references I've found: Should the jndi ports and proxy ports be different on each server instance, or should they be the same all over? Anyone? Thanks, Helge ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303815 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Element DSN.USERS is undefined in THIS
If that was the problem an error would be thrown at the line where THIS.DSN.USERS is set... Anyway, I tried it and it's not making a difference. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303816 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Element DSN.USERS is undefined in THIS
If that was the problem an error would be thrown at the line where THIS.DSN.USERS is set... Anyway, I tried it and it's not making a difference. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303817 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFchart and IE
I'm having a problem with charts not displaying in IE and I saw there is a hotfix. Has anyone here had experience of using this hotfix? Did you have any side effects? TIA, Jenny ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303818 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Element DSN.USERS is undefined in THIS
Did you reset the Application scope afterwards? On Sun, Apr 20, 2008 at 7:23 PM, marc -- [EMAIL PROTECTED] wrote: If that was the problem an error would be thrown at the line where THIS.DSN.USERS is set... Anyway, I tried it and it's not making a difference. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8.0 clustering - quick question.
You also need to name your instances uniquely. Even if you just copied the ear/war file, the instance names in the Enterprise Admin (JRun admin) cannot match. Just another thing to check. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303820 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Element DSN.USERS is undefined in THIS
Oops, sorry for the doubleposting... I thought I'd add the line that produces the actual error: cffunction name=getRequests access=public returntype=struct cfargument name=orderby required=false default=dateaccess cfargument name=orderdir required=false default=DESC cfquery name=qLog datasource=#VARIABLES.dsn.users# /cffunction ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303821 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Element DSN.USERS is undefined in THIS
cfquery name=qLog datasource=#VARIABLES.dsn.users# That says, VARIABLES.dsn.users, not THIS.dsn.users correct? They are two different scopes. The VARIABLES scope is private to the component, the this scope is public. Chances are you want to set everything in the VARIABLES scope rather than the THIS scope. HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303822 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Element DSN.USERS is undefined in THIS
Ok, that was the problem! Just before where I do a call to the function in the cfc I did a cfinvoke and called on the resultvar of that operation. The init() method had not been invoked. I did this because Godaddy is not supporting Createobject() so I had to rewrite parts of the app and obviously didn't bother to rewrite all... :S Anyway thanks for pointing me to this! Marc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303823 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Element DSN.USERS is undefined in THIS
marc, I always init() my cfc's like this: cffunction name=init access=public returntype=someDAO output=false hint=Returns an instance of the CFC initialized with the correct settings. cfargument name=dsn cfset variables.dsn = arguments.dsn cfreturn this /cffunction VARIABLES.dsn is always available in any methods for me. I don't know about your specific problem tho. HTH, Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303824 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion 8.0 clustering - quick question.
Yes, It's on, I've been through every setting on the servers that I can think of - and everything I've found on different blogs. Have also tried to tweak TCP settings as described on some forums: http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/c om.ibm.websphere.express.doc/info/exp/ae/tprf_tunewindows.html I give up for now, no session replication for me yet.. lol If I find out something I'll post back Thanks Helge -Original Message- From: Maureen Barger [mailto:[EMAIL PROTECTED] Sent: 20. april 2008 13:20 To: CF-Talk Subject: Re: ColdFusion 8.0 clustering - quick question. I think one requirement for session replication is to turn on J2EE sessions - do you have that on? On Sat, April 19, 2008 13:30, WebSite CFtalk wrote: Hello, I'm struggling with a cluster setup. (IIS6/CF8, 2 servers with 2 instances each) The problem is session replication - tons of errors regarding session replication failed in the logs: 19/04 19:01:40 error Setup of session replication failed. [2]java.io.StreamCorruptedException: unexpected end of block data And a lot of these: 19/04 19:01:40 error unexpected end of block data java.io.StreamCorruptedException: unexpected end of block data As soon as I turn off session replication the errors disappear. This also happens when running a cluster with 2 instances on one server - i.e. no network trouble. One thing is unclear (or obvious?..) in the references I've found: Should the jndi ports and proxy ports be different on each server instance, or should they be the same all over? Anyone? Thanks, Helge ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303825 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion 8.0 clustering - quick question.
we have unique ports per server (that is port 8301 8302 is used on two server), but we are having issues adding a third server to the cluster - I too would be interested in hearing a authoritative view on this question. On Sun, Apr 20, 2008 at 1:30 AM, WebSite CFtalk [EMAIL PROTECTED] wrote: Hello, I'm struggling with a cluster setup. (IIS6/CF8, 2 servers with 2 instances each) The problem is session replication - tons of errors regarding session replication failed in the logs: 19/04 19:01:40 error Setup of session replication failed. [2]java.io.StreamCorruptedException: unexpected end of block data And a lot of these: 19/04 19:01:40 error unexpected end of block data java.io.StreamCorruptedException: unexpected end of block data As soon as I turn off session replication the errors disappear. This also happens when running a cluster with 2 instances on one server - i.e. no network trouble. One thing is unclear (or obvious?..) in the references I've found: Should the jndi ports and proxy ports be different on each server instance, or should they be the same all over? Anyone? Thanks, Helge ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303826 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Need to pass multiple value from a CFC - stuck
All, To see the cfdump, first go to ... http://209.41.164.253/store_finder/application/zip.cfm or see cfdump below I need to pass the zipcodes info from a cfc to another query that looks up stores that contain these zip codes. I need multiple value returned from the CFC that creates this result. How do I do this? When I try to return the cfc values for zip I get a single zip code. How do I get all the zip? I'm not good at Structs or Arrays. 01860,03858,01985,01913,03865,01830, query RESULTSETquery CITYDISTSTATEZIP 1MERRIMAC 0 MA 01860 2NEWTON 2.9757394062 NH 03858 3WEST NEWBURY 3.06730100998 MA 01985 4AMESBURY 3.75117219798 MA 01913 5PLAISTOW 4.50656894395 NH 03865 6HAVERHILL 4.81549111708 MA 01830 CACHEDfalse EXECUTIONTIME0 SQLselect * from qSquareSearch where dist ? SQLPARAMETERSarray 15 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303827 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need to pass multiple value from a CFC - stuck
I need to pass the zipcodes info from a cfc to another query that looks up stores that contain these zip codes. I need multiple value returned from the CFC that creates this result. How do I do this? When I try to return the cfc values for zip I get a single zip code. How do I get all the zip? I'm not good at Structs or Arrays. If you have a query of zip codes that are used to query stores with those zip codes, chances are you would do it in one query. i.e. SELECT * FROM Stores WHERE zipCode IN ( SELECT zipCode FROM zipCodes WHERE *Distance From myzipCode* *theDistance* ) I've made pseudo-code of the distance bit - I presume you have that working already. If you must do it in two queries you could do: SELECT * FROM Stores WHERE zipCode IN (cfqueryparam cf_sql_type=cf_sql_integer/varchar? value=#ValueList(qZipCodes.zipcode) list=true) HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303828 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need to pass multiple value from a CFC - stuck
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, April 20, 2008 11:33 AM To: CF-Talk Subject: Need to pass multiple value from a CFC - stuck All, To see the cfdump, first go to ... http://209.41.164.253/store_finder/application/zip.cfm or see cfdump below I need to pass the zipcodes info from a cfc to another query that looks up stores that contain these zip codes. I need multiple value returned from the CFC that creates this result. How do I do this? When I try to return the cfc values for zip I get a single zip code. How do I get all the zip? I'm not good at Structs or Arrays. Not to put too fine a point on it... but get good at them. ;^) The complex data types (structs, arrays, queries) are exactly how you'd accomplish this goal. They're job in life is to create a single reference/handle/ variable that logically contain multiple values. I've a guide that covers CFML Variables in some detail that you might find useful in beginning to learn about this stuff here: http://www.depressedpress.com/Content/Development/ColdFusion/Guides/Variable s/Index.cfm It's old (it was written when CFMX first came out) but I think it's still valid (neither CF 7 or CF 8 changed or added to the core language all that much). I should set aside some time to update it... In any case the basics it covers will still serve you very well. Definitely post back with any questions you have! Jim Davis ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303829 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Firebug not playing nice
Is this an issue with FireBug or FireFox? Rey... Good question. I tend to think on the FireBug side (disabling it everything works fine) but can't nail it down yet. Will try to find FireFox related forum for a solution as well. Thks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303830 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Accessing SSIS package
Happy Saturday! I created an SSIS package and deployed it to my SQL Server, but what I am trying to figure out is how to trigger it using ColdFusion. Do I need to create an SP or a trigger to do this? I know in the past with DTS packages we would use the CFOBJECT tag to invoke it. Thanks, Bruce ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303831 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Accessing SSIS package
You should be able to run it using CFEXECUTE to run an app called DTEXEC.exe. Check out the docs here: http://msdn2.microsoft.com/en-us/library/ms162810.aspx --Bob Happy Saturday! I created an SSIS package and deployed it to my SQL Server, but what I am trying to figure out is how to trigger it using ColdFusion. Do I need to create an SP or a trigger to do this? I know in the past with DTS packages we would use the CFOBJECT tag to invoke it. Thanks, Bruce ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303832 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Accessing SSIS package
Thanks Bob. Bruce On Sun, Apr 20, 2008 at 10:25 AM, Bob Clingan wrote: You should be able to run it using CFEXECUTE to run an app called DTEXEC.exe. Check out the docs here: http://msdn2.microsoft.com/en-us/library/ms162810.aspx --Bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303833 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Grouping emails by domain
I've been having trouble sending opt-in posts to a local university. They cite that each post on my website results in 250 unique smtp sessions to their mail server, and that they'd prefer one session per post. This is a reasonable request, and would probably help with Yahoo and AOL, as well as possibly even ease the burden on my mailserver. So, what would the best way be to accomplish this? How can I create a single email per domain and BCC all users there? Currently I run a query that pulls all the email addresses destined for delivery, and use the QUERY attribute of CFMAIL to deliver individual emails. Should I create a new field in the [USER] table that contains the TLD of each user's email address, and then either do a GROUP BY in my SQL query, or a GROUP in the CFMAIL tag on that column? If I do a query GROUP BY that'll essentially create a sub-list of email addresses to send BCC: within a single email. I think. If I do an email GROUP that'll ... hmmm... send everyone a mutiple-layered email based on the number of addresses at the grouped domain? ie; if there are ten people with an AOL.com address, and I used CFMAIL GROUP=tld then the resulting email will go TO: all AOL.com addresses, with a stacked email showing the same thing ten times? Any advice? Is there a better way? Mik - From LiveDocs: Group Optional CurrentRow Query column to use when you group sets of records to send as a message. For example, to send a set of billing statements to a customer, group on Customer_ID. Case-sensitive. Eliminates adjacent duplicates when data is sorted by the specified field. Michael Muller Muller Technologies 24 3rd Street Turners Falls, MA 01376 work: (413) 863-0030 cell: (413) 320-5336 skype: michaelBmuller http://support.MullerTech.com Information is not knowledge Knowlege is not wisdom Eschew Obfuscation ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303834 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Remove everything but numbers and letters from a string
I am trying to figure out how to remove all characters from a string besides numbers, letters and spaces. Can anyone point me in the right direction. Thanks in advance for any help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303835 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Remove everything but numbers and letters from a string
ReReplace() would work. -Mike Chabot On Sun, Apr 20, 2008 at 4:57 PM, Steve Sequenzia [EMAIL PROTECTED] wrote: I am trying to figure out how to remove all characters from a string besides numbers, letters and spaces. Can anyone point me in the right direction. Thanks in advance for any help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303836 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Remove everything but numbers and letters from a string
The regex to use would look like this [A-Za-z0-9 ] -Mike Chabot On Sun, Apr 20, 2008 at 5:17 PM, Mike Chabot [EMAIL PROTECTED] wrote: ReReplace() would work. -Mike Chabot On Sun, Apr 20, 2008 at 4:57 PM, Steve Sequenzia [EMAIL PROTECTED] wrote: I am trying to figure out how to remove all characters from a string besides numbers, letters and spaces. Can anyone point me in the right direction. Thanks in advance for any help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303837 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Remove everything but numbers and letters from a string
rereplace(str, '[^\w ]', '', 'all') -or- rereplace(str, '[^a-zA-Z0-9 ]', '', 'all') -or- rereplace(str, '[^[:alnum:] ]', '', 'all') ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Steve Sequenzia [mailto:[EMAIL PROTECTED] Sent: Sunday, April 20, 2008 4:58 PM To: CF-Talk Subject: Remove everything but numbers and letters from a string I am trying to figure out how to remove all characters from a string besides numbers, letters and spaces. Can anyone point me in the right direction. Thanks in advance for any help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Remove everything but numbers and letters from a string
Thanks for the help. I am trying to do it like this: cfset d2 = rereplace(lcase(d1) , '[A-Za-z0-9 ]', '','all') / but (understandably) it is doing the reverse of what I want. It is replacing all the numbers and letters. How do I change it so it only picks characters that are not numbers and letters? Thanks The regex to use would look like this [A-Za-z0-9 ] -Mike Chabot On Sun, Apr 20, 2008 at 5:17 PM, Mike Chabot [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Remove everything but numbers and letters from a string
Got it now. Thanks guys for the help. I am trying to figure out how to remove all characters from a string besides numbers, letters and spaces. Can anyone point me in the right direction. Thanks in advance for any help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Remove everything but numbers and letters from a string
Actually that regex says to replace all of the characters that the poster wants to keep. It should be [^A-Za-z0-9 ] or one of the others that I posted ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Mike Chabot [mailto:[EMAIL PROTECTED] Sent: Sunday, April 20, 2008 5:18 PM To: CF-Talk Subject: Re: Remove everything but numbers and letters from a string The regex to use would look like this [A-Za-z0-9 ] -Mike Chabot On Sun, Apr 20, 2008 at 5:17 PM, Mike Chabot [EMAIL PROTECTED] wrote: ReReplace() would work. -Mike Chabot On Sun, Apr 20, 2008 at 4:57 PM, Steve Sequenzia [EMAIL PROTECTED] wrote: I am trying to figure out how to remove all characters from a string besides numbers, letters and spaces. Can anyone point me in the right direction. Thanks in advance for any help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303841 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
