Re^4: A Case with 5 Var's

in reply to Re^3: A Case with 5 Var's
in thread A Case with 5 Var's

It depends how your query is built. Hopefully each variable is responsible for just one section, then you just build the query up as you go.

 my $qry  = "";
 my $name = "Mueller";
 my $plz  = "55555";
 if ($name) { $qry .= "::5544$nameGDFT"; }
 if ($plz)  { $qry .= "xxxxx$plz::0:";}
 print $qry;
[download]

Since I have no idea what kind of query that is I had no idea what parts go where, but hopefully that gives you and idea how it can be done.

If your query is completly dependent on the elements available then you could combine your ifs together some for readability at least

 if    ($name && $vorname && $plz && $tel && tel49) { $qry = "whatever
+" }
 elsif ($name && $vorname && $plz && $tel)          { $qry = "whatever
+2" }
 elsif ($name && $vorname && $plz)                  { $qry = "whatever
+3" };
[download]

That is not the recommended solution, just one of the many ways to do it.

___________
Eric Hodges

Comment on Re^4: A Case with 5 Var's Select or Download Code

Replies are listed 'Best First'.
A reply falls below the community's threshold of quality. You may see it by logging in.

In Section Seekers of Perl Wisdom