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

More Search Options

RSS Available

• Nasty Trigger Question

  Hi All, here is the trigger: CREATE TRIGGER Members_Set_ApplicationSyncDate ON lyrisadmin.members_ AFTER UPDATE AS BEGIN IF NOT UPDATE(ApplicationSyncDate) BEGIN UPDATE lyrisadmin.members_ set ApplicationSyncDate = NULL where MemberID_ = (Select MemberID_ from inserted) AND List_ = (Select List_ from inserted) END END Problem is: If someone runs a query like n"Update TBL Set List_ = 'goo' WHERE List_ = 'boo' in this case MemberID_ is not present and and error is thrown in my Update statement. How

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by meantown2 on 2/22/2006

• Re: moderate sql procedure question

  Why is it not convenient to pass all the values in? How are you calling the Stored Proc? If you use an Address object with Save method that calls the stored Proc, it should not be an issue to pass all the values to the Proc because all the values should be loaded into the instance of the Adress object that is calling Save.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by meantown2 on 2/16/2006

• SQL Express Lost LDF File

  Hello, I'm have developed a web site with .Net 2.0 and Sql Express. To make a loooong story short, I have managed to lose the myDB.ldf file. I still have the .mdf file but can not get my app to connect due to the .ldf missing. Please help if you can. Many thanks!!! The error I get is: " Cannot open user default database. Login failed. Login failed for user 'myComputer\User'. File activation failure. The physical file name "D:\WebProjects\webProject\App_Data\myDb_log.ldf" may be incorrect. "

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by meantown2 on 2/13/2006

• Re: Help : can't login and can't register after moving the site to IIS

  If they can host and serve your site and they have SQL Express installed you "should" be OK. If you are not OK, i.e. your pages are served but you can't log in to the site on the host, here is some stuff to consider: 1. Your connection string. You will most likely need to edit the DataSource property in the connection string to match the name on the host. The connection string is in the web.config. mine looks like this: <connectionStrings> <add name="ClubSiteDB" connectionString="Data Source

  Posted to Club Web Site Starter Kit (Forum) by meantown2 on 2/9/2006

• Re: Help : can't login and can't register after moving the site to IIS

  OK, I found it. I'm in XP Pro in a workgroup environment (not a domain). Must turn off simple file sharing and give directory permissions to ASPNET, IUSR_, and IWAM_ (and maybe NETWORK SERVICE) users. Open windows explorer, Tools -> folder options -> View tab Go to bottom option and uncheck Use simple file sharing. Then go to the directory that contains your web site, right click -> Sharing and Security. Add the users listed above and give read/write pirvs. BINGO. I hope this helps someone

  Posted to Club Web Site Starter Kit (Forum) by meantown2 on 2/8/2006

• Re: Help : can't login and can't register after moving the site to IIS

  I am having the exact same issue, so I am bumping this thread back to the top. If anyone knows, please help. :) Thanks!

  Posted to Club Web Site Starter Kit (Forum) by meantown2 on 2/7/2006

• Re: Showing multi-day events in the calendar

  Hi, Nice idea to post this enhancement. I pulled down the event calendar project, made the updates and I get the following error on build: Error 1 Using the generic type 'System.Collections.Generic.Dictionary<TKey,TValue>' requires '2' type arguments C:\Documents and Settings\x\My Documents\Visual Studio Projects\EventCalendar\EventCalendar\EventCalendar.cs 352 40 EventCalendar In the " void cacheDataInViewstate(System.Data. DataView dv)" function, the error is on the line: System.Collections

  Posted to Club Web Site Starter Kit (Forum) by meantown2 on 2/6/2006