Re: ADO corrupts date time values in where clause

Tech-Archive recommends: Fix windows errors by optimizing your registry

sathya wrote:
Parameters for the set portion. However it's the where clause that
gets messed up. And since it's ADO that's generating the where clause
with all the columns in the table, we are not really sure as to what's
going on

Well, I could keep asking questions to try and figure out what you are
doing, or you could show us some code to reproduce the problem. Which do you
think would be quicker ;-)
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Can a SELECT query join across three tables?
    ... Which is not the problem he was reporting. ... Or, as he did, do it all in the where clause. ... reported back and since he could not post his actual SQL, ... This email account is my spam trap so I ...
    (microsoft.public.access.queries)
  • Re: Access View
    ... Roland Hall wrote: ... > Can't use CREATE PROCEDURE in Access for the same reason unless you ... but running it via ADO in a VBA module is exactly the same as running ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Enter parameter value Query1. ...
    ... window which identifies a parameter named Query1.fldname, ... fldname is the name of the output table. ... of tables mentioned in the From clause, or from objects in forms that are ... This email account is my spam trap so I ...
    (microsoft.public.access.queries)
  • Re: How to create a checkbox datatype column in a table in VB .net code
    ... Definitely not with ADO, ... but this is a classic ADO newsgroup. ... ADO.Net bears very little resemblance to classic ADO so, ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: ISAM error connecting to MDB and using a linked Sharepoint List
    ... 2007 I can read and write to this Sharepoint List, but when I use ADO ... to connect to the MDB with the OLE Jet provider and read the ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)