OK, query looks like:
cfquery name=getDATA
SELECT id,
resp_atty,
dsp_name,
CASE
WHEN dsp_millthou='thousand' THEN CAST(dsp_amount + '000' AS int)
WHEN dsp_millthou='million' THEN CAST(dsp_amount + '00' AS int)
WHEN dsp_millthou='billion' THEN
On Wednesday 02 Jul 2008, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
angencies talk about that there's more, less expensive developers out there
with these other technologies.
Uh huh, but they'll take longer to get stuff done than the more expensive CF
developers.
--
Tom Chiverton
i have two places that call the same form
here it validates just fine before the submit
http://rittal-corp.com/products/index.cfm?n1ID=1n2ID=1n3ID=1
but here
http://rittal-corp.com/products/product_details.cfm?n1Id=1n2Id=1n3Id=1pn=1500510
it validates, but stills submits with out forcing you to
Hello everyone,
Maybe it's obvious, but I'd like to include the #URL.klopper# variable
in my filename atribute when using cfdocument, so as to generate a
document for this specific page. (Pseudo) could would be something like
filename=c:\cfoutput#klopper#/cfoutput.pdf
Is this doable ? Fyi I'm
Yep ;)
cfset VARIABLES.klopper = URL.klopper
cfset VARIABLES.slachtdatum = URL.slachtdatum
cfset VARIABLES.dateiname = C:\#URL.klopper#.pdf
cfdocument format=pdf backgroundvisible=yes unit=cm
fontembed=yes filename=#VARIABLES.dateiname# overwrite=yes
cfinclude
Just wanted to share my work with the community. It's the least I can do after
asking for help on here all the time. :)
About my work ... it's a code review tool. I know there are already some out
there but I wanted to build my own, and use it mostly as a tool to learn
RegExs. There are
Les Mizzell wrote:
SELECT id,
resp_atty,
dsp_name,
CASE
WHEN dsp_millthou='thousand' THEN CAST(dsp_amount + '000' AS int)
WHEN dsp_millthou='million' THEN CAST(dsp_amount + '00' AS int)
WHEN dsp_millthou='billion' THEN CAST(dsp_amount + '0' AS int)
You have to put the case part in a subquery. You can't query against
something that doesn't exist yet, as thisValue doesn't. Give this a try:
SELECT *
FROM
(
SELECT id,
resp_atty,
dsp_name, CASE
WHEN dsp_millthou='thousand' THEN
On Wed, Jul 2, 2008 at 3:39 PM, marc -- [EMAIL PROTECTED] wrote:
Sounds plausible.
Yup - it's how CF's always worked AFAIK.
Why I want to know this is because I want to retain some information when
switching between Application A and Application B.
Honestly, it doesn't sound like you need
Hi, Will...
I read your blog on your code review tool. Looks interesting.
I've never used a tool like this and was wondering if you would
explain exactly what it does. What does it scan for?
(Knowing my code is always *perfect* and very *sexy* (as you like to say),
I'm wondering if it would be
Good pont Jochem...I hadn't even considered a max column size. Does SQL
Server have a largeint char type like MySQL?
andy
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2008 8:15 AM
To: CF-Talk
Subject: Re: Finding a number in a range -
Hi, Will...
I read your blog on your code review tool. Looks interesting.
I've never used a tool like this and was wondering if you would
explain exactly what it does. What does it scan for?
(Knowing my code is always *perfect* and very *sexy* (as you like to
say),
I'm wondering if
Hi, Will...
I read your blog on your code review tool. Looks interesting.
I've never used a tool like this and was wondering if you would
explain exactly what it does. What does it scan for?
I was basically building a pre-scan code review tool. lol
Once your code is submitted here at
Andy Matthews wrote:
Good pont Jochem...I hadn't even considered a max column size. Does SQL
Server have a largeint char type like MySQL?
Yup!
bigint
-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)
and I'm glad Jochem chimed in there, because I would have
Out of curiosity, why aren't tabs allowed? I personally prefer tabs because
their width can be adjusted by settings.
On Thu, Jul 3, 2008 at 10:08 AM, Will Tomlinson [EMAIL PROTECTED] wrote:
Hi, Will...
I read your blog on your code review tool. Looks interesting.
I've never used a tool
WHERE
(dsp_millthou='thousand' AND dsp_amount#Int(req.fromVALUE/1000)#)
OR
(dsp_millthou='million' AND dsp_amount#Int(req.fromVALUE/100)#)
OR
(dsp_millthou='billion' AND dsp_amount#Int(req.fromVALUE/10)#)
If I use a varient of this, I'm not even sure I need the CASE
Out of curiosity, why aren't tabs allowed? I personally prefer tabs because
their width can be adjusted by settings.
On Thu, Jul 3, 2008 at 10:08 AM, Will Tomlinson [EMAIL PROTECTED] wrote:
I was afraid this would become a topic of discussion. :)
Ok, they just don't allow them. Can we leave
Suppose it might. But that forces the user to make one extra choice when you
could just do it in the query.
And you shouldn't need to change any of the actual columns in the database,
just cast as bigint rather than int.
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Andy Matthews wrote:
Suppose it might. But that forces the user to make one extra choice when you
could just do it in the query.
Not really...
The way the search form *has* to be built is the same way the database
is put together. You enter a base amount like 2, and then there are
radio
Actually, MySpace launched a new version in the last few weeks, and
it's ASP.NET. Maybe there's still some CF on the back-end somewhere,
but as far as it looks to the public, they're a .NET shop now.
Scott
Now playing on iTunes: Goldfinger - Stalker
cf 8.0.1 WITH latest cumulative hot fix (including cfimage
hot fix).. Windows
What JVM?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago,
That's fine, I wasn't trying to start a flame war!
On Thu, Jul 3, 2008 at 10:40 AM, Will Tomlinson [EMAIL PROTECTED] wrote:
Out of curiosity, why aren't tabs allowed? I personally prefer tabs
because
their width can be adjusted by settings.
On Thu, Jul 3, 2008 at 10:08 AM, Will Tomlinson
Yes, it does. It seems to be more of a tool to determine whether or not
code complies with custom coding standards.
Since my code has no one to answer to, except the browsing public and
my clients (who wouldn't know enough to have standards requirements at this
point)
I'm not the target user
That's fine, I wasn't trying to start a flame war!
heehee... yeah, I've never started any of those on here myself AHEMMM.
My company has over 150 standards we must adhere to. No tabs, no carriage
returns
This:
if (someVar EQ 0) {
Do this
}
Must be:
if(someVar EQ 0){
Do this
}
That's why
Well there we go. That's even easier, and yes...that would be the best as
well.
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2008 9:57 AM
To: CF-Talk
Subject: Re: Finding a number in a range - sort of - problem
Andy Matthews wrote:
Suppose
If you are using cf8, you can make mapping variables local to the particular
site...I am not sure where it stored the data from cfadmin.
Eric
/*-Original Message-
/*From: sam menon [mailto:[EMAIL PROTECTED]
/*Sent: Tuesday, July 01, 2008 7:11 PM
/*To: CF-Talk
/*Subject: Coldfusion
On Wednesday 02 Jul 2008, James Holmes wrote:
I'll be watching this carefully - we've just deployed on SLES 32 bit
because we were aware of this issue
Did you report it to Adobe anywhere (contact install support, ...) ?
Please keep us all posted...
Well, it's been up for two days, rebooted
What version are you using? CF8 can plug into .NET, so anything done in
..NET by the agencies could still be used. I don't think the same is true
with php, but I could be wrong.
One of the issues I have run into is the lack of support for JBOSS, which
has also changed with 8.
I think the best
Companies love to spend money for the heck of it. Why do you think Adobe
raised the price of CF to make it more Enterprise-like in pricing? Of the
biggest complaints(comments) I have heard about CF (and, in my mind, the
most asinine) is that CF is too cheap to be a viable enterprise level
Is that a crayola color Gerald? *grin* I was going to ask the same question
hehehe
Eric
/*-Original Message-
/*From: Gerald Guido [mailto:[EMAIL PROTECTED]
/*Sent: Wednesday, July 02, 2008 11:25 AM
/*To: CF-Talk
/*Subject: Re: CF vs .Net or PHP - need arguement help
/*
/*I need a list
That's a pretty common thread with outsourcing to other countries and has
spearheaded the move back to using US developers in many cases. Even folks
who speak English just fine run into cultural differences in concepts that
cause communication issues. It has nothing to do with their ability to
Don't forget that CF gives you something like 14 or so ways to resize
an image. It covers a broad spectrum of quality versus speed. You may
want to play with those options.
On Wed, Jul 2, 2008 at 10:03 PM, Rick Root [EMAIL PROTECTED] wrote:
cf 8.0.1 WITH latest cumulative hot fix (including
Hi folks,
Scrambling here trying to restore a db on a ms sql server and cannot
connect with Enterprise Manager (another story). Is there a command line
utility out there anywhere that will let me restore a db from a .bak
file on a windows box? Or is there a way to do this from a CF query? TIA
I use Eclipse and CFEclipse. Eclipse uses an XML-based build engine called
Ant. It seems that Ant would be a perfect fit for something like what
you're describing. You would be able to code however you like and then run
the Ant script before committing the code.
On Thu, Jul 3, 2008 at 11:10
I use Eclipse and CFEclipse. Eclipse uses an XML-based build engine called
Ant. It seems that Ant would be a perfect fit for something like what
you're describing. You would be able to code however you like and then run
the Ant script before committing the code.
Leave it to me to reinvent the
Leave it to me to reinvent the wheel. :)
We all do it at one point or another.
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56551#306262
On Thu, Jul 3, 2008 at 1:01 PM, Will Tomlinson [EMAIL PROTECTED] wrote:
I use Eclipse and CFEclipse. Eclipse uses an XML-based build
Yes, we are SAS70 Type II compliant for dedicated environments. If you'd like
a quote on your particular hardware configuration please email me at
[EMAIL PROTECTED]
Thanks!
~|
Adobe® ColdFusion® 8 software 8 is the most
I wanted to see if I could use a negative look ahead on this block of code to
make sure if there's a var rbo=; in the code, there must be a rbo =
closeObj(); somewhere after it. Like so...
cfset str = '
cfscript
var rbo = ;
var someVar = Will;
var someOtherVar = Whatever;
Whateverelse logic
Hi all, this has been troubling me for a day or 2 now. I'm sure it must be
possible somehow?...
I'm trying to setup multiple sites under a single CF 8 instance (we currently
run cf in distributed mode and multiple instances, however this is more just
for demo purposes for various client sites
I didn't phrase that right. I want to check and make sure this is located after
the var rbo line. I guess I could do one at a time.
rbo = closeObj();
rbo = ;
~|
Adobe® ColdFusion® 8 software 8 is the most important and
Imperial, Robert wrote:
Scrambling here trying to restore a db on a ms sql server and cannot
connect with Enterprise Manager (another story). Is there a command line
utility out there anywhere that will let me restore a db from a .bak
file on a windows box? Or is there a way to do this from a
Dangit. I can't make this flag it. It LOOKS like it'd work.
Find the first instance of the rbo call, then make sure it's closed AFTERwards.
cfset str = '
cfscript
var rbo = ;
var someVar = Will;
var someOtherVar = Whatever;
Whateverelse logic here...
rbo = closestObj();
rbo = ;
/cfscript
'
Will,
Lookaround doesn't work with ColdFusion's regex engine. Instead, use Java's:
#str.matches(re)# (returns true/false)
also look into replaceFirst, replaceAll and split.
Ehh, I'd link my blog where I have a couple entries and a presentation on
it, but I've been having DNS issues for a few
Thanks for the quick reply Jochem, but after trying to run the following I
get an error(see below)
cfquery name=dorestore datasource=grandRounds
RESTORE DATABASE [DCCRegistry]
FROM DISK = N'C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\DCCRegistry_db_200806110200.BAK'
WITH FILE = 1,
Jason,
You mentioned the application proxy method, but I think you're doing it
wrong...
/com/domain/Application.cfc -- this is the main one
/domain.com/Application.cfc extends com.domain.Application -- nothing but
cfcomponent extends=... / inside
/domain.com/clientsite1/Application.cfc extends
What version are you using? CF8 can plug into .NET, so
anything done in ..NET by the agencies could still be used.
Well, in fairness, just because CF 8 can run .NET assemblies doesn't mean
that anything done in .NET could be used. For complete .NET integration -
analogous to the kind of
Thanks for the quick reply Jochem, but after trying to run
the following I get an error(see below)
...
Invalid SQL statement; expected 'DELETE', 'INSERT',
'PROCEDURE', 'SELECT', or 'UPDATE'.
You need to make sure your CF datasource allows the operation. This is in
your datasource
Hi Nathan
I guess I missed a small bit of info..
we require subfolders under each client to extend the client's root folder. ie
cfwebroot/
cfwebroot/client1
cfwebroot/client1/client1sub1
cfwebroot/client1/client1sub2
cfwebroot/client1/client1sub3
cfwebroot/client2
Will,
Lookaround doesn't work with ColdFusion's regex engine. Instead, use Java's:
#str.matches(re)# (returns true/false)
also look into replaceFirst, replaceAll and split.
Thanks dude! I'll check it out.
Will
~|
Adobe®
Thanks for the heads up Dave, now that I've take care of that I have a
new error.
Progress I guess :) now I get [Macromedia][SQLServer JDBC
Driver][SQLServer]Exclusive access could not be obtained because the
database is in use. I'm a little confused here, is the reference in the
error to the
Oh please, not again ;o)
I asked the same question.
Short answer: you can't, use Apache
Long answer:
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56546
Good luck,
Wim.
~|
Adobe® ColdFusion® 8 software 8 is
Ok it's late in the day and I've obviously overlooked the obvious here
:) I was trying to run this query via https and this box had a selSSL
cert installed on it, which is what was giving me trouble connecting via
the Enterprise Manager. I'll deal with that later but at least the
RESTORE ran under
Wim
Thanks for the reply! good to know it can't be done so I can stop looking
hah!.. btw.. do you have info on how to do it with Apache? From what I gather,
its something to do with virtualhosts?
thanks again
Jason
Subject: Re: Multiple CF applications under a single instance/webroot?
I'm delighted at the number of people who've had a look at the
tutorial i made on using object oriented approach to coldfusion
programmingI am mid way through the second part, which will
explain some of the odd things the first tutorial expects you to just
accept without question.And
Thanks for the heads up Dave, now that I've take care of that
I have a new error.
Progress I guess :) now I get [Macromedia][SQLServer JDBC
Driver][SQLServer]Exclusive access could not be obtained
because the database is in use. I'm a little confused here,
is the reference in the
Will,
Lookaround doesn't work with ColdFusion's regex engine. Instead, use Java's:
#str.matches(re)# (returns true/false)
also look into replaceFirst, replaceAll and split.
Check this out too:
http://www.bennadel.com/blog/769-Learning-ColdFusion-8-REMatch-For-Regular-Expression-Matching.htm
Wowee... in CF8, this works with a lookahead.
cfset str = '
cfscript
var rbo = ;
var someVar = Will;
var someOtherVar = Whatever;
Whateverelse logic here...
rbo = closeggObj();
rbo = ;
/cfscript
'
cfset re = '(?!rbo\s=\s;)\nvar\ssomeVar'
cfset result = REMatchNoCase(re, str)
cfdump
Why doesn't this work?
cfmail to=[EMAIL PROTECTED] cc=[EMAIL PROTECTED] from=[EMAIL PROTECTED]
subject=Cover missing for #title2x# #number#
#title2x# cat## #number# is in stock./cfmail
when this does work.
cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Cover missing
for
Wow, ok! [EMAIL PROTECTED] was not setup in my server's mailserver. So it's
interesting that cfmail won't send to ANY of the addresses if one of the
addresses is not set up.
Why doesn't this work?
cfmail to=[EMAIL PROTECTED] cc=[EMAIL PROTECTED]
from=[EMAIL PROTECTED] subject=Cover
explain doesn't work?
error? no email at all? just no email to the cc'd address?
check the undeliverable mail folder ( under your CF directory in
mail/undelivr ). also check the log files.
On Thu, Jul 3, 2008 at 2:13 PM, Richard Steele [EMAIL PROTECTED] wrote:
Why doesn't this work?
Lookaround doesn't work with ColdFusion's regex engine. Instead, use
Java's:
As far as I remember lookaheads work, lookbehind don't.
Please correct me if I am wrong.
Will, if you want to use Java RegExp, you can try this CFC:
http://www.massimocorner.com/coldfusion/cfc/tmt_java_regexp.zip
Hi Wim
Actually, I took a look at your previous thread
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56710#307393
and I think I might be in somewhat a slightly different situation although it
looks similar to begin with.
We run a SaaS app (so codebase is somewhat similar
Jason,
I get it, ok...
yeah... you can't do that.
well, there are workarounds
If you really wanted to, you could merge your sub-application methods into
your application.cfc, sort of like a duck-type thing. rename the existing
methods to super_onRequestStart or something, and make calls to
Here's what finally worked (simplified a bit):
cfswitch expression=#form.frommillthou#
cfcase value=thousand
cfset req.fromVALUE = form.fromAMNT * 10 /
/cfcase
cfcase value=million
cfset req.fromVALUE = form.fromAMNT * 1 /
/cfcase
cfcase value=billion
cfset
Thanks Nathan..
Hmmm I think that could get messy, if we grow in the number of sites for the
instance. I think we might have to just resort to explicitly naming the app
path in the extends parameter, and using ant to go through and replace it
accordingly for each site. I was hoping to find
Well, hypothetically, if I were in the beta I'd have seen that it was
already reported and that Adobe were aware of it since then and I'd be
under an NDA to prevent me from discussing it. I'd have also decided
to avoid the issue by sticking with 32 bit... hypothetically.
On Thu, Jul 3, 2008 at
On Wed, Jul 2, 2008 at 12:19 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
They're rebranding and reorganizing from scratch. It's driven by the
Marketing
folks and they want my feedback on what we should use, but the angencies
talk
about that there's more, less expensive
If you are using any Cold Fusion MX version you can use the underlying regex
engine. I came into this thread late, but if this helps you then great.
Take a look at the below blog to see what mean. This works with Cold Fusion
version 6 to current.
Most good languages also have an IDE that can format code for you, check out
Eclipse's (or maybe it is MyEclipse's not sure) Java code formatter it is
very nice and fairly configurable. Unfortunately I've never done one and I
know if I ask Mark he'll tell me to start coding ;)
Adam!
On Thu, Jul
Bah I say stand up and be proud ColdFusion is a great platform, CFML is a
great language
Adam, You ROCK!!
BEST Regards,
Gerald the PROUD CFer
PS Gawd do I love CF. He more I learn the more I love it.
On Thu, Jul 3, 2008 at 9:06 PM, Adam Haskell [EMAIL PROTECTED] wrote:
On Wed, Jul 2, 2008
Windows 2k3, Coldfusion 8.0.1 Standard on JDK 1.6.
Is it normal behavior for coldfusion to restart itself for no apparent
reason? And by restarting, I mean starting.. restarting implies it's
stopping.. there's no indication in the server log of it stopping. It
must be crashing and crashing
This has happened twice in the last 5 minutes. Exact same issue as
described below.
I have fusionreactor system metrics running and it showed only about
15% memory usage.
On Thu, Jul 3, 2008 at 11:45 PM, Rick Root [EMAIL PROTECTED] wrote:
Windows 2k3, Coldfusion 8.0.1 Standard on JDK 1.6.
Is
This looks like a bug in the Sun java hotspot compiler (the thing that
converts Java bytecode into native code after a certain number of
calls to the same class).
http://www.talkingtree.com/blog/index.cfm/2006/4/28/Understanding-HotSpot-in-Plain-English
On Fri, Jul 4, 2008 at 11:45 AM, Rick Root
Ok, every once in a while, usually the first time I load my website every few
hours, I am getting this error:
The system has attempted to use an undefined value, which usually indicates a
programming error, either in your code or some system code.
Null Pointers are another name for undefined
FYI,
Hi All just giving you my personal experience with this company?
They had me drive 600 Miles round trip for an interview did not pay for gas or
anything.
The kicker the interview did not happen because of their mistake. The CEO of
the company is not nice and not professional. Even after
That was the whole point Scott,
To tell the truth to people who might not take the time to email or even
read this message.
I am a man of courage and honor. I don't lie or hide behind my woman's
skirts.
So if a company does not want me because I told the truth about a bad
experience with
As most of the professional users of this site know, there are always 2
sides to every story. This site is to be used for professionals looking for
work. As many of you have seen, this is not the first negative post from
this individual. Slanderous comments posted are definitely considered
I am not sure what Mr. Vincent is trying to accomplish by sending these kind
of e-mails but I can talk for my own experience. I have worked with
recruiting companys like Robert Half Technology, Signature Consulting,
TekSystems, AppleOne among others and all I have to say to the recruiters is
THANK
Hello My Fellow IT Pros
This is my last post on this subject.
I have but three things to say!
Did the recruiter DENY any of my statements?
Did they say they paid me for my time or mileage?
Or that I did not drive 600 Miles for an interview that did not happen?
Did she deny that I had to deal
Just to clearify, you mean the arguing, not the bad interview experience,
right? It's jobs-talk, people can post their bad experiences if they like.
Personally, I find it fascinating reading, and I didn't think either Scott
nor Vincent had gone too far.
nathan strutz
http://www.dopefly.com/
On
Just a comment from the sidelines...I might be superficial, but just looking at
the emails at a surface level of grammar, punctuation, professionalism, I would
honestly say that I would give more weight to Ms. Skinner than Mr. Cannady.
Yes, I know that email standards are not the same, but to
Not to mention that this is the third or fourth such email from Vincent.
On Thu, Jul 3, 2008 at 2:23 PM, Kathryn Butterly [EMAIL PROTECTED]
wrote:
Just a comment from the sidelines...I might be superficial, but just
looking at the emails at a surface level of grammar, punctuation,
The point of the CF-Jobs-Talk list is not to negatively comment on any
one individual or company who posts to the CF-Jobs list (or to this
list, for that matter.) The point of CF-Jobs-Talk is to have a
discussion of issues that come up when one is looking for a job or
trying to find an employee.
83 matches
Mail list logo