Robertson-Ravo, Neil (RX) wrote:
Indeed and a Google for sites using it is just as good...
Google allinurl:.cfm
allinurl:.cfm = 360,000,000
allinurl:.php = 1,330,000,000
allinurl:.asp = 1,030,000,000
allinurl:.aspx = 497,000,000
allinurl:.jsp = 237,000,000
Of course, it seems to be
In addition to a Pocket Reference book and the poster mentioned in
another thread, it would be nice to have a quick reference...something
like Allaire did for JSP here...
http://tinyurl.com/38srt9 (PDF)
There are bunch of other ones here...
http://www.digilife.be/quickreferences/quickrefs.htm
[EMAIL PROTECTED] wrote:
All,
Is there a way to pass a #form.variable# to a form from a hyperlink?
I'm trying to pass a string to a processing page from a hyperlink becuase
the processing page is not under our control and we're being told there's
code to handle strings passed via the URL
Andy Matthews wrote:
When I use that code, and compare to tempFreq, the code works just fine.
Why is this happening? Does anyone have wisdom on this because it's really
irritating for me to have to have this extra line of code in here. Anyone?
I think about the best answer you are going
Ben Nadel wrote:
Create a new file Project using existing database
An Access project is probably a good way to go since you are comfortable
with Access, but it does not use the Access Relationships function
that was described. It has something similar in the Database Diagrams
button that
Will Tomlinson wrote:
My client stopped getting her order was processed email notifications all
of a sudden.
I ran some tests on the production server and found that as a customer, I
receive them just fine. But the one that goes to the client never arrives.
So then I'm testing on my
Eric Roberts wrote:
I have the same complaint for any software or hardware manufacturer who
doesn't have updates or drivers for Vista. I find it very unprofessional.
There is no excuse for any company not to have been ready for the release...
Having been a part of a company that produced
Scott Stewart wrote:
I downloaded wget to use to execute .cfm files in a batch file. Does anyone
have experience using this with url variables. Were getting weird results..
and I need to know if Im missing something.
I have batch files that use URL variables in them with wget and they
Bruce Sorge wrote:
OK, so I am going to take the Vista plunge this weekend. What is the minimum
version I need to run SQL Server 2000, CF7 and IIS?
I know that SQL 2000 is not supported on any version of Vista...I don't
know if that means it won't run, though.
Robertson-Ravo, Neil (RX) wrote:
? IIS is free.
I think the point was that in order to get IIS with Vista, you have to
go to the Business, Enterprise or Ultimate version. Therefore, if the
only reason you are going to those versions is IIS, then it is not free.
Jeff Gladnick wrote:
I think there are a few more too :), although not quite as big.
Charlie Arehart blogged on the various entries yesterday
http://carehart.org/blog/client/index.cfm/2007/2/13/google_cf_CSEs
~|
Upgrade
Jochem van Dieten wrote:
If the cause is people putting email addresses of other people in the
body of their email, why go after the symptom of the subsequent display
of said email addresses on one of the many archive websites? People need
to configure their MUA properly so that they don't
Scott Stewart wrote:
hey all,
is there a method to running .cfm files from within a .bat file without
opening a browser window?
You can use a command line client like wget:
http://www.gnu.org/software/wget/
~|
Upgrade
It is a great site...I went to view one of their client examples, hit
the back button, and suddenly had a pretty picture with no navigation.
They obviously knew I was done looking at their site. That takes some
serious UI design skills.
Charlie Griefer wrote:
As far as the former, the site can only be accessed by
localhost/127.0.0.1 and 2 external IP addresses (whichever 2 addresses
hit the server first after setup).
Just to clarify, since it seems to get asked a lot...it is localhost +
the first 2 IP addresses to hit
Kris Jones wrote:
select case left(right(path,4),1) when '.' then right(path,3) else '' end
This will work on SQL Server (assuming all of your extensions are three
characters), and possibly on Oracle(I think it now supports CASE). In
your message you wanted a T-SQL solution, but said your
Rick Root wrote:
For what it's worth, if Railo went open source.. now *THAT* would be
interesting...
The combination of a open source shared hosting optimized CF runtime
is where I see some possibilities. Perhaps if one of the big hosting
companies (HMS or GoDaddy seem like likely
Doug Brown wrote:
MySql offers an open source product and were able to grow their client base
while at the same time having the people that downloaded their software also
develop their software and reduce their costs. Free and closed source simply
means that we have to wait for you to implemnt
Christopher Jordan wrote:
I'd like to see them have a mailing list or forum (which I don't think
they presently have... I could be wrong), but I like seeing discussions
like this, and I'll bet they would too. I'd definitely join such a
mailing list/forum.
There is actually a forum
Russ wrote:
No, I'm referring to:
http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:50203#268818
That one is pretty quick here...
SELECT b.* FROM tblzipcodes a CROSS JOIN tmpzipcodes b
WHERE dbo.getDistance(a.latitude,a.longitude,b.latitude,b.longitude)
10 AND a.zip =
Frank Greene wrote:
Hello:
In December I launched a 30 Gig SQL Server database with 140 ColdFusion
templates.
I use the OnRequestEnd.cfm template to call the Footer.cfm template.
For 139 of the templates the footer is displayed at the bottom of the page.
In just one template the
Rick Root wrote:
I like how you're limiting by latitude only and using the radius as well.
Thinking about limiting it by longitude made my head hurt...I thought
about using some larger constant (like the 2 degrees that you used), but
in Alaska, 2 degrees longitude only equates to about 44
Rick Root wrote:
Actually, I did a limitation by longitude as well, because at the equator,
the fudge factor is the same (approximatley 69 miles per degree)...
everything in the US is less than that but I figured what the heck. So I
draw the box on both lat and long, knowing that the
Mik Muller wrote:
select left(datetime,11), count(*) as dt
from sitelog
where datetime = '2007-02-03 00:00'
group by left(datetime,11)
order by left(datetime,11) desc
Well, now that I look at it, the order by is ordering by jan 1 2006 etc in
Orlini, Robert wrote:
I using #DateFormat(Now(),dd)-1# to get a previous date. However, using it
today it gives me the previous date of 0 as opposed to 31.
How do I get it to generate the previous date as the 31st as opposed to 0?
#DateFormat(Now()-1,dd)#
Bruce Sorge wrote:
I have a lot of duplicate information in a table. I know how to query to
find the dupes, but I am having problems with deleting them (there are
thousands). I tried this:
DELETE
FROM CODES
WHERE Code =
(SELECT Code,
COUNT(Code) AS NumOccurrences
FROM Codes
GROUP BY
Mike Elmalem wrote:
Hi All
Looks like we have been hit with the patriot act here in canada as wel.
Some of my clients who are currently being hosted at Crystaltech have made
requests to me that their data can no longer be hosted on american servers
as their database could be confiscated.
Tim Laureska wrote:
I hope this isn't too far off topic. does anyone have any online resources
that talks about site code ownership, particularly when no written contract
exists
This is a pretty good overview...
http://www.freibrun.com/articles/articl0.htm
basically, my understanding is
Ian Skinner wrote:
I have a task that needs to run every other Thursday. Since the
scheduled task administrator does not have bi-weekly option, I'm
expecting I will run it every week and then have logic on the page
determine if this is an on week or an off week.
I don't think this is the
Ian Skinner wrote:
But if not this, what characteristic of a date would determine which week to
run the code. I have a 'start' date if that helps.
And as for an idea that may solve your problem...how about..
cfif DateDiff(ww, startdate, now()) MOD 2
run the task...
/cfif
Dan G. Switzer, II wrote:
I have a MSSQL database w/a lot of tables. I've got to copy all of a
company's data from one database into a brand new database. The database
should have all its foreign keys/primary key relationships defined (with one
exception.)
I can write scripts by hand, but
It might make more sense to you if you think about it as two completely
separate queries...
cfquery name=q1...
SELECT n_r_id FROM notes_to_the_record_shared WHERE id =
#session.user.id#
/cfquery
The above query just got us a list of n_r_id's that we know are
associated with the user.
Convert
daniel kessler wrote:
Would another good way to do this be to group all the ANDs (assuming that
they have content to use in the query) together in parens and then have all
the ORs following?
1=1 AND (UPPER(n.meeting_name) LIKE '%somevalue%' AND UPPER(n.type) LIKE
'%anothervalue%') OR
Les Irvin wrote:
Novice question here.
I need to write a query to find a single integer in a field of delimited
integers, say 23,25,27,29. How is this done in Cold Fusion? FindOneOf?
FindNoCase? Can anyone advise?
In CF, you would probably use ListFind...but are you trying to find this
Les Irvin wrote:
http://redwood.jmdl.com/themes.cfm
http://redwood.jmdl.com/themes_code.cfm (code)
I'd say this is a perfect example of why you don't want to have
repeating data in a field, and why you would want to move that theme
data out into a separate table that relates photos to
http://www.forta.com/blog/index.cfm/2007/1/26/Book-Publishing-Dilemma-Input-
Requested. Feel free to comment there.
Here is a link that doesn't wrap...
http://tinyurl.com/35rr99
while these SEO blog links are great and all, they can be kind of hard
to click on sometimes...
daniel kessler wrote:
Here are the results from the dump (not sure how this'll come through)
ommitting unnecessary info.
Can you re-paste this dump without ommitting anything...I'm guessing
there is some necessary info in there. My guess is that the s.id is
being returned in your result
Perhaps you could handle it in your original query by having a table of
the months and years to join against...something like...
tblPayPeriods
payYear
payMonth
tblPayData
GrossPay
payYear
payMonth
payClass
tblPayClass
payClass
sortorder
query...
SELECT SUM(b.GrossPay) AS Amount, a.payYear,
daniel kessler wrote:
honestly, though - I've read and re-read it over several times and I just
don't get it. Would you mind walking me through it a bit? There's clearly
some bit of information that I'm not getting.
commented...
SELECT
daniel kessler wrote:
Now, since it's a search tool, I had to add another set of ANDs for all the
search parameters. I came up with something, after much ta-doo and I think
it's right, but I was hoping that y'all could check it over - mainly how I
organized the search variables with the
In that previous message, I meant to say...
1. If url.meeting_name IS AND url.type IS NOT AND url.and_or_1 IS
OR, then you are
going to return all records, no matter what you have in url.type.
~|
Upgrade to Adobe ColdFusion
Chad Gray wrote:
I cannot switch it to an integer field because there will be some text also.
Any way to accomplish this?
maybe something like...
SELECT thefield FROM foo
ORDER BY CASE WHEN IsNumeric(thefield)=1 THEN CAST(thefield AS INT) ELSE
0 END,thefield
That should put the text
I should point out one issue with the way I did it...the isnumeric
function is not perfect, and will resolve to true things that can't be
converted to INT...case in point...
IsNumeric('1,0.') = 1
CAST('1,0.' AS INT) throws an error
Jim Wright wrote:
I should point out one issue with the way I did it...the isnumeric
function is not perfect, and will resolve to true things that can't be
converted to INT...case in point...
IsNumeric('1,0.') = 1
CAST('1,0.' AS INT) throws an error
and further, you need to look
Doug Brown wrote:
How can I detect the browser with an if statement? I have tried without luck.
Is there a regex to do the trick?
cfif findNoCase(CGI.HTTP_USER_AGENT, Firefox)
You have it reversed...
cfif findNoCase(Firefox,CGI.HTTP_USER_AGENT)
Andy Matthews wrote:
I've got two DBs showing up in Enterprise Manager. I need to query against
both of them. In MySQL you can do this by simply prepending the db name to
the tablename like so:
SELECT t1.id
FROM db1.t1 t1
INNER JOIN db2.t1 t2
ON t1.id = t2.fkID
Assuming that the
Peterson, Chris wrote:
Every time I host a lan party, we end up getting a giant piece of
cardboard to put the tournament bracket on, and I tell myself 'I really
need to code something for this'
Has anyone else started on a tourney bracket like this? Anyone have any
ideas on how to start a
Richard Cooper wrote:
I tried grouping the data from the poll table and then used this in the
select:
COUNT(DISTINCT PR.questionAnswer) as answerCount
,MIN(PR.questionAnswer) as questionAnswer
But that hust returned the number of different answers. I'm looking into some
kind of sql
David Low wrote:
IrfanView usually did the trick for me (on the PC) but I'm sure Google's
Picasa will do it too.
+1 for IrfanView...it has a command line version, too...very handy.
Picasa does have some batch optimization when you do a File/Export
Picture to Folder...but it is pretty
Bobby Hartsfield wrote:
Apparently that is causing all cf-talk mail to be flagged as spam
That may be the issue...or it may be related to something I noticed a
while back...
http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:47910#254138
basically when people send from Outlook,
[EMAIL PROTECTED] wrote:
I'm so sorry, but this is my favorite forum and they are so many sharp people
out here and I know I can get a quick answer to what shoud be a sql question.
I want to pass two values to distinct in a query. How do I do that?
I want to pass both
Does anyone have a list of keywords or code for detecting if a request
is coming from a mobile browser? I don't need it to be perfect, but I'd
like to redirect most mobile users to some optimized pages...I'm
figuring that I could probably compare a list of keywords to the
HTTP_USER_AGENT or
Claude Schneegans wrote:
I don't know, but I think that testing the total screen width should be
accurately enough.
Are mobile browsers to the point that a large percentage of them would
support the js functions to allow this?
Dave Watts wrote:
This list is updated regularly:
http://wurfl.sourceforge.net/
There are some other approaches, outlined here:
http://www.thewirelessfaq.com/how_to_distinguish_a_mobile_browser_from_a_des
ktop_browser
Good links...thanks Dave.
Chad McCue wrote:
The problem is the browser after the search is conducted still sees all
accounts even though the XML document only shows the results searched
for.
Is this in IE? ..
http://www.google.com/search?q=spry%20ie%20caching
[EMAIL PROTECTED] wrote:
CFOUTPUT ...
cfoutput query=rsContestwinners
#trim(dateformat((Expr_month), ))# #trim(Expr_year)#
/cfoutput
gives me ...
December
2005
December
2006
January
2006
January
2006
January
2006
January
2006
Try this instead...
cfoutput
There are probably many ways to do this, but one thing you might find
useful is to make use of a CROSS JOIN in your query...that way you can
return one record for each combination of tbl1ID and service, and then
use a LEFT JOIN to determine if there is a match in Table 2...something
like...
Robert Walters wrote:
Hello,
My company wants me to build a site just like YouTube for our users. Has
anyone come across any software out there to do this?
I can do the front end in CF but I need some type of engine that takes
any video and converts it to Flash FLV on the server. Any
Michael Greenberg wrote:
Best thing out there I've seen is anystream
http://www.anystream.com/
That looks interesting...any idea on what their pricing is like?
~|
Create robust enterprise, web RIAs.
Upgrade integrate
Ali Majdzadeh wrote:
Plus 5 different templates for the parts and a Logo and flash intro.
I'd say $3500 may sound fair for just this part of it (and probably low,
as I often find that the design, being very subjective, can be the part
of a project that really balloons)...I'll join the chorus
Joshua Cyr wrote:
I have used Aqua Data Studio for just that task. (mysql and mssql to
postgre). I had to do it table by table, but I did it for millions of
records with relative ease. Export to delimited text file or file with
insert statements, then import to the other db.
Joshua Cyr wrote:
Wasn't Aqua Data Studio free at one point? I swear I didn't buy it... but
could be forgetting. I don't do the warez thing, so either it was
legitimately free at one point or very inexpensive or I am losing too many
brain cells on WOW.
Prior to the current version 6, it
Matt Quackenbush wrote:
Jim,
Are you referring to v6 RC1? That's all I've seen so far on their site.
Yes, I believe that is the latest version...but I think the 4.7 version
also had the export capability I was describing. I went ahead and
started using the RC because I wanted to use the
Matt Quackenbush wrote:
Am I correctly understanding what I'm reading on their site that Aqua Data
Studio supports ALL of the listed databases in the same client? (As opposed
to having a different one for each DB?)
Yes...it is very nice having the same interface for multiple database
Dave Watts wrote:
Am I correctly understanding what I'm reading on their site
that Aqua Data Studio supports ALL of the listed databases in
the same client? (As opposed to having a different one for each DB?)
Sure. It's a JDBC client, just like CF. I doubt it provides GUI management
Che Vilnonis wrote:
Thanks Damien. I was stuck on using the IN clause which was not working. I
switched to LIKE and it works. Actually, it works w/o the commas and only
one where clause.
i.e. - WHERE emaildates like '%#todaysDate#%'
Be careful with that, because if your data is...
Keith McGee wrote:
Does anyone know of a way to print a web page or create a output file
from a PDA using windows Mobil? I am writing a program in cold fusion
where service guys need to print out the results of a test. I have
tried to create .xls, .pdf, and .doc file outputs, (they work on the
Scott Stewart wrote:
Hey all,
My wife and I are considering a move to Raleigh. We can do alot more down
there house wise than we can in DC.
What's the CF Market like in the area, and what are average salaries for CF
developers with 6+ years experience.
and just out of curiosity are
Also, Raleigh/Durham just made Wired's list of top ten tech towns...
http://www.wired.com/wired/archive/15.01/geekcities.html
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
James Smith wrote:
I am selecting 5 random products from each of 5 random genres.
Currently I query for the 5 random genres, then use a cfloop to run 5
queries each selecting 5 products from one of the genres.
SELECT TOP 5 GenreID, GenreName
Les Mizzell wrote:
Form field requesting a birth date.
Person enters 1/22/45
Coldfusion returns 1/22/2045
How can I insure it returns 1/22/1945 without forcing the year entry
as four digits- 1/22/1945 vs. 1/22/45
And if they enter 1/22/05, does that mean 1905 or 2005? I would force
Pete Ruckelshaus wrote:
Anyone have a code example for taking an XML file and GZipping it? I
want to dynamically generate Google sitemaps for my sites, and they
need to be .gz files.
I don't believe that gzip compression is required to submit a sitemap.
Still, if you find some good code
Orlini, Robert wrote:
I have an interesting dilemma.
I need to populate a Select dropdown field with the past five days.
It worked OK until today and it's my coding fault. Right now it is
trying to retrieve days 28 to 01 which are none. See loop below.
How do I have it recognize dates as
New Years day being a good day to clean house, I was culling some old
stacks of CDs, and came across a copy of Website Professional version
1.1 (date of May 25, 1996), which included ColdFusion 1.5. It installed
fine on XP-Pro and CF was able to pull back data from a SQL Server 2005
ODBC
Andrew Grosset wrote:
//example from http://www.webreference.com/js/column63/6.html.
According to this link, this is an example for WMLScript, a variation of
javascript for use with wireless devices. I don't see a insertAt method
in another reference on javascript...
Andrew Grosset wrote:
Jim,
Thanks for pointing that out(WMLScript), is there a way to insert a string
within another using javascript?
Andrew
Not something I've done before, so this isn't tested well or anything...
script
function insertAt(s,i,l){
return
Dwayne Cole wrote:
I'm looking for a tool that would alow me select a table and then it
automatically generates a series SQL statements to select, insert,
update, delete records from the taable.
Any suggestions.
Aqua Data Studio has this...you just right click on a table and choose
what
of exception is possible with
SeeFusion.
Thank you for your consideration of this issue, and also for the
excellent service and support I have come to expect from your organization.
Thank you,
Jim Wright
(list of sites hosted)
I'll probably send this on myself, as I am concerned that the 50
This was discussed on another list I'm on a while back...one of the
prevailing ideas was to monitor the FTP server logs to see if there is a
upload complete statement for the file in question, of course that all
depends on what FTP server you are using and what it logs.
Christopher Jordan wrote:
DateDiff(, Date1, Date2)
Where Date1 and Date2 are valid CF Date/Time objects.
the datepart is in years.
the datepart y is days of the year (1-365?) same as d for days.
Just a note since he didn't say if he wanted to do this on the CF side,
or the db
I'll throw out my vote for Aqua Data Studio. It is especially good if
you have multiple database engines that you manage (SQL Server, MySQL,
Postgres, etc), and want a fairly consistent interface to deal with all
of them. It has a very nice dump feature, which allows you to dump
table
Jochem van Dieten wrote:
If you need to change the database, you send it the appropriate SQL
command. Either by typing the command yourself, or by using a GUI
that translates your clicks to the appropriate command and sends it.
And while I would recommend getting away from Access, you
Christopher Jordan wrote:
Simple: Because CreateODBCDateTime(now()-1) doesn't cover the proper
time span that he needed to cover. He needed to check for entries in the
database that occurred between midnight yesterday (00:00:00) and
23:59:59 of today. now()-1 doesn't give that sort of
Christopher Jordan wrote:
Results in:
WHERE timereceived = {d '2006-12-20'} AND
timereceived {d '2006-12-22'}
I haven't tried it, but if the datatype on the field is 'ts' and you're
trying to compare it with just 'd' (meaning it's holding data like, {ts
'2006-12-20 13:43:24'} and
Snake wrote:
Yet calling the same web service in the same way via a CFM page causes no
problems, even when the toolbar cannot get any response, the cfm page gets a
response from the web service just fine.
Is it possible that you have a software firewall that is blocking calls
from that app?
Rick Root wrote:
Try cfinclude.
And google on scrollable div
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
You might want to look at using the Access datediff function
cfquery name=get datasource=barracuda_log
SELECT *
FROM message_log_20391
WHERE datediff(d,timereceived,now()) = 1
/cfquery
Although note that languages aren't consistent as to whether they take
the time part into
Joshua Cyr wrote:
I think BD 7 will or was that ralio?
BD 7 will...here is a test page I just whipped up...
http://www.wrightster.com/webthumb.cfm
The resizing is done with Rick's image.cfc, and if you click on the
thumbnail, you will see the original jpg created by cfdocument.
Seems to have
Mark Leder wrote:
I'm using this cfquery to pull records from an MSSQL 2005 db:
SELECT U.userID, U.userFirstName, U.userMiddleName, U.userLastName,
(U.userFirstName + SPACE(1) + U.userMiddleName + SPACE(1) + U.userLastName)
AS assignedName
FROM a_Table
It works great, with one
[EMAIL PROTECTED] wrote:
What's the best way to share a half dozen sql server 2000 tables that contain
data with an offsite
contractor? I was going to export to MS Access and send a file. Any other
thoughts?
If they have SQL Server on their end, and you just want to provide them
with
I just was made aware of this charting component the other day on
another list...
http://www.advsofteng.com/gallery_gantt.html
which has gantt capabilities...and a CF version. I haven't had a chance
to work with it yet, but it looked to be more flexible than most
charting components out there.
Orlini, Robert wrote:
How can I have a search with two dynamic dates; one the day before and one
the current day? I current use an Access dbase and have the timereceived
field set as date/time.
This line works: where timereceived between {ts '2006-12-06 00:00:00'} and
{ts '2006-12-09
Jim Wright wrote:
CFQUERY name=get datasource=bbb _log
SELECT * FROM bbb
where timereceived between #createodbcdate(startdate)# and
#createodbcdate(enddate)#
/cfquery
Seeing Ben's post reminded me that this query will eliminate 3.33
milliseconds of time...
where timereceived
Mike,
What you have to remember with your query is that the COUNT is just a
count of rows...and that is done AFTER the data has been joined
together. If you look at how your joins are constructed, you will see
that your counts are going to be the product of the two joins...
You can strip all
James Smith wrote:
SELECT col1/col2 AS result
FROM aTable
What is the simplest way to make col2 0.01 if it is 0.
You also could do it with a CASE statement...
SELECT col1/CASE col2 WHEN 0 THEN 0.01 ELSE col2 END AS result
OR
SELECT CASE col2 WHEN 0 THEN -1 ELSE col1/col2 END AS result
Terry Troxel wrote:
I am having a senior moment and could use some help with a
sql select query I am attempting to use to populate a
listbox with only those items that have inventory.
SELECT DISTINCT inventory.ItemNumber, SUM(inventory.qty) as
invqty where invqty 0
And I get the error I
Jim Wright wrote:
SELECT inventory.ItemNumber, SUM(inventory.qty) as
invqty
FROM inventory
GROUP BY inventory.ItemNumber
HAVING SUM(inventory.qty) 0
oops...told you to take the DISTINCT out, and then left it in...see above
Ken Ferguson wrote:
So, I'd like to see:
John - 40% - 5 incidents
Sue - 50% - 4 incidents
Try something like this...
SELECT p.personName,(SUM(CASE t.tool WHEN '-5' THEN 100 ELSE 0
END)/count(t.tool)) as notoolpercent
FROM People p INNER JOIN ToolsUsed t ON p.IncID = t.IncID
GROUP BY
Coldfusion wrote:
Besides doing a DIR on the images folder and then searching through each
template, is there any other way?
One other way would be to get a list of files that have been called from
the images directory in your web server logs. There is a command line
utility from MS
Mingo Hagen wrote:
so he should use 1=0
That would exclude the ANDs...but you could do something like...
(cfif url.and_or_1 IS AND1=1cfelse1=0/cfif
cfif url.meeting_name neq
#url.and_or_1# UPPER(meeting_name) LIKE cfqueryparam
value=%#UCase(url.meeting_name)#% cfsqltype=cf_sql_varchar
/cfif
101 - 200 of 522 matches
Mail list logo