I've got to delete the 5 oldest records in a SQL table. Is there any way to
delete only 5 records based on a date field? I'm looking for something
like:
DELETE LAST 5
FROM <tblname>
ORDER DESC BY <datefield>
Is there any SQL clause that will pull those 5 records? My CTO wants to
avoid doing a SELECT on the 5 records and then doing a DELETE, if at all
possible.
<CFUG-SFL Manager>
-Kev
</CFUG-SFL Manager>
> -----Original Message-----
> From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 17, 2000 11:02 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: datasource on a network machine
>
>
> I'm not sure I fully understand what you mapped. But we have
> several Access
> databases here that live on a machine other than the CF machine.
> We setup a
> network drive to the directory on the server where the db lives. Then I
> setup an ODBC connection using that network drive. Is that what
> you need to
> accomplish? Our server where the db lives is an NT 4.0 machine. The CF
> server is W2K.
>
> Athelene Gieseman
>
> -----Original Message-----
> From: Jeffrey Rose [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 16, 2000 2:01 PM
> To: [EMAIL PROTECTED]
> Subject: datasource on a network machine
>
>
>
> greetings list,
>
> How can we register an Access datasource on another
> server on our network?
>
> We have tried mapping the drive but this won't work
> on NT. We ran a test registering and verifying a
> datasource on a 98 machine and it succeeded.
>
> We need to be able to access the datasource on two
> different CF servers.
>
> TIA,
>
> - Jeffrey
>
> _____________________________________
>
> Jeffrey Rose
> XpressTrack: Smartware for Journals
>
> [EMAIL PROTECTED]
> http://xpresstrack.com
>
> ------------------------------------------------------------------
> ----------
> --
> Archives: http://www.mail-archive.com/[email protected]/
> 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/[email protected]/
> 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/[email protected]/
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.
