replace(species," ","_","all") HTH,
-- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >http://www.coolfusion.com/imssecomparison.cfm ----- Original Message ----- From: "NZERN National Office" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, June 30, 2002 8:28 PM Subject: Species names > In a table is stored species names > eg > Oleria furfuracea > Parsonsia capularis > > I want to be able to convert this to a string like > > Oleria_furfuracea > Parsonsia_capularis > > so that links can be made like > > http://www.members.bush.org.nz/plant/fact.cfm?species=Aristotelia_serrata > > How do I do this? > > > Thanks for any help > > Mike > ---------------------------------------------------- > NZERN National Office > Mail: PO Box 9000, Christchurch > (03) 338-5451 > E-mail: [EMAIL PROTECTED] > http://www.bush.org.nz > ---------------------------------------------------- > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

