You searched for the word(s): userid:486407

More Search Options

RSS Available

• set dropdownlist to dropdownlist

  i have a dropdownlis that is on many pages in different areas so i placed a property in a common class that returns a dropdownlist populated with the data I want. On the web user control I set the dropdownlist on that page to the property and for some reason i can pull the first value of the drop down list befor it renders although when it does renter the UI it has not items. I set the it like so: me.ddl = common.ddl if i go back to populating it the traditional way it shows the items on the UI.

  Posted to Web Forms (Forum) by JsonTerre1 on 12/3/2009

• Re: set dropdownlist to dropdownlist

  I have a common class that has a property that returns a type of DropDownList. In that property i crete a dropdownlist and populate it with items. On my page i want to just call the common class property and assign it to the drop down list on the page. My though was that since i use this same dropdownlist on tons of other pages in my project i would make one property and use it everywhere. So on my page i have a dropdownlist called MyDDL and i set that to the common class property ddl. Me.MyDDL

  Posted to Web Forms (Forum) by JsonTerre1 on 12/3/2009

• url rewrite

  I'm really not sure if this is a url rewrite or not. Example of what I am looking to do: I need to have URL http://r.fwer.us always point to a certain page no matter what comes after it. For example http://r.fwer.us/asd should point to the same page as http://r.fwer.us . anything with this host header should point to the same page. http://r.fwer.us/asd gives me a page can not be found although http://r.fwer.us/ takes me to the page. The URL could be http://r.fwer.us/asdf , http://r.fwer.us/y6yy6y4

  Posted to HttpHandlers and HttpModules (Forum) by JsonTerre1 on 10/15/2009

• Re: url rewrite

  thanks for the response. we are using iis6 which i have not control over an upgrade. is there another way? jason

  Posted to HttpHandlers and HttpModules (Forum) by JsonTerre1 on 10/15/2009

• Re: bulk update

  Sorry to add to this although I have another one that is a bit more complex and since I am not SQL Guru I'm strugling. If UserID on table @u has an IsArchive flag set to False. @t and @t2 have the same UserID if all tables have matching UserIDs and the IsArchive flag on @t for one of the records on a matching UserID is set to false then get the newest CreatedDate record in @t2 for that same UserID and set it to True and change col1 to "Changed" on @t2 ONLY if none of the records in

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by JsonTerre1 on 10/8/2009

• Re: bulk update

  That is slick. the new way of writing sql with 2005/2008 is really cool. Thank you very much. jason

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by JsonTerre1 on 10/8/2009

• Re: bulk update

  i noticed you didn't factor in the @u table and I'm not sure that factors into what i am explaining below. The isarchive on the bulk update should = 0 but i knew what you were doing. If you make the following changes @u UserID 2 "IsArchive" = 1 one record for @t UserID 2 "IsArchive" columne = 0 change all @t2 UserID 2 "IsArchive" = 1 The script should not change any @t2.IsArchive values for any UserID 2 records because the IsArchive value for UserID 2 on @u is

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by JsonTerre1 on 10/8/2009

• Re: bulk update

  this is very close. I noticed that two UserID 1 records have an IsArchive value changed to 0. since @t2.IsArchive already has a value set to 0 on that UserID record it should ignore it. should i add a "not in " conditional on the @t2 table in the where clause? below is the code i have. I only changed the isarchive update value to 0 rather than 1 because i want to set them to 0. ;with mycte as (SELECT * ,ROW_NUMBER() OVER(PARTITION BY userId ORDER BY createddate desc) rn FROM @t2 WHERE userid

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by JsonTerre1 on 10/8/2009

• Re: bulk update

  I'm getting this with the following SQL: UserID 1 some text1 2009-02-15 00:00:00.000 1 UserID 1 some text2 2009-01-16 00:00:00.000 0 UserID 1 some text3 2009-03-12 00:00:00.000 1 UserID 1 Changed 2009-08-13 00:00:00.000 0 UserID 2 some text1 2006-02-15 00:00:00.000 1 UserID 2 some text2 2007-01-12 00:00:00.000 1 UserID 2 some text3 2008-03-18 00:00:00.000 1 UserID 2 some text4 2009-08-11 00:00:00.000 1 UserID 3 some text1 2006-02-16 00:00:00.000 1 UserID 3 some text2 2007-11-13 00:00:00.000 1

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by JsonTerre1 on 10/8/2009

• Re: bulk update

  if any isarchive flag on the @t2 table for a specific userid is set to 0 then it should not update any of them for that userid. UserID 1 has an existing 0 set for date 2009-01-16 00:00:00.000. but then it also updates isarchive for date 2009-08-13 00:00:00.000. It should just leave the one for 2009-01-16 00:00:00.000 because is already exists with a value of 0 on the isarchive field for that userid record. So it should not have changed the isachive flag on 2009-08-13 00:00:00.000 for userid 1. If

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by JsonTerre1 on 10/8/2009