OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   Re: XML and LDAP: Common APIs?

[ Lists Home | Date Index | Thread Index ]
  • From: tpassin@home.com
  • To: KenNorth <KenNorth@email.msn.com>, xml-dev@lists.xml.org
  • Date: Mon, 28 Aug 2000 09:25:47 -0400

KenNorth wrote -
> > I don't think you need to know the datatype to form the query -
> Here are two SQL queries for which the filter is expressed differently
> on the type of the employee ID (empID) column. To match a numeric ID, you
> use the first query. To match a character string ID, you use the second:
> select emp_name from employee where empID = 200
> select emp_name from employee where empID = '200'
> The type was stated when the table was created.
I know you can come up with examples, but for this particular example, many
databases actually do return the same results.  SQLAnywhere, which I have
used a lot, does so.  Just change the "equals" to a "greater than", though,
and you will have made the point.

Tom Passin


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS