Search results for query: *

Does anyone know what causes session data and cookies to be truncated. The following trace was taken from our IIS server and seems to truncate the session cookie. ASP.NET_SessionId= seems to dissapear from the cookie: Chris Dukes 2004-04-05 15:11:20 192.168.13.1 - W3SVC1 TTSENET02...

I wondered if anyone had any ideas on the following: I have an ASP.Net web application which when the application is running on most servers, the web site root is appended to hyperlinks thus '/xxx.aspx' become 'http://localhost/xxx.aspx' However, on our live system '/xxx.aspx' becomes...

I wondered if anyone had any ideas on the following: I have an ASP.Net web application which when the application is running on most servers, the web site root is appended to hyperlinks thus '/xxx.aspx' become 'http://localhost/xxx.aspx' However, on our live system '/xxx.aspx' becomes...

Bmann, Just for your information, I am a contract PC developer and have worked with SQLServer, VB etc for the last 10 - 12 years in many large industries and companies. Unfortunatly, your next question is slightly more tricky as it not only involves a linked server, but also Oracle. There are...

Yes, Clearly you would present the user with a drop down list. Chris

You are selecting record on the exact dates rather than between them: (dbo.SUSCRIPTOR.FecActivacion = CONVERT(DATETIME,@FecActivacionDesde, 102)) AND (dbo.SUSCRIPTOR.FecActivacion = CONVERT(DATETIME, @FecActivacionHasta, 102)) I think what you require is: (dbo.SUSCRIPTOR.FecActivacion >=...

bMann, Glad you have a more acceptable update query, as for the additional problem, Just check for the bad dates: WHERE LA.Birth_DATE is not null and Len(LA.BIRTH_DATE) = '10' and LA.BIRTH_DATE > '1900' and LS.BIRTH_DATE <> '00-00-1950' alternatively, you could check and only convert valid...

try changing the table name from B to TableB: INSERT INTO TableB VALUES ( @VariableB1, @VariableB2 ) NOT INSERT INTO B VALUES ( @VariableB1, @VariableB2 ) Hope this helps, Chris Dukes

Yes, Your performance will be increased as it does not have to check the foreign key, but what is more important for the users. performance or data integrity? Having worked on many databases, I would prefer the data to be clean than have a fast queries. Consider the following: Users have to...

Why do you want this unchecked? The whole point in foreign keys is to main integrity within your database. By saying that you do not want to check the foreign keys, there will be no point in creating the relationship in the first place. Hope this helps, Chris Dukes

Try something like the following. --Update Products -- SET FSC = PAC.FSC, -- NIN = PAC.NIN, -- PackageDesc = PAC.PackageDesc SELECT * FROM Products PRO INNER JOIN Package PAC ON PAC.PID_pk = PRO.PID_pk Check the select first, if it is what you require then comment out the select and...

This can often happen when the underlying view has been recompiled, but the view above as not. The view above is still expecting data that used to come out of the original view and therefore formats it accordingly. try recompiling both views. Hope this helps Chris Dukes

MeanGreen, Cursors do have their place (occasionally!!), but when using a language like SQL that is designed for these kind of bulk transactions then you might as well take advantage of it. Otherwise you might as well write it in access using 23 global opened recordsets!! Exactly the...

OOPS, Yes, I forgot the set PERIMAGE_DATE =. Its always a problem trying to do several things at the same time!! Chris

You should be able to do this with a single update statement. This is just a quick mockup, but it should be along the following lines: UPDATE CALPHOTO.dbo.Perimage SET Cast((substring(LA.PERIMAGE_DATE, 5, 2) + substring(LA.PERIMAGE_DATE, 1, 4) +...

You should set IsValid after you have run the SP objCM.Execute IsValid = objCM.Parameters(&quot;return&quot;).Value How can it know what the value is before you have executed the Stored procedure? Hope this helps, Chris Dukes

Aletrnativly, You can create a batch file and run each stored procedure through ISQL eg. @echo off Rem /* ------------------------------------------------------------ */ Rem /* */ Rem /* L01_Add.cmd */ Rem /*...

RebLazer, I couldn't find a vb function, but you could create your own. You can start with the following: Public Function isUppercase(varString As String) As Boolean Dim bTemp As Boolean Dim sTemp As String 'This holds the character that we are 'currently checking. bTemp...

You can do this via an insert trigger if you have setup mail on your SQL Server. look at xp_sendMail. Hope this helps, Chris Dukes

JayKusch, Although a solution, I would not suggest using the xp_cmdshell due to the power and security issues with xp_cmdshell. Chris Dukes