MrFujin
Lord of the Dance
Devshed Expert (3500 - 3999 posts)
- Join Date
- October 30th, 2003
- Last Activity
- Today 06:21 AM
Recent Visitors
- ducvietnam003,
- jonh85711,
- khaiminh1407,
- kiteless,
- linhxinh19999,
- maytinh.ctv05,
- namviet382,
- seogama88,
- uuvancuong,
- vattugiatot24
-
Older Activity
-
Should have be more cleared that my example was just that - an example of who you could place the subquery into its own join statement. Only...Yesterday, 06:18 PM3 replies | 67 view(s)
-
Maybe this blog article can point you in the proper direction: DNS Load Balancing and Using Multiple Load Balancers in the CloudYesterday, 12:24 PM3 replies | 61 view(s)
-
You should add the subquery as its own join and then "link" them together. Something like this: select d.description , count(*) as frequency...Yesterday, 12:19 PM3 replies | 67 view(s)
-
MrFujin replied to a thread Design a notification system for real time events delivery in Software DesignJust one comment about "keeping the same values in different places". If you think about a global system, I can imagine a set-up where you would...January 22nd, 2015, 06:42 PM3 replies | 198 view(s)
-
MrFujin replied to a thread My secure password-based authentication method in Security and CryptographyThen I better like another similar version (from an online-game) where it displayed a number-pad and then you had to click your number as the...January 21st, 2015, 07:00 PM3 replies | 218 view(s)
-
Searching for a tutorial on google could be a good start. You can also start taking a look at the sticky post at top of this forum.January 20th, 2015, 03:18 PM2 replies | 187 view(s)
-
Do you know how to get the value of an check in PHP? if not, look here: PHP: Get Values of Multiple Checked Checkboxes | FormGet With SQL you have...January 20th, 2015, 03:01 PM4 replies | 262 view(s)
-
How do you get the data without filtering?January 20th, 2015, 04:41 AM4 replies | 262 view(s)
-
What does you program do? and what exactly does it do? any error(s)? unexpected behaviour? Something else? If you have changed the code, please...January 18th, 2015, 03:02 PM13 replies | 423 view(s)
-
Compare the two scanf and find the difference. The order you had with printtf and scanf was ok.January 18th, 2015, 12:36 PM13 replies | 423 view(s)
-
Just thinking, can you actually modified that file manually? What happens if you try to copy the ADMIN_PW to SYSTEM_PW and then save it? Have you...January 18th, 2015, 11:45 AM3 replies | 133 view(s)
-
Do you want to store the result as 'Y' or 'N' in the database? Or will it be enough to have it as '1' (true/yes) or '0' (false/no) If 1/0 is ok,...January 18th, 2015, 11:40 AM13 replies | 411 view(s)
-
in scanf, you should only specify the name of the variable. Think you have a copy/paste issue, since you also have add 'ohms' and ' volts' in it....January 18th, 2015, 11:38 AM13 replies | 423 view(s)
-
MrFujin replied to a thread Starting problems - what is wrong with this function? in Android DevelopmentWhat does "does nothing" mean? Does it Crash? does it open but not correct layout / missing elements? something else? What did you expect it to do?January 14th, 2015, 11:07 AM1 replies | 104 view(s)
-
MrFujin replied to a thread Seeking advice: many to many relationship design and query in MySQL HelpOnly thing with it that seems annoying - from an EXPLAIN point of view - is the order, making it to use temporay and/or filesort. Although I can't...January 13th, 2015, 02:20 PM40 replies | 539 view(s)
-
MrFujin replied to a thread Seeking advice: many to many relationship design and query in MySQL HelpDefine "reasonably". :) a table with ~40.000 rows should not be the bottleneck, especially not if you have proper indexing. Even if you...January 13th, 2015, 12:01 PM40 replies | 539 view(s)
-
MrFujin replied to a thread Seeking advice: many to many relationship design and query in MySQL HelpThink this is where the design went wrong. You should have a table (which could be called pcfeats or userSkills) containing the user_id and...January 13th, 2015, 04:17 AM40 replies | 539 view(s)
-
MrFujin replied to a thread Seeking advice: many to many relationship design and query in MySQL HelpWhy is it you have pcfeats as an tempory table in first place? How is data put into the table?January 12th, 2015, 05:02 PM40 replies | 539 view(s)
-
MrFujin replied to a thread Seeking advice: many to many relationship design and query in MySQL HelpThis is my best solution: SELECT feats_g.id as featID, feats_g.name as featNAME, pcf1.id as hasID, NA.NAid as NotAvailble FROM feats_g LEFT JOIN...January 12th, 2015, 12:58 PM40 replies | 539 view(s)
-
MrFujin replied to a thread Seeking advice: many to many relationship design and query in MySQL HelpHmm, this sounds a bit tricky. 1. First you will have to select all skills from feats_g. 2. Then you want to remove those skills that are already...January 12th, 2015, 10:43 AM40 replies | 539 view(s)
-
MrFujin replied to a thread Seeking advice: many to many relationship design and query in MySQL HelpCan See your point. You want to List those skills where requirements ( if any) are fulfilled but not yet taken.January 11th, 2015, 09:14 PM40 replies | 539 view(s)
-
You have to assign the value before you use it. Move the line up before birthDay. currentYear = 2015; birthYear = currentYear - age; ...January 11th, 2015, 06:01 PM4 replies | 194 view(s)
-
Where do you assign a value to currentYear? I suggest you take a look at the time structure: https://www.google.dk/#q=c+programming+time When...January 11th, 2015, 05:30 PM4 replies | 194 view(s)
-
MrFujin replied to a thread Seeking advice: many to many relationship design and query in MySQL HelpAlterntative suggestion: SELECT ft_req.ft_id, COUNT(ft_req.ft_req) as needskills, count(pcfeats.id) as haskills FROM pcfeats RIGHT JOIN ft_req...January 11th, 2015, 05:03 PM40 replies | 539 view(s)
-
MrFujin replied to a thread Seeking advice: many to many relationship design and query in MySQL HelpMaybe this one will be useful: SELECT ft1.ft_id, COUNT(pcf1.id) FROM pcfeats as pcf1 INNER JOIN ft_req as ft1 ON ft_req=id GROUP BY...January 11th, 2015, 04:55 PM40 replies | 539 view(s)
-
MrFujin replied to a thread Seeking advice: many to many relationship design and query in MySQL HelpAs you describe it, it sounds like there are no multi-level. Based on what you said, all id in ft_req for a specific ft_id should be listed in...January 11th, 2015, 04:15 PM40 replies | 539 view(s)
-
MrFujin replied to a thread Seeking advice: many to many relationship design and query in MySQL HelpThen the questions is as follow. If user has 0, 5 and 21. Should it then only display 20? or should 22 be included? If first is true, then it...January 11th, 2015, 03:43 PM40 replies | 539 view(s)
-
For programming in Windows environment, I would say learning C# .NET is must. This can be used for both desktop application as well as...January 11th, 2015, 03:38 PM1 replies | 147 view(s)
-
MrFujin replied to a thread Seeking advice: many to many relationship design and query in MySQL Helpso you mean it will do an update/refresh for each selection. For example, the table would be like this after selecting 0 and 5: Table pcfeats 0...January 11th, 2015, 03:20 PM40 replies | 539 view(s)
-
MrFujin replied to a thread Seeking advice: many to many relationship design and query in MySQL HelpHow is multi-level controlled? Can you have a feat that require id 20? and one or more feat? For example something like this: Table feats_g id...January 11th, 2015, 12:29 PM40 replies | 539 view(s)
