First of all: STOP concatenating together your SQL code!! This is an invitation to hackers everywhere to attack you with SQL injection! Use parametrized queries instead! I would use this solution: create a single SqlCommand with a parametrized query, and execute that: string stmt = “INSERT INTO dbo.Test(id, name) VALUES(@ID, @Name)”; SqlCommand cmd = new … Read more
To loop through items properly you need to use ${var[@]}. And you need to quote it to make sure that the items with spaces are not split: “${var[@]}”. All together: x=(“some word” “other word” “third word”) for word in “${x[@]}” ; do echo -e “$word\n” done Or, saner (thanks Charles Duffy) with printf: x=(“some word” … Read more
Do it the other way around: <script> numberofArticles = 5; db = openDatabase(“websql”, “0.1”, “web-sql testing”, 10000); db.transaction(function(tx) { tx.executeSql(‘CREATE TABLE IF NOT EXISTS LOGS (id unique, articleID int)’); }); db.transaction(function (tx) { for (var i=0; i<=numberofArticles-1; i++){ tx.executeSql(‘INSERT INTO LOGS (articleID) VALUES (?)’, [i]); }; }); </script> And the alternative, the proper way with … Read more
The code should read the contents of the two files into lists of lines, then iterate over them. It ends up like this: # Set up various other variables here ($user, $password) # Get the list of hosts, one per line ##### set f [open “host.txt”] set hosts [split [read $f] “\n”] close $f # … Read more
Right now, you’re checking whether the sentence as a whole contains any vowels, once for each character. You need to instead check the individual characters. for (int i = 0; i < sentence.Length; i++) { if (sentence[i] == ‘a’ || sentence[i] == ‘e’ || sentence[i] == ‘i’ || sentence[i] == ‘o’ || sentence[i] == ‘u’) … Read more
You could try to define the variable before the loop, e.g. $report = “”; while ($row = mysql_fetch_array($result)) { $report .= “a”.”b”.$row[“prevDOCid”]+1; } echo $report; I hope this helps you! Edit Use .= not +=
Think of this way, after each loop, the scope is “destroyed”, and the variable is gone. In the next loop, a new scope is created, and the variable can be declared again in that scope. You can also do this, for the similar reason { int someInteger = 3; } { int someInteger = 13; … Read more
It’s not necessary to unpack and repack the tuples returned by zip: ‘\n’.join(‘ ‘.join(x) for x in zip(a, b))
I have figured it out, thanks for the feedback Tanmay. I noticed that the y-offset was incorrect for n – cols and should be row – half instead. Below is the most comprehensive and compact code I could obtain. Although it is preferred to enter an odd integer for the size, you could enter a … Read more
This recursive function should do the trick with any number of dimensions: var printArray = function(arr) { if ( typeof(arr) == “object”) { for (var i = 0; i < arr.length; i++) { printArray(arr[i]); } } else document.write(arr); } printArray(parentArray);