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

More Search Options

RSS Available

• Sql Query Help with 3 Unrelated Tables

  Hello, I am requesting help constructing a query that pulls fields from 3 unrelated tables and displays them in an inventory report of sorts. I will create 3 fictitious tables as an example: WritingUtensils LocationId SubmissionDate Pens Pencils Highlighters 1 11/1/2009 250 200 80 2 11/3/2009 175 220 40 3 11/5/2009 200 120 55 Media LocationId SubmissionDate CDs DVDs 1 11/1/2009 80 10 1 11/8/2009 70 8 3 11/8/2009 70 0 Paper LocationId SubmissionDate PostItNotes Notepads PrinterPaper 1 11/1/2009 40

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Rossoneri on 11/21/2009

• Re: Sql Query Help with 3 Unrelated Tables

  The Stored Procedure produces the output, but I should have specified I can't use a SP. The query just above was close, but produced too many rows. However, it pointed me in exactly the right direction. I modified it slightly and was able to produce the output. Thanks for all the assistance! DECLARE @WritingUtensils TABLE ( LocationId INT, SubmissionDate DATETIME, Pens INT, Pencils INT, Highlighters INT ) INSERT INTO @WritingUtensils SELECT 1,'11/1/2009',250,200,80 UNION ALL SELECT 2

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Rossoneri on 11/21/2009

• Re: Ajax/Scripts aren't working with 3.5

  OK, I think it is resolved. I followed the advice found in the last post here. I made a check against System.Web.HttpContext.Current.Session instead of just Session. After that the scripts all worked. Strange issue. http://www.velocityreviews.com/forums/t282576-aspnet-20-session-availability-in-globalasax.html

  Posted to ASP.NET AJAX UI (Forum) by Rossoneri on 6/11/2009

• Re: Ajax/Scripts aren't working with 3.5

  I already did that. Here is some additional info from the Firefox JS console: Error: WebForm_AutoFocus is not defined Error: Sys is not defined Error: ASP.NET Ajax client-side framework failed to load. I have narrowed it down to something in my Global.asax file, specifically the following void Application_PreRequestHandlerExecute( object sender, EventArgs e ) { if ( Session[ "Culture" ] != null ) Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture( Session[ "Culture"

  Posted to ASP.NET AJAX UI (Forum) by Rossoneri on 6/11/2009

• Ajax/Scripts aren't working with 3.5

  I am having a lot of trouble getting Ajax to work withthe 3.5 framework. Here is the problem I am having Locally, I seem to only have problems with the ConfirmButton. It only wants to work some of the time. Seems to just kick in randomly. I have both VS 2005 and 2008 running. However, after publishing to the production server, nothing works. I can't get an UpdatePanel to work, I can't get the ConfirmButton to work. In fact, I can't even get the TextBox.Focus() method to work. I have referenced

  Posted to ASP.NET AJAX UI (Forum) by Rossoneri on 6/10/2009

• Re: Localization and Validating Integers

  I found System.Globalization.NumberStyles.Any (or System.Globalization.NumberStyles.AllowThousands) and when I add this into the parse method, it seems to be working.

  Posted to Localization (Forum) by Rossoneri on 6/8/2009

• Localization and Validating Integers

  I am having trouble validating Integers. I can't seem to get the CompareValidator to work, so I tried my own custom control, and I still cannot get it to work. Here is an example: In Global.asax: void Application_BeginRequest( object sender, EventArgs e ) { Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture( "fr-FR" ); } In my webform, I display a value from a class: txtAmount.Text = string .Format( "{0:n0}" , program.Amount ); Amount is an Int32 property

  Posted to Localization (Forum) by Rossoneri on 6/8/2009

• Re: DefaultButton in UpdatePanel

  The panel in question does in fact have a mixture of ImageButton's and Buttons. The ImageButton(s) are firing when pressing Enter as they come first.

  Posted to ASP.NET AJAX Discussion and Suggestions (Forum) by Rossoneri on 6/18/2007

• Re: DefaultButton in UpdatePanel

  Yes, anyone? I would hate to have to take the UpdatePanels off the site, but if it is the difference between the site working properly in all browsers, the choice is easy.

  Posted to ASP.NET AJAX Discussion and Suggestions (Forum) by Rossoneri on 6/18/2007

• Re: Database Design Question

  Thanks. That is how I was going to design it as well. The administration will basically be handled using Access (blah) and I won't be responsible for designing that form per se. There is no web front end to this thing. Option 1 is how they are used to doing things, but I needed to be able to explain why Option 2 is better..

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Rossoneri on 6/1/2007