ColdFusion Programmer wrote:
>
> #DateFormat(Now()-7,"/mm/dd")# - #qTmp.DateTime#
>
> SELECT UserName, SearchString, Count(SearchString) AS Occurences
> FROM qTmp
> WHERE < DateTime
> GROUP BY UserName, SearchString
>
Any NULLs in qTmp? What datatype is DateTime in the database?
first of all, whats this?
#DateFormat(Now()-7,"/mm/dd")# - #qTmp.DateTime#
dateAdd() needs to be in there for the -7 thing to work.
here is the below in correct format.
SELECT UserName, SearchString, Count(SearchString) AS Occurences
FROM qTmp
WHERE '#dateFormat(dateAdd('d',Now(),
ok so format that value, with dateFormat, enclose it in 's and you should be
good.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: Friday, Octo
whats the value of dateTime parse out to?
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 9:32 AM
To: CF-Talk
Subject
its because of the odbc datetime format that that will give you...the
getDate function that is...and the qOfq prolly doesn't like that? try,
adding a dateFormat() around that, so that its in a format the qOfq will
jive with.
SELECT UserName,
SearchString,
Count(SearchString) A
tions architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:56 AM
To: CF-Talk
Subject: RE: SQL Statement help!
Tony Weeg wrote:
> I guess standards matter in some ca
Tony Weeg wrote:
> I guess standards matter in some cases, but, jochem, this is fairly
> clear in its descriptive text of a function available to sql server
> programmers.
>
> --from transact sql help docs-
Transact SQL <> SQL
Why do you think I explicitly refered Alla
Tony Weeg wrote:
> and besides that, what are the values that you are expecting
> to do a subtraction operation with?
>
> to me, I don't see how, (#Now()# - DateTime) would make sense
> regardless.
In full featured databases, they return an interval. Unfortunately,
neither Java nor JDBC has an in
Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:39 AM
To: CF-Talk
Subject: RE: SQL Statement help!
Tony Weeg wrote:
> now() isnt a sql function, getDate() is tho' :)
Neither are SQL functions (copies of ISO 9075-2:1999 are available through
your national standards orga
getDate isnt?
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:39 AM
To: CF-Talk
Subject: RE: SQL Statement help!
Tony
Tony Weeg wrote:
> now() isnt a sql function, getDate() is tho' :)
Neither are SQL functions (copies of ISO 9075-2:1999 are available
through your national standards organisation).
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
ssage-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:34 AM
To: CF-Talk
Subject: RE: SQL Statement help!
now() isnt a sql function, getDate() is tho' :)
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548
now() isnt a sql function, getDate() is tho' :)
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:35 AM
To: CF-Talk
Su
"from where" doesn't jive.
SELECT UserName, SearchString, Count(SearchString) AS Occurences
FROM yourTableName
WHERE (#DateFormat(Now(),"/mm/dd")#
#TimeFormat(Now(),"HH:mm:ss")# - #qTmp.DateTime#) < 7 qTmp
GROUP BY UserName, SearchString
replace, yourTableName, with, wellyour t
Allan Clarke wrote:
>
> I have this table that keps a log
> of the user search activity. For ex, on the site
> search page of the site, if a user searches for
> a keyword "test", it gets stored on the database table
> along with other details like the
> username, date/time, search category and the
I was wondering if the SQL gurus out there could help.
I have this table that keps a log
of the user search activity. For ex, on the site
search page of the site, if a user searches for
a keyword "test", it gets stored on the database table
along with other details like the
username, date/time, sea
16 matches
Mail list logo
