SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Evangelist cms9651's Avatar
    Join Date
    Mar 2010
    Posts
    407
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Import web page with ASP in DB MySQL

    Hi all, I need your help.

    I need import periodically in the db mysql from ASP content and the information published in this web page:

    http://www.eurometis.it/jobalert/risultati.metis

    Can someone help me?
    Thanks in advance.

  2. #2
    SitePoint Wizard siteguru's Avatar
    Join Date
    Oct 2002
    Location
    Scotland
    Posts
    3,629
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    I'm not sure I understand.

    You want to get content from a MySQL database and display it using ASP?

    You want to use ASP to put data into a MySQL database?

    Something else?

    Please clarify your question.
    Ian Anderson
    www.siteguru.co.uk

  3. #3
    SitePoint Evangelist cms9651's Avatar
    Join Date
    Mar 2010
    Posts
    407
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I need use ASP to put data into a MySQL database.

    I need import into a MySQL database the information published in this web page:

    http://www.eurometis.it/jobalert/risultati.metis

    thanks

  4. #4
    SitePoint Evangelist cms9651's Avatar
    Join Date
    Mar 2010
    Posts
    407
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I try this, but not working:

    Form.asp
    Code:
    <%
    If Request.Form("stampa")="stampa" Then
        Response.Write ("Il valore di field1 : " & Request.Form("ja.IdRegione"))
    Else
    %>
    
    <FORM METHOD="POST">
    <INPUT type="text" NAME="ja.IdRegione" VALUE="12" />
    <INPUT TYPE="submit" name="stampa" value="stampa" />
    </FORM>
    
    <%
    End If
    %>

    test.asp:
    Code:
    <%
    
    Set objHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP.3.0")
    objHTTP.open "POST", "http://www.eurometis.it/jobalert/risultati.metis", False 
    
    objHTTP.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
    
    objHTTP.send "ja.IdRegione=12&stampa=stampa"
    
    if objHTTP.Status = 200 Then
        Response.write (objHTTP.responseText )
    Else
        Response.Write ("Si  verificato un errore. Status code: " & objHTTP.status)
    End If
    
    Set objHTTP = Nothing
    
    %>


Bookmarks

Posting Permissions

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