Fw: MDB Access

[marco scotoni]

- Original Message -
From: "marco scotoni" <[EMAIL PROTECTED]>
To: "Upayavira" <[EMAIL PROTECTED]>
Sent: Thursday, December 19, 2002 2:05 PM
Subject: Re: MDB Access


> OK,
>
> i'm able to connect with this string in local way:
> jdbc:odbc:Driver={Microsoft Access Driver
> (*.mdb)};DBQ=c:\test\test.mdb;
>
> But when the file is located on intranet like \\test\test\test.mdb i'm not
> able to send the username and password of net to access to file...
>
> not able to connect in net way:
>
> jdbc:odbc:Driver={Microsoft Access Driver
> (*.mdb)};DBQ=\\test\test\test.mdb;
>
> thx
>
> Marco
>
> - Original Message -
> From: "Upayavira" <[EMAIL PROTECTED]>
> To: "marco scotoni" <[EMAIL PROTECTED]>
> Sent: Thursday, December 19, 2002 1:59 PM
> Subject: Re: MDB Access
>
>
> > > There's anyone who could send me string connection to a MDB File
please?
> >
> > I can't give you an exact string to do this - I haven't done it myself.
> >
> > However, to connect to databases from Cocoon, you use JDBC. To connect
to
> Access
> > databases, you often use ODBC. Therefore, you could probably get away
with
> using the
> > JDBC-ODBC bridge, which I believe comes with some versions of the JDK.
> >
> > Search on the net for JDBC-ODBC bridge, or maybe someone else on the
list
> can
> > explain how to use it.
> >
> > Regards, Upayavira
>


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

MDB Access

[marco scotoni]

There's anyone who could send me string connection to a MDB File please?

thx 
__
Dark Schneider
ICQ#: 13815557
Current ICQ status:   
+  More ways to contact me 
__

-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Could be a Bug? Re: XSP+logic 2nd

[marco scotoni]

Hi, i notice that i get an error if i 
put  between tags ,
 
it seems a strange thing...there's a particular tag 
or method to process a result after a query?
 
or that's a bug?
 
 
Error:
 
org.apache.cocoon.ProcessingException: Language Exception: 
org.apache.cocoon.components.language.LanguageException: Error compiling 
query_prod_xsp:Line 962, column 49:  illegal start of 
expressionLine 0, column 0: 1 error
 
Code:
 




xmlns:xsp="http://apache.org/xsp"
xmlns:esql="http://apache.org/cocoon/SQL/v2"
xmlns:xsp-request="http://apache.org/xsp/request/2.0" 

>

String pippo="eheh";
String pippo2="";
String pippo3="";
static String replace(String str, String pattern, 
String replace) {
int s = 0;
int e = 0;
StringBuffer result = new StringBuffer(); 

while ((e = str.indexOf(pattern, s)) >= 0) { 

result.append(str.substring(s, e));
result.append(replace); 
s = e+pattern.length();
}
result.append(str.substring(s));
return result.toString();
} 
 


 
 

trafomec
 

select distinct nome_prod, 
data_prod from tabella_prodotto where 
id_prod=request.getParameter("num")








 
 



select distinct 
id_ufoto,link,desc_foto from tabella_foto where 
id_foto=request.getParameter("num")













select distinct tabella_at.nome_at 
as nome_at, tabella_cf.nome_cf as nome_cf from 
tabella_at,tabella_cf,tabella_famiglia,tabella_prodotto where 
tabella_famiglia.id_at=tabella_at.id_at and 
tabella_famiglia.id_cf=tabella_cf.id_cf and tabella_famiglia.id_fa=4 and 
tabella_prodotto.id_fa=4




 





 


select distinct specifiche from 
tabella_prodotto where id_prod=4



 

Re: XSP+logic

[marco scotoni]

Thx the problem is that i have to replace a substring from the result of
query...

but  there arent methods or tag to do it...




- Original Message -
From: "Ilya A. Kriveshko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 07, 2002 4:45 PM
Subject: Re: XSP+logic


> Search the mailing list archives for SQL injection - your page is
> vulnerable.
> Use  name="num"/> in your query.
>
> I don't see a closing '>' on the  tag in the beginning of the
> file. I would have expected it to give you a different error, though.
>
> Your problem is coming from the last  in the file:
>
> 
>   String Prova;
> 
>
>
> You either meant to declare a String variable Prova, for which you
> should do with  tags, or
> you meant to output "String Prova;", for which you should have used
quotes.
>
> So, it's either:
> 
>   String Prova;
> 
>
> or
>
> 
>   "String Prova;"
> 
>
> Also, it would be faster if you opened the database connection once, and
> then placed all your queries inside of it:
>
> 
> http://apache.org/xsp";
>   xmlns:esql="http://apache.org/cocoon/SQL/v2";
>   xmlns:xsp-request="http://apache.org/xsp/request/2.0";>
>
>   
> static String replace(String str, String pattern, String replace) {
> int s = 0;
> int e = 0;
> StringBuffer result = new StringBuffer();
> while ((e = str.indexOf(pattern, s)) >= 0) {
> result.append(str.substring(s, e));
> result.append(replace);
> s = e+pattern.length();
> }
> result.append(str.substring(s));
> return result.toString();
> }
>
>   
>
>   
> 
>   trafomec
>   
> 
>   select distinct nome_prod, data_prod from tabella_prodotto
> where id_prod=
>
>
request.getParameter("num")
> 
> 
>   
> 
> 
>   
> 
>   
>
>   
>   
> 
>   
> select distinct id_ufoto,link,desc_foto from tabella_foto
where
> id_foto=
>
>
request.getParameter("num")
>   
>   
> 
>   
> 
> 
>   
> 
>   
> 
>   
>   
> 
>   
> SELECT DISTINCT tabella_at.nome_at as nome_at,
> tabella_cf.nome_cf as nome_cf
>   FROM tabella_at, tabella_cf, tabella_famiglia,
> tabella_prodotto
>   WHERE tabella_famiglia.id_at=tabella_at.id_at AND
> tabella_famiglia.id_cf=tabella_cf.id_cf AND
> tabella_famiglia.id_fa=4 AND
> tabella_prodotto.id_fa=4
>   
>   
> 
>   
> 
> 
>   
> 
>   
> 
>   
>
>   
> 
>   select distinct specifiche from tabella_prodotto where id_prod=4
> 
> 
>   
> 
>   "String Prova;"
> 
>   
> 
>   
> 
>   
> 
>
> marco scotoni wrote:
>
> >Hi, i have an error on this .xsp page but i can't solvehelp plz
> >
> >Error:
> >org.apache.cocoon.ProcessingException: Language Exception:
> >org.apache.cocoon.components.language.LanguageException: Error compiling
> >query_prod_xsp:
> >Line 1113, column 18:  ')' expected
> >Line 1114, column 11:  illegal start of expression
> >Line 1113, column 11:  variable String not found in class
> >org.apache.cocoon.www.mount.html_pdf.query_prod_xsp
> >Line 0, column 0:
> >3 errors
> >
> >
> >
> >Page .xsp
> >
> >
> > >xmlns:xsp="http://apache.org/xsp";
> >xmlns:esql="http://apache.org/cocoon/SQL/v2";
> >xmlns:xsp-request="http://apache.org/xsp/request/2.0";
> >
> >
> >
> >static String replace(String str, String pattern, String replace) {
> >int s = 0;
> >int e = 0;
> >StringBuffer result = new StringBuffer();
> >while ((e = str.indexOf(pattern, s)) >= 0) {
> >result.append(str.substring(s, e));
> >result.append(replace);
> >s = e+pattern.length();
> >}
> >result.append(str.substring(s));
> >return result.toString();
> >}
> >
> >
> >
> >
> >
> >

XSP+logic

[marco scotoni]

Hi, i have an error on this .xsp page but i can't solvehelp plz

Error:
org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException: Error compiling
query_prod_xsp:
Line 1113, column 18:  ')' expected
Line 1114, column 11:  illegal start of expression
Line 1113, column 11:  variable String not found in class
org.apache.cocoon.www.mount.html_pdf.query_prod_xsp
Line 0, column 0:
3 errors



Page .xsp


http://apache.org/xsp";
xmlns:esql="http://apache.org/cocoon/SQL/v2";
xmlns:xsp-request="http://apache.org/xsp/request/2.0";
>

static String replace(String str, String pattern, String replace) {
int s = 0;
int e = 0;
StringBuffer result = new StringBuffer();
while ((e = str.indexOf(pattern, s)) >= 0) {
result.append(str.substring(s, e));
result.append(replace);
s = e+pattern.length();
}
result.append(str.substring(s));
return result.toString();
}






trafomec

select distinct nome_prod, data_prod from tabella_prodotto where
id_prod=request.getParameter("num")













trafomec

select distinct id_ufoto,link,desc_foto from tabella_foto where
id_foto=request.getParameter("num")














trafomec

select distinct tabella_at.nome_at as nome_at,
tabella_cf.nome_cf as nome_cf from
tabella_at,tabella_cf,tabella_famiglia,tabella_prodotto where
tabella_famiglia.id_at=tabella_at.id_at and
tabella_famiglia.id_cf=tabella_cf.id_cf and tabella_famiglia.id_fa=4 and
tabella_prodotto.id_fa=4












trafomec

select distinct specifiche from tabella_prodotto where
id_prod=4




String Prova;









__
Dark Schneider
ICQ#: 13815557
Current ICQ status:
+  More ways to contact me
__


-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

URL / Relative path in External graphic

[marco scotoni]

Hi,

I know that there's a common problem on Cocoon when i try to generate a PDF
within a external graphic object:

it'snt possible to use a relative path on 

i can use two tricks

1) use absolute src=file://c:/...help.jpg
2) use URL src=http://localhost:8080/bla bla bla/help.jpg

the problem has been solved?


thx

Marco Scotoni
__
Dark Schneider
ICQ#: 13815557
Current ICQ status:
+  More ways to contact me
__


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Re: Where is the Jar with Jdbc-Odbc Class!?!?!?

[marco scotoni]

It's very big  22 mb
can i re-jar only class i need ? what do u think?

I think that loading a so big jar my memory fill out immediatly!

- Original Message -
From: "Ludovic de Beaurepaire" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 10:37 AM
Subject: Re: Where is the Jar with Jdbc-Odbc Class!?!?!?


> It is in the JDK (rt.jar)
>
> Ludovic
>
> ----- Original Message -
> From: "marco scotoni" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, November 05, 2002 10:23 AM
> Subject: Where is the Jar with Jdbc-Odbc Class!?!?!?
>
>
> >
> > I'm lookin for Jar where Jdbc-Odbc classes are...help plz i cant
find
> >
> > -
> > Please check that your question  has not already been answered in the
> > FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
> >
> > To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> > For additional commands, e-mail:   <[EMAIL PROTECTED]>
> >
> >
> >
>
>
> -
> Please check that your question  has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>


-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Where is the Jar with Jdbc-Odbc Class!?!?!?

[marco scotoni]

I'm lookin for Jar where Jdbc-Odbc classes are...help plz i cant find

-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

cocoon & Batik

[marco scotoni]

I try to update Batik up version 1.5b4 but i've got 
some problems...
 
on cocoon 2.0.3 i have batik-all-1.5b2.jar 
file
and on bin of last beta 4 a lot of 
file...
 
anyone could help me to know how create a 
batik-all-XXX.jar from all little files?
 
or if there's a different way to do thi 
update?
 
thx
 
__Dark 
SchneiderICQ#: 13815557

  
  
Current ICQ status:  
 
  +  More ways to contact me 
__


online?icq=13815557&img=21
Description: Binary data