sql server – Need help with JOIN I should be using as values are in columns are changing to find difference in tables

how can i compare text info using joins here as parentid & id of node will be the identifying factor for difference and also the text ?

columns are

RID  ConfigFileID  ID(xml child node)  ParentID(xml parent node)  Path  Text

My query showing wrong results . Ideally should show 2 rows for which text is missing or addition:

select * from XML_table a 
left join xml_table b
on a.id= b.id
where a.ConfigFileInfoID = 55187765 and b.ConfigFileInfoID = 55205283
    and a.id = b.id
    and a.text != b.text 
    and a.parentid ! = b.parentid
    and a.path ! = b.path

(data in xml table is just english text for which i need to find difference)

RID ConfigID ID parentId Path


Blockquote

RID ConfigID ID parentid Path Text

333570 55187765 36 28 configuration/system.web/customErrors NULL

347804 55205283 36 0 configuration/system.serviceModel NULL

My final query should display the difference this way ..the path is different and ID & parent ID should be different to identify that there is a difference. RID & Config ID will keep changing anyway .The path is almost the same but changes in the final file.the key is to know what changed in path and I need to find difference in text too( here null but sometimes there are different texts)

layout – Magento 1 – Split Configurable product options list into 2 columns

I have a Configurable product… I would like to split the Configurable Options into 2 columns (using existing responsive markup). To make things more complex, I would like to apply the layout update to only one particular Configurable product.

So far, I have been able to format the product page by…

Duplicating and renamed subtheme/template/catalog/product/view/options/wrapper.phtml to custom_wrapper.phtml

I then added below to Product > Design > Custom Layout Update in Magento Admin.

<reference name="product.info.options.wrapper">
  <action method="setTemplate">
    <template>catalog/product/view/options/custom_wrapper.phtml</template>
  </action>
</reference>

The desired result is working as I hoped… see https://www.smarthome.com.au/smarthome-installation.html

Now it gets tricky, I would like to list the first 6 options in column 1

Then the remaining options in column 2 – effectively splitting the Configurable Product Options into 2 sections. I also need to do this so that it only applies to this product page.

I am really hoping someone can kindly assist with this – or at least point me in the right direction – I have spent hours trying to figure this out!

Thanks in advance to anyone who is nice enough to lend their wisdom.

Shifting and adding the columns of two lists

Let’s say that I have this list

a={{-2, 1}, {-1, 2}, {0, 1}, {1, 0}, {2, 0}}

and I’d like to change the value of the elements in the column to obtain something like this

b={{-2, 0}, {-1, 0}, {0, 1}, {1, 2}, {2, 1}}

so, you can see that it’s like I’m shifting the values in the column two positions.

and then I’d like to sum the elements in the column to obtain

c={{-2, 1}, {-1, 2}, {0, 2}, {1, 2}, {2, 1}}

Creating downloadable link in 3rd column using the values of 2 columns in SharePoint online list

I am new to JSON. Here is what I am trying to do:
first column name -> firstname and
second column name -> lastname.
Then in third column I need this to display as a downloadable link -> Randomtext/firstname/lastname. For example https://www.sagar.sharepoint.com/firstname/lastname

I tried below code but doesn’t work:-
{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”,
“elmType”: “div”,
“txtContent”: “=[$firstname] + ‘ ‘ + [$lastname]”,
“attributes”: {
“target”: “_blank”,
“href”: “=’https://www.sagar.sharepoint.com/sites/file.txt’ = [$firstname] + ‘ ‘ + [$lastname]”
}
}

linear algebra – Orthonormal columns implies orthonormal columns

I find it non-intuitive if I impose that all of a square matrix’s columns are normalized and mutually orthogonal, then all its columns are also normalized and mutually orthogonal. Any intuitive explanation for this? Also if I relax the conditions to be only mutually orthogonal without being normalized, is this still true? And why so?

Reordering admin columns for CPT with custom taxonomy and an added custom field

This may be a repeat but it’s the combination of things I can’t find.

Custom post type is event.

I have added an admin column ‘Event Date’ generated by ACF and it appears at the right. Everything appears fine in this order; ‘Title’, ‘Venue’, ‘Date’ ‘Event Date’

I’d like to reorder it. So far so good, this code does that.

But the custom taxonomy ‘venue’ which has the slug venue does not reappear (it appears but is not populated). How do I find out what the custom taxonomy is called for the purposes of the admin columns?

function reorder_event_columns( $columns ) {

$columns = array(
    'cb' => $columns('cb'),
    'title' => __( 'Title' ),  // Post Title
    'venue' => __( 'Venue'), // not populated!
    'event_date' => __( 'Start Date'), // Appears fine
    'date' => __('Date'), // Published Date
);

  return $columns;
}

add_filter( 'manage_event_posts_columns', 'reorder_event_columns' );

jQuery DataTables move columns – Stack Overflow

I try to use colReorder.move() from jQuery DataTables plug-in. I use constructor for configure links for this plug-in (i only add ColReorder extension) and use CDN links in my asp net core 3 project.

@section Scripts {
    <script>
    $(document).ready(function () {
        var table = $('#parcel').DataTable({
            language: {
                url: "//cdn.datatables.net/plug-ins/1.10.21/i18n/Russian.json"
            },
            colReorder: true
        });
        table.colReorder.move(1, 2);
    });
    </script>
}

And I have this error

jquery.min.js:2 Uncaught TypeError: Cannot read property 's' of undefined
    at _Api.<anonymous> (datatables.js:16874)
    at Object.move (datatables.js:7216)
    at HTMLDocument.<anonymous> (Parcels:1076)
    at l (jquery.min.js:2)
    at c (jquery.min.js:2)

Does using multiple columns in partitioning Spark DataFrame makes read slower?

I wonder if I use multiple columns while writing a Spark DataFrame in spark makes future read slower?
I know partitioning with critical columns on which I would filter in future will improve the performance while reading data, I don’t know if I use many columns in partitionBy does this reduce the performance or still, I could benefit from the higher performance?

(ordersDF
  .write
  .format("parquet")
  .mode("overwrite")
  .partitionBy("CustomerId", "OrderDate") # <----------- add many columns
  .save("/storage/Orders_parquet"))

innodb – Row size restrictions in MySQL with TEXT and BLOB columns

There is a known limitation in MySQL for the line size of 65,535 bytes.
As you go through the documents,

I found that

BLOB and TEXT columns only contribute 9 to 12 bytes to the row
Size limit because their content is stored separately from the rest
the series.

I looked through the MySQL documentation, but couldn't understand when a TEXT column would add 9 bytes and when 12 bytes would add. Can someone explain how to interpret the statement?