It works for me using SQL Server 7.
What database are you using? I removed the < and > tags in the email of
course. This is a simple piece of working code, but the DDL will vary
depending on your database. As long as you know how to do what you want to
do in SQL, then you can do the same in a cfquery.
> YES, the code below does not work.
> A.Bajaria
>
> CFQUERY NAME="altertable" DATASOURCE="mydatasource"
> alter table foo
> add boobear int
> /CFQUERY
>
> ?
>
> c
> --
> Chris Lott <[EMAIL PROTECTED]>, Technical
> Manager
> p907.474.5122 | f907.474.5402 | PGP Key ID:
> 0x8687E87E
>
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://im.yahoo.com
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
