Posts by dHEKU • 829 points
30 posts
-
2
votes0
answers299
viewsQ: Select from a table within a cell of another table
In the SQL SERVER 2012 it is possible to construct a table that in one of its columns contains the result of another table? The master key would be the reference.…
-
1
votes2
answers1232
viewsA: How to implement google reCAPTCHA using classic Asp
If you already have the key, you must replace in the code below: File name: Googlecaptcha.Asp <%@LANGUAGE=VBSCRIPT%> <% Option Explicit %> <html> <head> <script…
-
2
votes2
answers531
viewsQ: Organize columns in rows for equal ID in SQL server
I have a single table with some key records(Foreign key) repeated at most 5 times according to entries, example: id_ok|fornecedor|valor_final|escolha|ativo|…
-
3
votes2
answers9986
viewsQ: Spacing between specified columns in the table without creating <td> a false
I am looking for a solution to leave a predetermined space between columns of my table, without resorting to the use of <td> or <th> phony (without anything written, just with a padding…
-
1
votes3
answers1827
viewsA: Excel - Extract only numeric fields from a selection containing text and numbers
You can also try using another formula, I don’t know why, whenever I use SpecialCells(xlCellTypeBlanks),error - So I chose to try for autofilter: Sub seleciona_numeros() Dim ultimalinha As Integer…
-
2
votes1
answer811
viewsA: Dropdown menu of Bootstrap on Asp.net site works only on the main page, what to do to fix it?
You don’t need to put the jquery of activation of the dropdown unless you want to use some event in conjunction with the click or anything else - only with formatting can you get it to work. Also…
-
5
votes2
answers1166
viewsQ: -ms-flexbox and flexbox do not work in Internet Explorer
I’m having trouble identifying what I should do to fix this mistake - I recently used the CSS Progress Wizard, it works perfectly on google Chrome and other browsers: But when I visualize in…
-
0
votes1
answer170
viewsA: How to center content on the screen depending on your mobile device with intel xdk?
You should take a look at how to work with media queries, as already explained in this question/answer here from Sopt. To find the specific resolution of the device you want to work on, you can use…
-
1
votes1
answer139
viewsA: Bootstrap 2 does not float image
You have two options, the first, to preserve your code, is to put everything between rows: <div class="row"> <div class="col-md-3"> <ul class="thumbnails"> <li class="span4">…
-
1
votes2
answers4025
viewsA: Split EXCEL file
I believe a solution in VBA would be far more practical than a manual and tiring, so I did it here if I didn’t have experience with macro, I left the code well explained: The idea is to take the…
-
1
votes2
answers66
viewsA: Problem to mount query
According to what was explained, I made a model like this: SELECT categoria, produto, pontos from tabela a WHERE pontos = (select max(pontos) from tabela b where a.categoria = b.categoria) order by…
-
1
votes1
answer3659
viewsA: How to customize checkbox/radio without using background: url?
You can try using the -webkit-appearance: none; to reset the default style and customize radio and other input elements, as well explained in that article.…
-
4
votes2
answers1099
viewsA: How to remove formatting from the GETDATE() command
If it is SQL-SERVER 2008 or earlier, the function FORMAT, very well applied by friend @gmsantos won’t work; You can do this function to remove special characters: CREATE FUNCTION…
-
7
votes3
answers438
viewsQ: How to make a standalone script using Global.asa
I’m looking to run a script that records information into the database every 24 hours. I’m not the server administrator, so I don’t have access to Scheduled Tasks, I read in some articles that I can…
-
2
votes2
answers436
viewsA: Form does not send the information to the email
$headers .= "From: dominio.com.br<[email protected]>\n"; $headers .= "X-Sender: <[email protected]>\n"; $headers .= "X-Mailer: PHP v".phpversion()."\n"; $headers .= "X-IP:…
-
5
votes1
answer674
viewsA: Formula excel SOMASE
For various criteria, you must use the SOMASES =SOMASES(B2:B158;E2:E158;">=4";E2:E158;"<=10") Syntax: =SOMASES( intervalo_soma, critérios_intervalo1, critérios1, [critérios_intervalo2,…
-
1
votes1
answer404
viewsA: problem with Response.redirect
The response.redirect is occurring first, simply because it comes first in the code - basically, ASP ignores everything that comes after redirecting. You can let javascript handle this:…
-
1
votes2
answers1223
viewsA: Transition effects on a slider
You can also use plugins to emulate other effects; I used this one a lot: http://www.joelambert.co.uk/flux/ On the jquery site itself also has a directory with animation effect plugins:…
-
4
votes4
answers34013
viewsA: How to make a loading screen before opening the site
If you want with picture: jquery jQuery(window).load(function () { $(".loader").delay(1500).fadeOut("slow"); //retire o delay quando for copiar! $("#tudo_page").toggle("fast"); }); .css .loader {…
-
2
votes1
answer650
viewsA: Bootstrap 3: left tabs no longer work?
No, those components were removed in version 3.0; But you can have a similar result in two different ways: 1 - Adding your own style to CSS: /* custom inclusion of right, left and below tabs */…
-
1
votes1
answer58
viewsQ: For + slideToggle in Jquery does not work
Can anyone explain why my code doesn’t work? I don’t know exactly how many divs will generate, but the maximum is 25. So I wanted each click button to specifically open the div "glue" attached to…
-
0
votes1
answer269
viewsQ: Optimize printing of great SQL-Server results through ASP
Today I have a classic ASP page with an unconventional chain-select (read "armengado") that returns a select populated with some data from an sql-server database (2005). I select the building and…
-
1
votes1
answer1193
viewsA: Problems with Error '9': subscribed out of range
From what I understand the main problem is that you are not able to get the last line used of the sheet "Database"; You can use: Dim totaldelinhas As Integer totaldelinhas = Worksheets("Banco de…
-
1
votes1
answer3074
viewsA: Allow automatic sending of email with Outlook
Here it worked normal without any notification window, with the code you provided: Function Enviar_dados_celulas_email(subject As String, destiny As String, body As Range, introductin As String) '…
-
1
votes3
answers2507
viewsA: Translate specific part of the Woocommerce template
Va no woocommerce-functions.php and look for the function that contains the property 'woocommerce_add_to_cart_message' to change the message "Product successfully Added to your Cart." For the…
-
0
votes3
answers888
viewsA: Range in Excel VBA
Hi, I have never used this method, but to select a dynamic table you can use the PivotTables. In your case, ex: Dim pt As PivotTable Dim tabelarange As Range Set pt =…
-
1
votes1
answer57
viewsA: Convert currency formats EUR->USA and USA->EUR in Excel
It would be a normal replace, like removing the commas and putting spaces; And removing the dots and putting commas? Cell format is in text or number? If you want to repeat yourself, just put a loop…
-
0
votes1
answer81
viewsA: Change Carousel caption on iphone
I believe you’re talking about Media Queries, I think this question has to do with the size of the screen, do a test using another browser on the iphone, to see if it remains the same thing;…
-
21
votes1
answer7883
viewsA: Map of Brazil - what is the best way to do it?
This can help you: https://github.com/felipeduardo/mapa-brasil-svg/blob/master/index.html The map is almost the same, just change the style. https://jsfiddle.net/9yp2L7ab/…
-
8
votes4
answers7856
viewsQ: Calculate Total Hours by identifying Equal Time Intervals
after a bit of a break in the head, I ask for help from you to assist in the following situation: I have a problem with SQL (Sql Server 2005) calculation of hours; Basically I have to calculate the…