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

More Search Options

RSS Available

• Re: SQL trigger .. please help...

  CISCBrain: abyss I think that if you update multiple records at once you'll get the Subquery returned more than 1 value error. yp you're right :)

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by abyss on 7/26/2006

• Re: SQL trigger .. please help...

  SQL 2005 CREATE TABLE [dbo].[sample]( [ID] [int] IDENTITY(1,1) NOT NULL, [SampleField] [nchar](10) COLLATE Latin1_General_CI_AS NULL, [Updated] [datetime] NOT NULL CONSTRAINT [DF_sample_Updated] DEFAULT (getdate()), CONSTRAINT [PK_sample] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] CREATE TRIGGER sampleUpdate ON dbo.sample AFTER UPDATE AS BEGIN DECLARE @rowId INT; SELECT @rowId=ID FROM INSERTED; SET NOCOUNT ON; UPDATE sample SET Updated=GETDATE() WHERE

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by abyss on 7/26/2006

• Re: Learning T-SQL lang..?

  Hi, In my opinion the best way to learn T-SQL is to learn basics and start doing something real (application) then you'll see what else do you need to know. the best book in my opinion is O'Reilly "T-SQL Cookbook" http://www.amazon.com/gp/product/1565927567/104-3029177-0577504?v=glance&n=283155 it provides you T-SQL solutions for most common problems

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by abyss on 7/26/2006

• Bug: Invisible UpdatePanel gives an error

  Hi guys, The problem is that the atlas script manager includes UpdatePanel name in xml script even if this panel is marked as Visible="False" (panel code doesn't exist in final HTML sent to browser). This causes a JavaScript error (Object Not Found). below is the code to reproduce bug: <atlas:ScriptManager ID="ScriptManager1" runat="server" EnablePartialRendering="true" /> <atlas:UpdatePanel ID="panel1" Mode="Always" runat="server" > <ContentTemplate> <asp:Label runat="server

  Posted to ASP.NET AJAX Discussion and Suggestions (Forum) by abyss on 7/26/2006

• Re: Defining XML document

  this code works for me fine: protected void Button1_Click(object sender, EventArgs e) { Xml1.TransformSource = "~/simple.xsl"; Xml1.Document = GetXMLFromUrl("http://www.w3schools.com/xml/simple.xml"); } protected XmlDocument GetXMLFromUrl(string url) { WebRequest request = WebRequest.Create(url); WebResponse response = request.GetResponse(); XmlTextReader reader = new XmlTextReader(response.GetResponseStream()); XmlDocument xmlDocument = new XmlDocument(); xmlDocument.Load(reader); return xmlDocument;

  Posted to XML and XmlDataSource Control (Forum) by abyss on 7/25/2006

• Re: updatepanel inside a panel gives an error

  Luis Abreu: and in the end you have an updatepanel inside another updatepanel... the post is about disposing a xml script element... this issue exists even if update panel is not contained in another panel ... try this code: <atlas:ScriptManager ID="ScriptManager1" runat="server" EnablePartialRendering="true" /> <atlas:UpdatePanel ID="panel1" Mode="Always" runat="server" > <ContentTemplate> <asp:Label runat="server" ID="label" /> </ContentTemplate> <Triggers> <atlas

  Posted to ASP.NET AJAX Discussion and Suggestions (Forum) by abyss on 7/25/2006