Hey... I have a need to dynamically (using a button/link) add additional
fields to a form.Does anybody have/know of a solution for this? (purchased
or otherwise)
--
Jillian
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
I'm hoping somebody out there can help.I need to display these results in
two columns (currently just displaying in one).
cfquery name=search datasource=#DSN# username=#db_username#
password=#db_password#
SELECT *
FROM users
WHERE dealership = #form.dealership#
ORDER BY
department
/cfquery
towards
maintaining 'proper' HTML) :)
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 04, 2004 9:35 AM
To: CF-Talk
Subject: Displaying Results in Columns
I'm hoping somebody out there can help.I need to display these results
in two columns (currently
I've been playing with this for a while.I don't want zero's to be visible
in these form fields, I just want them to be blank until/unless a value is
entered. The problem is that I get an error when the calculation is done
(for amtInsurance) on the fields that are 'blank'.
cfparam
I'm sorry to be posting OT... but I've got a _javascript_ problem that's
plaguing me.
I have a CF page that spawns this 'people picker'.The problem is, when I
choose a person from the list it generates (see the cfoutput from the
'search' query) I get the _javascript_ error: 'Error:
Brain fart moment... how can I most easily/reliably trim the prefix from an
e-mail address:
[EMAIL PROTECTED]
I want everything before the @... so: 'test'.
--
Jillian
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I am looking for a host who can meet my requirements:
- Windows platform
- Apache (need to use mod_rewrite)
- MySQL
- Redundant Backbone
- 20GB Monthly Transfer
- 1-6GB of space
- Mailing List with Archival Support
- Subdomains, some with additional sites
- SSL Support
- Nightly back-up
Not
I've got a form that is made up of a dynamic list of form fields.How do I
write the SQL query so that it will loop over all of the fields to do the
insert?
My form:
cfquery name=golfers datasource=#DSN# username=#db_username#
password=#db_password#
SELECT*
FROMgolfers
ORDER BY
golfer_name
: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 8:38 AM
To: CF-Talk
Subject: Insert dynamic form fields into a database
I've got a form that is made up of a dynamic list of form fields.How do I
write the SQL query so that it will loop over all of the fields to do the
insert
Hey!
I've got a project where I've got 5 groups of golfers... and I need folks to
be able to choose up to 2 golfers per group... no more, no less.
Anybody have any advice on how best to do this?
This is what I have so far:
form name=team_info action="" method=post
!--- Select all
Hey folks... I'm really frozen on this one.
This is for a golf pool --the idea is:
01. User comes to the page, selects 2 golfers from each 'group'.
02. No more than 2 golfers can be selected from each group.
I can get the golfers to list from the database without any difficulty...
the
I'm inserting records from a text file using the code below.
I think that the problem lies in this code:
cfset DataFile = Replace(DataFile, '#chr(9)##chr(9)#','#chr(9)#
#chr(9)#','all')
cfset DataFile = Replace(DataFile, '#chr(9)##chr(9)#','#chr(9)#
#chr(9)#','all')
When I do the insert, I get
Good morning,
I am having a heck of a time with this little import script.When it runs,
all I receive are the messages that 'An error occurred while updating the
database.' (as I indicated it should do if the query fails)
Can anybody point me in the right direction?
Thanks!!
--
Jillian
***
of
(#ListGetAt(l, 2)#), occupying document position (56:7) to (56:23).
*** *** ***
Where should I go from here? Should I be taking a different approach?
--
Jillian
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: February 12, 2004 10:57 AM
To: CF-Talk
Subject: Importing CSV
A few good links to start with:
http://www.css-discuss.org/
http://css-discuss.incutio.com/
http://www.glish.com/css/
And of course, the W3C validator: http://jigsaw.w3.org/css-validator/
--
Jillian
-Original Message-
From: John Munyan [mailto:[EMAIL PROTECTED]
Sent: November
I am Canadian.
-Original Message-
From: Chunshen Li (Don) [mailto:[EMAIL PROTECTED]
Sent: November 20, 2003 12:19 PM
To: CF-Talk
Subject: Any Canadians here?
Up front, my apology for off topic (this post is not of technical nature),
probably it would be the last one of such a nature to
As long as your message isn't multipart, you can leave it out.
--
Jillian
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: November 14, 2003 6:54 AM
To: CF-Talk
Subject: When sending a message through CFMail
Is the cfmailpart tag required if I know I'm only going
Chad,
Here is an example:
cfquery name=data_export datasource=#DSN#
SELECT person.*,
organization.name AS org_name
FROM person
JOIN organization ON organization.organization_id = person.organization_id
/cfquery
html
cfcontent type=application/vnd.ms-excel
head
titleIntranet Test Page/title
Do you mean delete it from the database, or exclude it from the results?
If you just want to exclude it, you could use a WHERE to eliminate it from
your new results.
-Original Message-
From: Sparrow-Hood, Walter [mailto:[EMAIL PROTECTED]
Sent: November 12, 2003 3:03 PM
To: CF-Talk
If you turn off 'Maintain DB Connections' in the CF Admin Panel, you won't
have the lock file problem, or you can run a bogus query on the database
right before you copy the database... should unlock it.
That would apply to moving the file... just running a backup on it shouldn't
be a problem.
I've -nearly- got this one... but I've got one little glitch.
I've got a file of comma delimited fields, and I need to put them in a
database.What I've got so far is nearly working... but it appears that
some fields are being skipped over (because they are blank).I've tried to
make all blank (,,)
Hey folks.I am having a problem with a _javascript_ that creates one of
those 'tile' games, where there is a 3x3 grid with pieces of a picture that
is scrambled... and one piece is missing, so you click click click to move
the tiles around until the picture is no longer scrambled.
This was
I have been very pleased with Mastering ColdFusion MX' by 'Danesh, Camden,
Bainum and Rish' published by Sybex.
It's a mighty heavy book to lug around... but for a 'keep it nearby complete
reference', it can't be beat.
The examples are clear and simple... and the book is very well edited.
--
I'm looking for an hour or two of consulting from an Authorware expert
--somebody who can take a quick look at my client's module and give me a
point in the right direction / answer a few questions.
If any of you could give me a hand, please e-mail me off-list.
Thank you!
--
Jillian
I'm working on a migration plan for a Linux server I manage... and while it
is logical for us to move to RedHat 9 at this time, we are also looking at
BlueDragon --and it does not appear that it supports this version of Linux.
Has anybody installed it successfully on this OS? What about later
Jeff,
This article should help you, it was recently featured in the ColdFusion
Developers Journal: http://www.sys-con.com/coldfusion/article.cfm?id=635
It deals with Parsing RSS Feeds Using ColdFusion, and it's very well
written.
--
Jillian
-Original Message-
From: Jeff
I'm starting to work on this web based .htaccess creation, and the most
basic place to begin seems to be with creation.
When I do this:
cfexecute
name=c:\Program Files\Apache Group\Apache\bin\htpasswd.exe
arguments=-c -b c:\Program Files\Apache
the
executable what each of the arguments are. Otherwise, if you
pass an argument string to the arguments attribute, CF parses
the string to create an array for you.
Is this CFMX, CFMX 6.1, or CF5?
-Steven Erat
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED
: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: August 22, 2003 3:22 PM
To: CF-Talk
Subject: Re: cfexecute erroring
Jillian Carroll wrote:
cfexecute
name=c:\Program Files\Apache Group\Apache\bin\htpasswd.exe
arguments=-c -b c:\Program Files\Apache
Group\Apache
I've fixed my problem... but I'm not sure why I had to do this workaround.
I created a batch file, and I am using cfexecute to run the batch file.
--
Jillian
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: August 22, 2003 4:42 PM
To: CF-Talk
Subject: RE
I am about to create a web-based htaccess manager... that will allow my
client to create/delete htaccess areas on the server.
This is a Windows 2000 server... I already have a script that does this
nicely in perl on my Linux server.
Does anybody have any thoughts on how best to go about this?
First I created a blank MySQL database, and configured it in the CF Admin to
be the default store for client variables. CF couldn't create the tables
automatically, so I found the code and did it manually. The variables
weren't being written to the database, but instead, still written to the
Hey all!
I'm trying to migrate a server from using the Registry for client variable
storage to using either cookie or ODBC.
What's the best action plan? I've been searching the web for a good
'how-to' guide... does anybody know of / have one? I'd love to learn some
'best practice' tips.
--
I created a database, with the following tables (CF Admin couldn't create
them automatically):
CREATE TABLE cdata (
cfid varchar(20) NOT NULL default 0,
app varchar(64) default NULL,
data text,
PRIMARY KEY (cfid)
)
CREATE TABLE cglobal (
cfid
Sorry for the repost... my message wasn't delivered.
*** *** ***
First I created a blank MySQL database, and configured it in the CF Admin
to be the default store for client variables. CF couldn't create the tables
automatically, so I found the code and did it manually. The variables
I have a client who contracted MSBlaster yesterday... and ever since, CF
isn't properly serving up pages. No error comes up, but the page displayed
is blank.
A view of the source shows this:
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META http-equiv=Content-Type
Does anybody have / seen code the does some slick and easy keyword storage /
data for reporting on verity search?
--
Jillian
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
to the db, but a bunch still get written to the
registry.
If anybody has any suggestions - the would be most welcome.
I've tried specifying my datasource in the Application.cfm, and that is when
I started to get a few (but not all) entries into the db.
-Original Message-
From: Jillian
Has anybody purchased Centrasoft's CFMX Exam Buster? Did you find it to be
helpful for preparing to take the certification exam?
--
Jillian
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
Good Morning!
I've got an array that worked, other than when content contained a comma (of
course)... and because a comma is a common character that is actually
required in these fields, I wanted to change the delimiter in my array to a
|. I made the change below, but I'm no longer having any
: Array Delimiter Problems
You're not specifying the pipe as the delimiter in your listlast()s.
-- Ben Doom
Programmer General Lackey
Moonbow Software, Inc
: -Original Message-
: From: Jillian Carroll [mailto:[EMAIL PROTECTED]
: Sent: Thursday, July 24
I'm looking for a survey application to purchase.
My needs:
- True / False, Multiple Choice, Check One, Check Many + Write
in Other
- Skip pattern
- Graphing of results
- Export all results as CSV (optional)
Has anybody written or used an
?
Check out ultimateapps.com
We just purchased their ultimate survey app
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 10:57 AM
To: CF-Talk
Subject: Survey Applications - Anybody Written One / Know of One?
I'm looking for a survey
I'm building a secure file manager on a CF 5 server.
Because there are a number of different file types in my directories (.pdf,
.doc, .xls, etc.) I think the best way is to create a directory that isn't
accessible via Apache... and use CF to view/work with the directory.
The question I
CFCONENT
Or you can look at: http://www.mindkeeper.net/products/filemanager
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 3:39 PM
To: CF-Talk
Subject: Secure File Manager
I'm building a secure file manager on a CF 5 server
Is anybody out there an Authorware guru? If so, please e-mail me off
list... I'd love to ask a few questions about integrating with CF.
--
Jillian
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
I've got this array (below) that pulls the results from a variety of tables,
and displays results based on the list position. The problem is with
frwhatsnewresearch. The list position for 3 SHOULD be 'frname' and the list
position for position 6 SHOULD be 'id'. This does not display the right
I've got an unusual problem.
I have a Javascript that rotates through a series of books (images/text
w/links). It's very simple. It works in IE and NS 4.x... But it doesn't
workin Mozilla / NS 7... nothing appears on the screen. How can I modify
this script/div so that it will display in all
Thanks Dan (and everybody else who pointed me in the right direction) that
did the trick!
--
Jillian
-Original Message-
From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]
Sent: July 10, 2003 10:06 AM
To: CF-Talk
Subject: RE: Javascript / Div's in NS 7 and Mozilla
Jillian,
Today is the day for me to have brain-freeze it seems!
I want to order a search query by last_name instead of relevance... What's
the best/easiest way to do this?
My CFSEARCH tag:
CFSEARCH
NAME=phonedir
COLLECTION=cla_intranet_phonedir
TYPE=Simple
/teammacromedia)
Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 10, 2003 10:49 AM
To: CF
(www.mindseye.com)
Member of Team Macromedia
(http://www.macromedia.com/go/teammacromedia)
Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Jillian Carroll
I just discovered my own problem!!! I needed to add _2 to #phonedir.key# in
the WHERE clause.
--
Jillian
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: July 10, 2003 11:08 AM
To: CF-Talk
Subject: RE: Sorting a Query Alphabetically
cfoutput query
I need to validate a password field, to ensure that it contains at least 8
characters and at least 1 non-alphabet character.
Does anybody have something handy that will help me with this? Should I use
CF/RegEx or Javascript?
Thanks!
--
Jillian
I'm trying to create an e-mail report for some course administrators. I've
got things figured out so that I can output the results, and I'm getting the
correct results... but I only want each administrator to get a single
e-mail... my current output would have them getting one for each student.
I have a form, that asks for a number of 'conditions' in order to find an
attendee for a course. The problem is, I've put together a query that
returns too many results / not the correct results. Every row returned is
returned multiple times. I'm wondering if I'm needing a join somewhere...
or
Gabriel,
When adding SSL, it really has more to do with your web server than your
ColdFusion server.
If you can tell me a little more about your environment, I can probably help
you out more easily. Are you running IIS or Apache? What version? Are you
on Windows or Linux?
As far as
Jillian Carroll wrote:
Gabriel,
When adding SSL, it really has more to do with your web server than
your ColdFusion server.
If you can tell me a little more about your environment, I can
probably help you out more easily. Are you running IIS or Apache?
What version
John,
I have had this problem more than once.
Which DBMS are you using?
--
Jillian
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]
Sent: June 17, 2003 12:33 PM
To: CF-Talk
Subject: RE: Data getting truncated on select
Yea I understand the problem you had,
Subject: RE: Data getting truncated on select
Using sql server 7.
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: 17 June 2003 20:14
To: CF-Talk
Subject: RE: Data getting truncated on select
John,
I have had this problem more than once.
Which
that checked of course, it will only return
64,000
characters / whatever value is specified in the text box below.
Adminstrative settings in MSSQL or CFMX?
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: 17 June 2003 20:42
To: CF-Talk
Subject: RE: Data getting
I am creating a drop-down list of items, but I want to keep several items
from appearing in the drop-down.
Is there a more efficient way to accomplish this (there will be several more
exclusions):
cfquery name=qCrop datasource=common_as
SELECT DISTINCT
Description
FROMVCT
ORDER BY
I've recently moved my CF 5 server from RH Linux to Windows 2000... and now
I'm having a problem with my MySQL database. I can't insert or select more
than about 65,000 characters (I've been doing character counts with spaces).
I've selected 'Enable retrieval of long text' in the CF
PIER System, Inc.)
[EMAIL PROTECTED] voice : 360.756.8080 x12
fax : 360.647.5351
www.audiencecentral.com
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 2003 9:55 AM
To: CF-Talk
Subject: URGENT - MySQL Truncating DB Insert / Select
I've
I'm an idiot.
I restarted the server after making the change to 'Enable retrieval of long
text'.
It works now.
Boy is my face red.
--
Jillian
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: May 30, 2003 12:39 PM
To: CF-Talk
Subject: RE: URGENT - MySQL
It is called the Microsoft Action Pack... for about $450.00 USD you get
licenses (note they are only 1 year licenses) to just about all the MS
OS/Office/Server software.
--
Jillian
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: March 18, 2003 10:33 AM
To:
Folks,
I have a problem... and I am -really- hoping that somebody has a
solution for me. I've searched for hours, tinkered for days... and Im
really stuck. I'm at the stage of hoping that I'm missing something
obvious.
First, my platform: CF 5 on RH Linux 7.2 using PostgreSQL 7.1 (but I
I've got a search collection (CF 5) made up of about 900 files. I can
search them using CF Search... and display their filepath/urlpath/key...
how can I display/call on their contents (or a portion thereof)? There
doesn't appear to be a body/custom1/etc for index type=file.
I've searched
: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2003 4:06 PM
To: CF-Talk
Subject: Display Search Contents
I've got a search collection (CF 5) made up of about 900
files. I can
search them using CF Search... and display their
filepath/urlpath/key... how can I
Good Morning!
I know I'm close here... but I'm having a few problems trying to get my
search engine to index my static pages. The code below works... but I
need to evolve it to do two more things, and I can't find anything
through google/macromedia forums.
My questions: How can I evolve my code
: Re: Search Indexing
Jillian,
Have you tried using the Verity K2 Spider on your site? It's
a full web spider that will follow all the links on your site
and index the content regardless of it being static or dynamic.
Jeff
- Original Message -
From: Jillian Carroll [EMAIL
I second this recommendation for GoDaddy. I saw somebody recommend them
on the list a few months ago and I've been working with them
exclusively. Their prices are cheap, their service is great and they
are fast to respond to tech support questions.
--
Jillian
-Original Message-
From:
On the flipside of this... If you register through GoDaddy, you won't
receive the oodles of spam that other registrars send you trying to get
you to transfer/renew your domain with them.
-Original Message-
From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]
Sent: March 6, 2003 8:58 AM
To:
If version 6.0 isn't bleeding edge enough... that's a problem as far as
I'm concerned.
--
Jillian
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: March 6, 2003 11:08 AM
To: CF-Talk
Subject: RE: New Macromedia.com launched!
It does matter,
I'm surprised MM would launch this site given:
- Jakob Neilson (and other usability professionals) are going to
be watching
- They are trying to 'sell sell sell' the idea that Flash has
matured and is now faster, friendlier, etc.
For my own interest, I checked out the site in several
Two companies doing something incorrectly doesn't make it correct.
--
Jillian
-Original Message-
From: Benoit Hediard [mailto:[EMAIL PROTECTED]
Sent: March 5, 2003 10:41 AM
To: CF-Talk
Subject: RE: New Macromedia.com launched!
If it's a beta version, why is it public then?
I know I'm just contributing to a way-off-topic conversation...
I think that for the purposes of sending/receiving e-mail, there are far
less bloated solutions that prove themselves to be more stable than
Exchange.
However, I've yet to see a product on the market (Notes comes closest)
that
I have a form that has a number of checkboxes that are generated
dynamically. I have two problems: how can I 'recall' the values of
these checkboxes so that I can check/uncheck them later (the idea of
this form is students being assigned to organizations for study, so they
might belong to one or
Sorry for the duplicate post... my posts weren't being delivered on
CFTALK yesterday.
*** *** ***
Folks... I'm not sure what I'm doing here, but I'm hoping somebody can
point me in the right direction (even if the right direction is just a
web resouce, I don't mind learning).
I've got this
I've been working on this for a while and I've created a test page
before I move this over to my full form.
How can I create a loop that will allow my insert to work?
This is what I have:
cfif IsDefined('form.action')
cfquery name=addorg datasource=#DSN#
INSERT INTO org_admin
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 9:53 AM
To: CF-Talk
Subject: Dynamic Insert
I've been working on this for a while and I've created a test page
before I move this over to my full form.
How can I
Megan,
I have some contact information for the general manager... but I'm not
sure whether it's still accurate as when I looked back at my records, it
is from late August 2002. I don't host with them, but I considered it
at that time.
Nick Richards
General Manager
Flare Network Operations
I'm getting this error:
ODBC Error Code = 0 ()
Error while executing the query (non-fatal); ERROR: Bad boolean external
representation ''
From this code:
cfquery name=update datasource=#DSN#
UPDATEattendee
SET
cfif IsDate(Trim(Form[regreceived Indx]))
Can anybody please help me with this page? I've been fooling around
with it forever and I'm just not having any luck.
There are two things that I need help with:
1.Why aren't my dropdowns working properly? They should be pulling
the data from the database and displaying it when possible.
What I'm trying to do is take a query of all my students, and update
their grades, record by record and then submit them all with one submit
button at the end. I think I'm getting close with the code I have
(thanks to some folks off the list), but it's still not working...
everything I try seems
I've broken down my queries into the simplest of forms... and it's not
working. It should return 3 values and only returns 1. I'm posting
this because I'm hoping that I am missing something completely obvious
that I'll smack my head about.
My database is in Postgres.
My query at the
Sorry... one of those moments where 20 seconds after I sent this I
figured out my silly error.
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]]
Sent: February 12, 2003 4:17 PM
To: CF-Talk
Subject: Query Not Cooperating
I've broken down my queries
Okay, it's definitely been one of those days... I'm having a hard time
making these checkboxes work. Can anybody see something obvious wrong?
--
cfquery name=attendee datasource=#DSN#
SELECT attendee.*, users.id AS users_id, users.lname, users.fname
FROM attendee, users
WHERE
Hey everybody... I'm having a problem that is causing me to knock my
head against the wall... I'm sure it's something completely obvious. I
have the following code (pasted below) and it should return 3
users/rows... but it only returns 1. There isn't any error message, it
just lists one. I did
Sorry for the second OT message, but I'm not having any luck.
Does anybody have a truly cross-browser compatible script that will
create an automatic slideshow w/text descriptions?
Any help would be greatly appreciated... I've been working on them all
day and it seems no matter what I do it
: February 5, 2003 9:45 AM
To: CF-Talk
Subject: RE: Remotely spider websites
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 10:18 AM
To: CF-Talk
Subject: Remotely spider websites
From what I have been able to find
Can anybody tell me why the following script will work in all versions
of IE, Netscape 4 and 6... but won't work in Netscape 7? I'm hoping
somebody can see something that I won't.
*** *** ***
html
head
SCRIPT
!-- Beginning of JavaScript -
// Slide-show and Text-Ticker all in one- Copyright (c)
?
Thank you for your information.
--
Jillian Carroll
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http
I'm really stumped here.
Can anybody tell me how to turn this Excel formula into CF friendly
code?
=LOOKUP(B58,$A47:$A52,B47:B52)+(B57/100)*(B167-LOOKUP(B57,$A39:$A45,B39:
B45))
I'd be forever in your debt!! :)
Thanks!
--
Jillian
Is there any way to duplicate the 'roundup' functionality from Excel?
I'm using CF to do a number of calculations (basically to make a form
into a calculator) and I need to round up to a number so that there are
no decimal points. I can't just trim them... I need the rounding.
Thanks!
--
do these things:
round up
round down
truncate to integer
round nearest
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 10:35 AM
To: CF-Talk
Subject: ROUNDUP functionality from Excel
Is there any way to duplicate
can
just order your query by that field?
- Original Message -
From: Jillian Carroll [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, January 22, 2003 6:24 PM
Subject: RE: Sorting Numbers
Sorry, I mis-spoke (hazard of using a word with double meanings).
I need
How do I sort a list so that it doesn't do this:
1
2
3
4
5
6
7
8
9
10
100
101
102
103
104...
I want 11 to come after 10.
Thanks!
--
Jillian
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
there is an ASCII sort.
You want a numeric sort.
ListSort(myList,numeric)
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 5:51 PM
To: CF-Talk
Subject: Sorting Numbers
How do I sort a list so that it doesn't do
I am having a really weird problem... I do some calculations in CF, they
work on my development machine (Windows XP Home/Apache) but when I
upload them to my host (Windows 2000/IIS) they don't work. I get this
error... anybody able to help me on this one?
*** *** ***
Error Diagnostic
1 - 100 of 150 matches
Mail list logo