[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