Perl DBD

MiniMe · Post by **MiniMe** » Mon Dec 03, 2001 4:40 pm

In vortex when an update is done to a column the new value is assigned to the variable name of column in the same call to sql. Is it possible to do this in the perl dbd as well or do I have to select out the value.

I have a sql call where I dont know what the final value of the column will be when its done. It looks like this:

update ordernum set order = order + 1

I vortex $order would be the new value.

Can this be done in perl too.

Post by **John** » Mon Dec 03, 2001 5:22 pm

I don't believe that can be done according to the DBI specs, as the execute() call is supposed to return the number of affected rows, rather than allowing you to fetch the results as you can in Vortex. The same is true of most of the other standard APIs and database connectivity tools. It might make sense to add that as a flag that can be set for a future release.