Re: query with parameters and asp

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

Date: Thu, 25 Mar 2004 00:12:33 GMT

On Wed, 24 Mar 2004 19:57:06 -0300, "Marcelo Marchesoni" wrote:

>.CreateParameter("fechainicial",adDate)
>
>when the server process this sentence sends an error

You neglected to state what the error was. However, I'll guess that it
is "Variable is undefined", because of adDate not being defined.

Have you made a reference to the ADO type library in your global.asa
file? Or otherwise, included the ADO constants definitions anywhere? If
not, then adDate will not be defined, and you will get the error above.

Simplest and best is to create a global.asa file in the root of your
website. A minimal one, here referencing ADO 2.6, is below:

----- cut here -----
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
<!--METADATA TYPE="TypeLib" NAME="Microsoft ActiveX Data Objects 2.6
Library" UUID="{00000206-0000-0010-8000-00AA006D2EA4}" VERSION="2.6"-->
</SCRIPT>
---- end script ----

cheers,
Ross. 

-- 
"There is more to life than simply increasing its speed." - Mahatma Gandhi