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

More Search Options

RSS Available

• New to Stored Procedures. How do I make a SP in ASP.NET 2.0?

  I am using VS.NET 2005 I am trying to turn the following INSERT and EDIT statements into Stored Procedures. Can someone help me with this? UpdateCommand="UPDATE [info] SET [class_name] = @class_name, [info_date] = @info_date, [notes] = @notes WHERE [info_id] = @original_info_id" InsertCommand="INSERT INTO [info] ([class_name], [info_date], [notes]) VALUES (@class_name, @info_date, Left(Replace(@notes, "'", ""), 7000))" I am wanting to use a SP because I couldn't get the follwing Bind to work. Text

  Posted to Data Presentation Controls (Forum) by jettman26 on 8/14/2005

• Re: Betreft: Re: Getting error when inserting large numbers of characters into DB

  Thanks for the reply. I do not know how to use a Stored Procedure. Can you show me?

  Posted to Data Presentation Controls (Forum) by jettman26 on 8/12/2005

• Re: Betreft: Re: Getting error when inserting large numbers of characters into DB

  Sorry guys, I don't understand. Can you please post the exact Insert statement I should use?

  Posted to Data Presentation Controls (Forum) by jettman26 on 8/12/2005

• Re: Getting error when inserting large numbers of characters into DB

  Thanks for the reply. Can you please explain "i think that in C# it would have to be "\""... "?

  Posted to Data Presentation Controls (Forum) by jettman26 on 8/12/2005

• Re: Getting error when inserting large numbers of characters into DB

  I still get the same error using LEFT(RIGHT(@notes, 7000)). Using Left(@notes, 7000) in SQL Server 2005 it works. Just doesn't work in SQL Server 2000. I think it has something to do with the " ' " (single quotes) inside the notes field that I am trying to Insert. I have tried Left(Replace(@notes, "'", ""), 7000)) but VS.NET 2005 gives me this message. Server Error in '/WebSite1' Application. Parser Error Description: An error occurred during the parsing of a resource required to service this request

  Posted to Data Presentation Controls (Forum) by jettman26 on 8/11/2005

• Getting error when inserting large numbers of characters into DB

  I am getting the following error when trying to insert large amount of characters into a SQL 2000 database. "An error occured while entering this record. Please verify you have entered data in the correct format." My database column (notes) is varchar 7000. This is what I have in my code for an insert. InsertCommand="INSERT INTO [info] ([class_name], [info_date], [notes]) VALUES (@class_name, @info_date, LEFT(@notes, 7000))"> Why am I getting this? Shouldn't the 'Left' be taking care of this?

  Posted to Data Presentation Controls (Forum) by jettman26 on 8/10/2005

• Re: Getting error on hosted server with ASP.NET 2.0 when trying to Login

  I talked to my hosting provider and they said my WebApp is not on a web farm. Also, I am not using Server.Transfer so I don't know why I am getting this error. Any ideas?

  Posted to Installation and Setup (Forum) by jettman26 on 8/7/2005

• Re: Validation of viewstate MAC failed error....

  I am having this same problem. I am using ASP.NET 2.0 and getting the problems (I believe) with the new Login Controls. My hosting company doesn't understand/know what is going on or how to fix this. Any ideas?

  Posted to State Management (Forum) by jettman26 on 8/5/2005

• Getting error on hosted server with ASP.NET 2.0 when trying to Login

  Using ASP.NET 2.0. Not sure where to post this. I am getting the following error when trying to login to my webapp using the new Login controls in ASP.NET 2.0. My hosting company is not sure what to do at this point. Any ideas? Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster. Description: An unhandled exception occurred during the

  Posted to Installation and Setup (Forum) by jettman26 on 8/4/2005

• Re: Will we ever get an update to the Forums Module?

  Thanks for the info. Any idea when the next version of the Gallery will be out?

  Posted to DotNetNuke (Forum) by jettman26 on 8/4/2005