[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: XML and LDAP: Common APIs?

• From: tpassin@h...
• To: KenNorth <KenNorth@e...>, xml-dev@l...
• 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
based
> 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

• References:
  • RE: XML and LDAP: Common APIs?
    • From: johns@s... (John F. Schlesinger)
  • Re: XML and LDAP: Common APIs?
    • From: KenNorth <KenNorth@e...>

• Prev by Date: Re: XML and LDAP: Common APIs?
• Next by Date: Seeking implementation reports for XPointer and XLink
• Previous by thread: Re: XML and LDAP: Common APIs?
• Next by thread: Re: XML and LDAP: Common APIs?
• Index(es):
  • Date
  • Thread