query question

[lucidtech]

I'm trying to pull records from a database where the data in a column is the same date as today. Am I missing something here because I keep getting an error...

<cfquery name="test">
SELECT last_date
FROM users
WHERE <cfoutput>DateDiff("d", last_date, now())</cfoutput> = <cfqueryparam value="0" cfsqltype="cf_sql_integer">
</cfquery>

 

[r937]

which database? db2? informix? sybase? firebird? postgresql?

no, let me guess -- microsoft access

WHERE last_date = Date()

by the way, have a look at your SELECT clause

all you are pulling out is the date, which you already know is going to equal today!

how useful can that be???

r937.com | rudy.ca

 

[lucidtech]

Thank you for the help... I'm not pulling the date, I just posted a hypothetical query.

 

[r937]

so did it work for you, what i posted?

r937.com | rudy.ca

 

[lucidtech]

It didn't work necessarily, but that is not fault of your own. I'm a bit stubborn when it comes to figuring things out for myself (I just retain the knowledge better that way) so I didn't post exactly what I needed, but your post definitely made me think outside the box so to speak, and made me realize there is another way to do it.

I was trying to check which users had been online in the last hour actually... and by setting a date to match today and a time that matches an hour ago as variables, I can use them in the WHERE clause to get my result.

Thanks again. I was bumming for a while there cuz it seemed to me that this site was down for a month or so, and I come here to get help a lot.

 

[r937]

remind me never to answer any of your questions again



r937.com | rudy.ca

 

[lucidtech]

Will do... anyone who would rather me just be told how to do something rather than have me learn for myself should do the same. LOL