its taking more than two columns combined distinct

i have a query in sql2000 if i want to select distinct scid,requirement,comments from table1 i am not getting distinct rows . distinct keyword is not working .can you please give me some clue.it is urgent.

i want to pass and(SafetyCases.Link Like '%DL.125%' or SafetyCases.Link Like '%DL.233%' or SafetyCases.Link Like '%DL.256%' or SafetyCases.Link Like '%DL.259%' or SafetyCases.Link Like '%DL.288%' or SafetyCases.Link Like '%DL.518%' or SafetyCases.Link Like '%DL.534%' or SafetyCases.Link Like '%DL.538%' or SafetyCases.Link Like '%DL.67%' or SafetyCases.Link Like '%DL.68%' or SafetyCases.Link Like '%DL.683%' or SafetyCases.Link Like '%DL.777%' or SafetyCases.Link Like '%DL.800%') as parameter to my stored procedure can i do and how ?

in each row's cell i can have more than one hyperlink so how to get this.

If the files are too big add this in web.config file <httpRuntime maxRequestLength="100000" executionTimeout="9000"/>

i am working on word macro in which i have to select few heading1 complete content and paste it into other document. In the document in every heading 1 i have placed bookmarks for start and end . So how to pick up the text . Private Sub CommandButton3_Click() Dim a As String Dim iCnt As Integer a = "" Application.ScreenUpdating = False Selection.HomeKey Unit:=wdStory Selection.Find.ClearFormatting Selection.Find.Style = ActiveDocument.Styles("Heading 1") Selection.MoveDown Unit:=wdWindow, Count:=1, Extend:=wdExtend 'With ActiveDocument.Select 'With Selection.SetRange Start:=Selection.Start, End:=ActiveDocument.Content.End Dim Label As String Do While Selection.Find.Execute With Selection.Find fndrepl "<#T" If .Find.Found Then iCnt = .MoveEndUntil("#>") If iCnt = 0 Then MsgBox "No closing tag found", vbOKOnly, "Error..." Exit Do End If .MoveRight wdCharacter, 2, wdExtend a = Selection.Text End If End With Loop End Sub

i am working on word macro. i have to copy down selected headings from one document into another. For that i want to read heading 1 so as to display them on labels on a form . Can anyone guide me in this.

i know that all since i have been working in javascripting for long . bUT could not enable and disable image control on selection of radio button.

through javascripting i want to enable and disabled a image button.

that is what i am not getting.

<asp:ImageButton ID="imgbtnFromDate" runat="server" enabled="false" ImageUrl="~/Images/SmallCalendar.gif" /> I have this image button . On click of the radio button which i am getting how can i get this button enabled. i want to do this through javascripting.

<asp:ImageButton ID="imgbtnFromDate" runat="server" enabled="false" ImageUrl="~/Images/SmallCalendar.gif" /> I have this image button . On click of the radio button which i am getting how can i get this button enabled. i want to do this through javascripting.

<asp:TemplateField > <ItemTemplate> <%-- <asp:LinkButton ID="lnkReplyHeading" runat="server" ><%# DataBinder.Eval(Container.DataItem,"u.username") %></asp:LinkButton>--%> <asp:LinkButton id="lnkusername" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"u.username")%>' commandname="ss" > </asp:LinkButton> </ItemTemplate> </asp:TemplateField> System.Data.DataRowView' does not contain a property with the name 'u'.

modified on Tuesday, February 19, 2008 8:43 AM

SELECT distinct u.domain,u.username, count(d.downloadid) as DocumentCount FROM primaryusertable AS u inner join tbluseraccessinfo a on(u.userid=a.userid and a.courntryid=51 ) right join download d on(u.userid = d.userid and CDate( d.downloadutctime) <now()) group by u.username, u.domain it is not working giving syntax error. i could not use inner and right join together in access database

SELECT DISTINCT u.domain, u.username, count(d.downloadid) AS DocumentCount FROM primaryusertable AS u RIGHT JOIN download AS d ON u.userid=d.userid WHERE CDate([d.downloadutctime])>= CDate(#2/2/2008#) And CDate([d.downloadutctime])<=CDate(#2/15/2008#) GROUP BY u.username, u.domain; by this query i am not getting date equal including it is only > and < no =.

Options is giving null some error

<asp:RadioButtonList ID="rdDateSelection" visible="true" AutoPostBack="true" runat="server" RepeatDirection="vertical" > <asp:ListItem Value="Today">Today</asp:ListItem> <asp:ListItem Value="FromToDate">From </asp:ListItem> </asp:RadioButtonList> through javascripting i want ot find out which radio the user has clicked .

actually i want to log in the database that the file is downloaded or opened and not if it is cancelled. Please if you have any ideas pls let me know. :((

Response.Clear(); Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name); Response.AddHeader("Content-Length", file.Length.ToString()); Response.ContentType = "application/octet-stream"; Response.End(); By this code we get download dialog box.There are three buttons cancel,open and save. How to find out whether user had pressed cancel or open/save.

by this i am gettin ipaddress of the server . I want ipaddress of the machine . LIKE i am using the website so i should get ipaddress of my machine.