Re: detecting delivered email addresses...

2006-02-08 Thread Protoculture
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: http://www.houseoffusion.com/lists.cfm/link=i:4:231630
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


socket connections from CF to SMTP

2006-02-08 Thread Protoculture
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 someone point me in the right direction?

Cheers.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231631
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: socket connections from CF to SMTP

2006-02-08 Thread Protoculture
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:


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231633
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


detecting delivered email addresses...

2006-02-07 Thread Protoculture
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 to set up some kind of email priority whereby certain 
emails always get pushed to the front of the queue. But I'm not sure this is 
possible. Any opinions?



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231593
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


(ms sql) dinstinct not working...

2006-02-06 Thread Protoculture
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

person.id   AS  person_id,
person.first_name + ' ' + person.last_name AS person,
person.emailAS  person_email,
j_detail.ip_address AS  ip_address,
j_detail.date   AS  applydate

FROMperson,
j_detail

WHERE   j_detail.job_id = #url.id#  
AND j_detail.candidate_id   = person.id

 )
 
derivedtbl

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231396
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: sending mass emails

2006-02-06 Thread Protoculture
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 batches of 1000.

On averge using a DSL connection we managed 1000 per hour.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231407
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: (ms sql) dinstinct not working...

2006-02-06 Thread Protoculture
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: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: (ms sql) dinstinct not working...

2006-02-06 Thread Protoculture
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.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231453
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: (ms sql) dinstinct not working...

2006-02-06 Thread Protoculture
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?

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231458
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: (ms sql) dinstinct not working...

2006-02-06 Thread Protoculture
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 


DaCandidate,
candidate_email,
ip_address,
applydate

FROM
rs_responses_orig

ORDER BYapplydate

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231461
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


ms sql - delete records where older than 6 months

2006-02-02 Thread Protoculture
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
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: ms sql - delete records where older than 6 months

2006-02-02 Thread Protoculture
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: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


ms sql query...

2006-01-25 Thread Protoculture
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 ]

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230400
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


upgrading cfmx 6.1 pro to enterprise...

2006-01-19 Thread Protoculture
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?


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229964
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: upgrading cfmx 6.1 pro to enterprise...

2006-01-19 Thread Protoculture
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 in the New License field then click Submit 
 Changes.
 
 
 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229967
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CFMX 6.1 - export administrator settings?

2006-01-18 Thread Protoculture
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
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFMX 6.1 - export administrator settings?

2006-01-18 Thread Protoculture
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: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Coldfusion CFMX 6.1 on Red Hat

2006-01-18 Thread Protoculture
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. Anyone have any ideas?

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229858
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


socket write error

2006-01-16 Thread Protoculture
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: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Purchasing CF MX Enterprise...

2006-01-16 Thread Protoculture
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. Providing we have the proper license for CFMX enterprise, will this 
expand into the full blown enterprise edition?


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229662
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Purchasing CF MX Enterprise...

2006-01-16 Thread Protoculture
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: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CF licenses

2006-01-13 Thread Protoculture
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: http://www.houseoffusion.com/lists.cfm/link=i:4:229430
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


SMTP - socket error.

2006-01-10 Thread Protoculture
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 exact machine. So we know 
it CAN work. 

I've lowered the send /recieve thread count. Restarted ( which only works for a 
while )running out of ideas... its like the SMTP runs for a while and then 
just disconnects. 

Just wondering if anyone had any ideas?




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229021
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Optimizing Microsoft SMTP

2006-01-06 Thread Protoculture
Why are you going to use MS SMTP again?  

Because the software we used to run ( LSMTP ) trial has expired. I found this 
was a fantastic product. Unfortnatley we were going to buy the 20 thread 
version, but they now only sell unlimited thread 'corporate' version at a 
discount price of 7500 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 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.

There is nothing specific about MS SMTP, the optimizations 
Macromedia recommends for optimizing CF email performance apply 
equally to MS SMTP. (Except for the number of threads.) Check the 
Macromedia site for the whitepaper.

Jochem

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228640
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


looping over columns

2006-01-06 Thread Protoculture
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 ?

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228645
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Verity vs. sql indexing

2006-01-06 Thread Protoculture
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 with not 
many visitors and little growth potential.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228646
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: looping over columns

2006-01-06 Thread Protoculture
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: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Optimizing Microsoft SMTP

2006-01-05 Thread Protoculture
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...

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228514
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Ceiling of Verity collections...

2005-11-29 Thread Protoculture
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?

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225512
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: listgetat problems....

2005-11-17 Thread Protoculture
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 replace
%20 with some uncommon character and then specify that as delimiter.

HTH,
Matthieu

-Original Message-
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 to work?

c%2B%2B%20developer ( which is url encoded 'c++ developer' )

session.keyword: c%2B%2B%20developer 

keyword 1 : c
keyword 2 : B

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224470
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Sending Faxes through Cold Fusion

2005-11-17 Thread Protoculture
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 
printer?

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224474
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: FCKEditor and uploading images

2005-11-17 Thread Protoculture
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 
 destination=#request.destination_file_uploads# 
 nameconflict=overwrite


~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224475
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: nested array and structure loop inside cfmail....

2005-11-17 Thread Protoculture
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 )
 
 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 syntax 
 is correct. As I stated before, the error message I get is very vauge. 
 I've used both the collection loop and a query loop to loop over that 
 query object and I get the same error.
 
 is this a CF bug?
 
 cfmail to=#theemail# from=#thefrom# subject=Response Listing 
 type=html
 
   div align=left
   
   !--- loop through all the jobs ---
   cfloop from=1 to=#arraylen(arr_AllJobs)# 
 index=i 
   
   bJOB TITLE :/b #arr_AllJobs[i].job_title#br
   bJOB REFERENCE :/b #arr_AllJobs[i].job_ref#br
   bJOB VIEWS:/b #arr_AllJobs[i].job_views#br
   bJOB RESPONSES:/b #arr_AllJobs[i].job_responses#br
   bDATE POSTED:/b 
 #arr_AllJobs[i].job_datePosted#brbr
   
   bRESPONSE BREAKDOWN:/bbr
   
   cfloop 
 collection=#arr_AllJobs[i].qry_candidates# 
 item=j!--- loop through all responses ---
   
   a 
 href=mailto:#urlDecode(candidate_email)##urlDecode(candidate)#/a 
 (#urlDecode(candidate_email)#)
   
   /cfloop
   
   /cfloop
   
   /div
   
/cfmail

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224476
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Sending Faxes through Cold Fusion

2005-11-17 Thread Protoculture
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 the default printer is on the server (Windows 2003).
I've done a lot of searching, and I've seen the redirect to lpt1 in a batch
file posts and well, that won't work for sending html files.

Essentially I need a service that can run on the server that I can feed a
list of URLs to and have it render them, and then send them on over to the
default printer.  Anyone have ideas?


-Justin Scott

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224484
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Sending Faxes through Cold Fusion

2005-11-17 Thread Protoculture
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. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224495
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: nested array and structure loop inside cfmail....

2005-11-17 Thread Protoculture
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 requested a variable or an intermediate expression result as 
a simple value, however, the result cannot be converted to a simple value. 
Simple values are strings, numbers, boolean values, and date/time values. 
Queries, arrays, and COM objects are examples of complex values. p The most 
likely cause of the error is that you are trying to use a complex value as a 
simple one. For example, you might be trying to use a query variable in a 
lt;CFIFgt; tag. This was possible in ColdFusion 2.0 but creates an error in 
later versions.
 
The error occurred in E:\hosting\executivesontheweb.com\test.cfm: line 195

193 :   bRESPONSE BREAKDOWN:/bbr
194 :   
195 :   cfloop query=#arr_AllJobs[i].qry_candidates#
196 :   
197 :   a 
href=mailto:#urlDecode(candidate_email)##urlDecode(candidate)#/a 
(#urlDecode(candidate_email)#)


  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 syntax 
 is correct. As I stated before, the error message I get is very vauge. 
 I've used both the collection loop and a query loop to loop over that 
 query object and I get the same error.
 
 is this a CF bug?
 
 cfmail to=#theemail# from=#thefrom# subject=Response Listing 
 type=html
 
   div align=left
   
   !--- loop through all the jobs ---
   cfloop from=1 to=#arraylen(arr_AllJobs)# 
 index=i 
   
   bJOB TITLE :/b #arr_AllJobs[i].job_title#br
   bJOB REFERENCE :/b #arr_AllJobs[i].job_ref#br
   bJOB VIEWS:/b #arr_AllJobs[i].job_views#br
   bJOB RESPONSES:/b #arr_AllJobs[i].job_responses#br
   bDATE POSTED:/b 
 #arr_AllJobs[i].job_datePosted#brbr
   
   bRESPONSE BREAKDOWN:/bbr
   
   cfloop 
 collection=#arr_AllJobs[i].qry_candidates# 
 item=j!--- loop through all responses ---
   
   a 
 href=mailto:#urlDecode(candidate_email)##urlDecode(candidate)#/a 
 (#urlDecode(candidate_email)#)
   
   /cfloop
   
   /cfloop
   
   /div
   
/cfmail

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224511
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: searching for a '%' in an sql like statement...

2005-11-16 Thread Protoculture
So the mySQL statement says find an ampersand that has a space on either
side?

Well say you wanted to search for the actual string %20 in your database.

then the code would be:

opportunity.title LIKE '#firstsearchword#' + '\%20' + '#secondsearchword#' 
escape '\'



!//--
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 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 specify the character used
to escape. Here's code example.
SQL Code:
Oracle/SQL Server
SELECT * FROM employees WHERE Lastname LIKE '%\%%' ESCAPE '\';
MySQL
SELECT * FROM employees WHERE Lastname LIKE '%\%%'

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224292
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: nested array and structure loop inside cfmail....

2005-11-16 Thread Protoculture
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 
 over the array that contains structures ( when it comes to looping 
 over the structure in each array ) that contains a query object. 
 
 For example... 
 my_array[1].structure_name = whatever
 my_array[1].qry_object --- I need to loop over this 
)

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224293
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


listgetat problems....

2005-11-16 Thread Protoculture
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 to work?

c%2B%2B%20developer ( which is url encoded 'c++ developer' )

session.keyword: c%2B%2B%20developer 

keyword 1 : c
keyword 2 : B

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224327
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: nested array and structure loop inside cfmail....

2005-11-16 Thread Protoculture
 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 syntax is correct. As 
I stated before, the error message I get is very vauge. I've used both the 
collection loop and a query loop to loop over that query object and I get the 
same error.

is this a CF bug?

cfmail to=#theemail# from=#thefrom# subject=Response Listing type=html

div align=left

!--- loop through all the jobs ---
cfloop from=1 to=#arraylen(arr_AllJobs)# 
index=i 

bJOB TITLE :/b #arr_AllJobs[i].job_title#br
bJOB REFERENCE :/b #arr_AllJobs[i].job_ref#br
bJOB VIEWS:/b #arr_AllJobs[i].job_views#br
bJOB RESPONSES:/b #arr_AllJobs[i].job_responses#br
bDATE POSTED:/b 
#arr_AllJobs[i].job_datePosted#brbr

bRESPONSE BREAKDOWN:/bbr

cfloop 
collection=#arr_AllJobs[i].qry_candidates# item=j!--- loop through all 
responses ---

a 
href=mailto:#urlDecode(candidate_email)##urlDecode(candidate)#/a 
(#urlDecode(candidate_email)#)

/cfloop

/cfloop

/div

/cfmail

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224331
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


listgetat issue...

2005-11-16 Thread Protoculture
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 to work?

c%2B%2B%20developer ( which is url encoded 'c++ developer' )

session.keyword: c%2B%2B%20developer 

keyword 1 : c
keyword 2 : B

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224333
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: nested array and structure loop inside cfmail....

2005-11-16 Thread Protoculture
 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 syntax is correct. As 
I stated before, the error message I get is very vauge. I've used both the 
collection loop and a query loop to loop over that query object and I get the 
same error.

is this a CF bug?

cfmail to=#theemail# from=#thefrom# subject=Response Listing type=html

div align=left

!--- loop through all the jobs ---
cfloop from=1 to=#arraylen(arr_AllJobs)# 
index=i 

bJOB TITLE :/b #arr_AllJobs[i].job_title#br
bJOB REFERENCE :/b #arr_AllJobs[i].job_ref#br
bJOB VIEWS:/b #arr_AllJobs[i].job_views#br
bJOB RESPONSES:/b #arr_AllJobs[i].job_responses#br
bDATE POSTED:/b 
#arr_AllJobs[i].job_datePosted#brbr

bRESPONSE BREAKDOWN:/bbr

cfloop 
collection=#arr_AllJobs[i].qry_candidates# item=j!--- loop through all 
responses ---

a 
href=mailto:#urlDecode(candidate_email)##urlDecode(candidate)#/a 
(#urlDecode(candidate_email)#)

/cfloop

/cfloop

/div

/cfmail

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224332
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


nested array and structure loop inside cfmail....

2005-11-15 Thread Protoculture
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 and it is being filled with the 
correct data.


Error line that CF highlights: 
cfloop collection=#arr_AllJobs[i].qry_candidates# item=j


The #arr_AllJobs[i].qry_candidates# holds a query object. I've tried looping 
with cfloop collection and query, but both return the same vague error. 
Any ideas? am I missing something obvious? Perhaps CF doesn't like this process 
inside a cfmail tag.


*arr_AllJobs* is an array of all the jobs we have with responses.
in each array element is a structure of the following items.
job_title, job_ref, job_views, job_responses, job_datePoted


Full Code:

cfmail to=#myemaddress# from=#myfromaddress# subject=#mysubject# 
type=html


!--- loop through all the items ---
cfloop from=1 to=#arraylen(arr_AllJobs)# 
index=i 

bJOB TITLE :/b #arr_AllJobs[i].job_title#br
bJOB REFERENCE :/b #arr_AllJobs[i].job_ref#br
bJOB VIEWS:/b #arr_AllJobs[i].job_views#br
bJOB RESPONSES:/b #arr_AllJobs[i].job_responses#br
bDATE POSTED:/b 
#arr_AllJobs[i].job_datePosted#brbr

bRESPONSE BREAKDOWN:/bbr

cfloop 
collection=#arr_AllJobs[i].qry_candidates# item=j!--- loop through all 
responses ---

a 
href=mailto:#urlDecode(candidate_email)##urlDecode(candidate)#/a 
(#urlDecode(candidate_email)#)

/cfloop

/cfloop

/cfmail

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224163
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


searching for a '%' in an sql like statement...

2005-11-15 Thread Protoculture
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)#'

According to the results we are getting it seems that it might be taking the 
'%20' to mean something other than a space.

Any ideas?


~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224172
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: searching for a '%' in an sql like statement...

2005-11-15 Thread Protoculture
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' ?


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224176
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: nested array and structure loop inside cfmail....

2005-11-15 Thread Protoculture
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 structures ( when it comes to looping over the structure in each array 
) that contains a query object. 

For example... 
my_array[1].structure_name = whatever
my_array[1].qry_object --- I need to loop over this )

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224179
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: searching for a '%' in an sql like statement...

2005-11-15 Thread Protoculture
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 specify the character used to 
escape. Here's code example.
SQL Code:
Oracle/SQL Server
SELECT * FROM employees WHERE Lastname LIKE '%\%%' ESCAPE '\';
MySQL
SELECT * FROM employees WHERE Lastname LIKE '%\%%' 

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224185
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


preventing multiple form submissions

2005-11-08 Thread Protoculture
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?

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223558
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


querying for dates mssql.

2005-10-14 Thread Protoculture
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 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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221003
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: File uploading with firefox

2005-10-07 Thread Protoculture
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 firefox not allowing or revealing 
the mime type to the server.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220290
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


File uploading with firefox

2005-10-06 Thread Protoculture
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?

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220188
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: File uploading with firefox

2005-10-06 Thread Protoculture
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 my upload fails.

 The MIME type of the uploaded file application/unknown was not accepted by 
the server

Why would the same file be 'accepted by the server' by IE, but not firefox? 
what changes should I be making in the server configuration?

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220206
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: File uploading with firefox

2005-10-06 Thread Protoculture
code: ( works fine in IE )

cffile action=upload 
filefield=filename 
destination=#home_directory#\uploaddata\ 
nameconflict=makeunique 

accept=text/html,application/msword,text/plain,application/rtf,text/enriched,text/richtext,application/octet-stream


~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220237
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


XML/RSS Search Feed

2005-10-04 Thread Protoculture
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 the client write the forms to be used for searching or do we supply 
that to them. If we supply it, what formats can be used? ( ie. do we write an 
xml doc that they must parse to fill in the data ? ) or could they just use 
inline frames that point to templates on our site?

(2) When the data is searched and it is returned ( again, presumably in xml 
format ). Is it up to the client to format the visuals ( the html code around 
the recordset, or is something like that generally considered to be the hosts 
site responsibility? 

Thanks for any help or direction in this.

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:21
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: MailSpooling Service Crashing

2005-10-04 Thread Protoculture
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 previous batches have been completed. 
So what it sounds like you have happening is that the previous batches are not 
yet finished running and the later batches just come in without anything 
stopping them.

The solution was to set server varibles ( an array of 3 items or however many 
simultanious batches you can have runnung ) that set a flag up when a batch was 
running and close the flag when it was finished. Example server.mailitems[1] = 
'active' and set to 'inactive' when that process of batch is finished. When the 
next batches starts and if it sees that all array items are all 'active' with 
no 'inactive' spots then it will reschedule itself and the remaining batches.

This way you do not have the batches running on top of each other and consuming 
memory.

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:22
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: XML/RSS Search Feed

2005-10-04 Thread Protoculture
Thanks Andy, so in that case it would be up to them to provide the interface as 
far as the visual displaying of the xml. And maybe even up to them to design 
the forms or take them from our exsisting site.





Your best bet might be to write a web service which they could consume. Then
instead of your code being the action page for their form, theyt simply
query against your webservice, passing in a search term, and your code
returns a recordset in XML.

So, to encapsulate, you would write the code to search your data and the XML
which would be returned. They would write the form 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 PROTECTED]
Sent: Tuesday, October 04, 2005 5:52 AM
To: CF-Talk
Subject: XML/RSS Search Feed


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 the client write the forms to be used for searching or do we supply
that to them. If we supply it, what formats can be used? ( ie. do we write
an xml doc that they must parse to fill in the data ? ) or could they just
use inline frames that point to templates on our site?

(2) When the data is searched and it is returned ( again, presumably in xml
format ). Is it up to the client to format the visuals ( the html code
around the recordset, or is something like that generally considered to be
the hosts site responsibility?

Thanks for any help or direction in this.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220007
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


cfc memory question

2005-08-31 Thread Protoculture
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 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216959
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


SQL Count Question...

2005-08-26 Thread Protoculture
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 list of ids ( then do a 
#queryname.recordCount# ), rather I just want a proper count returned as I am 
trying to do in query2 below.

The two queries are identical except for the top portion, directly below.

query 1 snippet // this returns a listing 3500 records

SELECT DISTINCT 'id' = opportunity.id

/query 1 snippet

query 2 snippet // this returns a count of 135,000+ records

SELECT DISTINCT count(opportunity.id) as total_records

/query 2 snippet

/* also tried

  count(*),
  count(id = opportunity.id), 
  count('id' = opportunity.id)

*/

FULL SQL CODE...

query 1
SELECT DISTINCT 

   'id' =   opportunity.id

FROMopportunity,
advertiser,
location

WHERE   opportunity.deleted 
=   'N' 
AND
opportunity.authorised  
=   'Y' 
AND
opportunity.active  
=   'Y' 
AND
opportunity.activate
=  getdate()   
AND
opportunity.deactivate  
=  getdate()   
AND
opportunity.advertiser_id   
=   advertiser.id   
AND
advertiser.deleted  
=   'N' 
AND
advertiser.suspended
=   'N' 
AND

( 
(0 = 0  OR levels   LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%') OR
(0 = 0  OR levels   LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%')
) AND
 
(0  = 0 OR sectors  LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%')AND
(0  = 0 OR work_types   LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%')

  AND
 
 (
0   = 0 OR 
(0  LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%' 
AND
0   LIKE'%' + ',' + CONVERT(VARCHAR,0) 
+ ',' + '%')
  )

/query 1

query 2

SELECT DISTINCT

count(opportunity.id) as total_records  

FROMopportunity,
advertiser,
location

WHERE   opportunity.deleted 
=   'N' 
AND
opportunity.authorised  
=   'Y' 
AND
opportunity.active  
=   'Y' 
AND
opportunity.activate
=  getdate()   
AND
opportunity.deactivate  
=  getdate()   
AND
opportunity.advertiser_id   
=   

Re: SQL Count Question...

2005-08-26 Thread Protoculture
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 Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216482
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SQL Count Question...

2005-08-26 Thread Protoculture
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. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216484
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SQL Count Question...

2005-08-26 Thread Protoculture
thanks RADEMAKERS, that did it... here is the working code..

SELECT COUNT(DISTINCT(opportunity.id))

FROMopportunity,
advertiser,
location

WHERE   opportunity.deleted 
=   'N' 
AND
opportunity.authorised  
=   'Y' 
AND
opportunity.active  
=   'Y' 
AND
opportunity.activate
=  getdate()   
AND
opportunity.deactivate  
=  getdate()   
AND
opportunity.advertiser_id   
=   advertiser.id   
AND
advertiser.deleted  
=   'N' 
AND
advertiser.suspended
=   'N' 
AND

( 
(0 = 0  OR levels   LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%') OR
(0 = 0  OR levels   LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%')
) AND
 
(0  = 0 OR sectors  LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%')AND
(0  = 0 OR work_types   LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%')

  AND
 
 (
0   = 0 OR 
(0  LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%' 
AND
0   LIKE'%' + ',' + CONVERT(VARCHAR,0) 
+ ',' + '%')
  )

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216497
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


sharing query objects between coldfusion to .net

2005-08-09 Thread Protoculture
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 spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214189
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


How To...

2005-07-25 Thread Protoculture
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 
below in the #My_Embedded_CF_SQL_Code_Here# variable. It is in this variable I 
wish to place actual CFML and SQL content.

example...

cffile action=write output=#My_Embedded_CF_SQL_Code_Here# 
file=e:\mpath\#pagename#.cfm 
cffile action=append output=#My_Embedded_CF_SQL_Code_Here# 
file=e:\mypath\#pagename#.cfm

perhaps there's a better way to do this, but I will need to 'build' the page
dynamically.

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212710
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


clearning scheduled tasks from memory

2005-07-20 Thread Protoculture
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 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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212284
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Annoying undelivered email issue

2005-07-20 Thread Protoculture
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 emails 
as we were not on their white list.






We're still using MX around here (because of an incredibly sloppy setup 
by my predecessor, upgrading to 6.1 is impractical at best), and we're 
having a problem with our unsent e-mail.

When CF cannot send an e-mail, it puts that e-mail in the /Mail/Undelivr 
directory with the filename 'Undelievered_Mailx.cfmail'.  I should 
be able to rename that message to 'Mailx.cfmail' and move it to 
/Mail/Spool and restart the server, and have those messages sent out (or 
at least put back into the Undelivr diretory.  However, these messages 
are not getting resent; they're just sitting in the Spool directory.

What am I doing wrong?  This has worked before, and no changes have been 
made to our installation.

-- 
Richard Crawford, Programmer III
UC Davis Extension Distance Education Group
http://unexdlc.ucdavis.edu
http://www.extensiondlc.net
2901 K Street, Suite 200C
Sacramento, CA  95620
Tel: (916)327-7793
e-mail: [EMAIL PROTECTED]

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212286
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


list reverse function

2005-07-13 Thread Protoculture
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 with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211725
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


cachedwithin issues

2005-06-30 Thread Protoculture
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 return in the 
2000+ range ).

I thought the cachedwithin only ran on queries that were identical, it seems to 
be running the cached query everytime the search is processed and ignoring the 
fact that the searches are different.




~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210948
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Verity Searches Vs. Database Searches ( mssql )

2005-06-23 Thread Protoculture
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 (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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210326
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


MS SQL - Cannot Find Stored Procedure

2005-06-14 Thread Protoculture
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 again ( see code 
below ), it tells me that it cannot find it in the system catalog. ( whatever 
that means ). But it DOES appear in the stored procedure list. 

Checked permissions and they seem fine as well.

Code at top of the stored procedure...

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'Get_Adverts' AND uid = 
user_id('myuid') AND type = 'P') DROP PROCEDURE Get_Adverts

GO

. remaining code in here



 

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209393
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CF Server Crashing

2005-06-14 Thread Protoculture
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 retrieve single word doc files.

Yes, when you open the directory through FTP or windows explorer THEN it takes 
a long time to open it, but NOT when pointed to directly through a url string, 
it will simply ask user to download etc... and there appears to be no apparent 
server problem.

Any ideas?


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209400
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: MS SQL - Cannot Find Stored Procedure

2005-06-14 Thread Protoculture
 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?

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209401
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: MS SQL - Cannot Find Stored Procedure

2005-06-14 Thread Protoculture
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'.

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209405
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: MS SQL - Cannot Find Stored Procedure

2005-06-14 Thread Protoculture
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.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209423
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: MS SQL - Cannot Find Stored Procedure

2005-06-14 Thread Protoculture
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 still the same thing 
' cannot be found'.

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209430
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF Server Crashing

2005-06-14 Thread Protoculture
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 way you described in your hyperlink ) that this was the root cause of the 
unknown server crashes.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209431
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF Server Crashing

2005-06-14 Thread Protoculture
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 by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209437
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


indexing verity... quagmire!

2005-06-07 Thread Protoculture
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 (document catalog) in collection 
e:\hosting\oursite.com\index\job_index\job_index\custom..

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208767
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


changing the default time of SQLServer

2005-06-07 Thread Protoculture
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

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208771
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


changing the default time of SQLServer

2005-06-07 Thread Protoculture
 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.

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208772
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Search engines and CF

2005-06-03 Thread Protoculture
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 and thus improve 
our internet ranking.


~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208487
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Search engines and CF

2005-06-03 Thread Protoculture
Hey Kerry, so what you are saying is that changing the order of the links on 
the site map will signal to google that the page has changed?



Heres a tip:
If you can make the order of the links on the site map change dependent on,
say, the number of jobs for that type, or the most recently posted 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 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 and
thus improve our internet ranking.

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208520
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


delay processing a custom tag

2005-06-03 Thread Protoculture
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 documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208522
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: delay processing a custom tag

2005-06-03 Thread Protoculture
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 this be done?
  
  


~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208527
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: delay processing a custom tag

2005-06-03 Thread Protoculture
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] wrote:
  I want to call a custom tag, but at the end of the page processing, 
 not in sequencial order. Can this be done?
  
  

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208529
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


SMTP problems

2005-05-24 Thread Protoculture
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 158.152.1.43:53 

00:06:24 dns_query: rcode=refused for from 158.152.1.58:53

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207511
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SMTP problems

2005-05-24 Thread Protoculture
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 dns_query: rcode=refused for record from 158.152.1.43:53

That would imply you have email addresses which have no FQDN 
after canonicalization.

Jochem

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207515
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SMTP problems

2005-05-24 Thread Protoculture
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 seems certian email accounts and not getting sent out by our system any 
ideas?


~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207521
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: SQL Server User Problems

2005-05-19 Thread Protoculture
Thanks guys, this was the problem. Cheers!

Yeah, that'd be my guess. If the table is owned by a user you can't just
do select * from table you'd have to do select * from username.table
That's probably what's making things blow up.  Make sure you create all
of the tables and SP under an account that is a DBO. 


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Kerry [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 18, 2005 12:24 PM
To: CF-Talk
Subject: RE: SQL Server User Problems

is the table owner dbo 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 -- get this error when running a stored procedure.
We checked in the database and it does exist. Also have tried removing
and re-creating...




Make sure you have a SQL Server login with the same name under
Security.

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 account does not work. I've 
tried removing it and recreating the user all with the same dismal
results.

Has anyone else experienced this or know of a possible solution?

Cheers!

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207121
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


SQL Server User Problems

2005-05-18 Thread Protoculture
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 account does not work. I've tried removing it 
and recreating the user all with the same dismal results.

Has anyone else experienced this or know of a possible solution?

Cheers!

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207030
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: SQL Server User Problems [ solved ]

2005-05-18 Thread Protoculture
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 spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207042
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: SQL Server User Problems

2005-05-18 Thread Protoculture
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 -- get this error when running a stored procedure. We 
checked in the database and it does exist. Also have tried removing and 
re-creating...




Make sure you have a SQL Server login with the same name under Security.
Then, make sure your database's user points to that login.

Moving databases from one server to another tend to break SQL
Server-based logins, however, domain (Windows-based) logins will still
work.

M!ke 

-Original Message-
From: 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 database. 

This was working fine on the old system, but since we've copied things
across it seems that a particular user account does not work. I've tried
removing it and recreating the user all with the same dismal results.

Has anyone else experienced this or know of a possible solution?

Cheers!

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207048
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


default IIS SMTP Mail server good enough?

2005-05-17 Thread Protoculture
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 users who never get 
their emails.

The daily volume would be around 20,000. 

On the Database / CF end things seem fine as users who dont get emails can be 
seen in the queue


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206878
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


copying scheduled tasks to another machine

2005-05-13 Thread Protoculture
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?

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206608
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


calling stored procedure error..

2005-05-11 Thread Protoculture
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 :   dbvarname=@region
107 :   
108 :   /cfstoredproc

 

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206324
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


MSSQL Function

2005-05-10 Thread Protoculture
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 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206189
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Stored Procedure Help

2005-05-10 Thread Protoculture
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 pertain to the COUNTRY_ID 
of another table. eg... passing in CLIENT_ID of 15421 returns a list like the 
following... '6,31,32,33,35,36,' ( Yes I know this isn't the best way for it to 
be set up ).

so what I need to do in MSSQL is perform a query to grab that list of comma 
seperated numbers, put those numbers into an array OR a list and then loop over 
that array/list and and return the results ( which is a list of country names ).

Another thing I thought of was to create a temporary table and place the list ( 
6,7,8,13,4 etc ) into that, but then I would still have to be able to loop over 
each element, which I'm not sure how to do in MSSQL.


~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206207
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


detecting back button for page refresh

2005-05-03 Thread Protoculture
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 lastest session 
items, you get the old ones. 

any work arounds?

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205388
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


cfform problems with IE on Mac

2005-05-03 Thread Protoculture
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205395
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Using Java Classes rather than CFC's?

2005-04-22 Thread Protoculture
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 give you all the benefits of true 
object oriented programming?

~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203929
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Using Java Classes rather than CFC's?

2005-04-22 Thread Protoculture
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. 



~|
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 a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203934
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


  1   2   >