Posts by Rafael Christófano • 365 points
29 posts
-
0
votes2
answers193
viewsA: SQL Compare values in other rows
Answering my own question, with the help of Sorack, further increasing the question of counting the days if the guest stays. select transf.codigo_hospede, transf.transferencia, transf.data_entrada,…
-
-1
votes2
answers193
viewsQ: SQL Compare values in other rows
I have a table called transferencia that has data on the movement of a guest in a hotel, for example The table has no date of departure, so the date of departure is the data_entrada in which the…
-
1
votes0
answers1492
viewsQ: Block direct push on the master branch
I am starting a private project on Github and will have the participation of 5 developers and I will be the leader of this project. Each developer will have their branch to publish the files for…
githubasked Rafael Christófano 365 -
0
votes1
answer242
viewsQ: dll error in apache
I installed wampserver 3.1.7 on Windows 8.1 64, and apache is showing the following message. I have tried with newer versions of wampserver and the error persists, what changes is the word "isupper"…
-
1
votes1
answer56
viewsQ: SQL query for foreign key null fields
I have a relationship that has the chart: maoObra ( id* , descricao , valor , ... ) And the table: pecas ( id* , nome , valor , ... ) I have another table: ItensServico ( id* , data , pecas_id ,…
sqlasked Rafael Christófano 365 -
4
votes1
answer286
viewsQ: How to align an element at the bottom of the mother div?
I need the content that’s in <h1> stay aligned below (bottom) in <div>. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css"…
-
0
votes2
answers112
viewsQ: SQL: Compare between 2 columns and return only 1
I have a table of clients that includes clients PF and PJ. In this table, if the client has CPF has no CNPJ, if CNPJ has no CPF. I need a query that checks which of the two columns is not null and…
-
0
votes0
answers447
viewsQ: Checking that the CPF is unique with Jquery validate remote
I’m making a form that checks if the number already exists in a database. In my JS I use the Jquery Validate library $('#form').validate({ rules:{ cpf: { required: true, cpfBR: true, remote:…
-
1
votes1
answer30
viewsQ: Recover DOM element from a column
I have an event in Jquery that flags information from a table row (I’m using Jquery Datatables). var linha = $(this).parents('tr')[0].innerHTML; The value returned is this: <td class="text-center…
-
1
votes0
answers140
viewsQ: Validate date time with jquery validate
The title of the post says it all, I have one with the mask dd/mm/yyyyyy hh:mm and I would like to validate if the user typed correctly. I tried to create using addMethod and did not succeed.…
jquery-validateasked Rafael Christófano 365 -
0
votes1
answer104
viewsA: Modal opening using different links to the same table row
I was able to solve it this way: In the product link, the id goes with a name that indicates the column referring to information and concaten with a '-' separator plus the value of the id where the…
-
0
votes1
answer104
viewsQ: Modal opening using different links to the same table row
I have the following table: <table id="tabela"> <thead> <tr> <th>Produto</th> <th>Cliente</th> </tr> </thead> <tbody> <tr> <td…
-
0
votes1
answer1129
viewsQ: Popular Datatables via a JSON variable
I have the following function that returns data from a query in the database and stores in json format in the msg variable. $.ajax({ type: 'POST', dataType: 'html', url: page, data: {idtabela:…
ajaxasked Rafael Christófano 365 -
0
votes0
answers60
viewsQ: Recover Json after Success and use in PHP
I have the javascript code that returns me in a 'msg' variable the result of a query made in PHP. var page = "busca.php"; $.ajax({ type: 'POST', dataType: 'html', url: page, data: {idtabela:…
-
0
votes1
answer458
viewsQ: Insert items into a table using Jquery
I have a form where I insert into the bank the sale and the sale items. When opening a particular sale, the items of that sale are displayed in a table. When I want to add a new item to this sale,…
-
2
votes1
answer780
viewsQ: Sending variables in Ajax to PHP
Using php I do a BD search and send the data to AJAX via JSON: echo json_encode(array('sucesso'=>true, 'mensagem'=>'Dados inseridos com sucesso','idservico'=>$idServico)); In AJAX I…
-
0
votes1
answer628
viewsQ: Capturing the input type date
have a <input type="date" class="form-control" name="data"> In Jquery I need to capture this date and then send it to BD var data = $("#data").val(); But the value only returns 'Undefined'.…
-
-1
votes1
answer62
viewsQ: Remove 'R$' before converting to Double
I have a list of products in a table, and in order to make the interface more friendly, in the column 'price' I awarded the 'R$' next to the value. Now I need to capture this value to do a…
-
0
votes1
answer36
viewsQ: Hide a table after clicking
I have a table that lists the customers of a company. The user selects the client he wants through the links in each. By clicking the table data feed the form inputs. Only now I want to hide the…
-
1
votes1
answer129
viewsQ: Capture a record in a table and then insert it into the database
I’m developing a service order registration form for a workshop. I need the registered service to be linked to an already registered customer. For this I created a search form where the user can…
-
1
votes0
answers37
viewsQ: Reuse the Navigation Drawer in other Activities
I created an Activity Navigation Drawer, configured the menus, customized it for my application. Now what? How do I create new activitys by reusing Navigation Drawer creating for the first?
-
3
votes1
answer286
viewsQ: onclik event() Error opening camera
I’m developing an android app I have an event on the Button to open the camera: On Androimanifest.xml <!-- Permissão para acessar a área de memória externa --> <uses-permission…
-
1
votes2
answers111
viewsA: Textboxfor with white spaces
I found the problem: The field in Sql Server was as nchar, when the right thing is nvarchar. Who was populating values with spaces was the bank.…
-
2
votes2
answers111
viewsQ: Textboxfor with white spaces
I have a Textboxfor that lists the record of a table field. When displaying in the view, the textbox throws blank spaces after displaying the record content. I realized that these spaces are to…
-
0
votes0
answers97
viewsQ: Creating menu to link div
I have a link: <li><a href="#schedule">Programação</a></li> Which redirects to the div: <div class="schedule" id="schedule"> <h1>Programação</h1>…
-
0
votes0
answers76
viewsQ: Set a default value in Dropdownlistfor
In the form I have a: @f.FormGroup().DropDownListFor(r => r.AtividadeId, Model.AtividadeList).WidthLg(6) listing all activities to perform a filter per activity. I want to put an option: "List…
c#asked Rafael Christófano 365 -
2
votes1
answer786
viewsQ: View Model receiving Null values
After a query in BD, my query returns some null values in some attributes and when passing the values to the model: ViewModel.Participantes.Add(new RelParticipantesInscritosAtividadeVM { RA =…
c#asked Rafael Christófano 365 -
3
votes1
answer51
viewsQ: Converts an SQL query into Entity Query
I asked this question in another forum, but the content of the discussion went another way so I decided to open this topic. Without running away from the subject, how do I perform this SQL query:…
-
1
votes0
answers132
viewsQ: Query using the Entity Framework
I’m a beginner in the Entity Framework and I picked up a software for maintenance that uses the Entity. I need to create a report and do the following SQL search using Entity: select p.RA, p.Nome,…