Help with Select Query in ado.net

Question

I have got a table(newsImages) with columns newsID(Foreign Key) , newsImage , imageID(primary Key), What my query is Select newsImage From newsImages Where newsID = 'something'

The query returns all the images with specific newsID, What I want is to remove a row who has image named"something" from the resultant query. Any help or suggestion will be appreciated

i dont want to delete it from database, i want to remove it from displaying in the results — Mr A
– Mr A, Commented May 19, 2011 at 15:11

Mongus Pong · Accepted Answer · 2011-05-19 15:09:55Z

1

You would do

DELETE FROM newsImage
WHERE newsID = 'something'

But be careful, it looks as though your ID field is a text field.

Are you sure that the ID field is guaranteed to be unique? Is it defined as a Primary Key? If not you may have several rows with the same ID and you may delete more than you were expecting to.

EDIT

Ah, ok

SELECT newsImage From newsImages 
Where newsID = 'something'
AND newsName <> 'somethingElse'

answered May 19, 2011 at 15:09

Mongus Pong

11.5k9 gold badges47 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mr A Over a year ago

i dont want to delete it from database, i want to remove it from displaying in the results

Mr A Over a year ago

<> , what does dat stands for

Mongus Pong Over a year ago

<> means not equal to. (the opposite of =) so this query will not return any rows where newsName equals 'somethingElse'

Robb · Accepted Answer · 2011-05-19 15:10:14Z

1

To select everything but the newsImage with id 'something'

 Select newsImage From newsImages Where newsID <> 'something'

to delete newsImage with ID 'something' from the table newsImages

 delete from newsImages where newsID = 'something'

answered May 19, 2011 at 15:10

Robb

3,8511 gold badge38 silver badges39 bronze badges

2 Comments

Mr A Over a year ago

i dont want to delete it from database, i want to remove it from displaying in the results

Robb Over a year ago

@Muhammad Awais - I thought that might be the case that's why i wrote the first query which selects everything except the newsImage with ID 'something'

Chris · Accepted Answer · 2011-05-19 15:10:49Z

1

SELECT * FROM newsImages WHERE newsImage <> "something" AND newsID = <value>;

answered May 19, 2011 at 15:10

Chris

5702 gold badges4 silver badges20 bronze badges

2 Comments

Mr A Over a year ago

i dont want to delete it from database, i want to remove it from displaying in the results

Chris Over a year ago

Are you removing rows based on the results?

Collectives™ on Stack Overflow

Help with Select Query in ado.net

3 Answers 3

3 Comments

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related