I have a client using access (I know Access sucks for web stuff, but he's using
it...) Anyway I try to execute the SQL below and it blows a syntax error from
CF. I can paste this into a query in Access and get it to run. I think it has
something to do with the field called "Date" which is a text field.
INSERT INTO Reports_Items_Viewed (ItemNumber,[Date],Type,Count,PageCount)
VALUES('103','2007-04-18', 'collection' , 1 , 1 )
Any help would be appreciated.
Daron Smith
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 &
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275816
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
