Miquel Coll's questions

I have a md-datepickerdefined with Angular 1.X:

<md-datepicker ng-model="query.filter.mindate"></md-datepicker>

How can I define the date format of this component?

I have already read some answers about it (like this one ) where they propose to use the mdDateLocaleProvider.formatDatey parseDateand it doesn't work for me.

I have also tried to put it like this:

<md-datepicker ng-model="query.filter.mindate">{{date : 'D/M/YYYY'}}</md-datepicker>

And this:

<md-datepicker ng-model="query.filter.mindate">{{myFecha date : 'D/M/YYYY'}}</md-datepicker>

But this doesn't work either, validation occurs as expected M/D/YYYYand I don't see how to modify it.

Is there a way to put some tag in the same HTML so that it does the validation with the format that you want?

I have the following code in Angular 1.X:

 <md-input-container style="margin:0; overflow-y: hidden !important;">
        <label>STATUS</label>
        <md-select style="overflow-y: hidden !important;" ng-model="query.filter.status">
        <md-option ng-repeat="status in statuses" ng-value="
{{status.key}}"><span>{{status.val}}</span></md-option>
        </md-select>
    </md-input-container>

Currently when the element is selected a scrolling list of 7 elements is opened. I have already tried putting max-widthhigh and overflow-y: hidden;everywhere and there is no way.

I haven't found anything in the documentation to disable scrolling.

Does anyone know what I'm missing?

I am working with a project where multiple calls are made to a WCF that is configured like this:

<system.serviceModel>
    <bindings>
      <basicHttpBinding>
        <binding name="BasicHttpBinding_IWCF" />
      </basicHttpBinding>
      <wsHttpBinding>
        <binding name="BasicHttpBinding_IWCF" closeTimeout="00:10:00"
          openTimeout="00:10:00" receiveTimeout="00:10:00" sendTimeout="00:10:00"
          bypassProxyOnLocal="false" transactionFlow="false" hostNameComparisonMode="StrongWildcard"
          maxBufferPoolSize="2147483647" maxReceivedMessageSize="2147483647"
          messageEncoding="Text" textEncoding="utf-8" useDefaultWebProxy="true"
          allowCookies="false">
          <readerQuotas maxDepth="2147483647" maxStringContentLength="2147483647"
            maxArrayLength="2147483647" maxBytesPerRead="2147483647" maxNameTableCharCount="2147483647" />
          <reliableSession ordered="true" inactivityTimeout="00:10:00"
            enabled="false" />
          <security mode="None">
            <transport clientCredentialType="Windows" proxyCredentialType="None"
              realm="" />
            <message clientCredentialType="Windows" negotiateServiceCredential="true"
              establishSecurityContext="true" />
          </security>
        </binding>
      </wsHttpBinding>
    </bindings>
    <client>
      <endpoint address="URLWCF"
        binding="basicHttpBinding" bindingConfiguration="BasicHttpBinding_IWCF"
        contract="WCF.IWCF" name="BasicHttpBinding_IWCF" />
    </client>
    <behaviors>
        ---------
    </behaviors>
</system.serviceModel>

But when making some calls I get this error:

The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.

The funny thing is that I already have the defined MaxReceivedMessageSizein the configuration that I have shared with the value:

maxReceivedMessageSize="2147483647"

What am I missing?

From the original SO question How to redirect to another page in jQuery?

How can I redirect from one page to another using jquery ?

Given the query:

SELECT MAX(fecha), estado
FROM tabla
GROUP BY estado

I get the maximum date of the table for each state.

My question is: Can I get the columns that are not in the Group By without doing aggregations? namely:

SELECT MAX(fecha), estado, id
FROM tabla
GROUP BY estado

Where I would like the id to be the concrete id of the row being selected with MAX(fecha).

If the table tablacontains:

id - date - status

1 - 03/11/1991 - Open

2 - 03/11/1992 - Open

3 - 03/11/1993 - Open

4 - 03/11/1992 - Closed

5 - 03/11/1991 - Closed

If you applied the first query you would get:

03/11/1993, Open

03/11/1992, Closed

And I would like to get:

03/11/1993, Open, 3

03/11/1992, Closed, 4

I understand that there is an extra problem in the event that more than 1 row has the same date and status, which would cause the id to be random but any would do. That is, if the table contains:

id - date - status

1 - 03/11/1991 - Open

2 - 03/11/1992 - Open

3 - 03/11/1993 - Open

4 - 03/11/1992 - Closed

5 - 03/11/1991 - Closed

6 - 03/11/1992 - Closed

The result is very useful for me:

03/11/1993, Open, 3

03/11/1992, Closed, 4

Like this:

03/11/1993, Open, 3

03/11/1992, Closed, 6

But if there's a better way to work with it I'd like to learn it.

I'll start with the error:

Retrieving the COM class factory for component with CLSID {1CF0DE77-8CAE-11D1-82A2-0060083F9B01} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)).

Sometimes (not always), when I am executing a function that is defined by a COMI get that error and there is no way to solve it.

I have already applied the "rules" in the COM definition:

• To haveInterface

• Make sure you have defined in the classes:

  [ComVisible(true)]
  [ClassInterface(ClassInterfaceType.None)]
  [Guid("XXXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX")] //GUID que se desee
  [ProgId("NombredeCom")]
  [ComDefaultInterface(typeof(IInterfaceDefinida))]
  

Where el GUIDis well defined, it IInterfaceDefinidais comvisibleand does not give any compilation errors or warnings.

But sometimes the error I have mentioned appears for no apparent reason. How can it be fixed?

I am trying to get the values ​​of a stringcontaining a url with a QueryString.

This is an example of the URL:

string url = "http://example.com?id=gdjh48vnnnvwsid1dkif84ndn?id2=cjodfnuvbvmf47747";

As you can see, it is a stringand not a QueryStringsince it is not the address of the page where I am, but a url that I get with a HTTPRequest.

I would like to know if there is any way to parse and obtain the values ​​of the url (in this case id1and id2) without using Split, Replace, etc... since this is not a guarantee that it will work 100% of the time (in the value of id1, for example, appears id1).

I have a document xlsand another xlsxalready saved in bytes[]my code and I need to pass it to html+cssso I can display it on a page.

It is important to note that I also need the cssand that means that reading each row individually from the excel is not an option since it would lose the style.

I am using Visual Studio with .NET to develop it in C# .

Currently it works for me from pdf that is easy to transform to html but this is not the case with xls, xlsxnor any Microsoft product since I cannot use the native library interopsince it is not a guarantee that the server has it installed.

The result would be something similar to this:

strFinalXls = strFinalXls.Replace("<body>", "<body>" + documentInfoHtml + "<BR /><BR />");

Where documentInfoHtmlis the result of transforming them bytes[]to html and strFinalXlsis simply the content that replaces that bodyof a page.

I have found a solution but practically all interopof them use either paid libraries.

Do you know any way to do it with free software or open projects?

It is also important to keep the existing CSS styles as much as possible, so answers that simply extract the content to generate it myself HTMLis not enough in the sense that it would lose all the formatting.

I have a document docxalready saved in bytes[]and I need to pass it to html so I can display it on a page.

I am using Visual Studio with .NET to develop it in C#.

Currently it works for me from pdf that is easy to transform to html but this is not the case with docxany Microsoft product since I cannot use the native library interopsince it is not a guarantee that the server has it installed.

The end result is:

strFinalDoc = strFinalDoc.Replace("<body>", "<body>" + documentInfoHtml + "<BR /><BR />");

Where documentInfoHtmlis the result of transforming them bytes[]to html and strFinalDocis simply the content that replaces that bodyof a page.

I have found a solution but practically all interopof them use either paid libraries.

Do you know any way to do it with free software or open projects?

Also I have to do the same process for files xlsand xlsx.

The current answer is very good but it only covers one file docand not thedocx

It is also important to keep the existing CSS styles as much as possible, so answers that simply extract the content to generate it myself HTMLis not enough in the sense that it would lose all the formatting.

I have a function in the code behind of an aspx page made with Visual Studio that is called from javascript like this:

function cerrar(id) {
    document.getElementById('<%= btnBloquea.ClientID()%>').click();
    alert("Curso " + id + " bloqueado correctamente.");
}

The problem is that the btnBloquea function sometimes gives an error and is redirected to the error page (I already have it under control) but whether or not the javascript code gives an error, alertit is ALWAYS shown even if the function has an error since it is executed from asynchronous way.

The button definition:

<asp:Button id="btnBloquea" runat="server" OnClick="btnBloquea_Click" CssClass="hidden"/> //CssCLass hidden es simplement un display:none

And of the function in its minimum expression:

Protected Sub btnBloquea_Click(sender As Object, e As EventArgs)
    Dim idEvento As String
    Dim cerrado As Boolean

    idEvento = hdngroupid.Value()
    cerrado = False 

    'Aquí vienen varios cálculos para si realmente se puede o no cerrar.        

    If Not cerrado Then
          'Aquí me voy a una página de error y NO quiero mostrar ningún alert.
    Else
          'Aquí todo ha ido bien y quiero mostrar el alert.
    End If

End Sub

My questions are:

1. How can I alert the user only if the result of the function is correct?
2. Is there a way to launch the alert only when it click()has finished?
3. Maybe I can create an alert from the code behind function?

I am modifying a project made in classic asp with Visual Basic 6 and I need to catch an error.

Specifically, the error is generated by these lines:

dim strResult, split1, split2  
strResult = FuncionQueDevuelveUnXML() 
split1 = Split(strResult,"</a:AccessToken>")(0)
split2 = Split(split1,"<a:AccessToken>")(1)

The case where it fails that I would like to capture is when the tag does not existAccessToken .

As you can see currently there is no control and the page generates an error 500 ( very ugly )

I know I could perform a InStrto check if the tag exists:

if InStr(strResult,"<a:AccessToken>") < 1 Then
    'No existe el tag
else
    'Si existe el tag
end if

But I wanted to know if a can be done try catchto catch any type of error.

Although not with try catchitself but something similar, the truth is that I do not know if there is such a thing.