06-24-2009
Doing "select *" isn't good form anyway. Only select the fields you want to return.
For example:
SELECT fname, lname, ordernum FROM order_queue WJERE NUM_OF_PICKUP >=3 AND TRANSACTION_TYPE=4 ;
If you absolutely must do a select * (and you don't) you can escape the * with a \. "SELECT \* FROM blah blah". But don't.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Using a HTML page , i'm running a Unix ksh script with <a href=..>.
The script contains loop like this :
for i in
do
rsh.....
done
each rsh command is running quite long and then i would display results in HTML format but about 5mn my blank page waiting for result is running in error... (1 Reply)
Discussion started by: Nicol
1 Replies
2. Shell Programming and Scripting
Hi all,
I've been assigned the task of modifying a script which reads in names of tables from a list file, exports a 30 days worth of data from these tables, then deletes the table. The list file will now contain a table name and a number next to it indicating how many days to archive. I need... (1 Reply)
Discussion started by: MadHatter
1 Replies
3. Shell Programming and Scripting
Hello,
I wonder whether if we have a open file dialog as (in gtk+) in html. I know that a submit-type form (such as <input value="Add File" type="submit">) opens such dialog, but it -naturally- tries to submit the file chosen. I only want to find out the file name, not upload it.
Thanks! (0 Replies)
Discussion started by: f33ldead
0 Replies
4. Shell Programming and Scripting
Hello,
I am using sed as follows -
sed 's/CONTACT SYSTEMS! Some payments have been rejected/<B><font color="red" size="5.0pt"CONTACT SYSTEMS! Some payments have been rejected</font></B>/' $REPORT_FILE
But while executing this, I am getting the error as -
sed: command garbled
&... (5 Replies)
Discussion started by: The Observer
5 Replies
5. UNIX for Advanced & Expert Users
Hi All,
I have written a script which sends mail using “sendmail” command and mail contains HTML code.
When I run scripts on terminal it is working properly, but when I try to run this script through a crontab file it sends blank mail with proper subject.
crontab file detail :
00 05... (1 Reply)
Discussion started by: abhishek.mind
1 Replies
6. Shell Programming and Scripting
Dear all.
I need to extract the title (text between <title> and </title>) of a set of HTML documents.
I've found a command that makes the work of extracting the text, but it does not always work.
It works with the next example:
cat a.txt
htmltext<title>This is a HTML... (2 Replies)
Discussion started by: i007
2 Replies
7. Shell Programming and Scripting
Hi
I have a successfullly run perl script (by issuing command "perl sub.pl" under shell mode) and this sub.pl will call sub.exp successfully. The sub.exp expect script is basically to login to a server and run some commands and put the output into a sub.txt file, it takes about 5 seconds to... (0 Replies)
Discussion started by: cxbest
0 Replies
8. Shell Programming and Scripting
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary=border
--border
Content-Type: text/html
Content-Disposition: inline
<html><body><h2>This text should be displayed with html formatting</h2></body></html>
--border
Content-Type: text/plain
Content-Disposition: attachment
This text... (2 Replies)
Discussion started by: thulasidharan2k
2 Replies
9. Shell Programming and Scripting
Hi All,
I'm new to this forum. This is my first question. I'm trying to automate the status related information in our environment. So this is how the output would be.
SEGMENT SERVER PORT1 PORT2 PORT3 PORT4 PORT5
ACS acscsa01 up up up up up
All... (2 Replies)
Discussion started by: anand.aswini
2 Replies
10. Shell Programming and Scripting
Hi ,
I am not able figure out how to use expect tool to send input to this prompt of format
Searching for disks...done
selecting c0t3d0
FORMAT MENU:
disk - select a disk
type - select (define) a disk type
partition - select (define) a partition... (3 Replies)
Discussion started by: chidori
3 Replies
LEARN ABOUT DEBIAN
www::mechanize::formfiller::value::interactive
WWW::Mechanize::FormFiller::Value::Interactive(3pm) User Contributed Perl Documentation WWW::Mechanize::FormFiller::Value::Interactive(3pm)
NAME
WWW::Mechanize::FormFiller::Value::Interactive - Ask the user to fill out a HTML form field
SYNOPSIS
use WWW::Mechanize::FormFiller;
use WWW::Mechanize::FormFiller::Value::Interactive;
my $f = WWW::Mechanize::FormFiller->new();
# Ask the user for the "login"
my $login = WWW::Mechanize::FormFiller::Value::Interactive->new( 'login' );
$f->add_value( login => $login );
# Alternatively take the following shorthand, which adds the
# field to the list as well :
# "Ask the user for the password"
my $password = $f->add_filler( password => 'Interactive' );
DESCRIPTION
This class provides a way to write a value read from STDIN into a HTML field.
new NAME
Creates a new value which will correspond to the HTML field "NAME".
name [NEWNAME]
Gets and sets the name of the HTML field this value corresponds to.
value FIELD
Returns the value to put into the HTML field. The value will be read from STDIN. The name of the HTML field to be read and the current
value will be printed to STDOUT. An empty string will use the given default. There currently is no way to enter an empty string if
there is a different default string.
EXPORT
None by default.
COPYRIGHT AND LICENSE
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
Copyright (C) 2002,2003 Max Maischein
AUTHOR
Max Maischein, <corion@cpan.org>
Please contact me if you find bugs or otherwise improve the module. More tests are also very welcome !
SEE ALSO
WWW::Mechanize, WWW::Mechanize::Shell, WWW::Mechanize::FormFiller, WWW::Mechanize::FormFiller::Value::Value,
WWW::Mechanize::FormFiller::Value::Default, WWW::Mechanize::FormFiller::Value::Random, WWW::Mechanize::FormFiller::Value::Fixed
perl v5.10.1 2009-04-24 WWW::Mechanize::FormFiller::Value::Interactive(3pm)