>
> In Dreamweaver, using the Insertion Wizard, if I want to
> insert a hidden "datesubmitted" field and use #Now()# and the
> database is SQLServer, which option do I want to select in
> the "Submit As" dropdown? "Date" or "Date MS Access"?
>
> It's just a nagging question that I've always
> wondered...what's the difference between the two? The Help
> for Dreamweaver only contains the following reference, "In
> the Submit As pop-up menu, select the data format accepted by
> your database table. For example, if the table column only
> accepts numeric data, select Numeric.". Not much help there,
> but I've always wondered. Since I was using MS SQL Server,
> I've always selected "Date MS Access" and it works, but I
> just was wonderin'...ya know...all curious and stuff...
If you're using SQL Server, don't pass the date from CF, get SQL Server
to insert the data itself
INSERT INTO table (dateField)
VALUES (getDate())
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
