Skip to content

Instantly share code, notes, and snippets.

View marcelodeandrade's full-sized avatar

Marcelo de Andrade marcelodeandrade

View GitHub Profile
@marcelodeandrade
marcelodeandrade / checkAndChangeCollation.sql
Last active October 20, 2016 13:10
Check and change column collations from table
-- Check column collations
SELECT
col.name, col.collation_name
FROM
sys.columns col
WHERE
object_id = OBJECT_ID('table_name')
-- Change column collation
ALTER TABLE table_name
@marcelodeandrade
marcelodeandrade / searchInProcedures.sql
Last active November 14, 2018 18:03
Search a text in procedure definition
SELECT name
FROM sys.procedures
WHERE Object_definition(object_id) LIKE '%search%'
@marcelodeandrade
marcelodeandrade / sessionContents.asp
Last active February 16, 2017 17:59
Get session content
Dim i
For Each i In Session.Contents
Response.Write i & "<br>"
Next
@marcelodeandrade
marcelodeandrade / composer_fxp.txt
Last active June 22, 2017 20:19
Composer FXP Plugin error solve
Error:
[ReflectionException]
Class Fxp\Composer\AssetPlugin\Repository\NpmRepository does not exist
[ErrorException]
Declaration of Fxp\Composer\AssetPlugin\Repository\AbstractAssetsRepository::whatProvides() shou
ld be compatible with Composer\Repository\ComposerRepository::whatProvides(Composer\DependencyRe
solver\Pool $pool, $name, $bypassFilters = false)
@marcelodeandrade
marcelodeandrade / recordset_loop.asp
Created March 9, 2017 12:37
Recordset iteratator
Do Until rs.EOF
For Each field In rs.fields
response.write(field.name)
response.write(" = ")
response.write(field.value)
response.write("<br>")
Next
rs.MoveNext
Loop
@marcelodeandrade
marcelodeandrade / request_loop.asp
Created March 10, 2017 19:20
Request iterator
For Each field in Request.Form
response.write field
response.write "<br>"
response.write Request.Form(field)
response.write "<hr>"
Next
@marcelodeandrade
marcelodeandrade / for-loop.xsl
Created March 17, 2017 14:22
For loop iterator for XSL
<!-- Define a template -->
<xsl:template name="for-loop">
<!-- Define parameters default value -->
<xsl:param name="index" select="1" />
<xsl:param name="total" select="1" />
<!-- TODO -->
<xsl:value-of select="$index" />
<!-- TODO -->
@marcelodeandrade
marcelodeandrade / insertInArrayAfterPosition.php
Created April 6, 2017 13:32
Insert a new key => value after previous position in array
$status = [
'Visualizar' => 'Visualizar',
'Editar' => 'Editar',
'Boleto' => 'Gerar Boleto'
];
// Define a chave => valor que será inserido no array
$pair = ['Status' => 'Alterar Status'];
// Procura no array pela chave e retorna o índice dela
1. install openjdk
`sudo apt-get install openjdk-7-jdk`
2. install `android sdk`
# download android sdk
wget http://dl.google.com/android/android-sdk_r24.2-linux.tgz
tar -xvf android-sdk_r24.2-linux.tgz
cd android-sdk-linux/tools
@marcelodeandrade
marcelodeandrade / vartype.asp
Created April 28, 2017 20:12
Get the type of variable
Set TypeDictionary = CreateObject("Scripting.Dictionary")
TypeDictionary.Add 0, "vbEmpty"
TypeDictionary.Add 1, "vbNull"
TypeDictionary.Add 2, "vbInteger"
TypeDictionary.Add 3, "vbLong"
TypeDictionary.Add 4, "vbSingle"
TypeDictionary.Add 5, "vbDouble"
TypeDictionary.Add 6, "vbCurrency"
TypeDictionary.Add 7, "vbDate"
TypeDictionary.Add 8, "vbString"