Re^6: update db problem

Unfortunatelly, there is no way I can use DBI. Not my choice...

The following didn't help either... :(

$cmd = $connString."update [dbname].[record] set record = 7;commit\nGO
+\nquit\n";
[download]

Comment on Re^6: update db problem Download Code

Replies are listed 'Best First'.
Re^7: update db problem by kennethk (Abbot) on Jun 14, 2010 at 21:15 UTC
Though I don't know exact why you can't use DBI, a read through Yes, even you can use CPAN might be useful for you. You say you can accomplish your goal on the command line, but not with Perl. Perl is literally passing the string you are storing in `$cmd` to the OS. It should not be possible for that same exact string to fail in the Perl context and succeed on the command line (assuming you are performing the actions with the same environmental variables). What is the result when you modify your code to literally print the content of `$cmd` to STDOUT and then type that same code yourself?	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^7: update db problem
by kennethk (Abbot) on Jun 14, 2010 at 21:15 UTC

Yes, even you can use CPAN

You say you can accomplish your goal on the command line, but not with Perl. Perl is literally passing the string you are storing in $cmd to the OS. It should not be possible for that same exact string to fail in the Perl context and succeed on the command line (assuming you are performing the actions with the same environmental variables). What is the result when you modify your code to literally print the content of $cmd to STDOUT and then type that same code yourself?

[reply]
[d/l]
[select]