Escape char for '-'

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Escape char for '-'

Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

October 6th, 2005, 03:20 PM

mattastic

mattastic is offline

Authorized User

Join Date: Sep 2004

Posts: 36

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Escape char for '-'

Hi,

I'm using coldfusion to query an Access Db.

The table is called studentswithcourses-tg-table.

The '-' char causes an error, is there anyway I can escape it?

Thanks for your help.

Old

October 6th, 2005, 03:27 PM

echovue

echovue is offline

Friend of Wrox

Join Date: Oct 2004

Posts: 564

Thanks: 0

Thanked 4 Times in 4 Posts

Default

Hi Matt,

I am not experienced at all with ColdFusion, but what if you were to enclose the table name in []'s

Let us know if it works,

Mike

Mike
EchoVue.com

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Big challenge here! How to convert char* to char^?	samiswt	Visual C++ 2005	1	November 30th, 2007 09:09 PM
add id tag with setAttribute generates escape char	neilstairmand	Javascript	1	June 6th, 2007 05:18 PM
Escape '	lafilip	XSLT	3	May 22nd, 2007 03:31 AM
Invalid conversion from 'char*' to 'char'	deuxmio	C++ Programming	3	December 8th, 2006 07:56 AM
Suggestion... escape of [ char in messages	nikolai	Forum and Wrox.com Feedback	6	September 22nd, 2003 01:47 PM