Your skill will accomplish what the force of many cannot |
|
PerlMonks |
How can I retrieve a mysql text blob in Catalyst?by miguelele (Beadle) |
on Oct 26, 2011 at 18:29 UTC ( [id://933965]=perlquestion: print w/replies, xml ) | Need Help?? |
miguelele has asked for the wisdom of the Perl Monks concerning the following question: Hi, I have one XML list stored as a Blob in MySql and I need to retrieve it as the original text. My actual DBI Model/Schema gets all text columns fine, but not the blob. Maybe I can add some native mysql commands to the query to do the conversion, but I do not know where in the model o result set I can do such thing. In case you wonder why I have this situation: my first real Catalyst project is porting a working Flex site. Not too complicated. But in Flex I access database through a simple custom .php interface, and I get the Blob column as text without any special treatment. I can't change the blob to text because customers are using it. Maybe in a second version. Regards from the apprentice village, dear monks</>
Back to
Seekers of Perl Wisdom
|
|