-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> $result = $dbh->prepare ( "SELECT neues_suchprofil ( $cookieValue::numeric,
> '$suchprofil_name::text' ) " ) or die "Vorbereitung nicht durchfuehrbar!\n";
You are mixing up your syntaxes: double-colons in Perl are not the same as
double
colons in Postgres. Perl is treating $cookieValue::numeric as the variable
"numeric" in the package "cookieValue". What you need to do is either:
SELECT neues_suchprofil ( ${cookieValue}::numeric
or use placeholders:
SELECT neues_suchprofil ( ?::numeric
You might also want to make a single variable to pass to prepare, as it can
help in debugging:
my $COM = "SELECT neues_suchprofil ( $cookieValue::numeric,
'$suchprofil_name::text' )";
$result = $dbh->prepare ($COM)
or die "Vorbereitung nicht durchfuehrbar! ($COM)\n";
Not only does it make the code easier to read, but your error message would have
shown you that those variables were not getting set as you thought they were.
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200602220909
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iD8DBQFD/HFEvJuQZxSWSsgRAkG7AKDoqzOxjg6OSpcDp/x9DYUwMVCNMgCfRwsD
flkczHWCUXi5If3sWW8Ee3I=
=LIPT
-----END PGP SIGNATURE-----
