Clicking the unsubscribe link leads to this:
You have requested to be unsubscribed from the CF-Talk list. To complete this
action, you must enter your password below to make sure that this is not being
done to you maliciously. If you do not remember your password, you can have it
emailed to you
Simple example. mypage.cfm:
cfinclude template=header.cfm
cf_sometag
cfinclude template=footer.cfm
or, if it makes a difference:
cf_header
cf_sometag
cf_footer
Any way to have cf_sometag write output into header.cfm? I'm certain you
could do it with javascript, but considering that the CF
We've got two people at our company subscribed to the cf-talk list. I notice
in my mail server's SMTP logs what appears to be two copies of the message
being delivered from HOF's server. Both addresses here are in the same domain
name. I thought there was an SMTP provision to deliver a single
- Original Message -
From: Gyrus [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, August 25, 2003 5:57 PM
Subject: Re: cfinclude from within CFML tag
The tags are shared by a number of web sites. I want to be able have
multiple
tags cfinclude an html file that sits in
(ColdFusion 5)
How do you cfinclude a file from within a custom tag? I've got a group of
cftags that all want to cfinclude an html file in the same directory. The
directory with the tags is a subdirectory of a custom tag directory set up in
the CF Administrator.
One thing I suppose I could do
- Original Message -
From: Gyrus [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, August 25, 2003 4:07 PM
Subject: Re: cfinclude from within CFML tag
At 14:21 25/08/2003 -0600, you wrote:
How do you cfinclude a file from within a custom tag? I've got a group of
cftags
Which of the two is still being maintained, even if not sold directly, by
Macromedia? Would it be Homesite+, since it's included with Dreamweaver MX?
We need to purchase a couple of additional licenses for CF Studio. We're not
working with CF6 MX and have no plans to move away from CF5 Server.
. I think it is
more
cost effective to buy Studio MX.
If I am mistaken, I'm sure someone will chime in
At 08:03 AM 8/21/2003 -0500, you wrote:
Subject: CF Studio/HomeSite+
From: Jim McAtee [EMAIL PROTECTED]
Date: Thu, 21 Aug 2003 03:32:05 -0600
Thread:
http
We're runninng MDAC 2.5 SP3 on our CF5/IIS5 (Win2k) servers. I was just
looking into updating this to the latest 2.7 SP1 version of MDAC. These
servers are primarily using Access and MySQL through ODBC.
The following was found on Microsoft's download page for MDAC 2.7 SP1 download
page:
I've got quite a few CF5 templates in which I'd like to generate an error page
that returns an HTTP 404 status code (using cfhead). Most are constructed as
follows, usually with a number of queries and tests which may throw the error:
cfsilent
cfquery name=myquery ...
/cfquery
cfif
- Original Message -
From: cfhelp [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 2:53 PM
Subject: RE: Shared Windows Hosting - Licensing
I think this is the best thing MS has done with licensing.
My company 'Kchost.net' is joining this program now. I
Anyone know offhand how to examine cfhttp.responseHeader to tell if the cfhttp
operation has gotten a 404 error?
Thanks,
Jim
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
What's the no relaying rule?
What exactly are you trying to accomplish, besides not creating an open
relay?
Whether or not an SMTP relay is open is completely in the hands of the
email
server configuration. Permitting relaying only from localhost and/or
machines
on the local network would be
I'm talking about how it affects small hosts and developers doing hosting.
I guess it wouldn't affect you at all if you do not want to become a
partner. You can still buy the software license and CALs and be done.
Then we've come full circle. I thought this was the case as well, but after
For a sales report, I need to figure out what the date is for
this DAY last year. So for today, 8/5/2003 Tuesday, I need to
figure out what the date was for this Tuesday last year
(which was 8/6/2002).
It's not as simple as today-364 days right? You've got leap
- Original Message -
From: Dave Carabetta [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 11:28 AM
Subject: Re: cfhttp.responseHeader
Anyone know offhand how to examine cfhttp.responseHeader to tell if the
cfhttp
operation has gotten a 404 error?
Just
If I go with a web based CF driven interface that I require all clients to
use, because that's on the server farm with localhost as the mail
server... that would then allow me to enforce the No Relaying rule correct?
What's the no relaying rule?
What exactly are you trying to accomplish,
Sorry for the OT, but there are probably a number of people on the list
offering shared Windows hosting, most likely with CF. I know there are a lot
of small and medium sized developers who, like ourselves, own a couple of
Windows boxes that they host client web site on.
What is your
When a form passes multiple, same-name checkboxes to a CGI script (Perl, C,
whatever), what is the raw format of those form field values?
I'm trying knock together a cf app that works with an existing form handling
script (in Perl, I believe) on another server. The way it works is
cftemplate1
Hi, I am working on an RIA using CFMX, and using CF to generate some
XML pages. I am running into a problem with the debug portion of the
CF page, obviously Flash doesn't like all those comments appearing at
the bottom of each page.
Is there a way in CFMX is programmatically control the
Do tasks run from the cf scheduler (CF5) run at a different priority than those
called via a browser? I wouldn't think there would be a difference, since the
CF schedulere just thinks it's making an HTTP request, but...
~|
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, August 01, 2003 1:29 PM
Subject: RE: Scheduled Task Priority
Do tasks run from the cf scheduler (CF5) run at a different
priority than those called via a browser? I wouldn't think
Is there a means of selectively killing a CF template that
was run via the scheduler? Without cycling the CF service
itself, that is? It's got a _very_ long RequestTimeout, yet
looks like it won't be able to complete in that time. I'm
surprised it hasn't taken the CF server down, so it
Are there any other methods of seeing debug output from a CF5 development
server other than by designating a list of IP addresses? Cookie based, for
instance?
We've got three developers in-house and the only way that I can see to get CF's
debugging to work properly (assuming that any given
We're moving a number of backend databases from Access2000 to MySQL 3.23
(MyISAM) tables. As with Access, we're using ODBC (CF5) to talk to the MySQL
server. Any advice or gotchas we should be aware of? Things that worked in
Access that won't work in MySQL?
Thanks,
Jim
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 3:00 PM
Subject: Re: Access to MySQL Migration
Jim McAtee wrote:
We're moving a number of backend databases from Access2000 to MySQL 3.23
(MyISAM) tables
- Original Message -
From: Michael T. Tangorre [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 4:01 PM
Subject: Message board / forums
Does anyone have a favorite message board app or forums app they can
recommend..
That is free? :-)
phpBB
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 4:44 PM
Subject: Re: Access to MySQL Migration
One thing we just noticed... MySQL recognizes C-style character escape
sequences, beginning with backslashes.
What's a good way to handle the following application?
FormA posts to itself so that submission errors can be displayed and so that it
can be repopulated with the original data with the errors displayed.
If there are no errors, proceed to FormB and pass along all data from FormA.
Can't do a GET
I don't really want to stash the data in a temporary table, since this web
site
currently isn't data-driven and has no data source available. Also, I don't
want to user session variables.
When the second form is being built, just create hidden form variables
holding the values from the
Maybe they went surfing on the 13th. :-) Hurricane Claudette didn't make
landfall on the Texas coast until Tuesday, July 15th.
http://www.chron.com/cs/CDA/ssistory.mpl/outdoors/2012834
Surfside Beach near Freeport was jammed with surfing traffic July 13 as the
then-tropical storm meandered
How do you display a query column that has a space within its name?
I'm executing a MySQL SHOW CREATE statement, which returns a one row data set
with two columns named TABLE and CREATE TABLE, but I'll be hanged if I can
figure out how to get CF to reference the latter.
Thanks.
: Column names with spaces
not sure you can? although, maybe its possible...in sql server i dont
think
you can, but maybe in mysql you can, good luck!!
tony
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Friday, July 25, 2003 11:34 PM
To: CF-Talk
Subject
PM
Subject: Re: Column names with spaces
You can alias the table name in the select statement, or you might be able
to do:
queryName[CREATE TABLE][1]
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, July 25, 2003 9:34 PM
Subject
#TimeFormat(the_time_in_hours/24, HH:mm)#
I use this all the time to format things like elapsed time in HH:mm:ss. You
might want to be careful if the value goes over 24 hours, howerver. If you
have a value of 36.5, for example, I believe CF would then format it to 12:30.
- Original
I've got a table with 'year' and 'month' columns used to track quantities (of
widgets sold, doughnuts eaten - doesn't really matter) for certain objects in a
given month. The reason that only monthly totals are kept instead of creating
a record for every transaction is that the table would
We've got a web site where we try to meticulously track page views and referers
(without using the web logs). What we run into is that many of the page views
are being logged by search engine robots. I _think_ this can be avoided using
robots.txt, but I'm not certain.
Say I've got a page on a
I've got an Access 97 database that has a lock file that won't go away. I just
need to delete the database file, as we've migrated the data to MySQL. The
Access database is no longer being used, and I've deleted the old ODBC dsn
pointing at file. I've tried the usual bad query against the db.
- Original Message -
From: Dan Phillips [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 3:06 PM
Subject: RE: The Access .LDB file that will not die
You can disable the DB connection in the Administrator, then delete the
ldb file, then re-enable the DSN.
I've got a small app with a directory structure something like the following:
/
/catalog
/css
/maint
/products
/orders
/images
/includes
Within /includes I have common header and footer files, with the header
containing (simplified):
html
head
titleApplication_Name/title
/head
Show the code that is generating the error.
- Original Message -
From: Ryan Mitchell [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, July 12, 2003 11:38 AM
Subject: Php in cf help...
Hello
Im trying to include a php file within a cold fusion page, and in doing so
(2.50) which were current for the older db.
Matt Robertson [EMAIL PROTECTED]
MSB Designs, Inc. http://mysecretbase.com
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED
Maybe I'm missing something, but if we're talking about CF5 access only through
the MyODBC driver (maybe we're not) then why not just use ODBC formatted dates
date/times?
- Original Message -
From: Barney Boisvert [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July
So CFMX has a native driver for MySQL? I assume that if you had been using the
MyODBC driver with CF5, you could continue to use it with CFMX? Of course, my
original post in this thread was about how I could get away from using MyODBC
with CF5. :-)
I've never used any of the native drivers for
- Original Message -
From: Matt Robertson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 11:30 PM
Subject: RE: CF5 to MySQL without ODBC
Jim wrote, perplexed:
So CFMX has a native driver for MySQL?
Sorta kinda. It's the 'native' jdbc driver and it
Use forms AND non-standard role addresses. A form doesn't do you any good if
you've still got valid webmaster@ or info@ or admin@ addresses.
- Original Message -
From: Owens, Howard [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 12:48 PM
Subject: RE:
To what end? It's not doing you any good and I doubt if you're saturating
anything.
Those addresses will be used and sold and resold and even though the
connections will be refused, they hit real mail servers and use up real
resources. We've retired hundreds of email addresses over the years
We've begun moving a number of application databases from Access97 and
Access2000 to MySQL 3 and we're currently using the MyODBC 3.51 driver to work
with them from CF5. While I'm guessing that MySQL will behave much better than
Access under load, under light loads it's pretty easy to see that
For a very large file, something in between. If you build a big file within
memory (in an array or text variable) then you risk bringing the machine to a
standstill or even crashing it.
If you append to a file line by line a couple of million times you'll also tax
the system and won't be doing
I didn't know the looping condition for your particular application. You'd
just loop over your query.
cfloop query=myquery
...
/cfloop
- Original Message -
From: James Blaha [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 11:37 AM
Subject: Re: best
If you just want to replace all occurences of ~AA (caps only), anywhere in the
file and you have the entire file contents in a single variable, the following
should work:
cfset y = REReplace(x, (~[A-Z]{2}), \1~, all)
If you need to discern this character sequence only when it's the only thing on
Do you have CF Studio or HomeSite+? They both permit the use of re's in the
Extended Find and Extend Replace dialogs. The regex syntax should be pretty
much identical to CF Server's syntax. Hard to say what TextPad's abilities or
quirk's are when working with regular expressions.
From your
Can you put leading and trailing commas into the field?
,1,3,9,12,2,51,
SELECT EmailAddr, RecipientID
FROM SupportEmailRecipient
WHERE SubjectID LIKE '%,#FORM.SubjectID#,%'
Better would be to normalize the data into two tables.
- Original Message -
From: Lee Fuller [EMAIL
Han anyone run into this?
I've got a W2k server running MySQL. I set up a MySQL database with a couple
of tables and a MySQL user with password and access to that database.
On another server running CF5 I install MyODBC 3.51 and create a System DSN
pointing at the MySQL database. I enter the
Just reread this. Should read:
From CF, though, I can't connect to the database unless I supply a username and
password.
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 3:54 PM
Subject: MySQL ODBC Problem
Han
, [EMAIL PROTECTED]
MSB Designs, Inc. http://mysecretbase.com
---
-- Original Message --
From: Jim McAtee [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Tue, 1 Jul 2003 15:54:33 -0600
Han anyone run
Thanks, that did it. I was somehow under that impression that the CFAdmin
wouldn't even see the datasource, so never looked at it there. It can't edit
any aspect of the System DSN, but it does let you specify a username and
password to be used by CF.
Thanks,
Jim
- Original Message -
cfset temp = 7/8
cfoutputtemp = #temp#/cfoutput
- Original Message -
From: Che Vilnonis [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, June 30, 2003 3:26 PM
Subject: Is there another way to write this???
cfset temp = 7/8
cfoutputtemp = #Evaluate(temp)#/cfoutput
so
[EMAIL PROTECTED] wrote:
I'm not too sure how many people out there know about this problem but I
just experienced it for the first time and had never heard of it before.
Hopefully this will save someone else the frustration I just went though:
I was setting up a new server today with
Has anyone got a CF tag or function that can take a raw email message
(including all headers and potentially multiple attachments) and parse it into
standard headers (To, From, CC, Subject, Reply-To), plus body, plus peal off
the attached files? Ideally, able to function with HTML formatted
- Original Message -
From: Rafael Alan Bleiweiss [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 5:20 PM
Subject: WAY OT - Setting Mail Server to block relaying
If anyone can point me in a direction or to a mailing list on topic, I
would greatly
Michael Dinowitz wrote:
Post.Office is officially abandonware and is close to impossible to secure. I
highly suggest getting a different mail server. Any mail server will do at
this
point as long as it allows for security.
I'd be amazed if it can't be locked down to deny unwanted relaying.
Assuming you're using an ODBC datasource... How about an external application
this is constantly checking the availability of the databases in question, and
modifies the ODBC DSN to point at a working one?
- Original Message -
From: admin [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Jochem van Dieten wrote:
I've got developers that I give admin access to CF for creating DSNs and
scheduled tasks, as well as viewing CF's logs. But they don't have the
ability
to use Terminal Services into the machine to get to the control panel.
It is just a bunch of registry keys. One
Has anyone made the necessary mods to the CF5 Administrator that they'd care to
share? We're thinking of using MySQL and MyODBC for some new projects and it
would certainly be handy if we could create/edit the ODBC DSNs from the CF
Administrator.
Thanks,
Jim
- Original Message -
From:
: Jim McAtee [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Wed, 18 Jun 2003 16:49:05 -0600
Has anyone made the necessary mods to the CF5 Administrator that they'd care
to
share? We're thinking of using MySQL and MyODBC for some new projects and
it
would certainly be handy if we could
I need to read in and parse text files with cr, lf, or cf/lf delimiting the
lines. I could use CF's list processing except that I must be able to see
blank lines, which the following will skip over:
cfset crlf = Chr(13) Chr(10)
cffile action=read file=#thefile# variable=filestuff
cfloop
Has anyone here implemented or heard of a telnet client written in CF (v5 or
earlier)? I've got some telnet controlled devices that I'd like to create a
web-based interface for. I'm thinking of perhaps emulating a telnet client,
with text screen output and throw in a few buttons and controls for
-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 10:04 AM
To: CF-Talk
Subject: Web-based telnet client?
Has anyone here implemented or heard of a telnet client written in CF (v5 or
earlier)? I've got some telnet controlled devices that I'd like to create a
web
Say you have a begin date and an end date. For instance 7/12/03 and
2/23/04. I want to create calendars for each month in the date range, so I
want to construct a loop to step through each month in the date range. From
July 2003 through February 2004 in the above example it should iterate 8
Is there anything similar to the PHP open source project Gallery available for
Cold Fusion? I've been playing with some php open source projects such as Post
Nuke, phpBB2 and Gallery for the past week and they are some impressive pieces
of work.
The Gallery project on SourceForge can be found
, Australia
AFP Webworks.
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Sunday, 6 April 2003 12:17 PM
To: CF-Talk
Subject: (Photo) Gallery for Cold Fusion?
Is there anything similar to the PHP open source project Gallery
available for
Cold Fusion? I've been
I've been running CF Studio 4 for just about forever. I recall trying 4.5 quite
a while ago and not particularly liking it, but I'd like to try it out again.
Can I run both on the same machine, so that I could uninstall one or the other
if I choose? It would be easier than installing,
I've seen similar things implemented elsewhere. It should begin with a default
and have a very brief explanation, or else a help link. Sure, the user can
screw up the look of the output, but so long as you control it to the point of
not allowing them to create errors when the code executes, it
Tom,
In Access, something like the following works for us, where 'PrimaryKey' is a
unique key in the table:
SELECT *
FROM CompanyTbl
WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic = 'Yes'
ORDER BY ClassOfService, rnd(PrimaryKey)
If you're not seeing the expected number of records,
One small disadvantage, depending on your application (and your user base): If
you want to implement an I forgot my password page and email the _current_
password to the user, you can't do it. You've got to generate a new password
first and email it out before hashing it into the db.
I've seen
Tony Schreiber wrote:
I want to be sure that I never, ever, ever, send a user's password to them
in clear text email. This is important because as many websites as people
log into they do not always a different password to each one. Their
password on my site could be the same as their
#ReplaceList(co1005, ,, ,)#
Robert Orlini wrote:
I am using the Replace function to clear a character in a
column.
The line I use to display between cfoutput is: #replace(col005,
, , all)#.
This is probably simple, but the column data contains another
character I want to delete
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 7:23 PM
Subject: RE: NTLM Authentication
If I enable Basic Authentication for an IIS 5 web site
protected by NTFS ACLs, will Internet Explorer still
use NTLM to
The following should count non-whitespace characaters in a string:
cfset n = Len(ReplaceList(mytext, ,#Chr(9)#,#Chr#(13)#,#Chr(10)#, ,,,))
Jim
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 2:31 PM
Subject: Easy Len ?
If I enable Basic Authentication for an IIS 5 web site protected by NTFS ACLs,
will Internet Explorer still use NTLM to authenticate if its able to? In other
words, does enabling Basic Authentication keep IIS from using NTLM, or does it
only enable Basic Authentication as fallback method?
Jim
- Original Message -
From: Issac Rosa [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 10, 2003 11:59 AM
Subject: Changing from HTTPS to HTTP for normal pages
What's the best way to setup the page links so that when you go to a secure
page
via https and then go to a
- Original Message -
From: samcfug [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, March 08, 2003 11:11 AM
Subject: Re: CF and MySQL
Also uncheck the keep connection alive
Why? I remember quite a few problems with CF memory leaks and earlier MS ODBC
drivers. Are there
I've got an intranet site that uses a simple frame construct for navigation. It
has a 60 pixel tall navigation frame across the top of the screen that uses
icons and text links, while the working application pages are displayed below.
I'd like to convert this to using DHTML drop-down menus within
I think CF just does an operating system function call to retrieve the directory
listing, as would any other language. Performance should be fine unless you've
got thousands of files in the directory. If you anticipate having quite a few
files, use some type of convention for creating
You don't need CALs for anonymous connections to either a CF web site or a
non-CF web site. You only need CALs for connections that use Windows
authentication, such as IIS' FTP users. Also, shop around - you should be able
to find Windows 2000 w/5 cals for under $700.
Jim
- Original
- Original Message -
From: dan martin [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 12:46 PM
Subject: win 2000 professional for web server?
I called MS and was told that I need three sets of licenses with separate part
numbers:
1. for win2k server @ $738
Then use CF and its regex capability (maybe just ReReplace()). It's unlikely to
be anywhere near as fast as Perl, but if you're not processing hundreds or
thousands of files, big deal. CF shouldn't have much of a problem with 5MB
files. If they were 100MB I'd look elsewhere.
If you wan't to do
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
You might also want multiple web servers if you have scripts
or other non-CF stuff on your site that puts load on the
web servers.
Why wouldn't I just put that stuff on a web server that's not using CF?
If you've got only
Do you actually need to populate an array with all the possible dates? You can
test if any given day is one of the recurring days using the mod operator and
DateDiff() function.
How about the following to generate an array. I've added an end date, which
wouldn't necessarily have to fall on one
- Original Message -
From: Russ [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 12:16 PM
Subject: Allowing specific HTML tags to be displayed
I've still not had any luck trying to get Replace or ReReplace to allow
a set of specific codes when displaying
I don't think I'd trust that approach. It's too dependant on the way the
browser submits the form. There's no guarantee that the 1st item in the
list #form.a# will correspond to the first item in list #form.b#, etc.
Probably most browsers _do_ work like this, but it's nearly as easy to name
the
I suspect the code you posted may not reflect what you're using. In any case, I
wouldn't recommend doing all the comparisons of days, hours, minutes and seconds
to tell if an auction has ended. You've got the end date/time (deadline) and
you know what the current date/time are (Now()). Just
Any ideas why I might be seeing duplicate email addresses in the dataset
returned by this simple query (Access 97 via ODBC)?
cfquery name=r datasource=#dsn#
SELECT DISTINCT(email), name
FROM table1
WHERE status = 'A'
AND email ''
/cfquery
In the output, I'm seeing stuff like:
[EMAIL
PROTECTED]
Sent: Monday, January 27, 2003 6:24 PM
Subject: Re: OT: Problem with DISTINCT()
That happened to me too - then I found out it was trailing white
spaces.. try trimming the white spaces
Jim McAtee wrote:
Any ideas why I might be seeing duplicate email addresses in the dataset
Thanks. I understand what you're saying. I couldn't get the suggested query to
complete until I indexed the email field, but now it's pretty quick.
Jim
- Original Message -
From: Matthew Walker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, January 27, 2003 3:24 PM
I'd like to move a custom tag from a web site's local directory tree to one
designated in the CF Server Administrator's 'Custom Tag Paths'. This is so that
it can be used by another web site and so I don't have to maintain multiple
copies of the tag.
How do I get CF to recognize the new location
How can I go about ordering the following query by first name?
cfquery name=emp datasource=#dsn#
SELECT DISTINCT(t.employeeid),
e.firstname + e.lastname AS name
FROM transactions t
LEFT JOIN employees e ON t.employeeid = e.employeeid
/cfquery
The following query throws an error about
Tried that first, but same error (Access DB). Matthew's suggestion of adding
e.firstname as a selected field did the trick, though.
Thanks all!
- Original Message -
From: Bryan Love [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, January 22, 2003 6:34 PM
Subject: RE:
Just wondering if any else has noticed this bug. It's somewhat inconsequential,
but I'm righting an email log analyzer where it's proving a problem.
My email server's SMTP process logs a short summary of messages that it receives
for relaying. From these logs, it appears that in the SMTP EHLO
401 - 500 of 1058 matches
Mail list logo