you can create an excel spreadsheet out of a regular-ol HTML -
if you wanted to make the spreadsheet database driven you could use
& - to generate an excel spreadsheet on the fly,
which would always be current:
field 1
field
you can't really, since adding the ID field will un-distinct two rows.
I'd add a field to the query just as a flag, and then through
the query, and if two entries are the same, set the flag to 1. Then you
can do a query of a query to get the unflagged entries, something like:
SELECT fi
try using a JOIN instead, something like
SELECT ll_location.location_id, ll_location.location
FROM ll_lessonstage LEFT JOIN ll_lesson ON ll_lesson.lessonstage_id =
ll_lessonstage.lessonstage_id
LEFT JOIN ll_location ON ll_location.location_id =
ll_lesson.location_id
I don't know from Oracle, but I'd wager that it's the ORDER BY clause
that's causing that error...
-Original Message-
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 4:31 PM
To: CF-Talk
Subject: RE: Trimming Duplicates
this is the erro
it's also a keen way to store a bunch of preferncess in one place, i.e.
say you want to keep track of read, write, edit and delete permissions
for a bunch of different things, you can save them as one integer and
use the bit operators to deduce whether or not a specific bit is 0 or 1.
you can then
Why not just do it all in SQL? I think it's usually best to let SQL do
its own time functions...
select * from shows where
ShowDate BETWEEN getDate() AND dateAdd(ww,1,getDate())
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 20
I usually use
SET NOCOUNT ON
INSERT INTO people (password, username)
VALUES ('something', 'testuser123456')
SELECT @@identity AS lastID
works in SQL 2000 for me...
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, Apri
7 matches
Mail list logo