Re: Help with command object parameters query?

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 03/27/05 

Date: Sun, 27 Mar 2005 09:57:18 -0500

What-a-Tool wrote:
>> No. Delimiters are not needed when using parameters. Here is a repro
<snip>
> AhHa - I see my error - Delimeters are needed, but in the array
> itself.

Not really. I used delimiters in the array creation statement in my demo
because I was hard-coding the literal values. In a real application, I would
use the vbscript conversion functions to make sure my arguments were of the
proper type:

on error resume next
dim startdate
startdate=cdate(Request.form("StartDate"))
if err<> 0 then
    response.write "Invalid Start Date"
    response.end
end if
...
arParms = array( ..., startdate, ...)

Bob Barrows 

-- 
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"