recordset constants (data types)

spinal007 · #1 (**permalink**) Sep 14th, 2004, 17:09

I need to create a recordset (through scripting, not connecting to a database)

I know that for text fields (variants) I can use the constant 200,
integers is 3 and dates is 7

I've looked all over the place and I can't find anything on this.....
anyone know what the other constants are?
boolean/memo/etc

sample code:

Code: Select all

' contants
cnstVar = 200
cnstInt = 3
cnstDate = 7

' define recordset and fields
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Fields.Append "name", cnstVar, 100 ' variant, length 100
rs.Fields.Append "number", cnstInt ' integer
rs.Fields.Append "date", cnstDate ' date
rs.Open

' then add data to the recordset like this.......
rs.AddNew
rs("name") = "hello world!"
rs("number") = 157
rs("date") = Now()
rs.Update

' ETC

Webforumz Staff · #2 (**permalink**) Sep 14th, 2004, 17:36

Here you go:
http://msdn.microsoft.com/library/de...tatypeenum.asp

spinal007 · #3 (**permalink**) Sep 14th, 2004, 17:47

I searched the MSDN website and still couldn't find it... I must be thick.......
thanks a million!

Webforumz Staff · #4 (**permalink**) Sep 15th, 2004, 06:55

Yeah, the problem with MSDN is you have to already know where something is to find it.

Rob · #5 (**permalink**) Sep 15th, 2004, 11:41

Well, not quite true.
I always use google to search MSDN, as I find it better than msdn's own search.

To search MSDN (on google) for this, you would use:- 'ADO Data types site:msdn.microsoft.com'
The 'site:msdn.microsoft.com' switch tells google to ONLY return results from that domain, as can be seen by clicking here:-
http://www.google.com/search?hl=en&l....microsoft.com

I believe the result you want, is listed second.

Smokie · #6 (**permalink**) Sep 16th, 2004, 07:51

magic numbers....

spinal007 · #7 (**permalink**) Sep 19th, 2004, 07:39

thanks guys

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing RecordSet to .asp file	tolis	Classic ASP	8	Nov 23rd, 2005 20:23
MIME types	ktsirig	PHP Forum	0	Oct 10th, 2005 17:38
passing recordset to next page?	Monie	Classic ASP	1	Sep 25th, 2004 07:53
Constants	jakyra	Classic ASP	2	Oct 16th, 2003 12:27

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
recordset constants (data types)