How to Select all articles form a category without an article that is selected?

Hello,

i want to Select all articles form a category without an article that is selected.
Thanx a lot !
0
marius
6/7/2004 9:54:33 AM
asp.net.sql-datasource 29906 articles. 0 followers. Follow

1 Replies
642 Views

Similar Articles

[PageSpeed] 26

It's good what i'm thinkin?

select * from articles where idCategory = 1 AND IdArticle <> 5
???
:)
0
marius
6/7/2004 10:11:52 AM
Reply:

Similar Artilces:

SELECT from SELECT
Hi! I remember seeing an example where you can do a select from a nested select, but I cannot seem to make it work. So it would be something like this: select max( name ) from ( select name from customer union select name from vendor ) Was I dreaming I saw that? Thanks! D In article <4500243f@forums-2-dub>, daniel_AT_infrontsoftware_DOT_com@N0SPAM.com says... > Hi! > > I remember seeing an example where you can do a select from a nested > select, but I cannot seem to make it work. No, you weren't. Try (UNTESTED!) adding a...

Forms , Select and option selected.
Name: Jirrick Email: jurahudecatgmaildotcom Product: Firefox Release Candidate Summary: Forms , Select and option selected. Comments: I've found problem with SELECTED option in <select> forms. I wanted to use pre-selected option in my form , but when I used the Firefox 3 RC1 to render it there wasn't any preselected item. I tried to rewrite code ( use selected="selected" ) , but still no effect. I was confused and tried to use others viewers ( IE 8 , OP 9 , Konqueror ) and the pre-selected item worked well in these browsers. The bug has to be in FF 3 ...

Why is the select saying selected after an item is selected?
This was a whitelisting issue due to a software upgrade at hostgator..  Nothing wrong with my code..Scot King SEO Software Tool | Search Engine Optimization"Get your page rank high"  huh? It is smart to put your question in the body and not just in the title. Have no idea what your question is or if it even a question.Eric Pascarello.com | Twitter epascarello | LinkedIn use thisddl.options[ddl.selectedIndex].selected = false; //Clear the selection ddl.options[1].selected = trueMAKMark as Answer if this reply helps youMVP ASP/ASP.NetASP.Net Hosting : Host DepotMy Sit...

New article: using a multiple-select ListBox without the CTRL key
    Have you ever been frustrated by having to hold down CTRL while making selections from a long list?  Now you can save your clients from this little piece of frustration; this article shows you how. Cheers, Peter BrunoneMS MVP, ASP.NETFounder, EasyListBox.comDo the impossible, and go home early. Very nice!    thanks.Peter Kellnerhttp://73rdstreet.com and blogging athttp://PeterKellner.netMVP, ASP.NET...

Form: Focus on selected values in dropdownlists, Refresh after selection and hidding formfields based on selection.
Hello again,I have a form with several dropdown lists. Depending on the selected value in the dropdown lists other fields become available in that same form. It is working in classic ASP in combination of JavaScript. I want to migrate it to ASP.NET. I have posted a part of the form at the end of this post.My questions:1. I use <option <%If iFood="0" then%>selected<%End If%> value="0">No value selected</OPTION> to select the selected item when the form is reloaded after the selecting. I know that this also works in ASP.NET, but isn't there a typical ASP....

ReorderList Populating (without Object or SQL Datasource) using Selected Items from ListBox
Hi - I am trying to acheive a simple solution of Adding Items Listed in a ListBox one by one to the ReorderList Control.  In short my ReorderList Control is empty initially and I want to add items listed in the ListBox Control by clicking on a Button...something like...(as below)  Now I am able to acheive that but everytime I add one Layer the Session gets overwritten, which ofcourse I understand. Is there a way where in the layers whihc I have added still remains and the next layer I add to ReorderList gets appended to the Session List? (Somewhere on IDictionary or Hashtable lin...

select cheboxlist if any values are selected in sql
hello and thanks in advance,  I have a checkboxlist that is created dynamically from table1 once the records are inserted they are inserted in table2. i can save the values into the table and remove them if i uncheckd them that is working fine. the problem is to checked the items that have been selected already, how to i do this?? really really confuse...   here is the cs code; namespace IMS_2K9.Admin { public partial class Order_Charges : System.Web.UI.Page {private string connectionString = WebConfigurationManager.ConnectionStrings["IMSCon...

How to select a row without select button
Hi. I am use one Dataview in My Web site Now i Have 2 boubts , 1.How to get a Datagrid item values(All row values)in pageLoad event 2.How to select a row without using Select Button, i want to select a row on mouse click event Please give me a soulation TO SELECT A ROW ONCLICK: Firstly, you will need to enable row selections for your datagrid. this will place the proper javascript in your page for what is to come.  This will place a select button on your page, but you can convert that column into a template and make the linkbutton visible=false. you need a OnRowCreated ev...

Multiple Selects
Is it possible to specify more than one select in the Infomaker SQL Select Painter? Example: SELECT Tab1.Num FROM Tab1 SELECT Tab2.Ref FROM Tab2 If it is possible, please let me know how can I do that. If it isn't possible, how can I overcome this issue? Thanks and regards, Filipe Freitas Yes, inside a UNION. "Filipe Freitas" <filipe.freitas@hp.com> wrote in message news:435f98ea$1@forums-2-dub... > Is it possible to specify more than one select in the Infomaker SQL Select > Painter? > > Example: > SELECT Tab1.Num FROM Tab1 ...

Quick Select & SQL Select
What difference between "Quick Select" & "SQL Select" in DataWindow ? E-mail me PLS -- Leonid ANTISPAM ! SORRY!!! My e-mail is not correct: zzz_leo@softincom.ru Remove 'ZZZ_' from E-mail ICQ UIN: 7281017 Quick Select uses wizards and has limited capabilities. SQL Select is a point and click and lets you do a lot more. Plus you need to know the SQL Select approach if you want to modify a Quick Select after the initial creation. HTH, Mark -- Mark Pfeifer[Team PS] mpfeifer@sprynet.com ** ARE YOU READY FOR THE WEB...

superreview granted: [Bug 107776] NNTP error (like "400 Too_Many_Connections") seems to cache selected article even though the article is not download : [Attachment 174381] proposed fix
Scott MacGregor <mscott@mozilla.org> has granted David Bienvenu <bienvenu@nventure.com>'s request for superreview: Bug 107776: NNTP error (like "400 Too_Many_Connections") seems to cache selected article even though the article is not download https://bugzilla.mozilla.org/show_bug.cgi?id=107776 Attachment 174381: proposed fix https://bugzilla.mozilla.org/attachment.cgi?id=174381&action=edit ...

superreview requested: [Bug 107776] NNTP error (like "400 Too_Many_Connections") seems to cache selected article even though the article is not download : [Attachment 174381] proposed fix
David Bienvenu <bienvenu@nventure.com> has asked Scott MacGregor <mscott@mozilla.org> for superreview: Bug 107776: NNTP error (like "400 Too_Many_Connections") seems to cache selected article even though the article is not download https://bugzilla.mozilla.org/show_bug.cgi?id=107776 Attachment 174381: proposed fix https://bugzilla.mozilla.org/attachment.cgi?id=174381&action=edit ------- Additional Comments from David Bienvenu <bienvenu@nventure.com> if we get an error, doom the cache entry. Also, don't disconnect if the error is just article not...

Details view with a select box to select the categories
Hello, Thansk to all you that can reply this post.  What I need to do is very simple, I use to do in VB ASP before and now that I'm migrating to .net is not so simple. Here is what I need, I have some categories of products and some subcategories, the cat I select on a dropdownbox and on the details view show all the data on subcat. i have a key of relationship similar to cat. and subcat 1-infinit. Up to this point everything works fine, perhaps when I try to edit/update/insert a message error show: <asp:SqlDataSource ID="SqlDataSource2" runat="server&qu...

Select a gridview row without a select button
Hi Does anyone have a vb code sample of how to select a gridview row without having to click on a select button?   Thanks    ASPX <asp:label id="Label1" runat="server" /> <asp:gridview id="GridView1" runat="server" autogeneratecolumns="False" datakeynames="ProductID,ProductName" datasourceid="SqlDataSource1" style="margin-top: 12px;"> <columns> <asp:boundfield datafield="ProductID" headertext="ProductID" readonly="True" sort...

Web resources about - How to Select all articles form a category without an article that is selected? - asp.net.sql-datasource

Portal:Law/Nominate/Selected article - Wikipedia, the free encyclopedia
Add the article in to a subpage of this portal, such as Portal:Law/Selected article/# , replacing the "#" with the number above the current highest. ...

F8: Facebook’s FbStart Initiative Will Give Selected Developers A $30K Kick-Start
... successful applications is likely a whole lot easier with $30,000 in free tools and services to start off with, and that’s exactly what selected ...

LEGO Shop - The LEGO Technic team has selected the winner... - Facebook
The LEGO Technic team has selected the winner of the Co-Creation Challenge! LEGO will be producing a limited run of 20,000 of this stunning set.... ...

baby365- Grand Doctor Ma Selected Students for iPad on the iTunes App Store
Get baby365- Grand Doctor Ma Selected Students on the App Store. See screenshots and ratings, and read customer reviews.

Selected Cheney Vice Presidential Photographs
... for photos found within these albums are Paul Morse, Karen Ballard, Kimberlee Hewitt, Shealah Craighead, and Chris Greenberg. These selected ...

[iOS Advice] How To Clarify Your Email Replies By Quoting Selected Text - YouTube
Follow me on Twitter: http://www.twitter.com/macmixing Like my Facebook page: http://www.facebook.com/macmixing RATE, COMMENT, SUBSCRIBE! :-) ...

Sait Faik Abasıyanık’s Selected Stories are tales that beguile all for their brevity
The influential Turkish writer's collection of short stories is often bizzare but never boring.

Animal of the Day: Lucius Has Been Selected as the U.K.’s ‘Happiest Cat’
He’s got one blue eye, one green eye and a heart of gold. British mobile phone company O2 recently held some “cat auditions” to find “the UK’s ...

Michael Sam becomes first openly gay player selected in an NFL Draft
Defensive end Michael Sam of the University of Missouri became the first openly gay player to be selected in a National Football League Draft ...

Refugee spinner selected for PM's XI
Fawad Ahmed has gone from asylum seeker to rubbing shoulders with Julia Gillard at The Lodge.

Resources last updated: 12/12/2015 9:23:40 AM