Willy Koch

Hello, This one is a bit tricky: I have a database with people where the email is the primary key. These people can have one or more values from a value list. The value list are different check box categories that the person belongs to, like what type of movie they prefer: Action, Comedy, Cartoon etc. Is there a script or function that will check for duplicates on import and retain the existing values, and just append the new category? Or in other words: Jack@example.com already exists in the database and he likes "Drama" and "Detective movies" In an external text file, with several people, there's also an entry for jack@example.com "Romantic comedy" When this duplicate record is found, I'd like the import process to append "Romantic Comedy" to Jack's record, so it reads: jack@example.com "Detective movies", "Drama", "Romantic comedy" It's given that I've created the new value list entry before importing. Thanks for any pointers. Regards, Willy T. Koch Norway

Ok, I figured it out. I was a bit confused but now I'm fine. I did, with the Execute SQL function->Calculated SQL text: "INSERT INTO `users` ( `id` , `username` , `password` , `reply_to` , `reply_name` , `last_login` , `cookie` ) VALUES ( '', '"&WDev::Navn&"', 'password', '"&WDev::Epost&"', '', '', '' );" WDev being the name of the FileMaker database. It was the '"&WDev:<field>&"' part I couldn't figure out right. Thanks ya'll!

Ok, I figured it out. I was a bit confused but now I'm fine. I did, with the Execute SQL function->Calculated SQL text: "INSERT INTO `users` ( `id` , `username` , `password` , `reply_to` , `reply_name` , `last_login` , `cookie` ) VALUES ( '', '"&WDev::Navn&"', 'password', '"&WDev::Epost&"', '', '', '' );" WDev being the name of the FileMaker database. It was the '"&WDev::<field>&"' part I couldn't figure out right. Thanks ya'll!

Ok, I figured it out. I was a bit confused but now I'm fine. I did, with the Execute SQL function->Calculated SQL text: "INSERT INTO `users` ( `id` , `username` , `password` , `reply_to` , `reply_name` , `last_login` , `cookie` ) VALUES ( '', '"&WDev::Navn&"', 'password', '"&WDev::Epost&"', '', '', '' );" WDev being the name of the FileMaker database. It was the '"&WDev:<field>&"' part I couldn't figure out right. Thanks ya'll!

Hello and thanks for the reply. I'm using ODBC, I bought the Actual ODBCPack which works great. One question: Could you please show how you would write the INSERT code using the Execute SQL() function? (With fields from the FM database) Thanks!

Hello, I've been working with mysql and php for a while and now I'm looking into using Filemaker 7 as a frontend. I think what I'm trying to do is fairly simple: I want to use Scriptmaker to Execute an SQL query, like this: INSERT INTO journalists (contact, name) Values ("' & contact & '","' & name & '") I've added a new record, two fields, contact and name, and I now want to add that record to the sql database. But how do I get the field values into the INSERT statement? In php I would do: <?php $sql = "INSERT INTO journalists (contact, name) Values ('".$contact."','".$name."')"; ?> What do I do in Scriptmaker? Thanks a bunch. Willy Oslo, Norway

Sorry about that, have to be more specific. I want all the employees with their totals to be displayed on one page. What I've done now seems to work alright, I do the search and put the resulting totals in an Employees Database for storage. Not that it's a real problem, just a curiosity: Why won't this work: Set Field ["People_total::Total_amount", "0"] It doesn't put the zero in the field, just leaves it blank... Thanks! Willy

Okay, here's one for you wizards: We have a time-register database that are used by 15 or so people. In one record, they choose their name and type in how many hours they've worked on a project/customer. What I want is statistics for how many hours, how much money all these employees have earned. I'm thinking something like this: Do a find on person Joe Blow to list all the money only this person has generated. Copy summary-field to other field for storage. Repeat for all employees. How can I do this without having to do 15 Set Field ["Employee", "Joe Blow"] ? Do I use a repeating field for storing the individual totals? Use loop and lookup the employees' name from another database? Any help and pointers will be greatly appreciated... Thanks! Willy