used to use cfml.exe but MX doesn't have it...

2003-06-27 Thread cf talk
I had a bat file that created an HTML page based off of the running of a CFM page. With MX, it doesn't work anymore. Can anyone look at what I was doing and give me some direction? Bat file: REM *** set variable to contain URL variables set QUERY_STRING=PASSEDNAME=a0002 REM *** set

Is there a way to test to see if a data source exists?

2003-06-27 Thread Stan Winchester
Thank you for all the suggestions! Using the following cfcatch block I get the below messages returned cfcatchtype=Database cfoutput#cfcatch.message#/cfoutput /cfcatch CF5 ODBC SQL 2K: ODBC Error Code = IM002 (Data source not found and no default driver specified) CFMX SQL 2K: Data source

RE: error handling question

2003-06-27 Thread Mosh Teitelbaum
Mark: CFTRY/CFCATCH is definitely the way to go here. Something like: CFLOOP ... CFTRY CFQUERY ... /CFQUERY CFCATCH EXCEPTION=Database !--- Do nothing ---

RE: used to use cfml.exe but MX doesn't have it...

2003-06-27 Thread DURETTE, STEVEN J (AIT)
Brian, I asked this question before. Short answer... Can't be done. CFMX is now entirely Java. No more cfml.exe. I'm sure that there is probably some way to make it work, but instead I found another way to do what I wanted. Do you have to do it in a batch file or can you find another way to

CSV Upload Note

2003-06-27 Thread Andy Ousterhout
I've tested using OBDC to upload CSV files into queries and have found that they do not handle the following situation properly: Small Heart, with Red decorations is translated as Small Heart, with Red and Small Heart, with PINK decorations becomes Small Heart, with PINK The following

Re: Remote SQL Server and intermittent connection

2003-06-27 Thread William Bowen
via MS SQL Server driver configg'd in the Admin or via ODBC datasource (configg'd in ODBC Datasources CP and then via ODBC socket in the CFMX Admin? The reason I ask is that when I upgraded our servers to CFMX *all* of our datasources that were MS Sql Driver completely blew up. the only way I

RE: used to use cfml.exe but MX doesn't have it...

2003-06-27 Thread cf talk
Steve, I would love to not use a bat file. I just don't know how to create an html file from the data of a CFM page. Brian Brian, I asked this question before. Short answer... Can't be done. CFMX is now entirely Java. No more cfml.exe. I'm sure that there is probably some way to make it

RE: End of stream was detected on a read...again?

2003-06-27 Thread SPANGLER ALAN L. (dal1als)
I have come to the conclusion that there is no answer for this question. But I did find a workaround. I installed Oracle's JDBC Type IV thin driver and configured the DSN in MX server for other driver type. I don't know if MS SQL has a JDBC driver you could use though... Alan. -Original

RE: used to use cfml.exe but MX doesn't have it...

2003-06-27 Thread Douglas.Knudsen
You could write a cfm page that does a CFHTTP call to your CF script and save the results to an HTML file. If you need this to run automagically, you could use the scheduler. Doug -Original Message- From: cf talk [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 5:11 PM To:

Re: CSV Upload Note

2003-06-27 Thread jon hall
If you were using a the correct custom delimiter for your file ...that's quite a bug, and quite incredible that it has gone undetected for all these years. If you left the DSN on the default of CSV delimited...expect crazy things like that to happen, because the example you give is _not_ a valid

Re: CFM Shopping Cart System

2003-06-27 Thread Fusion
I would to - Original Message - From: Dan Phillips [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 27, 2003 9:53 AM Subject: RE: CFM Shopping Cart System Same here. -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 12:50

RE: CSV Upload Note

2003-06-27 Thread Andy Ousterhout
However, it is the CSV file format output by Peachtree, which is what I need to interface with and represents real data input by Users. So I am stuck with my work around. I was hoping for an easier and faster solution. Andy -Original Message- From: jon hall [mailto:[EMAIL PROTECTED]

Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Jim Davis
This may be a VERY dumb question, but I'm brain fried. Okay - so I'm working on a form and I need to validate fields for many things. Taking email address for example I need to validate that it's been filled in (not zero length), that it's less than 255 characters (the database limit), that it

Re: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Kwang Suh
Why not use the condition attribute? cfloop condition=theForm eq valid - Original Message - From: Jim Davis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 27, 2003 5:26 PM Subject: Smart or Stupid (CFLOOP as a GOTO) This may be a VERY dumb question, but I'm brain

RE: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Jim Davis
That's only checked (as far as I understand it) before each iteration, not throughout the processing. In other words setting theform equal to invalid will not stop processing immediately - it will finish out the rest of the code in the loop THEN stop. Jim Davis -Original Message-

RE: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Barney Boisvert
That's a really clever idea. I'm a FB guy so I never really been in that situation (and I usually prefer to generate all error message not just the first), but if that's what you're looking for, I'd say it's a perfect solution. Here's a different take on the same idea, except using the same

Re: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Scott Brady
- Original Message - From: Jim Davis [EMAIL PROTECTED] That's only checked (as far as I understand it) before each iteration, not throughout the processing. In other words setting theform equal to invalid will not stop processing immediately - it will finish out the rest of the code

Re: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Jochem van Dieten
Jim Davis wrote: Okay - so I'm working on a form and I need to validate fields for many things. Taking email address for example I need to validate that it's been filled in (not zero length), that it's less than 255 characters (the database limit), that it fits a email format and finally

RE: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Jim Davis
-Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 7:52 PM To: CF-Talk Subject: Re: Smart or Stupid (CFLOOP as a GOTO) Jim Davis wrote: Okay - so I'm working on a form and I need to validate fields for many things. Taking email

RE: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Jim Davis
I could - I was just hoping for a quick(er) fix. I guess I'm also being a little silly... thinking that CFTRY is only for pure errors, not validation rules... But I probably should use it... it does make perfect sense. Jim Davis -Original Message- From: Scott Brady [mailto:[EMAIL

Re: Image Editor

2003-06-27 Thread cf-talk
http://www.imagemagick.org -Novak - Original Message - From: Cedric Villat [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 26, 2003 9:41 PM Subject: Image Editor Anyone know of an image editor, like resizing gifs/jpgs, etc, that will work on a unix/linux server?

Re: Overriding Request Timeout in CFAdmin

2003-06-27 Thread cf-talk
Yes, but a better practice would be to use the cfsetting tag and set the timeout in the template itself. -Novak - Original Message - From: Stacy Young [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 27, 2003 5:37 AM Subject: Overriding Request Timeout in CFAdmin

RE: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Matt Blatchley ~ Bridgeleaf Studios
Why not just use JavaScript client side and then use CF server side? -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 8:03 PM To: CF-Talk Subject: RE: Smart or Stupid (CFLOOP as a GOTO) I could - I was just hoping for a quick(er) fix. I guess

RE: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Jim Davis
-Original Message- From: Matt Blatchley ~ Bridgeleaf Studios [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 9:51 PM To: CF-Talk Subject: RE: Smart or Stupid (CFLOOP as a GOTO) Why not just use JavaScript client side and then use CF server side? JavaScript will be added

RE: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Matt Blatchley ~ Bridgeleaf Studios
Ususally I stick to the if than else routine, but I think I'd try the different options mentioned here and see what works better. I'll bet it looks a hell of a lot cleaner :) -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 8:54 PM To: CF-Talk

Re: Overriding Request Timeout in CFAdmin

2003-06-27 Thread Dave Carabetta
Yes, but a better practice would be to use the cfsetting tag and set the timeout in the template itself. Actually, I don't think you can use the URL string, regardless. In MX, to use the requestTimeOut, you must specify it in the cfsetting tag. At least, that's been my experience using MX for

Re: Is there a way to test to see if a data source exists?

2003-06-27 Thread CF Dude
I'm not sure why it would be an obvious - are you talking about a specific database with known tables, or just an unknown datasource? Yes. I really can't imagine anybody building a web app that will give a user the option of connecting to some random unknown datasource. Know what I mean? I

Re: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread jonhall
Sure, but that's why you loop over the validation types as well. something like... valStruct.email = listToArray(null,maxlength,email); valStruct.email.value = [EMAIL PROTECTED]; valid = true; while(valid) { valid = true; for(i = 1; i LT arrayLen(valStruct.email), i = i + 1) {

RE: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Mike Kear
When you're done, can you let us know which site it is, so I'll put it on my list of sites never to go to? I HATE forms that tell me somethings wrong, I correct that, then it says something else is wrong. Then when I go back, usually my last input is removed from the form so I have to fill it

Problem setting dynamic links in variables

2003-06-27 Thread Terry Hogan
I'm trying to set a variable that will be passed to a form field something like: cfset hyperlink = a href=index.cfm?Fuseaction=Home.DisplayContentContentID= #ContentID# #LinkName# /a I've tried escaping the quotes in various ways double quotes, single quotes, etc. The real choker seems to

RE: Problem setting dynamic links in variables

2003-06-27 Thread Matt Blatchley ~ Bridgeleaf Studios
cfset hyperlink = a href ='index.cfm?Fuseaction=Home.DisplayContentContentID=#ContentID#'#LinkName# /a Is that what your looking for? -Original Message- From: Terry Hogan [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:01 PM To: CF-Talk Subject: Problem setting dynamic links

RE: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Jim Davis
-Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:42 PM To: CF-Talk Subject: RE: Smart or Stupid (CFLOOP as a GOTO) When you're done, can you let us know which site it is, so I'll put it on my list of sites never to go to? I HATE forms

RE: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Matt Blatchley ~ Bridgeleaf Studios
Jim, Are you Tired and Cranky in New England? -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:27 PM To: CF-Talk Subject: RE: Smart or Stupid (CFLOOP as a GOTO) -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent:

RE: Problem setting dynamic links in variables

2003-06-27 Thread Terry Hogan
Thanks for the suggestion, but it doesn't look like it will work. I think I need double quotes. The processing page searches through HTML code that has been generated in HTMLArea looking for an exact match and HTMLArea (actually I believe it's the rich text editing functions in IE) automatically

RE: Smart or Stupid (CFLOOP as a GOTO)

2003-06-27 Thread Jim Davis
Yup. -Original Message- From: Matt Blatchley ~ Bridgeleaf Studios [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 11:33 PM To: CF-Talk Subject: RE: Smart or Stupid (CFLOOP as a GOTO) Jim, Are you Tired and Cranky in New England? -Original Message- From:

RE: Is there a way to test to see if a data source exists?

2003-06-27 Thread Taco Fleur
I guess you would just make a call to the datasource within a cftry block and catch the error with cfcatch if it does not exist.. -Original Message- From: CF Dude [mailto:[EMAIL PROTECTED] Sent: Saturday, 28 June 2003 12:12 PM To: CF-Talk Subject: Re: Is there a way to test to see if a

<    1   2