Search results for query: *

Thanks all, got the code working now. Not sure what the problems was but hey ho. Cheers, John Web Design Wetherby Personal Web Design Service

Thanks for the suggestions guys. bborissov: still returns the same subquery error? TysonLprice: can you explain please? Many thanks, Web Design Wetherby Personal Web Design Service

...dbo.split(@SWAPS, ',')) But If I change the Update to a select it displays the three records which I effectively want to update?? eg. select * from ItemOffer where ItemID in (Select convert(int, Value) from dbo.split(@SWAPS, ',')) Can this method work with an update or is there a...

Oh yeah!!!!! Crazy how you look at something for so long you miss the obvious. Nice one, Cheers. Web Design Wetherby Personal Web Design Service

Hi, I have the following SP which I would like to return a total of the JourneyDuration field for a each day in the search criteria. I also then want to change the JourneyDuration value from seconds to hours. i.e divide by 60 twice. Everything works fine until I try and perform the above...

Ah, right that makes sense then! I should have posted before wasting an hour testing [smile] Cheers guys. Web Design Wetherby Personal Web Design Service

Hi, I'm doing some testing reqarding db connections and something is driving me nuts! I'm checking the connections made to sql via sp_who2 and using a console app is VS2005. This is the simple code i'm using, that as far as I know should open and close the connection fine...

Hi, I've recently been testing the Atlas framework and wanted to see what everyone else thought about it. I'm thinking about implementing it heavily on a new project and wondered if anyone had come across any problems in a production environment. After coding Ajax manually it does feel...

Try this... Trigger Page Methods from a User Control Web Design Wetherby Personal Web Design Service

You could also do this using panels to display / hide the different stages. click here for code example eg, Have two panels on one page. Panel1 : Containing the text fields and submit button Panel2 : Containing the edit and confirm button Set Panel2 to not be visible as default. In the...

As vbkris said, you dont need to use Eval there, set it when you bind the list in the code behind. Dim lstCategoryID As DropDownList = CType(FormView1.FindControl("lstCategoryID"), DropDownList) lstCategoryID.DataSource = Utilities.GetCategoriesList() lstCategoryID.SelectedValue = "CategoryID"...

I agree with both the above options. Its best to deal with the requirement database level or the business layer instead of at the GUI i.e the aspx page. Web Design Wetherby Personal Web Design Service

Hi Micker377, The bluetooth hub is powered by the mains and the mouse is charged via the hub. Thanks anyway. I'll just send off for a replacement, from what i read on the logitech forums it seemed alot of people have had problems with this combo set. So I just thought I'd see if anyone here...

Hi, I took the plunge and forked out the hefty whack for the above bluetooth mouse and keyboard set. Got it home and everything installed first time and I was well impressed. It looks that absolute nuts and is excellent to use, it really is. Until.....for some reason one day (about three...

Thanks for the suggestion RTomes. It works just fine. I'm not happy with the process overall, but this looks like the best solution to a undesirable situation. Cheers J Find out you can improve your plant security and plant tracking ¦

Hi, I can not sort the data there because it is used somewhere else in the system. There must be a wasy to transfer the data from a sortlist to something else (maybe arraylist or another sortedlist) and re-order?? Thanks anyway Find out you can improve your plant security and plant...

Hi, I have a SortedList that contains the key field and on object (which has 8 fields within). I can bind this fine to a datagrid and see the 8 fields via the bound columns. Works great. What I would like to do however is sort the data by one of the eight fields before i bind it to the...

Thanks for the reply, could you tell me how I can just find the IP for the server then please? Find out you can improve your plant security and plant tracking ¦

Hi, I have tried to find the answer to this on google on here. Maybe I've had too much coffe but no luck. Anyway, I want to find and change the IP address for my local SQL Server. I am sure I have found this before in a file in the SQL Server program files, but I cant for the life of me...

Hi, Check this out, its got all you need to know. article on 4 guys HTH Find out you can improve your plant security and plant tracking ¦