Was wondering if there was a way to send the email from our server say using
Perl or some other language to run a telnet session and retrive SMTP return
codes. This would then be passed onto CF
possible?
~|
Message:
Was wanting to confirm the existance of an email address at a particular server
and my co-worker has mentioned doing this in the past with PHP.
Apparetly what needs to happen is to create a socket connection from Coldfusion
to the SMTP server. Then checking MX records.
Is this possible? Can
Not a bad idea John. Which undelivered folder though... CF or SMTP?
what about sending a message to the address and then checking the
undelivered folder for any bounces?
john
On 08/02/06, Protoculture [EMAIL PROTECTED] wrote
I was wondering if there was a way to detect the email delivery status of an
email programmatically?
Essentially what we want to do is to make sure that an email account exists or
guarantee fast delivery. Either one of these options would work for us at the
moment.
The other alternative is
Need help with the following query. The distinct keyword doesn't seem to be
working for me.
select distinct
person_id,
person,
person_email,
applydate
from (
SELECT distinct
Yah I think this discussion has come up a few times before. We are running
similar volume daily ( 25-30k ).
Hi Russ.
I assume this mail server is in-house... What kind of connection are you using
with that ( standard DSL ? ). I've found that with the size of our emails that
we send out
Is it throwing an error, or just not returning the expected results?
Yeah Hi Andy, it's just not returning the expected results.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231437
Archives:
Could you be more specific? What do you expect, and what does it
return? We need more data to be able to help you.
Sorry guys for not being more specific.
I'm getting duplicate rows back. In this case I do not want the duplicate rows.
Not sure why I am getting them.
Not sure if this applies in your case, but DISTINCT acts across all selected
columns. Would this be the problem?
Perhaps yes... would there be any way to select DISTINCT on certain columns
ONLY ( but still retrieving the other columns as well? If so, how is that SQL
written?
Ok so then how would I rewrite the following if I only wanted distinct on the
'DaCandidate' field? BUT still wanted to get the other fields ( ie'
candidate_email, ip_address, applydate ).
SELECT DISTINCT
How would I finish the following sql statement to delete all records older than
6 months?
delete * from mytable_fav_cvs
where date_set
..
cheers
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231084
great, guys thanks.
Forgot I could use DateAdd to actually subtract.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231088
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription:
I need to do a text search within a query , however... I need to state in the
query to not accept any letters from [a-z] or [A-Z] directly before and after
the string to be searched.
example:
where this_title like '%myearchstring%'
where % = [ match any characters except a-z ]
We have been able to get a copy of cfmx 6.1 enterprise.
Is it possible to upgrade a current installation of cfmx pro to enterprise on a
live server? What would be involved and would there be any chance of some kind
of malfunction?
thats sounds too easy. You mean to say that by doing the following will unlock
all the enterprise features? (with no reintalling of anything required? )
To update your edition of ColdFusion MX:
On the System Information page in the ColdFusion Administrator, enter
your product serial number
Hi list,
anyone know of any way to export all the cf admin settings one may have on a
particular server? Is there an xml file anywhere that records this?
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229850
Hi Mike, what is a CAR file and how is it accessed?
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229852
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription:
Hi List,
I am wondering, an isp that we deal with is telling us that the latest version
of Red Hat will only work with CF 7.
something about updates and stuff and they are saying that it(CFMX) wont work
with apache etc... the updates to red hat will not work with CFMX 6.1.
I'm not convinced.
Any idea what would cause the following error?
[Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229657
Archives:
Our company is considering purchasing an old license of CFMX Enterprise. My
question is does Macromedia (Adobe) still offer support. IE downloadable
versions of CF MX 6.1 Enterpise that we can install?
I noticed on the Macromedia site all they have left is the CFMX 6.1 developer
edition.
I seem to be getting conflicting answers here guys.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229669
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription:
just a quick question. When purchasing a license of CF does it ( the single
license ) apply to one OS or to all of them. Or does it only apply to the first
OS you chose when registering?
~|
Message:
We are running a smtp server that gets mail generated from coldfusion.
But having problems with intermitment connection timeouts from both the default
windows iis smtp, and another SMTP server both seem to be having connection
issues.
We have run a certain SMTP server previously on this
pounds. This is way above our budget and our needs at
present.
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 05, 2006 4:24 PM
To: CF-Talk
Subject: Re: Optimizing Microsoft SMTP
Protoculture wrote:
We currently have a email list of about
Hi.
Essentially there will be one row of data returned and I need to loop over each
column to see if the column name begins with K then a number ( from 1 - 50 ).
How can I
(*) Loop over each column to check for its name ?
We were using Verity up to a point and we found it did not scale well. It
seemingly couldn't handle the volume of traffic when its records got populated
at a certain point and then it started slowing down big time. So I would
recommend doing that in the database, unless you have a smaller site
Cheers guys.
Incidently
refind(col, K[0-9]) worked fine to process all the columns I needed from
1-50.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228665
Archives:
Hi all,
We currently have a email list of about 60,000 users and unfortunatley at this
point have to fall back on using MS SMTP. Can anyone recommend best practices
to optimze it and or some useful websites that provide this information.
Cheers...
Anyone here aware of potential ceiling or maximum use capability of Verity
collections?
Our site was using them, but after a point we found that they became sluggish
to update. Even after reindexing them. Is there a maximum size limitation or
maximum user limitation on these collections?
Excellent, thanks guys!
I think that the delimiter attribute of ListGetAt looks at each
character specified on its own. In other words, it's looking for three
possible delimiters: %, 2, and 0. Maybe if you used the URLDecode
function first, then used a space as delimiter? Otherwise, I'd
Hey all -
I have a situation where I need to replace a current application (a web
system that runs .exe for each requested page!) with CF. Everything is good
except for one item: I need the ability to send a fax from CF.
Does it have to be a fax? What about sending the data to a locally installed
It does work once properly configured. If you can't getting working you missed
something...
Check your paths and everything where the files is getting uploaded to.
/filemanager/upload/cfm/upload.cfm
cffile action=UPLOAD
filefield=FCKeditor_File
Any ideas out there? basically having problems looping over a query object
contained in a structure that is contained in an array.
Could you post a dump of a sample structure?
Sure, here is a picture of the structure ( personal info removed )
I wrote a small app in Visual Basic a few years ago that did exactly that. I
might still have that kicking around somewhere.
I'd love to know if there is a simple way to do that. I'm in a situation
where I need to run several reports (generated in HTML) and they need to be
printed on whatever
ok, I'll have a look to see if I still have it.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today.
I tried this with the loop attribute set to query and got the following error.
So CF does not like the way I am referencing the query object that is contained
in a structure which is contained in an array help!
Complex object types cannot be converted to simple values.
The expression has
'\'
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 15, 2005 8:26 AM
To: CF-Talk
Subject: Re: searching for a '%' in an sql like statement...
Here
Any takers on the query below? I have a query object inside a structure which
is inside an array. I know its possible, just the notation in incorrect.
But a query is a structure I thought. And if you look at the code I am
using an index loop over the array. The problem occurs while looping
session.keyword: #session.search_keywords#
p
keyword 1 : #listgetat(session.search_keywords, 1, %20)# br
keyword 2 : #listgetat(session.search_keywords, 2, %20)#
Any idea why the above code would output the following? Why isn't it breaking
the list at the '%20' isn't that the way it's supposed
Could you post a dump of a sample structure?
Sure, here is a picture of the structure ( personal info removed )
http://www.visualreality.ca/images/problem.gif
The problem is that my code ( shown below ) never ends up looping over that
structure located inside the array. Although I believe my
session.keyword: #session.search_keywords#
p
keyword 1 : #listgetat(session.search_keywords, 1, %20)# br
keyword 2 : #listgetat(session.search_keywords, 2, %20)#
Any idea why the above code would output the following? Why isn't it breaking
the list at the '%20' isn't that the way it's supposed
Could you post a dump of a sample structure?
Sure, here is a picture of the structure ( personal info removed )
http://www.visualreality.ca/images/problem.gif
The problem is that my code ( shown below ) never ends up looping over that
structure located inside the array. Although I believe my
Hello All... I'm trying to figure out what error is happening here. Coldfusion
just gives me back nothing...literally. It just says there's an error and it
highlights this line. But no more information is given as to what is causing
the problem.
I've already checked out my array of structures
I need to search for the urlendcode for a space ( %20 ) in an sql server LIKE
statement.
example...notice the middle space between the two keywords below...
opportunities.title LIKE '#listgetat(session.search_keywords, 1, %20)#' +
'%20' + '#listgetat(session.search_keywords, 2, %20)#'
Not sure... consider this statement which searches for anything before the word
'mack'
like '%mack'
I guess part of my question is what happens when you do this...
like '%20'
( does that search for anything before the number 20? , or this '%20' ?
As I understand, the collection style loop is only for use with structures.
To loop over an array, use a standard index loop.
But a query is a structure I thought. And if you look at the code I am using an
index loop over the array. The problem occurs while looping over the array that
contains
Here it is... for anyone else following this thread..
SQL - Predicates Escaping Characters
Say you want to find a percent character(%) in your database, or all rows
associated with one. SQL Server and Oracle, require an additional statement
over MySQL. With Oracle and SQL Server, you must
we would like to limit the amount of times a user may search/ie use our search
facility as we think that we may be under some kind of script attack at the
moment.
What would be some solutions to prevent a certain number of form submissions
from taking place in a given period of time?
I need a query that will return all records that are set to expire ( column
name toexpire - which is just a date ) in the next 7 days.
select * from mytable
where toexpire ???
~|
Logware (www.logware.us): a new and convenient
No I agree, that wasn't very nice.
Anyway, someone mentioned before about posting the info about the headers in
order to further diagnose this problem? how is that done?
And as far as server configuration, what can be done on that end? But I
guessing the server end is fine. And that its
We have a form to upload word docs, etc. It works fine in IE, but firefox
throws the following error. Looks like it does not know I am uploading a word
doc.
ERROR:
The MIME type of the uploaded file application/unknown was not accepted by
the server
Any ideas how to fix?
why would I change the file extension of a word doc (.doc) to something other
than a word doc in order to fix a file upload feature that should be supporting
word documents?
Anyway to reiterate. Its working in IE, but Firefox does not seem to identify
that the file IS a word document. And this
code: ( works fine in IE )
cffile action=upload
filefield=filename
destination=#home_directory#\uploaddata\
nameconflict=makeunique
Hello. Having never done what has been mentioned in the subject. I would like a
simple overview of the process.
I'll be using Coldfusion to generate a recordset ( preumably xml ) in order to
allow other websites to perform searches against the data we store.
My main questions are:
(1) Does
Hi Robert how are ya?
We are currently sending off a similar amount of emails and we used to have the
EXACT problem you desribe. However I managed to come up with a solution.
The problem with running straught batches like that is that CF/SMTP Mail
service doesn't know or care whether the
to be used. Of course you
could also write the form itself. Then the setup time on their end would be
less.
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
-Original Message-
From: Protoculture [mailto:[EMAIL
so if I invoke a cfc method how much of that cfc is loaded into cf's memory? is
it the whole cfc (and all other methods) or just the method I am calling?
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
I am trying to get a total count of all our records. The query itself is a join
( as you can see below )... however when I make a change between the following
I get a different result set... I want to be able to return the correct number
of records but do it the correct way and not return a
ms-sql,
basically want to get the proper number of records.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with
yes I've also tried
'id' AS opportunity.id
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today.
thanks RADEMAKERS, that did it... here is the working code..
SELECT COUNT(DISTINCT(opportunity.id))
FROMopportunity,
advertiser,
is there any way this can be done? putting the query object into a server or
session varible perhaps?
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours
I need to build a .cfm page ( assume with cffile ). In other words I will be
creating a cfml page using cffile, that will be using coldfusion functions, sql
statements etc passed into it as part of the new file ...
How can I safely pass cf functions/sql into the cffile output attribute? See
The way our system runs is that once a day it sets up the tasks for the whole
day. Puts that somewhere in memory, but where? how could I clear all the
scheduled tasks for the day from CF's memory?
~|
Logware (www.logware.us): a
Hi Richard, I think the bigger problem is why they aren't being sent in the
first place. Check that your email isn't being flagged as spam by the
recipient's server ( or whoever handles the MX records for your company ).
We had a similar issue and it wound up to be that AOL was refusing our
does anyone have a listreverse udf kicking around or know of one?
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client
I've set this up on our site and I've noticed some weird behaviour with it.
(*) Users performing different queries are getting the same results. ( Ie. I do
a search for 'c++' which returns 100 records. Another user does an any any
search and gets back the same records. ( btw the any any should
Part of our system uses the verity search ( it updates its index from a group
of word doc files ).
Now using MSSQL, do you think there could be a performance improvement by
switching this search to the database?
~|
Logware
I've created the stored procedure in the Enterprise Manager on our Dev Server.
Its the same code that's used on our live site so I know it works. However,
Coldfusion returns an error that says the stored procedure cannot be found.
Another thing : is that when I go to run the stored procedure
Trying to figure out why one of our servers keeps crashing. Like about 1-4
times per week it needs restarting.
The guy at the isp said that it was due to a directory we had ( about 50,000
word doc files at a total of 2.7 gigs ) and said CF was crapping out when it
opened the directory to
Turn off maintain connection across requests in CF Admin under
Datasources = Your DB Name = Advanced.
thanks, but that didn't seem to work. As a side note, what are the performance
implications for setting this value true or false?
I've also tried connecting directly to the database as the main user ( not SA
)... and I get a permission denied error.
Server Msg: 262, State: 42000, [Microsoft][ODBC SQL Server Driver][SQL Server]
CREATE PROCEDURE permission denied in database 'mydbname'.
I've even restarted the server after creating this new procedure and still the
system ( CF) can't find it. Even when I try to run it again under enterprise
manager I get not found in system catalog? Funny that it says it cannot be
found if its clearly displayed ms sql is hell.
You can restart the system a million times, and that will not help you if
you are not using the correct login to run the procedure.
Ok, I settled for restarting the server 1262 timesbut still having the same
problem...
seriously.
I've tried the procedure with the login name prefixed and
Was the ISP suggesting that linking to the word doc like this:
http://www.whatever.com/somedirectory/myword.doc
caused CF to crash?
Well they did not say that exactly. They were basically saying that because
this directory existed on the same server as CF and that CF accesses it ( in
the
My coworker here reminded me that the ISP said that it was a problem with
windows and large directory sizes that was causing the server crashes.
~|
Find out how CFTicket can increase your company's customer support
efficiency
we have moved servers and now it seems we have lost an important verity index.
I am trying to rebuild it manually, but I get the following error. No idea what
it means.
coldfusion.tagext.lang.CFIndexTagException: Error # -31 Error # -31 Error
E3-0036 (VDK): Cannot load style.ddd schema
the ISP installed our sql server with US time when it needed to be UK time. Is
there any way of altering this?
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
the ISP installed our sql server with US time when it needed to be UK
time. Is there any way of altering this?
That would be US and UK DATES DATETIME, not TIME. We need to change this (
after its already been installed ) to UK.
Are there any best practices for search engine optimization when using
coldfusion?
What we are currently doing is setting up a site map of sorts that interlinks
our database of job types with a customized page. Essentially what the
intention here is that search engines will index these pages
job of
that type, then google will see that the page has changed, keep re-indexing
it, and through that, re-index your customised pages.
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: 03 June 2005 14:22
To: CF-Talk
Subject: Search engines and CF
Are there any
I want to call a custom tag, but at the end of the page processing, not in
sequencial order. Can this be done?
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and
FANTASTIC! I totally forgot about that one.
Why not use onRequestEnd.cfm (if before cfmx7) or onRequestEnd() (if
using cfmx7).
On 6/3/05, Protoculture [EMAIL PROTECTED] wrote:
I want to call a custom tag, but at the end of the page processing,
not in sequencial order. Can
Hold on actually, no it's not exactly what I wanted. I need the custom tag to
be embedded in the html but only process at the end of the page load. Is that
clear?
Why not use onRequestEnd.cfm (if before cfmx7) or onRequestEnd() (if
using cfmx7).
On 6/3/05, Protoculture [EMAIL PROTECTED
Some of our email seems to get lost and either stuck in the queue or not sent
at all. I checked the log files of the SMTP server and found this... what do
you guys make of it?
any idea why our email server would be returning this in the log file?
00:03:44 dns_query: rcode=refused for from
huh? so what does that mean to someone who has no idea about SMTP?
Protoculture wrote:
any idea why our email server would be returning this in the log file?
00:03:44 dns_query: rcode=refused for from 158.152.1.43:53
I guess it misses a record to query for and it should read:
00:03:44
Alright, so I did some more digging and found the following problem that seems
to plague or system...
WSACONNABORTED - Software caused connection abort.
An established connection was aborted by the software in your host machine,
possibly due to a data transmission timeout or protocol error.
It
or {username}?
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: 18 May 2005 17:20
To: CF-Talk
Subject: RE: SQL Server User Problems
Manage to solve the issue with the users, but now we're finding the
stored procedures we had aren't not functioning.
Invalid object name
We've transferred a copy of our database to a new server and are trying to log
in as a particular user. It seems that for some reason, we cannot connect to
the default database.
This was working fine on the old system, but since we've copied things across
it seems that a particular user
found it, orphaned users here's the solution.
http://dmwebb.com/blog/archive/2004/11/12/204.aspx
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours
: Protoculture [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 18, 2005 10:15 AM
To: CF-Talk
Subject: SQL Server User Problems
We've transferred a copy of our database to a new server and are trying
to log in as a particular user. It seems that for some reason, we cannot
connect to the default
We are currently sending out large batches of emails using the default iis smtp
server. We are finding that many users are not getting emails and the queue
folder has many items in it. They seem to be getting sent ( as the queue folder
gets smaller )...but the problem remains that there are
We have a number of scheduled tasks that need to be copied over to our new
server. Is there a fast way of doing this? Are they stored in a particular
directory or xml file that we may simply copy over, or is this going to be a
manual job?
I dont understand this error...
Macromedia][SQLServer JDBC Driver][SQLServer]Invalid length parameter passed to
the substring function.
104 : cfsqltype=CF_SQL_VARCHAR
105 : value=#region#
106 :
I have a variable like this.. ',6,6,8,2,10,11,'
what mssql function(s) can I use to remove the commas before the first 6 and
after the last number (11) ?
~|
Logware (www.logware.us): a new and convenient web-based time tracking
I'm new to stored procedures ( in MS SQL ) and need help with the following
query...
Essentially what my procedure will do is take an argument of CLIENT_ID and
return a list of COUNTRIES. Simple enough, cept for the fact that the database
does not return a single ID, but a list of IDS that
Hi All. I would like to detect that the user has clicked the back button. I
need to do this in order to get the last value entered in the form. ( currently
using session variables to recall the last item searched for ). However as you
can guess, by pressing the back button you do not get the
is Javascript turned off?
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with
just wondering if this was feasable... and in the end a little bit more
powerful than just working with cfc's? As I understand it everything gets
turned into Java anyway.
So why not use java classes etc ( either as custom tags or servlets ) rather
than cfc's? Doesn't this make more sense and
Hi thanks for the responses.
I wouldn't want to recreate what CF does ( and does well I might add ). I was
just thinking on a larger scale. Say if an organization had these classes in
existance, then in my mind it makes sense to hook CF into these objects than
recreating them as cfc's.
1 - 100 of 159 matches
Mail list logo