Posts by Pedro Giorgis • 309 points
6 posts
-
3
votes2
answers10109
viewsQ: Set Value Local SQL Server Variable
I would like to assign the value of the local variable within the SELECT, as in the example below, but displays the following error message: "A SELECT statement that assigns a value to a variable…
-
2
votes4
answers6360
viewsQ: Break row into table cell in CSV format to be read by Excel
I have the following code that inserts a value in an excel cell for export context.Response.Write("aa\r\nbb\r\nccc"); /r/n breaks the line but writes in the cell below, would like to break the line…
-
-1
votes1
answer339
viewsQ: Installation My SQL
I am installing Mysql Server on my machine following the step by step, but finishing the installation does not show the Server Configuration Wizard (Mysql Server Instance Configuration Wizard). I…
-
6
votes2
answers652
viewsQ: I cannot place a subquery inside the IN in the PIVOT
Below is the code for table creation and insertion of some data for test. CREATE TABLE [dbo].[tb_empresas]( [data] [date] NULL, [nome] [varchar](100) NULL, [valor] [decimal](18, 2) NULL ) ON…
-
3
votes3
answers8251
viewsA: Using jQuery Validation Engine and CNPJ validation
Follows the correct solution: Aspx asp:TextBox ID="txtCNPJ" runat="server" CssClass="validate[required, funcCall[validateCNPJ]]" Put to jquery.validationEngine-pt_BR.js "cnpj": { "alertText": "*…
-
7
votes3
answers8251
viewsQ: Using jQuery Validation Engine and CNPJ validation
I am using the jQuery Validation Engine with this file of translations into Portuguese. I added in Javascript the following line: "cnpj": { "regex": /^\d{2}\.\d{3}\.\d{3}\/\d{4}\-\d{2}$/,…