IPB





Welcome Guest ( Log In | Register )

24 Pages V   1 2 3 > » 

fido77
Posted on: Nov 2 2021, 02:57 AM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


I appreciate your time for looking into this Sir Robin! I just sent it back to them and said I believe something is missing, like the file to read from. They said that one of the developers made the assessment test, and that there could be something missing. I guess we'll find out sometime this week smile.gif
  Forum: Public Discussion · Post Preview: #30172 · Replies: 5 · Views: 4,713

fido77
Posted on: Nov 1 2021, 04:28 AM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


I think I got it smile.gif

Select Authors.Name, AVG(Price) AS AVG_Price
From Authors INNER JOIN BookAuthors ON BookAuthors.AuthorID = Authors.ID
INNER JOIN Books ON BookAuthors.BookID = Books.ID
GROUP BY Authors.name;

That seems to work.

Now, The only part on the Javascript I'm having seems to trouble everyone I've talked to. This is what they gave me:

let fs = require('fs');

function read() {
var promise = new Promise(function(resolve, reject) {
fs.readFile("myFile.txt", "utf8", (err, data) => {

if (!err) {
resolve(data);
}
else {
reject(err);
}
});
});
return promise;
}

------------------------------------------------------------------------------
Question: Use the read function and output the results.

read().then((x) => {console.log(x)}).catch((err) => console.log(err) );
--------------------------------------------------------------------------------
async / await option

try{
const x = await read();
console.log(x);
}catch(err){
console.log(err);
}

-----------------------------------------------------------------------------------

That is what they gave me. I didn't put any answer yet. I'm not sure what to do with this. It's almost like they gave me the problem and the answer, and there is nothing left to do. Am I missing something here?
  Forum: Public Discussion · Post Preview: #30170 · Replies: 5 · Views: 4,713

fido77
Posted on: Nov 1 2021, 03:49 AM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


I almost have all the SQL completed, which seems simple, but the last one I am having a problem with. I'm getting the average of all the prices instead of just the average price of the books by a certain author. Here is what I have wrote:

Select Authors.Name, AVG(Price) AS AVG_Price
From Authors, BookAuthors
INNER JOIN Books ON BookAuthors.BookID = Books.ID
GROUP BY Authors.name;
  Forum: Public Discussion · Post Preview: #30169 · Replies: 5 · Views: 4,713

fido77
Posted on: Oct 31 2021, 10:08 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


I have this assessment test I have been working on for my job. I don't mess with JavaScript or SQL very often, but they want me to finish it anyway :/
Was wondering if anyone here, like my good buddy Monkeyfiend, has any experience with it. I'm more of an OOP C# programmer. It looks simple enough, but I'm stuck on the second set of JavaScript questions and the second two SQL questions. I put answers, but I want to be sure they are correct before sending it back Monday morning. I'll just post them here for anyone who wants to give it a shot. Very much appreciated for any assistance.

//JavaScript

let data = ["A","B","C"];
let results = ["1","2","3"];
let entity = {};
for(let i = 0; i < data.length; i++){
entity[data[i]] = results[i];
}
console.log(entity);
Question: What do you expect the console.log will output?
--------------------------------------------------------------------------------------------
let fs = require('fs');

function read() {
var promise = new Promise(function(resolve, reject) {
fs.readFile("myFile.txt", "utf8", (err, data) => {

if (!err) {
resolve(data);
}
else {
reject(err);
}
});
});
return promise;
}


Question: Use the read function and output the results.
read().then((x) => {console.log(x)}).catch((err) => console.log(err) );
----------------------------------------------------------------------------
async / await option
try{
const x = await read();
console.log(x);
}catch(err){
console.log(err);
}
-------------------------------------------------------------------------------
function getText(text){
return new Promise(function(resolve, reject){
setTimeout(function(){
if(text)
resolve(text);
else
reject(new Error("text is empty"))
}, Math.random() * 10);
});
}
function logData(data){
console.log(data);
}

getText("Hello").then(logData);
getText("World").then(logData);

Question: Sometimes this app produces “Hello World” sometimes it produces “World Hello”. Explain why and correct it.
----------------------------------------------------------------------------------------------------------------------------------------

function data (){
return [1,2];
}

let [x,y] = data();

console.log(x);
console.log(y);
Question: What will console log out in this program and why?
________________________________________
_______________

SQL Technical Screening

Books
Id (int)
Title (text)
Price (int)
Authors
Id (int)
Name (text)
BookAuthors
BookId (int)
AuthorId (int)

WRITE A SELECT STATEMENT SHOWING ALL THE BOOKS ORDERED BY TITLE IN ASCENDING ORDER

WRITE A SELECT STATEMENT SHOWING ALL THE BOOKS AND THE BOOK'S RELATED AUTHOR(S)

WRITE A SELECT STATEMENT SHOWING THE AVERAGE COST OF A BOOK BY AUTHOR


  Forum: Public Discussion · Post Preview: #30168 · Replies: 5 · Views: 4,713

fido77
Posted on: Dec 12 2014, 07:04 AM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


Lol. Reading this whole thing only leaves me wondering how many years I have been amused by Monkey's avatar.
  Forum: Public Discussion · Post Preview: #16760 · Replies: 12 · Views: 11,369

fido77
Posted on: Oct 27 2014, 02:32 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


Nice! I have not hit anything with the catas.
  Forum: Public Discussion · Post Preview: #16314 · Replies: 10 · Views: 9,960

fido77
Posted on: Oct 12 2014, 06:24 AM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


It is an unusual kick here. I have not read the rules, but I have been in the clan for a number of years. I have never seen someone get kicked for rambling on in the game chat unless they were being racists and disrespectful of other players. I do not see any of that from the chat logs. I type all kinds of crazy shit into the game chat and can get a bit carried away sometimes, but I drink a lot and live on the other side of the lake. Just wanted to throw my opinion out there before I quit drinking for the night smile.gif
  Forum: Public Discussion · Post Preview: #16255 · Replies: 25 · Views: 26,475

fido77
Posted on: Apr 5 2013, 02:39 AM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


Lol. The bottom one was at the YetiZen party and the two with the girls dancing on the platform was the Untiy3D party.
  Forum: Public Discussion · Post Preview: #14144 · Replies: 2 · Views: 4,835

fido77
Posted on: Apr 4 2013, 07:17 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


Outside the building when we first arrived is Battlefield 4:
































  Forum: Public Discussion · Post Preview: #14142 · Replies: 2 · Views: 4,835

fido77
Posted on: Mar 24 2013, 06:52 AM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


This review was posted today. I am very excited for this trip, but I may have made a mistake when booking the Hotel. lol

I wasn't expecting much after reading all the reviews....but we spent $80 for a room here which was just ridiculous.
1. Room was clean, but the bathroom didn't work...and I mean, NOTHING worked. Toilet wouldn't flush. The trickle of water called a shower went from burning hot to freezing cold...nothing in between. Why did we pay an extra $30 for a bathroom?!
2. Breakfast is a bunch of crappy donuts...oh well, guess that's why it was free.
3. Internet only works downstairs. And I don't want to hang out in the lobby, some really weird people around.
4. Location...smack dab in the middle of the ghetto.
When we checked in at around 4 pm, there were 2 homeless men having a full out fight in the front. When we arrived back to our hotel at night (after some dinner), our taxi didn't even want to stop because he said it was unsafe. Told us to run to our hotel from across the street and not to stop. At least it was close to the tram to Fisherman's Warf...but really, that was the only redeeming quality about this place. We stayed 1 night and then switched hotels.
  Forum: Public Discussion · Post Preview: #14139 · Replies: 2 · Views: 3,852

fido77
Posted on: Oct 25 2012, 01:25 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


And WarZ beta.
  Forum: Public Discussion · Post Preview: #14117 · Replies: 8 · Views: 8,647

fido77
Posted on: Oct 25 2012, 01:25 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


I have had no crashes so far. I have not found any weapons outside. I mainly find water or a hat. I did find a shotgun once, but then I was killed by a zombie that did not move. There does seem to be quite a bit of PvP. I have been killed by another player only once so far, but keep seeing people talk about it in the in game chat. The food and water levels go pretty quickly so you gotta try to keep some food and water at all times.

I think it will be an ok game when it is released. There is quite a bit of content that is not availble in the alpha such as friends list, squad play, or any other features for playing with friends. From what the developers have been saying these are things that are going to be implemented in the full version.
  Forum: Public Discussion · Post Preview: #14116 · Replies: 1 · Views: 2,963

fido77
Posted on: Oct 25 2012, 01:15 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


Been playin BF3 and Borderlands 2. have MoH on the way.
  Forum: Public Discussion · Post Preview: #14115 · Replies: 8 · Views: 8,647

fido77
Posted on: Feb 28 2012, 07:34 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


I believe it has everything to do with sexual preference. Everything else does not really matter.
  Forum: Public Discussion · Post Preview: #14097 · Replies: 20 · Views: 25,482

fido77
Posted on: Feb 24 2012, 07:37 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


QUOTE (=R6= Raile @ Feb 23 2012, 05:48 AM) *
who even plays it any more?

we had about 15 guys playing it when it came out, and I might be wrong, but I don't think any of them are playing it any more!


We had 14 douches playing it. They stopped because of gayness on their part. I still play it when I have a chance. I have been trying to finish skyrim off here lately, but that doesn't mean I am done with bf3. The game is great and just keeps getting better smile.gif
  Forum: Public Discussion · Post Preview: #14094 · Replies: 20 · Views: 25,482

fido77
Posted on: Feb 21 2012, 07:46 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


Sell your pond!
  Forum: Public Discussion · Post Preview: #14092 · Replies: 20 · Views: 25,482

fido77
Posted on: Feb 19 2012, 06:43 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


GET IT!!!
  Forum: Public Discussion · Post Preview: #14090 · Replies: 20 · Views: 25,482

fido77
Posted on: Feb 2 2012, 07:54 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


QUOTE (Magik5 @ Feb 2 2012, 11:24 AM) *
Thats a pretty retarded statement.


Not when you work where I do and have to deal with dumbassez with switches all throughout their houses.
  Forum: PC, Website, Server & Game Support · Post Preview: #14085 · Replies: 6 · Views: 11,033

fido77
Posted on: Feb 2 2012, 04:20 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


The only real benefits of having the modem/router combo is that you only need one power outlet and you only have one device to troubleshoot if you loose connection. other than that it is still a modem and a router, just in one case. From what I can tell the brands all seem to be the same and all have no support for their products. For my DSL internet I have a westell 7500 modem/router combo. The only reason I have that is because I wanted to take out the possibility of my connection problems being my Linksys router. Stay away from switches. they are stupid.
  Forum: PC, Website, Server & Game Support · Post Preview: #14083 · Replies: 6 · Views: 11,033

fido77
Posted on: Dec 9 2011, 11:39 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


QUOTE (McJaffa @ Dec 9 2011, 03:29 AM) *
Good Stuff:
Colo(u)r blind setting smile.gif
Moved chat box out of way

Bugs not fixed list:
Everything critical (ie: crashes at end of rounds, crashes at launch, black screens on loading, complete PC lockups when using onboard sound)
Chopper TV missile (according to Raile/Twon)


I forgot to turn the color blind setting on. can't see most things before its too late without it. was very helpful in bc2.
  Forum: Public Discussion · Post Preview: #14073 · Replies: 2 · Views: 4,342

fido77
Posted on: Nov 21 2011, 01:35 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


i had forgot about that one. when the server does not appear in battlelog i cannot connect to it in procon either.
  Forum: Public Discussion · Post Preview: #14032 · Replies: 3 · Views: 4,971

fido77
Posted on: Nov 21 2011, 01:32 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


maybe not. Gummy's 9400 will not play the game. everything goes in slow mo. lol
  Forum: Public Discussion · Post Preview: #14031 · Replies: 20 · Views: 25,482

fido77
Posted on: Nov 18 2011, 09:57 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


QUOTE (MonkeyFiend @ Nov 18 2011, 01:40 PM) *
unlike me.. I talk without listening tongue.gif


no wonder your answers don't make any sense hitting.gif
  Forum: Recruitment · Post Preview: #14025 · Replies: 12 · Views: 17,405

fido77
Posted on: Nov 18 2011, 09:55 PM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


QUOTE (Aki @ Nov 18 2011, 04:04 AM) *
Seriously? Hrmz... its only a 2 core 1.86Ghz ... xp 3GB ram (4 really ... that reminds me I should upgrade to 7) geforce 9600 GT. :/ Think I might just scrape through?


yes sir!
  Forum: Public Discussion · Post Preview: #14024 · Replies: 20 · Views: 25,482

fido77
Posted on: Nov 17 2011, 04:03 AM


Knight Lieutenant
********

Group: Clan Members
Posts: 989
Joined: 5-June 08
From: Tyler, Texas, US
Member No.: 124


for just pennies a day you to can save an Aki.
  Forum: Public Discussion · Post Preview: #14017 · Replies: 20 · Views: 25,482

24 Pages V   1 2 3 > » 

New Posts  New Replies
No New Posts  No New Replies
Hot topic  Hot Topic (New)
No new  Hot Topic (No New)
Poll  Poll (New)
No new votes  Poll (No New)
Closed  Locked Topic
Moved  Moved Topic
 

RSS Lo-Fi Version Time is now: 29th March 2024 - 05:10 AM
Sneaky Monkeys Clan :: MonkeyFiend.com