[thelist] jjsteele22 at yahoo.com

[Kevin]

> Message: 4
> Date: Sat, 23 Jun 2001 12:24:04 -0700 (PDT)
> From: jon steele <jjsteele22 at yahoo.com>
> To: thelist at lists.evolt.org
> Subject: [thelist] MS Access and SQL (from ColdFusion)
> Reply-To: thelist at lists.evolt.org
>
> Hi,
>
> I'm using ColdFusion to create a table, and I need to know how to work
> with all those extra options in Access...like default value, required,
> Autonumber, etc. Does anyone have a good link explaining these (besides
> the MS help file...they don't explain a thing).
>
> Also, you know how in Access you can use VB commands in the fields you
> create in Design View, I need to create a date field, with Now() as the
> default value, from ColdFusion. How can I set that default value?
>
> Thanks in advance,
> Jon.

Have you considered any of the tutorial style books on ColdFusion.
There are plenty out there, One in particular that I have been working with
just walked me thru cftable and table. The pros and cons of both and how
to work effectively.

I would highly recommend:
Build ColdFusion 5.0 web applications by B. Forta
You sound like you have a vB background so you could probably just
thumb thru the material.

Kevin