|
|
|
|
|
| Job Offers |
|
|
|
<%
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open ("DRIVER={MySQL};SERVER=lldf444.servidoresdns.net; PORT=3306;DATABASE=qgm334;UID=qgm334;PWD=AminsA00")
sSQL_contador="SELECT COUNT(*) AS CUENTA FROM PA_OfertasTrabajo WHERE FechaLimiteOferta >= '" & Year(Date()) & "-" & Month(Date()) & "-" & Day(Date()) & "'"
sSQL="SELECT Puesto_en, DescripcionTrabajo_en, FechaLimiteOferta FROM PA_OfertasTrabajo WHERE FechaLimiteOferta >= '" & Year(Date()) & "-" & Month(Date()) & "-" & Day(Date()) & "' ORDER BY FechaLimiteOferta DESC"
Set RS_cont=Conn.Execute(sSQL_contador)
If CInt(RS_cont("CUENTA")) = 0 Then
%>
| There are no vacancies at the moment. |
<%
RS_cont.Close
Else
Set RS=Conn.Execute(sSQL)
Do While Not RS.Eof
%>
| · Vacancies: |
<%=RS("Puesto")%> |
| · Job description: |
<%=RS("DescripcionTrabajo")%> |
|
|
|
<%
RS.MoveNext
Loop
RS.Close
End If
Conn.Close
%>
|
|
| Application |
|
|
|
You can send us your job application to the email address empleo@aminsa.com . Do not forget to specify your area of expertise according to your training, and to enclose your contact information.
It is highly recommended to attach an up to date photograph and to use standard formats.
|
|
|
|
|
C. Guardia Civil 30, Entresuelo D-1, 46020 Valencia - Tlf. +34 963 624 708 - aminsa@aminsa.com
Copyright © Agrupación Mediterránea de Ingeniería, S. A.
Terms of Use - Privacy |
|
|
