Very hard to answer without code.
For your second problem: your next-n is working on individual records, not groups, so it works as intended. Show first three (3 ben), then next three (1 ben, 2 john). You will have to find an alternative to make the next-n work on accounts. You could make 2
You need to drop the time from the date-time in your where clause.
Otherwise it has to match to the exact second.
On Oracle:
WHERE TRUNC(event_date) = TO_DATE(cfqueryparam
cfsqltype=CF_SQL_VARCHAR
value=#Dateformat(show_event_date,'-mm-dd')#,'-MM-DD')
On MSSQL you can do
WHERE
Hi,
We have been using a simple LDAP authentication method, which basically queries the LDAP server for the user's own record using their own username and password.
This in general works fine, however for a very small number of accounts (about 1 in 50ish), instead of returning the user's record,
message of LDAP server is unwilling to perform
How busy is the traffic to the LDAP?Ours refuses connections after a
certain limit over a defined period of time, presumably to stop hack
attempts.
Might be a similar issue.
--
dc
[Todays Threads]
[This Message]
[Subscription]
[Fast
Hi All,
Has anyone found a solution concerning the message (warning: page has expired), when one clicks the back button or go(-1). I've tried the following with
no success.:
cfcache action="" timeout = #DateAdd(h, -1, Now() )#
or
CFHEADER NAME=Expires Value=Sun, 06 Nov 1994 08:49:37 GMT
Whittingham, P wrote:
Has anyone found a solution concerning the message (warning: page has expired), when one clicks the back button or go(-1).
Was the page originally sent as the result of a GET or a POST
request?
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast
You will always get this message if you are moving back to page which in
itself was a form post (as the data to form this page does not techincally
exists in the back request).
There is no solution as far as I knowits by design.
_
From: Whittingham, P [mailto:[EMAIL PROTECTED]
Sent:
post method. some of the form data is sensitive or more that 4k in length (lots of form elements). I been trying all the different method via google.
Pat
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 26, 2004 7:05 AM
To: CF-Talk
Subject:
Whittingham, P wrote:
post method.
Responses to POST requests are only cacheable in special
circumstances. The recommended workaround is not to send the
response directly, but forward the user to another page that can
be cached. See the HTTP 303 statuscode in RFC 2616.
Jochem
[Todays
i am using w2k servers,ie 6 and http1.1...
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 26, 2004 7:32 AM
To: CF-Talk
Subject: Re: page has expired Message
Whittingham, P wrote:
post method.
Responses to POST requests are only cacheable in
What form of mailing list?Like read only newsletters or open discussion
forums like this?
I'm actually working on a mailing list for news letters currently.So far
my progress is as follows.
Users can subscribe / unsubscribe (adding and removing them from the
database) and they are sent a
Hi,
What has everyone running MX on production set their simultaneous requests
to? I see its 5 out of the box (or is it 8)obviously for higher traffic
sites this is not very good.I was gonna set it at around 20-30?
That good or bad?
Also, its suggested to upgrade the Java to 1.4.2 from
It will work, but from what I've read isn't really suggested.
If more than a handfull of users will be accessing access (no pun
intended) things have the potential to slow down.
If you don't want to spend the $$ for sql, go with MySQL which is free and
for me has worked flawlessly with
If it works when it's all on one line, why not just set the script (nicely
formatted) to a cf variable, then run replace on the line breaks, then use
the variable?
- Original Message -
From: Semrau Steven Ctr SAF/IE
The problem, in a nutshell, is that we (dba and me) have very limited
It has long been a desire of mine to run CF apps on the desktop and/or
from CD.There have been many threads on this list, about this topic,
but no resolution
I recently posted a question on the BlueDragon list, asking if it were
possible to run BD from a CD.
I got several responses, indicating
dan.
I do this:
select *
from yourTable
where date between '05/01/2004 00:00:00.000' and '05/01/2004 23:59:59.999'
if I want the events of a day.
and of course you can do some slick stuff to create those datetime combos
does that get what your looking for?
tw
-Original Message-
Anyone worked recently with activePDF? I just downloaded the eval and the
actual CF docs on the subject are pretty thin.
N
This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England,
They way I have understood this setting in the past is as so:
5 Sim Requests = 20% of the resources
10 sim requests = 10% of resources
Thus the more you have the less resources and thus the slower the request I
think its very a bit of a black art.
Hope this helps
I know this was touched on before and I re-read the thread but did not find my answer. I need a way to prevent the browser's refresh from re-submitting info. Is there a way via CF or _javascript_? anyone have something already please?
Thanks.
Robert
HWW
[Todays Threads]
[This Message]
I know this was touched on before and I re-read the thread
but did not find my answer. I need a way to prevent the
browser's refresh from re-submitting info. Is there a way via
CF or _javascript_? anyone have something already please?
Set a variable: session.ranAlready = false
Check to
Robert Orlini wrote:
I know this was touched on before and I re-read the thread but did not find my answer. I need a way to prevent the browser's refresh from re-submitting info. Is there a way via CF or _javascript_? anyone have something already please?
Use POST instead of GET as the request
Original Message:
From: Dave Watts
That's only true if Maintain Connection Across Client
Requests is checked.
That's correct, but the default setting is to enable this option, I think.
That was true in CF5 (and presumably earlier versions), but not in CFMX.
In general, maintaining
Yes I did one year and a half in my previous company
J-M
-Message d'origine-
De : Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]
Envoy : mercredi 26 mai 2004 14:41
: CF-Talk
Objet : activePDF
Anyone worked recently with activePDF? I just downloaded the eval and the
actual CF docs
From: Pascal Peters
On Oracle:
WHERE TRUNC(event_date) = TO_DATE(cfqueryparam
cfsqltype=CF_SQL_VARCHAR
value=#Dateformat(show_event_date,'-mm-dd')#,'-MM-DD')
Why wouldn't you use CF_SQL_DATE as the cfsqltype?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
whats you take on it? good / bad?
_
From: Jean-Marc Bottin [mailto:[EMAIL PROTECTED]
Sent: 26 May 2004 14:17
To: CF-Talk
Subject: RE: activePDF
Yes I did one year and a half in my previous company
J-M
-Message d'origine-
De : Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]
(Most hosts I've seen will charge more for SQL Server accounts than
for Access accounts)
That's mainly because the SQL (either MySQL or MS SQL) run on a seperate
server.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Honestly, fifty fifty!
If you need to generate a lot of pdf files it could be ok, however you will have to create a css for it. The good point is that it will generate a report on several pages. You need to use the server (activePDF) in combination with web grabber. I have been dissapointed by
Original Message:
From: Dan Phillips
That's mainly because the SQL (either MySQL or MS SQL) run on a seperate
server.
True (and a SQL Server license is more expensive than Access).But to the customer, it's just an additional cost. (Of course, I think CrystalTech doesn't charge extra for
- Original Message -
From: Philip Arnold
From: Pascal Peters
On Oracle:
WHERE TRUNC(event_date) = TO_DATE(cfqueryparam
cfsqltype=CF_SQL_VARCHAR
value=#Dateformat(show_event_date,'-mm-dd')#,'-MM-DD')
Why wouldn't you use CF_SQL_DATE as the cfsqltype?
Oracle's
From: Robertson-Ravo, Neil (RX)
Anyone worked recently with activePDF? I just downloaded the
eval and the actual CF docs on the subject are pretty thin.
Take a look at CFXPDF as well - it has specific CF instructions and will
probably do what you need
[Todays Threads]
[This Message]
Thanks Phil...I will take a look and compare these.
_
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: 26 May 2004 14:48
To: CF-Talk
Subject: RE: activePDF
From: Robertson-Ravo, Neil (RX)
Anyone worked recently with activePDF? I just downloaded the
eval and the actual CF docs on
I am having a bit of trouble doing a date search on form entered data.
WOW - I had no idea that there would be so many approaches.I thought on the way into work today to just put zeros in the time and do a 'greater than', but Tony pointed out that it'd be between instead.Hey tony, the date you
neil, what are you looking to with these pdfs?
have you/anyone worked out a way to hit a page, generate a pdf, and have
that sent to a print spool, to print with dynamic stuff, through a fdf,
inserted into the pdf?
thanks.
tony
-Original Message-
From: Robertson-Ravo, Neil (RX)
checkout iText too
http://www.lowagie.com/iText/
Java based...
Doug
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 26, 2004 9:48 AM
To: CF-Talk
Subject: RE: activePDF
From: Robertson-Ravo, Neil (RX)
Anyone worked recently with activePDF? I just
I am having a bit of trouble doing a date search on form entered data.
WOW - I had no idea that there would be so many approaches.I thought on the way into work today to just put zeros in the time and do a 'greater than', but Tony pointed out that it'd be between instead.Hey tony, the date you
I have a CFFILE question:
I have a form which allows a user to upload three different images at the
same time
I have three different cffile action="" tags on the processing
page.
The problem is it only uploads the very first image...
Any suggestions?
[Todays Threads]
[This Message]
It will upload one file at a time and not two or three together
-Original Message-
From: Monique Boea [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 26, 2004 10:03 AM
To: CF-Talk
Subject: CFFILE
I have a CFFILE question:
I have a form which allows a user to upload three different
On May 26, 2004, at 10:06 AM, Monique Boea wrote:
It will upload one file at a time and not two or three together
Try doing a cfloop or cfoutput with cffile as the query name.I
haven't tried it yet but it might work.
--
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company -
Combing the three into one cffile with a loop?
-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 26, 2004 10:12 AM
To: CF-Talk
Subject: Re: CFFILE
On May 26, 2004, at 10:06 AM, Monique Boea wrote:
It will upload one file at a time and not two or
Its the coldfusion noob again here..
Is there a self varible in coldfusion?much like $PHP_SELF if your
familier with that..
So, if the varible were used in blah.cfm, the content of it would be just
blah.cfm.
-Mike
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
Can you post the code for the submission form?
George
At 10:20 AM 5/26/2004, Monique Boea wrote:
Combing the three into one cffile with a loop?
-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 26, 2004 10:12 AM
To: CF-Talk
Subject: Re: CFFILE
On
If you are using oracle, go with trunc()
-Original Message-
From: daniel kessler [mailto:[EMAIL PROTECTED]
Sent: woensdag 26 mei 2004 15:52
To: CF-Talk
Subject: Re: date search
I am having a bit of trouble doing a date search on form
entered data.
WOW - I had no idea that
Is there a self varible in coldfusion?much like $PHP_SELF if your
functions...
getBaseTemplatePath()
getTemplatePath()
--
dc
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- Original Message -
From: Philip Arnold
From: Robertson-Ravo, Neil (RX)
Anyone worked recently with activePDF? I just downloaded the
eval and the actual CF docs on the subject are pretty thin.
Take a look at CFXPDF as well - it has specific CF instructions and will
#GetFileFromPath(GetCurrentTemplatePath())#
-Original Message-
From: techmike [mailto:[EMAIL PROTECTED]
Sent: woensdag 26 mei 2004 16:23
To: CF-Talk
Subject: self varible..
Its the coldfusion noob again here..
Is there a self varible in coldfusion?much like $PHP_SELF
if your
cftry
!--- upload new file ---
cffile action="" filefield=form.tLogoFilename
destination=#variables.home_dir#media\images\clientlogos\#variables.tLogoFi
lename# nameconflict=overwrite
cfcatch
SCRIPT LANGUAGE=_javascript_ TYPE=text/_javascript_
alert(Error uploading Logo file.Please try
Take at all of the CGI variables. Some really good and useful stuff there.
I use #cgi.SCRIPT_NAME# frequently. Sounds like this would output what you are wanting.
Greg
- Original Message -
From: techmike
To: CF-Talk
Sent: Wednesday, May 26, 2004 9:23 AM
Subject: self varible..
Its
Do you mean the current file name? If so, you can use
getCurrentTemplatePath(), which returns the full path, and if you want just
the file, use getFileFromPath...
cfoutput
#getFileFromPath(getCurrentTemplatePath())#
/cfoutput
[Todays Threads]
[This Message]
[Subscription]
[Fast
On May 26, 2004, at 10:20 AM, Monique Boea wrote:
Combing the three into one cffile with a loop?
That's what I'm thinking..
eg
cffile
cfoutput query=cffile
#cffile.clientFileName#br /
/cfoutput
--
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company -
also you may want to try
cfdump var=#cgi#
just to see what other variables are out there.
and while your at it...
cfdump var=#session#
cfdump var=#server#
cfdump var=#application#
cfdump var=#form#
cfdump var=#url#
cfdump var=#client#
just to see what else is there and available.
I have
Ah sorry, I meant the code for the form page, not the action page. So the
page just before this one.
George
At 10:26 AM 5/26/2004, Monique Boea wrote:
cftry
!--- upload new file ---
cffile action="" filefield=form.tLogoFilename
sorry, it's long
form action="" method=post
enctype=multipart/form-data validateform();
table width=600 cellpadding=0 cellspacing=0 border=0
tr
td width=100 align=leftnbsp;/td
td width=500 align=rightnbsp;/td
/tr
tr
tdbLabel:/b/td
tdcfoutputinput type=text name=tScreenLabel maxlength=100
just got the CFX working as noted below...seems pretty basic but it does
look goodlike Kevin, I am gonna be generating fairly simple PDF's for
now...
_
From: Kevin Graeme [mailto:[EMAIL PROTECTED]
Sent: 26 May 2004 15:29
To: CF-Talk
Subject: Re: activePDF
- Original Message -
Has anyone worked with an editable PDF which post to a database on
submission?
This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.It contains information which is
For the filefield attribute, you need the name of the input
type=file.
The destination attribute has to be a directory (not a file!). You can
find out the name of the uploaded file with #cffile.serverFile#.
cffile action=""
filefield=tLogoFilename
From: Monique Boea
I have a CFFILE question:
I have a form which allows a user to upload three different
images at the same time
I have three different cffile action="" tags on
the processing page.
The problem is it only uploads the very first image...
I've run upto 10 on the same
Hi, all...
As the subject lines states, I'm setting up a system whereby a user
can subscribed to various newsletters that are sent out automatically
at varying intervals.
The advice I'm seeking, before I get into development is in the best way
to setup the db tables...
The main tables (among
Exactally what I needed..
Thanks for the quick replies..
Was trying to figure out how to post a form to itself..
form action="" method=post
Seems to work, but is there a better or more correct way?
-Mike
-Original Message-
From: Pascal Peters [EMAIL PROTECTED]
To: CF-Talk [EMAIL
form action="">
The code below will not work inside a cfinclude, Custom tag, ...
-Original Message-
From: techmike [mailto:[EMAIL PROTECTED]
Sent: woensdag 26 mei 2004 17:15
To: CF-Talk
Subject: RE: self varible..
Exactally what I needed..
Thanks for the quick replies..
there is
form action="" method=post
/form
look @ my last reply.
there are myriad things to output, if you know what to output and what you
cant see, may be visible through those cfdumps.
tw
-Original Message-
From: techmike [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 26, 2004
I am using cfhttp to pull a page from one of our servers to another.
The page that I am pulling contains a table.What I would like to do is
strip everything out of the file except for the table.The problem is
that the page is coming from a content management system.So I can't be
sure that the
What version of cf? Can you identify the table in a unique way (does it
contain something that doesn't change and is unique)? Are there other
tables nested in the table?
Pascal
-Original Message-
From: Jeff Langevin [mailto:[EMAIL PROTECTED]
Sent: woensdag 26 mei 2004 17:27
To:
On May 26, 2004, at 11:26 AM, Jeff Langevin wrote:
How would I even begin (and can it even be done) to strip out the HTML
that I don't want?
cfset CleanData = Mid( UncleanData, find(table id=findthisone,
UncleanData) -1, find(/table!--findthisone--, UncleanData) + 8)
This is based on using the
Thanks, that explains it.I thought my account was current but I guess not.FWIW, I'm happy that SQLWizard wasn't available for the last 15 months cause it didn't work properly with MX
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I am pulling from CFMX 6.1 to CF5.
I could put comments before and after the table to delineate it.
However, I could not guarantee that a user in the CMS would never remove
or alter them.
At this point, there are no nested tables in the table, but again, I
can't that won't change in the
table id = thisTable ...
/table
can you guarantee the id= will stay there, if you set it up that way in
the first place?
tw
-Original Message-
From: Jeff Langevin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 26, 2004 11:42 AM
To: CF-Talk
Subject: Re: cfhttp and stripping out text
My biggest request is the ability to create a PDF which is in itself an
editable PDFI am not sure if this is possible with any of the tools out
there?
_
From: Kevin Graeme [mailto:[EMAIL PROTECTED]
Sent: 26 May 2004 15:29
To: CF-Talk
Subject: Re: activePDF
- Original Message -
[CF5/Win2k]
I'm trying to run Verity Spider (vspider.exe) commands using
cfexecute. Some of the commands stop mid-way through, and the
process dies. I am using batch files to keep the cfexecute as
uncomplicated as possible, and I'm also using long timeouts, as well
as output files.
The same
form action="">
method=post
Seems to work, but is there a better or more correct way?
Yes
That will only work if your file is in the root directory of your
website.
Try this instead -
form action="" method=post
Cheers,
Alistair Davidson
Senior Technical Developer
Headshift.com
Smarter,
The problem is that the page is coming from a content management system.So I can't be
sure that the surrounding html will always be the same.
Yes or no, the chances are bigger the content management system will always generate content the same way.
How would I even begin (and can it even be
I have a table like the following.With just CFML (v5) and plain Oracle PL/SQL--ie, no temp tables or stored procedures--is there a way to get, say, the 7 most recent distinct providers?I've tried every which way, even using QofQ with MAXROWS=7, but that only returned the first 7 distinct providers
Hmm I definately had RDS installedbut,I dont think I pointed to the correct place for the JRE in the Administrator settings
I'm getting a sequelink error now,apparantly it couldn't start and now I cant get CF Server to start.
If your machine doesn't acknowledge the JRE, you might need to
Since the table is part of a larger block of content, I can't
guarantee that the id would never be removed.
With a little tweaking, Damien's idea did work for me.But, now its a
question of whether a user will much things up or not.In general, no I
would not expect them to be altering the
a Top-N styled SQL...something like
SELECT *
FROM
(SELECT *
FROM tablename
OREDER BY datestamp
)
WHERE rownum 8
Doug
-Original Message-
From: Lofback, Chris [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 26, 2004 12:09 PM
To: CF-Talk
Subject: PL/SQL stumper
I have a table like
What do you mean by editable?AFAIK, Illustrator is the only app that
offers any significant editing of PDFs.Do you mean forms that can be
filled in buy the user in Adobe Acrobat Reader?
Cary Gordon
The Cherry Hill Company
At 04:50 PM 5/26/2004 +0100, you wrote:
My biggest request is the
I have a table like the following.With just CFML (v5) and plain Oracle
PL/SQL--ie, no temp tables or stored procedures--is there a way to get,
say, the 7 most recent distinct providers?I've tried every which way,
even using QofQ with MAXROWS=7, but that only returned the first 7 distinct
Lofback, Chris wrote:
I need to get the first 7 distinct providers in date order with newest first.Can it be done without getting fancy?
PROVIDER DATESTAMP
Eckerd Drugs 25-MAY-04
Walmart 25-MAY-04
Walgreens 23-MAY-04
Publix 23-MAY-04
Hush Puppy Shoes 23-MAY-04
Publix
oops...left out the distinct provider part
SELECT *
FROM
(SELECT provider,Max(datestamp)
FROM tablename
ORDER BY Max(datestamp)
)
WHERE rownum 8
Doug
-Original Message-
From: Knudsen, Douglas
Sent: Wednesday, May 26, 2004 12:16 PM
To: CF-Talk
Subject: RE: PL/SQL stumper
a
Yes, they are easily created in distiller etc...but needed to know if
activePDF could create these forms itself...
_
From: Cary Gordon [mailto:[EMAIL PROTECTED]
Sent: 26 May 2004 17:24
To: CF-Talk
Subject: RE: activePDF
What do you mean by editable?AFAIK, Illustrator is the only app that
On Wed, 26 May 2004 11:56:36 -0400, in cf-talk you wrote:
[CF5/Win2k]
I'm trying to run Verity Spider (vspider.exe) commands using
cfexecute. Some of the commands stop mid-way through, and the
process dies. I am using batch files to keep the cfexecute as
uncomplicated as possible, and I'm also
Is this actually the best way to post a form to itself?What I'm running
into now is it works, however it appends to the end of the url whatever
the action is.
Example.
blah.com/test.cfm#CGI.SCRIPT_NAME#
-mike
-Original Message-
From: Alistair Davidson [EMAIL PROTECTED]
To: CF-Talk
On a 2Gb Windows 2k3 server running CFMX, what would be the optimal memory
limits to impose on the JVM for CFMX?
Is there a maximum limit to the amount of memory the jrun service can
consume running CFMX?
For instance, for the sake of argument, say I had 8Gb of memory installed,
if I set
not sure what you mean?
is the page not parsing #cgi.script_name# ?
do you have cfoutput/cfoutput around it somewhere?
tw
-Original Message-
From: techmike [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 26, 2004 12:31 PM
To: CF-Talk
Subject: RE: self varible..
Is this actually the
Sorry, this is long but here's some more detail.Thanks, Tony, for the suggestion but the data, when it is returned, is good.I re-ftped the database over, thinking maybe some fields got corrupted, but no go.I even re-ftped the database from the host back to my local drive and ran the searches
bangs head off desk
What a stupid oversight on my part..Thanks!
-Mike
-Original Message-
From: Tony Weeg [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Wed, 26 May 2004 12:33:26 -0400
Subject: RE: self varible..
not sure what you mean?
is the page not parsing
The destination attribute has to be a directory (not a file!). You can
find out the name of the uploaded file with #cffile.serverFile#.
???
From the CFML reference:
Absolute pathname of directory or file on web server.
I know in the past I've used a filename here.
--Ben Doom
[Todays
Get rid of the cftry and cfcatch for now so you can see why the cffile
operation isn't working. The CF error should tell you what's wrong.
Greg
-Original Message-
From: Monique Boea [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 26, 2004 10:27 AM
To: CF-Talk
Subject: RE: CFFILE
cftry
If I might chime in, if he DIDN'T mean that, does someone out there know
how to have editable forms in pdf?I have a job that will require that
coming up
Thanks,
Ray
At 12:23 PM 5/26/2004, Cary Gordon wrote:
What do you mean by editable?AFAIK, Illustrator is the only app that
offers any
ok, thanks I will.
If you are using oracle, go with trunc()
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I thought the same thing at first, but you cannot sort on a field that is not selected when using DISTINCT.And adding the field throws off the records selected because DISTINCT looks at the entire row, not just the one column...
Thanks,
Chris
-Original Message-
From: Dave Carabetta
As far as I've seen just leaving the Action blank will always self-submit -
correct?
Jim Davis
Exactally what I needed..
Thanks for the quick replies..
Was trying to figure out how to post a form to itself..
form action="" method=post
Seems to work, but is there a better or more correct way?
This throws an error:
ORA-00937: not a single-group group function
But it gives me some ideas to work with.
Thanks,
Chris
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 26, 2004 12:20 PM
To: CF-Talk
Subject: Re: PL/SQL stumper
Lofback,
Lofback, Chris wrote:
This throws an error:
ORA-00937: not a single-group group function
Forgot the GROUP BY:
SELECT *
FROM (
SELECT provider,
MAX(datestamp) AS lastDate
FROM table
GROUP BY provider
ORDER BY MAX(datestamp) DESC
) a
WHERE rownum 8
Jochem
[Todays Threads]
[This
What is the syntax for the updatetext() function in SQL 7. What I need to do
is replace all occurrences of a word with another word inside a long text
field. I have two SQL books and neither explain this fully. Google hasn't
been of much help either. On that note, is there any way in enterprise
Try passing the values back to the same page, and provide a message asking the user not to use the browser back button, but use the button provided as shown below:
form action="" page] method=post
cfoutput
cfloop collection=#form# item=fieldName
input type=hidden name=#fieldName#
Get rid of the cftry and cfcatch for now so you can see why
the cffile operation isn't working. The CF error should tell
you what's wrong.
Greg
Or,
cfcatch
cfdump var=#cfcatch#
cfabort
cfcatch
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Quick question,
Does anyone know who did the website for Real Log Homes?
http://www.realloghomes.com/
If so, could you contact me off-list please?
[EMAIL PROTECTED]
Ryan Hagan
ph: 540-731-3588
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Last summer, there was a lot of optimism on this list surrounding the release of Mach-II and it's object oriented approach to ColdFusion. Having tried it on a few projects and decided Fusebox was better suited for what I was doing, I am now considering it for a larger project my team is about to
I'm curious about the current status of this feature?I was a bit surprised when I could not find any mention of it in the current documentation?Does that mean it is deprecated, it's not going to be supported into the future?It still seems to work in the current version.
I don't think I ever used
In my reference (cfmx):
Pathname of directory in which to upload the file. If not an absolute
path (starting a with a drive letter and a colon, or a forward or
backward slash), it is relative to the ColdFusion temporary directory,
which is returned by the GetTempDirectory function.
I have never
1 - 100 of 204 matches
Mail list logo