Accessing Filemaker Pro fileds In ASP

[sanith]

Hi all

I'm in deep trouble.My client having FileMaker Pro 6.0 db which i wants to access from ASP using ODBC connectivity.But their filds have space between two words.for example "Reference Number".when i use this in SQL query it's taking the first word "Reference" and giving the error as Reference field not exist.I can't remove the space in between the filed coz they are using this db for other applications.So can anybody help me to resolve this problem....

regards

sanith

[cjaeger]

you can define calc fields (reference_number = reference number) for every field that is likely to appear in the query.

[Garry Claridge]

In the SQL statement can you place single quotes around the field name; e.g.:

'Reference Number'

Good Luck.

Garry

[sanith]

We can't give single quotes in the SQL queries....Thanks for the suggestion....

regards

sanith