Comments by AndyInUK - CodeProject

AndyInUK 8-Jan-14 11:20am View

I think there is a small problem here. by adding AND t2.UserID <> '@UserID', it will remove that particular UserID from the list but it will not removed all the articles that particular user viewed.

It's suggesting the same articles again and again and just remove the article it's coming from.

AndyInUK 7-Jan-14 9:34am View

Thanks for your reply. Now am even more confident to go with 1st solution. What do you think works better REST or SOAP? I am thinking to go with REST as most of the people suggesting it provides better performance. Not that I have much experience with REST or SOAP.

I will have a look at windows identity foundation. This should be good solution for .net based project but we do have php based project too. So for that I might need to look into something different.

Thanks

AndyInUK 2-Jan-14 6:14am View

I guess just adding this line should remove the current user -
AND t2.UserID <> '@UserID'

AndyInUK 2-Jan-14 5:40am View

Hello Andrius,

Thanks for your reply. I am just trying to understand your solution. So basically what you did here is -
1. Searched the users who viewed article 102
2. Then scanned all the users viewed article and on the basis of maximum views the best 3 result is displayed and the same article id should not be displayed.

If this is how this query works then great.. i wasn't expecting such a simple solution to the problem. And also how can I remove current user ArticleIDs from the result?

Thanks

AndyInUK 31-Dec-13 5:12am View

Can you explain a little bit more about your db table. Which field do you want to compare the random number with?

AndyInUK 30-Dec-13 7:13am View

So your question is not how to generate random number but it's how to compare random number with database. So all you have to do is assign that random number to a variable and connect to database and run a query to compare the two. Best is if you show us what have you done so far and where exactly are you stuck.

AndyInUK 6-Sep-13 12:32pm View

As per your suggestion, i tried below query but am getting error - 'Every derived table must have its own alias' and with sum(*) am getting some other errors in the query.

SELECT member.type, COUNT(*) FROM (
SELECT
member.type,
v.id,
COUNT(v.path)AS `count`
FROM
views v
INNER JOIN member ON v.id = member.uid
WHERE
v.path = "/asd/des/gef/index.php"
GROUP BY
member.type,
v.id
) group by member.type

I have also tried WITH ROLLUP, but that just sums the count and not the type.

AndyInUK 15-May-13 12:09pm View

Any clue guys??

AndyInUK 10-Apr-13 10:16am View

Yap, that works, thanks. :)

AndyInUK 10-Apr-13 9:51am View

I have tried this, but the problem is it list the users with interest 'abc' or 'def' but there are many users with interest as both 'abc' AND 'def'. So I want to list those users too. I am expecting the result for interest should be
Interest
abc,def

AndyInUK 3-Apr-13 4:50am View

What are you on about mate?? Even you commented http://www.ie6death.com/[^]. as a Solution?? And how on earth you are replying to a thread which is 2 years old??

AndyInUK 11-Mar-13 11:23am View

I have updated the question. Hope it makes sense now.

AndyInUK 11-Mar-13 11:22am View

I think I didn't explained the question well - I want to display result like -

article 1
test
testing

article 2
something else

With the above query, I end up repeating title for each notes under same article

AndyInUK 4-Dec-12 7:17am View

lol not for you. It's for OP. Replied at wrong post by mistake.

AndyInUK 4-Dec-12 7:16am View

Deleted

lol not for you. It's for OP. Replied at wrong post by mistake.

AndyInUK 4-Dec-12 5:08am View

Can you elaborate? No one can help you if you ask such a general question. Tell us what problem are you facing and we will be very happy to help you.

AndyInUK 9-Nov-12 10:57am View

hmmm the solution is good for splitting the csv file but the problem is I need header(column names) to be added in each csv split as on the receiving end, it will concatenate the data according to the header.

May be it would be a better option to get the data from mysql, and split it into 2MB size and insert it to csv and repeat till the complete data size.

What do you think?

Thanks

AndyInUK 9-Nov-12 6:10am View

Thanks for the excellent solution. I will try this now. :)

AndyInUK 9-Nov-12 6:10am View

Deleted

Thanks for the excellent solution. I will try this now. :)

AndyInUK 8-Nov-12 10:54am View

Thanks for your reply.

I don't think, first option is any good in this case as am uploading to external system, and i don't think, they will accept compressed file.

The second suggestion seems appropriate in this situation but am wondering how would you split an array into smaller pieces no larger than 2MB? I know there is a function called array_chunk, but I need to split it by file size and not by the number of elements? Data is basically an array(queried from database)...

Thank you

AndyInUK 10-Oct-12 10:16am View

well it's php mainly and there is no error. I am asking how to print the object array?

AndyInUK 30-Aug-12 4:51am View

Well, that's what I want to be sure about. If am on the right path.. i.e. comet

AndyInUK 23-Aug-12 11:22am View

Well, I understand what you mean but bit of explanation from you won't do any harm, I guess.

AndyInUK 25-Jul-12 12:45pm View

and ofcourse, i am definitely passing the $id variable in a query string

AndyInUK 20-Jul-12 11:58am View

No php/mysql/html guru here??

AndyInUK 25-Oct-11 12:35pm View

Well ask my manager. If i get a permission not to support ie6 - i will give a damn. Already wasted so many hours trying to hack this ie6 problem. It works absolutely fine in other browsers.

AndyInUK 21-Oct-11 9:41am View

Thanks Dylan, New to questions and answers section :)

AndyInUK 21-Oct-11 9:40am View

Deleted

Thanks Dylan, New to questions and answers section :)

Comments by AndyInUK (Top 28 by date)