Please help

Results 1 to 2 of 2

Thread: Please help

  1. #1
    stelios Guest

    Default Please help

    Please this is frustrating....I try to get the max number of database..but it wont store it in a variable but it will print it...Code follows..Please someone help me..where am I doing wrong??<BR><BR>str3SQL= "SELECT MAX(Year) FROM Datetab" <BR> str3SQL,oConn ,adForwardOnly <BR> &#039;maxyear = objRS3(O)<BR> &#039;Response.Write maxyear <BR> Response.Write objRS3(0)<BR><BR><BR>Moreover I want to do this..but very hard..dont know the SQL for it..dont know if even exists..<BR>Think of a column in a database with duplicated values but not duplicated tuples eg..100 tuples with mutiple values of 1, 2 ,3 etc..want to get an array to plot a graph..with unigue values of the numbers existing in the [1,2,3...]<BR><BR>Is there an SQL statement to do that ??<BR>Please help me ..Im really stuck!! Thank you<BR>

  2. #2
    Mark Guest

    Default RE: Please help

    your recordset is not the same in both cases ie(O) &#062;(0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts