View Single Post
  #2 (permalink)  
Old November 15th, 2004, 03:06 AM
happygv happygv is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Code:
    var mySQL = "SELECT Usuarios.Expediente, Usuarios.Nombre, Perfiles.DescPerf, Curricula.URL" + " FROM (Curricula INNER JOIN (Usuarios INNER JOIN Inscritos ON Usuarios.Expediente = Inscritos.Expediente) ON Curricula.Clave = Inscritos.[Puesto inscrito]) INNER JOIN Perfiles ON Usuarios.Perfil = Perfiles.Clave_perf" + " WHERE (((Inscritos.Expediente))=" + expediente + ")";
    adoRecordSet = adoConnection.Execute(mySQL);

'Check that here.

    If adoRecordSet.Eof Then
        Response.write "Sorry you are not subscribed"
    ELSE

// hace loop en la base y al terminar, trae los datos a la página WEB

        while( adoRecordSet.Eof == false)
            ...
            ...
        WEND
    END IF
    Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection
Reply With Quote