Hi James,
You might want to think about doing it on the sql database though, could save you some performance. T-SQL thingys to do this with could be LEFT or CONTAINS. And if you use sql in CF you can also use MID.
(No equivalent of MID in t-sql, anyone??)
Jenny Admin and Development, chicksNchaps http://www.chicksNchaps.co.uk
----- Original Message ----- From: "James Buckingham" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 23, 2004 9:47 AM
Subject: RE: [ cf-dev ] Finding out if a string contains particular characters
Thanks again Duncan. Thought that would be an easy one ;)
Does anyone know any good website where I can find out information like this? In comparison to some of the other questions in here it seems quite basic. I've been looking at www.cfhub.com but unless you know what you're looking for it's not much use.
Really need a list of basic syntax and FAQ's.
Cheers again, James
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 17:35 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Finding out if a string contains particular characters
<cfif FindNoCase("<a", queryname.yourString)> do set 1 <cfelse> do set 2 </cfif>
James
Buckingham To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc:
a.com> Subject: [ cf-dev ] Finding out
if a string contains particular
characters
22/09/2004
17:24
Please
respond to
dev
Hi guys,
Bit of a basic question I'm sure but I need to find a way of seeing if a
string in a database record contains the characters <a (i.e. the start of a
link).
Depending on the answer I want to run one of two sets of code.
How can I do this in Cold Fusion? I'm running version 5.0
Cheers again,
JamesB
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
--
These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.768 / Virus Database: 515 - Release Date: 23/09/2004
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
