cmdTemp error

Results 1 to 2 of 2

Thread: cmdTemp error

  1. #1
    any-who Guest

    Default cmdTemp error

    I am having trouble retrieving info from a SQL database. It&#039s giving me the error: "Object Required: &#039cmdTemp&#039"<BR><BR>Can anyone help? <BR><BR><BR>if thingy = 1 then<BR> cmdTemp.CommandText = "SELECT var1, var2, var3, var4 FROM table WHERE var2 = &#039 2&#039"<BR> set rs = server.CreateObject("ADODB.Recordset")<BR> rs.Open cmdTemp,,adOpenStatic,adLockReadOnly<BR>end if

  2. #2
    Join Date
    Dec 1969

    Default RE: cmdTemp error

    You need to add...<BR><BR>Set cmdTemp = Server.CreateObject ("ADODB.Command")<BR><BR>somewhere before you try to use it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts