Ticket #154 (closed enhancement: fixed)

Opened 1 year ago

Last modified 1 year ago

Suggestion to add attribute to PDOSQLExecTask for fetch_style

Reported by: albertlash Assigned to: hans
Priority: trivial Milestone: 2.3.0
Component: phing-tasks-ext Version: 2.3.0RC1
Keywords: Cc:

Description

The default fetch mode for PDO is FETCH_BOTH, which results in two columns of the same data: the associated column (with the field name) and the numeric column position. See:

http://www.php.net/manual/en/function.PDOStatement-fetch.php

Would be nice to have the ability to select this from the build file.

Attachments

Change History

09/24/07 02:30:27 changed by albertlash

Also, it would be great to be able to output the result set into XML, rather than CSV.

10/17/07 01:56:05 changed by hans

Hey, Albert, have you modified your PDOSQLExecTask to support SELECT statements? It looks like that is currently disabled in the version I'm looking at .... It also looks like I couldn't figure out a good solution for handling SELECT statements. It seems the more typical usage would also be for updates ...

10/17/07 05:35:01 changed by albertlash

Yes, I have, see #153 for how that's done.

10/17/07 12:51:53 changed by hans

  • status changed from new to assigned.

Oh, right :) -- Sorry, I guess I'm doing things out of order.

10/18/07 15:49:12 changed by albertlash

No problem, my reports were very disorganized. In the future I'll be more specific - I'm planning extensive use of the pdo / sqlite functionality.

10/20/07 22:30:50 changed by hans

  • status changed from assigned to closed.
  • resolution set to fixed.
  • milestone set to 2.3.0.

This should be implemented now in changeset:256


Add/Change #154 (Suggestion to add attribute to PDOSQLExecTask for fetch_style)




Action