Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cdukes

    Session data truncated

    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...
  2. cdukes

    Web root Directory missing

    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...
  3. cdukes

    Hyperlink Root directory missing

    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...
  4. cdukes

    Fetch Next Cursor is to Slow

    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...
  5. cdukes

    Foreign Key Issue

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

    Problem Executing a stored procedure with a datetime parameter!

    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 >=...
  7. cdukes

    Fetch Next Cursor is to Slow

    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...
  8. cdukes

    Stored Procedure Problem

    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
  9. cdukes

    Foreign Key Issue

    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...
  10. cdukes

    Foreign Key Issue

    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
  11. cdukes

    Update a table with a table

    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...
  12. cdukes

    Views displaying wrong data

    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
  13. cdukes

    Fetch Next Cursor is to Slow

    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...
  14. cdukes

    Fetch Next Cursor is to Slow

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

    Fetch Next Cursor is to Slow

    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) +...
  16. cdukes

    asp + sql server stored procedure not returning a value

    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
  17. cdukes

    How to import many Stored Procedure scripts

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

    A method &quot;isUpperCase&quot; ?

    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...
  19. cdukes

    Sending Emails

    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
  20. cdukes

    running a command line prompt from a dts package

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

Part and Inventory Search

Back
Top