Re: query with parameters and asp

From: Marcelo Marchesoni (mmarches_at_adinet.com.uy)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 19:57:06 -0300

thanks for your reply

.CreateParameter("fechainicial",adDate)

when the server process this sentence sends an error

"Ross McKay" <rosko@zeta.NOT.THIS.BIT.org.au> escribió en el mensaje
news:kb0v501c2nhoaqcpuobmj9ip83fjmrahht@4ax.com...
> On Mon, 22 Mar 2004 19:15:36 -0300, "Marcelo Marchesoni" wrote:
>
> >I try to get the next query with parameters.
> >I can't pass the parameters values.
>
> G'day Marcelo,
>
> Why can't you pass the values? What error do you get?
>
> >' .Parameters("fechainicial").Value=Request.Form("fechainicial")
> >' .Parameters("fechafinal").Value=Request.QueryString("fechafinal")
>
> What have you done to ensure that the format of these values from ASP is
> acceptable to convert into a date?
>
> I strongly recommend you ensure that these strings are first converted
> into either a Date or a Null (not an empty string!), before passing them
> to the parameter object.
>
> cheers,
> Ross.
> --
> "There is more to life than simply increasing its speed." - Mahatma Gandhi

Relevant Pages

  • Re: execute append query
    ... copied sql from query into strings in vba in form, ... Dim qdfAppend as querydef ... > yes i did declare the parameter in the query and yes there was a suitable ...
    (microsoft.public.access.modulesdaovba)
  • Re: execute append query
    ... It may be that adding dbFailOnError to your original Execute statement would ... > copied sql from query into strings in vba in form, ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.modulesdaovba)
  • Access 2003 treats embedded functions in nested queries as a reference rather than a value - Acc
    ... Microsoft Access 2003 allows one to embed "expressions" in the query ... I also make extensive use of queries that are built from queries, ... Typically the IIf and Switch functions I use return strings. ... Has this behavior changed in Microsoft Access 2007? ...
    (microsoft.public.access.queries)
  • Re: Invalid URL form or fully-qualified absolute URL was used. Use relative URLs
    ... doesn't work with query strings... ... >Greater love has no one than this, that he lay down his life for his friends ...
    (microsoft.public.inetserver.asp.general)
  • Re: Group By, Count, and Like
    ... > Status field data type is text, and records contain values: ... > Is there a way of having a 'group by' query grouping these sort of strings ... > of records in just the three categories Used; Expired; and Void? ... > experiments with 'Like' in the query criteria haven't been successful.... ...
    (microsoft.public.access.queries)