December 24th, 2001, 08:55 AM
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] "
code for search needed to be translated to java server pge
xml += "<DATA>Importaciones";
ORECORDSET.Filter= "RECEPTOR=rowLabels[i] AND PRODUCTO=colLabels[i]"
If (objRecordset.BOF = True) OR (objRecordset.EOF = True) Then%>
xml += "<VALUE>"+<%=0%>+"</>";
xml += "<VALUE>"+<%=ORECORDSET("KILOS")%>+"</>";
xml += "</>";
thanks for your help
December 24th, 2001, 01:44 PM
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.