errr...tables in the HTML-sense. i really gotta express myself better. i'll try it in staccato-style:
i use perl to generate html-pages. these contain tables that are the result of (more or less) complex sql-queries which use lots of placeholders (simplest example: the result of a search-form, where the user's query is, of course, bound to a placeholder). i $sth->execute() the $sth, and pass it to a generic printTable() sub, which does all the (rather advanced, if i may say so) html-formatting. i'd like these tables to generate and offer a "print this table!" link. thus, i have to pass the sql-query that actually generates this table to the script in charge of printing. this wouldn't be taht much of a problem if mysql would support $sth->{'ParamValues'} (which returns the values bound to placeholders). but dbd::mysql (to my knowledge) doesn't support this (yet?). thus, i fear i'm quite screwed (to put it lightly). thus i'm looking for a way to re-construct the SQL that an executed statement handle...well...executed.
geez. i really shouldn't have bought this weak coffee. :-) | [reply]
[d/l]
[select] |