Can I integrate an exiting blog platform into my website

I had asked this question on Software Recommendation but did not get any answer.

I am working on an e-commerce website, which is developed in ASP.NET MVC… I want to build a blog for the website and add some content to the blog to improve website’s ranking in the Search result.

I want my blog to be reached using: my-site.com/blog

Is it possible to integrate an existing blog platform such as Medium or Blogger into my website?

Exporting Stock Financial Data into Excel

I would like to pull 3 attributes (Open, Close, Volume) for a variety of stock symbols. I would like to pull the stock data within a specific range and export it to an excel spreadsheet. I would also like to append the next stock ticker and its attributes to the bottom of the former.

So far I have the following code:

filename = "Data.xls"; data = FinancialData[    "GE", {"Open", "Close"}, {{2000, 1, 1}, {2021, 1, 1}}]; V = data // Normal; Export[filename, V]; 

Several problems are easy to see: Data for Open and Close are saving in separate tabs (I do not know why), adding additional ticker symbols forces all ticker data for a symbol into the same row in the same tab (again I do not know why), I am getting a string e.g.

Quantity[50.29999923706055, "USDollars"]

when all I want is the numerical piece. Finally, I am not getting the headers for each attribute as I am looking for.

I would really appreciate some assistance here. I have looked at other solutions as Creating a Stock Dataset but it doesn’t quite give me what I am looking for and my attempts to change it to meet my needs have failed.

Is a target pushed into a wall by a spell effect subject to collision damage?

Some spells can push the target X feet away (like thunderwave, which pushes 10 feet away on a failed save). I was wondering what happens if the target, while being pushed, encounters a wall or other rigid object. Does it take (bludgeoning) damage? To me it seems logical that it would: it is like falling, sudden force applied to a creature due to encountering resistance from an object.

I couldn’t find any rules about this in the Player’s Handbook nor online.

Download multiple images into a folder from listview

I am displaying multiple images in listview from database and is working fine, the problem am having is when ever I wan’t to download multiple selected images into any folder on my desktop computer, only one image is downloaded not multiple selected images : check my codes Code for retrieving rom database:::

listView1.View = View.LargeIcon;         listView1.LargeImageList = largeImage;         {             connect.Open();             SqlCommand cmd = new SqlCommand("SELECT name,data FROM gallery", connect);             SqlDataReader reader = cmd.ExecuteReader();                 listView1.Items.Clear();                 largeImage.Images.Clear();                  while (reader.Read())                 {                     if (!reader.IsDBNull(1))                     {                         Bitmap bm = BytesToImage((byte[])reader.GetValue(1));                         float source_aspect = bm.Width / (float)bm.Height;                       AddImageToImageList(largeImage, bm, reader[0].ToString(), largeImage.ImageSize.Width, largeImage.ImageSize.Height);                 }                    listView1.AddRow(reader[0].ToString(), reader[0].ToString());                 }             connect.Close();         } 

Code for downloading (My Problem)

    FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog(); if (folderBrowserDialog.ShowDialog() == DialogResult.OK) {   if (listView1.Items.Count > 0) {     listView1.FocusedItem = listView1.Items[0];     listView1.Items[0].Selected = true;     listView1.Select();     SqlCommand cmd = new SqlCommand("SELECT Name,Data FROM ", connect);     cmd.CommandType = CommandType.Text;     connect.Open();     SqlDataReader sdr = cmd.ExecuteReader();     if (sdr.Read()) {       byte[] bytes = (byte[]) sdr["Data"];       string fileName = sdr["Name"].ToString();       string path = Path.Combine(folderBrowserDialog.SelectedPath, fileName);       File.WriteAllBytes(path, bytes);     }     connect.Close();   } } 

what i have tried

if (sdr.HasRows) { while (sdr.Read()) {   byte[] bytes = (byte[]) sdr["Data"];   string fileName = sdr["Name"].ToString();   string path = Path.Combine(folderBrowserDialog.SelectedPath, fileName);   File.WriteAllBytes(path, bytes); } }  for (int I=0; I<listView1.Items.Count; I++)   {     listView1.FocusedItem = listView1.Items[I];     listView1.Items[I].Selected = true;   } 

D&D 3.5e: How exactly do you calculate changing a Line into a Cone?

Exactly as the title is asking. But to be more specific, I am asking for the purposes of the Shape Breath Metabreath feat. As the feat says:

If you have a line-shaped breath weapon, you can opt to shape it into a cone. Likewise, if you have a cone-shaped breath weapon, you can shape it into a line. When you use this feat, add +1 to the number of rounds you must wait before using your breath weapon again.

Comparing this to the breath weapon of a Dragonborn of Bahamut, which is a Line with a range of 5ft per hit die, how would you calculate converting the breath weapon into a cone? Would a 6th-level Dragonborn of Bahamut breath out a 30ft cone? Or would the length of the cone be reduced?

put the result of a query into a variable and WITH statement

I need to put the result of a query into a variable.

Just a query, works as successful

DECLARE @count INT = (  SELECT count (*) FROM [AdventureWorks].[Person].[Address]     );  select @count; 

But if I need to use the WITH statement in a query, then I get a syntax error

DECLARE @count INT = (    WITH person_address (id)    as (     SELECT AddressID     FROM [AdventureWorks].[Person].[Address]    )    SELECT count (*)    FROM person_address     );  select @count; 

Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword ‘WITH’.

Msg 319, Level 15, State 1, Line 2 Incorrect syntax near the keyword ‘with’. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

Msg 102, Level 15, State 1, Line 9 Incorrect syntax near ‘)’.

How do I put the query value into a variable if the WITH clause is used in the SQL statement?

Can an artificer/wizard make a homonculus heart into a spell-storing item?

The Homonculus Servant infusion requires a specific component:

Item: A gem or crystal worth at least 100 gp

Later, it goes on to say

The item you infuse serves as the creature’s heart, around which the creature’s body instantly forms.

Okay, while gemstones are assumed to be just valuables, what is a crystal? The PHB lists the following forms for an arcane focus:

Arcane Focus: Crystal, Orb, Rod, Staff, Wand

Admittedly, the crystal has a listed cost of 10gp, but it’s reasonable a fancier one could be made to fulfill the requirement.

Moving on, the Artificer’s Spell-Storing Item feature lists as its possible targets

one simple or martial weapon or one item that you can use as a spellcasting focus,

An artificer must use a tool they are proficient with or an item they have infused as a spellcasting focus – this means that a finished homonculus can be turned into a spell-storing item, but it’s rather unclear if it can then touch itself to cast the spells stored within itself.

… but, if you pick up one level of wizard (or the magic initiate: wizard feat, perhaps? Actually, no, that deserves a question of its own), you can use the crystal as a spellcasting focus, since the feature does not specify it must be an artificer focus.

Thus the plan. At the end of a long rest, touch your expensive crystal focus, imbue it with your desired spell, then infuse the focus to be the heart of your homonculus, which it is rather difficult to argue isn’t touching its own heart at all times, letting it cast the spells within the item even by the strictest of RAW readings.

Is there a reason this wouldn’t work?