Let the user input the address with the pound sign. The reason to replace the # sign after you pull the info is in case the database info will be used by something other than CF. You will maintain your data integrity, it won't confuse non-CF programs, and it's easy to do the replace in <cfoutput>, after all it is a CF issue. My 2 cents. Joe Kelly
On 1/5/06, Joe Kelly <[EMAIL PROTECTED]> wrote: > Ray, > Use the replace function within your <cfoutput> tags when presenting > the address, after your <cfquery> select. > Thanks, > Joe Kelly > > 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/ > > > _______________________________________________ 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/
