Sponsored Content
Top Forums Shell Programming and Scripting How to read query string from shell script? Post 302828165 by Scott on Tuesday 2nd of July 2013 12:27:49 AM
Old 07-02-2013
Clearly, the problem is with the array (param=($QUERY_STRING)). Your shell doesn't support them, or doesn't support them in that format. You'll need to find an alternative way of getting the values.

i.e.
Code:
$ cat myScript
QUERY_STRING="a=1&b=2&c=3&d=4&e=5"
IFS='=&'
set -- $QUERY_STRING

echo $3 is $4
echo $9 is ${10}

$ ./myScript
b is 2
e is 5

# or

$ cat myScript
QUERY_STRING="a=1&b=2&c=3&d=4&e=5"
IFS='&'
set -- $QUERY_STRING
echo ${2%=*} is ${2#*=}

$ ./myScript
b is 2

You didn't answer either of my questions: Which Linux are you using, and what is a "device".
This User Gave Thanks to Scott For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

C Shell Script query

Hi I need a small help Cshell% more abc.txt ******** Cshell% cat abc.txt | cut -c1-3 *** Cshell%set test3=`cat abc.txt | cut -c1-3` Cshell%echo $test3 a.txt b.txt................. ..... It displays all the file in the current directory. I want *** to be displayed. Can any one of... (1 Reply)
Discussion started by: bpupdown
1 Replies

2. UNIX for Dummies Questions & Answers

Shell script query

Hi, I am stuck assigning a value to a variable. I am trying to assign a value to a variable but getting error.... IP_ADDR=grep 'I.P. Address' /install/cfgdist/`uname -n`.cfg | cut -d : -f 2| cut -d . -f 1-3| sed s/" "//g I am using this script to grep first three octets of an IP address... (4 Replies)
Discussion started by: max29583
4 Replies

3. Shell Programming and Scripting

query sql using shell script

query sql using shell script, is it possible? my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script? thanks in advance! (2 Replies)
Discussion started by: kingpeejay
2 Replies

4. Shell Programming and Scripting

shell script query

hi all i have a shell script for connecting in sybase env what i need is i have around 10 servers , i need to connect to all servers and retrive the database inforamtion in the servers and display them any one of u have it request to share it asap ! "QUERY TO Connect to all servers... (1 Reply)
Discussion started by: mvsramarao
1 Replies

5. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

6. Shell Programming and Scripting

shell script query

Hi Admins, I was trying to list the failed logins as part of my daily checklist. Here is my script for i in `who -s /etc/security/failedlogins|tail -100|grep "$dt"|awk '{print $1" "$6}'` do a=`echo $i|wc -l` if then echo $i else echo "There are no failed logins" fi done but... (3 Replies)
Discussion started by: newaix
3 Replies

7. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)
Discussion started by: DevendraG
2 Replies

8. Programming

Query result from shell script

Hi, I wrote the below script to get the query result from a Syabase DB. isql -s -U **** -P **** SYBASE SERVERNAME USE ***(Database name in Sybase) @command.sql But im not getting the output. Can anyone help me on this (2 Replies)
Discussion started by: rohan G
2 Replies

9. Shell Programming and Scripting

How do I read sql query into shell script?

Hello All, I'm trying to put together a shell script that will: 1. connect to an oracle database 2. execute a query 3. save the output to a csv file I know that I can execute the sqlplus -s user/pass @dbsid and get logged in. What I would like to do is have my query in a separate text... (9 Replies)
Discussion started by: bbbngowc
9 Replies

10. Shell Programming and Scripting

Shell Script (ksh) - SQLPlus query filter using a string variable

Using ksh, I am using SQLPlus to execute a query with a filter using a string variable. REPO_DB=DEV1 FOLDER_NM='U_nmalencia' FOLDER_CHECK=$(sqlplus -s /nolog <<EOF CONNECT user/pswd_select@${REPO_DB} set echo off heading off feedback off select subj_name from subject where... (5 Replies)
Discussion started by: nkm0brm
5 Replies
CGIPARSE(8)						     DACS Web Services Manual						       CGIPARSE(8)

NAME
cgiparse - CGI argument parsing utility SYNOPSIS
cgiparse [mode] [-enc {none | url | mime | dacs}] [-in filename] [-d] [-nonewline] [-qs query-string] [-copy filename] [[-n name filename]...] DESCRIPTION
This program is part of the DACS suite. It is a stand-alone program that neither accepts the usual DACS command line options (dacsoptions) nor accesses any DACS configuration files. This utility is used by web-based scripts (shell scripts in particular) to obtain their CGI arguments, which can be obtained from a URI's query component or in an encoded entity-body read from the standard input (as with the POST method). The form content types[1] application/x-www-form-urlencoded and multipart/form-data are both understood. The program has several different modes of operation, one of which may be specified by the first command line argument. cgiparse combines query arguments found in the QUERY_STRING environment variable with arguments found in the message body it reads from the standard input. If an argument name is duplicated the result is indeterminate. OPTIONS
The mode may be one of the following: -arg variable-name Emit the value of the CGI argument variable-name, then exit. If there is no such argument, the exit status will be 1 instead of 0. -targ variable-name Test if the CGI argument variable-name exists. If there is no such argument, the exit status will be 1, otherwise it will be 0. -html Emit an HTML document that lists the CGI argument names and their values. -one Emit a listing of the CGI argument values (without the names). -sh Emit CGI arguments as a single line in the format: variable-name='variable-value'; [...] It is an error if any variable-name or variable-value is syntactically unsuitable for this format. The returned string can be used as the argument to eval to set the CGI arguments as shell variables. -text Like -html except emit text. This is the default. With this mode, the program's stdout is usually written to a file. Each line of the file has the format: variable-name variable-value (a space separates the name from the corresponding value). The file is typically read by a script to obtain the arguments, or cgiparse can be run with the -in flag to retrieve an argument. Additionally, cgiparse recognizes these options: If writing the parsed CGI arguments (-text), encode the argument value using the specified method: url means URL encoding, mime means MIME base-64 encoding, and dacs means DACS base-64 encoding. For details about these encodings, please see dacs.exprs(5)[2]. The default is none, which means that no encoding is performed (use this only when you are sure this cannot cause a problem). If reading the parsed CGI arguments (-in), decode the argument values using the specified method. The default is none, which means that no decoding is performed; if the arguments were encoded, they will be returned in that encoding, but other than this case the decoding method must match the encoding method previously used or an error is likely to occur. -qs query-string Instead of using the environment variable QUERY_STRING to get a query component, use query-string. -nonewline With -arg, do not emit a newline after printing an argument value. -d Enable debugging output. -copy filename Append the input stream to filename. This can be useful for debugging purposes. -in filename Instead of parsing CGI arguments, read variable name/value pairs (as produced by the -text flag) from filename. If filename is "-", stdin is read. -n name filename If parsing succeeds, and there is a MIME body part with a name exactly matching name, then: o if the content disposition is multipart/form-data, write the content as quoted-printable text to filename; o if the content disposition is base64, write the decoded content to filename; o otherwise the content is written verbatim to filename. If the output file exists it is truncated. EXAMPLES
The following shell script demonstrates one way of using cgiparse. #! /bin/sh tmpfile=/tmp/cgiparse.$$ cgiparse > ${tmpfile} chmod 0600 ${tmpfile} echo "Context-Type: text/plain" echo "" done= while [ "${done}x" = x ] do a= b= read a b if [ $? = 1 ] then done=1 break else echo "Arg: ${a}" echo "Is: ${b}" fi done < ${tmpfile} rm -f ${tmpfile} exit 0 The following code fragment uses cgiparse to save and then look up its CGI arguments: #! /bin/sh tmpfile=/tmp/cgiparse.$$ trap 'rm -f ${tmpfile}; exit 1' EXIT 1 2 3 13 15 cgiparse -enc mime > ${tmpfile} chmod 0600 ${tmpfile} mode=`cgiparse -in ${tmpfile} -enc mime -arg MODE` target=`cgiparse -in ${tmpfile} -enc mime -arg TARGET` The following script will print "1 2 3" to its standard output: #! /bin/sh args=`cgiparse -sh -qs "a=1&b=2&c=3"` eval "$args" echo "$a $b $c" DIAGNOSTICS
The program exits 0 if everything was fine, 1 if an error occurred. BUGS
There do not appear to be any official recommendations concerning how to handle apparently "malformed" CGI query strings that do not look like a sequence of name=value pairs. The parsing routines that cgiparse uses will flag an error if they see strings containing a component like "=foo", for example, although "foo=" is fine. SEE ALSO
RFC 3875[3], The WWW Common Gateway Interface, Version 1.2[4], HTML 4.01 Specification[5], dacs_prenv(8)[6] AUTHOR
Distributed Systems Software (www.dss.ca[7]) COPYING
Copyright2003-2012 Distributed Systems Software. See the LICENSE[8] file that accompanies the distribution for licensing information. NOTES
1. form content types http://www.w3.org/TR/html401/interact/forms.html#h-17.13.4 2. dacs.exprs(5) http://dacs.dss.ca/man/dacs.exprs.5.html#encode 3. RFC 3875 http://www.rfc-editor.org/rfc/rfc3875.txt 4. The WWW Common Gateway Interface, Version 1.2 http://ken.coar.org/cgi/cgi-120-00a.html 5. HTML 4.01 Specification http://www.w3.org/TR/html4/ 6. dacs_prenv(8) http://dacs.dss.ca/man/dacs_prenv.8.html 7. www.dss.ca http://www.dss.ca 8. LICENSE http://dacs.dss.ca/man/../misc/LICENSE DACS 1.4.27b 10/22/2012 CGIPARSE(8)
All times are GMT -4. The time now is 08:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy