Hi, i have 2 tables(prduction and transact) that contain data for transactional updates per product, stock is calculated by doing sum() on one column in each table that contains the weight and to get the result per product i use group by product. My
problem is that if than one value exists in the transact table, the sum(production.plannedtonnage)
result is doubled for every record in the transact table. How can i fix this, any help would be greatly appreciated!
View Complete Post
Problem is this................
Table 1: studentprofile
scholarid class section
1 A 1 VI K
2 B &nbs
Hi to all,
I have some things that I want to know. I am right now using a free asp.net webhosting ("somee.com"). The problem is that when I am visiting a page, there's a tendency that values stored in my session variables are lost. Therefore, it causes an error when the requested page is loaded.
1. I am thinking of using sessionState mode="SqlServer". Will it solve my problem?
Actualy Im working on it but Im having problems when connecting to the sql database.
2. Is that a problem in the webhost?
3. Do free webhosting sites provide allow session state in the sql server?. Because ive tried it locally into my computer and error say's i should intall the ASP.NET Session State SQL Server version 2.0 or above.
I have tried dozens of changes and modifications to many settings as I will outilne here and all to no avail.
The short answer here though is that I uninstalled SQL Sever Express 2008 R2 and went back to the "NON" 2008 R2 and got things working. But like the fool I am wanted to run on the more current rev and updated again, all problems returned....
Win Server 2003 R2 SP2
SQL SERVER EXPRESS 2009 R2
VWD2008 Express (removed)
SQL Server Express 2008
I was orginally getting this message after updating to SQL Sever Express 2008 R2, I removed VWD 2008 Express from the web server, no good, then uninstalled SQL Server 2008 Express R2 and reinstalled SQL Server 2008 Express. worked but had issues, couldn't install MGTM Studio. Then I removed SQL 2008, cleaned folders and reg. Reloaded SQL Server 2008 Express, still flaky, couldn't get the Management Studio to install. So I removed it again and used the Web Platform Installer, which worked but loaded 2008 R2 again. Which brought back the message.
Failed to genera
I have Sqlserver2008 setup.
It is work in wndows Xp.
But I have to Install it on Windows 7 ,during installation process it requires some patch and I am unable to get it.
Plz some buddy can help the same.
Hello everyone. I am having an issue downloading files that I have store in SQL Server. I have no problem in a WinForm. What am I doing wrong in my code?
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim sch As New clsReport
Dim fileData As New clsReport.Letter
fileData = sch.DownloadLetter(Session("LetterID"))
Dim ms As System.IO.MemoryStream = fileData.fil
Dim fil As Byte() = ms.ToArray
Dim nam As String = fileData.name
Dim ext As String = fileData.ext
If Not fil Is Nothing Then
Response.AppendHeader("Content-Disposition", "attachment; filename=" + nam & "." & ext)
' Response.AddHeader("Content-Disposition", nam & "." & ext)
Response.ContentType = "Application/octet-stream"
Response.Buffer = True
Catch ex As Exception
We recently upgraded to a 2008 development web server and I installed all the stuff to get dot net 1.1 app working on the server. I can host them and they work. My problem is that when I try to open one in VS 2003 I get the following error. I set up the web server the same as my previous one, and I think a long time ago I got this error when we set up current one but do not remember how to resolve it. So I moved my project files from the old server to the new server and then I get these errors.
The web Server reported the following error when attempting to create or open the Web Project located at the following url: Http://localhost:/MobTracker. 'Http/1.1 500 server error
I get a message that x_login is not declared. I added Dim login as String = "123", but that didn't help. What's the problem?
Dim Login = "123"
x_login.Value = loginID
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Default.aspx.vb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<form id="simForm" runat="server" method='post' action='https://test.authorize.net/gateway/transact.dll'>
<input id="HiddenValue" type="hidden" value="Initial Value" runat="server" />
<input type='hidden' runat="server" name='x_login' id='x_login' />
<input type='submit' runat="server" id='buttonLabel' />