#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2001
    Location
    valencia ,venezuela
    Posts
    13
    Rep Power
    0

    help with javascript connections accesdb


    If its impossible to parse from jva to vbscript how you would do it can i use connections to java and work on the database directly in java my connection code is as follows and the search is below which i include also.
    i am totally new to java

    <% Dim ConStr, oRecordset, SQL,campo,valor,ano,PUERTO
    ConStr = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;Data Source=" & Server.MapPath ("/BUQUESIMPORTACION/totalbuques.mdb") &";"
    set oRecordset = Server.CreateObject("ADODB.Recordset")

    oRecordset.ActiveConnection = Constr
    oRecordset.CursorLocation = 3 'adUseServer = 2, adUseClient = 3
    oRecordset.CursorType = 3
    sql = "SELECT * from [TOTALES] "
    orecordset.open sql%>



    code for search needed to be translated to java server pge
    xml += "<DATA>Importaciones";
    for(var i=0;i<rowLabels.length;i++)
    for(var j=0;j<colLabels.length;j++)
    {
    <%ORECORDSET.MOVEFIRST
    ORECORDSET.Filter= "RECEPTOR=rowLabels[i] AND PRODUCTO=colLabels[i]"
    If (objRecordset.BOF = True) OR (objRecordset.EOF = True) Then%>
    xml += "<VALUE>"+<%=0%>+"</>";
    <%ELSE%>
    xml += "<VALUE>"+<%=ORECORDSET("KILOS")%>+"</>";
    <%END IF%>
    }
    xml += "</>";
    return "<xml>"+xml+"</>";
    thanks for your help
    r.soler
  2. #2
  3. No Profile Picture
    Not there when you need me
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    1,430
    Rep Power
    15
    Hi!

    First of all: I don't understand why this belongs into a client-side HTML and Javascript forum.

    Next: please make your question clear. I'm not a native English speaker (reader) and simply don't understand what you want to achieve. So don't others, if I'm any judge.

    Next: what in your code is precisely done when and with which data and what does the user do for it? Is the second piece of code server-side or client-side?

    Please explain ...

    Btw: if you put your code in [ code ] tags, it will be much easier to read.

IMN logo majestic logo threadwatch logo seochat tools logo