Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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] =...

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

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

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

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

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