All Questions

2
answers

How to remove a foreign key in mysql?

I need to edit a table, but I can not remove it. I need to remove the foreign key, but all the commands I tried did not work. I'm currently tempting the alter table tabela drop foreign key nomefk And the error always happens saying that...
asked on 14.02.2018 / 19:22
2
answers

How can I prevent a user from sending the same form multiple times?

I have a form on a page, sometimes users can double-click the button to submit the form ... The form is a @using (Ajax.BeginForm(...)) { } How can I prevent this from happening?     
asked on 20.12.2013 / 15:12
2
answers

How to get the current date in MySql?

I want to create an event so that every hour verifies that the expiration date of the advertisement is higher than the current date, in which case it should change a topic of this ad in the database, that is, it would be something of the kind th...
asked on 29.04.2015 / 17:01
6
answers

How to do the following query without using INNER JOIN?

I have table A with the following fields: ID | ID_PAIS_ENVIO | ID_PAIS_RECIBO 1 | 23 | 47 //... I have table B with the following fields: ID | NOME_PAIS 23 | Brasil 47 | Portugal //... I need a query that returns the follow...
asked on 02.07.2014 / 15:50
3
answers

How to use this!

I need each button when clicked to turn yellow and the others return to normal ... follow the code and the fiddle: $( "#botoes" ).each(function() { $(this).click(function() { $(".botaoativo").removeClass('botaoativo'); $(th...
asked on 21.09.2014 / 21:56
3
answers

How to query in MySQL with two different conditions in WHERE

I have two queries that work perfectly apart, but I needed all of their records together. They would be these: SELECT b.idBanca AS idB, b.DataHora AS dataHora, b.Sala AS sala, t.idTrabalho AS idT, p.Nome AS orientador, a.Nom...
asked on 09.12.2014 / 04:11
2
answers

Alternative to create a new method on a String object?

I have the following situation: I have a txt file of defined positions (type CSV, CNAB, etc.) to process and extract values. For purposes of understanding, follow the code I've made and it's working perfectly: public class Extract { final...
asked on 17.03.2015 / 16:18
2
answers

Error "An error occurred while processing your request. "

I've developed an application in MVC C # for reporting in JSON, in my%% of cases it works normally, the query takes a long time because I get 2 to 3 databases depending on the report, the application in Azure, most of the time it gives an error...
asked on 10.10.2014 / 16:58
3
answers

Add space to each letter in UPPERCASE

How to make room using PHP when starting a capitalized word, for example, string oiEusouMuitoLegal results in oi Eusou Muito Legal .     
asked on 01.01.2015 / 00:33
4
answers

Creating a Permission Control System

I have a PHP / HTML system and want to deploy a permission system. It would work as follows: 1) I have some pages that some features can only be seen by higher positions. Example: I have a search page, for a normal user, I want it to searc...
asked on 07.10.2014 / 13:52