Why do you set the fields in " ?
select Company, Client Number, Name from attorneyDatabase
select "Company", "Client Number", "Name" from attorneyDatabase
AND you should
rename field Client Number to ClientNumber (without blank) or Client_Number. Only characters and numbers as table or field specifier, no spezial characters (the only exception is underscore _) such as blank, $, %, & and many many others.
Let me know if this helps.
greetings from germany
Thanks for responding.
I need the quotes because of the multi-word field name. I can't change the field name because the db is set up by my
client and is the center of his operation ... I am just trying to access the data to display on the web.
Note: One of the nice things about Filemaker, as compared to other DB apps, is that changing a field's name doesn't break the database in most cases. A few layout's may show the changed field name and you'd have to check for any Import records scripts that use Matching Names to align the fields, but that's about it.
I have determined that I can change the field names if necessary.
However, I just tested a query without the quotes and got the following result:
Warning: odbc_exec() [function.odbc-exec]: SQL error: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL, SQL state S1000 in SQLExecDirect in C:\web\test.php on line 9
[DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL
select Company, Name, Email, Position from attorneyDatabase
When I add quotes around the fields in the same query, it seems to run. (It was taking so long that I stopped it in the middle, but it did appear to be running.)
just this minute i did a look into the jdbc odbc guide for filemaker, page 44, reserved words.
position is a reserved word. Try your query once without position and let me know if it works.
greetings from germany
I'm still having trouble.
select Name from attorneyDatabase
returns 780 results, almost all filled in (a few scattered blanks throughout)
select Name, Email from attorneyDatabase
also returns 780 results, with the first one containing a name and a blank email, and the next 63 records with blank name and blank email!
I can't figure out what the problem is.