hi guys,
having a wee problem. am simply adding a new column 'product_image_large_5' to
an existing product table.
CREATE TABLE [dbo].[products] (
[product_id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[dCreated] [datetime] NULL ,
[dModified] [datetime] NULL ,
[product_code] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[product_price] [decimal](10, 2) NULL ,
[product_price_sale] [decimal](10, 2) NULL ,
[product_weight] [int] NULL ,
[product_date_available] [datetime] NULL ,
[product_status] [bit] NULL ,
[product_display] [bit] NULL ,
[product_image_small] [varchar] (255) COLLATE Latin1_General_CI_AS NULL
,
[product_image_med] [varchar] (255) COLLATE Latin1_General_CI_AS NULL ,
[product_image_large_1] [varchar] (255) COLLATE Latin1_General_CI_AS
NULL ,
[product_image_large_2] [varchar] (255) COLLATE Latin1_General_CI_AS
NULL ,
[product_image_large_3] [varchar] (255) COLLATE Latin1_General_CI_AS
NULL ,
[product_image_large_4] [varchar] (255) COLLATE Latin1_General_CI_AS
NULL
) ON [PRIMARY]
GO
when i add the column, and run our products query we get the following error...
[Macromedia][SQLServer JDBC Driver]Unsupported data conversion.
am really lost as all i seem to have added is the new column???
mike
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290020
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
