thanks to everyone for the suggestions
On 11/1/06, Mumia W. <[EMAIL PROTECTED]> wrote:
On 11/01/2006 01:44 PM, jm wrote: > On 11/1/06, John W. Krahn <[EMAIL PROTECTED]> wrote: > >> >> Use a hash: >> >> my %oob = ( >> state => 'IL', >> lata => 732, >> name => 'SomeName', >> ); >> >> If you don't think that you need a hash then be aware that what you >> are trying >> to do is actually using a hash anyways (the %main:: hash.) >> >> >> >> John >> -- >> Perl isn't a toolbox, but a small machine shop where you can >> special-order >> certain sorts of tools at low cost and in short order. -- Larry >> Wall >> >> -- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> <http://learn.perl.org/> <http://learn.perl.org/first-response> >> >> >> > > thanks to all for the replies. i think i was probably too concise in > my explanation; i'll try to elaborate without going overboard... > > the current code goes like this: > > &build_oracle_args_ne(FIELD => "ooba_element_host_name", VARIABLE => > $ne_ooba_element_host_name); > # and several other similar lines of code > > sub build_oracle_args_ne > { > my %options = @_; > # $options{FIELD} comma-separated list of fields to build > into oracle argument > # $options{DB_ARGS} string of Oracle field comparisons to be > dynamically constructed > # $options{VARIABLE} variable to compare to ORACLE field > > # $oracle_args_oob defined elsewhere in program as a "global" > variable > $oracle_args_ne .= ($oracle_args_ne =~ /where/ ? " and " : "where ") > . "upper($options{FIELD}) like '%" . uc($options{VARIABLE}) . "%'" if > $options{VARIABLE} ne ""; > } # end of sub build_oracle_args_ne > > ##################### > the purpose is to dynamically create a list of fields and values (from > a web interface) to compare in an oracle database (it has to be > dynamic due to the need to search any field, as well as the fact that > the person creating the database built 3 tables which store the same > data but with slightly different field structures/sequences - > different problem, just some background). the result would be > something like > > "... where upper(state) like '%IL%' and upper(lata) like '%732%' ..." > > for however many fields had been populated in the form. in the > updated routine, i wanted to pass only the oracle fieldname and create > the variable that held the desired data to build the sql query, not > pass the variable as a second argument, either as a hash or another > scalar. > > i'll look at hashes but i don't think that's the best solution for > this. if someone could, just for arguments sake, tell me how to do > this the "wrong" way, i'd really appreciate it, just for knowing > another alternative, whether i actually do that or not. > > thanks again. > > joe > > Make sure the perl documentation and its utitilty, perldoc, are installed on your system and, at a command prompt, type these: perldoc -q "variable as" perldoc perl -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
-- since this is a gmail account, please verify the mailing list is included in the reply to addresses -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
