I have a table which includes a most unfortunate column name: ID#:INST
I have tried:
INSERT INTO LS07DATA (
[ID#:INST], ...
And
INSERT INTO LS07DATA (
[ID##:INST], ...
For Microsoft Access.
Neither of which work. I get this for both:
Invalid CFML construct found on line 9 at column 12.
ColdFusion was looking at the following text:
#
The error occurred in
D:\Inetpub\autmsurvey\Administration\Add_new_inst_action.cfm: line 9
7 : <CFQUERY name="insertnew" datasource="#application.datasource#">
8 : INSERT INTO LS07DATA (
9 : [ID#:INST],
10 : ID,
11 : insttype,
Any ideas for a work-around would be appreciated.
TNX.
Rick Colman
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307378
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
