Search results for query: *

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

Well, now I'm stuck on part two...Accessing elements of the above array. Doing any sort of myBools(1) causes #Value errors. The vartype for myBools is 8204...or an array of Variants. My guess is that, as an array of variants, the script can't determine where each element starts and ends...

I used google to refresh my memory on arrays (It's been a few years since doing a lot of VBA). What I read suggested that one can't assign an array to a range, but you van assign a varient containing an array to a range. I assumed that the expression was returning an array, so I changed the...

You are correct: it is an expression and what data type does this expression return? There's no "Array" data type, so a Range is the closest thing I could think of. Kevin

If one has a range of cells containing: A 1 1 2 0 3 3 4 0 5 5 And you type in a cell: =A1:A4>0 you get a result of {True False True False True}. If, however, you have a VBA function: Public Function NewFunc(myBools As Range) NewFunc = myBools End Function and call it as...

It would be great if I could use the ActiveCell functions, but I'm using this as a function and the cell containing the formula will not be the active cell. here's my full code: I want the cell's value to be a #N/A if the loop exists without finding a number in the other range or if the other...