Re: [DFW CFUG] Help with the "pound" character other notes

Thu, 05 Jan 2006 11:17:01 -0800 

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/

Reply via email to