mrkeck Sharing the Love

29Mar/110

jQuery Graphing

Highcharts looks great!  If I were doing a non-commercial site I would check this one out heavily.  But since it costs, I'm on to the next one.

jqPlot worked pretty well but had some issues for me.  Some of these issues are most likely me just not knowing what I am doing but I like a library to handle my ignorance.  The data points didn't line up with the grid and when I used a bar graph I couldn't get the x-axis labels to format into a two decimal number.  It looked like it had options to do it but they didn't work for me.

Flot has worked great for me so far.  I like the tooltip, hover, and click stuff.  Looks nice too.  I had the initial call wrong and that made nothing work but I have it right now and am very pleased.

28Mar/110

mySQL Number Range

Integer Types

MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, and BIGINT. The following table shows the required storage and range for each integer type.

Type Storage Minimum Value Maximum Value
(Bytes) (Signed/Unsigned) Signed/Unsigned)
TINYINT 1 -128 127
0 255
SMALLINT 2 -32,768 32,767
0 65,535
MEDIUMINT 3 -8,388,608 8,388,607
0 16,777,215
INT 4 -2,147,483,648 2,147,483,647
0 4,294,967,295
BIGINT 8 -92,23,372,036,854,775,808 9,223,372,036,854,775,807
0 18,446,744,073,709,551,615

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

Filed under: mySQL No Comments
28Mar/110

Vampire Header 2

This is a Header

I have a lot to say!!
I have a lot to say!!
I have a lot to say!!
I have a lot to say!!

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
<style>
.left{
	border-right: 8px solid #5A554D;
	border-bottom: 8px solid transparent;
	height: 100%;
    float: left;
}
.middle{
	background-color: #5A554D;
	color: #fff;
	height: 100%;
	text-align: center;
}
.right{
	border-left: 8px solid #5A554D;
	border-bottom: 8px solid transparent;
	height: 100%;
    float: right;
}
.main{
	width: 150px;
	text-align: center;
}
.topicHead{
	width: 100%;
	height: 25px;
}
.topicText{
	width: 133px;
	margin: 0px 8px;
	border: 1px solid #5A554D;
}
</style>
<div class='main'>
	<div class='topicHead'>
		<span class='left'></span><span class='right'></span>
		<div class='middle'>This is a Header</div>
	</div>
	<div class='topicText'>
		I have a lot to say!!<br/>
		I have a lot to say!!<br/>
		I have a lot to say!!<br/>
		I have a lot to say!!<br/>
	</div>
</div>
Filed under: CSS No Comments
28Mar/110

Vamipe Header

Hey

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
<style>
.left{
	border-right: 8px solid #5A554D;
	border-bottom: 8px solid transparent;  
	//Having the border bottom adds the bottom corner to the side
	//But the bottom being transparent does not show the rest of the bottom
}
.middle{
	background-color: #5A554D;
	color: #fff;
}
.right{
	border-left: 8px solid #5A554D;
	border-bottom: 8px solid transparent;
	//Having the border bottom adds the bottom corner to the sides
	//But the bottom being transparent does not show the rest of the bottom
}
</style>
 
<span class='left'></span><span class='middle'>Hey</span><span class='right'></span>
Filed under: CSS No Comments
25Mar/110

jQuery Drop Down Menu

http://www.dynamicdrive.com/style/csslibrary/item/jquery_multi_level_css_menu_horizontal_blue/

Filed under: Javascript, jquery No Comments
25Mar/110

jQuery Apple Dock

http://www.wizzud.com/jqDock/

Filed under: Javascript, jquery No Comments
25Mar/110

jQuery Breadcrumb Navigation

http://www.comparenetworks.com/developers/jqueryplugins/jbreadcrumb.html

Filed under: Javascript, jquery No Comments
24Mar/110

Custom Ajax Loading Gifs

http://ajaxload.info/

24Mar/110

soapUI

Sometimes I have trouble with connectivity using nuSoap so to ensure it's the connection and not my program's issue I use soapUI.
http://www.eviware.com/soapUI/gallery.html

Filed under: PHP, SOAP No Comments
23Mar/110

Excel Loop through Cells

Loops come up in every programming language. This is how I like to loop through Excel Cells

1
2
3
4
5
6
7
8
9
10
11
12
13
Range("B4").Select
For i = 0 To 100
'Offset(row, column)
If Mid(ActiveCell.Offset(i, 0).Value, 1, 1) = "N" Then 'If the first letter is N
  If Worksheets("Sheet").Range("D3").Value = "thing" Then 'value on different Sheet
    ActiveCell.Offset(i, 0).EntireRow.Hidden = False 'Show this row
    ActiveCell.Offset(i, 1).Value = "awesome" '1 column right
    ActiveCell.Offset(i, -1).Value = "cool" '1 column left
  Else
    ActiveCell.Offset(i, 0).EntireRow.Hidden = True 'Hide this row
  End If
 End If
Next i
Filed under: Excel No Comments