I want to second Charlie's note on losing the index. You have to be careful
with data manipulation you do on the left side of your where statements.
If you have a table with millions of dates, the year function has to be
applied to every single date in the table.
If you are using MS SQL, I
This is coming from a different datasource, so I need a way to use a cfquery
resultset in the insert. I wish cfquery allowed one to specify a different
datasource from within a query.
Eric
/*-Original Message-
/*From: Ryan Stille [mailto:[EMAIL PROTECTED]
/*Sent: Wednesday, October 15,
Hi Raymond,
I think it's a good idea, but sorry, i don't know exactly how to do.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Eric,
What database are you using?
If you have access to 'Sql Server 2005 Enterprise', then you can attach the
second datasource as a 'linked server'. By doing this you have the ability
to write your queries using 4part dot notation (not very efficient), or you
can use openquery() or Execute()at
Don't use HTMLCodeFormat, it will escape your and
Can you output just one row, and make sure that it does output bla ksk
kak alkd sk skd img src=/images/myimage.jpg sjd ksd fksdf and that it
is not escaped in the database.
You don't need HTMLCodeFormat to view it, just view the source. Make
Use two CFQUERYs:
cfquery name=firstDSN datasource=DSN01
select name from [user]
/cfquery
cfquery name=secondDSN datasource=DSN02
cfloop query=firstDSN
insert into otheruser (name) values ('#firstDSN.name#')
/cfloop
/cfquery
this insert (secondDSN) is essentially the same, but
yeah thats what i did :)
but i was just wondering if there was a cf way around it... thanks!
-- tony
Better than a thousand hollow words, is one word that brings peace.
-- siddhartha gautama
On Wed, Oct 15, 2008 at 10:23 PM, Azadi Saryev [EMAIL PROTECTED] wrote:
create a column in your query
just trying to USE the tools as they are :) and see how far they get me...
no other good reason :)
-- tony
Better than a thousand hollow words, is one word that brings peace.
-- siddhartha gautama
On Wed, Oct 15, 2008 at 10:43 PM, Charlie Griefer
[EMAIL PROTECTED] wrote:
why not just use a
Out of curiosity, what makes you choose those titles as valid and no
others?
just our clients business logic, they want a drop down box with just those
options, so it is just server side validation.
~|
Adobe® ColdFusion® 8
just our clients business logic, they want a drop down box with just
those options, so it is just server side validation.
Heh. If it's a drop down, I wouldn't bother with a regex:
ListFind( 'Dr,Prof,Mr,Mrs,Ms,Miss' , value )
On Wednesday 15 Oct 2008, Fawzi Amadu wrote:
I have since upgraded to Coldfusion 8 and I though my SMS' are received and
properly processed, I receive not acknowledgment. What am I doing wrong? or
What is wrong with ColdFusion 8?
Well, you've not used 'var' before your local variables, so it
On Wednesday 15 Oct 2008, Marc Edwards wrote:
reached the maxxed capacity for the task queue and was wondering how I can
clear the tasks out or do I have to wait for it to do it itself. Thanks
Once the thread terminates, it frees a slot.
You set the number of slots in the administrator.
--
Heh. If it's a drop down, I wouldn't bother with a regex:
ListFind( 'Dr,Prof,Mr,Mrs,Ms,Miss' , value )
hmmm, yes that would be a bit easier :) thanks peter
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic
The point is (i think) and I've tested this myself is that even though a
thread completes processing it does not self terminate in a timely fashion
thus your thread queue maxes out.
I think we both talking about set and forget threads where you really don't
want the result of a thread back. You
On Thursday 16 Oct 2008, Wil Genovese wrote:
The point is (i think) and I've tested this myself is that even though a
thread completes processing it does not self terminate in a timely fashion
thus your thread queue maxes out.
The ones I've been launching in my current project always seem
what makes Dr and Prof special, compared to the hundreds of other
similar ones?
According to the typographic code, there are rules about abreviations.
For common words as Doctor, Mister, etc, there are may ways to abreviate
them, but
only one complies with rules and is considered as correct.
Heh. If it's a drop down, I wouldn't bother with a regex:
I wouldn't even bother with any verification at all.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
I haven't, but I've been thinking about this a lot lately. We just hired a
CSS firm that produced some nice looking results, but the underlying CSS is
hard to follow.
Have you started playing with any of these yet?
Personally I'd really like CSS that doesn't require a ton of classes and IDs
to
If I have CF 8 stand alone installed on my dev server. What do I need
to do to change it to multi-server to use different instances? I have
always installed multi-server from scratch. Can I just run through the
install and choose multiserver or do I need to uninstall stand-alone
first?
Thanks
[EMAIL PROTECTED] wrote:
If I have CF 8 stand alone installed on my dev server. What do I need
to do to change it to multi-server to use different instances? I have
always installed multi-server from scratch. Can I just run through the
install and choose multiserver or do I need to
Hi, all...
Before I go digging around and start trying to code a solution, I'd like
to know if what I'm trying to do is even possible.
I'm trying to automate the downloading of data from a site.
First, I have to go to a login page, enter my username and password,
then I'm taken to the download
From my experience you can't really control the save as/open dialog from
your end. That is generally handled by the browser and OS as they see
fit. File formats that can be opened right there in the browser
(images, html, text) tend to just open up in that window when you click
the link. Most
Actually you can control the way a link opens if your trying to push a file
when a user clicks a link. If the link is to a coldfusion page that then
grabs the file sets header info and content type.
I do this for mp3 files.
download.cfm
--start file--
cfparam name=url.songname default=
cfif
If you want to force the Save File dialog appear you can use
application/unknown as the content type for cfcontent. At least that
behaves on windows boxes.
EX: cfcontent type=application/unknowncfoutput#yourdata#/cfoutput
On Thu, Oct 16, 2008 at 3:35 PM, Wil Genovese [EMAIL PROTECTED] wrote:
Ahh, good tip on the cfheader name=Content-Disposition
value=Attachment; filename=#clipname# bit.
I have never used that before. Of course, that also means you burn a
thread to server the download. I wonder if there is an easy way to link
directly to the file, but force apache or IIS to provide
You could have an .htaccess file in your downloads directory that adds
the content type to do this, for files retrieved from that directory.
-Ryan
[EMAIL PROTECTED] wrote:
Ahh, good tip on the cfheader name=Content-Disposition
value=Attachment; filename=#clipname# bit.
I have never used that
I have clients with large newsletters and if more than 1 of them send
them at a time it could potentially send over 10k emails to the cfmail
spooler. So naturally I have other clients that are complaining about
how long it takes the mail to get delivered. I know there are
alternatives out there to
Last I heard, CF Enterprise could send an insane amount of email very
quickly. I think maybe 50k per hour? I don't think 10k would be a
problem.
Of course, what about using multiple mail servers? You can have one
client use mail server x, another one use y, etc.
On Thu, Oct 16, 2008 at 4:40 PM,
What version of Coldfusion are you using?
Older versions of CF could take a long time to send spooled messages. It
used to do on 100 every 15 seconds. I've tested CF8 and it does thousands
every 15 seconds.
We used to use CF_mail which was a wrapper for cfx_activemail on the old CF
version.
This month's NJFlex UG Meeting is featuring a
href=http://www.simonfree.com;Simon Free/a from a
href=http://www.nylontechnologies.com;Nylon Technologies/a in NYC,
demonstrating how to build an AIR application using CF on the back end. Should
be an interesting presentation. To learn more
I think it would be much more cost effective to buy a mail tag than to
shell out the $ for Enterprise though.
Even if you tell it to use different mail servers it is still using the
CF spooler. My mail server isn't the issue the cf spooler is :(
-Original Message-
From: Raymond Camden
8 Standard Edition.
-Original Message-
From: Wil Genovese [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2008 6:00 PM
To: cf-talk
Subject: Re: CFMail Alternatives
What version of Coldfusion are you using?
Older versions of CF could take a long time to send spooled messages.
It
Hey All,
During the really bad XSS (Cross Site Scripting for the newbs) attack a few
months back we went into every box and made sure Global Script Protect was
enabled.
However... On some of my servers, mostly the ones that run our CMS systems,
I don't want it on. We do allow our users to upload
Thanks for the feedback, Wil...
I'm not sure however, that we're talking about the same thing.
I'm trying to automate going to a data vendor's site, logging in to their
web page, then triggering a link on the next page to cause a download
of a file to start... I'm the one doing the downloading
oh well that's different.
Hmmm. CFHTTP? post login info followed by another CFHTTP to get
the file? Not sure how I would do that. assuming the login is session
based cfhttp may not work since they would need to set a session cookie.
Not sure. Now I will be thinking about this instead
You can turn on scriptProtect at the Application level as well (both
in cfapplication and Application.cfc). Are you sure it isn't turned on
there?
On Thu, Oct 16, 2008 at 6:17 PM, Alan Rother [EMAIL PROTECTED] wrote:
Hey All,
During the really bad XSS (Cross Site Scripting for the newbs)
This is an announcement to let you all know that Transfer 1.1 is now
available for download.
New features include:
* A huge performance increase
* Cache Monitoring
* Transfer Object Proxies
* TQL Custom tags
and more.
For more details, please check out the blog post:
Are you sure it is the spooler? All you said was that it took a long
for mail to get delivered. The slowdown could be anywhere.
On Thu, Oct 16, 2008 at 5:57 PM, [EMAIL PROTECTED] wrote:
I think it would be much more cost effective to buy a mail tag than to
shell out the $ for Enterprise
I worked on a site that sent many hundreds of thousands of emails
every day using CF 7 Enterprise and it was fine. The thing we had to
do though was to use two different mail servers, one optimized for
immediate mail delivery, like new account setup emails, and one
optimized for bulk newsletter
Are there any comparisons out there of these two different tags? Do both work
in a 64 bit windows 2003 server environment? Are there any speed and quality
tests? Thanks.
~|
Adobe® ColdFusion® 8 software 8 is the most important
Yeah, it's disabled now in the App.cfc...
The issue is it keeps getting turned back on in the CFADMIN. I literally log
back in, and it's enabled (box checked)
I've also checked to make sure it's not just my browser re-selecting it too,
I've logged into the CFADMIN from multiple browsers on
Yes I am sure it is the spooler. I sit there and watch it.
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2008 9:33 PM
To: cf-talk
Subject: Re: CFMail Alternatives
Are you sure it is the spooler? All you said was that it took a long
for
If you are certain that the ColdFusion spooling process is the source
of the slowness then turn off that feature.
-Mike Chabot
On Fri, Oct 17, 2008 at 12:03 AM, [EMAIL PROTECTED] wrote:
Yes I am sure it is the spooler. I sit there and watch it.
-Original Message-
From: Raymond
Are you the only person with access to CF Admin? It could be that some
other server or security admin is wondering who keeps turning off that
option.
-Mike Chabot
On Thu, Oct 16, 2008 at 11:54 PM, Alan Rother [EMAIL PROTECTED] wrote:
Yeah, it's disabled now in the App.cfc...
The issue is it
Hi all,
I thought some of you might be interested in the recording of this
DataFaucet ORM presentation I gave earlier today. I showed some very new
features (only days old) and it's the best live presentation I've given
to date. Lots of positive feedback. :)
45 matches
Mail list logo