You want to default to YES, although I would personally do it the other way and force the user to enter a 'Y or y'.
However how about using the _wildcard_ '*'...
(On CygWin at the moment and don't have ksh available so using sh instead...)
Code:
#!/bin/sh
echo "is this SQL query ? Y/N"
read answer
case $answer in
N|n)
echo "got a 'no'"
;;
*)
echo "got a positive answer"
;;
esac
exit 0
Results on CygWin...
Code:
AMIGA:~> chmod 755 /tmp/yn.sh
AMIGA:~> cd /tmp
AMIGA:/tmp> dos2unix yn.sh
dos2unix: converting file yn.sh to Unix format ...
AMIGA:/tmp> ./yn.sh
is this SQL query ? Y/N
slkflksflksldkflskflksjf
got a positive answer
AMIGA:/tmp> ./yn.sh
is this SQL query ? Y/N
got a positive answer
AMIGA:/tmp> ./yn.sh
is this SQL query ? Y/N
Y
got a positive answer
AMIGA:/tmp> ./yn.sh
is this SQL query ? Y/N
y
got a positive answer
AMIGA:/tmp> ./yn.sh
is this SQL query ? Y/N
N
got a 'no'
AMIGA:/tmp> ./yn.sh
is this SQL query ? Y/N
n
got a 'no'
AMIGA:/tmp> _
Hello,
I am writing a script in ksh(for HP Unix)where a user must answer to a question . So I want to know kow to test if the user do not answer , so if he enter "REturn".
I don't know how to test "space characters" or "empty characters
Thanks for your help (2 Replies)
Wondering what this line meant, especially the 2>&1 and ${RUN_DIR} parts:
${RUN_DIR}/<filename> 2>&1
Where <filename> is the location and name of a file. (1 Reply)
i want to add about 60 printers using a ksh script.
i am having trouble though, i am reading the input from the hosts file and using the lpadmin command to add like so:
lpadmin -p -v /dev/null -m netstandard -o dest=
i want printername and ipaddy to come from the hosts file, i am having... (1 Reply)
Hi Folks,
I would just like to know how recursion works in ksh or inside a shell in general. I created the following script, but it works(runs recursively) only for 64 times:
----------------
#! /usr/bin/ksh
displaymessage()
{
echo "displaying count: $cnt "
echo "wait for 1 second..."... (1 Reply)
Hi,
I am looking at a script, and it contains lines like:
if ]
...
This is getting me confused. Why do we need $ before (echo $* | egrep -c 'DG')? Why can't we simply have:
if ]
... i.e. no $ here before the ()...
Thanks.
J (3 Replies)
Hello,
I wanted to setup user friendly ksh command prompt, by typing first character of files or directories and then tab bring up whole word. No need to type whole file/directory/command names.
Example:
cat a file like university
just typing un and then tab bring up whole university wod.... (3 Replies)
Hi All,
This is an embarrassingly simple question and couldn't think of "keywords" to search for the answer, but how do I change my UNIX/KSH prompt to show the machine name and my "current" but not "full" directory?
For example: if the machine name is "machine" and I'm currently in... (4 Replies)
Hi all,
The below command tries to copy ".tgz" instead of "hello_test.tgz" -- It seems as if the underscore gets in the way. I tried with different ways of using quotes, with no luck, unfortunately...it's probably very simple, but may I ask how this would be done:
How would the below be... (3 Replies)
Discussion started by: chatguy
3 Replies
LEARN ABOUT DEBIAN
class::dbi::abstractsearch
Class::DBI::AbstractSearch(3pm) User Contributed Perl Documentation Class::DBI::AbstractSearch(3pm)NAME
Class::DBI::AbstractSearch - Abstract Class::DBI's SQL with SQL::Abstract::Limit
SYNOPSIS
package CD::Music;
use Class::DBI::AbstractSearch;
package main;
my @music = CD::Music->search_where(
artist => [ 'Ozzy', 'Kelly' ],
status => { '!=', 'outdated' },
);
my @misc = CD::Music->search_where(
{ artist => [ 'Ozzy', 'Kelly' ],
status => { '!=', 'outdated' } },
{ order_by => "reldate DESC",
limit_dialect => 'LimitOffset',
limit => 1
offset => 2 });
DESCRIPTION
Class::DBI::AbstractSearch is a Class::DBI plugin to glue SQL::Abstract::Limit into Class::DBI.
METHODS
Using this module adds following methods into your data class.
search_where
$class->search_where(%where);
Takes a hash to specify WHERE clause. See SQL::Abstract for hash options.
$class->search_where(\%where,\%attrs);
Takes hash reference to specify WHERE clause. See SQL::Abstract for hash options. Takes a hash reference to specify additional query
attributes. Class::DBI::AbstractSearch uses these attributes:
o order_by
Array reference of fields that will be used to order the results of your query.
o limit_dialect
Scalar, DBI handle, object class, etc. that describes the syntax model for a LIMIT/OFFSET SQL clause. Please see
SQL::Abstract::Limit for more information.
o limit
Scalar value that will be used for LIMIT argument in a query.
o offset
Scalar value that will be used for OFFSET argument in a query.
Any other attributes are passed to the SQL::Abstract::Limit constructor, and can be used to control how queries are created. For
example, to use 'AND' instead of 'OR' by default, use:
$class->search_where(\%where, { logic => 'AND' });
AUTHOR
Tatsuhiko Miyagawa <miyagawa@bulknews.net> with some help from cdbi-talk mailing list, especially:
Tim Bunce
Simon Wilcox
Tony Bowden
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
Class::DBI, SQL::Abstract, SQL::Abstract::Limit
perl v5.10.0 2009-07-21 Class::DBI::AbstractSearch(3pm)