Copy Some Rows From Table1 to Table2 SqlServer

I am doing a one-time combining 2 separate legacy database tables that contain some of the same info but also additional different info into one new SqlServer table. I am also copying some but not all of that additional data.

So I am inserting some of the columns from each table into some of the columns in the new table.

If all the columns in table2 are going to be inserted into table1 and the column names are the same I can:

insert into table1 (Detail, Unitname, Sortorder) select * from table2

if there is a change in column name change:

insert into table1 (Detail, Unitname , Sortorder) select facilabbr as Detail, Unitname , Sortnum as Sortorder from table2

Javascript Function using RegEx Regular Expression

I need to check client side if a DropDownList.SelectedItem.Value is any of the following: 1,3,9,17,or 15.


Rather than use a clumsy if statement, I do this by seeing if the value will match a Regular Expression:

      function taskChange() {
      var task = $get("ddlTest");
      var RegExp = "(^1$^3$^9$^17$^15$)" ;
      if (RegExp.match(task.value))
           { 
               // A value of 1,3,9,17,or 15 was selected

               // do whatever 

           }
           else
           {
                //Some other value was selected 

                // do whatever
           }
       }
 

Playing with an Infragistics WebDialogWindow Bug

Found a bug in the Infragistics WebDialogWindow.

I discovered it when using the zooming function via holding down the Ctrl key and scrolling the mouse wheel to make the display more visible to the group I was demo-ing to. Moving the WebDialogWindow around leaves text behind. Oops.

Not exactly the demo I was shooting for.

But can be used to generate some cool effects:

This is what the WebDialogWindow looks like before moving it:

These are screenshots of the WebDialogWindow on zoom:

Floating away:

Where did my window go?

An out of body experience:

And my personal favorite -

WebDialogWindow Abstraction :

Increasing number of connections in IIS 5.1

XP Pro IIS 5.1 is limited by default to 10 concurrent connections.

This can be increased to a maximum of 40 by:

C:\Inetpub\AdminScripts\adsutil set w3svc/MaxConnections 40

Using Manoli

I use http://manoli.net/csharpformat/ , or other manoli flavors, to format code for presentation in this blog.

Delayed action on Mouseover

Haven't tried this yet, just parked it here till I need to use it.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Page title</title>

<script type="text/javascript">
var c=0;
var t;
var myTimer;
function timedCount()
{
document.getElementById('txt').value=c
c=c+1
t=setTimeout("timedCount()",50)
}

function stopCount()
{
clearTimeout(t)
}

</script>
</head>

<body>
<form>
<input type="button" value="Start count!" onmouseover="var myTimer=setTimeout('timedCount()', 1000);" onmouseout="clearTimeout(myTimer);">
<input type="text" id="txt">
<input type="button" value="Stop count!" onClick="stopCount()">
</form>
</body>
</html>

Gps coordinates from Google maps

To provide directions on my Rahway River Park blog, a have link to google maps.

1. I open Google Maps to the vicinity of where I would like coordinates.


2. I use my right click mouse button and select "center map here" from the drop down button.


3. I click the "go to the address in the location bar" button usually to the right of the address.


4. A popup appears showing the coordinates of the center of the map like this: (43.60336, -110.7362)

Take a look:
Directions