I hope $id is the Perl variable that contains the actual field name and not
the field name.
Have the script dump the table name and SQL to a separate file and try to
execute it from SQL*Plus after you have logged in in the same account as the
webserver runs in.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
----- Original Message -----
From: "Marius Keraitis" <[EMAIL PROTECTED]>
To: "DBI Perl" <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 00:57
Subject: problem with geting data from db
> I have problem when i trying to select data from table, which name i keep
in
> variable.
> How could i do (this statement don't work: select * from $table_name)
> $table_name i get from other .pl file in which table name i set with input
form:
> <td><input type="submit" name="$id" value="Parodyti" </td>
>
> in second file i do this: $table_name=param("$id");
