Dynamic Recordset

Results 1 to 3 of 3

Thread: Dynamic Recordset

  1. #1
    Duc Guest

    Default Dynamic Recordset

    Hi all,<BR>How come I can&#039t create a dynamic record set using this code<BR><BR>Set Record = Server.CreateObject("ADODB.RecordSet")<BR>Record.F ields.Append "FirstName", adVarChar,30<BR>Record.Fields.Append "FirstName", adVarChar,30<BR><BR>What is wrong with this??<BR><BR>Error Type:<BR>ADODB.Fields (0x800A0BB9)<BR>Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.<BR>/AC/testme.asp, line 4<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Dynamic Recordset

    Not ot sound tooooooo lame but what are you trying to do? add a table field, add a record to a table or a select a record from atable. It looks like you are trying to add a field to a table if so you might try<BR><BR>Sql="ALTER TABLE Tablename ADD COLUMN FirstName, VarChar, 30;"<BR><BR>yourconnection.execute Sql<BR>yourconnection.close<BR>I am not sure if that will work either <BR>

  3. #3
    Duc Guest

    Default RE: Dynamic Recordset

    I am trying to create a synthetic Recordset that I would store my information in memory for a temp use when I am done I will dump it away.<BR>Duc

Posting Permissions

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