Re: query with parameters and asp

From: Ross McKay (rosko_at_zeta.NOT.THIS.BIT.org.au)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 00:18:00 GMT

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: advice on strings
    ... take them and boil them in water to clean ... you can extend its life by 50% or so. ... report to this group from some years back: ... Thomastik-Infield Swing 13 strings. ...
    (rec.music.makers.guitar.jazz)
  • Re: OT Funeral readings
    ... In article, Charlie wrote: ... To celebrate a long life, well lived, Christian service but agnostic ... Barbers Adagio for Strings as sung by the Dublin University choir (ie ...
    (uk.rec.motorcycles)
  • 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: anudder poll
    ... (and I'm sure I could probably pull some strings ... And, in other ways, it also feels a bit liberating to break that life ... Bruce still has the life or death-like circle over me whenever he's ...
    (rec.music.artists.springsteen)
  • Re: Music to celebrate 5 years of our Accomplshed Mission
    ... My vote is for Barber's "Adagio for Strings," to commemorate the ... mentally scarred for life, and the future of the nation recklessly ...
    (rec.music.classical.recordings)