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 Rhinorhino 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: *

  • Users: litton1
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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
  6. 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...
  7. 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...
  8. litton1

    Help with JS to JQ

    Hi all, I have a JavaScript function that checks values have been added to textboxes on button click. If no values have been added then the backgrounds are changed to red, a message is added and false is returned. If they have then true is returned. I am having problems getting the correct...
  9. litton1

    Empty space above image.

    Empty space above image. Hi all. I was wondering if you could tell me why there is an orange space above the top banner (with leaves on) when viewed in chrome, firefox and IE 9 but not when viewed in I9 in Document Mode IE 7 Standards? http://lancstreesurgery.com/oak/index.html Thanks Age...
  10. litton1

    SQL Help

    Hi All, I have a sub query. It returns duplicates on the contact number but I would just like the top contact number. How can I do this? left join (SELECT p.PartyID, sc1.SubCaseRef, pcn.ContactNumber FROM SubCase sc1 inner join SubCaseItem...
  11. litton1

    prevent li having an image

    Hi all, My content li has an image. #content li { list-style-type: none; background: url(img/bullet.gif) no-repeat 0px 8px; etc ... } How do I make an li below this id not have this image. I could make a new id/class but what is the syntax to cancel the image? Thanks. Age is a...
  12. litton1

    mouseover on li change background colour

    I have 4 li tabs. When mouse over I would like the background to change colour to the same colour as the image. e.g. on this site, move over a tab and the image is replaced by a black background. I would like the black background to actually be the colour of the tab but I only seem to be able to...
  13. litton1

    Caching

    Hi all, I have a telephone number that comes from the DB into a label. What is the best way I can I cash this for all visitors of the page, but only this? Thanks L Age is a consequence of experience
  14. litton1

    Multiple joins

    Hi all, having problems with my joins again :(. I cannot fathom where the brackets go when I have three joins, any help much appreciated. SELECT s.S_SupplierID AS SupplierID, blah, blah FROM Suppliers s INNER JOIN SupplierProducts sp ON SP_SupplierID = S_SupplierID INNER JOIN...
  15. litton1

    Left Join

    Can anybody see what is wrong with this simple query? The error seems to be in the Left Join SELECT p.[P_ItemID] AS ProductID, i.[Name], PQ.[QuantityOnStock] FROM [Products] p INNER JOIN [Items] i ON i.[I_ItemID] = p.[P_ItemID] LEFT JOIN ProductQuantitys PQ ON PQ.[PQ_ItemID] =...
  16. litton1

    DataGridView Sort

    I am having problems while sorting a DGV. At the moment the glyph (triangle) shows but is not enabled to allow a sort on the column. It looks like the header is not enabled? Could this be because the data is bound to a generic list? The properties that I have set are (otherwise assume default)...
  17. litton1

    Constraint needs relaxing?

    Hi all, I need to put a constraint on a table. This constraint will help to pull out an error in our legacy software, as the legacy software is putting duplicate records in a table. Fairly simple you might think. My problem is that on one of the fields I only want the constraint to fail if...
  18. litton1

    Proc Help plz

    I would like to run three queries in a procedure and return the results as one dataset. The reason I would like to run three is, this is a search procedure for searching a parts list so if the user enters Part1. I would then like to search for exact matches. Then search for Like 'Part1%' and...
  19. litton1

    Deploy CF always

    Hi all, I have just moved onto a job that has been on the go for a while but using VS 2005. This is a barcode app that runs on handheld wireless barcode scanners. The app uses the CF as they are all Win CE devices. The problem is that if I try to run this app/solution on a new device (just...
  20. litton1

    Inser to MySql Stored proc error

    Hi all, having a very frustrating problem. When inserting through stored procedure using ODBC I am getting an error saying that I have an error in my sql near the procedure name? The procedure works fine from MySql so guess the fault is in my code somewhere? I have supplied both for...

Part and Inventory Search

Back
Top