Search results for query: *

I am running Perl and MySQL and want to create dynamic charts (All different types) and was wondering what do you recommend.

I am running PHP and MySQL and want to create dynamic charts (All different types) and was wondering what do you recommend.

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

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

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

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

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

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

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

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

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?

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

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

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

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

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.

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

A user created a table my-data, how can I rename it to mydata.

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

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