Kranky

I have a container field that stores file reference to an image file. The image file is in host machine as the image file. The Filemaker training book mentions: "If the container data has been stored as a link or reference, rather than embedded directly within FileMaker Pro, the stored path to the file needs to be accessible to the IWP host in order for the container data to be available. For FIleMaker Server Advanced, acceptable paths would lie within the FIleMaker Server/Web Publishing directory, or any nested subdirectories...." I have a folder in the Web Publishing folder called "images". I reference the image in the container field with a relative path. "imagewin:Web Publishing/images/image.jpg" In fact i have tried several variations of the file path both relative and full path. It doesn't work. What crucial ingredient am i missing in this IWP/Server/Container Field Soup? Many Thanks Kranky

Thanks for the reply. The problem was the scope of the global fmpro object. I got around it by setting the fmpro object to a static variable in my class. myClass.fmpro = fmpro myClass{ public static def fmpro; }

I am attempting to use the fmpro.evaluate() function inside a class. I get a 'groovy.lang.MissingPropertyException: No such property: fmpro for class:' error. Do i need to import a package for it to work?

From what i could tell by reading the filemaker ODBC developer guide both GROUP BY and ORDER BY sql statements are supported by filemaker. I am unable to use these two statements together without receiving an error. The statements used separately work painlessly. Anybody else having the same problem? the statment is similar to Select * from table group by item order by total

According to the Filemaker documentation (FM8_ODBC_JDBC_Developer.pdf), SET ROWCOUNT is not a supported SQL statement. Neither are LIMIT or TOP.

filemaker timestamp - 15/2/2005 11:09:03 am when retreived via xml for web publishing is turned to 15/2/2005 11:09:03. its no use to me because i can't tell whether the time is in am or pm. i tried to change the filemaker timestamp to display time in 24 hour format by setting the time format(format>time) to 24 hours. this however didn't change the format of the time nor the xml output. has anyone worked with timestamp in webpublishing? if so please write so inputs. many thanks.

Code: $query->AddDBParam('customer',"cust7","eq"); $query->AddDBParam('status',"closed","neq"); this search should give me all the items for customer - cust7 whose item status is not closed(ie, open). this in filemaker terms would be doing two find request. one for customer = cust7 and another for status = closed ( with the omit tick box checked) so it would give me a result set of 3 which is correct. the fx.php search however gives me 57, obviously incorrect. i even tried with the 'lop' set to 'and' without any joy. if anyone has figured it out, give us a hint. cheers

Table:customers text field-name textfield-email textfield scope Table:pref text field-code text field-email text(global) - criteria relationships: email=email scope = (global) criteria layout:main(based on customers) text field-name pref::textfield-code That is the basic setup. two tables one customers with the three text fields and a preference table with the unique code,email and a global field. The relationship between the table is shown as above customer::email=pref::email AND customer::scope !=(notequal) pref::criteria A layout based on the customers table displaying the text field name and the code from the preference table. If say for arguments sake scope = flies and criteria = drives, the relationship wouldn't be valid and no found set shoudl be returned. If i perform a find on (textfield code on the layout)in the filemaker database itself, it was perfectly.but when i use a simple FMFind() it does return me a record matching when it really shouldn't Now i am wondering if it is the Global field that is playing a villian. Can anybody clarify this to me? thangyuh thangyuh vurry mush again

thanks dan i tried your way, but i still get error100: file missing its frustrating.i don't know why its refusing to work when the file is setupt correctly

I have a problem using a different account for my cwp(other than admin account). at the moment i can use fx php using either of the below step to choose the account. Code: $result->SetDBPassword('bandwagon','admin'); $result->SetDBUserPass('admin','bandwagon'); i now create a new account for my filemaker database, called 'web', which uses the same privilege set as the 'admin' account. this time when i try to use 'web' account with: Code: $titles->SetDBPassword('','web'); i get Errorcode- 100:File is missing error in the browser. does anyone know where i am getting it wrong. why is it saying file is missing, when i have provided it with a username and password another issue i can't get around is, if i create a filemaker database which uses a default account so that it doesnt ask me for a password each time i open the file, do i still have to specify a user account in fx.php? thanks for any input.

$serverIP = "127.0.0.1"; $user = "xxxx"; $pwd = "xxxx; $dbName = "Login.fp7"; $layout = "login"; $groupSize = "All"; include_once("FX.php"); $query = new FX($serverIP); $query->SetDBPassword($pwd, $user); $query->SetDBData($dbName, $layout, $groupSize, $layout); $data = $query->FMFindAll(); var_dump($data); once you have that, how can you display all the data in a table? any clues