Ray,
I'm happy to help. I was thinking I might be leading you astray there for a bit and answering a question you didn't ask!
Ryan
On 1/5/06, Ray Hughes <[EMAIL PROTECTED]> wrote:
Ryan,
I am still new to CF.
This solution
Replace(address,'##','') *AS Address*,
Works........
Thanks A Bunch.
Regards
Ray Hughes
>From: Ryan Everhart <[EMAIL PROTECTED]>
>Reply-To: Dallas/Fort Worth ColdFusion User Group Mailing
>List<[email protected]>
>To: Dallas/Fort Worth ColdFusion User Group Mailing
>List<[email protected] >
>Subject: Re: [DFW CFUG] Help with the "pound" character other notes
>Date: Thu, 5 Jan 2006 11:36:17 -0600
>
>Ray,
>
>In this case you would nee to name the address variable Address again..
>
><cfquery datasource=-------------------------
>select company, Replace(address,'##','') *AS Address*, suite, city, state,
>zip
> from client
> where --------------------------------------
></cfquery>
>
>
>On 1/5/06, Ray Hughes <[EMAIL PROTECTED]> wrote:
> >
> > Hi All,
> >
> > The database query pulls the data for the address field.
> >
> > <cfquery datasource= ---------------------
> > select company, address, suite, city, state, zip
> > from client
> > where -----------------------
> > </cfquery>
> >
> > I have a problem with an address in the database. The problem is that
>on
> > some rare occasions the entry people instead of putting the suite number
> > in
> > the field for the suite number they put the suite number after the
>street
> > address in the address field.
> >
> > Examples of records with good data:
> > 408B Hargrove Rd E.
> > 1120 NASA ROAD ONE
> > 219 Billings
> >
> >
> > Example of a record with BAD data:
> > 950 W. Elliot Rd #120
> >
> > It seems that the "pound sign" in this field cause ColdFusion to have a
> > Heart Attack.
> >
> > Here is the line of code I am trying to fix.
> >
> > Code:
> >
> > Line 280 <cfinput name="companyAddress" type="text" label="Address"
> > width="150" value="#IIf(getProfile.recordcount neq 0,
> > DE(getProfile.companyAddress), DE(fundinglogClient.address))#" />
> >
> > This code works fine as long as I do not access any records with bad
> > address.
> >
> > I tried the suggestion from Ryan Everhart and this does not work.
> > Unless I am doing something wrong.
> >
> >
> > <cfquery datasource=-------------------------
> > select company, Replace(address,'##',''), suite, city, state, zip
> > from client
> > where --------------------------------------
> > </cfquery>
> >
> > This produces an error for line 280:
> > "Element ADDRESS is undefined."
> >
> > Does anyone have any advice or maybe could offer some suggestions.
> >
> > Regards
> > Ray Hughes
> >
> > _________________________________________________________________
> > Is your PC infected? Get a FREE online computer virus scan from
>McAfee(r)
> > Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
> >
> >
> > _______________________________________________
> > Reply to DFWCFUG:
> > [email protected]
> > Subscribe/Unsubscribe:
> > http://lists1.safesecureweb.com/mailman/listinfo/list
> > List Archives:
> > http://www.mail-archive.com/list%40list.dfwcfug.org/
> > http://www.mail-archive.com/list%40dfwcfug.org/
> > DFWCFUG Sponsors:
> > www.HostMySite.com
> > www.teksystems.com/
> >
>
>
>
>--
>Ryan Everhart
>[EMAIL PROTECTED]
>_______________________________________________
>Reply to DFWCFUG:
> [email protected]
>Subscribe/Unsubscribe:
> http://lists1.safesecureweb.com/mailman/listinfo/list
>List Archives:
> http://www.mail-archive.com/list%40list.dfwcfug.org/
> http://www.mail-archive.com/list%40dfwcfug.org/
>DFWCFUG Sponsors:
> www.HostMySite.com
> www.teksystems.com/
_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
--
Ryan Everhart
[EMAIL PROTECTED]
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
