shoppergroups

[guardiano78]

hi,
I'm analyzing the table {prefix}_virtuemart_shoppergroups and I would read what is written in the "price_display."
I would also read and write.
I dont't know how BLOB field work's.

Can anyone help me?
Thank you.

[slammy]

Hi guardiano78,
as far as I know BLOB´s are binary-file-data saved in a db instead as a file on a directory-path. What do u want to do?
regards jens

[guardiano78]

I'm trying to create php scripts through an external xml file to import and export data from the database. I noticed that "price_display" is the only field in the database to be "blob". Unfortunately I have no idea how it handles.
Maybe it could be useful to find queries that deal to do insert and update shopper group, but I do not find.

[Milbo]

Make your live easier and learn how to use the VM API. http://dev.virtuemart.net/projects/virtuemart/wiki/Developing_a_module_or_plugin_for_VirtueMart_2

[guardiano78]

Thank you Milbo,
but to achieve my goal I have to work outside the joomla.
I need only to know how to read e write "price_display" (blob) in _virtuemart_shoppergroups

[GJC Web Design]

Still think you should look into building a vm custom plugin - you are then "inside" VM and can use all the Joomla & VM classes

[slammy]

take a look here:

http://dev.mysql.com/doc/refman/5.0/en/blob.html
http://dev.mysql.com/doc/connector-net/en/connector-net-programming-blob-writing.html ( VB-Example with MySQL and C# )
http://www.mysqltutorial.org/php-mysql-blob/
http://php.net/manual/en/function.fbsql-read-blob.php