RE: CFMX7 Now casts query columns as datetime?

2005-04-04 Thread Mark W. Breneman
I can verify that it is CF that is doing this. In CFMX (6) you could set any query cell to any value. In CFMX 7 it looks that CFMX uses typed columns. You can not use querysetcell to format a date in the mm/dd/ format, if the query is returning a date column. Anyone else see this? Mark

CFX_Paymentnet and Verisign

2005-04-04 Thread Jeff Langevin
Does anyone know where I can get a copy of CFX_Paymentnet? We are running Ablecommerce 3 and want to enable real-time credit card processing. However, this custom tag is required and it no longer appears to be available on the VeriSign website (Verisign has not been too helpful). --Jeff

RE: Any news from MM on the broken IIS6 connector on stand alone installs???

2005-04-04 Thread Matt McDonald
This is the response on the Macromedia forums: We have identified the issue and it occurs only when using the CFMX 6.1 updater (the bug is not in CFMX 7) and only when using the JRun connector. We are working to get a hotfix released for the JRun connector as quickly as we can. Sorry about

RE: CFMX7 Now casts query columns as datetime?

2005-04-04 Thread Mark W. Breneman
Hey Tony, Your suggestion on casting it as a varchar works well. Thanks! This causes problems for me where I want to apply date formatting to a query column. Yes, I know applying a date format in a query result is a different way of doing it. But, I have application where it is required.

RE: CFX_Paymentnet and Verisign

2005-04-04 Thread Mark W. Breneman
If at all possible you might want to look into the java CF_payflowpro tag as a replacement. I could not get CFX_Paymentnet running on a new windows 2003 server. (That does not mean it can not be done) If you contact me off list I can send you a copy of the CFX_Paymentnet tag, but it is very

RE: Anything wrong with this statement?

2005-04-04 Thread Rick Faircloth
Ok...I got this part figured out...now the users can click Add Another Photo and the page resubmits and adds another CFFILE filefield and caption field... I know this could be done more elegantly in JavaScript...but I'm no JS'er... You know, it's too bad the CFFILE file selection dialog won't let

Re: CFMX7 Now casts query columns as datetime?

2005-04-04 Thread Tony Weeg
really? what kind of application? one that doesnt do it on the other side? basically when you hand it off from cf to the other application it just looks at it, and cant format it for itself? tony On Apr 4, 2005 3:24 PM, Mark W. Breneman [EMAIL PROTECTED] wrote: Hey Tony, Your suggestion

RE: Anything wrong with this statement?

2005-04-04 Thread Burns, John D
That's not a CFFILE filefield. That's an HTML form element of the type file. It's a standard HTML problem. I think most people dislike it but you get used to it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From:

Re: Anything wrong with this statement?

2005-04-04 Thread Claude Schneegans
When the page is submitted back to itself, the variable is upped 1, Ah ah! Here is what is wrong: when the page resubmit itself, the variable Photo is lost and a new one (default = 0), Unless you resend the variable through the URL or as an hidden field. You could also use a session variable

Re: Running exe file from browser

2005-04-04 Thread Tim Claremont
Thanks Jim, but still a problem. I am using: file://g:/applications/foobar.exe There are several applications in that directory. SOME of the applications launch without a hitch, but when I use this particular FoxPro application I get the File security.exe does not exist error. Note that this

RE: CFMX7 Now casts query columns as datetime?

2005-04-04 Thread Mark W. Breneman
Tony, The application where this is used needs to be keep generic and needs to be able to accept many different types of data. This application is one part of an in-house system smartVar UDF, I wrote to really simplify the creation of the many CRUD (CreateReadUpdateDelete) pages I make. (I

RE: Anything wrong with this statement?

2005-04-04 Thread Rick Faircloth
I finally went the variable in a hidden formfield route... Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 3:50 PM To: CF-Talk Subject: Re: Anything wrong with this statement? When the page is submitted back to itself, the

Re: CFMX7 Now casts query columns as datetime?

2005-04-04 Thread S . Isaac Dealey
Has anyone else noticed that CFMX7 now casts a date column as date time in queries? Or is it just a Monday and I have not recovered from the weekend? When I run a query to get one record cfquery name=getbuilds datasource=#database# SELECTStartDate, RecordId, RecordDate FROM

RE: Running exe file from browser

2005-04-04 Thread Dave Watts
I am using: file://g:/applications/foobar.exe There are several applications in that directory. SOME of the applications launch without a hitch, but when I use this particular FoxPro application I get the File security.exe does not exist error. Note that this is a FoxPro Error Message

RE: What are optimal GC/JVM settings?

2005-04-04 Thread Jacob
What I read was that if you increase the heap size, you must also increase the perm size. This setting has worked well so far for me. BUT... I can reduce the perm size on a couple of servers. Maybe I do not need it this high. I will start at 256 and see what happens. Jacob -Original

Re: Running exe file from browser

2005-04-04 Thread Tim Claremont
There is NOT a file called security.exe in that directory. There IS a security.exe a couple of subdirectories down, but the executable to launch the application, and the sexurity.exe file are NOT in the same directory. Further, I copied the security.exe file to the application start directory

Re: Access query problem in CF

2005-04-04 Thread Jann E. VanOver
Did you try single quotes? Try WHERE datepart('h',statistique.date_in) = 11 CFDEV wrote: Thanks but it still says too few parameters :( I'm on CFMX 6.1 with a MS Accecss datasource. Pat -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: April 2, 2005 19:41 To:

Can we pitch in to send one of the goodguys to CFUNITED?

2005-04-04 Thread Will The Game
Hey all, As you know, Jared R-H posts quite a bit here. He's helped me out a ton, and probably has helped many of you as well. He's an exceptional CF'er, JS'er, blogger and provides plenty of great code for us to use. As of right now Jared will not be able to attend CFUNITED do to some

RE: search engines

2005-04-04 Thread dave
Someone brought up serving up different content to a bot then to the viewers as being a viable solution but wordpress just found out the hard way thats not the way to go. Google officials declined to comment on why WordPress.org pages had dropped from the company's index, but its Webmaster

Re: Web Based Mail Merge? (not email!)

2005-04-04 Thread Rebecca Wells
When I use CF to create mail merge type form letters, I first set up my format characters as a block of variables, like this: !--- Generic formatting variables. --- cfset crlf = #chr(13)##chr(10)# !--- carriage return, line-feed --- cfset cr = #chr(13)# !--- carriage return --- cfset lf =

RE: Web Based Mail Merge? (not email!)

2005-04-04 Thread Dave Watts
Then I just loop over the query with the data for the variables and build a variable with the letter text, like this: cfset ResidentLtrs = ResidentLtrs #topmargin# ... I think it's worth pointing out that if you're going to concatenate strings, you don't need to wrap pound signs around

RE: search engines

2005-04-04 Thread Rick Faircloth
Good to knowthanks for the heads up, Dave! Rick -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 5:15 PM To: CF-Talk Subject: RE: search engines Someone brought up serving up different content to a bot then to the viewers as being a viable

RE: Web Based Mail Merge? (not email!)

2005-04-04 Thread Calvin Ward
I've always found pound signs make it hard for me to read stuff so I find myself organizing my code in such a way as to avoid them where reasonable. Nice solution Rebecca. - Calvin -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 5:28 PM To:

RE: Dreaded cfform.js Error

2005-04-04 Thread Calvin Ward
It doesn't have to be mapped, it can be physically beneath each site (if you do that, be sure to NOT include your CF Admin stuff). - Calvin -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 11:41 AM To: CF-Talk Subject: Re: Dreaded

RE: Any news from MM on the broken IIS6 connector on stand alone installs???

2005-04-04 Thread Paul Vernon
Thanks for that... Do you have a URL for the forums Paul ~| 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

For Rey Bango

2005-04-04 Thread Chris Manougian
Way Off Subject: Rey, I've got a problem that you helped solve for a guy installing Allaire Forums back in 2000. Sorry to be posting this here, but this is the only way I could get you. The guy you helped posted: I have just installed Allaire Forums 2.06 (CF4.01), and although it installed

Re: For Rey Bango

2005-04-04 Thread Jochem van Dieten
Chris Manougian wrote: The Allaire knowledgebase article that discusses how to fix this can be found at: http://www.allaire.com/Handlers/index.cfm?ID=1560Method=Full Rey, the Allaire KB is no more. Do you happen to have this KB article - or could you set me in the right direction to get

RE: For Rey Bango

2005-04-04 Thread Emmet McGovern
Here you go. Never can tell when archive.org will come in handy. You are getting one of the following error trying to post a message right after installing Forums or when posting or deleting a message: Error: Error occurred in tag CFINDEX Collection failed to open:

Re: Web Based Mail Merge? (not email!)

2005-04-04 Thread Rebecca Wells
Thanks. And thanks for the reminder, guys, re: the pound signs. Sometimes when I'm in a rush, I just slip into old habits just to meet some deadline. I'm sure we all have moments when we look back on code we've written in the past and groan. There are probably developers somewhere who inherited

Generating BarCodes in CF

2005-04-04 Thread Ali Awan
I was wondering if anyone knows of any CF apps, or used CF to connect to 3rd party apps to generate barcodes. Specifically 2D barcodes. If you are familiar with barcodes, you will know what that means :-) There are some off-the-shelf cfapps that generate barcodes but not in that format.

Re: CSV file and com.Ostermiller.util.ExcelCSVParser

2005-04-04 Thread Jon Gunnip
Victor, I'm using the ostermiller CSVWriter, and I am very happy with it. I'm having trouble understanding exactly what your problem is. Can you share some relevant code? Jon On Apr 4, 2005 12:58 PM, Victor Moore [EMAIL PROTECTED] wrote: Actually it's a little bit more complicated than this.

Re: efflare - CFX_gfont

2005-04-04 Thread Dwayne Cole
Surprise that you have not heard from them. Usually pretty responsive. -- Original Message -- From: Bailey, Neal [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Mon, 4 Apr 2005 11:12:39 -0500 Hey guys, Anyone out there using the CFX_gfont

Re: For Rey Bango

2005-04-04 Thread Chris Manougian
Jochem and Emmet, thanks very much. The article states: Go into ColdFusion Administrator, click the Verity link (note the path to the directories for each on your hard drive in parenthesis), and delete these two collections: Forums_CFForums_Messages Forums_CFForums_Subjects bThen, go into

Re: What are optimal GC/JVM settings?

2005-04-04 Thread Sean Corfield
On Apr 4, 2005 1:30 PM, Jacob [EMAIL PROTECTED] wrote: What I read was that if you increase the heap size, you must also increase the perm size. Where did you read that (because it isn't true)? BUT... I can reduce the perm size on a couple of servers. Maybe I do not need it this high. I

RE: For Rey Bango

2005-04-04 Thread Dave Watts
When they say file system, do they mean do a manual delete through Windows? Yes. Also, the article goes on to talk about reindexing. I had not thought of this concerning CF. I run an app on Novell that I requires reindexing every other day. Do you have to maintain CF/a CF database in

RE: Generating BarCodes in CF

2005-04-04 Thread CFDEV
http://www.fusionzone.com/ http://www.infosoftglobal.com/PoS4TallyPro/index1.html -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: April 4, 2005 18:48 To: CF-Talk Subject: Generating BarCodes in CF I was wondering if anyone knows of any CF apps, or used CF to connect

Re: CFMX7 Now casts query columns as datetime?

2005-04-04 Thread Sean Corfield
On Apr 4, 2005 12:20 PM, Mark W. Breneman [EMAIL PROTECTED] wrote: I can verify that it is CF that is doing this. In CFMX (6) you could set any query cell to any value. In CFMX 7 it looks that CFMX uses typed columns. Yes, one of the changes in CFMX 7 is to make more use of query metadata so I

Re: CSV file and com.Ostermiller.util.ExcelCSVParser

2005-04-04 Thread Victor Moore
Hi Jon, I'm happy with this utility , except this little problem. Bellow is the code: cfscript parser = createObject(java, com.Ostermiller.util.ExcelCSVParser) ; fileInfo = parser.parse(fileContents) ; noFields = arrayLen (fileInfo); for (i = 2; i lte noFields; i = i + 1) { lineArray

Re: Can we pitch in to send one of the goodguys to CFUNITED?

2005-04-04 Thread Paul Kenney
I would like to meet Jared myself, so its in my best interests to help him out. Can't think of a better way. On Apr 4, 2005 1:51 PM, Will The Game [EMAIL PROTECTED] wrote: Hey all, As you know, Jared R-H posts quite a bit here. He's helped me out a ton, and probably has helped many of

Re: For Rey Bango

2005-04-04 Thread Chris Manougian
Many thanks to all. I have it running locally. Now it's server time. CF (and the whole server setup issue) is more intense than I thought it would be. I'm glad I was able to set it up locally first. I don't know how much development I'll try outside of the Forums program. I got lucky with

Re: Any news from MM on the broken IIS6 connector on stand alone installs???

2005-04-04 Thread Jared Rypka-Hauer - CMG, LLC
Yeppers... http://www.macromedia.com/support/forums/ One account will get you access to all forums, the downloads section and the store. Very well done stuff... J On Apr 4, 2005 4:50 PM, Paul Vernon [EMAIL PROTECTED] wrote: Thanks for that... Do you have a URL for the forums Paul

Re: Web Based Mail Merge? (not email!)

2005-04-04 Thread Jared Rypka-Hauer - CMG, LLC
All, I agree that RTF (or, possibly PDF, but that presents its own challenges) is probably the way to go. Rick, you're going to want to take your query, or whatever format your source data is in and just loop over it (this could produce several nested loops - don't be afraid to just do it) to

Re: Any news from MM on the broken IIS6 connector on stand alone installs???

2005-04-04 Thread Mike Kear
And all those people said it was MY fault. They implied I was deficient in not being able to make it run. '... I've installed it dozens of times and it worked ok for me ... they said, the implied criticism being that I must be somehow stupid or have pennypinched on my hardware if i couldn't

Re: Any news from MM on the broken IIS6 connector on stand alone installs???

2005-04-04 Thread Jared Rypka-Hauer - CMG, LLC
But Mike... It DID install for me! Really... Nary a bug in site (except for having to recompile the Apache connector on SuSE, but there were instructions for that). Maybe it's a polar thing... since I'm that close to the North Pole and you're that close to the South Pole, it could be that. Or

Re: Create Excel file??

2005-04-04 Thread Nathan Drury
G'day Scott We are looking to use XML to generate Excel and Word files using CF. Your example is great - thanks! Do you know of any other resources that would assist us with doing this sort of thing? Have you run into any limitations or problems? We have an app that uses COM generate Excel

cfc error

2005-04-04 Thread dave
anyone know what this error means? Local variable qLF on line 18 must be grouped at the top of the function body. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application

Re: cfc error

2005-04-04 Thread Jon Austin
Are all of your cfargument statements grouped under your cffunction? //got nuthin On Apr 5, 2005 2:40 PM, dave [EMAIL PROTECTED] wrote: anyone know what this error means? Local variable qLF on line 18 must be grouped at the top of the function body.

Re: cfc error

2005-04-04 Thread dave
here it is cfcomponent !---     function getQLF     Generated by the CFC Recordset ColdFusion MX Extension     Mon Apr 04 22:08:12 GMT-0600 (Mountain Daylight Time) 2005     --- cffunction name=getQLF output=false access=private returntype=query cfset dsn=it cfset un=that cfset pw=this

RE: cfc error

2005-04-04 Thread Taco Fleur
If you use var in front of any of your variables then they need to be right after your arguments, i.e. function arguments cfset var qLF = / -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Tuesday,

RE: cfc error

2005-04-04 Thread Taco Fleur
cfcomponent !---     function getQLF     Generated by the CFC Recordset ColdFusion MX Extension     Mon Apr 04 22:08:12 GMT-0600 (Mountain Daylight Time) 2005     --- cffunction name=getQLF output=false access=private returntype=query   cfset var qLF = cfset dsn=it cfset un=that

<    1   2