ansaurus

Question

Answer 1

A:

Looks like you are missing a bracket. Try:

.Where("Month(SubmittedOn)").IsEqualTo("Month(getdate())")

RedFilter 2009-05-20 15:28:08

Good catch, but that doesn't seem to fix it:SubSonic.SqlQueryException: Conversion failed when converting the varchar value 'Month(getdate())' to data type int.

Scott 2009-05-20 15:32:00

I don't know SubSonic, but can you rewrite it as:.Where("Month(SubmittedOn) = Month(getdate())")

RedFilter 2009-05-20 15:54:07

Answer 2

A:

You can only pass in a value to a constraint method (IsEqualTo) in SubSonic so the following will get all the rows submitted in March:

.Where("Month(SubmittedOn)").IsEqualTo(3)

The following will get all rows submitted in the current month:

.Where("Month(SubmittedOn)").IsEqualTo(DateTime.Now.Month)

Adam 2009-05-21 16:24:34

I am trying to only search by one column. I have a table with a 'SubmittedOn' DateTime column and I want to return all records that happened in the current month. In SQL MONTH(getdate()) will return the current month because MONTH is a SQL function. Here is the SQL code:SELECT * FROM Awards WHERE MONTH(SubmittedOn) = MONTH(getdate())Eventually I need to get the year in there too, but I can figure that out once I have the month in there: AND Year(SubmittedOn)=Year(GETDATE())Also: what are the code tags if I want to enter code into StackOverflow like the user in the first answer?

Scott 2009-05-22 18:35:20

OK I think I see what you're trying to do now and I've updated my answer. You get code formatting by putting four spaces in front of each line you want formatted.

Adam 2009-05-22 18:55:33

Thanks that was it!

Scott 2009-05-26 14:26:19

ansaurus

tags:

views:

answers:

Custom where clause with a string?

related questions