cases) there is no select statement, it will return the whole string.
That is why I usually go with REFind/Mid.
2. If you are looking for a column list, I would also add some \s in the
regexp:
"^.*?SELECT\s(.*?)\sFROM\s.*$"
If you don't, a statement like this will get you in trouble:
SELECT MAILTO, MAILFROM, MAILSUBJECT, MAILMESSAGE FROM TBL_MAIL
Pascal
> -----Original Message-----
> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
> Sent: 01 September 2004 14:11
> To: CF-Talk
> Subject: Re: REFind Help ...
>
> > Hello,
> > I have a string and I need to get a certain part out of it
> > and pipe it in to another variable.
>
> > Here is what I have --
>
> > <cfset NewString = REFind("SELECT(.*?)FROM",theQuery)>
> > Here are all of the columns in your query #NewString#
>
> > What I get is a "1", I was really looking for the string.
>
> <cfset newString =
> rereplacenocase(theQuery,"^.*?SELECT(.*?)FROM.*$","\1")>
>
> s. isaac dealey 954.927.5117
> new epoch : isn't it time for a change?
>
> add features without fixtures with
> the onTap open source framework
>
> http://www.sys-con.com/story/?storyid=44477&DE=1
> http://www.sys-con.com/story/?storyid=45569&DE=1
> http://www.fusiontap.com
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
