Excel

found to separate my fields is by putting a tab and another character afterward. If I put a plain tab excel joins the fields. Please help. Thanks -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 11:09 AM To: CF-Talk Subject

CFCONTENT in CF4 and CF4.5

Hi, Can someone please tell me the change in the way the CFCONTENT tag works in CF4 and CF 4.5. Meaning, in CF 4.0 the excel file that I am creating looks fine. The each field is in a separate cell. However, when running off a 4.5 server all the fields are attached and are displayed in one

RE: CFCONTENT in CF4 and CF4.5

Why does it look fine on my hard drive?? And not when it is running off the CF 4.5 Server. Thnaks for your help. Here is my code: CFSETTING enablecfoutputonly="Yes" htmlbody bgcolor="White" cfquery name="qryGetSummary" datasource="csesdr" dbtype="ODBC" #Form.txtSql#

cfcontent

Please help. I am trying to test out a cfcontent tag. I want to create an Excel file. When I test it on my hard drive everything looks good, however, when I try it on the web, all the fields are one continuous cell in Excel. The DB and files are the same. Any leads. I woulsd really

It takes CF 1 minute to close DSN

I posted this question over the weekend, but I don't have a solution so I am posting it again. I have a page that connects to one DSN1 and it has a link that calls a page which connects to another DSN2. Now I get an error. CF is looking in DSN1 for a table that is in DSN2. If I wait a minute

RE: It takes CF 1 minute to close DSN

/td /cfloop /tr /table /body /html -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 10:15 AM To: [EMAIL PROTECTED] Subject: Re: It takes CF 1 minute to close DSN Have you spoken to the Admin of the server about this yet? I rou

RE: It takes CF 1 minute to close DSN

/td td width="37%" align="center" valign="middle" smallfont face="Verdana"nbsp;#NumberFormat("#SumOfQuantity#")#

RE: It takes CF 1 minute to close DSN

ication scope to see if there is a difference in behavior? DC -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 15:13 To: [EMAIL PROTECTED] Subject: RE: It takes CF 1 minute to close DSN This is the other page (the one that the first pag

RE: It takes CF 1 minute to close DSN

] Subject: RE: It takes CF 1 minute to close DSN On 9/5/00, Miriam Hirschman penned: cfquery name="qryGetProgram" datasource="#Application.settings.dsn#" dbtype="ODBC" Where are you setting application.settings.dsn? What are you using for the datasource name on the

RE: It takes CF 1 minute to close DSN

elfast BT9 6GE Tel: 02890 225 776 Fax: 02890 223 223 web: http://www.biznet-solutions.com email: [EMAIL PROTECTED] - Original Message ----- From: "Miriam Hirschman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 05, 2000 5:12 PM Subject: RE: It takes CF 1 minu

RE: It takes CF 1 minute to close DSN

application.settings.dsn? Ken - Original Message - From: Miriam Hirschman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 05, 2000 3:51 PM Subject: RE: It takes CF 1 minute to close DSN Yes, But that didn't change anything. Is my assumption of how the application.cfm page should work

RE: Thanks Bud!!!....It takes CF 1 minute to close DSN

ber 05, 2000 6:39 PM To: [EMAIL PROTECTED] Subject: RE: It takes CF 1 minute to close DSN On 9/5/00, Miriam Hirschman penned: It worked on my computer, I didn't test it on the real server yet but I think it would work there too. Is my method of using #application.settings.dsn# incorrect? Before

RE: CF Holding On To DSN

- Original Message - From: "Miriam Hirschman" [EMAIL PROTECTED] To: "CF Forum" [EMAIL PROTECTED] Sent: Saturday, September 02, 2000 11:55 PM Subject: CF Holding On To DSN I have a page that links to one DSN, but as soon as a user requests a page which connects to another DSN

RE: CF Holding On To DSN

It's a gov. server. -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 2:46 PM To: [EMAIL PROTECTED] Subject: Re: CF Holding On To DSN What host are you using? Ken - Original Message - From: Miriam Hirschman [EMAIL PROTECTED

CF Holding On To DSN

I have a page that links to one DSN, but as soon as a user requests a page which connects to another DSN I get an error. CF is looking for the table in the old DSN . It seems as if CF is holding on to the old DSN connection. What can I do to make sure that when a new page is called up, that CF

RE: alphabetical Order

Hi Roger, Thanks so much!!! I did not believe that it would be so easy!! Miriam Hirschman -Original Message- From: Roger Lim [mailto:[EMAIL PROTECTED]] Sent: Monday, August 21, 2000 12:01 AM To: [EMAIL PROTECTED] Subject: Re: alphabetical Order There is no built-in function to handle

searching through word documents

I'm having trouble finding a search string in one of the word documents in my collection. I tried to play around with the document and put the exact searchstring in the document, however CF is not finding it even though it IS there. Is there any reason why it wouldn't be reading changes to

cfsearch

I have two questions. I have a folder with resumes in word format. I want people to be able to put in an education level, for example B.A. and get all the resumes that apply. However, if they put in B.A. I get nothing, but if I put in B.A, then I get the right entries. What I did for know is

alphabetical Order

I am searching through a bunch of word documents using cfsearch. I then loop through them and output the fields. How do I get CF to put them in alphabetical order?? Thanks,   ---miriam -- Archives:

Refining Search

Can someone point me in the right direction. I have done verity searched before, but now is there a standard way to let the user refine his or her search results. Thanks,   ---miriam -- Archives:

RE: Error Handling

I looked a bit into that , but I waant a message only for that error, and it doesn't seem like I can tell CFTRY to only catch the cfsearch error. Please tell me if I am wrong. -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 12:59 PM

CFTHROW

How Do I define my own error in a cfthrow? I would like to say if the error is an invalid search criteria then Thanks,   ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To

RE: Error Handling

code in the CFTRY block, only errors from that code will activate the error handler. If you need even finer resolution than that, you could check the actual error message (CFCATCH.Details, I think). -David On Fri, 11 Aug 2000 09:20:59 -0400 "Miriam Hirschman" [EMAIL PROTECTED] writes:

Error Handling

I am using CFSearch. If the user enters "and","or", "'" then I get a CF error. I would like to catch only this error and display a message to the user telling them that they entered invalid search criteria. Thanks,   ---miriam

Formatting Data

I have a collection to pull up records based on a text string that a user types in. My queries based on my collection return the correct data. However, the data is like this a b a c a d b q c s c w d r e t e b I want it to be like this a

RE: Formatting Data

application.test#" SELECTFieldOne FieldTwo FROM Test /CFQuery CFOutput query="test" group="FieldOne" #FieldOne# - #FieldTwo# CFoutput - #FieldTwo# /CFOutput /CFOutput I apologize for the sloppyness of the example, but i hope you get the id

RE: Formatting Data

should fix it. --K -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 10:15 AM To: [EMAIL PROTECTED] Subject: RE: Formatting Data HI, It didn't reaaly change the display Here is my code: cfloop query="SearchResults"

RE: Formatting Data

: Formatting Data You might be. Can we see the template in action? --K -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 10:45 AM To: [EMAIL PROTECTED] Subject: RE: Formatting Data Tha didn't change anything. Am I having a problem because

Previous Record

Is there a way that I can hold the previous record when looping through a query so that I can compare it to the current record?? Thanks,   ---miriam -- Archives:

RE: 5 Blank Lines in Excel

Good=#ReReplace("#niin#","[[:cntrl:]]"," ","ALL")# cfoutput #strGood# #Activity# #DateFormat('#MaxOfmyDate#','mm/dd/yyy')# #strComment# #EquipmentValue##DeficitQuantity#/cfoutput /cfloop/body/html CFSETTING enablecfoutputonly="no"

5 Blank Lines in Excel

Thanks, everyone, with your questions and answers I got my cfcontent to open a page in excel. However, I tried everything to get the five blank lines on the top of the page to disappear. Can anyone tell me what is causing them or better yet how to get rid of them. Thanks,   ---miriam

RE: Export to Access

exporting to access is like a memo field and whenever I export it (using the code you gave me or someone elses) it splits the memo field into a few records. I see that this does happen by a period, although not all the time. Thanks a lot for your help, Miriam Hirschman -Original Message- From

cfcontent

Hi, I posted a question before about exporting to access. I am using cffile to create a test file, and it is saved as an excel file. However, I want to know if there is a way that I can open that file. I tried to do the whole thing using cfcontent, but the code that I had was creating a csv

Export to Access

A client of mine wants to know if there is a way that I can export a CF page to access or excel?? I would appreciate any info Thanks,   ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/

PLease Help

I want to give some admin users the ability to edit records. I get all the results of the query and display them in rows of text boxes. At the end of each row is a delete link. I want to validate using JavaScript. My question is, Does Js knoe which text box i am referring to, because the text

Update Query

How can I specify which row in my table I want to update if the user has the ability to change every field. Is there any way besides making an autoNumber field? I have an Access DB. Thanks,   ---miriam -- Archives:

Repost question on Collection. Please answer

I created a collection to index and search. I had both Netscape and IE opened at the same time to test them, however when I put in the same search criteria, the browser that hit the code second returned an error saying that it couldn't open the collection. Can someone please tell me why this

Collection Failing to Open

I created a collection to index and search. I had both Netscape and IE opened at the same time to test them, however when I put in the same search criteria, the browser that hit the code second returned an error saying that it couldn't open the collection. Can someone please tell me why this is

Sum

Is there a way in CF that you can add the summ of all the results in a certain query? Thanks,   ---miriam -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit

cfmail

If I do a cfmail to a string that can be blank, will that cause an error?? I did try it and it was fine, but I just want to make sure I didn't miss anything. Thanks,   ---miriam -- Archives:

cfloop-Please answer

If I am looping through a query and the query did not have any results, dose CF skip the whole code, or does it go inside and hold a "". For example: If qryResults has 0 records. cfloop query="qryResults" cfif Field1 is not Email do this cfelse

Printer Friendly Forum

HI, I have a page with about 6 frames. I want the user to be able to have the option of printing the whole document without having to go to File-Print- and then choosing the option to print"As seen on screen" (that's in IE). In Netscape. as far as I know you can only print the selected frame.

Printing Multple Frames

HI, I have a page with about 6 frames. I want the user to be able to have the option of printing the whole document without having to go to File-Print- and then choosing the option to print"As seen on screen" (that's in IE). In Netscape. as far as I know you can only print the selected frame.

Changing Field Name in an Access DB

Is there a way to change the properties of a field in a table or add a field to a table through CF? Thanks,   ---miriam -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit

RE: To wildcard or not to wildcard (the SELECT statement)

I asked a similar question before and I was told that it is quicker to write out all the field names instead of using the *. -Original Message- From: Michel Gagnon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 12, 2000 12:33 PM To: [EMAIL PROTECTED] Subject: To wildcard or not to

RE: How to do

I did this with java script: function chkData() { if((document.frmname.radiobuttonname.checked)(document.frmName.RadioButtonName.value.length = 0)) { alert("If you checked 'Other' for question 8, please describe."); return false; }

Survey Again

I am creating hidden form fields for all the questions. But what should I do with the questions that the user does not have to complete(specifically a check box, or an option button)if they leave it blank, it does not get passed and I can't update the database. Thanks,   ---miriam

Surveys

I am creating a survey with about 30 questions. I have about 3 pages with 10 questins on each page. I want to save all the answers so by the last page (when I collected allthe answers)I can update the database. What is the best way to save the form variables (application, session variables).