You searched for the word(s): userid:666313

More Search Options

RSS Available

• Re: Joining a table to itself based on a condition

  Ok, it may be easier if I explain what my end goal is: There will be several grade rows for a student and a module. If one of the rows has a resit (they failed and assessment and must do it again) flag against it, then all the other rows for that student and module must also be flagged as resit. The UPDATE statement needed to do this obviously needs to take into account a sub-query. My first example was to first SELECT the appropriate records to see if the data was correct before attempting to UPDATE

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by rcaine on 9/3/2008

• Joining a table to itself based on a condition

  Hello, I am trying to find rows in a table where they match a value from other rows in the same table. Essentially, I have a student grades table where for a given student, one of the grades may have a resit flag against it. I want to find all other rows for the student based on this resit flag row. I have tried LEFT OUTER JOINing the grades table to itself where the right table is finding the the resit flagged row but this just gives me a load of duplicate rows. Is this possible? Can it be done

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by rcaine on 9/3/2008

• Re: File DOWNLOAD function with UpdatePanel/UpdateProgress

  Thanks for your input. The file I'm sending down to the client doesn't physically exist, its a .xls that is generated by the application from a DataTable. I was wondering whether the Response.Clear() and Response.ContentType commands were interfering with the asynchronous postback/response... I'd also like to stick to using AJAX control toolkit controls if possible. My Code: 1 protected void lnkRepStudsMods_Click( object sender, EventArgs e) 2 { 3 lnkRepStudsMods.Enabled = false ; 4 UpdatePanel1

  Posted to ASP.NET AJAX Control Toolkit (Forum) by rcaine on 5/23/2008

• File DOWNLOAD function with UpdatePanel/UpdateProgress

  Hi, I have a reports page on my web app which when a linkbutton is clicked, results in a dynamically generated excel file being downloaded. This works great although because of the query involved, takes several seconds to complete. I'm trying to make the UI more responsive and inform the user that the job is being completed and so have surrounded the linkbutton with an UpdatePanel with an associated UpdateProgress (simply with "working..." in it). The upshot is that the generated file

  Posted to ASP.NET AJAX Control Toolkit (Forum) by rcaine on 5/22/2008
  Filed under: Ajax updatepanel updateprogress file download

• Re: Finding rows with missing related rows

  Thanks both. I actually twigged onto DotNetAdvisor's method as I clicked the Post button lol nikki_doer_of_things, your second method was along the lines I was thinking of when I was trying to search for an example. Could either your 2 methods be including in a delete query?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by rcaine on 4/2/2008

• Finding rows with missing related rows

  Hi, I need to write a query which I have never attempted before and could do with some help.... I have a Groups table and a Users_Groups look up table. In this model, users can only be assigned to 1 group. If a group is deleted, a trigger should fire and delete any rows in User_Groups having a matching Groups.Ref. Unfortunately, the trigger hasn't been firing and I now have a load of defunct rows in Users_Groups relating users to groups which do not exist. I now need to find all of these defunct

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by rcaine on 4/2/2008

• Re: Ajax with Web Services - JS proxy doesn't work

  Hi, I used the fully qualified namespace when calling the web method in my clientside code. If you look at my 2nd post at the pageLoad() method I orignially referred to by just using ret = WebService1.HelloWorld(OnCompleteHW, OnTimeOut, OnError); I got it to work using: ret = My.Complete.Namespace.WebService1.HelloWorld(OnCompleteHW, OnTimeOut, OnError);

  Posted to ASP.NET AJAX Discussion and Suggestions (Forum) by rcaine on 11/16/2007

• Re: Ajax with Web Services - JS proxy doesn't work

  Got it I switched the ServiceReference to create InlineScript for the proxy class. I then viewed source of the rendered page to find the the proxy definition was fully namespace qualified. I changed my JS webservice reference from WebService1 to My.Long.Namespace.WebService1 and it worked! Considering the ASP form and the web service are in the same namespace, I consider this a little odd, but at least its working now. All the examples I've seen (including Joe Stagner's) didn't need to

  Posted to ASP.NET AJAX Discussion and Suggestions (Forum) by rcaine on 9/11/2007

• Re: Ajax with Web Services - JS proxy doesn't work

  Hi, I have since checked all naming and references to my webservice including the actual filename. All are now "WebService1.asmx" or "WebService1". I'm still getting the same problem though. The scriptmanager seems to be working fine as the pageLoad() event is firing. There just appears to be a problem with AJAX.NET creating the client proxy object for the web service.... Sections from my web.config: < httpHandlers > < remove verb= "*" path= "*.asmx"

  Posted to ASP.NET AJAX Discussion and Suggestions (Forum) by rcaine on 9/11/2007

• Re: Ajax with Web Services - JS proxy doesn't work

  Hi, Here is my very simple testing webservice: [WebService(Namespace = "http: //tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.Web.Script.Services.ScriptService()] [ToolboxItem(false)] public class WebService1 : System.Web.Services.WebService { [WebMethod] public string HelloWorld() { return " Hello World "; } [WebMethod] public string GoodBye() { return " Good Bye World"; } } My ASPX page: <%@ Page Language="C#" AutoEventWireup

  Posted to ASP.NET AJAX Discussion and Suggestions (Forum) by rcaine on 9/11/2007