cfquery name=getSigs datasource=firme
select signerName, signerLocation, signerComment, dateSigned,
MIN([dateSigned]) as startDate, MAX([dateSigned]) as endDate
from signatures
where signatures.petId ='#id#'
group by signerName, signerLocation, signerComment, dateSigned
order by dateSigned desc
The problem is I would assume the dimore expects you are an sa login?
I wouldn't think there is a need to license it as Google will give you this
type of script and more.
Still a good start for people who don't one of these scripts already.
This e-mail is from Reed Exhibitions (Gateway
Hi Walter, You may need to post a small sample of data to help us understand
this issue. how does petID crop up in the data for example.
On 10/22/06, Walter Conti [EMAIL PROTECTED] wrote:
cfquery name=getSigs datasource=firme
select signerName, signerLocation, signerComment, dateSigned,
Yes, and if the id field is numeric, not sure using the apostrophes around
#id# will work correctly... using apostrophes is usually reserved for text
fields I believe
-Original Message-
From: Michael Traher [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 22, 2006 3:55 AM
To: CF-Talk
On 10/22/06, Robertson-Ravo, Neil (RX)
[EMAIL PROTECTED] wrote:
The problem is I would assume the dimore expects you are an sa login?
Actually it's not based on login at the execution of the script,
simply at the datasource level. Whatever the DSN can see, the script
will dump... tables, SP's,
On 10/21/06, Andrew Tyrone [EMAIL PROTECTED] wrote:
Just put the days in the list, not codes ;-))
That will make a field with a max of what? 50 characters may be? Big
deal! ;-)
And...? It doesn't matter which types of data you store in those lists.
How would you return a workable query?
yeah, so the login will need access to the sys tables. If that is not
granted it will not work..?
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It
Im a little burnt out need some help.
If I query a table that tracks the number of times a book was checked out and
returned. I want to get the most recent item in the table to find the current
status of the book. So I can find out if it is checked in or out.
How do I write the SQL to
select top 1 *
from tablename
order by datefield desc
On 10/22/06, Chad Gray [EMAIL PROTECTED] wrote:
Im a little burnt out need some help.
If I query a table that tracks the number of times a book was checked out and
returned. I want to get the most recent item in the table to find
Thanks Kris! That makes sense.
-Original Message-
From: Kris Jones [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 22, 2006 10:12 AM
To: CF-Talk
Subject: Re: SQL Question
select top 1 *
from tablename
order by datefield desc
On 10/22/06, Chad Gray [EMAIL PROTECTED] wrote:
Pete,
I actually have a free tool (DataMgr) that does this (among other things).
http://www.bryantwebconsulting.com/presentations.cfm
http://www.bryantwebconsulting.com/cfcs/
Call the getDatabaseTables() method to get the non-system tables.
Call the getDBTableStruct(tablename) to get
Walter,
You are grouping by dateSigned which ensures that the min() and max() will be
the same (because you get a new record for each value of dateSigned).
Remove dateSigned from your select statement and your group by statement and
see if your results make more sense.
Steve Bryant.
Bryant
Walter Conti wrote:
cfquery name=getSigs datasource=firme
select signerName, signerLocation, signerComment, dateSigned,
MIN([dateSigned]) as startDate, MAX([dateSigned]) as endDate
from signatures
where signatures.petId ='#id#'
group by signerName, signerLocation, signerComment, dateSigned
I tried this (with the sample code) and it hung my cfserver, anyone else
have this? I didn't have enough time to play with it, but I'm curious if
someone else had similar experiences.
dov
-Original Message-
From: John Blayter [mailto:[EMAIL PROTECTED]
Sent: Friday, October 20, 2006 3:18
I don't think he can remove dateSigned from the group by statement,
since you must have all non-aggregate or subquery columns in the group
by statement.
I think he needs to look at his data in the fashion that the query is
grouping it. It may be the case that the min() and max() are the same
for
I don't know why buy I have seen it kill the server on certain
implimentations. I ended up changing the CF_ to CFMODULE calls and
that seemed to resolve it.
On 10/22/06, Katz, Dov B (IT) [EMAIL PROTECTED] wrote:
I tried this (with the sample code) and it hung my cfserver, anyone else
have this?
I've got a simple shopping cart that stores cart selections in a structure.
Works great. It simply checks for the itemID, then either adds the itemID if
not found or updates the quantity key if the itemID exists.
cfscript
tempvalue =
Using SQL Server 2000, is there any way to get (a) a list of
non-system table names for a given database, and (b) any way to get
the datatypes for database columns? This would be via two different
queries.
Although it is possible to get these information from SQL Server,
you may find it simpler
I don't think he can remove dateSigned from the group by statement
He should remove it from both the select AND the group statements.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to
What if a manager would like a printout of the days of the week and which
employees are available to work on each of those days.
If I worked for a company and had a manager liable to ask anything
after a project has been designed, then of course, I would take a belt
and suspenders
and use a
I always got this kind of information via the connection object and
metaData() function and Claude has always offered that
ODBC product. From the DSN use getConnection().getMetaData() I think.
On 10/22/06, Pete Ruckelshaus [EMAIL PROTECTED] wrote:
Nice, Steve, thanks! This will save me a lot
Nice, Steve, thanks! This will save me a lot of time.
Pete
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a
cfif entry.name EQ session.realUserName
cfdocument format=pdf
margintop = .5
marginbottom = 1
marginleft = .5
marginright = .5 !--- printing OK ---
cfelse
cfdocument format=pdf
margintop = .5
marginbottom = 1
marginleft = .5
marginright =
23 matches
Mail list logo
