.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Post New Web Links

VS thinks that my var timesemailed is timesRMemailed (another var)

Posted By:      Posted Date: September 19, 2010    Points: 0   Category :ASP.Net

Why can't vs figure out that there are the letters RM inserted in between the letters timesemailed. It's a different variable and also a different column in my table! THis is ridiculous. Now I have to go change my variable name in about 100 places in my code. I thought the program made hashes for each var. Would not the hash for the var timesemailed be different for timesRMemailed? When I print both vars with response.write, I get a 0 for timesRMEmailed when there is actually a 3 in the column for this row. The number 3 is in the timesRMEmailed column in the table and it is accessed by another variable timesemailed....

Ok, I digress, upon close examination of my busineslogic area, my New function was missing the RM and timesemailed got 2 assignments. My mistake. Code carefully!

View Complete Post

More Related Resource Links

My VS thinks it sees a 0 when it is really a 1


It's really quite ridiculous. I'm staring at my table, which I have refreshed, and I know there is a 1 sitting there in the column. Yet my program says it's a zero. What can be the reason for this anomoly? 


 If Not IsDBNull(adv.TimesRMEmailed) Then
            Response.Write("WE ARE HERE")
            Response.Write("TimesRMEmailed: " & adv.TimesRMEmailed)
            NumRMemails = adv.TimesRMEmailed
            NumRMemails = NumRMemails + 1
        Else : NumRMemails = 1
        End If

I put a 3 in the column and made sure it took. Usually I have to retype the data 5 times until I see a little red circle which tells me that the data took. Why do I always have to do this in the SQL tables?

When I ran my program, rather than print me the 3 which was sitting there, it thinks that the value is 0, then it adds 1 to the number and assigns it fo NumRMEmails. This is absurd....It should be 3+1=4

Why can't it read the value in the column for adv.TimesRMEmailed? It turns it to a zero every time.



SQL Server 2008 Express Management Studio fails to install because it thinks visual studio is instal


I tried to install SQL Server 2008 R1 Express with Tools on Windows Server 2008 R2. It installed, but the management studio failed to install because it said I already had Visual Studio installed and it needed Visual Studio service pack 1 before Management Studio could install.

Visual Studio is nowhere to be found in Programs and Features, and when I try to install Visual Studio SP1, it won't install, saying:

A compatible version of Visual Studio 2008 was not detected on the system. This update is designed for only the Microsoft Visual Studio 2008 (ENU) product family, and is not compatible with any Express editions.

Though I can't find any Express version of SP1 to try, and there is no SP1 in windows update.


SQL 2005 thinks a SQL 2000 backup is corrupt, but SQL 2000 restores just fine

I am attempting to move some SQL 2000 databases to SQL 2005. My main production database does not seem to want to move. When I use the SQL 2005 GUI the .bak backup file is marked 'Incomplete'. When I attempt to restore the backup file I get a 'RESTORE detected an error on page (0:0) in database' message. I saw a thread in the SQL Express forum suggesting trying to restore from the T-SQL level to get the GUI out of the picture and I get the same 'error on page (0:0)' message.  However when I take the same file and use SQL 2000 Enterprise Manager it restores with no problems.

Any ideas?

Mike Mattix

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend