This works in MS Access
SELECT TOP 10 uniquecolumnid, * from Table
ORDER by uniquecolumnid DESC
I should really start reading the entire question before I attempt to give
an answer..
--
Archives: http:/
Are you sure you're making the connection? Does it work when everything
is valid? If not, the very first thing I'd do is test by using an FTP
client and see if you can connect and log in. Then, I'd hard code the
server address, username, password, etc. to see if you can do it from
CF.
Dependin
Of course the master gets the entire record set, I'm going to sleep now:-)
At 01:41 AM 8/20/2000 -0400, you wrote:
>Assuming you have a counter in the table, order the results by that counter
>reversed (using order by colname desc). Then, in the CFQUERY tag itself, set
>the maxrows to 10.
>
>se
At 01:41 AM 8/20/2000 -0400, you wrote:
>Assuming you have a counter in the table, order the results by that counter
>reversed (using order by colname desc). Then, in the CFQUERY tag itself, set
>the maxrows to 10.
This works with MS SQL 7
SELECT Top 10 uniquecolumnid From table
ORDER
Assuming you have a counter in the table, order the results by that counter
reversed (using order by colname desc). Then, in the CFQUERY tag itself, set
the maxrows to 10.
select * from table
order by uniquecolumnid desc
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_
You are storing the column names in your structure, but not the values.
Change this:
to this:
You may need to reference the query by name, though.
-David
On Sat, 19 Aug 2000 00:18:58 -0400 "Bill Killillay"
<[EMAIL PROTECTED]> writes:
> When I run this code below I end up getting the colu
Luke try this:
SELECT MAX(ID) AS TopID
FROM yourTable
SELECT Date
FROM yourTable
WHERE ID BETWEEN #TopID# AND #LowID#
#Date#
Sebastian
on 8/19/00 10:16 AM, Luke Kearney at [EMAIL PROTECTED] wrote:
>
> Hi There CFer's
> Can anyone give me a hint on how to tell CF to display the mo
Oops. it's getting late:-)
You are looking for CFFTP so the port should be 21 I guess.
>PORT="80" OR PORT="443" (id SSL)
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
h
At 09:55 AM 8/19/2000 -0400, you wrote:
>When I try using CFFTP to initially connect to an FTP Server but the userid
>or password is invalid, all I'm getting is a timeout on the CF page
>and no error returned via CFFTP.
Try with a port number Matt...
PORT="80" OR PORT="443" (id SSL)
>Here's
When I try using CFFTP to initially connect to an FTP Server but the userid
or password is invalid, all I'm getting is a timeout on the CF page
and no error returned via CFFTP.
Here's the code I'm using to call CFFTP to attempt the login:
Any pointers or ideas from folks on th
There may be other problems, but the line
should be
-David
On Fri, 18 Aug 2000 13:30:59 -0400 Ashley Hart <[EMAIL PROTECTED]>
writes:
> Hi Everybody,
>
> I can't figure out why this code in the template for verifying
> Username
> and Password will not work correctly. I am trying to verif
Phil,
Since its 100% free, I'd say download it and try it out yourself. Its a
very cool interface, and packed with useful stuff...its surprisingly similar
to ColdFusion Studio.
BTW, for some reason, the URL is a little bit tricky. To download this
software go to:
http://www.evrsoft.com/downlo
yep, it good for basic design and storyboarding like front page but it works
in both browsers...
:)
- Original Message -
From: Phil Labonte <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 19, 2000 8:32 PM
Subject: html editor
> Does anyone use the following editor ins
> I do have NTFS.
> Can you actually insert the HD into a working NT server and
> recover the data from it?
> Is it not going to conflict with the other NT OS?
I've done it before a couple times. Did exactly that two days ago when w2k
on a machine went crazy. Copied what I needed and cdr'ed it a
Does anyone use the following editor instead of studio?
Evrsoft 1st Page 2000
Do you like using this editor? It was recommended by a friend of mine but I
wanted to see what all you thought about it.
Thanks
--
Archives
Thanks Frank.
Dave
- Original Message -
From: Frank Priest <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 19, 2000 10:20 PM
Subject: Re: OT: JS - Submit a form onChange
> At 10:18 PM 8/19/2000 -0400, you wrote:
> >Works like a charm in IE. Does it work in Netscape?
At 10:18 PM 8/19/2000 -0400, you wrote:
>Works like a charm in IE. Does it work in Netscape? I thought I read that
>submit() did not work with NS? I am at home and don't have it loaded up
>here. Do you know?
Should work in both.
Works like a charm in IE. Does it work in Netscape? I thought I read that
submit() did not work with NS? I am at home and don't have it loaded up
here. Do you know?
Thanks,
Dave
- Original Message -
From: Frank Priest <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, Augus
At 09:54 PM 8/19/2000 -0400, you wrote:
>I know this is OT, but can anybody tell me how to automatically submit a
>form when an option in a dropdown box is selected?
Hope this helps
Frank
--
Archives: http://www.
I know this is OT, but can anybody tell me how to automatically submit a
form when an option in a dropdown box is selected?
Thanks,
Dave
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe
How about getting the form field and then #Trim(Form,FieldName)# This should
get rid of the spaces and allow you to test the length of it.
If the length is zero, then generate an error...
L.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Lucas Sherwood
Technical Sales Consultant
Firmware
What you have is a variable inside of a variable.
When you are doing your you are only evaluating the first
variable, which displays the second variable but doesn't evaluate it.
Try:
#Evaluate(getheader.mainheader)#
You might get an error about nested s if you don't remove the set
from the
Probably simple, just never had a reason to try it
until now. I want to put CF code in a text area.
insert it to a varchar field in SQL 7 then output
the CF code to an html page. BUT!! It disappears.
Simplified-
Untitled
Select mainheader
from styl
How bout talking about this NT issue directly?
- Original Message -
From: Philippe Varichon <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 19, 2000 4:52 PM
Subject: RE: Stuck at the NT Login box
> Yes, the mouse is wireless...It was working without installing the driv
Yes, the mouse is wireless...It was working without installing the driver that came
with it (9.1) but then I thought that it would be a good idea to update it.
But what happened is that it could not update and the previous driver might have been
erased because it did not appeared in the "Progr
Have you tried plugging a PS2 mouse into the box and booting in safe mode?
That should get you in, at which point you should be able to "update" the
drivers for the Logitech mouse with the older version.
Now, I have to ask in order to satisfy my own curiosity, are you running a
cordless, Logitech
If the drive is NTFS, you can stick it in another computer running NT.
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
-Original Message-
From: Steve Bernard [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 19, 2000 5:29 PM
To: [EMAIL PROTECTED]
Subjec
On 8/19/00, paul smith penned:
>APPLICATION scoped variables that once set are read only
>VARIABLES scoped variables, and
>CLIENT scoped variables
>
>and no other non-scoped variables,
>
>then I don't have to worry about CF locking.
I believe the general consensus is you should still lock the
ap
Shane,
The keyboard does not respond to any command, although at boot time I was able to use
the space bar.
I used another keyboard, same thing. Same for the mouse, I tried 2.
The "OK" button is highlighted but does not respond to the "Enter" command nor the Tab.
Note: My AT scripts and Cold
If you happened to format the root NT drive, normally C:, with the FAT or
FAT32 file systems then you can use a DOS/Win9x boot diskette to access the
drive. If it's formatted using NTFS then you'll probably need to use ERD
Commander Pro by Winternals, http://winternals.com/
Regards,
Steve
-
i may be simplifying this but can you hit the tab button to highlight the ok
button?
Sincerely,
Shane Witbeck
Webmaster
mailto:[EMAIL PROTECTED]
www.digitalsanctum.com
-Original Message-
From: Philippe Varichon [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 19, 2000 5:11 PM
To: [E
My NT server (SP6) was working until I tried without success to update a Logitech
driver for a wireless mouse (NT
compatible).
When I rebooted I could get to the login box but I could not enter a username because
I got the following error message from the
Service Control Manager: 'At least
An NDS 5 Directory. I'm not a Novell tech so I don't know to set up the LDAP
interface in NDS. Once it was setup I was able to query it with CF/CFLDAP
without problems. Using CFLDAP I passed the username/password to the server.
Steve
-Original Message-
From: Norman Elton [mailto:[EMAIL P
So as far as variables go (putting aside CFFILE considerations, and some
others mentioned by Forta such as CFX tags that aren't multithread safe and
CFHTTP) -- AND IF I have only:
APPLICATION scoped variables that once set are read only
VARIABLES scoped variables, and
CLIENT scoped variables
a
It took me a long time to figure this out... and then of course I said "DOH"
a lot... but you can query most ldap servers with a wildcard in the
attributes field to get all of the fields. Below is a file I use for this
task. Change the filter to a value that will only return one record.
(there i
Steve,
How did you pass the UID and password into LDAP? I searched in Novell's
developer website, but couldn't find any useful information about LDAP (i.e.
a list of what attributes are available).
Also, were you querying GroupWise's LDAP, or NDS directly?
Thanks!
Norman Elton
Information Tech
I don't know if this will be what you're looking for, but check out
http://javascript.internet.com/messages/text-fader.html (only works in
IE 4.0+, though).
Chris Montgomery [EMAIL PROTECTED]
Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner & NetObjects
John,
Okay, how's this for simple. Set up a template called switchDJ.cfm like
so:
DJ Switched
The DJ has been switched to DJ
#Application.dj#
Then, in your img links, use something like:
You could also include custom bio information:
Then, in your Application.cfm file, make
Anybody know of a good way to handle a rotating photo that would show which
Disc Jockey was currently on the air.
I realize that it would be fairly easy to set this up in a database file and
determine what photo should be up based upon a query, but what I am looking
for is an idea for the Admin s
use flash.. I suggest
- Original Message -
From: "mcklyn1" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 19, 2000 12:43 PM
Subject: Text Fade
>
> Anybody got any ideas on this?
>
> I have a query that is pulling two random quotes out of a database
Anyone have some example sytax for using regular expressions in the
extended search and replace and find in Cold Fusion Studio 4.5?
Bob Everland
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com
Anybody got any ideas on this?
I have a query that is pulling two random quotes out of a database.
These quotes need to be displayed where quote 1 fades into quote 2.
I have used a couple of different java applets to make the two quotes fade
into one another, but I am having a problem with the
At 09:21 19/08/00 -0700 paul smith said
>Well, I have to disagree. For lists up to 3,000 or so,
>(the limit of my experience with CF-driven lists)
>a CF-driven list server offers flexibility and features
>others do not, such as dynamically selected message
>content that varies for each subscr
On 8/19/00, paul smith penned:
>Does the following mean you let the database take care of locking
>client variables and you don't bother CF with this little detail?
Client variables are written to a database or the registry and
therefore are not susceptible to problems caused by multiple users
On 8/19/00, Al Musella, DPM penned:
>If you went through all of this trouble already, why not just get rid
>of all session / client / application variables all together. I don't
>really see the need for them. You can create your own database, and your
>own clientID and password, and pass them alo
1. It's better to create a seperate database because the cfid and cftoken
have to be unique. You dont have to fight with other applications it's just
easier to manage one database of client variables then it would to have 10.
2. Since they are being written to a database there shouldn't be a prob
>Well, I have to disagree. For lists up to 3,000 or so,
>(the limit of my experience with CF-driven lists)
>a CF-driven list server offers flexibility and features
>others do not, such as dynamically selected message
>content that varies for each subscriber. This is a must
>feature in the age o
Here is what Allaire recommended to us for our Spectra Cluster.
Note the machine that has the collections on it, has to have CF
installed and running.
__
You can change the # of servers to suit your needs.
This assumes 3 CF servers and one additional server where the
collections
will reside
At 08:46 AM 8/19/00 -0400, you wrote:
>Well. Due to my utter confusion over cflocks,
Thanks! I thot I was the only one ;-)
Does the following mean you let the database take care of locking
client variables and you don't bother CF with this little detail?
best, paul
> I've gone in to my
>shop
Well, I have to disagree. For lists up to 3,000 or so,
(the limit of my experience with CF-driven lists)
a CF-driven list server offers flexibility and features
others do not, such as dynamically selected message
content that varies for each subscriber. This is a must
feature in the age of one-t
Sounds like a JavaScript issue to me. I would check out www.irt.org for assistance.
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Em
Ive tried out efax, jfax and one other web based "service" fax solution, and
my results were all the same unsatisfactory. They werent cheap either,
but price was not the issue really. For us if we could have found a fast,
reliable, and easy email to fax program that used the web, the ROI woul
I like MDaemon, use 2.x - latest at my offices, and just dl'd 3x and like it
as well.
For mail server / cf interaction - how about iMS/inFusion Mail Server???
http://www.coolfusion.com/iMS.htm
Steve
- Original Message -
From: "JF" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sat
In order for the CF dateformat function to work you must have a valid date
argument either created from the database or using another CF date function
to create the date (i.e. CreateODBCDate() ).
Sincerely,
Shane Witbeck
Webmaster
mailto:[EMAIL PROTECTED]
www.digitalsanctum.com
-Original
I figured out the map thing... I was just being lame...
Thanks,
John
-Original Message-
From: John J. Kirker [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 19, 2000 8:14 AM
To: [EMAIL PROTECTED]
Subject: Verity on a cluster
Hi all,
We've got a couple clusters running and were wonde
This is a multi-part message in MIME format.
--=_NextPart_000_001B_01C00A3B.F1EEEF50
Content-Type: text/plain;
charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable
Hi There CFer's
Can anyone give me a hint on how to tell CF to display the most recent =
10 records from a
Hi all,
We've got a couple clusters running and were wondering if anyone has any
experience working with Verity on a clustered solution.
It's a pain in the arse trying to keep all three collections up to date etc.
None the less, we are trying to get away from having multiple collections
when it
Bud,
If you went through all of this trouble already, why not just get rid
of all session / client / application variables all together. I don't
really see the need for them. You can create your own database, and your
own clientID and password, and pass them along to each form This way
This is a multi-part message in MIME format.
--=_NextPart_000_000D_01BDCBD6.FBDDD120
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
when i look at cf generated output from a table on the isp's server i get
the follwoing error message however if i view
I may be misinterpreting this question but preventing blank spaces should
not be an option. Instead use client side validation (Javascript) or
post-processing (CF code) to take care of the fields that were not filled
out by the user.
Sincerely,
Shane Witbeck
Webmaster
mailto:[EMAIL PROTECTED]
ww
I haven't looked at this, but it looks interesting.
best, paul
>Reply-To: <[EMAIL PROTECTED]>
>From: "Brett" <[EMAIL PROTECTED]>
>To: "ora-list" <[EMAIL PROTECTED]>
>Subject: OT: Email to fax Gateway
>Date: Fri, 18 Aug 2000 11:58:05 -0700
>X-Mailer: Microsoft Outlook Express 5.50.4133.2400
>X-I
yes, that's what I wanted, a one way newsletter type thing.
jake
- Original Message -
From: "Gordon Burns" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 19, 2000 1:10 AM
Subject: RE: Mailing List
> At 23:25 18/08/00 -0400 Steve Pierce said
> >Why would you want
Hi All,
I am writing the CF Exam soon and was wondering if anyone who wrote it can
offer a little insight on the content. I have heard that there are a lot of
questions on arrays and structures, but is about it. Any info appreciated.
JM
-
If I understand you correctly, both the selected and unselected values are
in their own tables so you could just do something like this, right?
select foo
from unselected_table
where foo not in (select foo from selected_table)
HTH
Jon
- Original Message -
From: netman <[EMAIL PROTECTE
Howdy.
Well. Due to my utter confusion over cflocks, I've gone in to my
shopping cart and got rid of ALL session variables and converted them
to client variables. I'm serializing the shopping cart variable
itself with WDDX for storage in the client storage database. All is
well I'm happy to r
Sure looks like CF to me. They're still on Cold Fusion. I think they'll
probably leave the toysrus.com site running for a while until they've fully
integrated with Amazon. They even may continue to maintain it.. seeing as
they've got a few dozen servers sitting there, which, if you were wondering,
I just went to ToyRus website and clicked on the pokemon site and got this
error, doesn't look like CF to me. unless they're already at amazon.
$ self_string = !!
Type EXPRESSION
Message An error occurred while evaluating the expression:
#variables.flt_is_retail#
Is it required to have two tables, one for all choices and one for selected
values? If you could use a single table with an additional 'selected' flag
field the query would be simple. However, if that is not a possibility you
can try something like:
SELECT [field] FROM tblALL WHERE [field] NO
I'll second the MDaemon recommendation - good product, frequent updates,
very stable. We've installed it on 8 customer sites and haven't had a
problem with it yet.
Our past installs have been the 2.8x versions so I'm not real familiar with
3.x, but I checked your site and didn't see anything
You guys have really lost and confused me on this thread. Why are you
locking session variables per user??? I would understand in the case of a
machine having a session with another machine but a session for a specific
user keeps other users out by design. And given that CF processes commands
>Oops, let me try again, 100,000 total users per server and suggested max of
>2,000 users per domain.
hah, I thought it sounded too good to be true. A low-end server, but
of course the low-end is the big end.
Len
http://BIND8NT.MEIway.com: ISC BIND 8.2.2 p5 installable binary for NT4
http:
Robert:
Why don't you do a query for you select box that selects only the values
that are in the first table but not in the second. Kind of like so:
SELECT KeyID_Table1 from Table1
WHERE KeyID_Table1 NOT IN (select KeyID_Table2 from Table2)
My syntax may be off, but I think the idea is sou
72 matches
Mail list logo