Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dynamic charts (graphs) - what's the best approach?
I am running Perl and MySQL and want to create dynamic charts (All different types) and was wondering what do you recommend. -
Create Dynamic charts with PHP and MySQL
I am running PHP and MySQL and want to create dynamic charts (All different types) and was wondering what do you recommend. -
print and display values
I have not coded for while, so pardon the rustiness. I have two sets of values being pulled from a DB. 1 cat1 2 cat1 3 cat2 4 cat3 5 cat3 6 cat1 7 cat1 What I need to do is key off of 2nd filed and associate all values fron field 1. The number of values when reach a pre-defined limit should... -
tail the output and run another script without forking
My first script creates an output file, which the second script needs to parse real-time. Using system command, I was teeing and tailing the files as follows system("sc1.pl | tee out1.out | tail -f out1.out | sc2.pl | tee out2.out"); Both the output files get created but are empty. I can't... -
HLOOKUP, then VLOOKUP, then COUNT
I have a list of 3 columns PROD SD ED APP 1-1-2010 1-31-2010 SW 1-1-2010 1-11-2010 Lookup data is in the following format DATE APP SW 1-1-2010 1 3 1-2-2010 1 1 . . 1-31-2010 8 0 I can't get the formula right to do: First check if the PROD is listed in the...- max1x
- Thread
- Replies: 16
- Forum: Microsoft: Office
-
TWO VLOOKUPS in one argument not working
I'm using TWO VLOOKUPS to do some check and balances, across two worksheets via LOOKUP. If #N/A is returned by VLOOKUP, it prints ITEM NOT LISTED, but does not do the 2nd VLOOKUP to get the value needed. The 2nd VLOOKUP works and reports value if listed by it's self...- max1x
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
join two colums on different sheets and make hyperlink
In sheet1, coulum A I have a b c d e In sheet2, colum I have http://somelink= In sheet1, I did the following in column B HYPERLINK("sheet2!A1"&"sheet2!A1",A1) which creates http://somelink=a The problem is that when I copy the forumla down in the column on sheet1, colB, it keep on adding 1...- max1x
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Data Parsing of multiple lines into fields
I have been able to parse the data from many blocks and lines into single fields, but am running into a brain freeze for further correlation. Data looks as follows and I need to make it look like FINAL data. Any pointers and my brain will thank you. DATASET sig1 a b c d e sig1 f g h i j sig2... -
call function after spawn process
Once spawn is completed for ssh, there could be several scenarios that can encountered. I'm trying to figure out how to handle most within a function and then move to the main part of the script i.e spawn ssh -l us ser #Do pattern match of what could be, possibly within a function somehow if... -
trigger on table to update another
Using phpMyAdmin a table was created where a column is defined using SET from GUI. I have created a master table which provides data to all the secondary tables via a one to many relationship. I wanted to check with the experts before I start messing with live tables. Can I create an AFTER... -
Avoidig MySQL Injections
I use Net::MySQL as DBD and DBI don't install correctly. I have read the constuctors and mehtods for the module via CAPN, but I don't see an options to do escape(). Any suggestions on how I can do this with in the scope of using this module? -
Update on UNIQE field
I have a tbale userId = PK and AUTO_INCREMENT and e-mail = unique. When a new user is added, I use the INSERT key, but if an existing user updates their profile, I use REPLACE. This though treats the updated record as a new entry and updates the AUTO_INC (which I guess if fine). Is there a... -
data extraction from a table with 20Million records
I'm extracting data from a MySQL DB that has greather than 20 Million records in it and 12 fields (or columns) defined. The engine is MyISAM and the field I'm interested in is a defined as the primary key and as a BIGINT. The query takes 3-7 mins with a where clause. Is there anyway to... -
passing different number of arguments to a function.
I have function, which depending on how it's being called can have different number of arguments passed to it. I know how to set it up, when I know the # of args being passed, but not sure how to handle multiples. function tryThis(val1, val2) { var myVal1 = val1; var myVal2 = val2...- max1x
- Thread
- Replies: 3
- Forum: Javascript
-
wait for prompt then continue
I have to run a set of commands under a special environment with in a shell that changes the prompt. Is it possible to do this in ksh, csh or sh and not have to install Tcl/Expect. invoke new environment:--> this changes propmt from # to $ Run commands there Type exit to come to main shell...- max1x
- Thread
- Replies: 4
- Forum: UNIX Scripting
-
telnet using crypted password between sun boxes.
I would like to telnet from one box to another box using encrypted passwords. The crypted password is being pulled from a DB. I cannot figure out how the target box can understand the crypted passwd. SSH is not an option at this time unfortunately.- max1x
- Thread
- Replies: 4
- Forum: Sun: Solaris
-
how to update table with multiples values in one column
I have been asked to update a table which holds multiple values in ONE column COMP/IP/Port --> yes that is the column name :) CompA ip1 port1 CompA ip1 port2 CompA ip1 port3 now why not break them into diff fields is beyond me. Is there way to update the IP only and leave everything as is... -
rename table with "-" in it
A user created a table my-data, how can I rename it to mydata. -
Hung Results Page
I have a script that is called from the cgi page to be ran on a remote machine, results of which are displayed in the html page it's self. On the cgi page I have $| = 1 and am using telnet module with Timeout set to 700, since the remote script can take quite some time to finish... -
How to pass value to a variable.
I'm a complete novice to the this and here's what I'm trying to do: capture the value of send "set | grep TZ" to a variable. I tried set tzVal [send "set | grep TZ"] puts $tzVal but it seems to be completely off base here I am also unable to print expect_output(buffer), getting a not...
