Re: Get New Record ID in mySQL

Aaron Rouse wrote: I am not familar with MySQL but what would be the advantage of using that function over just using cftransaction cfquery ...INSERT INTO myTABLE (myCOLUMNS) VALUES (myVALUES) /cfquery cfquery ... name=get SELECT MAX(ID) AS NewID FROM myTABLE /cfquery /cftransaction

ThreeSelectRelated Distinct value

Hi I am using the three select related select box. I have one table, which has, State | City | Name fields. The CustomTag works fine, except there are multiple states are showing in the first select box. how can I get the Distinct value of the states CFQUERY DATASOURCE=#DSN# NAME=TestQuery

Re: submit a form to two servers...

Thanks Mike, The funny part is that Iook at cfhttp but some how I missed it. Thank God for this list that can smack you in the head when you fell a sleep at the wheel. Thanks again Victor On 6/5/05, Dawson, Michael [EMAIL PROTECTED] wrote: Use CFHTTP POST to send the form fields to a different

RE: trapping/logging errors in onSessionEnd in application.log

Silly question: is there enough disk space on the drive with the logs? We've seen this before and, lo-and-behold, monitoring failed (or was ignored) and the machine a 0 kb free on the D drive (where the logs were). Plenty of space on C meant that Windows and CF was running fine... just no

RE: Query of Queries with dates

To answer my own question for the sake of posterity...the problem I was running into was caused by two things: 1) In my original SELECT statement, where I was getting data from the database, I had repeated the sales_appointment_date field twice, 2) It seems you can't use ODBC dates--you need to

Hot Banana

Anyone ever used Hot Banana's CMS? Good? Bad? Costs? www.hotbanana.com This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is

cfdocument pdf output

Hi all, trying to do a output via cfdocument format=pdf.. it is a form that posts back to its self. It generates the pdf file but my mac always whats to use Dreamweaver to open it with rather than the acrobat plug in for the browser. Any suggestions on how to fix this? TIA Mark Holm Get

Zipping or Rar Large Files with Coldfusion

Hello, I have a really large Txt file that I would like to Zip then Send to my server then upzip it there using CFX_ZIP. The problem that I am running in to is that the file is too large for a valid zip archive the file is over 5gb. Each time I try to unzip it on the server I get a corrupt

RE: Zipping or Rar Large Files with Coldfusion

I use the command line tools for WinRAR (http://www.rarlab.com/download.htm), using cfexecute. Works well for me, but the largest file I've unzipped is around 100 meg. HTH, Brad Roberts -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Sunday, June 05, 2005 5:18 PM To:

Re: trapping/logging errors in onSessionEnd in application.log

I logged a bug in March for onSessionEnd. It was just fixed, and I expect it will be released with a cumulative updater soon. Bug 59913- onSessionEnd event does not fire unless This.Sessiontimeout is defined in Application.cfc. The default session timeout in CFAdmin is ignored. Maybe this

RE: Zipping or Rar Large Files with Coldfusion

Winzip has command line utilities built into version 9.0. At a past job we used it to unzip 350MG files nightly using cfexecute. It supports command line zipping and unzipping. Duane -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED] Sent: Sunday, June 05, 2005 6:38 PM To:

RE: Zipping or Rar Large Files with Coldfusion

That is a good suggestion.  Thanks Brad I will give it a try. Mike From: Brad Roberts [EMAIL PROTECTED] Sent: Sunday, June 05, 2005 3:37 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Zipping or Rar Large Files with Coldfusion I use the command

Re: Zipping or Rar Large Files with Coldfusion

Although I haven't tried it but how about using Java classes for zipping and unzipping. This package might give you a head start. Package java.util.zip Qasim On 6/5/05, Mickael [EMAIL PROTECTED] wrote: That is a good suggestion. Thanks Brad I will give it a try. Mike

Re: Zipping or Rar Large Files with Coldfusion

There is a great cfc available for free from Web clarity using the java zip methods - we use it on a daily basis with great sucess. www.webclarity.com On 6/6/05, Qasim Rasheed [EMAIL PROTECTED] wrote: Although I haven't tried it but how about using Java classes for zipping and unzipping. This

Re: trapping/logging errors in onSessionEnd in application.log

Thanks Steven, I don't believe that was the case -- in any event I did make sure to define sessiontimeout in the Application.cfc pseudo-constructor. I've managed to get the onSessionEnd code working in spite of my logging / error trapping problems... As it turns out I suspect IIS has been

Re: OT: xmlHTTP

Might not help you, but I found CFajax last week and it's pretty straightforward to get working, removes the need for a lot of the JS coding. http://www.indiankey.com/cfajax/project.asp Seems to be a fairly new project but the developer is releasing things pretty regularly so hopefully it will

CFserver MX memory usage

Hi, I have a customer W2003, SQL2000, CFMX6.1 with updater and latest drivers, Xeon 3.2, 2Gb Ram. The server is using no external dlls. When CF is started the Jrun process is using 130M. With virtually no activity on the server the memory starts climbing to 400 in a few hours and then continues

asynch cfml gateway - working example

This just isn't my week... I'm guessing there's not a working exmaple of the asynch cfml gateway included in either of the example apps included with the Getting Started Experience since the only 2 gateway instances pre-installed were both SMS. Does anybody have some working code I can test

RE: OT: xmlHTTP

Thanks for that one. I'm looking at writing a wrapper functions.cfm page to enable me to call CFCs. -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, 6 June 2005 9:03 To: CF-Talk Subject: Re: OT: xmlHTTP Might not help you, but I found CFajax last week

nevermind -- asynch cfml gateway - working example

Argh... did I mention this isn't my week? I just realized I had the cfc in a directory with an Application.cfm that performed an abort on any base template with a file extension other than .css or .js (just in case somebody assigned these to be processed by cf)... Of course, as soon as I added

Re: OT: xmlHTTP

Thanks, I will look into that. I found the problem with my code. I had forgot to use cfcontent type=text/xml in the page that creates the xml from the query. Everything works fine now. - Original Message - From: James Holmes [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com

Re: Zipping or Rar Large Files with Coldfusion

There is a great cfc available for free from Web clarity using the java zip methods - we use it on a daily basis with great sucess. www.webclarity.com I checked out the CFC because it looked really interesting. FYI, I did a quick code review and noticed that this CFC is mostly likely not thread

Re: Zipping or Rar Large Files with Coldfusion

I also wrote a CFC for zip: http://www.olimpo.ch/tmt/cfc/tmt_zip/ But I guess for such large archives cfexecute would be better Massimo Foti Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com

ot: flash platform

whoa, wasn't expecting this! http://www.communitymx.com/content/article.cfm?cid=549C1 ~Dave the disruptor~ This bottle of lemonaid says contains no lemon juice and the can of Pledge says contains real lemon juice figures @%*((%

RE: flash platform

-Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Monday, June 06, 2005 1:17 AM To: CF-Talk Subject: ot: flash platform whoa, wasn't expecting this! http://www.communitymx.com/content/article.cfm?cid=549C1 Honestly I've been expecting it for years. They've been