Ray,
Can you do a replace on the SQL side of the house when you are pulling the records back? That might be easier. MSSQL would be Replace(CompanyAddress,'#','##').
Ryan
On 1/5/06, Ray Hughes <[EMAIL PROTECTED]> wrote:
Hi All,
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 good one:
408B Hargrove Rd E.
1120 NASA ROAD ONE
219 Billings
Examples of a BAD one:
950 W. Elliot Rd #120
It seems that the "pound sign" in this field cause ColdFusion to have a
Heart Attack.
What I am trying to do is to do a replace on the # character.
Here is the line of code I am trying to fix.
Code:
<cfinput name="companyAddress" type="text" label="Address" width="150"
value="#IIf(getProfile.recordcount neq 0,
DE(replace((getProfile.companyAddress ), "##", " ", "ALL")),
DE(replace((fundinglogClient.address), "##", " ", "ALL"))#" />
This code works fine without the replace function and as long as I do not
access any bad address records.
Does anyone have any advice or maybe could offer some suggestions.
Regards
Ray Hughes
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/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/
