User Profile

Collapse

Profile Sidebar

Collapse
VipinKB
VipinKB
Last Activity: Dec 24 '09, 10:43 AM
Joined: Dec 9 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • VipinKB
    replied to DISTINCT and ORDER BY
    in ASP Classic
    Not sure, if you still require this. But, here's is the quick and simple SQL to achieve your desired results -

    Select Product_Name, Min(Product_Pri ce)
    From Table_Name
    Group By Product_Name
    Order By Product_Name

    This will give you your desired results -

    ProductA (silver) = $5
    ProductB (brown) = $10
    ProductC (green) = $5

    Hope this helps !!!

    Vipin
    See more | Go to post

      Leave a comment:

    • VipinKB
      replied to javascript onMouseOver Issue
      in Javascript
      Hello Navin,

      Do the following in your code to make it work:

      1. Give id to image tag
      Code:
      <img [B]id="imgPIC"[/B]/>

      2. Use the below modified javascript function:

      Code:
      function showImg(picName){	
	document.getElementById('PopUp').style.display='block';
	document.getElementById('imgPIC').src = "pics/" + picName + ".jpg";
}
      ...
      See more | Go to post
      Last edited by Dormilich; Dec 15 '09, 10:49 AM. Reason: Please use [code] tags when posting code

        Leave a comment:

      • VipinKB
        replied to Syntax error (missing operator) in query
        in ASP Classic
        aaron6098,

        Your problem is probably because of order Id value being blank in the querystring...

        Try printing out OrderID variable before you use it in SQL..

        Also, alternatively to nail the issue, you can hard-code the OrderId in SQL and see if it works...

        But, my guess is you are probably missing orderId value in SQL...also try printing SQL before firing it to database engine..

        Hope...
        See more | Go to post

          Leave a comment:

        No activity results to display
        Show More
        Working...