C# Discussion Boards - CodeProject

SomeGuyThatIsMe1-Aug-11 2:45

1-Aug-11 2:45

in sql server, both of those dates default the time to midnight, not sure bout other db's but i assume its the same. If all you have is the one date you can use a some DATEADD function to add a day to it and just make the query Tdate < date + 1. all the db's i've seen have some form of that function as do most popular languages..even javascript can do it.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: find data between 2 dates

PIEBALDconsult1-Aug-11 2:52

PIEBALDconsult

1-Aug-11 2:52

goldsoft wrote:
filed that hold date in short format in this format: `01/08/2011`

Don't store dates as text/char; use a proper date/datetime datatype.

goldsoft wrote:
and hold `01/08/2011`

No, it holds a proper DateTime value; it simply displays the value in that format (or any other).

goldsoft wrote:
>= #01/08/2011# and Tdate <= #01/08/2011#

Use a parameterized query.
Those two values are the same, so you will only get rows with exactly that value. You could use the AddDays method of the DateTime type to calculate the second value.

Re: find data between 2 dates

OriginalGriff1-Aug-11 8:34

OriginalGriff

1-Aug-11 8:34

As PIEBALDconsult said, store dates and times in a proper DateTime, and hand them through as parameters.

It is also worth noting that Access (like every other database I have seen) uses ISO format for dates anyway: yyyy-MM-dd so the query you tried would not work as the date format would cause an error.

Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.

Manfred R. Bihy: "Looks as if OP is learning resistant."

Re: find data between 2 dates

#realJSOP1-Aug-11 9:54

#realJSOP

1-Aug-11 9:54

This is a SQL question, not a C# question.

You want to use the BETWEEN keyword in your SQL query:

SQL

select * from table where table1.datecolumn BETWEEN date1 AND date2

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997

select query proble

love yadav30-Jul-11 20:13

love yadav

30-Jul-11 20:13

what is the right way to fetch only one record from the table where many records of same types exist there ?

Re: select query proble

PIEBALDconsult30-Jul-11 20:56

PIEBALDconsult

30-Jul-11 20:56

Because you asked in this forum, rather than the Database forum, I assume you mean a DataTable, not a database table, where an SQL solution would be appropriate, so I will recommend you look at Linq and select and take in particular.

If you are looking for SQL please post in the Database forum. I'll still help you there, although I should be asleep already.

Re: select query proble

GuyThiebaut31-Jul-11 3:12

GuyThiebaut

31-Jul-11 3:12

The generic answer is to use a cursor.
Specifically it really depends on the database engine - for instance in Oracle PL/SQL you can use a loop command to iterate through a table.

Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)

Re: select query proble

Not Active31-Jul-11 5:25

Not Active

31-Jul-11 5:25

There are many other ways besides using a cursor, which have inherent problems depending on the situation.

I know the language. I've read a book. - _Madmatt

Re: select query proble

jschell1-Aug-11 8:20

jschell

1-Aug-11 8:20

GuyThiebaut wrote:
The generic answer is to use a cursor.

That doesn't sound like a good idea to me.

All major databases provide alternatives to that. Oracle certainly does.

At this point I am not sure that answer isn't just wrong.

Re: select query proble

GuyThiebaut1-Aug-11 8:25

GuyThiebaut

1-Aug-11 8:25

I think I may be misunderstanding his question - I understood him to be asking how does one iterate through a result that returns multiple rows one row at a time...

Since it does not sound like a good idea, to you, could you provide me with better suggestions please as I always want to learn from my mistakes - thanks.

Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)

Re: select query proble

jschell2-Aug-11 9:19

jschell

2-Aug-11 9:19

If you want to return one record then you should construct the query to do just that.

Re: select query proble

GuyThiebaut2-Aug-11 9:23

GuyThiebaut

2-Aug-11 9:23

Sure but given:
"I understood him to be asking how does one iterate through a result that returns multiple rows one row at a time"

How would you do this without a cursor?

Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)

Re: select query proble

jschell3-Aug-11 9:49

jschell

3-Aug-11 9:49

This is the C# forum.

So the correct way to do that would be to return the result set (complete or subset) and interate it in C#.

But if one wants to return on record then one structures the query appropriately.

Re: select query proble [modified]

Shameel31-Jul-11 5:16

Shameel

31-Jul-11 5:16

The easiest way is to use the DISTINCT clause.

EDIT: I do not know who downvoted my answer and why. But let me explain to you why I suggested DISTINCT and not TOP as suggested by other posters. A part of the question is

love yadav wrote:
where many records of same types exist

That means the OP wants to return one record from each type (each set of distinct values) and not just the first row. TOP 1 will return just the first row not matter how many distinct values are there in the result set.

modified on Sunday, July 31, 2011 11:42 PM

Re: select query proble

Richard Andrew x6431-Jul-11 6:33

Richard Andrew x64

31-Jul-11 6:33

If you're using MySQL, you can say Limit 1

The difficult we do right away...
...the impossible takes slightly longer.

Re: select query proble

dan!sh 31-Jul-11 6:59

dan!sh

31-Jul-11 6:59

Top (1) could be an option. If you are talking about LINQ, try FirstOrDefault.

"The worst code you'll come across is code you wrote last year.", wizardzz[^]

database releted question

love yadav30-Jul-11 19:45

love yadav

30-Jul-11 19:45

what i do to retrive the primary key of table which is autoincreamented in the table

Re: database releted question

PIEBALDconsult30-Jul-11 20:12

PIEBALDconsult

30-Jul-11 20:12

Drop back and punt.

Most poeple ask in the Database forum[^], as here[^].

Re: database releted question

Dave Kreskowiak31-Jul-11 4:26

Dave Kreskowiak

31-Jul-11 4:26

Your going to have to describe a bit more what you're trying to do. Getting the value of the key depends on what you're really trying to retrieve and do with it.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: database releted question

Abhinav S31-Jul-11 5:35

Abhinav S

31-Jul-11 5:35

By using @@Identity - see http://msdn.microsoft.com/en-us/library/ms187342.aspx[^].

Too much of heaven can bring you underground
Heaven can always turn around
Too much of heaven, our life is all hell bound
Heaven, the kill that makes no sound

Re: database releted question

Shameel31-Jul-11 7:28

Shameel

31-Jul-11 7:28

There are three ways and each has a slightly different meaning:
1. SCOPE_IDENTITY()
2. @@IDENTITY
3. IDENT_CURRENT()

To know more, google these terms.

MP3 Trimming

gmhanna30-Jul-11 4:51

gmhanna

30-Jul-11 4:51

Hi,

I am working on a project where I receive an MP3 file used in the broadcast industry. However sometimes the MP3 file has dead air so to speak at the beginning and end of the file. I would like to be able to trim this automatically so that I can calculate the appropriate length of the MP3 file, and not broadcast the dead air.

Any idea how to trim the MP3 on both ends for silence?

Thank you and much appreciated,

Glenn

Re: MP3 Trimming [modified]

GuyThiebaut30-Jul-11 7:34

GuyThiebaut

30-Jul-11 7:34

google search result for C# MP3 Trim[^]2nd result on first page...

Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)

modified on Saturday, July 30, 2011 1:42 PM

Re: MP3 Trimming

Ravi Bhavnani31-Jul-11 5:11

Ravi Bhavnani

31-Jul-11 5:11

Along with Guy's response, this[^] article may help in determining the points where the silence ends and begins.

/ravi

My new year resolution: 2048 x 1536
Home | Articles | My .NET bits | Freeware
ravib(at)ravib(dot)com

Web Get Requests

gmhanna30-Jul-11 4:47

gmhanna

30-Jul-11 4:47

Hi,

I'm a bit puzzled here and feel silly asking this question. I know how to open a new URL, read the response back from the web, etc if I initiate the request. Where I'm stuck is how do I do this if I don't initiate the request.

Here is what I'm trying to do. A distribution center is going to call my Web Server via a Web Service. I'm supposed to obtain the fields of information they are passing to me via a Web GET request. How is this done?

Thank you,

Glenn

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.