EMAIL 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-----
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 wh
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 A
Hi all,
I came across something today that just made my jaw drop...
I have a snippet of code:
#Variables.myNewField#
If I change the to , I mysteriously get a NULL NULL error. This type of
code works in other pages.
Got me stumped.
Steve
/30/06, DURETTE, 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 aga
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 the
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.
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 (c
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
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 M
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 Adobe/
d that problem with
Macromedia apps I'll make 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 jus
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 th
all web users - about 137.8 million unique 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
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:
if(not isDefined("Application.datasource"))
Application.datasource = "mydatasource";
if(no
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
AT&T
-Original Message-
From: Ken Ketsdever [mailto:[EMAIL PROTECTED]
Sent: Monday, Janu
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 can't
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
To
ked on the link 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&
ti-Instance Setup STILL
hummm, I'm not sure 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, Apri
o 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
Subject: RE: Flash Forms Multi-Instance Setup STILL
No
From: "DURETTE, STEVEN J \(AIT\)" <[EMAIL PROTECTED]>
Sent: Wednesday, April 13, 2005 3:40 PM
To: CF-Talk
Subject: Flash Forms Multi-Instance Setup STILL
Hey all,
I'm looking for someone who has set up CFMX7 Enterprise with the
M
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 t
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]>
06 AM, 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
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: C
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 'mx.rpc.Rem
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 mini
Ben Rogers
http://www.c4.net
v.508.240.0051
f.508.240.0057
> -----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
IS. Mappings are used 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
&g
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 ColdFusion
here CF looks for cf_ and
component files.
Laterz,
J
On Mon, 24 Jan 2005 13:28:08 -0500, jonese <[EMAIL PROTECTED]> wrote:
> did you try to put your CFC in your custom tag directory? or create a
> new CFC custom tag directory / mapping?
>
> ERJ
>
> On Mon, 24 Jan 2005 1
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 po
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)
> &l
-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 hel
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})? an
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,
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
ntely?
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.
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 o
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:
<br>
function myFunc() {<br>
alert("
function myFunc() {
// do whatever
}
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,
>
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 a
form
tag? I kn
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
[
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
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 Unsubscri
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)] = "";
}
Steve
-Original Message-
From: Che Vilnonis [mailto:[EMAI
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
Steve
-Original Message-
From: Tony Weeg [mailto:[EMA
k
Subject: Re: cfmx - request timeout setting
got that...and did that in the mean time, 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:
> well...
>
> 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 200
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
Subj
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
A
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
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
)
and I have everything set up.
What I would like to be able to do is when the user cl
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 Col
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
: Re: 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
>
> and got:
> 5
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
and got:
500 Translator.WrongCase/bau/testthreads.jspbauBAU
Any ideas?
I'd love to be able to get this working!
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 t
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
Subjec
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 proper
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.
Be
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
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
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 personal
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 wh
Go to easycfm.com there is a "Three selects related using cf and js"
tutorial I wrote it.
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 draft on accident).
I haven
:[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&#
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)
alk
Subject: Re: CFC's not working.
On Thursday 08 Jul 2004 19:32 pm, DURETTE, STEVEN J (AIT) wrote:
> The error returned is 500 Null (on another machine it comes up internal
> server error 500).
Logs ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [E
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
Comp
Why don't you try, ?
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 from an
e-mail address:
[EMAIL PROTECTED]
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 nume
you 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
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 inclu
2004 6:54 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 Chiver
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 dec
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
hotfix/
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 j
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 Form.Field
Bob,
Inside your cfmail tags, you only need to use this code:
#thisField#: "#evaluate(thisField)#"
(just remove the cfoutputs)
Steve
-Original Message-
From: Bob Haroche [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 1:24 PM
To: CF-Talk
Subject: Emailing Form.Field
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 [mailto:[E
:[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
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: Frid
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 PROTECTE
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 [mailto:[E
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, 20
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 Diete
Try:
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 a list. Visually, I'm inserting an image between
each record.
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 #i# it 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 'var' scope has
MC,
What database are you using?
This will work for mssql, but I'm not sure about others.
select *
from table2
where [idfield] not in (select distinct [idfield]
from table1)
That is if I understand your table layout. If this doesn't work, give us an
ex
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.) th
Thanks.
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) wrote:
>
> I currently have this:
>
>
Hi all,
Alright this one has me stumped (because of lack of sleep I think).
I currently have this:
evaluate("#Variables.myQueryName#.employee_name")>
and I want to get rid of the evaluate. Problem is that the
Variables.myQueryName is the scope.
Anyone have any ideas. I'm sure that
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
uot;, "\U\1\E", "All")
> -Original 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
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
1 - 100 of 258 matches
Mail list logo
