[thelist] Command text was not set for the command object.

[Paul Backhouse]

Optimizer - now i always use a config file for that stuff, didn't put it in
because i assumed people would realise the connection done ealier.

cheers

paul

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of The Optimizer
Sent: 30 November 2001 14:46
To: thelist at lists.evolt.org
Subject: RE: [thelist] Command text was not set for the command object.


Paul

[..]

I may have missed something, but you don't appear to have set a value for
strConn. This would be necessary to specify which database to connect to.

HTH

Chris Marsh

> -----------------------------------------------------------
> The error im getting is:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e0c'
>
> Command text was not set for the command object.
>
> /work/knightsbridge/registered/Results.asp, line 82
> --------------------------------------------------------
> The code im using is:
> -----------------------------------------------------------
> <%
> SearchType = request.form("SearchType")
> SearchType2 = request.querystring("SearchType2")
> SChoice = request.querystring("SChoice")
>
> -- general other ElseIfs above this line of code --
>
> ElseIF SearchType = "strength" Then
> 	If SChoice > "" Then
> 	ThisOne = "= "& SChoice &""
> 	Else
> 	ThisOne = "> '""""'"
> 	End If
> Archive = "0"
> ThisStart = "SELECT * FROM tblData WHERE (Strength "& ThisOne &") AND
> (Archive = "& Archive &") ORDER BY idate DESC"
>
> 	Const adUseClient = 3
> 	Const adOpenKeyset = 1
> 	Const adLockReadOnly = 1
>
> 	Set objConn = Server.CreateObject("ADODB.Connection")
> 	objConn.open strConn
>
> If SurSearch > "" Then
> 	strQuery = "SELECT * FROM tblData WHERE Surname LIKE '%" &
> SurSearch & "%'
> ORDER BY Surname ASC"
> Else
> 	strQuery = ""& ThisStart &""
> End If
> 	'response.write strQuery'
> 	Set objRS = objConn.Execute(strQuery)
> %>
>
> is this confusing or do you get it - does anyone know how to fix the error
> im getting?
>
> cheers
>
> paul
>
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !
>


---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !