doingITgood

i'm new to using the 'execute sql' script step and i'm not very well known with sql statements. what i'm trying to to is insert all data in a found set into a mysql database: INSERT INTO MysqlTable( CustID) Values (" & "'"& FMPTable::CustomerID & "'") with this code only the first record is inserted, even though i have 10 records in the found set. doest this mean i need to loop this script step for every record in the found set? or can this be done by modifiying the sql query.

thanks for your response!

just a quick question: how does the fmp php api hold itself against fx.php? fx.php uses xml-generated data which has to be parsed by the fx.php module, as far as i know, and i'm wondering if the same goes for the fmp php api. if there's no xml parsing involved (using the fmp php api) my guess is that performance-wise it would shine. any comments on this are appreciated.

hi shawn, i've only managed to access the xml api by using the nettools plugin. i get alle the info i need, now i just need to find a way to import the xml data in filemaker. ik need a stylesheet to do this, but have no experience on making stylesheets