Knockout
|
| Posted: 06/18/2002, 2:38 AM |
|
I am working on a customer database and in their database they have fields which have spaces in the name of the field
(e.g. First Name Members Address)
My page gives a qurey error when i create a page with this.
but if i make the field name first_name it works fine.
is there something i can do to make this work with the space in the name of the field.
thanks for your help in adv.
|
|
|
 |
Ken Hardwick
|
| Posted: 06/18/2002, 3:10 AM |
|
1) Write/used custom sqls with brackets around the field names..
Like
Select [First Name] as First_Name,
[Last Name] as Last_Name
from Employees
2)Or create Queries/Views and then use the views..
Use similar type of Sql...
Select [First Name] as First_Name,
[Last Name] as Last_Name
from Employees
|
|
|
|
|
