User Profile

Collapse

Profile Sidebar

Collapse
ssouhrada
ssouhrada
Last Activity: Oct 21 '09, 12:36 PM
Joined: Jun 27 '08
Location: Indiana
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ssouhrada
    replied to Multi-Threading using Thread Pool C#
    in C Sharp
    Possible Solution

    I have tried doing that but it will get the Console.Readlin e(); prior to actually executing all of the statements. The point is also to not have to require user interaction as I'm building an app that would hopefully not require supervision and could be scheduled to run. I did end up finding an answer on another post. Here is the code that ended up working as desired:


    Code:
    using System;
    ...
    See more | Go to post

      Leave a comment:

    • ssouhrada
      started a topic Multi-Threading using Thread Pool C#
      in C Sharp

      Multi-Threading using Thread Pool C#

      I have some code below which Queues up Worker Items... The only thing it doesn't do is wait for the application to finish executing it. Any ideas on how I can get the application wait for all these Console.Writeli nes to actually display on the screen? It exits out before it's finished.

      Code:
      using System;
using System.Threading;

namespace ThreadPoolTest
{
    class Program
    {
      ...
      See more | Go to post
      • ssouhrada
        started a topic Setting a variable based on a match - Then inserting into a temp table - SQL 2000
        in SQL Server

        Setting a variable based on a match - Then inserting into a temp table - SQL 2000

        Hello,

        I have a stored procedure that looks similar to the one below:

        Code:
        Select * from 
table a
inner join
table b
on
a.id = b.id
inner join
table c
on
b.id = c.id
AND
(a.value = b.value	
OR
a.value = c.value
OR
b.value = c.value)
        How could I set a variable I declare @match, to...
        See more | Go to post
        • ssouhrada
          replied to Null value breaking result set
          in ASP Classic
          Hello,

          Thanks for responding. That ISNULL feature of stored procedures will come in handy. What I found that solved my issue was actually the order that the results were coming back via the stored procedure.

          Stored Procedure: "storedprocedur e"

          Select value1, value2, value3, value4 from table


          When looping through the results on the page if I were to access value3 first...
          See more | Go to post

            Leave a comment:

          • ssouhrada
            started a topic Null value breaking result set
            in ASP Classic

            Null value breaking result set

            Hello,

            I call a stored procedure via classic ASP (1.1). I loop through the results and print out items on a page. Pretty basic concept but what I'm finding is that if a row from the database comes back as null, the next row doesn't display even though it's not null and has data in it. See the code below:

            Code:
            details1Query = "EXECUTE storedprocedure"
set details1RS = conn.Execute(details1Query)
do
            ...
            See more | Go to post
            Last edited by DrBunchman; Oct 29 '08, 10:10 AM. Reason: Added [Code] Tags - Please use the '#' button
            • ssouhrada
              replied to TextBox Update inside of a loop (.Net 1.1) / VS 2003
              in Visual Basic
              In my version of DotNet (1.1) I don't have a statusbar control. I also don't have the DoEvents Method to call in the function. I may need to directly reference it similar to the sleep function. Do you know the full path of DoEvents or the statusbar?

              Example (System.Threadi ng.Thread.Sleep )

              Thanks
              See more | Go to post

                Leave a comment:

              • ssouhrada
                replied to TextBox Update inside of a loop (.Net 1.1) / VS 2003
                in Visual Basic
                I have some code that processes some numbers (several thousand at a time). I would like to update the end user of the progress so they don't wait for 5+ minutes while it assembles this list. Basically my code takes input from one list and then sorts it and puts it in one of 3 lists classifying if they are valid, invalid, incomplete. Within this loop I would like the code to update the text box so the user can visually see that the code is working...
                See more | Go to post

                  Leave a comment:

                • ssouhrada
                  replied to How to get vars from PHP into Flash
                  in Flash
                  Hello,

                  Passing variables to flash is not too difficult. Based on the code you put up their I think you are just missing a few lines to have it recognize the variable (flashvar). See this link for more information.

                  http://kb.adobe.com/selfservice/viewContent.do? externalId=tn_1 6417


                  Thanks
                  See more | Go to post

                    Leave a comment:

                  • ssouhrada
                    started a topic TextBox Update inside of a loop (.Net 1.1) / VS 2003
                    in Visual Basic

                    TextBox Update inside of a loop (.Net 1.1) / VS 2003

                    Hello,

                    I have a simple loop that adds values to a textbox. I would like to have it refresh the text box every 100 records so that the end user still believes it is processing data (it sometimes crunches several thousand records). I don't have the .refresh method for a textbox in .Net 1.1. How was this accomplished prior to 2.0? Below is an example of the behavior simiar to what I want.

                    Thanks in advance
                    ...
                    See more | Go to post
                    • ssouhrada
                      replied to Variable database name in stored procedures
                      in SQL Server
                      Do you have an example that you could post? The only way I could find out how to do this was using an exec statement.

                      Exec( 'Select * from ' + @database + '.dbo.TableName ')

                      That is essentially in a stored procedure but it compiles at run time so the benefit of having it in a stored procedure isn't utilized. If you have any examples of how to do this I would appreciate it.

                      Thanks...
                      See more | Go to post

                        Leave a comment:

                      • ssouhrada
                        started a topic Variable database name in stored procedures
                        in SQL Server

                        Variable database name in stored procedures

                        I am trying to create a stored procedure that runs a smaller query first to determine the database to run the second query on. Below is a sample query that is similar to what I would be doing. I'm not interested in creating new Stored Procedures as their are hundreds that are like this so I don't want to write new statements like...

                        EXEC( "Select * from " + @TableName + " where " + CAST(@Param1 as varchar) +...
                        See more | Go to post
                        • ssouhrada
                          started a topic Variable Database Name in Stored Procedures
                          in Visual Basic

                          Variable Database Name in Stored Procedures

                          I am trying to create a stored procedure that runs a smaller query first to determine the database to run the second query on. Below is a sample query that is similar to what I would be doing. I'm not interested in creating new Stored Procedures as their are hundreds that are like this so I don't want to write new statements like...

                          EXEC( "Select * from " + @TableName + " where " + CAST(@Param1 as varchar) +...
                          See more | Go to post
                          No activity results to display
                          Show More
                          Working...