Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. litton1

    Possible commit issue ?

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

    Possible commit issue ?

    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...
  3. litton1

    Possible commit issue ?

    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...
  4. litton1

    Find dynamic elements

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

    Find dynamic elements

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

    Find dynamic elements

    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...
  7. litton1

    generics help needed

    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
  8. litton1

    generics help needed

    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...
  9. litton1

    Get column list and max length in that field

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

    Get column list and max length in that field

    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...
  11. litton1

    Fields that a calculated field depends on

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

    Fields that a calculated field depends on

    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
  13. litton1

    Cast from type DBNull error

    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...
  14. litton1

    Getting return value from EXEC SP_EXECUTESQL

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

    Getting return value from EXEC SP_EXECUTESQL

    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…...
  16. litton1

    Getting return value from EXEC SP_EXECUTESQL

    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
  17. litton1

    Getting return value from EXEC SP_EXECUTESQL

    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...
  18. litton1

    New directory on remote server?

    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...
  19. litton1

    Help with JS to JQ

    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...
  20. litton1

    Help with JS to JQ

    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

Part and Inventory Search

Back
Top