What about this ???
SELECT #Year(todayDate)# - Year(HIRE_DATE) AS YearsWithFirm,
#Year(todayDate)# - Year(HIRE_DATE)AS TotalYearsExperience
WHERE YEARS_OTHER_FIRMS IS null
UNION
SELECT #Year(todayDate)# - Year(HIRE_DATE) AS YearsWithFirm,
#Year(todayDate)# - Year(HIRE_DATE) +
They should actually rename the tag to CFPOOP
@llan
-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 2:12 AM
To: CF-Talk
Subject: Re: cfpop alternitives
well you can check out what is available from
http://www.coolfusion.com
Douglas
is this Is it possible to query the full list for the
email addresses that are not in the database ???
Any help is appreciated!
Allan Pichler .:.
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http
Thanks for you input Justin,
But I think I need to find a workaround in a typical case of this page
the original list holds 30-90.000 addresses and the partial list
contains 0-90.000 addresses . needless to say that this query takes
forever...
=)
@llan
-Original Message-
CFSET Future_Date = dateadd(n, 30, now())
Look in the CF Language Reference for other date parts!
@llan
-Original Message-
From: David Boyd [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 11:58 AM
To: CF-Talk
Subject: Getting Future Date + 30 Minutes...
Hi,
Can anyone help me
The whole problem is that this is a mailjob application that allows our
clients to upload huge txt files with email addresses and other relevant
information to our server along with some html files that gets processed and
then sends out the emails.
CF DOES NOT SEND THE ACTUAL EMAILS!
I have
I need it to run on-the-fly to create a new .dat file for the mail system.
OT: anyone have a list comparing algorithm for Perl ??
:) @llan
-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 1:11 PM
To: CF-Talk
Subject: RE: Simple question
The end of it all is that I'm made cf process the whole thing even
though it takes 34,000 queries into the db, but after adding an index to the
table it processes 1000 queries in 2.9 seconds so the new file will be built
in less than 2 minutes I think that's acceptable.
Thanks for all
I second that
--Allan
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 4:45 PM
To: CF-Talk
Subject: RE: neo question
Yes, for the love of god, PLEASE stop posting questions about neo. It's not
that your questions bother me, it just
For some reason this question keeps popping up in here .
There are two tags on the Developer Exchange that accomplish this,
CF_TwoSelectsRelated tag by Nate Weiss:
http://devex.macromedia.com/developer/gallery/info.cfm?ID=CA347197-2830-11D4
-AA9700508B94F380method=Full
and
CF_JSelect by
http://www.coderbox.com/tip_details.cfm?tid=77
has a little info on it ... as I recall it's a function without parameters
and it's called CFusion_DBConnections_Flush()
@llan
-Original Message-
From: Kevin McCabe [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 12:43 PM
To:
-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 11:03 AM
To: CF-Talk
Subject: RE: HELP NEEDED
Well ... the problem is that the other box is a FreeBSD box! Can I use
cfexecute to solve my problem
@llan
-Original Message-
From
I have a little problem guys and i need your help!
I've made a little perl script that runs every 5 minutes, it checks a MySQL
DB to see if there's any mailjobs scheduled that needs to be executed.
If there's jobs in queue it runs another perl script with the id of the
mailjob as an argument.
it be
easier to accomplish that w/ a perl cgi script?
c'anyone tell i'm having a slow day? :P
Allan Pichler [EMAIL PROTECTED] on 03/14/2002 09:24:14 AM
Please respond to [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
cc:
Subject: HELP NEEDED
I have a little problem guys and i need your help
Small
-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 10:24 AM
To: CF-Talk
Subject: HELP NEEDED
I have a little problem guys and i need your help!
I've made a little perl script that runs every 5 minutes, it checks a
MySQL
DB to see
You can find a custom tag that does it in the components section of
www.coderbox.com
@llan
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 12:28 PM
To: CF-Talk
Subject: udf to recognise url in a block of text or do i need a regex?
Hi guys,
Make sure that it's not set to 20 minutes in the CF Administrator . the
max time in cf admin overrules anything you might have set in the
application.cfm
@llan
-Original Message-
From: Justin Hansen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 4:38 PM
To: CF-Talk
my queries and user authentication here ---
/CFPROCESSINGDIRECTIVE
CFSETTING enablecfoutputonly=No
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
html
...
...
/html
but prior to the !DOCTYPE ...
i get 239 lines of whitespace
Can anyone help ???
Allan Pichler // Senior
Tel +44(0)28 7127 3100
Fax +44(0)28 7127 3101
-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 9:39 AM
To: CF-Talk
Subject: Weird whitespace issue ...
I have this minor issue with my code . for some reason i have 239
lines
OF COURSE
I'M STUPID!!
i forgot to put the CFSILENT in the application.cfm as well
Thanks for the help!
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: 7. februar 2002 11:04
To: CF-Talk
Subject: Re: Weird whitespace issue ...
Allan Pichler wrote:
I
what about this ...
CFSET banlist = 64.0.0.1,65.0.0.1,66.0.0.1
CFSET myip = 64.0.0.1
CFIF listfind(banlist,myip) IS NOT 0
banned
CFELSE
not banned
/CFIF
just replace myip with cgi.remote_addr
:) @llan
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
or you can add a trigger to the sql server that runs on insert
statements to
that table
SELECT @@IDENTITY as newID
@llan
-Original Message-
From: Stuart Miller [mailto:[EMAIL PROTECTED]]
Sent: 11. januar 2002 14:32
To: CF-Talk
Subject: RE: SQL Help
Your query will run in Query
There should be a custom tag available to sort multidimensional arrays!
can't remember the name though!
@llan
-Original Message-
From: Matt Kornguth [mailto:[EMAIL PROTECTED]]
Sent: 10. januar 2002 14:57
To: CF-Talk
Subject: Re: Sorting multi-dimensional arrays?
Tried that. Get the
Hi Steve,
i have just been making a mailclient in cf/js, and i haven't even noticed anything
funky with it.
CFPOP on the other hand is as buggy as ever!
Mail me off-list if you wish to see some of the code for it.
:) Allan
-- Original Message --
From:
Hi all,
I'm building a webmail client right now, and i can't seem to get the attachment part
right. For some reason my CFCONTENT tag that prompts the user to save/open doesn't
accept all extension.
The case in point is a .psd file, but my mail client should be able to handle any
extension.
Does CF Express work with SQL server ?
The following is from the documentation on CF Express:
ColdFusion Express, as with other editions of ColdFusion, supports any ODBC database.
However, the Express installation process installs the following drivers, which we
know to work well with
Off Topic
-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 11, 2000 2:17 AM
To: CF-Talk
Subject: What does OT mean?
Other things??
~~
Structure your ColdFusion code with Fusebox. Get the official
Try this instead
!! this is line 98!! cfif ProdCount LTE "3" AND ProdCount GTE "1"
That should fix it for you!
Allan Pichler
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 9:40 AM
To: CF-Talk
Subject: can
UBB is Ultimate Bulletin Board
Allan Pichler
-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 2:06 PM
To: CF-Talk
Subject: RE: SimpleMessageBoard now available
Pardon my ignorance, but what is UUB?
--
Clint Tredway
CFSET temp = StructDelete(session, "yourkey", TRUE)
Allan Pichler
-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 9:16 AM
To: CF-Talk
Subject: Killing Single Session Variable
how do u kill a single sessio
That is correct ... the scope attributes was introduced in version 4.5
Allan Pichler
-Original Message-
From: JB Mentzer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 7:25 AM
To: CF-Talk
Subject: CFLOCK question
Hi all
I'm attempting to execute this:
cflock scope
You can do it this way
CFSET newfilename=left(File.ServerFile,(len(File.ServerFile)-4))
Allan Pichler
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 10:56 AM
To: CF-Talk
Subject: trim a string variable
Is there a way to trim a string
Is it just me, but CFDIRECTORY grabs a directory of the server, so you can't
use that to do a batch upload of images from a client!
Allan Pichler
-Original Message-
From: Christoph Schmitz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 10:37 AM
To: CF-Talk
Subject: AW
Use #evaluate("form.qty" x)#
Allan Pichler
-Original Message-
From: Roozbeh Hashemiha [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 28, 2001 6:53 PM
To: CF-Talk
Subject: loop and # sign as a part of form object
Basic problem ... please help guys !
cfloop index="
Just out of curiousity ...
Are we talking about the distance in a straight line (so to speak) or is it
the shortest distance you're looking for ?
Allan Pichler
-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 27, 2001 6:12 PM
To: CF-Talk
Subject
Correct me if i'm wrong, but in a spherical environment (the earth) a
straight line is not always the shortest is it ?
Allan Pichler
-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 27, 2001 10:06 PM
To: CF-Talk
Subject: RE: The real distance
ot;-1"nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
option value="-1"nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
option value="-1"nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
option value="-1"nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
Hope this works for you as well
Allan Pichler
-Origi
Flash is all good for fancy presentations. But that's not where the
majority of inet use is. It's still about making nice but fast presentation
of useful data.
That's my 2 cents
Allan Pichler
-Original Message-
From: Scott, Andrew [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January
Try to remove your body /body tags from the file
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 15, 2001 12:38 PM
To: CF-Talk
Subject: Cannot define a frameset in .CFM file?
Hi,
I'm trying to define some
Hi all,
is the datepart "w" not supported anymore ?? or is it just buggy ?
IMHO #dateadd("w", 1, now())# should return this time monday but it
doesnt't ....
Very weird ...
Allan Pichler
~~
Structure your ColdFusi
Try this
WHERE datefield = #createodbcdate(now())#
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: JB Mentzer [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 11:02 PM
To: CF-Talk
Subject: how to match dates?
Hi all
I'm trying to write a query to find records
That's actually a very interesting point to bring up
It seems that almost all european countries uses php/asp whereas over here
the market has room for all of the scripting languages is it the price
for a license that scares companies in europe ??
Allan Pichler
Machine Dreams Inc
cents!
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: Martin Sutton [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 2:18 AM
To: CF-Talk
Subject: RE: Slightly OT
I think that possibly Microsoft (therefore ASP) has a stronger marketing
machine here because our
Handcount the votes ??? only in florida ??
Allan
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 10:39 AM
To: CF-Talk
Subject: Re: And the award goes to ..
I demand a recount!
Howie
- Original Message -
From: "Hoffman, Joe
Well ... you could have a counter that got incremented if the item wasn't
deleted ... that should keep track of the current position
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: Lee Surma [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 10:54 AM
To: CF-Talk
i would
really hate to switch over to ASP/PHP.
Allan Pichler
Machine Dreams Inc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffus
;#trusted_connection#"
CFREGISTRY action="SET"
branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#newdatasource#"
ENTRY="UseProcForPrepare" value="#UseProcForPrepare#"
CFREGISTRY action="SET"
branch="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\#
Use the function DeleteClientVariable("myvar")
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 28, 2000 9:53 AM
To: CF-Talk
Subject: how do i delete client vars?
I know how to delete a session variable usi
That's how it is for us "Old Timers". Maybe that monkey butt formula is not
as good as we thought.
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 28, 2000 10:16 AM
To: CF-Talk
Subject: RE: how do i del
mid(string, 3, 1) should do the trick for you
:)
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: Eric J Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 27, 2000 10:31 PM
To: CF-Talk
Subject: brain dead easy ?
I need to remember how to find out what the third
Try this
SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"
function openpopup(){
popwin=window.open("login.cfm","newWin","width=200,height=150,left=400,
right=300")
popwin.focus();
}
/SCRIPT
BODY ONLOAD="javascript:openpopup
if i'm wrong but that's not the purpose of this mailing list is it
?
Merry Christmas!
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 23, 2000 6:58 PM
To: CF-Talk
Subject: Hosting Options
Good Evening
No it's not!
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:47 AM
To: CF-Talk
Subject: Duplicate supported in CF4.0
Quick question
is the Duplicate function supported in CF4.0?
Best regards,
Johan
StructCopy(structure)
-Original Message-
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:54 AM
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0
How do you duplicate a structure in CF4.0?
-Original Message-
From: Allan Pichler [mailto
Remove the CFdocs folder under wwwroot if it's a production server
Never have passwords for datasources in your cfm files, instead configure
them with their respective datasources in the cf administrator.
Change the password for login "sa" if you're using SQL Server
Allan Pichl
or for example
#datediff("h", timeformat("6.00 AM", "H:mm"), timeformat("5.00 AM",
"H:mm"))#
the above example should return -60 but it doesn't
Now i'm not looking for a solution just another perspective on this
issue!
Alla
This is how i use dynamic variable names on the left side of a cfset
there's probably other ways to do it too
CFLOOP from="1" to="20" index="i"
CFSET varname = "myvar" i
CFSET "#varname#" = i
/CFLOOP
Allan Pichler
Machine Dreams In
the .htr
extension and delete!
Hope it works for you (i'm actually not in front a server, so i'm not really
sure if i remember the IIS console correctly, but you should be able to
figure it out)
Allan Pichler
Machine Dreams Inc
-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent
this should do the trick
CFSET monday = dateadd("d", ( evaluate( - (dayofweek(date) - 2))), now())
Sets monday to the last based on todays date!
Allan
-Original Message-
From: Brent Goldman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 19, 2000 6:29 PM
To: CF-Talk
Subject: How
Well ... the first thing that i noticed was that it requires at least IE 5.0
. h ... but it's not working with IE5.5
:) Interesting browser check!
-Allan
-Original Message-
From: Gena [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 09, 2000 1:59 PM
To: CF-Talk
Subject: Re:
CF looks in the current folder for a application.cfm file, if it doesn't
find one it'll step back one (IE: cd ..) and look for it ... etc etc etc
So yes ... it's very possible to have multiple application.cfm files
As far as the error goes i have no clue ... SORRY!
-Allan
-Original
- webos.org
You are mistaken. beta.allaire.com is open for investigation :)))
Regards
- Original Message -
From: "Allan Pichler" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, December 19, 2000 11:50 AM
Subject: RE: Cool CF site - webos.org
Wel
BCC is an attribute that was added in CF 4.5, so that's probably why it
doesn't run on CF4.0
-Allan
-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 18, 2000 5:58 PM
To: CF-Talk
Subject: Strict Attribute Validation
We're currently running CF
, then
b = x * (1 + r/p) ^ np
or something like that
Nick
-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 15, 2000 10:37 AM
To: CF-Talk
Subject: RE: compound interest
Nope i gave you the formula for n years
b = result / balance
x
I have had problems with my postings as well FYI: this is sent at 2.38
PM (Pacific)
Allan
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 15, 2000 12:23 PM
To: CF-Talk
Subject: Re: Loong delay in postings
Nope, I'm seeing a 7-9
to $12,624.77 if
you leave it for 4 years
10,000 * (1.06)^4 = 12,624.77
Hope this is what you're looking for!
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: Jason Egan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 3:08 PM
To: CF-Talk
Subject: ot: compound
You're using the wrong division symbol!
/ returns a regular division
\ returns the integer result of a regular division, that means ... no
decimals!
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: Rick Lamb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 9:02
one query is not possible.
Ask "mice" (-- irc handle) i believe he's working for the same company as
you. (thesquare.com)
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: Eli Shechter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 10:26 AM
To: CF-Ta
Your new boss obviously doesn't worry about development time since he
chooses PHP over CF, and the points about security issues is FR
out. Obviously your new boss need some professional (mental) help!
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: Kelly Shepard
t rid off".
:)
Thanks in advance!
Allan Pichler
Machine Dreams Inc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.c
You need to have the value for the radiobuttons set to light and dark
instead of yes!
Allan Pichler
Machine Dreams Inc.
-Original Message-
From: C Kong [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 12, 2000 10:40 PM
To: CF-Talk
Subject: radio buttons and passing variable question
71 matches
Mail list logo