Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Find and Replace Question (easy)

0 views
Skip to first unread message

GarrettPoe

unread,
Aug 12, 2002, 6:27:39 PM8/12/02
to
Hi All,

I'm a real newbie trying to do work way over my head with SQL2000 and Cold Fusion. Anyways, here's my problem:

I have a table with a column called "match_video". That column contains URLs like:

Many thanks. Perhaps I understated my problem. Here's the real situation - I have many records with links like this:

/cgi-bin/miscmatches.pl?ef3/ef3_smith_vs_silviera.zip

/cgi-bin/miscmatches.pl?ef4/ef4_monday_vs_lewis.zip

I want to change them to this:

misc/ef3/ef3_smith_vs_silviera.zip

misc/ef4/ef4_monday_vs_lewis.zip

So, I only need to change the first part: /cgi-bin/miscmatches.pl? to this: misc/

How do I do this? I've been searching and trying to read up on REReplace, but having a tough time.


nicorawa

unread,
Aug 12, 2002, 6:37:49 PM8/12/02
to
It was just an example, here it is with a query...

<cfquery>
SELECT url
FROM tbl
WHERE field = '#variable#'
</cfquery>

<cfoutput query="qryName">

<cfset temp="misc/#listLast(url,"?")#">

</cfoutput>

Joe Nicora
Program Developer
MEIER Enterprises, Inc.

0 new messages