Posts by Andre Mesquita • 1,114 points
74 posts
-
0
votes1
answer466
viewsA: Error sending email ASP.NET
Include before the SEND method ServicePointManager.ServerCertificateValidationCallback = (sender, certificate, chain, sslPolicyErrors) => true; This code passes through the validation of the…
-
1
votes1
answer35
viewsA: list of tables in the database
Your question is rather extensive. I have prepared a script for creating tables that should give you a hint for your solution: -- Tabela de Produtos CREATE TABLE PRODUTO ( COD_PRODUTO INT,…
mysqlanswered Andre Mesquita 1,114 -
2
votes1
answer50
viewsA: Error adding Controler to ASP.NET MVC
Hi, Bruno, there’s an error in your foreign key statement. You declare your column and place the FK to the entity by designating the annotation for the attribute that makes the link. In case you…
-
0
votes2
answers210
viewsA: SQL Server foreign key is giving null value when entering data in the main table
Hi, Marco, if I understand correctly, you wanted FK from the 'process' table to receive the 'idClient' from the 'client' table'. Well, if it is, wouldn’t you have two options: 1) Perform the Insert…
-
1
votes1
answer211
viewsA: How to work with Foreign Keys in C# ASP . NET Core?
Hi, Lucas, if you are using Entityframework, I created this base class for the context for you to inherit yours from it, or make the change by overwriting the Onmodelcreating method, including…
-
0
votes1
answer42
viewsA: Azure Application Service Permission Bug
Microsoft support has concluded that there is a plugin that can be used in the Application Service called Composer which does not allow the word "vendor" and with it, the error occurs. We disabled…
-
1
votes1
answer42
viewsQ: Azure Application Service Permission Bug
I have an application service on Azure running wordpress. One day, while updating a plugin, this not only stopped working as the panel Kudu cannot visualize it. Observe: I can list inside the folder…
-
0
votes1
answer31
viewsA: Lazy Load only loads data when Solution remains
I know two important settings when it comes to Lazy Load and that have helped me over time: 1) Reiterate in context setting: Example: contexto.Configuration.LazyLoadingEnabled = false; 2) When the…
c#answered Andre Mesquita 1,114 -
1
votes1
answer1024
viewsA: Generate classes with XSD or import WSDL [ANS / TISS]
Hello, Rovann, to facilitate in future uses, I have created a Web App on Github already with the WSDL files imported into the application, ready for use. Everyone wants the fish, but few teach how…
-
1
votes1
answer813
viewsA: PHP SOAP - SOAP-ERROR
Message: "SOAP-ERROR: Encoding: Object has no 'Active' Property Your error message indicates that you expect an object named "Active" and cannot find. Please try to change the parameter from…
-
0
votes1
answer32
viewsA: Migration Conventions
According to the documentation, an identifier may only be up to 63 characters long. Need to use foreign key with smaller name. Try to use an annottation in the generation of it to decrease the name.…
-
0
votes1
answer181
viewsA: Masks in form fields in modal Woocommerce
Take a test like this: Create a javascript file with the code you want to run. For example, "seujavascript.js" and include in it: jQuery("#reg_billing_cpf").mask("999.999.999-99");…
-
0
votes2
answers72
viewsA: Validation of HTML variable
Hey, there, Arildo. I don’t really understand the scope of what you want, but only with HTML you don’t solve. The script you declared is Javascript and it is in it that you have to operate. You var…
-
2
votes1
answer326
viewsA: Page cannot be displayed due to internal server error
When this error occurs, without details of what is actually occurring, the ideal is to access the Windows Event Viewer and check the application error.…
c#answered Andre Mesquita 1,114 -
0
votes1
answer41
viewsA: displays php results
Hi, Kleyton, you need to make a Technical table Join with the table called. I’ve devised a simple scheme for understanding: /* Tabela Tecnico */ CREATE TABLE TECNICO ( COD_TECNICO int, TXT_NOME…
-
1
votes1
answer20
viewsA: Data sent to Model Clean when changing Page?
No need to pass the menu model to each screen. Normally the menu is loaded in the layout or by a partialview, so every time you change page, there will be the menu load.
-
0
votes1
answer14
viewsA: Wordpress index.php giving error with sidebar
Where is: 'before_title' => '<h3 class="widgettitle">', 'after_title' => '</h4>', Should be: 'before_title' => '<h3 class="widgettitle">', 'after_title' =>…
-
0
votes2
answers453
viewsA: Trigger with null value
Has a small correction in logic and syntax according to MSDN. CREATE TRIGGER VERIFICA ON CLIENTE FOR INSERT AS DECLARE @NOME VARCHAR(50), @TELEFONE VARCHAR(12), @ENDERECO VARCHAR (100) SELECT @NOME…
-
0
votes1
answer318
viewsA: Entity Framework is not interpreting my settings
[Foreignkey("Module")] is a foreign Moduloid key and not a Car ID. [Table("VIATURA")] public partial class Viatura { [Key] [Column("ID", TypeName = "NUMBER")] public long ViaturaID { get; set; }…
-
1
votes1
answer14
viewsA: How to call a plugin action by cronjobs
Hi, Victor. For these cases I use the plugin WP Cron Control. A simple solution without having to re-invent the wheel. I hope it helps.…
-
1
votes1
answer1734
viewsA: generate and email with pdf file attached with php
Hi, Lucca, I would refer you to create a temporary file and, after sending, delete it from the server. I took the liberty of including a function to generate the random name to complete the example.…
-
1
votes2
answers298
viewsA: Does the IP influence the ranking of the site?
Influence, always influence, even if you migrate your DNS. Whenever I came across this situation, I accepted the rule that I had to redo a re-indexing work and, over time, I got back to the desired…
seoanswered Andre Mesquita 1,114 -
1
votes1
answer158
viewsA: solve google speed insights problem
Hi, Horacio. It is not exactly plugin to be installed. The standards that influence Pagespeed are well explained on Webpagetest.Org and Gtmetrix websites. In your case, the file . HTAACESS, should…
-
1
votes1
answer501
viewsA: Entityframework + Sql Server + ASP.NET MVC
Everything is preferred... Your Connection string has the machine name but does not have the instance name. Try using SQLEXPRESS localhost in your Data Source, where you have SQLEXPRESS, in the…
-
1
votes1
answer425
viewsA: Ajax filter in wordpress
For security, so you don’t have requests for multiple php files, I advise you to create the functions in functions.php and access the functions using ajax. For this implementation I used only one…
-
0
votes3
answers2359
viewsA: Change htdocs from XAMPP to USB stick folder (or use XAMPP on Pendriver)
You need to locate the apache configuration file and include in it: <Directory K:\inetput\> Options Indexes FollowSymLinks MultiViews AllowOverride None Order allow,deny allow from all…
-
0
votes2
answers82
viewsA: Related news on the site
Danilo, now I understand what you want. You can use the css classes and check the desired event. It can be before (:before) or after (:after). Also, as the example below, use the focus event…
-
1
votes2
answers1343
viewsA: Apparmor DENIED Mysql
The general guidance indicated to solve this problem is in changing the charge permission of apparmour. Note the message indicating which feature lacked permission and which permission you…
-
0
votes2
answers57
viewsA: Query in two different tables in Wordpress
You need to make a Join between the tables: This query returns the column you want: SELECT um.user_id, um.meta_key, um.meta_value, u.user_email FROM wp_usermeta um inner join wp_users u on u.ID =…
-
0
votes2
answers459
viewsA: Page php, Not Saved In Bank ! Why?
Check the SQL commands: $sql = "SELECT 1 FROM email WHERE = '" . $email . "' "; $insert = "INSERT INTO downloads (email) VALUES ('" . email . "')"; Also check the closing of the SCRIPT tag. If if…
-
0
votes1
answer89
viewsA: Sql server error on the hosting server
Apparently, your SQL Server is not configured to receive connections. Please check the SQL Server Configuration Manager: You need to enable access. Check the protocol used on web.config and make the…
-
1
votes2
answers186
viewsA: How to select single data from a Join conditional?
See if it helps? select sv.* from servers sv inner join stats st on st.server_id = sv.id where st.type in ('inline','offline') order by st.modified desc limit 1…
-
1
votes5
answers19374
viewsA: How to check if a field of type text or ntext is null or empty?
A different version of a form already presented here. In this case, only Notes is converted and then compared. select * from tmp_textos where isnull(convert(varchar,Notes),'')=''…
-
0
votes4
answers2259
viewsA: How to display a Javascript message in an Asp.net MVC view?
With Viewbag: In the View, put: @if (!string.IsNullOrWhiteSpace(ViewBag.Erro)) { <script>alert('Olá');</script> } No Controller: public ActionResult Login(LoginViewModel model,…
-
0
votes1
answer43
viewsA: Previous Record Search (Mileage)
I decided to create a FUNCTION for the calculation of the previous KM. The solution becomes more beautiful. create function dbo.fn_km_abastecimento_anterior ( @codigoVeiculo as int,…
-
0
votes1
answer261
viewsA: Windows Server 2012 application with Locaweb domain
You only need two items: Create a DNS entry in Control Panel of Locaweb; Create an IIS BIND with this address. After creating the entry in your DNS, you should select your website on the IIS…
dnsanswered Andre Mesquita 1,114 -
1
votes1
answer211
viewsA: C# in form 2 does not show string in label
You need to allow the label1 to be changed by another class. In this case you must change the Modifiers property. In your case it is not working because the property does not have the value at the…
c#answered Andre Mesquita 1,114 -
3
votes2
answers164
viewsA: Help with textbox validation
You can perform the Onclose event treatment from the form. This is the event that is called after the Close method is called. In it you can specify if you can actually close. The article of the MSDN…
-
1
votes2
answers883
viewsA: AWS - Remote access to the instance
Windows RDP access: Security Group : Inbound : RDP : 0.0.0.0/0 To get the windows administrator password you need the . PEM file that was generated in your server generation. His name will appear in…
-
1
votes1
answer978
viewsA: Permission error while uploading file to Amazon server
The ideal would be for you to see the permission of the /var/www/html folder. You can check using the command "$ls -l". By default in the Ubuntu distribution, the owner must be the www-data user who…
awsanswered Andre Mesquita 1,114 -
1
votes1
answer180
viewsA: Download SQL Server Backup Amazon
Straight from Amazon RDS FAQ: Q: Where my database snapshots and automated backups are stored and how do I manage their retention? Amazon RDS automated backups and BD snapshots are stored in S3. You…
awsanswered Andre Mesquita 1,114 -
0
votes1
answer1408
viewsA: Webservice returns to Soapui, but does not return to PHP
Hello, Paulo. I took the liberty of transporting your code to the visual studio and managed to identify the problem. The error shown indicates that the token would be null, and indeed it is. If you…
-
2
votes3
answers3672
viewsA: Release other Amazon HTTP ports
To Amazon calls her firewall Security Group. You can reach this option through the panel by following: EC2 Dashboard >> Network & Security >> Security Group Note the INBOUND and…
-
0
votes1
answer279
viewsA: How to modify the server user and folder in Sqlserver 2014
To change the password, you can do: ALTER USER WITH password = "". Or use SQL Management Studio to select the user you want to change, click on properties and change the password by form. To change…
sql-serveranswered Andre Mesquita 1,114 -
3
votes1
answer1968
viewsA: Viewing Query History in Sql Server Management Studio
You need to enable the Recover in the settings.…
-
1
votes1
answer902
viewsA: Sending email to Asp net - Gmail
Not long ago I created a new Google account in gmail to use an application agent to send messages. On the first email attempt, the configured account received a notification preventing sending that…
-
1
votes1
answer3076
viewsA: How to validate md5 password with database?
In the inclusion I would already perform the encryption, as wordpress already does. Mysql already has the function and therefore its inclusion could be: "INSERT INTO user (email,senha) values…
-
1
votes1
answer2771
viewsQ: How to add a default Constraint to an already created column in SQL Server?
In SQL Server, assuming the column already exists, how to create a new DEFAULT Filter? I looked in various references and in all the examples, always had the column to create together. I found the…
sql-serverasked Andre Mesquita 1,114 -
1
votes1
answer2771
viewsA: How to add a default Constraint to an already created column in SQL Server?
The command is: ALTER TABLE [schema].[tabela] ADD DEFAULT (([valor])) FOR [coluna] If you prefer to name the Constraint: ALTER TABLE [schema].[tabela] ADD CONSTRAINT [nome-da-constraint] DEFAULT…
sql-serveranswered Andre Mesquita 1,114 -
1
votes1
answer242
viewsA: Setting up Phpmailer for Newsletter
First you need to specify the SPF of DNS. The Locaweb indicates this change: Locaweb Input TXT. SPF tells the target server that your server can send emails through the domain. Normally, PHP Mailer…