how about supportsANSI92IntermediateSQL(), supportsANSI92FullSQL or other support methods?
I'm hoping that aliases conventions are speced out in ANSI SQL standards. ATTA ----- Original Message ----- From: "Gilbert, Antoine" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Monday, February 10, 2003 11:35 AM Subject: RE: [OT] aliases [SQL SELECT column aliases] > Ya, finally it seem to be the only solution... > > thx for all comments > > -----Message d'origine----- > De : Thomas CORNET [mailto:[EMAIL PROTECTED]] > Envoyé : 10 février, 2003 14:33 > À : Struts Users Mailing List > Objet : RE: [OT] aliases [SQL SELECT column aliases] > > > > > Well, if this can not be detectable, you should make a test at the > start of your application. Try to make a test statment with some 'AS' > inside, and catch the SQLException. If it is catched, make a flag to true, > otherwise make the flag to false. Thus, inside your application, accessing > this flag, you'll be able to know how to build your queries. I know it may > not be 'good' programming, but if it is a solution which works... > > Thomas > > At 20:15 10/02/2003, you wrote: > >well some bd must have the "AS" to work properly... > > > >I would like to dynamicly detect it.. > > > >Event with DatabaseMetadata its not possible ? > > > >-----Message d'origine----- > >De : atta ur rehman [mailto:[EMAIL PROTECTED]] > >Envoyé : 10 février, 2003 14:18 > >À : Struts Users Mailing List > >Objet : Re: [OT] aliases [SQL SELECT column aliases] > > > > > >A safer bet tough, IMHO, would be not to use 'AS' at all. As most of > >database servers would support space delimited column aliases. > > > >ATTA > > > >----- Original Message ----- > >From: "Durham David Cntr 805CSS/SCBE" <[EMAIL PROTECTED]> > >To: "Struts Users Mailing List" <[EMAIL PROTECTED]> > >Sent: Monday, February 10, 2003 11:09 AM > >Subject: RE: [OT] aliases [SQL SELECT column aliases] > > > > > > > It seems strange that a database server would not support AS. Be sure > >that you are not trying to use any reserved words. The documentation for > >your database server should tell you what words are reserved. > > > > > > -Dave > > > > > > > -----Original Message----- > > > > From: atta ur rehman [mailto:[EMAIL PROTECTED]] > > > > Sent: Monday, February 10, 2003 1:12 PM > > > > To: Struts Users Mailing List > > > > Subject: Re: [OT] aliases [SQL SELECT column aliases] > > > > > > > > > > > > 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] > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > 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] > > > --------------------------------------------------------------------- > 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]