I have create sql quary to update datetime fields from utc to local time zone can review it and give me some advice BWT
BEGIN TRY
BEGIN TRANSACTION
--update rrnForm
UPDATE [dbo].[registrationForms]
SET VisitPhoneDate = (CONVERT(datetime2, SWITCHOFFSET(CONVERT(datetimeoffset,RrnVisitPhoneD...
I just started with Python 3.4.2 and trying to find and replace text in csv file.
In Details, Input.csv file contain below line:
0,0,0,13,.\New_Path-1.1.12\Impl\Appli\Library\Module_RM\Code\src\Exception.cpp
0,0,0,98,.\Old_Path-1.1.12\Impl\Appli\Library\Prof_bus\Code\src\Wrapper.cpp
0,0,0,26...
After searching the internet, I was able to find a base JavaScript file in order to build upon for my project. Which is to create a Adobe Illustrator Script that will create the desired Folders and then export different resolution ratios for each artboard. This method is used in order to create W...
I have a makefile that I've been using to compile my shared libraries which reads in the files from different folders and then builds the objects and binaries in their own folders. The folder structure I'm using is roughly displayed below.
-Folder
|
+--API Header Files Dir
|
+--Library (.so)...
Stack Exhange and Code Review are not fora
Stack Exchange is not a forum
Replace Stack Exchange for Code Review if preferred.
I received a code analysis warning in Visual Studio 2013, but I'm not sure why and I wondering if anyone can give me some insight.
Original Code:
using (var stream = client.OpenRead(httpAddress))
using (var sr = new StreamReader(stream))
{
string content = sr.ReadToEnd();
return conte...
I found a neat way to find the signum of a number (Java):
public static int signum(int x) {
return x != 0 ? x / abs(x) : 0;
}
This is the Java method:
public static double signum(double d) {
return (d == 0.0 || Double.isNaN(d))?d:copySign(1.0, d);
}
I was thinking my method was not ...
Ron Wesley has been bit by a three headed snake and Harry Potter is searching for a potion. The Witch promises to tell the ingredients of the medicine if Harry can find equi pair of an array. Listen to the conversation between Harry The witch to know more about equi pairs.
Conversation:-
The ...
This just feels like it could be done better, but I can't figure how.
This function checks these 6 fields for a user profile to determine if they have "completed" their profile.
/**
* Is the user's entire profile filled in?
*
* @return boolean
*/
public function isProfileComplete()
{
$...
I think that a comparative review should be 2 questions, and then the user can take the answers from both and do the comparing on their own. then they can decide what is going to work best for their situation.
This came from chat.
There is a lot of discussion in Chat about comparative-revie...
I am running an Intel Chromebook with Ubuntu 12.04 LTS and would like to upgrade to Ubuntu 14.04 LTS. Is it possible to create code that does this?
I have to create a box 5x5 using the images that they gave me, and my first solution was to create 25 variables and print them, which is very inefficient but it was the first thought that occurred to me, now I would like to optimize this code is there some way?
here I leave the declaration of...
This is what I have written to get the LCA of binary tree in c++. I want to know at which conditions these will fail. I am sure about it but can't figure it out.
node * lca(node * root, int v1,int v2)
{ if(root == NULL)
return root;
if(v1 <= root->data && v2 >= root->data)
...
I am implementing a multi-player game in C# and having seen all sorts of projects, from indie developers all the way to large studios struggle to patch networking into existing products in the past, have made the decision to get the networking aspect done first, and build the game on top of that....
I am very new to Ruby,And I am facing error on below code as
"syntax error, unexpected keyword_end, expecting end-of-input in line 8".
Can any one help me what is the mistake in my code.
Class Paste
def pasteinfo(companyname,brand,price)
@companyname=companyname
@brand=brand
...
First, I'll start off with my script:
#!/usr/bin/env python
"""Scraping information from https://www.tdcj.state.tx.us/death_row/dr_executed_offenders.html"""
import requests, time
from bs4 import BeautifulSoup
from collections import defaultdict
url = "https://www.tdcj.texas.gov/death_row/dr_e...
Put the php code outside the form, run it once and create a variable with the options, something like:
$dropDownList = '<select name="vat" id="find" data-required="true"><option value="">Select Vat</option>';
$query = mysqli_query($con, "SELECT * FROM `tax_vat` ");
while ($row = mysqli_fetch_a...
First attempt at doing anything F#-y from a very heavy C# background, think I've grasped the fundamentals of FP, but always good to get other eyes on it:
namespace FSharp.GameOfLife
open System
open System.Drawing
module Array2D =
let toArray (arr: 'T [,]) = arr |> Seq.cast<'T> |> Seq.toAr...
I made myself a simple budgeting application. Each transaction is stored in the “transactions” table:
CREATE TABLE transactions (
-- Foreign key into the "categories" table, not shown here. (In reality this
-- has a NOT NULL constraint instead of a default, but this makes the
-- exam...
I'm trying to learn HTML5 and I'm interested to respect good practices of this language. I've learned it was better to use tags as <section> or <header>, to make your code more readable, than use always <div> tag.
I don't care about SEO (because my project doesn't target web), so I suppose that...
I'm relatively young in Java, and am familiar with only the basics of the language, yet. I've started studying data structures, and I've made an attempt to create a solution for the selection sort algorithm. After many attempts with errors and exceptions, I've managed to come up with what looks l...
I've created this simple 3D voxel terrain generator using Perlin Noise. I have a few concerns about it though.
Is there any way to make it more performant? It currently takes ~1.5 seconds to generate a 200x200 map.
Am I splitting up the different "jobs" of the generator correctly?
Is my general...
