The only way to know wehter or not you could use AS for column aliases would be to refer to the SELECT statement documentation of your underlying database server. The JDBC driver has got nothing to do with it.
ATTA ----- Original Message ----- From: "Gilbert, Antoine" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Monday, February 10, 2003 11:02 AM Subject: RE: [OT] aliases [SQL SELECT column aliases] > I wanna detect if i must use the "AS" or not to define my alias > > for example, using "AS" with jdbc-idb crash.. > for example, not using "AS" with jdbc-odbc crash > > so sometime i have to use "AS" keyword in SQL and sometime not.. > > -----Message d'origine----- > De : atta ur rehman [mailto:[EMAIL PROTECTED]] > Envoyé : 10 février, 2003 14:05 > À : Struts Users Mailing List > Objet : Re: [OT] aliases [SQL SELECT column aliases] > > > hello Antoine, > > what it is that you want to 'detect'? > > Regards, > > ATTA > > > ----- Original Message ----- > From: "Gilbert, Antoine" <[EMAIL PROTECTED]> > To: "Struts Users Mailing List" <[EMAIL PROTECTED]> > Sent: Monday, February 10, 2003 10:39 AM > Subject: aliases > > > Hiya > > I have a little database question about alias... > > Most of bd(drivers) support the use of "AS", but generally you can ommit it > and it work. But some bd must have the "AS" specified and some dont accept > the "AS" (only space). > > How i can detect that, using java.sql.* > > p.s.: sorry for my bad english > > regards > > Antoine > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
