Programming :: Finding Particular Ranges Of Results In MySQL?
Jan 20, 2009How do I find for example the 4th to the 9th result in a particular SELECT query?
View 6 Replies
ADVERTISEMENT
Programming :: Looping Over Mysql Query Results In Bash?
Sep 15, 2010I am querying a single string column in a table. The string values have spaces in them. I want to loop over each value in bash. I set IFS to split lists on newlines instead of spaces. When I try this, it is splitting the list of results on the actual character 'n', not the newline ''.
DATA=`mysql -u root -ppassword --silent 'SELECT name FROM table_a;'`
IFS=$'
'
for i in $DATA; do
echo "item = $i"
[Code]....
Programming :: Compress Ip Address Ranges?
Sep 19, 2010I've googled til my brain went boom... So the short story goes; I have lots of ip address ranges in multiple files which need to go into an iptables firewall... Sounds simple right?
Example of files:
1.0.1.0-1.0.1.255
1.0.1.0-1.1.0.255
[code]....
Programming :: Modify Script Loading Array With Ranges Of Lines In Awk?
Mar 15, 2011As awk programmers may know, we can print range of lines with awk, from an initial pattern until a final pattern as follow:
Code:
awk '/Initial_String/,/Final_String/' inputfile
Well, I have this inputfile:
Code:
[code]...
Once having those elements in that way within an array(a[]), I want to be able to manipulate the array (a[]) and copy its elements
to another array (b[]) in different order (all lines joined in a single line separated with commas), as follow:
Code:
Category,Adventure,Titles,Robinson,Crusoe,Saturday,Authors,Daniel-Defoe,Ian-McEwan
Only inserting the missing "array" coding and based and follow the code I've written Not needed to create a new code to do it with other method.
Programming :: Shell Script To Convert Values On Successive Lines Into Consecutive Ranges?
Jul 7, 2010I have a series of input files formatted like this:
Code:
RTREVF, KOG3266 = 111
RTREVF, KOG3294 = 130
RTREVF, KOG3295 = 177
WAGF, KOG3307 = 107
JTTF, KOG3320 = 174
Each line represents a portion of a data matrix. I want to convert the numbers after the "=" to the range of that partition in the matrix such that the output file looks like this:
Code:
RTREVF, KOG3266 = 1-111
RTREVF, KOG3294 = 112-241
RTREVF, KOG3295 = 242-418
WAGF, KOG3307 = 419-525
JTTF, KOG3320 = 526-699
Programming :: Get Similar Results Using Both Gcc And G++
Mar 7, 2011consider these lines of code and their outputs:
[CODE]
int C = 0;
fprintf(stdout, "
(C, ++C) Bef = %d, Aft = %d
", C, ++C);
fprintf(stdout, "(C++, C) Bef = %d, Aft = %d
", C++, C);
[Code].....
The only one that looks right to me is the second one. I get similar results using both gcc and g++.
Programming :: Arrange The Results In The Shell?
May 10, 2010Im having problems with this little thing in a C example Im doing. I want to show in the shell like this example:
Name Birthday
Tomas 13
Adrian 24
Nate 15
Im trying to use the printf function but the names doesnt have the same lenght. So I cant do it like this:
printf("Name Bithday
");
printf("%s %d
");
Programming :: Store The Results In An Array?
Apr 13, 2010i have a loop which produces new value everytime it runs. i want to store the results in an array. how can i do dat??
loop is like:
a=0
declare v
while ((....))
do
v[$a]="$r"
let a=a+1
done
while doing this it is not treating v as array but as variable and it is overriding the value and old value is lost..i am using bash shell version 3.00.15
Programming :: Get Search Results To Array By Awk?
May 5, 2010I have this multiline variable code...
View 5 Replies View RelatedProgramming :: IPv6: Using Results From Recvfrom()
Jul 25, 2011I have a socket library that I tinker with from time to time. Lately, I decided to expand it to support IPv6.
One of the issues I am having is sending data, using sendto(). When the server receives data from a client, using recvfrom(), it does not retain the sockaddr_in information, but instead provides the callee the IPv6 address and port number from where the data originated. See here:
Code:
int
UDPSocket::recv(char* buffer, size_t bufferLen, std::string& sourceAddr, unsigned short& sourcePort)
{
sockaddr_in sin;
socklen_t sinLen = sizeof(sin);
[Code]....
Programming :: Splitting Results In More Web Pages?
Apr 1, 2010I've a web page where I can search information in my database.Sometimes results of search operation are more of fifty.How can I split results in different web page as it happens for example in any search engine or operation
View 7 Replies View RelatedProgramming :: Unusual Encryption Results With Php's Mcrypt?
May 30, 2010I have a simple class that encrypts strings. It seemed to be working fine until I tried to compare the decrypted values to the original. below is the output of the php code. It appears to be decrypted but the length is incorrect.
String Before Encryption: a text string
String Length Before Encryption: 13
String After Encryption: rew2iSYotruIpmJ3llos3A==
[code]...
Programming :: Expect/TCL - Unable To Get The Correct Results
Feb 8, 2011I'll post the entire code here, and then specifically highlight what is just failing in a fashion I'm apparently incapable of fixing a few hours later:
Code:
#!/usr/bin/expect
# The script should be called with a file in the directory called sshServerList
# That file has the following format:
# Line # | Contents of line
[code]....
I've had all kinds of different results and problems, but I've never been able to successfully log into multiple servers, though the first server in the list most times works okay (though might not on this iteration). I'm a bit hack and slash and I would be very greatful not only for a solution, but any tips on how I should have done this and places where I could clean up my code.
Programming :: GCC And G++ Build Results If The -march=TYPE Is Not Specified?
May 25, 2010I'm sure this has been covered somewhere before, but I couldn't find anything and so figured I would post here. I have been using Linux OSes for the past couple of years and also using GCC/G++ for application development. However, I have almost always been on x86 systems and never gained much experience using the wide range of optimization options available.
My question is, if I do not specify the -march=PROCTYPE option, will GCC still be able to detect the current architecture and build the code accordingly? I primarily ask this because I am working with an x86_64 system, and specifying -march=x86_64 in my makefiles generates errors about it being an unknown processor type, even though the CPU and OS are X86_64. I know this sounds like a newbie question, but it's just ground I've never had to cover before until now.
Programming :: TCL / Expect - IF Results Are Different Then Send A Command?
Dec 11, 2010trying to see IF i dont get the right results repeat the command until it will or quit after 3 tries....
expect -exact "->"
send -- "test_read_register 0,0x37
"
if {! [regexp {Address 0x00000000} do send -- "test_read_register 0,0x37
[code]....
It should read
Read: Address 0x00000037, Data: 0x0000000b
but sometimes it comes out to this
Read: Address 0x00000000, Data: 0x00000000
therefore ill have to run the command again IF I Dont get the right results...
Programming :: Encryption / Decryption Program - Getting Different Results Every Time
May 9, 2011I am having trouble with encryption/ decryption program. The program goes out and finds the file I want it to, encrypts it into a continuing series of a single repeated negative number, then generally decrypts(or should i say re-encrypts)it into a widely repeated character, different but same results every time.
[Code]....
Programming :: List Specific Files And Delete Results?
Jul 8, 2011I ran the command:
Code:
ls -ltr | head -n40
I'd like to delete all the files listed...
Programming :: Shell Script Query - How To Achieve The Results
Feb 7, 2010how do I achieve the result but here is the story. I have a script which prompts for the IP Address and read that value and validate if reachable. If not then it should keep on prompting until the IP is reachable. I tried using until loop as well as while loop but dang..Here are the codes
#!/bin/bash
IP_Feed () {
echo -n "Give me IP : "
[code]....
Programming :: Same Program Runs Multiple Times But Get Very Different Results?
Dec 7, 2010I used wait4 to time a child process. but the results differ each other dramatically. why?my core source code lists as below.to the point: in linux 2.6 kernel, how to time a process with a high precision. and, only its user-time rather than the elapsed time???
static struct rusage ruse;
static pid_t u_pid;
int main(int argc, char *argv[])
{
int i;
code....
Programming :: Save The Results Of A Fortran Loop In A Text File?
Nov 2, 2010I am trying to store the results of my code to a separate text file.But the problem is, as my results comes from a loop, my text file shows only the last result, not all of them.Like if the loop runs 5 time the text file shows the result for the 5th step.But i need to store all of them (1 to 5).Can I use awk to print the output field and store to another file and creat a new line so that the next output field goes to a new line?(just an idea, dont know).
#!/bin/basth
for (( i=1; i<=5; i++))
do
./file.exe > output.txt
done
Programming :: Bash : Searching For Info And Changing The Color Of Keywords In The Results?
May 5, 2011(bare with me as I am sort of new with scripting) I am trying to figure out how to run a script that does a basic chkconfig and to get only those services that are running, but changing the color of "on" to red in my output file. Here is what I am working with so far:
Quote:
#/bin/bash
RED=$(tput setaf 1)
BLK=$(tput setaf 0)
[code]....
*I had to substitute a "-" and <colon_symbol> for ":" in front of the on's, because the forum thought they were smiley faces (i.e. n) how to make the "on" to be red while the rest of everything remains in black text. I have been trying to read up on sed and awk, but it is still pretty much a mystery to me right now. There will be other things in the output file that I wouldn't want a rogue "on" to be in red, so just the instances of "on" in that one chkconfig return.
Programming :: Error ""Can't Connect To Local MySQL Server Through Socket" In Connecting To MySQL In C Language
Sep 29, 2010I wrote a code in C to connect to MySQL by using mysql_real_connect function but I recieved error "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" (by using mysql_error function).
I also did the following things: in mysql I typed 'SHOW VARIABLES LIKE '%SOCKET%'', it returned /var/lib/mysql/mysql.sock I typed 'mysql_config --socket' in shell, it returned /var/lib/mysql/mysql.sock I modified /etc/my.cnf file
General :: Run Script Unless Between Time Ranges?
Aug 8, 2009I use speech for a lot of notifications, email, time every 30 minutes, system alerts, etc... but there are times when I do not want the speech, because I am on a conference call or have an open mic.
View 5 Replies View RelatedProgramming :: Script To Read Active Squid Logfile And Output Results To Html Based On Conditions?
Mar 12, 2010Basically the requirement of the script are :
1. need to run like a daemon which will read an active squid logfile in a refresh pattern of 5 minutes
2. calculate the total number requests based on different domains that the client access
3. calculate the total of number of requests based on different domains as well as the turnaround time of these access is more than 5 sec that the client access
4. calculate percentage of item 3 over item 2
5. report the results in html format as follows:
Domain Name Total req Req > 5 sec % of req > 5 sec
6. able to access the results from web browser.
Networking :: Manually Determining Ip Address Ranges?
Sep 8, 2009I am trying to remember the procedure used to determine the ip address range when given a network address and its subnet mask. Does anyone have any documentation on the steps that are done to accomplish this?
View 6 Replies View RelatedGeneral :: Fixing Ranges Using Shell Script?
Dec 3, 2010I have the datafile like this. I have to subtract 20 to the left of that number and add 120 to the right of that number. Output also given.Quote:
Input:
Chr5:26236044-26236064
Chr25:2622227-2622247
[code]....
Software :: Configure IPTABLES To Allow Certain IP Ranges To Ports 25 And 465?
Feb 16, 2011I have a mail server with IPTABLES enabled.I want to allow access to:
41.0.0.0/8
58.0.0.0/8
61.0.0.0/8
[code]....
General :: Saving The Results Of The Time Command While Discarding The Results Of The Command Being Timed
Apr 6, 2010I'm timing how long it takes to run a command foo. I'm looking to append the results from the time command to a file, and discard the results from the foo command. I tried the following, but it didn't do what I want:
$ time ./foo > /dev/null >> output_from_time_command.txt
Programming :: Pass Variable In Mysql Qyery In C Programming?
Dec 4, 2010i want to pass variable in mysql qyery in c programming
View 1 Replies View RelatedGeneral :: Capture Packets With WireShark On 2 Port Ranges?
Jul 3, 2010I'm trying to capture packets with WireShark on 2 port ranges.
This syntax is not working :
Quote:
bash-3.2# /usr/sbin/tcpdump -ttttvv udp portrange 8500-8600 and portrange 5060-5070
There is no output...
What is the correct syntax for defining multiple port ranges ??