Breaking up pages into several pages

2004-01-10 Thread Spectrum WebDesign
What's the secret to breaking up an article into several pages like http://www.onjava.com/pub/a/onjava/2003/06/18/dynamic_files.html Maybe user can insert any reserved word like newpage in the body of article. After send article CF regex can find that reserved word and store the precedent text

Re: Update Holiday Dates Aid.

2004-01-10 Thread Calvin Ward
The rules engine you mentioned is definitely a possibility. The x date of x month will account for some holidays: Christmas, New Years, etc. The n day of x week of x month will account for some more: Thanksgiving Going through and identifying the pattern may result in a table that will allow you

Re: cflocation and urlSessionFormat()

2004-01-10 Thread David Fafard
I use this often !-- default redirect -- cfoutput script language=_javascript_ location.href = ""> /script /cfoutput cfabort - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Friday, January 09, 2004 6:06 PM Subject: RE: cflocation and urlSessionFormat() Peter, Thanks

Recommendations for XML and Web Services training

2004-01-10 Thread Ralph Ogden
Anyone know of any good classroom training out there on Web Services and XML?Dont know where else to begin a search for this, and Google never points me to anything but LearningTree (about which past experiences leave me unenthusiastic...) Am in the Northern Virginia/D.C. area...

SOT: Padding zeros in SQL Server

2004-01-10 Thread Michael T. Tangorre
I am trying to determine the best way to store a zip code in a SQL Server 2K DB. Some zip codes begin with one or more zeros, so what is the best way to store them? In access I make the field of type Number and set the Format to 0. Is there something equivalent in SQL Server? Thanks, Mike

Re: Padding zeros in SQL Server

2004-01-10 Thread David Fafard
varchar... you can always cast in the future. I use varchar for both zip and phone numbers. dave - Original Message - From: Michael T. Tangorre To: CF-Talk Sent: Saturday, January 10, 2004 2:00 PM Subject: SOT: Padding zeros in SQL Server I am trying to determine the best way to

RE: Padding zeros in SQL Server

2004-01-10 Thread Michael T. Tangorre
Ok, thanks Dave. _ From: David Fafard [mailto:[EMAIL PROTECTED] Sent: Saturday, January 10, 2004 1:59 PM To: CF-Talk Subject: Re: Padding zeros in SQL Server varchar... you can always cast in the future. I use varchar for both zip and phone numbers. dave - Original Message -

RE: Padding zeros in SQL Server

2004-01-10 Thread Michael T. Tangorre
Dave, When I import the table form access I can not get the zeros to remain in tact in the zipcode field no matter if I use char or varchar. Do you know a solution I could look into? Thanks, Mike _ From: David Fafard [mailto:[EMAIL PROTECTED] Sent: Saturday, January 10, 2004 1:59

RE: Padding zeros in SQL Server

2004-01-10 Thread Philip Arnold
I am trying to determine the best way to store a zip code in a SQL Server 2K DB. Some zip codes begin with one or more zeros, so what is the best way to store them? In access I make the field of type Number and set the Format to 0. Is there something equivalent in SQL Server? What you

RE: Recommendations for XML and Web Services training

2004-01-10 Thread Dave Watts
Anyone know of any good classroom training out there on Web Services and XML?Dont know where else to begin a search for this, and Google never points me to anything but LearningTree (about which past experiences leave me unenthusiastic...) Am in the Northern Virginia/D.C. area... At Fig

RE: cflocation and urlSessionFormat()

2004-01-10 Thread Dave Watts
Remember that because CFLOCATION changes the headers cookies are not set on the page containing a CFLOCATION. Annoying but true. This is no longer true with CFMX. In fact, there's no reason why it couldn't have been that way in prior versions, as it's acceptable to put Location and Set-Cookie

RE: cflocation and urlSessionFormat()

2004-01-10 Thread Dave Watts
Has anyone ever run into problems when using the urlSessionFormat() function inside the url attribute of the cflocation tag? When I use the following code with cookies disabled on the browser I get two (J2EE sessions are enabled in cf administrator) jsessionid's in the URL and the whole

RE: Switch JVM Execution Policy on Runtime

2004-01-10 Thread Joe Eugene
Type runas at a command line for more information. Thanks Dave, i think this might work without executing a batch file. As soon as you enter the params, the next line asks for a password, any idea how to automate this? ie Press Enter and the execute a copy. Thanks, Joe Eugene -Original

Re: Padding zeros in SQL Server

2004-01-10 Thread David Fafard
Look into the DTS ( data transformation service ) of SQl Server. Try the import wizard ( found on the toolbar ) to import the data from access. I don't have SQL Server in front of me but I believe there should be an option to 'transform' on import. Dave - Original Message - From: Michael

RE: Padding zeros in SQL Server

2004-01-10 Thread Michael T. Tangorre
I'll look into it more. I did use DTS transformations when I imported which I do not know a whole lot about I'll keep looking into it. Thanks! Mike _ From: David Fafard [mailto:[EMAIL PROTECTED] Sent: Saturday, January 10, 2004 3:17 PM To: CF-Talk Subject: Re: Padding zeros in SQL

SOT: BD6.1b2 and mySQL

2004-01-10 Thread Cutter (CF-Talk)
So, I downloaded and installed the free version of BlueDragon 6.1 beta 2. This took care of issues I had with gettings the mySQL JConnect JDBC driver working. I can now make a connection with my mySQL server:) But...I took a low end CF5 App that I have had running on my CF 6.1 developer box

CFHeader/CFContent woes.

2004-01-10 Thread Shawn Grover
I know this is a relatively common question on the list, but the common answers/solutions just aren't working for me. I've built a testing page to isolate my problem with the following code: CFHEADER NAME=Content-Disposition VALUE=attachment; filename=fax_tenant.doc cfcontent

Re: CFHeader/CFContent woes.

2004-01-10 Thread Jochem van Dieten
Shawn Grover wrote: CFHEADER NAME=Content-Disposition VALUE=attachment; filename=fax_tenant.doc cfcontent type=application/msword file=c:\inetpub\wwwroot\app\fax_tenant.doc deletefile=No The problem is that no matter what I do to the cfheader line, I NEVER see fax_tenant.doc as the

RE: CFHeader/CFContent woes.

2004-01-10 Thread Shawn Grover
sorry, the page is on an internal development server. I just noted though the problem doesn't occur in Netscape 7.1, but does in IE 6.0.I've also found refernce to a windows bug, but not the details of the bug.I need this to work in IE 5.5 or better (client workstation configuration), but don't

RE: CFHeader/CFContent woes.

2004-01-10 Thread Bryan F. Hogan
I always use application/unknown. Here is the code that I use. cftry cfheader name=content-disposition value=attachment;filename=#qry_getDocument.documentLink# cfcontent type=application/unknown file=#expandPath('..')'\assets\uploads\'qry_getDocument.documentLink# deletefile=no cflocation

RE: BD6.1b2 and mySQL

2004-01-10 Thread Vince Bonfanti
If you'll send me the error pages produced by BlueDragon (again, privately, not to the list), I'm sure we can quickly figure out what's going wrong. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL

RE: CFHeader/CFContent woes.

2004-01-10 Thread Shawn Grover
The final code I have written is similar, but to isolate the problem, I have created a simplified page with just the CFHeader and CFContent lines.The problem is that the cfheader seems to be ignored by IE.The mime type appears to be working fine thus far. Shawn -Original Message- From:

Re: CFHeader/CFContent woes.

2004-01-10 Thread Jochem van Dieten
Shawn Grover wrote: sorry, the page is on an internal development server. Then just telnet to the webserver and see if the proper headers are returned. I just noted though the problem doesn't occur in Netscape 7.1, but does in IE 6.0.I've also found refernce to a windows bug, but not the

RE: Switch JVM Execution Policy on Runtime

2004-01-10 Thread Dave Watts
Thanks Dave, i think this might work without executing a batch file. As soon as you enter the params, the next line asks for a password, any idea how to automate this? ie Press Enter and the execute a copy. You know, I didn't even think of that when I suggested this. In the few cases where

Re:CFHeader/CFContent woes.

2004-01-10 Thread Kay Smoljak
Shawn Grover wrote: The problem is that no matter what I do to the cfheader line, I NEVER see fax_tenant.doc as the requested filename.I see the name of the .cfm file (which is word_test.cfm in this case).I wouldn't really care if the thing would at least display or save the word file. I had this

RE: CFHeader/CFContent woes.

2004-01-10 Thread Shawn Grover
sighs No luck on that. I've worked around the problem for now by opening a new window and directing it at the UNC path to the file in question.The application is intended for an Intranet, so this should be a resonable solution. Thanks anyways. Shawn -Original Message- From: Kay