question

[Pier Gaetano Novara]

I have this statement:
DELETE FROM
TMP_TABLE_MERGE
WHERE EXISTS
(SELECT 1 FROM
TMP_TABLE_1 T1
WHERE
TMP_TABLE_MERGE.OBJECT_ID = T1.OBJECT_ID)

In both the table TMP_TABLE_MERGE and TMP_TABLE_1 the field OBJECT_ID is the
primary key but in the Explain Plan the table TMP_TABLE_MERGE is acessed in
full scan mode.
Do someone knows how can I force the use of the primary keys?
Thanks
Pier

[Tim]

On Sat, 4 Jan 2003 14:20:33 +0100, "Pier Gaetano Novara"
<pgaetanoNoSpam@csc.com> wrote:

>I have this statement:
>DELETE FROM
> TMP_TABLE_MERGE
>WHERE EXISTS
> (SELECT 1 FROM
> TMP_TABLE_1 T1
> WHERE
> TMP_TABLE_MERGE.OBJECT_ID = T1.OBJECT_ID)
>
>In both the table TMP_TABLE_MERGE and TMP_TABLE_1 the field OBJECT_ID is the
>primary key but in the Explain Plan the table TMP_TABLE_MERGE is acessed in
>full scan mode.
>Do someone knows how can I force the use of the primary keys?
>Thanks
>Pier
>

What percentage of the rows in TMP_TABLE_MERGE match the WHERE
condition? If it's greater than 15% or so, it may be more efficient
to do a table scan than to use the index. Make sure you run analyze
statistics if using CBO also.

[Richard Foote]

"Tim" <df@sd.net> wrote in message
news:5djg1vk6n61a19pu2m2rgacqd4snfdvsck@4ax.com...

> On Sat, 4 Jan 2003 14:20:33 +0100, "Pier Gaetano Novara"
> <pgaetanoNoSpam@csc.com> wrote:
>

> >I have this statement:
> >DELETE FROM
> > TMP_TABLE_MERGE
> >WHERE EXISTS
> > (SELECT 1 FROM
> > TMP_TABLE_1 T1
> > WHERE
> > TMP_TABLE_MERGE.OBJECT_ID = T1.OBJECT_ID)
> >
> >In both the table TMP_TABLE_MERGE and TMP_TABLE_1 the field OBJECT_ID is

the

> >primary key but in the Explain Plan the table TMP_TABLE_MERGE is acessed

in

> >full scan mode.
> >Do someone knows how can I force the use of the primary keys?
> >Thanks
> >Pier
> >

>
> What percentage of the rows in TMP_TABLE_MERGE match the WHERE
> condition? If it's greater than 15% or so, it may be more efficient
> to do a table scan than to use the index. Make sure you run analyze
> statistics if using CBO also.

Hi Tim/Pier,

Couple of little points.

Firstly, the percentage of rows that need to be accessed from the
TMP_MERGE_TABLE is going to be somewhat more than 15%. It's going to be
100%. The sub-select is a correlated subquery and as there are no additional
predicates after it, Oracle has no choice (as the statement is currently
written) but to read all rows in the outer query in order for it to
determine if a corresponding row matches the inner query.

Secondly, I have a little shudder when someone mentions a percentage of
*rows* when discussing what the CBO might or might not do. Oracle may decide
to use a FTS if it requires 0.01% of rows, it might decide to use an index
if it requires 99.9% of rows. The percentage of rows has nothing to do per
se with how the optimizer decides to strut it's stuff. The percentage of
blocks that need to be accessed is a touch more accurate but even such
analysis is mis-leading. It's a little general I know but it really is the
*cost* (hence the optimizer's name) of the various possible access paths
that is the determining factor and it's simple issues such as the number of
rows per block, the fragmentation of the segments, the perceive efficiencies
of sorts, multiblock reads, index caching, parallelism etc. that makes the
percentage of rows rule(s) of thumb such a dangerous one to go by.

What are these costs ? This is a whole whopper of a discussion but CPU, I/O,
network overheads are some components of the mix and for those lucky enough
to go to Jonathon Lewis's IOUG-A class, I'm sure will have all the juicy
details revealed (note this plug attracts a 10% commission ;)

Cheers

Richard

[Chance Hopkins]

it won't

you need vs 2003


"Paul Finn" <digital_function@hotmail.com> wrote in message
news:#cZPkPSPDHA.1748@TK2MSFTNGP11.phx.gbl...

> i have this problem
>
> i installed vs.net that comes with .net framework v1
> and today i installed a new version of .net framework (v1.1)
> and i dont know if vs.net is going to use that new version
>
> how can i tell? is there a way
>
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[Terry Orzechowski]

It sure does not make sense that it would not since the
deployment of the new version of .net precedes the release
of VS 2003 by close to a year.

>-----Original Message-----
>i have this problem
>
>i installed vs.net that comes with .net framework v1
>and today i installed a new version of .net framework

(v1.1)

>and i dont know if vs.net is going to use that new version
>
>how can i tell? is there a way
>
>
>
>*** Sent via Developersdex [url]http://www.developersdex.com[/url]

***

>Don't just participate in USENET...get rewarded for it!
>.
>

[Kevin Spencer]

Since both versions are on the machine, he doesn't need VS.Net 2003 unless
he wants to use the 1.1 Framework.

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
[url]http://www.takempis.com[/url]
Big things are made up of
lots of Little things.

"Chance Hopkins" <chance_hopkins@hotmail.com> wrote in message
news:udlAdPUPDHA.2228@tk2msftngp13.phx.gbl...

> it won't
>
> you need vs 2003
>
>
> "Paul Finn" <digital_function@hotmail.com> wrote in message
> news:#cZPkPSPDHA.1748@TK2MSFTNGP11.phx.gbl...

> > i have this problem
> >
> > i installed vs.net that comes with .net framework v1
> > and today i installed a new version of .net framework (v1.1)
> > and i dont know if vs.net is going to use that new version
> >
> > how can i tell? is there a way
> >
> >
> >
> > *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> > Don't just participate in USENET...get rewarded for it!

>
>

[Alvaro Rosales R.]

Hi guys,I am new to PHP and I am writing my forst scripts, so maybe this quesetion
is a kinda stupid, but it is driving me crazy, can you tell meHow can I set a line
break in long line of my code?.
thanks in advance!

[Bill]

What happened to my post here, I never received an answer.

Bill Noel

[Dan Vendel *GOF*]

Bill wrote:

> What happened to my post here, I never received an answer.
>
> Bill Noel
>
>
>

Since there are 500-1,000 questions posted here daily, it's perhaps a
bit too much to expect people to recall you and your question. Can you
post it again?

--
Dan Vendel - *GOF*
[url]http://www.vendel.info[/url]
Contact me directly by clicking here:
[url]http://contact.vendel.info[/url]
Formmail tutorial:
[url]http://www.vendel.info/tut/formmail.html[/url]
Nested table demonstration:
[url]http://www.vendel.info/tabletut/[/url]

[Lito Dagodog]

i have a question?
i have 3 files of PHP and the codes are as follows.

variables.inc
<?php
$host = $_POST["host"];
$username = $_POST["user"];
$password = $_POST["password"];
$dbname = $_POST["dbname"];
$tblname = $_POST["table"];
$field = $_POST["field"];
$value = $_POST["value"];
?>

createDB.php
<?php
include ('createtbl.php');
?>

createtbl.php
<?php
include ('variable.inc');
?>


How come that the text inside the variable.inc will be shown in
createtbl.php?

[Matthias Schraft]

Hi,

I´m new with perl. I need to write a program that reads data out of a form
sent via internet and is able to interpret the data.
I have written the form in html. Is perl right for the other parts? How can
I do this easyly? Are there any pre-witten programs or modules existing for
that?

Thanks
Matt

--
NEU FÜR ALLE - GMX MediaCenter - für Fotos, Musik, Dateien...
Fotoalbum, File Sharing, MMS, Multimedia-Gruß, GMX FotoService

Jetzt kostenlos anmelden unter [url]http://www.gmx.net[/url]

+++ GMX - die erste Adresse für Mail, Message, More! +++

[Dan Muey]

> Hi,

Howdy

>
> I´m new with perl. I need to write a program that reads data
> out of a form sent via internet and is able to interpret the
> data. I have written the form in html. Is perl right for the
> other parts? How can I do this easyly? Are there any

You bet! You could also use the same script to print out your
html form and now the form and the form processor are all in
one place. Just an idea...

> pre-witten programs or modules existing for that?

Oh yes, it's super easy:

use CGI qw(param header);
# this import's the param and header functions from the CGI
# module which is a core module so you'll have it installed.

my $name = param('name'); # where 'name' was the input tag's name attribute.
print header();
print "Hello <b>$name</b> - How are you today?<br />\n";

You can handle multiple entry checkbox or select input's and other wise
handle your html form input with param().

Check out CGI.pm 's page on CPAN for even more cool stuff you
can do with it.

HTH

DMuey

>
> Thanks
> Matt

[John Dillon]

>I´m new with perl. I need to write a program that reads data out of a form

>sent via internet and is able to interpret the data.
>I have written the form in html. Is perl right for the other parts? How can
>I do this easyly? Are there any pre-witten programs or modules existing for
>that?

************************************************** **************************
**

PHP is what I use. [url]www.php.net[/url] is easier than anything I've found on perl.
See also database language on the slightly confusing [url]www.mysql.com[/url]. PHP
database query looks like this:

$myquery = "SELECT table.field FROM table WHERE table.field =
'$variable'";
$result = mysql_db_query($db, $myquery, $connection) or die
("myquery failed.");
$arr = array();
$x = 0;
while(list($a) = mysql_fetch_array($result))
{
$arr[$x] = $a;
$x++;
}

Variables are GETed or POSTed automatically with the form on submit. You
can use regex's also.

While this is off-topic re Perl, it's also a good idea to have an
informative subject line, like: "Parsing HTML form output: to use or not to
use Perl?" that is the question!

John





*******************************************[url]http://www.cantor.com[/url]
CONFIDENTIAL: This e-mail, including its contents and attachments, if any, are confidential. If you are not the named recipient please notify the sender and immediately delete it. You may not disseminate, distribute, or forward this e-mail message or disclose its contents to anybody else. Copyright and any other intellectual property rights in its contents are the sole property of Cantor Fitzgerald.
E-mail transmission cannot be guaranteed to be secure or error-free. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.
Although we routinely screen for viruses, addressees should check thise-mail and any attachments for viruses. We make no representation or warranty as to the absence of viruses in this e-mail or any attachments. Please note that to ensure regulatory compliance and for the protection of our customers and business, we may monitor and read e-mails sent to and from our server(s).

For further important information, please read the Important Legal Information and Legal Statement at [url]http://www.cantor.com/legal_information.html[/url]

[Levon Barker]

Oh here we go.

> -----Original Message-----
> From: Dillon, John [mailto:JDillon@cantor.co.uk]
> Sent: Wednesday, November 12, 2003 10:57 AM
> To: 'Matthias Schraft'
> Cc: 'beginners@perl.org'
> Subject: RE: question
>
>

> >I´m new with perl. I need to write a program that reads data out

> of a form

> >sent via internet and is able to interpret the data.
> >I have written the form in html. Is perl right for the other

> parts? How can

> >I do this easyly? Are there any pre-witten programs or modules

> existing for

> >that?

> ************************************************** ****************
> **********
> **
>
> PHP is what I use. [url]www.php.net[/url] is easier than anything I've
> found on perl.
> See also database language on the slightly confusing [url]www.mysql.com[/url]. PHP
> database query looks like this:
>
> $myquery = "SELECT table.field FROM table WHERE table.field =
> '$variable'";
> $result = mysql_db_query($db, $myquery, $connection) or die
> ("myquery failed.");
> $arr = array();
> $x = 0;
> while(list($a) = mysql_fetch_array($result))
> {
> $arr[$x] = $a;
> $x++;
> }
>
> Variables are GETed or POSTed automatically with the form on submit. You
> can use regex's also.
>
> While this is off-topic re Perl, it's also a good idea to have an
> informative subject line, like: "Parsing HTML form output: to use
> or not to
> use Perl?" that is the question!
>
> John
>
>
>
>
>
> *******************************************[url]http://www.cantor.com[/url]
> CONFIDENTIAL: This e-mail, including its contents and
> attachments, if any, are confidential. If you are not the named
> recipient please notify the sender and immediately delete it. You
> may not disseminate, distribute, or forward this e-mail message
> or disclose its contents to anybody else. Copyright and any other
> intellectual property rights in its contents are the sole
> property of Cantor Fitzgerald.
> E-mail transmission cannot be guaranteed to be secure or
> error-free. The sender therefore does not accept liability for
> any errors or omissions in the contents of this message which
> arise as a result of e-mail transmission. If verification is
> required please request a hard-copy version.
> Although we routinely screen for viruses, addressees should
> check this e-mail and any attachments for viruses. We make no
> representation or warranty as to the absence of viruses in this
> e-mail or any attachments. Please note that to ensure regulatory
> compliance and for the protection of our customers and business,
> we may monitor and read e-mails sent to and from our server(s).
>
> For further important information, please read the Important
> Legal Information and Legal Statement at
> [url]http://www.cantor.com/legal_information.html[/url]
>
>
> --
> To unsubscribe, e-mail: [email]beginners-unsubscribe@perl.org[/email]
> For additional commands, e-mail: [email]beginners-help@perl.org[/email]
>

[Dan Muey]

> >I´m new with perl. I need to write a program that reads data

> out of a

> >form sent via internet and is able to interpret the data. I have
> >written the form in html. Is perl right for the other parts?

> How can I

> >do this easyly? Are there any pre-witten programs or modules

> existing

> >for that?

> ************************************************** ************
> **************
> **
>

Flames of rath!!! :)

> PHP is what I use. [url]www.php.net[/url] is easier than anything I've
> found on perl. See also database language on the slightly

Yeah right have yiu even used param in CGI. I personally don't like
that variable being declared for me, it seems insecure as a user
could use that knowledge to get info they shouldn't among other thigns.

> confusing [url]www.mysql.com[/url]. PHP database query looks like this:
>
> $myquery = "SELECT table.field FROM table WHERE
> table.field = '$variable'";

What if $variable has single quotes or commas or other sql breaking
stuff, Mr PHP pants? Or evil query altering input hat deletes
records or drops tables or something?

> $result = mysql_db_query($db, $myquery, $connection) or
> die ("myquery failed.");
> $arr = array();
> $x = 0;
> while(list($a) = mysql_fetch_array($result))
> {
> $arr[$x] = $a;
> $x++;
> }

Perl's database query can look like this:

my $query = "SELECT monkey, foo, bar from JoeMama WHERE You =".$dbh->quote($variable);
my $res = $dbh->selectall_arrayref($query) or die 'My query failed'.$dbh->errstr();
for(@{$res}) {
my ($mon,$foo,$bar) = @{$_};
do whatever with each record
}

And what does this have to do with parsing form input anyway?

Why is it PHP people always act like PHP is the only thing
that can use databases, send email , and get form input?

Administering PHP on a server is a pain in the rear.

Don't worry everyone, I'm done ranting and shall speak no more of this post :)

>
> Variables are GETed or POSTed automatically with the form on
> submit. You can use regex's also.
>
> While this is off-topic re Perl, it's also a good idea to
> have an informative subject line, like: "Parsing HTML form
> output: to use or not to use Perl?" that is the question!
>
> John

[Tore Aursand]

On Wed, 12 Nov 2003 15:56:39 +0000, Dillon, John wrote:

>> I´m new with perl. I need to write a program that reads data out of a
>> form
>> sent via internet and is able to interpret the data. I have written the
>> form in html. Is perl right for the other parts? How can I do this
>> easyly? Are there any pre-witten programs or modules existing for that?

> PHP is what I use.

Why do you post PHP code in a Perl newsgroup?

> [url]www.php.net[/url] is easier than anything I've found on perl.

You mean that that the web-site [url]www.php.net[/url] is easier than anything found
on the programming language perl? Explain.

> See also database language on the slightly confusing [url]www.mysql.com[/url].

How is the web-site [url]www.mysql.com[/url] confusing? Explain. And what has that
got to do with Perl?

> PHP database query looks like this:
>
> $myquery = "SELECT table.field FROM table WHERE table.field = '$variable'";
> $result = mysql_db_query($db, $myquery, $connection) or die ("myquery failed.");
> $arr = array();
> $x = 0;
> while(list($a) = mysql_fetch_array($result))
> {
> $arr[$x] = $a;
> $x++;
> }

This code isn't safe, but that's not PHP's fault. What happens if
$variable is messed with?

Similary job is done with only one line using Perl's DBI module, and this
code is even secure compared to the PHP code above:

my $arr = $dbh->selectcol_arrayref('SELECT field FROM table WHERE field = ?',
undef, $variable);

> Variables are GETed or POSTed automatically with the form on submit.

That has nothing to do with the programming language on the server side,
actually, but is a part of the HTTP implementation.

> You can use regex's also.

So can Perl, right?

> While this is off-topic re Perl, [...]

It really is!


--
Tore Aursand <tore@aursand.no>

[John Dillon]

Original question was:

>I´m new with perl. I need to write a program that reads data out of a form
>sent via internet and is able to interpret the data.
>I have written the form in html.

It's partly bcs it's written in English. I know that sounds like Visual
Basic. But the queryist is a beginner.

The alternative programming language uses a config setting to deal with
apostrophe's in form input and a function to escape them. But that's a
detail....

> Yeah right have yiu even used param in CGI.

No. That's partly the point. I wouldn't even know where to find it. But
it sounded like he needed some help on the general sort of thing that goes
on in reading data out of a HTML form etc. Since he couldn't even write a
good subject line, it's unlikely he could write his question correctly
either.

As further posts have explained, a comparison between the two languages does
throw up important points, which wouldn't be there if we're all pressurised
to not mention the other language.



*******************************************[url]http://www.cantor.com[/url]
CONFIDENTIAL: This e-mail, including its contents and attachments, if any, are confidential. If you are not the named recipient please notify the sender and immediately delete it. You may not disseminate, distribute, or forward this e-mail message or disclose its contents to anybody else. Copyright and any other intellectual property rights in its contents are the sole property of Cantor Fitzgerald.
E-mail transmission cannot be guaranteed to be secure or error-free. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.
Although we routinely screen for viruses, addressees should check thise-mail and any attachments for viruses. We make no representation or warranty as to the absence of viruses in this e-mail or any attachments. Please note that to ensure regulatory compliance and for the protection of our customers and business, we may monitor and read e-mails sent to and from our server(s).

For further important information, please read the Important Legal Information and Legal Statement at [url]http://www.cantor.com/legal_information.html[/url]

[Dan Muey]

> Original question was:

>

> >I´m new with perl. I need to write a program that reads data

> out of a

> >form sent via internet and is able to interpret the data. I have
> >written the form in html.

>
> It's partly bcs it's written in English. I know that sounds
> like Visual Basic. But the queryist is a beginner.
>
> The alternative programming language uses a config setting to
> deal with apostrophe's in form input and a function to escape
> them. But that's a detail....
>

> > Yeah right have yiu even used param in CGI.

>
> No. That's partly the point. I wouldn't even know where to

I told him how to use it,

use CGI qw(param);
print "Hello ".param('name');

> find it. But it sounded like he needed some help on the
> general sort of thing that goes on in reading data out of a
> HTML form etc. Since he couldn't even write a good subject
> line, it's unlikely he could write his question correctly either.
>
> As further posts have explained, a comparison between the two
> languages does throw up important points, which wouldn't be
> there if we're all pressurised to not mention the other language.

No pressure, mentioning it isn't so bad, what gets my panties in a bunch is the "How do you
do this with Perl" and the "You use PHP and while we're at it here's why it is
so great" response. I just want Perl to be discussed on a Perl list instead of PHP. I'd
expect the same if I was on a PHP list asking how to do such and such with PHP.


I don't subscribe to any PHP lists however because it sucks, much like Micorsoft.
That's only my opinion of course so it doesn't mean much. It goes to my same
argument I posted a few weeks ago:

PHP developers use html and css to make nice *looking* things. Then people see
that nice looking stuff and assume PHP is awesome because it looks so great,
while the looks have nothgin to do with PHP but with html and css.

PHP is a pain to administer on a server, if anyone is recommending alternat
elanguages I'd say give moto a try.

[url]http://projectmoto.org/[/url]

It's a pretty new, developing language but it has it's up sides like PHP but without the
PHP bloat ego crap.

Ok I swear I'm done ranting, no more posts I swear!! :)

[John Dillon]

Yea, well it's really HTML that's the problem. The question was whether
perl was appropriate, not how to do it in perl. But, usefully, if there is
anything in the perl documentation that is quite as easy and
cross-referenced as the search box on [url]www.php.net[/url] then I would like to find
it.


*******************************************[url]http://www.cantor.com[/url]
CONFIDENTIAL: This e-mail, including its contents and attachments, if any, are confidential. If you are not the named recipient please notify the sender and immediately delete it. You may not disseminate, distribute, or forward this e-mail message or disclose its contents to anybody else. Copyright and any other intellectual property rights in its contents are the sole property of Cantor Fitzgerald.
E-mail transmission cannot be guaranteed to be secure or error-free. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.
Although we routinely screen for viruses, addressees should check thise-mail and any attachments for viruses. We make no representation or warranty as to the absence of viruses in this e-mail or any attachments. Please note that to ensure regulatory compliance and for the protection of our customers and business, we may monitor and read e-mails sent to and from our server(s).

For further important information, please read the Important Legal Information and Legal Statement at [url]http://www.cantor.com/legal_information.html[/url]

[Dan Muey]

> Yea, well it's really HTML that's the problem. The question

> was whether perl was appropriate, not how to do it in perl.

It was both. He asked if there were any scripts or modules
or something like that that can help him process his html
form input.
Yes it's appropriate,
yes it does it,
yes there are many thigns to process html,xml, sql, tcp,
sockets, email, ftp, images, gui apps, etc etc.

I'm sure he wasn't after a simple yes or no. That would be a most
unhelpful answer.

> But, usefully, if there is anything in the perl documentation
> that is quite as easy and cross-referenced as the search box
> on [url]www.php.net[/url] then I would like to find it.

perldoc

Could you turn off this confidential notice when posting?
It's anoying and useless.

Ok, I've spent to much on this lame post, I'm really done now, no matter
if John still feels compelled to get the last word in or not.

> *******************************************[url]http://www.cantor.com[/url]
> CONFIDENTIAL: This e-mail, including its contents and
> attachments, if any, are confidential. If you are not the
> named recipient please notify the sender and immediately
> delete it. You may not disseminate, distribute, or forward
> this e-mail message or disclose its contents to anybody else.

Then why are you posting it to a list that will "disseminate,
distribute, and forward this e-mail message and disclose its
contents to anybody" that has internet access?

See pointless and annoying :)

> Copyright and any other intellectual property rights in its
> contents are the sole property of Cantor Fitzgerald.
> E-mail transmission cannot be guaranteed to be secure or
> error-free. The sender therefore does not accept liability
> for any errors or omissions in the contents of this message
> which arise as a result of e-mail transmission. If
> verification is required please request a hard-copy version.
> Although we routinely screen for viruses, addressees
> should check this e-mail and any attachments for viruses. We
> make no representation or warranty as to the absence of
> viruses in this e-mail or any attachments. Please note that
> to ensure regulatory compliance and for the protection of our
> customers and business, we may monitor and read e-mails sent
> to and from our server(s).
>
> For further important information, please read the Important
> Legal Information and Legal Statement at
> [url]http://www.cantor.com/legal_information.html[/url]