Recent content by Sarky78

Hi all, I'm reasonalbly new to .net so please forgive me. I've got a database, that i am using a pagedatasouce to output the pagination. I looping over the number of pages using a for loop, and am then creating an htmlgenericcontrol li within it, and assigning it to a parent...

Hey Both, Thanks for your responses. Simi, you solution worked a treat (hence the stars, shame i can only give one!) What i have done, is to have two stored procedures, with the code from above, and then a third procedure that combines the data into a temp table to allow me to do other stuff...

Simi, Sorry, I find it difficult to explain as well to be honest. So I have a database structure something like this: PhoneID ParentID PhoneName 1 0 Nokia 2 1 3G 3 1 2G 4 2 Phone1 5 2...

Anyone got any good ideas on how i can achieve this? Thanks Tony

Hey Simi, The other table contains information like: ID OffenceID 1 5 2 4 3 3 4 4 5 5 6 10 I need the output to be: ParentOffence1 (5) ParentOffence2 (1) and so on for the other parent offences in the list if one of the lower level offences exists...

Hi All, I'm looking to query a hierarchical table that i have written, that has a format like this: OffenceID ParentID OffenceName 1 0 ParentOffence1 2 1 ChildOffence1 3 2 GrandChild1 4 2...

Hi All, I'm a web developer and we have a client that is using the Modx open source CMS, which connects to mySQL. Over the past week, the system has produced errors like this: Execution of a query to the database failed - Table './clientDatabase/modx_site_content' is marked as crashed and...

apparetly the libxml is installed by default. We've done a server restart and voila the dam thing is now working. thanks for responding so soon though Tony

Hi All, Hoping that someone can help me out there. We have written some code to allow editing of an xml file, this code loads an xml doc using DOMDocument, we are then doing an xpath expression on it and some ther processing. this is working fine on my wamp install on my PC, but putting onto...

Additional: what i should have said is the outcome that i want is: select ... .... where PageID IN ( . . . . . (OR (Title LIKE '%biscuit%') OR (Title LIKE '%apple%') OR (Title LIKE '%pear%') OR (Title LIKE '%orange%') ) ) Tony

George, Thanks for the suggestion, I'll give that a whirl. Borislav, sorry, that was a typo, from code i was just typing in, its not an extract of the actual query as too big. this is a cut down block: CREATE TABLE #RecipeSearchTable (PageID int, Condition nvarchar(2000), course...

Hi All, This is going to be quite tricky to explain, but hang in there please..... Ok, so we are using a third party system that uses key value pairs within a database table. The basic structure is ID, SubID, Name, Value. There are multiple subID's which build up meta data about a specific...

Hi All, I'm hoping someone will be able to help on this, at the moment our IT department is saying that its not possible, but I think everything is possible. So here we go..... We have a website that when it was developed it was running ASP/IIS and had a CMS that was based on ASP for the main...

Dam it, something that simple. could have sworn that i tried something like that. Thank you so much Tony

Hi all, I'm hoping that someone on here will have come across something like this before and be able to help. I've got an xml document that is returned to me via a webservice so i can;t change it. the document looks like this: <root> <news> <data alias="date">2008-10-20</data>...