Sounds to me like you need to differentiate between orders and packages.
If you had a table:
Order_package,shipper(UPS or US Mail),weight,destination,date
With all the separate orders marked as order.
Then use a sum query to total all packages going to same destination on same
date.
Either add
As someone about to embark on an intranet development with Content
Management I can say totally objectively that you should release it open
source, preferably within the next couple of weeks.
I'm sure I'm not alone.
-Original Message-
From: Kent Bulmer [mailto:[EMAIL PROTECTED]]
Sent:
I got this as a result of a bad sql query using up resources.
-Original Message-
From: David Berger [mailto:[EMAIL PROTECTED]]
Sent: 14 March 2001 20:37
To: CF-Talk
Subject: 'unknown exception condition' Causing CRASH
For the past 2 days, we've been experiencing Cold Fusion crashes.
forms[0] is not created, try forms[1].
using document.write does not wipe out the rest of the page... but depending
on when it's envoked, the stuff may not have been created yet (ie. a call is
made to a procedure that is in the process of being given to the browser to
figure out).
HTH, Cam
---
are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-Original Message-
From: Windle, Kevan [mailto:[EMAIL PROTECTED]]
Sent: 08 March 2001 17:03
To: CF-Talk
Subject: Javascript: Tearing my hair
I'm using IE5. Trying to do something really simple in javascript. The
problem I'm having is this. I can reference a form element with inline code.
So passing this variable to a function like this works:
input
ondblclick="resetwhereboxes(this.value,3,document.forms.wheres.wherefield1.n
ame)"
When you say there is no unique id do you mean that the fields shown also do
not uniquely identify the record. If so then you can't do it. However if the
item number and whatever criteris you use to select the query in the first
palce are unique then you can.
Generate the name of the quantity
If there's a record for each hour then wouldn't the number of hours just be
the number of records less the first one?
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: 01 March 2001 16:16
To: CF-Talk
Subject: date times
If there is anything I struggle with its
Does it output in order when you just view the cf page? Could it be
something to do with the link into excel. Perhaps it has trouble with some
data types.
-Original Message-
From: Winston Sia [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 07:33
To: CF-Talk
Subject: cfquery table data
You could loop round the commma delimted list of column names given by
query_name.ColumnList.
-Original Message-
From: Winston Sia [mailto:[EMAIL PROTECTED]]
Sent: 28 February 2001 08:16
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: Fw: CFQuery of database tables
This is a multi-part
I'm not sure about Sybase, I suppose it's the same principle as in SQL
Server. You have to either generate a dynamic query, by building a string
and running it via the execute function, or have a conditional statement to
select one query or another depending on the sort variable passed. The first
Yes you should index all linking keys. They don't have to be primary
indexes.
I always set the primary index on the tables most heavily used search.
Primary indexes are faster because the data is actually stored in that order
in the table.
-Original Message-
From: sebastian palmigiani
Just thought I'd jump on the bandwagon. Could you send me the code as well
please.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 13 February 2001 01:33
To: CF-Talk
Subject: Re: Hey Dave when can we see your email code
Um, the names Michael. Dave's a
I just got yours three times. It might be linked to similar problems on
CFtalk yesterday I don't know.
-Original Message-
From: Mak Wing Lok [mailto:[EMAIL PROTECTED]]
Sent: 08 February 2001 08:03
To: CF-Talk
Subject: OT: repeating maling list messages
am i the only one or do the
If your're doing it in Cf then sounds like you need to do it in the
database. Something like this depending what you're using.
1 Build first query for add direct links and add to a temp table.
2 Then get a query with just the departure and not destination.
3Add these to temp table or query and
I'm getting multiple copies of postings today. Is it just me?
**
The opinions expressed in this E-mail are those of the individual and
not necessarily the company. This E-mail and any files transmitted
16 matches
Mail list logo