RE: SOT, looking for an affordable SMTP/POP3 solution
I use Smartermail, but I am slowly moving all of my email accounts to gmail. I wouldn't put smartermail on the same server as your CF server.. it takes up a lot of resources for the spam and virus checking. One problem with gmail is they have problems when you receive too much mail in 1 account. They refuse some mail over a certain limit.. so if you get a lot of email, you have to break it down into multiple email addresses. At 02:59 AM 5/29/2009, Hugo Ahlenius wrote: >| I'm moving my CF applications to a new dedicated server, and I need to >| both send messages and receive, >| for several users under several domains. > >What OS? > >If Windows - I can definately recommend hmailserver - >http://www.hmailserver.com/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322995 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQLite, mySQL and MS SQL Express etc.
MSSQL has an embedded version that requires no install. I have not tried it with CF but it might be worth a look. H2 is another DB you might want to look at. Sava/ Mura CMS uses it for their Express version. Uses Railo to boot. Gotta love LGPL. Out of curiosity, what features do you require that MySQL could not provide? It is fast, stable, mature, has a pretty small foot print and requires no install. G! On Fri, May 29, 2009 at 9:39 AM, Don L wrote: > > Probably I was not well versed enough in all available free relational > database platforms out there about a year ago, I picked ms sql express. Now > I found its installation has consistent problems, not for me but average > computer users, what is totally unexpected and unacceptable by whatever > standard, for some XP or Vista boxes regardless of their SP version, is the > fact that sql server installtion would crash a user's computer, and some > times keep on rebooting, it devastates a user especially those who are not > computer savvy, this show-stopper is also documented by and known to some > sql manager of MS corp as well, for at least 5 months already, however, MS > has not taken any action to fix it, it says "a small number of users > experience this problem...", one wonders if this is a way to suppress > competition if any by MS. If MS requires some small fee in exchange for > making the installer reliable that would be a good service. Dictators are > always dispicable. > > mySQL is not a good choice for me, I "played" with it a little while ago > but was not impressed. > > SQLite came up this morning, it seems quite interesting, a main concern is, > how easy to install it and how reliable it is to work with CF8 or other cf > engine. > > Thanks for your time. > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322994 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF7 Unzip an encrypted, password protected .zip
Can anyone point me to a resource to unzip a 256 AES .zip with a password in CF 7? -- Ryan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322993 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ListLast equivalent in MS SQL
check the reverse, locate, and left functions. reverse it, find the delimiter, and then use left to strip off the prefix. cheers, barneyb On Fri, May 29, 2009 at 12:44 PM, Paul Ihrig wrote: > > how can i do > ListLast(your_email,"@") > > in a sql statement > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322992 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ListLast equivalent in MS SQL
how can i do ListLast(your_email,"@") in a sql statement ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322991 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfmail problem in cfc
Hi All, I am able to send mails via cfmail tag in cfm pages but not in cfc. I used to send mails from cfc but now it is throwing the below error message.Please advice where i am going wrong "Error","scheduler-2","05/29/09","06:15:32",,"Could not connect to SMTP host: 12 7.0.0.1, port: 25; nested exception is: java.net.ConnectException: Conne ction refused" javax.mail.MessagingException: Could not connect to SMTP host: 127.0.0.1, port: 25; nested exception is: java.net.ConnectException: Connection refused at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1008) at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:19 7) at javax.mail.Service.connect(Service.java:233) at coldfusion.mail.MailSpooler.getConnection(MailSpooler.java:908) at coldfusion.mail.MailSpooler.deliver(MailSpooler.java:773) at coldfusion.mail.MailSpooler.sendMail(MailSpooler.java:704) at coldfusion.mail.MailSpooler.deliverFast(MailSpooler.java:1028) at coldfusion.mail.MailSpooler.run(MailSpooler.java:938) at coldfusion.scheduling.ThreadPool.run(ThreadPool.java:201) at coldfusion.scheduling.WorkerThread.run(WorkerThread.java:70) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322990 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFPOP Checker/Uploader best practices
I'm building an app that uses CFPOP to check an email box and puts whatever attachments are in the email onto a server and then emails back the sender the URL (and a TinyURL of the file as well). I've added security - there are only a few email addresses that it will grab attachments for - otherwise it just deletes the mail. I realize there are better ways to go about getting files to a server but my users are novices and I think it's worth a try. I've got it working with a Gmail account and my initial tests have gone well. The server that would be performing this does not have a significant load, and only a handful of users would be emailing files (mostly 1-3mb jpegs, 2mg or so PDFs) but still I am concerned about how it might affect the performance of the box. It is on a Windows 2000 server w/ CF 6.1 so CFThread is not an option. If it's chugging away grabbing mail attachments off the Gmail account - are other requests to the box slowed to a crawl? I'm also debating how often the page with the CFPop should be called from the Scheduler - maybe 2 or 3 minutes apart? It's a fine line between giving the user the info within a reasonable time period versus taxing the server too much because it's constantly checking email. I would definitely have it stop once office hours were over. If anyone has experience with this sort of thing I've love to hear of suggestions, solutions, pitfalls, etc. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322989 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Scheduler Log reports "Interrupt Task" and job stops running
It's been a long time since I've seen that, but I believe the 1899
timestamps are interpretation of a NULL timestamp by CF (from SQL
Server data).
Cheers,
Kris
> I have no idea where those 1899 timestamps are coming from.
>>> We have a scheduled task that is fairly critical (it helps generate
>>> significant revenue for our company), so we get alerts if it hasn't
>>> run within a certain time frame. However, we had the job stop
>>> yesterday and the scheduler log reports: "Interrupt task
>>> scheduled at {ts '2009-04-09 00:00:00'} {ts '1899-12-30 00:00:00'}
>>> null {ts '1899-12-30 23:59:00'}" [where I replaced the job name --
>>> those 1899 time stamps are actually in the log]. I haven't been able
>>> to find a reference to this, either on the web or on Adobe's site.
>>> Has anyone encountered this issue before (or know what it means)?
>>>
>>> This process is running on ColdFusion 8 Enterprise on IIS (Windows 200
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322988
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray -adding values with commas throws an error?
You don't need # outside of a string. This works fine: tempvalue = [ attributes.id , attributes.name , attributes.price , attributes.quantity , attributes.category ] ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322987 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Scheduler Log reports "Interrupt Task" and job stops running
I have no idea where those 1899 timestamps are coming from.
The scheduled task only gets rescheduled by the ColdFusion admin
scheduler, not by the process itself. (It can be a lengthy process at
times, but we have code in the process to not do anything if the job
is currently running). However, the last time the job successfully
ran, it only took 3 minutes. The next time (when this error
occurred), it had only been running for about 20 seconds [so, it's not
a timeout issue].
The log output is from the automated logging (scheduler.log).
Scott
On Fri, May 29, 2009 at 10:05 AM, Azadi Saryev wrote:
>
> where are those {ts '1899 ...} coming from?
> is your scheduled task re-scheduling itself as part of its process?
> is when it runs or when it re-schedules itself to based on a value of
> some db column in some db table?
>
> is that log output a result of automated scheduled task logging (if you
> have it enabled in cf admin) or is that log entry created by your code?
>
>
> Azadi Saryev
> Sabai-dee.com
> http://www.sabai-dee.com/
>
>
> On 29/05/2009 22:53, Scott Brady wrote:
>> We have a scheduled task that is fairly critical (it helps generate
>> significant revenue for our company), so we get alerts if it hasn't
>> run within a certain time frame. However, we had the job stop
>> yesterday and the scheduler log reports: "Interrupt task
>> scheduled at {ts '2009-04-09 00:00:00'} {ts '1899-12-30 00:00:00'}
>> null {ts '1899-12-30 23:59:00'}" [where I replaced the job name --
>> those 1899 time stamps are actually in the log]. I haven't been able
>> to find a reference to this, either on the web or on Adobe's site.
>> Has anyone encountered this issue before (or know what it means)?
>>
>> This process is running on ColdFusion 8 Enterprise on IIS (Windows 2003)
>>
>
>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322986
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regex help...
> I'm trying to use REFind to get all of the anchor/href tags but I'm > coming up short. RegEx is not necessarily the ideal tool for this - try a DOM Parser. If you've got consistent/controlled input you can use regex, and here's a Java one that will work in most situations: ]+?\shref\s*+=\s*+["']([^"']++)["'][^>]++>(.*?) To use that with CFML, you can use my jre-utils CFC (which is GPL Free Software, rather than a $15 per server tag). Here's an example, along with a commented version of the above regex: (?xis) # Flags (above): # x = enable regex comment-mode; # i = make case-insensitive; # s = allow . to match newlines; # Main Regex: ]+? # start of tag, lazily match at least one non-> \bhref\s*+=\s*+ # match href attribute, word boundary at start, allow whitespace around = ["']([^"']++)["'] # match value of href, possessive capture contents between the quotes (note: doesn't support inverted embedded quotes) [^>]++> # rest of tag, possessively matching non-> then > (.*?) # lazily capture any tag contents # end of tag That will set Results to an array of matches, each one containing a struct with the matched string, plus an array of the groups. All make sense? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322985 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQLite, mySQL and MS SQL Express etc.
Interesting option, Azadi, thank you. Don >if you have a cf8-based application you are distributing, consider using >the built-in Apache Derby db, and then maybe including sql scripts for >other databases which a user can run to create the required db structure. > > >Azadi Saryev >Sabai-dee.com >http://www.sabai-dee.com/ > > >On 29/05/2009 20:39, D >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322984 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
image adjustment: brightness, contrast, color balance
i am in the process of developing a color and brightness controller and was wondering if anyone has any useful techniques out there? Here is something I have begun working on, which uses an overlay of color to control the balance: READ IMAGE INTO MEMORY TURN ON ANTI ALIASING SET TRANSPARENCY CREATE A COLOR OVERLAY OVERLAY PREVIEW This technique is 'okay' and could produce worthy results if there were slider controls for R,G,B and brightness. Contrast seems to be the most difficult. I am not even sure where to begin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322983 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray -adding values with commas throws an error?
As I said on the Adobe forums, do not use commas as your list delimiters.
|tempvalue =
listtoarray('#attributes.id#|#attributes.name#|#attributes.price#|#attributes.q
uantity#|#attributes.category#','|');|
Or otherwise be more explicit about your array creation.
Or you could try implicit array declaration, this is a new CF8 feature.
|tempvalue =
[#attributes.id#,#attributes.name#,#attributes.price#,#attributes.q
uantity#,#attributes.category#];
|
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322982
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Cold Fusion 5, Windows 2003 & PCI compliance
I am wondering if there is someone on the list who has experience in Cold Fusion 5, Windows 2003 IIS6 & PCI compliance scans and resolution. I have an issue with one server that I need someone to consult with and am hoping that some kind knowledgeable soul is willing to talk to me off list and maybe point me in the right direction. Dennis Powers UXB Internet - A Website Design & Hosting Company P.O. Box 6028 Wolcott, CT 06716 203-879-2844 Http://www.uxbinternet.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322981 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: listtoarray -adding values with commas throws an error?
On Fri, May 29, 2009 at 6:55 AM, Jeff F wrote: > > I've got a simple shopping cart that stores into in an array. If the > product name has commas, and it attempted to be added to the cart, it throws > an error: > "The value cannot be converted to a number". Error message is telling me > this is the problem line: > > > > What gives? I've not seen this before? Do the commas in the product name > need to be escaped somehow?? And where? > Are you talking about the product name, or a property like the price? I can't fathom why the product name would factor into an equation like "subtotal + (session.cart[i][4] * session.cart[i][3])". As far as numeric values... they should be stored (and worked with) as numeric values (e.g. no commas). You can use numberFormat() to display them to the user with a comma, but they shouldn't contain commas while you're working with them. If you've got too much code to deal with that already includes the commas in the numeric values, you can strip it out using a simple replace() or a reReplace that removes any non-numeric value (other than a decimal, in case you're working with floats). -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322980 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Time from client to multiple servers.
Hmmm...I don't quite get it...by the time you hit a server to do this checking, they have already hit a server with the request, so the choice has been made...or are you saying they can choose a server for all subsequent requests? Maybe a little more elaboration of what you're going for is in order. If you are looking to determine network latency for a client, something ajax-y would probably fit the bill. Do the same thing, get times before and after the ajax call and report them in javascript, and this will take the client's own network latency into account. -- Josh -Original Message- From: John Saunders [mailto:saunder...@gmail.com] Sent: Friday, May 29, 2009 5:28 AM To: cf-talk Subject: Time from client to multiple servers. Situation is this. Have an architecture with multiple coldfusion servers geographically separated. Trying to find a way for a user to determine which server would be the best for them to use based on speed. Was thinking of something along the lines of this. Although the speed here is based on the time it is processed on the server rather than the time it actually hits the client. Sure this is something dumb, it just isn't clicking right now. Any help would be appreciated. http://#i#/speedcheck.html";> Time to site (#i#) is : #tottime# ms ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322979 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Scheduler Log reports "Interrupt Task" and job stops running
PS: check that your scheduled task is not exceeding the request timeout
limit as set in CF Admin. check your application and exception logs for
clues if this is the culprit.
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
On 29/05/2009 22:53, Scott Brady wrote:
> We have a scheduled task that is fairly critical (it helps generate
> significant revenue for our company), so we get alerts if it hasn't
> run within a certain time frame. However, we had the job stop
> yesterday and the scheduler log reports: "Interrupt task
> scheduled at {ts '2009-04-09 00:00:00'} {ts '1899-12-30 00:00:00'}
> null {ts '1899-12-30 23:59:00'}" [where I replaced the job name --
> those 1899 time stamps are actually in the log]. I haven't been able
> to find a reference to this, either on the web or on Adobe's site.
> Has anyone encountered this issue before (or know what it means)?
>
> This process is running on ColdFusion 8 Enterprise on IIS (Windows 2003)
>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322978
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Scheduler Log reports "Interrupt Task" and job stops running
where are those {ts '1899 ...} coming from?
is your scheduled task re-scheduling itself as part of its process?
is when it runs or when it re-schedules itself to based on a value of
some db column in some db table?
is that log output a result of automated scheduled task logging (if you
have it enabled in cf admin) or is that log entry created by your code?
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
On 29/05/2009 22:53, Scott Brady wrote:
> We have a scheduled task that is fairly critical (it helps generate
> significant revenue for our company), so we get alerts if it hasn't
> run within a certain time frame. However, we had the job stop
> yesterday and the scheduler log reports: "Interrupt task
> scheduled at {ts '2009-04-09 00:00:00'} {ts '1899-12-30 00:00:00'}
> null {ts '1899-12-30 23:59:00'}" [where I replaced the job name --
> those 1899 time stamps are actually in the log]. I haven't been able
> to find a reference to this, either on the web or on Adobe's site.
> Has anyone encountered this issue before (or know what it means)?
>
> This process is running on ColdFusion 8 Enterprise on IIS (Windows 2003)
>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322977
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Scheduler Log reports "Interrupt Task" and job stops running
We have a scheduled task that is fairly critical (it helps generate
significant revenue for our company), so we get alerts if it hasn't
run within a certain time frame. However, we had the job stop
yesterday and the scheduler log reports: "Interrupt task
scheduled at {ts '2009-04-09 00:00:00'} {ts '1899-12-30 00:00:00'}
null {ts '1899-12-30 23:59:00'}" [where I replaced the job name --
those 1899 time stamps are actually in the log]. I haven't been able
to find a reference to this, either on the web or on Adobe's site.
Has anyone encountered this issue before (or know what it means)?
This process is running on ColdFusion 8 Enterprise on IIS (Windows 2003)
--
-
Scott Brady
http://www.scottbrady.net/
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322976
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regex help...
On Friday 29 May 2009, Tom Jones wrote: > If I use the following regular expression in a script it works fine, I just > dont know with CF, I have not used much RE in CF yet. http://txt2re.com/ -- Helping to globally grow world-class 24/7 unique partnerships as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322975 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Regex help...
Tom, you could try this... http://www.somedomain.com"; method="GET" result="theData"> ]*[^/]?)>", trim(theData.fileContent))> -Original Message- From: Tom Jones [mailto:tjo...@acworld.com] Sent: Friday, May 29, 2009 11:03 AM To: cf-talk Subject: Regex help... Hello, I'm trying to use cfhttp to download and parse a directory listing from one of my sites. I can download the page but the parsing is a whole different story :-). I'm trying to use REFind to get all of the anchor/href tags but I'm coming up short. If I use the following regular expression in a script it works fine, I just dont know with CF, I have not used much RE in CF yet. Thanks, tom .*?)[""'].*?>(?.*?)",rawHTTP,1,"TRUE ")> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322974 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regex help...
Hi, For this type of parsing, you should have a look at CF_REextract: http://customtags.internetique.com/REextract/testREextract.cfm ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322973 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Regex help...
Hello, I'm trying to use cfhttp to download and parse a directory listing from one of my sites. I can download the page but the parsing is a whole different story :-). I'm trying to use REFind to get all of the anchor/href tags but I'm coming up short. If I use the following regular expression in a script it works fine, I just dont know with CF, I have not used much RE in CF yet. Thanks, tom .*?)[""'].*?>(?.*?)",rawHTTP,1,"TRUE")> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322972 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query question
just LIMIT 1 will do. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 29/05/2009 21:53, Ryan Letulle wrote: > add LIMIT 0,1 add the end of the query to only grab the first match > -- > Ryan > > > > On Fri, May 29, 2009 at 9:50 AM, Chad Gray wrote: > >> Sorry should have mentioned that >> >> MySQL >> >> >> -Original Message- >> From: Ryan Letulle [mailto:bayous...@gmail.com] >> Sent: Friday, May 29, 2009 10:48 AM >> To: cf-talk >> Subject: Re: query question >> >> >> what db >> -- >> Ryan >> >> >> >> On Fri, May 29, 2009 at 9:41 AM, Chad Gray wrote: >> >>> I have two tables that are joined one to many. >>> >>> I would like to write a query to get the one from the first table and >> only >>> one from the many table. >>> >>> TABLE1 >>> AlbumID, AlbumTitle >>> 1, MyPictures >>> >>> TABLE2 >>> PictureID, AlbumID, PictureName >>> 1, 1, test.jpg >>> 2, 1, test2.jpg >>> >>> How do I write the query to only get one record from TABLE2 when I join? >>> >>> SELECT * >>> FROM TABLE1 >>> JOIN TABLE2 ON TABLE2.AlbumID = TABLE1.AlbumID >>> WHERE TABLE1.AlbumID = 1 >>> >>> This query returns 2 records because there are two matches in TABLE2. >>> >>> >>> >>> >> >> >> > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322971 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query question
add LIMIT 0,1 add the end of the query to only grab the first match -- Ryan On Fri, May 29, 2009 at 9:50 AM, Chad Gray wrote: > > Sorry should have mentioned that > > MySQL > > > -Original Message- > From: Ryan Letulle [mailto:bayous...@gmail.com] > Sent: Friday, May 29, 2009 10:48 AM > To: cf-talk > Subject: Re: query question > > > what db > -- > Ryan > > > > On Fri, May 29, 2009 at 9:41 AM, Chad Gray wrote: > > > > > I have two tables that are joined one to many. > > > > I would like to write a query to get the one from the first table and > only > > one from the many table. > > > > TABLE1 > > AlbumID, AlbumTitle > > 1, MyPictures > > > > TABLE2 > > PictureID, AlbumID, PictureName > > 1, 1, test.jpg > > 2, 1, test2.jpg > > > > How do I write the query to only get one record from TABLE2 when I join? > > > > SELECT * > > FROM TABLE1 > > JOIN TABLE2 ON TABLE2.AlbumID = TABLE1.AlbumID > > WHERE TABLE1.AlbumID = 1 > > > > This query returns 2 records because there are two matches in TABLE2. > > > > > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query question
2 options off the top of my head: 1) have your query return as many records as there are, but limit the output of the query by using MAXROWS attribute of tag 2) join your first table to a sub-query that pulls only one record from the other table in your sql: SELECT TABLE1.*, sq.PictureID, sq.PictureName FROM TABLE1 JOIN (SELECT TOP 1 AlbumID, PictureID, PictureName FROM TABLE2 WHERE AlbumID = 1) AS sq ON TABLE1.AlbumID = sq.AlbumID WHERE TABLE1.AlbumID = 1 depending on your db, use either TOP 1 as above, or use LIMIT clause (i.e. in MySQL) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 29/05/2009 21:41, Chad Gray wrote: > I have two tables that are joined one to many. > > I would like to write a query to get the one from the first table and only > one from the many table. > > TABLE1 > AlbumID, AlbumTitle > 1, MyPictures > > TABLE2 > PictureID, AlbumID, PictureName > 1, 1, test.jpg > 2, 1, test2.jpg > > How do I write the query to only get one record from TABLE2 when I join? > > SELECT * > FROM TABLE1 > JOIN TABLE2 ON TABLE2.AlbumID = TABLE1.AlbumID > WHERE TABLE1.AlbumID = 1 > > This query returns 2 records because there are two matches in TABLE2. > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322969 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query question
Sorry should have mentioned that MySQL -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Friday, May 29, 2009 10:48 AM To: cf-talk Subject: Re: query question what db -- Ryan On Fri, May 29, 2009 at 9:41 AM, Chad Gray wrote: > > I have two tables that are joined one to many. > > I would like to write a query to get the one from the first table and only > one from the many table. > > TABLE1 > AlbumID, AlbumTitle > 1, MyPictures > > TABLE2 > PictureID, AlbumID, PictureName > 1, 1, test.jpg > 2, 1, test2.jpg > > How do I write the query to only get one record from TABLE2 when I join? > > SELECT * > FROM TABLE1 > JOIN TABLE2 ON TABLE2.AlbumID = TABLE1.AlbumID > WHERE TABLE1.AlbumID = 1 > > This query returns 2 records because there are two matches in TABLE2. > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322968 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Autosuggest truncating long result strings
The commas were the issue. I used the replace function in my query to remove them and it works! THANK YOU >YUI, and Yahoo Autocomplete Widget is excatly what is behind the >built-in cf8 autocomplete feature. > >I have just tested it with a 300 char long string, and, with addition of >css i have posted previously, it displayed just fine... > >mind you, if you have a , (comma) in the value displayed in the >autosuggest, it WILL break the line at the comma position. > > >Azadi Saryev >Sabai-dee.com >http://www.sabai-dee.com/ > >On 29/05/2009 20:56, Torrent Girl wrote: >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322967 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query question
what db -- Ryan On Fri, May 29, 2009 at 9:41 AM, Chad Gray wrote: > > I have two tables that are joined one to many. > > I would like to write a query to get the one from the first table and only > one from the many table. > > TABLE1 > AlbumID, AlbumTitle > 1, MyPictures > > TABLE2 > PictureID, AlbumID, PictureName > 1, 1, test.jpg > 2, 1, test2.jpg > > How do I write the query to only get one record from TABLE2 when I join? > > SELECT * > FROM TABLE1 > JOIN TABLE2 ON TABLE2.AlbumID = TABLE1.AlbumID > WHERE TABLE1.AlbumID = 1 > > This query returns 2 records because there are two matches in TABLE2. > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
query question
I have two tables that are joined one to many. I would like to write a query to get the one from the first table and only one from the many table. TABLE1 AlbumID, AlbumTitle 1, MyPictures TABLE2 PictureID, AlbumID, PictureName 1, 1, test.jpg 2, 1, test2.jpg How do I write the query to only get one record from TABLE2 when I join? SELECT * FROM TABLE1 JOIN TABLE2 ON TABLE2.AlbumID = TABLE1.AlbumID WHERE TABLE1.AlbumID = 1 This query returns 2 records because there are two matches in TABLE2. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Autosuggest truncating long result strings
AH! That makes sense. There are commas in the data. So I guess I'll need to strip the commas before I make my list? >YUI, and Yahoo Autocomplete Widget is excatly what is behind the >built-in cf8 autocomplete feature. > >I have just tested it with a 300 char long string, and, with addition of >css i have posted previously, it displayed just fine... > >mind you, if you have a , (comma) in the value displayed in the >autosuggest, it WILL break the line at the comma position. > > >Azadi Saryev >Sabai-dee.com >http://www.sabai-dee.com/ > >On 29/05/2009 20:56, Torrent Girl wrote: >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQLite, mySQL and MS SQL Express etc.
if you have a cf8-based application you are distributing, consider using the built-in Apache Derby db, and then maybe including sql scripts for other databases which a user can run to create the required db structure. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 29/05/2009 20:39, Don L wrote: > Probably I was not well versed enough in all available free relational > database platforms out there about a year ago, I picked ms sql express. Now > I found its installation has consistent problems, not for me but average > computer users, what is totally unexpected and unacceptable by whatever > standard, for some XP or Vista boxes regardless of their SP version, is the > fact that sql server installtion would crash a user's computer, and some > times keep on rebooting, it devastates a user especially those who are not > computer savvy, this show-stopper is also documented by and known to some sql > manager of MS corp as well, for at least 5 months already, however, MS has > not taken any action to fix it, it says "a small number of users experience > this problem...", one wonders if this is a way to suppress competition if any > by MS. If MS requires some small fee in exchange for making the installer > reliable that would be a good service. Dictators are always dispicable. > > mySQL is not a good choice for me, I "played" with it a little while ago but > was not impressed. > > SQLite came up this morning, it seems quite interesting, a main concern is, > how easy to install it and how reliable it is to work with CF8 or other cf > engine. > > Thanks for your time. > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322963 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Autosuggest truncating long result strings
YUI, and Yahoo Autocomplete Widget is excatly what is behind the built-in cf8 autocomplete feature. I have just tested it with a 300 char long string, and, with addition of css i have posted previously, it displayed just fine... mind you, if you have a , (comma) in the value displayed in the autosuggest, it WILL break the line at the comma position. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 29/05/2009 20:56, Torrent Girl wrote: > I have established that it's not the sql that is truncating the results. > > So it must be the widget. > > >> This looks like what I need (for anyone else who may need it) >> >> http://developer.yahoo.com/yui/docs/YAHOO.widget.AutoComplete.html >> >> Hoping that it shows the setting that I am looking for. > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322962 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Autosuggest truncating long result strings
I have established that it's not the sql that is truncating the results. So it must be the widget. >This looks like what I need (for anyone else who may need it) > >http://developer.yahoo.com/yui/docs/YAHOO.widget.AutoComplete.html > >Hoping that it shows the setting that I am looking for. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
listtoarray -adding values with commas throws an error?
I've got a simple shopping cart that stores into in an array. If the product name has commas, and it attempted to be added to the cart, it throws an error: "The value cannot be converted to a number". Error message is telling me this is the problem line: What gives? I've not seen this before? Do the commas in the product name need to be escaped somehow?? And where? -John B ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322960 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT, looking for an affordable SMTP/POP3 solution
Thanks all for your suggestions. I also received this one from my server host support : MailEnable Any one aware of it ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322959 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQLite, mySQL and MS SQL Express etc.
Probably I was not well versed enough in all available free relational database platforms out there about a year ago, I picked ms sql express. Now I found its installation has consistent problems, not for me but average computer users, what is totally unexpected and unacceptable by whatever standard, for some XP or Vista boxes regardless of their SP version, is the fact that sql server installtion would crash a user's computer, and some times keep on rebooting, it devastates a user especially those who are not computer savvy, this show-stopper is also documented by and known to some sql manager of MS corp as well, for at least 5 months already, however, MS has not taken any action to fix it, it says "a small number of users experience this problem...", one wonders if this is a way to suppress competition if any by MS. If MS requires some small fee in exchange for making the installer reliable that would be a good service. Dictators are always dispicable. mySQL is not a good choice for me, I "played" with it a little while ago but was not impressed. SQLite came up this morning, it seems quite interesting, a main concern is, how easy to install it and how reliable it is to work with CF8 or other cf engine. Thanks for your time. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322958 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Autosuggest truncating long result strings
This looks like what I need (for anyone else who may need it)
http://developer.yahoo.com/yui/docs/YAHOO.widget.AutoComplete.html
Hoping that it shows the setting that I am looking for.
> Thanks
>
> I added these line. I see that it controls the width of the div(there
> the results show up) but my text is still being truncated.
>
> I think it's a sql issue.
>
> Here is what I am doing:
>
> I am querying a database returning two pieces of info.
> The first is an ID number and the second is text
> I do a cast on the ID num as a varchar
> I concatenate these 2 items in a subquery
>
> I think somewhere in the steps above, the data may be truncated.
>
>
>
>
> >if you are using cf8's built-in autosuggest feature, add this to
> your
> >css file:
> >
> >.autosuggest, .autosuggest div {width:100%}
> >div.autosuggestcontainer .yui-ac-content {width:auto !important}
> >div.autosuggestcontainer .yui-ac-content ul {list-style:none}
> >
> >
> >Azadi Saryev
> >Sabai-dee.com
> >http://www.sabai-dee.com/
> >
> >
> >On 29/05/2009 19:11, Torrent Girl wrote:
> >> Is there anyway for me change this? possibly in CFIDE somewhere?
> >>
> >>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322957
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Autosuggest truncating long result strings
Thanks
I added these line. I see that it controls the width of the div(there the
results show up) but my text is still being truncated.
I think it's a sql issue.
Here is what I am doing:
I am querying a database returning two pieces of info.
The first is an ID number and the second is text
I do a cast on the ID num as a varchar
I concatenate these 2 items in a subquery
I think somewhere in the steps above, the data may be truncated.
>if you are using cf8's built-in autosuggest feature, add this to your
>css file:
>
>.autosuggest, .autosuggest div {width:100%}
>div.autosuggestcontainer .yui-ac-content {width:auto !important}
>div.autosuggestcontainer .yui-ac-content ul {list-style:none}
>
>
>Azadi Saryev
>Sabai-dee.com
>http://www.sabai-dee.com/
>
>
>On 29/05/2009 19:11, Torrent Girl wrote:
>> Is there anyway for me change this? possibly in CFIDE somewhere?
>>
>>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322956
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
File to large errors when posting to CF8
Does anyone know why I get: 500 File too large java.io.IOException: File too large at java.io.FileOutputStream.writeBytes(Native Method) at java.io.FileOutputStream.write(FileOutputStream.java:260) at java.io.BufferedOutputStream.write(BufferedOutputStream.java:105) at com.oreilly.servlet.multipart.FilePart.write(FilePart.java:252) at com.oreilly.servlet.multipart.FilePart.writeTo(FilePart.java:210) at coldfusion.filter.FormScope.fillForm(FormScope.java:228) ... if I post a form containing a file upload, where the file is greater than a mere two megabytes ? Adobe CF8 on Linux via. Apache, if it helps. I don't see anything obvious in the CF admin -- Helping to apprehensively revolutionize vertical prospective bricks-and-clicks guinine market-growth as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word âpartnerâ to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322955 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Inserting blobs using cffile into MSSQL05
I wrote the section below to insert PDF files directly into my database. For some reason it sometimes works and sometimes it doesn't. I've noticed the files are OK when they're uploaded to the server (and they're viewable) but when I save them from the database they've been truncated and corrupted. Adobe suggests converting the binaries to base64... As a test I converted file_blob into base64, saved it into the database and retrieved it but it was still truncated and corrupted. >From what I see that would point to the 2nd cffile as the culprit - has anyone >else seen this before? insert into t_je_attachments ( id_je ,timestamp ,filename ,fileActual ) values ( #jeid# ,#currentTimeODBC# ,'#file.ServerFile#' , ) tia, - Joe ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322954 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL IDE on OS X
Personally I went with Querious, defiantly worth the small cost of it, granted I got in on it at the start but more features that sequal pro and still only $25 http://www.araelium.com/querious/ http://theappleblog.com/2009/02/27/mysql-showdown-querious-vs-sequel-pro/ some others http://theappleblog.com/2009/03/31/eight-more-mysql-apps-for-os-x/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322953 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL IDE on OS X
>Can anyone recommend a good MySQL IDE on OS X? So far I've been using >Navicat but it's kind of a joke. > >Anyone have one they actually like? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322952 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Autosuggest truncating long result strings
Sorry, no experience there. I use the one you started with. -- Ryan On Fri, May 29, 2009 at 7:50 AM, Torrent Girl wrote: > > Now I am using the coldfusion autosuggest. I nver got that other one to > work. > > > > >That might be a setting in the autocomplete js. There are some default > >settings in the middle of the js. You are using the one from bassistance > >right? > >-- > >Ryan > > > > > > > > > > > >> > >> Is there anyway for me change this? possibly in CFIDE somewhere? > >> > >> > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322951 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Autosuggest truncating long result strings
if you are using cf8's built-in autosuggest feature, add this to your
css file:
.autosuggest, .autosuggest div {width:100%}
div.autosuggestcontainer .yui-ac-content {width:auto !important}
div.autosuggestcontainer .yui-ac-content ul {list-style:none}
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
On 29/05/2009 19:11, Torrent Girl wrote:
> Is there anyway for me change this? possibly in CFIDE somewhere?
>
>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322950
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Autosuggest truncating long result strings
Now I am using the coldfusion autosuggest. I nver got that other one to work. >That might be a setting in the autocomplete js. There are some default >settings in the middle of the js. You are using the one from bassistance >right? >-- >Ryan > > > > > >> >> Is there anyway for me change this? possibly in CFIDE somewhere? >> >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322949 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Time from client to multiple servers.
Situation is this. Have an architecture with multiple coldfusion servers geographically separated. Trying to find a way for a user to determine which server would be the best for them to use based on speed. Was thinking of something along the lines of this. Although the speed here is based on the time it is processed on the server rather than the time it actually hits the client. Sure this is something dumb, it just isn't clicking right now. Any help would be appreciated. http://#i#/speedcheck.html";> Time to site (#i#) is : #tottime# ms ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322948 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Autosuggest truncating long result strings
That might be a setting in the autocomplete js. There are some default settings in the middle of the js. You are using the one from bassistance right? -- Ryan On Fri, May 29, 2009 at 7:11 AM, Torrent Girl wrote: > > Is there anyway for me change this? possibly in CFIDE somewhere? > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Autosuggest truncating long result strings
Is there anyway for me change this? possibly in CFIDE somewhere? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322946 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Email via cfmail tag goes to junk folder
On Friday 29 May 2009, Vineetha Varghese wrote: > I am using cfmail to send out emails. For some users it goes to the junk > mail folder. The email content has a link. When I remove the link it goes > to the Inbox. From address is a valid address. Pipe the email through SpamAssassin or something, and see what it moans about. -- Helping to competently cultivate essential m-commerce as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322945 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dynamic robots.txt
On Wed, May 27, 2009 at 8:17 PM, Michael Dinowitz wrote: > I've gone the route of rewriting IIS's 404 handler in the past and I highly > suggest against it. Mapping .txt to CF would work, but that means every .txt > file will be handled, not just robots.txt. So don't put *.txt in your web.xml, but put /robots.txt in your web.xml. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322944 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 SQL Deadlock
On Thu, May 28, 2009 at 2:18 PM, Andy Gillette wrote: > Error Executing Database Query. [Macromedia][SQLServer JDBC > Driver][SQLServer]Transaction (Process ID 87) was deadlocked > While looking in the FusionReactor logs, I am noticing that this seems to be > only happening when the "Finished Request Count" in FR is above CF's "Maximum > number of simultaneous Template requests" (which is set to 60). > I am guessing (that is what I need clarification on) that this is what is > giving us the deadlocks? I think you are confusing cause and effect. Most likely you have a deadlock, requests queue up behind the deadlock and when the deadlock is resolved by rolling back one of the transactions involved all the queries in the queue finish immediately and cause the spike in the finished request count. > Should we be using CF Enterprise? This is not a CF problem but a database problem. Since you haven't provided any details on the database we can only provide general guidance: 1. MS SQL Server has an option to log the SQL statement of all the transactions involved a deadlock. Use that to see which statement is the deadlock winner and figure out what the resources under contention are. 2. MS SQL Server by default uses a transaction isolation level that causes writes to block reads and vice versa. Since version 2005 snapshot isolation is available, which doesn't do predicate locking so only writes block writes (at the cost of moving from mathematical serializability to the limited serializability defined in the SQL standard). Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322943 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Email via cfmail tag goes to junk folder
On Fri, May 29, 2009 at 2:56 AM, Vineetha Varghese wrote: > I am using cfmail to send out emails. For some users it goes to the junk mail > folder. The email content has a link. When I remove the link it goes to the > Inbox. If the presence of the link makes the difference between your email being recognized as spam or not I would check the link hostname with SURBL: http://www.surbl.org/ Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322942 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SOT, looking for an affordable SMTP/POP3 solution
| I'm moving my CF applications to a new dedicated server, and I need to | both send messages and receive, | for several users under several domains. What OS? If Windows - I can definately recommend hmailserver - http://www.hmailserver.com/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322941 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
