Jennifer,
Looks like your database for client variables wasn't configured. If you
go into the CF Administrator there should be an option to create the
tables you need.
Steve
-Original Message-
From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 02, 2006 6:58
Delete from mytable_fav_cvs
Where date_set dateAdd(m, -6, getDate())
SHOULD delete every thing that is before 6 months from today.
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 02, 2006 6:13 AM
To: CF-Talk
Subject: ms sql - delete records
PROTECTED]
Sent: Thursday, February 02, 2006 7:09 AM
To: CF-Talk
Subject: RE: help! cgi.global
Hi Steven,
I've configed another db and other sites are using it ok.
It's only on this site and with one query I'm seeing the error.
jenny
-Original Message-
From: DURETTE, STEVEN J (AIT
Hi all,
I came across something today that just made my jaw drop...
I have a snippet of code:
cfparam name=form.myField default= /
cfif form.myField neq
cfset variables.myNewField = Didn't pass anything in /
cfelse
cfset Variables.myNewField = You passed in: form.myField /
/cfif
, STEVEN J (AIT) [EMAIL PROTECTED] wrote:
All,
I have considered using CFEclipse in the past. Even installed it
once,
but I couldn't find any tutorials or such that could get me up and
running quickly.
Recently I decided to try again. I have Eclipse and the CFEclipse
plug-in installed
All,
I have considered using CFEclipse in the past. Even installed it once,
but I couldn't find any tutorials or such that could get me up and
running quickly.
Recently I decided to try again. I have Eclipse and the CFEclipse
plug-in installed. Are there any good beginner tutorials out
I find it interesting that everyone is assuming that open source means
free.
It doesn't. I'm in a Linux+ Certification class and we had to watch a
movie about the history of Linux (et all). In the movie the people who
actually came up with the phrase open source, said it doesn't mean
free. It
But I thought that the license key was system specific.
When I got one for Windows (cf4) I thought the key started with a W and
someone from a different department got one for Linux and it started
with an L.
Of course my memory is faulty, I haven't had much sleep and all the
dayquil I've taken
Hi all,
Got a question on datasource problems. First I'll tell you that this is
CFMX7.01 (on one server) with IIS 6 [Win2K3] (on the same server),
MSSQL2K sp4 (different Win2K3 server).
When creating a DSN to a SQL server, what are the recommended settings
for the following?
Select method
Hi all,
After many years, I decided to go back to school and finish my degree...
One of my current classes is Linux + Certification and I am going to
have a project.
I was thinking that my project would be to create a Linux distro that
had just the tools needed by ColdFusion developers to do
the switch.
http://www.ubuntu.com
http://www.kubuntu.org
regards,
Casey
On 1/12/06, DURETTE, STEVEN J (AIT) [EMAIL PROTECTED] wrote:
I was thinking that my project would be to create a Linux distro that
had just the tools needed by ColdFusion developers to do their work
I was planning on having the cfmx 7 developer edition as an install
option if it works on Linux.
This may just be for me when all is said and done, but if I can get the
ok from Adobe (for the cf dev edition) I might release it. Or I might
just give an option in the install that goes out to
Well,
If there are no legal problems with including the developer edition with
the distro, then it would be totally self-sufficient storing all the
data (cfm files, etc) on the usb drive.
The extra software like Thunderbird would be for IF you had an internet
connection.
Steve
-Original
Ken,
Is it really necessary to disparage an ad campaign of a company that
might just have people on this list?
(READ THE SIGNATURE)
Thanks,
Steve
--
Steve Durette
Mgr - Results Mechanization
ATT
-Original Message-
From: Ken Ketsdever [mailto:[EMAIL PROTECTED]
Sent: Monday,
In my CF4 and CF5 days I found that it was actually faster to lock an
entire scope (application) then set multiple variables in that scope
before releasing the lock.
I'd do something like:
cflock scope=Application timeout=30 type=exclusive
cfscript
if(not
users to
opt-in?
That is an amazing.
Ken
-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Ken,
Is it really necessary to disparage an ad campaign of a company that
might just have people on this list?
(READ THE SIGNATURE)
Thanks,
Steve
--
Steve Durette
Hi all,
Every once in a while we get the following error:
Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Error
establishing socket. Address already in use: connect
The error occurred on line 42.
It happens at different times and in different pages/line numbers.
I
Rey,
I'd check the WI state website and find out information on sales tax.
If you do the wrong thing YOU could be held liable instead of the
client.
Better to go with official than guesses. Some states will fine you if
you charge to little or too much!
Steve
-Original Message-
From:
Try viewing this webcast:
http://www.ftponline.com/reports/wdwsf/2005/bowman1/
It has the speaker making a similar layout but shows how to deal with
some of the pitfalls.
Steve
-Original Message-
From: Connie DeCinko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 1:35 PM
on accident because I don't have FLEX and there
was my answer!
Sometimes it pays to read things that don't seem related.
Thanks,
Steve
-Original Message-
From: DURETTE, STEVEN J (AIT)
Sent: Thursday, April 14, 2005 10:20 AM
To: 'cf-talk@houseoffusion.com'
Subject: RE: Flash Forms Multi
then, did you call MM?
do you have a page up I can see and maybe get an idea from?
do you have flash 7 installed?
From: DURETTE, STEVEN J \(AIT\) [EMAIL PROTECTED]
Sent: Wednesday, April 13, 2005 4:42 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: Flash
Hey all,
I'm looking for someone who has set up CFMX7 Enterprise with the
Multiserver option, on Win2k3 with IIS6 using host headers.
That is my setup and I can't get flash forms working. I have followed
the directions to remove and re-run the wsconfig, but it didn't help. I
tried following
From: DURETTE, STEVEN J \(AIT\) [EMAIL PROTECTED]
Sent: Wednesday, April 13, 2005 3:40 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Flash Forms Multi-Instance Setup STILL
Hey all,
I'm looking for someone who has set up CFMX7 Enterprise
this for them to work and not just a
virtual mapping but the actual folder
From: DURETTE, STEVEN J \(AIT\) [EMAIL PROTECTED]
Sent: Wednesday, April 13, 2005 4:00 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: Flash Forms Multi-Instance Setup STILL
Not even
Hi all,
I'm resending this because it was late Friday when I originally sent it
and some of you might not have seen it.
Thanks,
Steve
-Original Message-
From: DURETTE, STEVEN J (AIT)
Sent: Friday, April 08, 2005 4:08 PM
To: 'cf-talk@houseoffusion.com'
Subject: CFMX7 Enterprise
, DURETTE, STEVEN J (AIT) [EMAIL PROTECTED]
wrote:
Hi all,
I'm resending this because it was late Friday when I originally sent
it
and some of you might not have seen it.
Thanks,
Steve
-Original Message-
From: DURETTE, STEVEN J (AIT)
Sent: Friday, April 08, 2005 4:08 PM
To: 'cf-talk
http://foo.goo:8000 provided you have
the
JRun admin server runing. Under each JRun instance that you have, you
should
see the EAR for CF listed as well as the Flash Remoting EAR. remove the
flash remoting one.
D
On Apr 11, 2005 11:29 AM, DURETTE, STEVEN J (AIT) [EMAIL PROTECTED]
wrote
Hi all,
I have a problem with what I'm assuming is flash remoting in CFMX7
Enterprise.
Whenever I try to use a flash form I get the following:
2 Errors found.
Error C:\websites\testFlashForm.cfm:-1
macromedia.css.LocatorParser
Error C:\websites\testFlashFor.mxml:349
The class
Hi all,
I've been reading a lot of articles lately about automated testing and
I'm hoping a few of you can answer some questions.
Are there any automated testing systems for developing web projects?
(Even better CF Specifically)
We have problems all the time of short due dates, we do our
by CF only. If you want a CF mapping to be
available via HTTP, you have to create a virtual dir.
Doug
On Tue, 25 Jan 2005 11:57:14 -0500, DURETTE, STEVEN J (AIT)
[EMAIL PROTECTED] wrote:
Ok, I did some testing and found out that while the cfc does work, you
can't get information from it like you
-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 25, 2005 3:39 PM
To: CF-Talk
Subject: RE: CFCs and virtual directories.
Doug,
That's been the issue all along. If I put the cfc into a directory
and
make a virtual directory
Ok, I did some testing and found out that while the cfc does work, you
can't get information from it like you would if you by doing something
like http://localserver/mycfcdir/mycfc.cfc
I'm thinking about seeing what happens when you have both a virtual
directory in iis and a mapping in
Hi all,
Got a quick question for you. I have created a cfc that I want
available to all urls on our web server (this is on an intranet). So, I
created a directory outside of the webroots and put the cfc there. Then
I went into IIS and created virtual directories on each of the websites
that
? or create a
new CFC custom tag directory / mapping?
ERJ
On Mon, 24 Jan 2005 13:20:14 -0500, DURETTE, STEVEN J (AIT)
[EMAIL PROTECTED] wrote:
Hi all,
Got a quick question for you. I have created a cfc that I want
available to all urls on our web server (this is on an intranet).
So, I
Hi All,
Need some help with a regex. What I'm trying to do is validate and
input in javascript.
The users are allowed to input a number.
It can be in the following formats:
9
9.9
9.99
.99
.9
(9 used inplace of any digit.)
I tried using \b[0-9.]+ and I've tried \b[\d]*([.]?[\d]{0,2})?
-0600, Greg Morphis [EMAIL PROTECTED]
wrote:
I think this will work..
^\d{1,2}.\d{1,2}$
(not tested)
On Mon, 10 Jan 2005 14:43:27 -0500, DURETTE, STEVEN J (AIT)
[EMAIL PROTECTED] wrote:
Hi All,
Need some help with a regex. What I'm trying to do is validate and
input in javascript
})?$
there that will catch 9, 9.9, 9.99, will not catch 9. 9.9.9, etc
On Mon, 10 Jan 2005 13:51:23 -0600, Greg Morphis [EMAIL PROTECTED]
wrote:
I think this will work..
^\d{1,2}.\d{1,2}$
(not tested)
On Mon, 10 Jan 2005 14:43:27 -0500, DURETTE, STEVEN J (AIT)
[EMAIL PROTECTED] wrote:
Hi All,
Need some
Hi all,
First let me say this is on an intranet... (the names have been changed
to protect ME!)
My original server was myServer.mycompany.com with a vanity urls of
vurl.mycompany.com, vurl2.mycompany.com. When ever I used cfmail and
set the to=test #chr(60)[EMAIL PROTECTED](62)#, you would
I saw this problem with CFMX 6.1 Enterprise. I just did a fresh install
of the J2EE type for a server mode. After I applied the updater and the
hotfixes/jrun updater I had these mappings also.
It broke our flash. I had to get rid of the .swf maping to make it work
again!
Steve
-Original
Hi all,
Does anyone know why certain users would be prompted to log in when using NT
Authentication when they are already logged in to a Windows nt/2000/xp
machine?
Here is the setup:
1) This is on an intranet.
2) All pages in the NT Authentication areas are .cfm
3) All users are members of
?
If Not maybe the account password has timed out if that is a settings
for the domain.
Just an Idea.
Cheers
BK
- Original Message -
From: DURETTE, STEVEN J (AIT) [EMAIL PROTECTED]
Date: Fri, 17 Sep 2004 10:31:15 -0400
Subject: CFMX, IIS5 and NT Authentication problem.
To: CF-Talk
Hi all,
Is there anyway to edit the value that is in the onsubmit portion of a form
tag?I know you can to formname.action="" to change the action,
but I need to change the onsubmit and I can't get it to work.
Every time I change it, it acts like there is nothing there.
Thanks,
Steve
480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
- Original Message -
From: DURETTE, STEVEN J (AIT)
To: CF-Talk
Sent: Friday, August 27, 2004 2:11 PM
Subject: OT: form onsubmit
Hi all,
Is there anyway to edit the value that is in the onsubmit portion of
ver
}
document.getElementById(formID).>
OR
document.getElementById(formID). {
// do whatever
};
cheers,
barneyb
On Fri, 27 Aug 2004 17:11:18 -0400, DURETTE, STEVEN J (AIT)
[EMAIL PROTECTED] wrote:
Hi all,
Is there anyway to edit the value that is in the onsubmit portion of a
form
tag?I kn
obj.event = function() {foo(goo)};
Doug
- Original Message -
From: DURETTE, STEVEN J (AIT) [EMAIL PROTECTED]
Date: Fri, 27 Aug 2004 17:35:07 -0400
Subject: RE: OT: form onsubmit
To: CF-Talk [EMAIL PROTECTED]
Ok,
I tried:
script language=_javascript_1.2 type=test/_javascript_ defer=onload
Hi all,
I have another strange one for you.I'm writing a custom tag and I want it
to do a cfheader.I can do this no problem, but what I'm looking to do is
have it so if I call the tag more than once in a page, the cfheader is only
done on the first call.
Any ideas how I might get it to do
Hey all,
Does anyone know of a Flash list like CF-Talk?
We are getting into using flash more and more and have some questions that
we need answered and I don't want to keep bothering you guys with OT stuff.
Thanks,
Steve
[Todays Threads]
[This Message]
[Subscription]
[Fast
cfscript
if(not isDefined(form.fieldnames) {
fieldnames = CCType,CCNumber,CCID,CCMonth,CCYear,CCExpire;
}
for(i = 1; i lte listLen(fieldnames, ,); i = i + 1) {
form[listGetAt(fieldnames, i)] = ;
}
/cfscript
Steve
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Tony,
What database are you using?Are you doing the purge through CF or the
database?
If you are using SQL server try making a stored procedure that does the
purge and schedule it through the Enterprise manager.
That way it is all done on the back end and you don't have to worry about as
Tony,
A few things that might help.
1) Use set nocount on and off.
2) Calculate the datediff once instead of multiple times. (not too sure on
this, I have seen it recalc not at all or on every record whatever the sql
server decides).
Like this:
create procedure storedProc_Kill_91stDay
Tony,
If you are just looking for the date, why don't you do:
select dateAdd(d, -91, convert(varchar, getdate(), 101))
That returns 5/6/2004 00:00:00.000
Steve
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 05, 2004 2:08 PM
To: CF-Talk
...
thank you steve.
ive just got it down to like 5 min to delete 2million rows.
timeID is an int, and yes its indexed.
thanks for the ideas...
tony
On Thu, 5 Aug 2004 14:06:42 -0400, DURETTE, STEVEN J (AIT)
[EMAIL PROTECTED] wrote:
Tony,
A few things that might help
, but is there a way to chunk
the data, like delete in 3 row blocks, and start again, etc.?
someone had suggested that as the way to do that?
tw
On Thu, 5 Aug 2004 16:26:34 -0400, DURETTE, STEVEN J (AIT)
[EMAIL PROTECTED] wrote:
Tony,
Remove the set rowcount 3It is limiting the delete to only
Tony,
The only thing I can say to that is run it one way , then run it the other
way and see which is faster.
There is an article about Query performance here:
http://www.databasejournal.com/features/mssql/article.php/3298411
http://www.databasejournal.com/features/mssql/article.php/3298411
Hi all,
I have an OT question about Flash Datagrids (Flash MX 2004 Pro 7.2).I used
Ben Forta's article on using datagrids in Flash
(http://www.macromedia.com/devnet/mx/coldfusion/articles/dc_wizard.html
http://www.macromedia.com/devnet/mx/coldfusion/articles/dc_wizard.html )
and I have
Hi all,
Someone in our company noticed that if a single address in the to was
invalid then coldfusion gets a 550 error from the smtp servers and
incorrectly interprets it as the whole e-mail is bad and don't send it.
We got this response from our E-Mail group in IT:
The problem is with
I'd say do them one at a time and test.One of the hotfixes (I can't
remember which one) broke all of my cfcs until I removed it.
Steve
-Original Message-
From: Jim Davis [mailto:[EMAIL PROTECTED]
Sent: Monday, August 02, 2004 12:31 PM
To: CF-Talk
Subject: RE: CFMX 6.1 - Hotfixes - Best
Hi all,
I have just really started maintaining multiple instances of CFMX on one
server and I had an idea for how to do updates easier (hot fixes and
security updates).I'd like to know what your opinions are.
I started out with a master copy of the cfusion\cfusion-ear directory that I
use to
Pete,
I tried this on my server.I put it under the webroot and got 500 null.I
put it under a directory called /bau and called it with
http://localhost/bau/testthreads.jsp http://localhost/bau/testthreads.jsp
and got:
500 Translator.WrongCase/bau/testthreads.jspbauBAU
Any ideas?
I'd
: Monitor CFMX threads
DURETTE, STEVEN J (AIT) wrote:
Pete,
I tried this on my server.I put it under the webroot and got 500
null.I
put it under a directory called /bau and called it with
http://localhost/bau/testthreads.jsp
http://localhost/bau/testthreads.jsp
and got:
500
Does anyone know how to list all of the current running threads and their
information?I'm not proficient with JAVA (yet) so an example will be
helpful.
Thanks,
Steve
-Original Message-
From: Joe Bernard [mailto:[EMAIL PROTECTED]
Sent: Monday, July 19, 2004 11:08 AM
To: CF-Talk
Will you let us know when it's available?It sounds great!
I tried modifying the template to get more info on queries before.I left
in the original code and added more so I could see if it was working, but
something was wrong and my parts always returned nothing.After about an
hour I had to drop
The only problem is that I have been hearing that there is an updater coming
soon for about 3 months now.
I'm about to give up hope!
Steve
-Original Message-
From: Alex Hubner [mailto:[EMAIL PROTECTED]
Sent: Friday, July 16, 2004 9:08 AM
To: CF-Talk
Subject: Re: cfmx hot fixes
I
Alex,
I already have the hot fixes.I'm just sick of 1) having to do so many for
a clean new install. and 2) having to recheck each one of those continuously
because they update them.
I'd like to have one large updater that has these and then a small amount of
patches/hotfixes after.
Michael,
Where do we get it for testing???
Steve
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: Friday, July 16, 2004 2:54 PM
To: CF-Talk
Subject: Dinowitz_Debug
Dinowitz_Debug is a new debugging template for CFMX that makes use of
CFTREE to show a
Hi all,
I was just trying to make some of my pages xhtml 1.0 transitional compatible
and when I tested through the W3C testing page I noticed that cfform and the
others capitalize the tags and don't self close them.
Anyone else notice this?
I would hate to have to recode all of my pages
Dave,
Ok, I have to say that I agree with not using the cfform, cfinput, etc.but
I have a lot of legacy code.Some I wrote when I was just starting with cf
and a lot of it that I inherited.We also have some programmers in our
group who still aren't _javascript_ proficient yet.
I personally
Go to easycfm.com there is a Three selects related using cf and js
tutorial shameless_plugI wrote it/shameless_plug.
Be sure to read the notes at the bottom though because in the haste to
provide the document I let a couple of flaws to slip in. (Actually I think I
may have submitted an older
cfc.
Thanks for any help.
Steve
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Friday, July 09, 2004 4:16 AM
To: CF-Talk
Subject: Re: CFC's not working.
On Thursday 08 Jul 2004 19:32 pm, DURETTE, STEVEN J (AIT) wrote:
The error returned is 500 N
The JRun4 that comes included with the enterprise edition of CFMX6.1
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Friday, July 09, 2004 8:24 AM
To: CF-Talk
Subject: Re: CFC's not working.
On Friday 09 Jul 2004 12:48 pm, DURETTE, STEVEN J (AIT) wrote:
2669
:[EMAIL PROTECTED]
Sent: Friday, July 09, 2004 8:40 AM
To: CF-Talk
Subject: Re: CFC's not working.
On Friday 09 Jul 2004 13:26 pm, DURETTE, STEVEN J (AIT) wrote:
The JRun4 that comes included with the enterprise edition of CFMX6.1
Oh, I'll leave it to someone else then, we're on WebLogic :-)
--
Tom
Hi all,
I've got a problem and need some help.On my local machine I have CF
developer set up and CFCs including the component browser.We have CF set
up on our production machine (standalone) and they work fine there.
On our development we are testing the J2EE install and CFCs and the
Hey all,
I've got an interesting one for you. I have StudioMX 2004 with FlashMX2004
and I'm trying to talk my boss into the FlashMX2004 Professional version.
She wanted me to show her the differences, so I downloaded the 30 day trial
from Macromedia.
The problem is that the download now
have Flash 2004 installed you can go to help upgrade to 2004 Pro
you can request a 30 day trial upgrade from normal to pro within flash
itself.
Jb.
-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: 19 May 2004 14:52
To: CF-Talk
Subject: OT: Flash MX Pro 30
Try select cast(.01000 as decimal(18, 2))
Steve
-Original Message-
From: Won Lee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 19, 2004 4:45 PM
To: CF-Talk
Subject: RE: return only 2 decimal places
I tried round.It seems it returns the same amount of decimal places as
the
Why don't you try, cfset myPrefix = listFirst(emailaddr, @) /?
Steve
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 19, 2004 3:47 PM
To: CF-Talk
Subject: Trim E-Mail Prefix
Brain fart moment... how can I most easily/reliably trim the prefix
AM
To: CF-Talk
Subject: Re: CFChart and the Y-Axis
On Monday 17 May 2004 20:05 pm, DURETTE, STEVEN J (AIT) wrote:
Anyone know how to make this happen?
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a11.htm#wp261963
0
You want the gridlines attribute.
--
Tom Chiverton
Advanced
Hi all,
Got one for you all.(and yes I did search the list history before asking!)
:)
I have a cfchart that has a minimum value of 0 (zero) and a maximum of 100.
No matter whether I put in only integers or decimals (the data that will be
in the final chart) the Y-Axis always shows up in
Hey does anyone have any idea when an updater for CFMX6.1 might be out?
I just had to re-image my web server and re-install.Now most of my time is
being spent dling and installing HotFixes and Security updates for
ColdFusion.
An updater would be really helpful about now as I am up to 14
Jeff,
The easiest way I see to fix this quickly (if you don't have multiple sites
each running different image directories) is to make a mapping in the
CFAdmin of /images pointing to the images directory.
That should clear up the problem.
Steve
-Original Message-
From: Jeff Small
Just remember there are 10 kinds of people.
Those who know binary and those who don't.
:)
Steve
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Friday, March 19, 2004 4:57 PM
To: CF-Talk
Subject: RE: MAX 2004 Conference date?
true true
its all good ben.we
Bob,
Inside your cfmail tags, you only need to use this code:
cfloop index=thisField list=#Form.FieldNames#
#thisField#: #evaluate(thisField)#br
/cfloop
(just remove the cfoutputs)
Steve
-Original Message-
From: Bob Haroche [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18,
if I remember correctly, #form[thisField]# won't work in cf5, but I'm not
100% sure of that (It's been so long since I used CF5).
Steve
-Original Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 1:40 PM
To: CF-Talk
Subject: RE: Emailing
Che,
Just off the top of my head, I believe it is:
select refkeywords, sum(refcount) as trefcount
from referer
group by refkeywords
having sum(refcount) 5
order by sum(refcount) desc
I haven't tested it but give it a try.
Steve
-Original Message-
From: Che Vilnonis
Che,
If you are on MSSql 2K then this is the solution:
select count(convert(varchar, creationdate, 101)), convert(varchar,
creationdate, 101)
from referer
group by convert(varchar, creationdate, 101)
Steve
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent:
:[EMAIL PROTECTED]
Sent: Friday, March 12, 2004 3:18 PM
To: CF-Talk
Subject: RE: Quick SQL Question...
WOW! WOW! WOW! Thanks so much. I knew this was possible.
what is the significanse of the 101
-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Friday, March 12
I already got it 2 days ago.It is great.I'm only to chapter 3 but it is
making everything clear to me finally!
Also, the appendix with the real world regex's is a great time saver.I
recommend it to everyone.
Steve
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Les,
I believe it depends on the database.I have seen queries work this way on
some and break on others.
I think that the best way to do it would be to change your order by line to:
order by (69.1 * (longitude = 104.825814))
Steve
-Original Message-
From: Les Irvin
Sung,
Not an answer to the hang, but you might be able to speed up the page (and
possibly prevent the hang) by moving the queries to a stored procedure.
The speed increase is dramatic.
Steve
-Original Message-
From: Sung J. Woo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02,
Jochem,
I tried looking for the unicode driver in the drop down, but all that is
listed is Access.The dropdown you are talking about is on the CFA
Datasources page right (Add datasource above a listing of all the current
datasources).
Steve
-Original Message-
From: Jochem van Dieten
Try:
cfif myQuery.currentRow neq myQuery.recordcount
img src="">
/cfif
Steve
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 10:26 AM
To: CF-Talk
Subject: How to know when you have the last record?
Hey,
I'm outputting a query as
John,
Try CFSQLTYPE=CF_SQL_TIMESTAMP
Steve
-Original Message-
From: John mccosker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 9:57 AM
To: CF-Talk
Subject: stored proc error with MX
hi,
is there some reason why I can't add a date object via a stored proc in MX
6.1.
Actually, I don't think that you even need the scope.
just try cfoutput#i#/cfoutputit should work.
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Monday, February 23, 2004 1:37 PM
To: CF-Talk
Subject: RE: Scope name of method's local scope?
I don't think the
MC,
What database are you using?
This will work for mssql, but I'm not sure about others.
cfquery name=Test datasource=YourDataSource
select *
from table2
where [idfield] not in (select distinct [idfield]
from table1)
/cfquery
That is if I understand your table layout.If this doesn't
Steven,
I think that there might be a slight flaw in that logic.
A massive cutover would be disruptive, but as new employees come in
converting them would stop the I've always done it this way mentality.
If large companies always had the same employees (no retirements, firings,
etc.)
Hi all,
Alright this one has me stumped (because of lack of sleep I think).
I currently have this:
cfset Variables.employee_name =
evaluate(#Variables.myQueryName#.employee_name)
and I want to get rid of the evaluate.Problem is that the
Variables.myQueryName is the scope.
Anyone
Thanks.
cfloop from=1 to=100 index=Variables.dummy
cf_beatHeadOnDesk
/cfloop
Steve
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 11:06 AM
To: CF-Talk
Subject: Re: convert evaluate to [] notation.
DURETTE, STEVEN J (AIT
I need some quick help with a regex.
I need to replace Ii, Iii, Iiii, etc with II, III, , etc. and it is part
of a longer string (these characters are surrounded by spaces).
I can find the chars with this regex:[\s][I]i+[\s](I used the Visual
Regular _expression_ Editor),
but I don't
Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: woensdag 4 februari 2004 15:05
To: CF-Talk
Subject: Need regex / rereplace help.
I need some quick help with a regex.
I need to replace Ii, Iii, Iiii, etc with II, III, , etc.
and it is part of a longer string
You need to do:
and month(date) = #month(thismonth)#
Steve
-Original Message-
From: JT [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 04, 2004 1:41 PM
To: CF-Talk
Subject: Pulling record for this month
How can I pull all records where date = this month. this is what I have and
1 - 100 of 258 matches
Mail list logo
