Re: tweak of A2002 Enterprise Dev Handbook fails?

pietlinden@xxxxxxxxxxx wrote:
Thanks Bob,

I removed the Parameters declaration and just created them in the
query itself (I thought ADO couldn't access the parameters collection
of what I thought was a DAO object... shows what I know!). but when I
took that out, it worked a champ!

Yes, when Jet encounters a word in a query that does not correxpond to any
object in scope of the query, it assumes it is a parameter marker.
--
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: Expression Builder
    ... Open the query in Design View. ... This is what the SQL statement shows: ... This email account is my spam trap so ...
    (microsoft.public.access.queries)
  • Re: Expression Builder
    ... Open the query in Design View. ... This is what the SQL statement shows: ... This email account is my spam trap so ...
    (microsoft.public.access.queries)
  • Re: Expression Builder
    ... Open the query in Design View. ... Could you show us the sql statement for your query? ... This email account is my spam trap so ...
    (microsoft.public.access.queries)
  • Re: ASP and Access SQL Problem
    ... > following in an asp page: ... > Dim objRS ... Your query does not return records - why open a recordset??? ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: Q
    ... > sorry for typo, only those whitch are not 1 ... The above query should work if you are using SQL Server, ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)