Have you tried using the DATEPART() Transact-SQL function?
SELECT ID, FirstName, LastName, DateCreated
FROM Contact
WHERE DATEPART(m,DateCreated) = 7
The above query will return all Contacts create in the month of July
(for any year).
Here are the details for the DATEPART() function:
Try this:
SELECT CAST(Month(myDate) AS varchar) + '/'
+ CAST(Day(myDate) AS varchar) + '/'
+ CAST(Year(myDate) AS varchar)
Works for me in SQL 2000.
SCOTT VAN VLIET
BRD.WRKS INTERACTIVE
T: 714.469.6805
E: [EMAIL PROTECTED]
-Original Message-
From: Brook Davies
You can simply nest SELECT STATEMENTS:
cfquery name=selTotals datasource=#Request.Datasource#
SELECT (SELECT COUNT(*) FROM Products) As ProductCount,
(SELECT COUNT(*) FROM Brand) As BrandCount
/cfquery
Note that you can nest any number of sub-statements in the SELECT
You can escape double quotes in CFML simply by using two quotes next to
each other:
cfset myString = This is my string
In other languages, such as JavaScript, this can be done using a
backslash:
var myString = This is \my\ string;
You should also remove the ##'s from the variable,
Hey List People,
I posted a message to this list a couple of months ago about the CFML
Toolkit for Flash, which allows ColdFusion developers to use CFML functions
and syntax in Flash ActionScript.
With help from several kind and gracious members of this list, we are almost
finished with the
Here is an excerpt a Macromedia DesDev article about running CFMX in
Distributed Mode:
snip
10. On the application server computer, open the
cf_root\runtime\servers\default\SERVER-INF\jrun.xml file and locate
the following code:
...
service
After playing around for a little while, I realized that you could just
manipulate the CFID and CFTOKEN cookies to view each Session's data.
Check it out here: http://www.valsurf.com/sessionBrowser
The only thing that I came across is that you will always be able to
view Session data for each
I am in the midst of developing a toolset that will allow ColdFusion
developers to write Flash MX applications with familiar objects, functions,
and even CF tags - called CFMXTK. This includes support for the
CFAPPLICATION framework (including Application AND Session Management),
ColdFusion
CF-Talk,
For those who've already downloaded Beta 2 of CF_DEBUG, please check out
the latest version, Beta 3, from the link at the end of this message.
For those of you who haven't used CF_DEBUG, here's the low-down.
CF_DEBUG is a unique, portable tool for debugging ColdFusion
applications.
CF-Talk,
We have created a unique tool for debugging ColdFusion applications, CF_DEBUG. This
tag allows developers to organize, manage and maintain their debugging code within an
application without placing this information directly in structured HTML layout and CF
code.
CF_DEBUG will also
Well, you can try ditching the space at the beginning of the arguments.
Also, you can write the generated output to a file.
CFEXECUTE ... OUTPUTFILE=C:\CFEXE.log
/CFEXECUTE
HTH.
SCOTT VAN VLIET
BRD.WRKS INTERACTIVE
T: 714.469.6805
E: [EMAIL PROTECTED]
-Original Message-
From:
Does anyone know what this tag does? I was able to deduce that it had
an attribute, ACTION which could be either BREAK, LEAK, PCODE,
REPORTSTATE, SETBREAKALLOC and WRITEOUTPUT. Each ACTION has its own
attributes, but I don't know what each of these actions does - morever
what it outputs (as I
Mike,
Are you asking to create an Access Database (.mdb file), or just to
create a additional table in an existing Access DB?
See ya tomorrow!
Scott
SCOTT VAN VLIET
BRD.WRKS INTERACTIVE
T: 714.469.6805
E: [EMAIL PROTECTED]
-Original Message-
From: Mike Brunt [mailto:[EMAIL
Wish MX was the case, however this is for a project that has to be done
ASAP (on CF5). Ben, please tell me there's a hack for 5!
Thanks!
SCOTT VAN VLIET
BRD.WRKS INTERACTIVE
T: 714.469.6805
E: [EMAIL PROTECTED]
-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]]
it in the OnRequestEnd.cfm.
Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net
-Original Message-
From: Boardworks Interactive [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 10:12 PM
To: CF-Talk
Subject: RE: Execution Time
Wish MX was the case, however this is for a project
Has anyone had success with anti-aliasing text when using CFX_Image? I
am using CF 5 Pro on Windows 2000 Server. TIA!
SCOTT VAN VLIET
BRD.WRKS INTERACTIVE
T: 714.469.6805
E: [EMAIL PROTECTED]
__
This list and all
I've already got this down, I was just wondering about the uploading and
re-replacing the CF-Generated (ACF54.gif, etc.) images into the HTML
Text String. I know what needs to be done, I am just being lazy, and
was hoping that there was a Custom Tag of UDF to make my life easier ^_^
SCOTT
17 matches
Mail list logo