I can no usey "-" in my field names???
Posted: Fri Jan 14, 2005 4:59 pm
I just created a new table and had some fields like:
user-name
user-pass
I tried to do an insert doing something like insrt into myTable (user-name,user-pass) values ('bob','bobby')
and it no likey.
I guess I could have tried to escape the "-"'s with "\" but figured that would cause a major headache down the road.
As soon as I replaced all of the "-" with "_" I"m good to go.
This is news to me that I can't use these..can anyone shed some light here?
thx,
Burr
user-name
user-pass
I tried to do an insert doing something like insrt into myTable (user-name,user-pass) values ('bob','bobby')
and it no likey.
I guess I could have tried to escape the "-"'s with "\" but figured that would cause a major headache down the road.
As soon as I replaced all of the "-" with "_" I"m good to go.
This is news to me that I can't use these..can anyone shed some light here?
thx,
Burr