Excel
HI I need help. I have a field which is a text field in access even though
it hold numbers. However, I have a cfcontent tag and when I open the excel
file, it takes away all zeros from the front. How can I keep all the digits
there and let excel know that it is text. Also, the only way I've 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: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">
#Form.txtSql#
#preserveSingleQuotes(Form.txtDate)#
ORDER BY Niin
#strGood# #Activity# #DateFormat('#MaxOfmyDate#','mm/dd/yyy')#
#strComment##EquipmentValue##DeficitQuantity#
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 10:59 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject:RE: CFCONTENT in CF4 and CF4.5
> 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 cell.
The CFCONTENT tag doesn't have anything to do with this (and hasn't changed
between 4.0.x and 4.5.x). When used with dynamic content generation, as
opposed to returning an existing file from the filesystem, all CFCONTENT
does is creates an HTTP header which describes the MIME type of the content.
My guess is that you've got a carriage return missing on the page that's
causing the problem. When generating CSV, for example, this:
#field1#,#field2#,#field3#
will generate one line, while this:
#field1#,#field2#,#field3#
(note the closing CFOUTPUT on a second line)
will generate the multiple lines you want.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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">
#Form.txtSql#
#preserveSingleQuotes(Form.txtDate)#
ORDER BY Niin
#strGood# #Activity# #DateFormat('#MaxOfmyDate#','mm/dd/yyy')#
#strComment##EquipmentValue##DeficitQuantity#
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 10:59 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject:RE: CFCONTENT in CF4 and CF4.5
> 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 cell.
The CFCONTENT tag doesn't have anything to do with this (and hasn't changed
between 4.0.x and 4.5.x). When used with dynamic content generation, as
opposed to returning an existing file from the filesystem, all CFCONTENT
does is creates an HTTP header which describes the MIME type of the content.
My guess is that you've got a carriage return missing on the page that's
causing the problem. When generating CSV, for example, this:
#field1#,#field2#,#field3#
will generate one line, while this:
#field1#,#field2#,#field3#
(note the closing CFOUTPUT on a second line)
will generate the multiple lines you want.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 cell. Thanks, Miriam ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 appreciate it. Thanks, Miriam ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: how to tell if radio button is checked
-Original Message-
Try
if (form.degreed_fl.value.checked)
will return true if radio button is checked.
From: Kim Ahlbrandt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 07, 2000 4:42 PM
To: [EMAIL PROTECTED]
Subject: how to tell if radio button is checked
I have a set of radio buttons in a CFFORM where the user can choose Yes or
No. I need to make sure they fill in another field if they have chosen the
"yes" radio button. I'm not sure if I'm going about checking to see if it
is checked "yes" the right way. I have "If (form.radiobutton.value == "Y")
Is there some other way like form.radiobutton.value.checked or something
like that? Here is my javascript below...the radiobutton in question is
named "degreed_fl".
Thanks, KIm
function auditBSBA(form) {
var submitForm=true //-- Changes to false when bad field found.
if (form.degreed_fl.value == "Y") {
if (form.schl_grad.value == "") {
window.alert("Please provide the name, city and state of the school
where you received your BS or BA degree");
submitForm=false;
form.schl_grad.focus();
}
}
if (submitForm==true) {
//-- The statement below submits the form, if all OK.
document.BSBAQuestions.submit()
}
}
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Thanks Bud!!!....It takes CF 1 minute to close DSN
You got it Bud!! I was using the same application name in both applications. I copied the code from one to the other, although I changed the DSN I forgot to change the application name. So as soon as I changed that, it worked without the hard code. One more question: Where do you put the tags you wrote above? If you put them in the application.cfm page, do you then refer to the DSn as datasource="attributes.dsn1"or "attributes.dsn2"? Thanks for your patience and time!! -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 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 I upload the changes, I wanted >to know if it makes sense that that is what's causing the error. If you have 4 datasources, you would want 4 names. application.settings.dsn1 application.settings.dsn2 application.settings.dsn3 application.settings.dsn4 I personally don't understand why you would want, or need, to set the datasource names with application variables anyway. Does it for me. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: It takes CF 1 minute to close DSN
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 I upload the changes, I wanted to know if it makes sense that that is what's causing the error. Thanks a lot, Miriam -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 4:42 PM To: [EMAIL PROTECTED] Subject: Re: It takes CF 1 minute to close DSN Out of curiousity, what happened when you tested it by hard-coding the DSN names rather than using 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 incorrect? > > -Original Message- > From: Dave Wilson [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 05, 2000 3:40 PM > To: [EMAIL PROTECTED] > Subject: Re: It takes CF 1 minute to close DSN > > > Miriam, > > Have you ensured that "maintain database connections" options is UNchecked > in your odbc settings for both datasources on the server? > > Dave Wilson > Internet Technology Manager, > BizNet Solutions > > > Co-Founder CFUG Ireland > http://www.cfug.ie > > 224, Lisburn Road > Belfast 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 minute to close DSN > > > > I thought that the application.cfm page is called before each page in that > > directory. So why doesn't the variable get updated before the page loads. > > Also, I've used this code before in other applications without a problem. > > I'm not sure I understand why this method is giving me an error now. In a > > CF article I read, it said that it is better not to hard code the DSN > name, > > because it makes your code hard to maintain. Please explain. > > > > Thanks so much for your time. > > > > -Original Message- > > From: Bud [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, September 05, 2000 12:01 PM > > To: [EMAIL PROTECTED] > > Subject: RE: It takes CF 1 minute to close DSN > > > > > > On 9/5/00, Miriam Hirschman penned: > > > > >dbtype="ODBC"> > > > > Where are you setting application.settings.dsn? What are you using > > for the datasource name on the second page? If you are using > > application.settings.dsn as the datasource name for both queries, and > > if that is supposed to change dynamically, depending on which page > > you are accessing (which by the way, would probably be a bad use of > > application variables) and it's not changing until AFTER you access > > the second query, then that would explain why it doesn't access the > > correct datasource until you click the 2nd time, AFTER the > > application variable is updated. > > > > Try entering the datasource names manually in both queries and see > > what happens. > > -- > > > > Bud Schneehagen - Tropical Web Creations > > > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > > ColdFusion Solutions / eCommerce Development > > [EMAIL PROTECTED] > > http://www.twcreations.com/ > > 954.721.3452 > > -- > -- > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > > the body. > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > > > -- -- > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with
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 incorrect? -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 3:40 PM To: [EMAIL PROTECTED] Subject: Re: It takes CF 1 minute to close DSN Miriam, Have you ensured that "maintain database connections" options is UNchecked in your odbc settings for both datasources on the server? Dave Wilson Internet Technology Manager, BizNet Solutions Co-Founder CFUG Ireland http://www.cfug.ie 224, Lisburn Road Belfast 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 minute to close DSN > I thought that the application.cfm page is called before each page in that > directory. So why doesn't the variable get updated before the page loads. > Also, I've used this code before in other applications without a problem. > I'm not sure I understand why this method is giving me an error now. In a > CF article I read, it said that it is better not to hard code the DSN name, > because it makes your code hard to maintain. Please explain. > > Thanks so much for your time. > > -Original Message- > From: Bud [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 05, 2000 12:01 PM > To: [EMAIL PROTECTED] > Subject: RE: It takes CF 1 minute to close DSN > > > On 9/5/00, Miriam Hirschman penned: > > >dbtype="ODBC"> > > Where are you setting application.settings.dsn? What are you using > for the datasource name on the second page? If you are using > application.settings.dsn as the datasource name for both queries, and > if that is supposed to change dynamically, depending on which page > you are accessing (which by the way, would probably be a bad use of > application variables) and it's not changing until AFTER you access > the second query, then that would explain why it doesn't access the > correct datasource until you click the 2nd time, AFTER the > application variable is updated. > > Try entering the datasource names manually in both queries and see > what happens. > -- > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > -- -- > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: It takes CF 1 minute to close DSN
I thought that the application.cfm page is called before each page in that directory. So why doesn't the variable get updated before the page loads. Also, I've used this code before in other applications without a problem. I'm not sure I understand why this method is giving me an error now. In a CF article I read, it said that it is better not to hard code the DSN name, because it makes your code hard to maintain. Please explain. Thanks so much for your time. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 12:01 PM To: [EMAIL PROTECTED] Subject: RE: It takes CF 1 minute to close DSN On 9/5/00, Miriam Hirschman penned: >dbtype="ODBC"> Where are you setting application.settings.dsn? What are you using for the datasource name on the second page? If you are using application.settings.dsn as the datasource name for both queries, and if that is supposed to change dynamically, depending on which page you are accessing (which by the way, would probably be a bad use of application variables) and it's not changing until AFTER you access the second query, then that would explain why it doesn't access the correct datasource until you click the 2nd time, AFTER the application variable is updated. Try entering the datasource names manually in both queries and see what happens. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: It takes CF 1 minute to close DSN
Each page is part of an application. There are two application, which are it two separate folders. They each have their own application.cfm page which refers to their own DSN. -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 11:19 AM To: [EMAIL PROTECTED] Subject: RE: It takes CF 1 minute to close DSN This is a multi-part message in MIME format. --=_NextPart_000_0257_01C0174C.9993FDA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit RE: It takes CF 1 minute to close DSNWell, to my eye, it looks like you are using "#application.settings.dsn#" in both pages, so unless the tables in question are in the that datasource you are going to have some issues. Have you tried testing with hard coded datasource names instead of looking in the application 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 page links to.) CLPTS Select Niin, CurrentPri, PreviousPri, Nomenclature, PrContractNo, Poc, PartNo, Cage, Description, Rate, PicWebAddress, DetailLink From NewestMain Where niin='#url.niin#' Select Buyyear, Qty, EAD, EDD From Schedule Where Niin='#url.niin#' SELECT Seca, SumofQuantity From qryTotalSecas Where Niin='#url.niin#' Select myDate, Details From Notes Where Niin='#url.niin#' CLOSED LOOP PROCUREMENT TRACKING SYSTEM BACK DATA CURR PRI PREV PRI NOMENCLATURE NIIN #CurrentPri# #PreviousPri# #Nomenclature# #Niin# POINT OF CONTACT PART NUMBER CAGE PR/CONTRACT NUMBER #Poc# #PartNo# #Cage# #PrContractNo# http://140.229.102.109/cse/projects/#picwebaddress#' border='0'>"> PROGRAM DESCRIPTION http://140.229.102.109/cse/projects/#detaillink#index.html"> #Description# #picture# DELIVERY SCHEDULE RATE: #Rate# PER MONTH DELIVERY ALLOCATION BUY YEAR QUANTITY EAD
RE: It takes CF 1 minute to close DSN
QUANTITY
#seca##Symbol#
#NumberFormat("#SumOfQuantity#")#
TOTAL
#NumberFormat("#Count#")#
NOTES
DATE
DETAILS
#Dateformat("#myDate#","mm/dd/yy")#
#Details#
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 05, 2000 10:56 AM
To: [EMAIL PROTECTED]
Subject: Re: It takes CF 1 minute to close DSN
On 9/5/00, Miriam Hirschman penned:
>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 then CF
>seems to let go of DSN1 and I don't get an error. I am using CF 4.0. Any
>help would be appreciated.
Hi Miriam. I'll ask again. We can't possibly guess without seeing the
code on the pages in question and maybe the URL to the site.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
RE: It takes CF 1 minute to close DSN
OK, I'm not sure what code you want to see, but here is the code for the page that has a link to anothere page. If this is not what you wanted plese let me know. Thanks for your help. Common Support Eqiuipment SELECT Distinct Program FROM Equipment PROGRAM EQUIPMENT SELECT * FROM Equipment WHERE program='#qrygetprogram.program#' ORDER BY Nomenclature asc #qryGetProgram.Program# -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 routinely do what you describe without fail which leads me to think it must be something other than CF that is causing the problem. Or perhaps posting a bit of your code would help us to identify if there is a CF code problem. Ken - Original Message ----- From: Miriam Hirschman <[EMAIL PROTECTED]> To: CF Forum <[EMAIL PROTECTED]> Sent: Tuesday, September 05, 2000 8:44 AM Subject: 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 then CF seems to let go of DSN1 and I don't get an error. I am using CF 4.0. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 then CF seems to let go of DSN1 and I don't get an error. I am using CF 4.0. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, September 03, 2000 2:10 PM Subject: RE: CF Holding On To DSN > Hi. > > Thanks for responding. The tables that are referred to as well as the DSn > have to be right because no matter which one I try the first one always > works. It's just that when I link from one to the other or put the address > in manually-that's when I get the error. Also, it is not my own servwer. > Would that make a difference? > -Original Message- > From: Bud [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 03, 2000 12:54 PM > To: [EMAIL PROTECTED] > Subject: Re: CF Holding On To DSN > > > On 9/2/00, Miriam Hirschman penned: > >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 > should > >reconnect to the right DSN?? > > Never heard of such a problem. Have you double checked your query to > be sure you're not referring to the table in the query returning the > error? Is this server your own? Have you double checked to make sure > that the Datasource name didn't get pointed to the wrong database? > -- > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > -- -- > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Holding On To DSN
Hi. Thanks for responding. The tables that are referred to as well as the DSn have to be right because no matter which one I try the first one always works. It's just that when I link from one to the other or put the address in manually-that's when I get the error. Also, it is not my own servwer. Would that make a difference? -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 03, 2000 12:54 PM To: [EMAIL PROTECTED] Subject: Re: CF Holding On To DSN On 9/2/00, Miriam Hirschman penned: >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 should >reconnect to the right DSN?? Never heard of such a problem. Have you double checked your query to be sure you're not referring to the table in the query returning the error? Is this server your own? Have you double checked to make sure that the Datasource name didn't get pointed to the wrong database? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Holding On To DSN
That did not help, any other ideas? -Original Message- From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 02, 2000 11:56 PM To: [EMAIL PROTECTED] Subject: Re: CF Holding On To DSN put cflock tags around the query. you might even try cftransaction. Fred - 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 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 should reconnect to the right DSN?? Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 should reconnect to the right DSN?? Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 documents or what would cause CF not to find it in the first place? Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 this in CF. but you can have a CFML custom tag that you can use to order your results. After your , call out the below custom tag and whola! you're done. ;) roger lim - Original Message - From: "Miriam Hirschman" <[EMAIL PROTECTED]> To: "CF Forum" <[EMAIL PROTECTED]> Sent: Monday, August 21, 2000 10:44 AM Subject: 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 just cut the last character of a string if it ends withe a perios, but I was wondering if I am doain something wrong, or if there is a better way to go about doing this. My second question is, I return the appropriate resumes with a link to the word documents. In Netscape it saya that it is opening "Smith%2Edoc.doc. It is opemning the right file, but I was wondering why it saya doc.doc at the end?? Is this right? Thanks for your time Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Error Handling
Hi, TRhanks I did a find on the cfcatch.detail and I got what I wanted. Thanks a lot. -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:21 AM To: [EMAIL PROTECTED] Subject: Re: Error Handling Miriam, If you put only the CFSEARCH 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: > 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 > To: [EMAIL PROTECTED] > Subject: Re: Error Handling > > > Hello Miriam. While I'm not too familiar with the CFSearch tag, I > would > imagine that the CFTRY/CFCATCH could pick up any such error and then > you > have control over how you'd handle it. Look up the CFTRY/CFCATCH > statements, use those and tell me how it works out. > > Gregory Harris YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 To: [EMAIL PROTECTED] Subject: Re: Error Handling Hello Miriam. While I'm not too familiar with the CFSearch tag, I would imagine that the CFTRY/CFCATCH could pick up any such error and then you have control over how you'd handle it. Look up the CFTRY/CFCATCH statements, use those and tell me how it works out. Gregory Harris Los Angeles ITA Dept. [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 08/09 8:42 AM >>> 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 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Formatting Data
Thank pou very much for helping me. I think it was becasue of the loop, because I redid my code layout and now it is working ( so far ) -Original Message- From: Katrina Chapman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 2:15 PM To: [EMAIL PROTECTED] Subject: RE: 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 it is in a loop? -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 1:24 PM To: [EMAIL PROTECTED] Subject: RE: Formatting Data First things first. Don't select * Select program, nomenclature >From Equipment Where Nomenclature='#SearchResults.key#' ORDER BY Program Secondly change your output to #Program# #Nomenclature# This 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: Select * From Equipment Where Nomenclature='#SearchResults.key#' ORDER BY Program #qryDisplayResults.Program# #Nomenclature# -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:55 PM To: [EMAIL PROTECTED] Subject: RE: Formatting Data I'm not sure if this is what you're looking for, but try useing grouped outputs: SELECTFieldOne FieldTwo FROM Test #FieldOne# - #FieldTwo# - #FieldTwo# I apologize for the sloppyness of the example, but i hope you get the idea.. Mark -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:48 PM To: CF Forum Subject: 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 b c d b q c s w d r e t b I tried loop and anything I can think of so that I can dispaly may data like that,but I am at a loss. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --
RE: Formatting Data
Tha didn't change anything. Am I having a problem because it is in a loop? -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 1:24 PM To: [EMAIL PROTECTED] Subject: RE: Formatting Data First things first. Don't select * Select program, nomenclature >From Equipment Where Nomenclature='#SearchResults.key#' ORDER BY Program Secondly change your output to #Program# #Nomenclature# This 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: Select * From Equipment Where Nomenclature='#SearchResults.key#' ORDER BY Program #qryDisplayResults.Program# #Nomenclature# -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:55 PM To: [EMAIL PROTECTED] Subject: RE: Formatting Data I'm not sure if this is what you're looking for, but try useing grouped outputs: SELECTFieldOne FieldTwo FROM Test #FieldOne# - #FieldTwo# - #FieldTwo# I apologize for the sloppyness of the example, but i hope you get the idea.. Mark -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:48 PM To: CF Forum Subject: 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 b c d b q c s w d r e t b I tried loop and anything I can think of so that I can dispaly may data like that,but I am at a loss. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Formatting Data
HI, It didn't reaaly change the display Here is my code: Select * From Equipment Where Nomenclature='#SearchResults.key#' ORDER BY Program #qryDisplayResults.Program# #Nomenclature# -Original Message- From: Mark Armendariz [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:55 PM To: [EMAIL PROTECTED] Subject: RE: Formatting Data I'm not sure if this is what you're looking for, but try useing grouped outputs: SELECTFieldOne FieldTwo FROM Test #FieldOne# - #FieldTwo# - #FieldTwo# I apologize for the sloppyness of the example, but i hope you get the idea.. Mark -Original Message----- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:48 PM To: CF Forum Subject: 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 b c d b q c s w d r e t b I tried loop and anything I can think of so that I can dispaly may data like that,but I am at a loss. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 b c d b q c s w d r e t b I tried loop and anything I can think of so that I can dispaly may data like that,but I am at a loss. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: 5 Blank Lines in Excel
Hi Kevin,
Thanks for your time. This is my code.
#Form.txtSql#
#preserveSingleQuotes(Form.txtDate)#
ORDER BY Niin
#strGood# #Activity# #DateFormat('#MaxOfmyDate#','mm/dd/yyy')#
#strComment#
#EquipmentValue##DeficitQuantity#
If I put the end tag any earlier, then I get five lines in
between every row in Excel.
Thanks,
Miriam Hirschman
-Original Message-
From: Kevin Plexico [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 2:28 PM
To: [EMAIL PROTECTED]
Subject: RE: 5 Blank Lines in Excel
You probably have the same issue on the page your pulling up (ie the actual
CFM page your executing that has the CFCONTENT tag on it. You should hide
the output above your CFCONTENT tag with the same CFSETTING. Just make sure
you turn it off (set it to no) before the CFCONTENT tag.
-Original Message-
From: Miriam Hirschman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 10:23 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: 5 Blank Lines in Excel
Thanks, that eliminated about 2 lines, any other ideas??
Miriam
-Original Message-
From: Kevin Plexico [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 18, 2000 9:23 AM
To: [EMAIL PROTECTED]
Subject: RE: 5 Blank Lines in Excel
Your probably getting the blank lines from a application.cfm file that is
executing. You need to wrap your application.cfm code in a
(providing you don't have any display
code in the application.cfm).
Kevin
-Original Message-----
From: Miriam Hirschman [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 11:33 AM
To: CF Forum
Subject: 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
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: 5 Blank Lines in Excel
Thanks, that eliminated about 2 lines, any other ideas?? Miriam -Original Message- From: Kevin Plexico [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 18, 2000 9:23 AM To: [EMAIL PROTECTED] Subject: RE: 5 Blank Lines in Excel Your probably getting the blank lines from a application.cfm file that is executing. You need to wrap your application.cfm code in a (providing you don't have any display code in the application.cfm). Kevin -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, July 17, 2000 11:33 AM To: CF Forum Subject: 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 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 file and that did not format my data well. It's splits my memo field at every few words. I wold like to keep the cffile code because it is working well. Any help would be appreciated. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Export to Access
Hi, Thanks for helping me out. I hop you don't mind that I am emailing you directly. I have 3 questions. Firstly, the file in excel leaves a blank line between each record. Also before the first field there is a square character. My last question is that one of the fields that I am 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: Eron Cohen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 4:41 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Export to Access Miriam, Excel/Lotus 123 is easy. Here's a very simple solution that works great for creating CSV files and opening them up into Excel or Lotus (or whatever is handling comma seperated files on the client machine). The gist of this is that CFCONTENT will cause the browser to put up an "Open File or Save" dialog box. If they push OPEN, Excel will open up and display the info that CF outputs: Select * from something Report For Someone: "#first_name#","#last_name#","#COMPANY_name#","#state#","#country# ","#company_address1#","#company_city#","#state#","#company_postal_code#","# contact_phone_number#","#contact_email_address#" There are also custom tags that you can get in Allaire's tag gallery that are more specifically tied to Excel, but excel would need to be installed on the server. HTH, Eron -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 1:10 PM To: CF Forum Subject: 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/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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
box has the same name for all the records. If I click the edit button for
that record will java script be able to give me the value??
Here is what I mean:
if ((document.frmEditSchedule.Qty.value.length <=
0)||(document.frmEditSchedule.Qty.value == 0))
{
alert("'Quantity' is a required field, and must be a number greater
than
0.");
}
Does it know which Qty text box I am referring to???
Thanks,
---miriam
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 is happening and if this could happen on the web with two simultaneous users? Thanks, ---miriam Thanks, ---miriam -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 happening and if this could happen on the web with two simultaneous users? Thanks, ---miriam -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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. do this Thanks, ---miriam -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
When are Form Variables created
HI, Are Form variables created, by calling the submit method using JavaScript,like in the code below?? Submit Thanks, ---miriam -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Printer Friendly Forum
I am not sure I understand what your saying. Do I pass it as url variables, since there is no Submit button on the pages. Also, is what your sayong quicker than rerunning the queries? Thanks -Original Message- From: Childress, Emily [mailto:[EMAIL PROTECTED]] Sent: Monday, April 17, 2000 10:40 AM To: '[EMAIL PROTECTED]' Subject: RE: Printer Friendly Forum Why not pass the contents of the frames to another page, as parameters, then build a dynamic table on that page filling it with the passed content? You can use one of those nifty "Printer-friendly" version links. just my .02, -e -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, April 17, 2000 10:43 AM To: CF Forum Subject: 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. I tried the cf print tag and in Netscape it doesn't help and in IE , the user has to click 'Cancel' twice on the print dialog box to close it,if they decide not to print. I would like to copy the contents of the whole document to a new page and create a link to that page, is this possible?? Thanks, ---miriam -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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. I tried the cf print tag and in Netscape it doesn't help and in IE , the user has to click 'Cancel' twice on the print dialog box to close it,if they decide not to print. I would like to copy the contents of the whole document to a new page and create a link to that page, is this possible?? Thanks, ---miriam Thanks, ---miriam -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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. I tried the cf print tag and in Netscape it doesn't help and in IE , the user has to click 'Cancel' twice on the print dialog box to close it,if they decide not to print. I would like to copy the contents of the whole document to a new page and create a link to that page, is this possible?? Thanks, ---miriam -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 wildcard (the SELECT statement) When we query with a star (*) in the SELECT statement, does MS-Access return all the fields, even if they are empty? I have over 50 fields in a perticuar table, but some pages only use 3 or 4 of them. The rest are empty. For performances sake, am I better off using: SELECT a1,a2,a3 FROM test instead of: SELECT * FROM test Will it make a difference in speed? (It would be alot simpler to use the * -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Date/Time woes....
I just encountered this type of problem, I'm not sure if you have the same
one as I did, bit I had Access storing my dates with the time, so when I
compared the date alone to the dates in the table it didn't return anything
I had to do a CREAte odbcdatetime and concatenate the time to the date
variable.
-Original Message-
From: Christopher Mick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 12, 2000 12:55 PM
To: [EMAIL PROTECTED]
Subject: Date/Time woes
Hi all,
I'm using CF 4.5 and Access2000. When I submit this SQL query it doesnt
seem to want to isolate the dates correctly:
***
Select *
>From tbl_OCRlot
Where hnum = 1 OR hnum = 2 OR hnum = 8
AND DateTime >= {d '2000-04-12'}
AND DateTime <= {d '2000-04-13'}
***
Is there any reason why this shouldn't work? Here's the date part of the
query in CF:
***
AND DateTime >= #createODBCdate(now())#
AND DateTime <= #createODBCdate(createODBCdate(now()) +
CreateTimeSpan(1,0,0,0))#
***
Is this createODBCdate() function useable with Access? I tried to achieve
the desired results in Access and was only able to separate dates out when I
used this format:
***
WHERE ((([tbl_OCRlot]![DateTime])>=#4/4/2000# And
([tbl_OCRlot]![DateTime])<=#4/5/2000#))
***
Here's a post I read which somewhat covers this:
***
>> I never had much luck with #CreateODBCDate(***)#
>> because it appends
>> these brackets { t ' '} and MsSQL7 and Access
>> freak out!! So I just did something like the above for a
>> quick workaround and never got around asking how you correctly
>> use the ODBCDate functions. I guess now is as good a time as
>> ever, anyone
>ODBC date and time formats use the curly brackets you mention above. To
>reference values in ODBC date/time format in your CFQUERY tags, just leave
>off the single quotes that you'd use for strings.
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
***
I am not sure I understand what Dave is talking about,...can anyone
elaborate?
TIA,
Chris
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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;
}
else
{
return true;
}
}
I called this function in the form tag:
hth
miriam
-Original Message-
From: Sumeet Khanna [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 2:34 PM
To: '[EMAIL PROTECTED]'
Subject: How to do
Can anyone please tell me how to do radio
button validation ,if I want to use
the check "if radio button "Other" is clicked then only
enter Other option text in text box"
Sumee
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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). I appreciate your help. Thanks, ---miriam -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
