[thelist] Command text was not set for the command object.
Paul Backhouse
paul.backhouse at 2cs.com
Fri Nov 30 08:58:19 CST 2001
Dave - Darren,
its really bizarre - somehow managed to get the error to:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another
tried everything - im finally going to create a new search page separate
just for the strength value = 5 bit - see if that helps it out.
cheers
paul
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of darren
Sent: 30 November 2001 14:29
To: Paul Backhouse
Subject: Re: [thelist] Command text was not set for the command object.
On 30 November 2001 at 14:18:32, Paul Backhouse <paul.backhouse at 2cs.com>
wrote:
<snip
PB> Set objRS = objConn.Execute(strQuery)
try:
set objRS = objConn.Execute(strQuery, , adCmdText)
you can put a variable as the second parameter to get the number of
records affected by the query...if you're doing an update or delete
for example.
hth,
darren
---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !
More information about the thelist
mailing list