Once, I was having some issues with Struts: Radio Button : Form Bean:JSP. The following information helped me. You usually specify the name of the form/form-bean when you declare a form bean in your struts-config.xml file like: You can use a variable to point to this form using: extract specific properties: print them: From: http://sitestree.com/?p=4842 …
Category: Root
Aug 06
Magento2: update product attributes using sql
cat update_product_attributes_using_sql.sql update catalog_product_entity_int — select * from catalog_product_entity_int set catalog_product_entity_int.value = 1 where (catalog_product_entity_int.attribute_id = 97) and catalog_product_entity_int.entity_id = ( select entity_id from ( SELECT product.entity_id as entity_id FROM bitnami_magento.catalog_product_entity product inner join catalog_product_entity_decimal price on price.entity_id = product.entity_id and (price.attribute_id in (78)) inner join catalog_product_entity_int status_t on (status_t.entity_id = product.entity_id) and (status_t.attribute_id=97) where …
Aug 06
Magento 2: Clear Images in database
truncate table bitnami_magento.catalog_product_entity_gallery; truncate table bitnami_magento.catalog_product_entity_media_gallery_value; truncate table bitnami_magento.catalog_product_entity_media_gallery_value_to_entity; truncate table bitnami_magento.catalog_product_entity_media_gallery_value_video; no warranty given as is
Aug 06
Magento 2: Update data for a custom product attribute
use bitnami_magento; SELECT * FROM bitnami_magento.catalog_product_entity_varcharwhere ( attribute_id = 73 ) — and (value = ”)limit 10 replace into bitnami_magento.catalog_product_entity_varchar (attribute_id, store_id, entity_id, value )SELECT 181, 0, product.entity_id, left(concat(“https://www.amazon.com/s?k=”, product.value),255)FROM bitnami_magento.catalog_product_entity_varchar productinner join catalog_product_entity_int status_t on ( status_t.entity_id = product.entity_id ) and ( status_t.attribute_id = 97 and status_t.value = 1 )where (product.attribute_id=73) — and (value …
Aug 06
Magento 2: Misc. Image related SQLs
select * from bitnami_magento.catalog_product_entity_media_gallery_value_to_entity where value_id in (232574, 242521) — 232574, 242521 select * from bitnami_magento.catalog_product_entity_media_gallery_value_to_entity where value_id in (232574, 242521) — where value like ‘%ud6vtf2a_5ezdxueqvnr%’ –select * from bitnami_magento.catalog_product_entity_media_gallery_value_to_entity select * from bitnami_magento.catalog_product_entity_media_gallery — where value_id in (237733, 237734) where value like ‘%ud6vtf2a_5ezdxueqvnr%’ update bitnami_magento.catalog_product_entity_media_gallery set value = ‘/u/d/ud6vtf2a_5ezdxueqvnr1dyny_1.jpeg’ where value = ‘/u/d/ud6vtf2a_5ezdxueqvnr1dyny.jpeg’ and …
Aug 06
Magento 2: Deactivate Products without images
update catalog_product_entity_int — select * from catalog_product_entity_int set catalog_product_entity_int.value = 2 where (catalog_product_entity_int.attribute_id = 97) and catalog_product_entity_int.entity_id in ( select entity_id from ( Select distinct(product.entity_id) FROM bitnami_magento.catalog_product_entity product left join catalog_product_entity_media_gallery_value_to_entity valentity on valentity.entity_id = product.entity_id left join catalog_product_entity_media_gallery image on image.value_id = valentity.value_id and (image.attribute_id in (90)) inner join catalog_product_entity_int status_t on (status_t.entity_id = …
Aug 04
Traffic Crashes Are Getting Worse. Car Ads Are Part Of the Problem.
More on CityLab: The Plexes of Montreal Make Room for Change With their distinctive details and treacherous outdoor staircases, these two- or three-floor apartment buildings dominate the city’s multi-family rental housing market. Traffic Crashes Are Getting Worse. Car Ads Are Part Of the Problem. What if car companies were banned from boasting their trucks can …
Aug 03
Some Educational Android Apps on Software/Web Development #Android Development and Programming #Android Development and Programming #Our Android Apps
Some are in Bengali Project Management https://play.google.com/store/apps/details?id=com.sitestree.pmp On CSS https://play.google.com/store/apps/details?id=com.sitestree.css On JavaScript https://play.google.com/store/apps/details?id=com.sitestree.javascript On PHP https://play.google.com/store/apps/details?id=com.sitestree.php On SEO course https://play.google.com/store/apps/details?id=com.sitestree.seo SQL Course https://play.google.com/store/apps/details?id=com.sitestree.sql Oral Communications https://play.google.com/store/apps/details?id=com.justetc.oral_communications.workplace AngularJS https://play.google.com/store/apps/details?id=com.salearningschool.bangla.angularjs1 HTML https://play.google.com/store/apps/details?id=com.salearningschool.bangla.html From: http://sitestree.com/?p=11803 Categories:Android Development and Programming, Android Development and Programming, Our Android AppsTags: Post …
Jul 30
Coding Projects in Scratch
Theme: Science There are a lot of projects for games, simulations, and art. I will share 1 example: Sarah does this: when go clicked…go to front layer. Forever: go to x: 0 y: 0. Sarah’s home should do this: When go clicked…set size to 50%. You need to add this to Sarah: If touching home then …
Jul 30
Art with Your Hands and Feet
Theme: Preforming arts There were a lot of art to do but here is one example: Skipping penguins Make a pair of black footprints. Let it dry. Make the tummy for both penguins. Add the eyes and beak. Make two triangles (one for each penguin) Make the triangles top attached. I like this book because …
