Posts by Márcio Lordelo • 182 points
7 posts
-
1
votes1
answer70
viewsA: How to generate random names for images that will be uploaded?
You can use the uniqueid() function of PHP. It generates a unique id taking time into account, in microseconds. You can pass a prefix to the function it concatenates with the generated id. For more…
-
0
votes3
answers958
viewsA: Query in two fields of a table
You can use COUNT() together with GROUP BY to return. In your case, it would be something like: SELECT COD_OCORRENCIA, COUNT(COD_PROVID) AS TOTAL_PROVID FROM ocorrencia, providencia WHERE…
sqlanswered Márcio Lordelo 182 -
1
votes2
answers54
viewsA: I have a QUERY that doesn’t display what I really need
After talking, through the chat, I saw that what you really want is: If the tipo is zero, it already accounts. If the tipo is non-zero, checks that other information is zero, and accounts for. This…
-
-2
votes1
answer116
viewsA: How to validate some fields in SQL
After talking, through the chat, I saw that what you really want is: If the tipo is zero, it already accounts. If the tipo is non-zero, checks that other information is zero, and accounts for. This…
-
3
votes2
answers7863
viewsA: When should I use GET function and when should I use POST function?
The GET has a character limit, varying according to the browser because this limit is based on the size of the URL. Usually using when you want to pass little information. Also, as you yourself…
-
3
votes3
answers464
viewsA: IDE - Divergence between Ides relative to tab [to Enter]
This divergence occurs in the snippets you edit from the file on Sublime ? In the eclipse there is a setting to remove the one whiteSpace. You going into Preference -> [linguagem, por exemplo…
-
1
votes1
answer133
viewsA: Replace problem on sqlserver
At first it’s missing a ) at last replace, would be something like replace( @charLinhaDigitavel,'' '','''') + '''' +'+''%'' ' The way it is there you end up repeating the digitable line, since you…
sql-serveranswered Márcio Lordelo 182