Hi Richard I haven't used Access for a while, but I seem to remember being able to do inserts via a view (query in Access).
Could you make a view that aliases the dodgy column with a normal name, and try using that for inserts? Another wild guess - try using the ascii code for # - asc(35) and see if it gets through that way, although if doubling the # didn't work this probably won't either. Two dodgy ideas - hope one helps. Antony On Fri, Jun 13, 2008 at 2:19 PM, Colman, Richard <[EMAIL PROTECTED]> wrote: > > 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:307381 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
