Recent content by beakerboy

I'm setting up a database to store laboratory analytical data: I have a 'sample' table with a sample_id, sample_date, sample_location (when was the sample take, and from where) I have a 'method' table with method_id, method_name and method_table_name (name of the analytical method and what...

I moved the get references to session and it works perfectly! Much easier than I was thinking before your suggestion.

I'm running PHP 5.2.9-2 $year1=$year2=$year3=2009; while ($year1 <= date('Y')){ $array1[$year1] = $year1 . "-" . ++$year1; $array2[$year2+0] = $year2 . "-" . ++$year2; $array3[$year3+1] = $year3 . "-" . ++$year3; } print_r($array1); print_r($array2); print_r($array3); Produces the...

Using using session data is a great idea! Thanks. Kevin

I'm using a package called Image_Graph to produce some scatter plots on the fly in a website. The way this file works is, it accepts values as $_GET parameters and produces a png image. You call it with <img src="Image_Graph?title=foo&x0=1&y0=0...."> It works great, but I have so much data that...

I'm using a package called Image_Graph to produce some scatter plots on the fly. The way this file works is, it accepts values as $_GET parameters and produces a png image. You call it with <img src="Image_Graph?title=foo&x0=1&y0=0...."> It works great, but I have so much data that the URL is...

Got It. I rearranged the function and it works Sub set_color() ActiveSheet.ChartObjects("Chart 3").Activate For i = 1 To 24 Dim color color = Cells(i, 4).value ActiveChart.SeriesCollection(1).Points(i).Format.Fill.ForeColor.RGB = RGB(color, 0, 0) Next i End Sub

I guess that might be the simplest way. I was trying this: Sub set_color() ActiveSheet.ChartObjects("Chart 3").Activate ActiveChart.SeriesCollection(1).Select For i = 1 To 24 ActiveChart.SeriesCollection(1).Points(i).Select Dim color color = Cells(i, 4).value...

I have a worksheet with three columns; an x value, a y value and a confidence value. I'd love to be able to plot the x and y in a scatter plot, and use the confidence value somehow in the marker color. I could easily add 3 more columns for RGB values and manipulate them using the confidence if...

Thanks!! This opens up a new window for me. I've never used anything except NATURAL INNER JOINs. I've never even considered anything besides PK, FK joins on equal values, so this will have some broad-reaching consequences in a lot of my projects. I'll try this in my PostgreSQL database, but a...

I have two tables: sample has three columns; s_id (int), s_start(timestamp), and s_end(timestamp) temp has two columns; t_timestamp (timestamp), and t_temp (real) I want to do the following: for each row in sample, return the s_id and the average temperature from temp between the times...

I have a spreadsheet which is being used as a logsheet in a manufacturing facilty. I have a webserver running a PosgreSQL database and PHP and a decent web site running with pages allowing entry of this data into the database through a form. I also have a method where I can cut the data from...

I put so much effort into getting IP Passthrough to work that I didn't even think about port forwarding. I set my wireless router to port-forward http and ssh from my server and all is good.

I have DSL service from Bellsouth. My service is a static IP, but that IP address is handed out by a DHCP server. The server hands out the following: WAN IP Address 65.5.248.x Gateway IP Address 68.152.239.152 Netmask: 255.255.0.0 Now my understanding of network protocols says this...

I'm trying to move some matlab code over to vba. One commonly used matlab function takes a vector of booleans and extracts only those elements from another vector where the boolean value at the same position is true. My problem is I keep getting #VALUE errors if I try to access the myBool...