Posts by Thiago • 491 points
31 posts
-
2
votes1
answer85
viewsQ: Change default pages created by MVC in Visual Studio C#
When I create the controller and use MVC 5 Controller with views, using Entity Framework, the Index, Create, Edit, Delete and Details are created automatically with a default setting, and I have to…
-
0
votes1
answer596
viewsA: Save IE file generated by Javascript using VBA
Dear, I chose to use Chrome and found that javascript sends information via url, so I used the following logic: Sub teste() Dim chromePath, PN As String Dim Linha As Integer chromePath =…
-
0
votes1
answer1279
viewsA: Excel stops working when I use Workbook.close to close another spreadsheet
Hello, I usually use the command to close other sheets as follows: First store in a variable the name of the spreadsheet I want to close: FileName = ActiveWorkbook.Name After performing all…
-
0
votes1
answer596
viewsQ: Save IE file generated by Javascript using VBA
Dear friends, I am using the routine to access a page and download a file, which uses a javascript to be generated, but I need this file to be saved automatically, without user intervention. Sub…
-
1
votes1
answer2208
viewsQ: Phpexcel class line break string
Dear, I have a small problem generating an excel file using the Phpexcel class. I do a query in the database and get a string with an x amount of chars, and insert this value in an excel template.…
-
0
votes1
answer75
viewsQ: Problem with generating txt via PHP
Dear, I have a routine that creates a txt file with some information of a query in mysql, but when the query returns some text with quotes, the problem begins. When displaying the data on the…
-
1
votes2
answers5211
viewsQ: Delete tr table html jquery
Guys, I created a routine that adds a tr to an existing table, and I’m trying to create a boot to remove this tr, but I haven’t been able to. I used the following code to add to tr, this works…
-
5
votes1
answer6466
viewsA: Add Mysql Time Field
Dear, thanks for the help,I managed to solve the problem using time_format leaving the query so: SELECT time_format( SEC_TO_TIME( SUM( TIME_TO_SEC( TOTAL ) ) ),'%H:%i:%s') AS total_horas FROM…
-
4
votes1
answer6466
viewsQ: Add Mysql Time Field
Dear friends, I have a table with a TIME column, which stores the time worked on the day, and I am trying to sum up these times at the end of a month, but without success. I used the following…
-
1
votes2
answers621
viewsQ: Return default value in mysql query
I own a query that in certain situations does not return value. In this case I would like to get the value 0, I tried using the ifnull, but without success. SELECT ifnull((valor * t1.PBRT),'0') AS…
-
1
votes1
answer1100
viewsQ: Select with value lookup in another table
I have a table with foreign key fields, and would like to return in a select the value of the item for the key. For example, I have the following table formed with the query: SELECT cod_produto,…
-
1
votes1
answer681
viewsQ: Loop for adding Mysql fields
Dear, I have two tables, where Tabela1 has columns from A1 to A4, B1 to B4, C1 to C4 and D1 to D4, all of the decimal type (4,2) and with n rows; and the table2 has 3 columns being Total1, Total2…
-
2
votes1
answer41
viewsQ: Problem with special char insertion via prompt
Dear, I have a table where I do some Inserts with data containing special char. Currently I use Toad for Mysql, and when I do the insertion by this editor, everything happens correctly, the special…
-
1
votes2
answers2195
viewsQ: Change Jquery global variable value and use in PHP
Dear, I have a code that displays a dialog with a table, where after selecting the item, it is sent to an input field, via ajax. I need to use this value in a php function on the same page, so that…
-
0
votes2
answers835
viewsQ: Select only columns with values
I have a table with a sequence of fields with almost the same name, changing only the final character, and I need to make a query that returns only the columns with some value, currently I do the…
-
0
votes2
answers1508
viewsA: how to select an option and update the values (price, images ...) that are in the database?
Hello, I came across something similar, I believe that if you adapt the code below will be possible to get the expected result. Jquery code $('#txt_ssd').blur(function(){ /* Configura a requisição…
-
0
votes3
answers2063
viewsQ: Problem with Div scrolling when running Zoom
Dear friends, I’m putting together the standard layout for some pages I’m developing, but I’m still a beginner in html and css pages. In my code, the footer tag moves from the main div when I zoom…
-
-1
votes1
answer155
viewsQ: Group Mysql Values
Dear, I have a table with the configuration: Tipo Medida Valor 1 0.2 5.00 1 0.4 6.00 1 0.1 5.00 1 0.3 5.00 2 0.1 3.00 2 0.2 3.00 2 0.3 5.00 2 0.4 5.00 I would like to group the values where they…
-
0
votes1
answer602
viewsQ: Somar Campos Input
I am trying to sum up some fields in a final input `. I have a input id #TotalFR and would like that, according to the fields #CFR1, #CRF2, #CRF3, #CRF4 and #CRF5 are completed, the sum of the…
-
1
votes1
answer51
viewsA: Dialog fields appearing when page updates
I got it fixed, just put the script onload=function(){ document.body.style.visibility="visible" } and make the body stay with visibility:hidden in css.…
-
1
votes3
answers2134
viewsA: Compare Mysql Select Values
My table is with the fields MAXIMO, MININO and TYPE in the type FLOAT, and for comparison of the way I wish, this format is not interesting, according to the link Problems with Float type . The…
-
0
votes3
answers2134
viewsQ: Compare Mysql Select Values
I have a table with four columns, the first with one type, the second with the minimum value , the third with the max value, and the fourth with the data I want. I need to select the value of the…
-
0
votes1
answer51
viewsQ: Dialog fields appearing when page updates
Dear, I’ve inserted some divs to work with dialog and tabs , those using jquery. Everything is working well, but every time I enter or update the page, the fields that have a dialog "behind" gives a…
-
1
votes2
answers1413
viewsQ: Loop repeat jquery
Guys, I’m having a problem and I still can’t find a solution, I’m still new to jquery, I’d like a little help, please. In the code below I have a procedure to call a dialog, which will be loaded…
-
0
votes1
answer199
viewsA: Send data to Fomulario by Dialog
Dear, I got the result, in this example a dialog is called and it contains a div with a table loaded by php, where it has a check box field, when it is selected, and the OK button receives the…
-
0
votes1
answer199
viewsQ: Send data to Fomulario by Dialog
Dear ones, I set the code to display a table in a dialog, but I would like to , when clicking on the icon, the name of the table field was sent to an input field of my form. Another detail, my…
-
2
votes1
answer2137
viewsQ: Jquery mask working only for one field
Dear, in my code I must insert two mask, however, only of INSC_EST It’s working, the other one isn’t. Follows the code: <html xmlns="http://www.w3.org/1999/xhtml"> <head> <script…
-
0
votes2
answers1677
viewsQ: Jquery mask when typing text
I have been researching some Jquery masks to apply on a system, but I noticed that in some examples the mask is displayed when you click on the input, and in other cases the mask is applied during…
-
2
votes2
answers2112
viewsQ: Fixing Elements in the DIV
I’m building an HTML page with some Divs, and inside one of them there is a input and a button. But when I zoom out, the Ivs stay aligned the right way, but the button and the input come out of the…
-
5
votes1
answer853
viewsQ: Mount array with txt data
I’m trying to find a way to assemble a table with the data of a txt, but I don’t know how to separate the values in the array, since they are separated by several spaces, but are identified by…
-
3
votes1
answer685
viewsQ: Form does not send all variables by POST
I am a beginner in PHP and created a form, and when I submit it by POST, only two variables (DESCRICAO and CODIGO) are being sent, the rest are blank. What is the error in this code? <form…