gideondsouza

public class HomeController : Controller
{
    public ActionResult Index()
    {
        return View();
    }
    public ActionResult Upload()
    {
        var file  = Request.Files["Filedata"];
        string savePath = Server.MapPath(@"~\Content\" + file.FileName);

gideondsouza

<div class="gallery-img2">
  <div class=""></div>
  <a href="somelink">
    <img src="MY TARGET FILE IS HERE" alt="" width="225" height="225" border="0" />
  </a>
</div>

gideondsouza

#!/usr/bin/perl
#updated on tryperl.com
# Created by Gideon Dsouza on 2012-12-11

use strict;
use warnings;
use WWW::Mechanize;
use HTML::TokeParser;

#create a new instance of mechanize

gideondsouza

SELECT yr
FROM movie
WHERE title='Citizen Kane'

gideondsouza

SELECT id, title FROM movie WHERE yr = 1962

gideondsouza

SELECT a.name
 FROM casting c JOIN actor a ON
  a.id = c.actorid
 WHERE 
  a.name <> 'Art Garfunkel' AND
  c.movieid 
 IN (
  SELECT m.id
     FROM casting c JOIN movie m ON
       m.id = c.movieid

gideondsouza

SELECT m.title, Count(c.actorid)
  FROM casting c JOIN movie m ON
    m.id = c.movieid
  WHERE m.yr = 1978
GROUP BY m.title
ORDER BY Count(c.actorid) DESC

gideondsouza

SELECT a.name
  FROM casting c JOIN movie m ON
    m.id = c.movieid
  JOIN actor a ON 
    a.id = c.actorid AND 
    c.ord = 1
GROUP BY a.name
Having Count(m.id) >= 30

gideondsouza

SELECT m.title, a.name
  FROM casting c JOIN movie m ON
   m.id = c.movieid AND
   c.ord = 1
 JOIN actor a ON 
   a.id = c.actorid
WHERE m.id IN (
 SELECT m.id
  FROM casting c JOIN movie m ON
    m.id = c.movieid

gideondsouza

SELECT yr,COUNT(title) FROM
  movie JOIN casting ON movie.id=movieid
         JOIN actor   ON actorid=actor.id
WHERE name='John Travolta'
GROUP BY yr  
HAVING COUNT(title)=(SELECT MAX(c) FROM
(SELECT yr,COUNT(title) AS c FROM
   movie JOIN casting ON movie.id=movieid
         JOIN actor   ON actorid=actor.id
 WHERE name='John Travolta'