Guess I should have read the subject line :)
Try this:
alter table members add lastlogin date
----- Original Message -----
From: Dina Hess
To: CF-Talk
Sent: Sunday, March 31, 2002 4:31 PM
Subject: Re: ALTERing Access DB
What database are you using?
----- Original Message -----
From: W Luke
To: CF-Talk
Sent: Sunday, March 31, 2002 3:46 PM
Subject: ALTERing Access DB
Hi.
V simple - just need to add a date/time column to a table - I've tried the
below, with no luck. Where am I going wrong?
<cfquery name="addit" datasource="#application.ds#">
ALTER TABLE Members
(ADD COLUMN LasttLogin date)
</cfquery>
Thanks
Will
__________________________________________________
Try Pingo:
http://www.localbounty.com/pingo
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
