Jump to content

jkusmanto

Members
 View Profile  See their activity

  • Posts

    4

  • Joined

  • Last visited

jkusmanto's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. jkusmanto
    You are right, pulpfiction.But I want the opposite of this. Not like the output you mentioned, but:08/31/200607/30/2006Can you help me please?Thanks
  2. jkusmanto
    Hi all,I use SQL Server.Here is my SQL (temporary):SELECT TOP 2 *FROM ( SELECT TOP 5 *FROM table1ORDER BY Date1 DESC) xORDER BY Date1 DESCWhat I want is:I select the first 5 rows (descending).From this 5 rows, I just want to get the last 2. How to get them?ex. --> orginal data:02/05/200603/14/200607/30/200608/31/200609/02/200609/17/200611/24/2006The result has to be like this:08/31/200607/30/2006Can anybody help?Thanks,
  3. jkusmanto
    Thanks guys for youe replay.I have changed it to <%=request.QueryString("param") %>But it still didn't work. The result is the same.For the select-case problem, how to solve it?Thanks.Jkusmanto
  4. jkusmanto
    Hi all,As a beginner I would like to ask a question.I have made 2 pages: callit.html and callpara.asp.Here is the code :callit.html :---------------------------------------<html><head><title>Caller</title></head><body><a href="callpara.asp?param=nl">Nederlands</a><br /><a href="callpara.asp?param=fr">Français</a><br /><a href="callpara.asp?param=de">Duits</a><br /><a href="callpara.asp?param=en">English</a></body></html>callpara.asp :---------------------------------------<html><head><title>Call with parameter</title></head><body><table> <tr><td>The parameter is: <% request.QueryString("param") %></td></tr> <tr><td> <% select case request.QueryString("param") case "nl" %>Ik spreek Nederlands <% case "fr" %>Je parle Français <% case "de" %>Ich spreche Deutsch <% case "en" %>I speak English <% end select %> </td></tr></table></body></html>The result is :---------------------------------------The parameter is: Ik spreek Nederlands Je parle Français Ich spreche Deutsch I speak English-------I call callpara.asp from callit.html.If I click on one of the languages, the language will be shown on screen.Example :If I click on Duits, the result should be like this :The parameter is: deIch spreche DeutschIf I click on English, the result should be like this :The parameter is: enI spreak EnglishBut the result is not what I want.Can anybody help me please?Regards,JKusmanto
×
×
  • Create New...