Search results for query: *

Thanks for that great explanation! Need to think on this one :) Age is a consequence of experience

Hi and thanks. I could try that but it would mean changing all my data layer for all inserted records. Is there no way to return the last insert ID? I thought it was the same as scope_identity in sql serveer. I was trying to port an app from sql server but this could put a stop on that...

Hi all, I am new to MYSQL but not to databases, I am used to SQL Server.. My problem is I have written an SP that inserts a new record from C#. The SP does not return the correct ID column? It returns an ID from the previously run SP. The previously run SP inserts a user and that ID is then...

That's excellent thanks! Works well! Age is a consequence of experience

Thanks jpadie. I will try this when I get home. Just about to go to work. Age is a consequence of experience

Hi all I have dynamic list as below. How can I find the element when the button is clicked? eg.. When id="But2" is clicked how do I find the word electric in id="pd_2" Thanks. <div class="row" id="row_2"> <div class="column" id="PaymentID_2"> 2 </div> <div...

Sorry, not sure if that was clear. I am trying to get the top method to call the bottom method. But how do I pass the Type (eg int?) into the bottom method (T) ? Hope that's a bit clearer. Age is a consequence of experience

Hi all, I am trying to use some code found on cp. The one with the tick :) http://stackoverflow.com/questions/793714/how-can-i-fix-this-up-to-do-generic-conversion-to-nullablet This db mapper works but not with nullable types. The method below just loops through datatablerow and fills a class...

Thanks. I will give it a go. Age is a consequence of experience

Hi all, Hi all, I am trying to get a list of all columns in a table (done) and then find the maximum length of the field that is used. For example if I have a table called Foo and there is a varchar field called Bar. I want to know what the allowed length of that column is and what actual space...

bborissov - the second example did it for me thanks. Have a star. Age is a consequence of experience

HI all, Any body know how to get at this info? tried sp_help table_name but it does not show up in there. Searched google but cannot find an answer to this. Thanks. Age is a consequence of experience

gmmastros is correct, this is a ADO.Net error. Basically you are selecting data from a table but that table data has a NULL in a date column. Probably coming out of the database with a datareader into the app? When a null comes from the database into the application .Net converts it to DBNull...

Your example worked well, thanks have a star. Age is a consequence of experience

Okay I dumb! You correct something not quite right with that? I will take a look later and let you know.. You know when you mess with something so much you loose track of what you have changed and just end up breaking it more.. (Excuses are coming out) Thanks for taking the time to look…...

Thanks for your reply softhemc, I did already try that but I get - Incorrect syntax near '+'. Sql server doesn't seem to like a concatenated string when using EXEC SP_EXECUTESQL? But i do it this way so I can have an out param. Age is a consequence of experience

Hi all, I am trying to build some dynamic sql. The first bit works but cannot get the second to work? Any help appreciated. declare @pWhereClause VARCHAR(50); set @pWhereClause = ' a.Visible = 1 AND a.Archived = 0 ' + @pWhereClause; declare @recCount INT; declare @sql NVARCHAR(500) EXEC...

Hi all, I am trying to create a new directory on the server from an ASP.Net page (this is a sub directory of the web site). When I try to do this I get System.UnauthorizedAccessException error. So I assume I need to give IIS the permissions on the directory which I am saving into e.g. The folder...

Thanks for that. You are right there is a jquery plugin on there site ( http://docs.jquery.com/Plugins/Validation#Example ) I will have go with that. It is all checked on the server so no probs there. Just trying to better my client side though... Have a star for your trouble. Age is a...

Thanks for your time. I will give this a go when I get chance to get on a machine. I will let you know how I get on :) Age is a consequence of experience