We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

Diver

Members
  • Content count

    16
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Diver

  • Rank
    novice
  1. Thanks Wim. I sometimes forget about 'rolling your own'. In this case it would have been ugly as there would have been over a 1,000 ?s. A recursive would have worked if I did them one by one. I stumbled across a Custom Function on briandunning.com that fit what I needed perfectly. You simply give the CF a list and it does the rest for you. VLookup ( LookupTableAndFieldName ; MatchingValueOrList ; ReturnFieldNames )
  2. Believe I found the solution. The list has to look like this: WHERE a.\"PartNo\" IN ('0110015004', '0110015005', '0110015008')" ; Setting the variable $itemIDs to that same list and then using: WHERE a.\"PartNo\" IN (" & $itemsID & ")" ; does NOT work Nor does setting a global field and using SELECT to pull the data from the global such as: WHERE a.\"PartNo\" IN (SELECT ( \"sqlSelect_g\" FROM \"INV__Inventory\"))" ; Unless someone could provide a way to use a dynamic list of items to use with the 'IN' option I think the 'IN' option has a very narrow focus and use, though good were it will work.
  3. Thanks Justin for the reply. I have changed the string of values to be what you outlined, not return-separated. I have my two original examples slightly modified trying what I thought your reply suggested yet neither work. I am now trying do a sql query in all records in the INV__Inventory table and only return those numbers that are in the "IN" string. Here are the two calcs, along with their results. Example 1: Though I am setting the $itemIDs, it is only being used to show what the field value of sqlSelect_g is. It was my understanding that this method, using the "IN( SELECT...." is needed as Kris M noted above. Let ( [ $itemIDs = INV__Inventory::sqlSelect_g ; SQLResult = ExecuteSQL ( "SELECT a.\"PartNo\" FROM \"INV__Inventory\" a WHERE a.\"PartNo\" IN (SELECT ( \"sqlSelect_g\" FROM \"INV__Inventory\"))" ; " " ; "|*|" ) ] ; "SQLResult is: " & SQLResult & ¶ & "When $itemIDs is: " & $itemIDs ) ----------- RESULT OF CALC ------------ SQLResult is: ? When $itemIDs is: "0110015004, 0110015005, 0110015008" Example 2: Here I am using the "IN" clause without the SELECT clause, corrected as you pointed out in your previous post. Let ( [ $itemIDs = INV__Inventory::sqlSelect_g ; SQLResult = ExecuteSQL ( "SELECT a.\"PartNo\" FROM \"INV__Inventory\" a WHERE a.\"PartNo\" IN (" & $itemIDs & ")" ; " " ; "|*|" ) ] ; "SQLResult is: " & SQLResult & ¶ & "When $itemIDs is: " & $itemIDs ) ----------- RESULT OF CALC ------------ SQLResult is: ? When $itemIDs is: "0110015004, 0110015005, 0110015008"
  4. I have run into a similar situation trying to use the 'IN' clause but have not been able to find a resolution. I have two FM files. The first one uses a sql call to capture a long list of part numbers (see example list below). I then pass the results to a second file in a script parameter. Example list: A12345 A85732 B45449 .... could be 1,000 items in the list Here is what I have tried: Let ( [ ReturnSub = "\n" ; // Swap out carriage returns in results with a different character. \n is the default. $itemIDs = Get(ScriptParmeter) ; SQLResult = ExecuteSQL ( "SELECT a.\"PartName\" FROM \"Inventory\" a WHERE a.\"PartNo\" IN ($itemIDs)" ; " " ; "|*|" ) ; partNames = Substitute ( SQLResult ; [ ¶ ; ReturnSub ] ; [ "|*|" ; ¶ ] ) ] ; partNames ) I have also tried using a global field (sqlSelect_g) in the second database and setting the passed parameter list into the field so it has a long list of items for the use by the SELECT clause : Let ( [ ReturnSub = "\n" ; // Swap out carriage returns in results with a different character. \n is the default. SQLResult = ExecuteSQL ( "SELECT a.\"PartName" FROM \"Inventory\" a WHERE a.\"PartNo\" IN (SELECT ( \"sqlSelect_g\" FROM \"Inventory\"))" ; " " ; "|*|" ) ; partNames = Substitute ( SQLResult ; [ ¶ ; ReturnSub ] ; [ "|*|" ; ¶ ] ) ] ; partNames ) I think I would be fine if I was in one file and could use the SELECT clause within the IN clause but the data I need for the IN clause is not from the file I need it for. Any suggestions?
  5. Great example, thanks sharing it! What would be required to get distance by vehicle?
  6. I want to use the SCMoveLocalFile command with a FM Server Side Script that moves files to the trash can rather than use the SCDelete. This is because the SCDelete makes the file gone for good where if it was moved to the trash during testing, it could be removed from the trash and put back in the FileMaker Server Documents folder. I have tried using the destination path of "~/.Trash" but I get an error. Anyone have a suggestion? Related to this, can you move a file to the Admin accounts trash without the FileMaker Server machine actually being logged in with a user account? For testing I do have it logged in.
  7. Good news, the problem is solved. While going through the manual process I learned that file /Library/FileMaker Server/Admin/admin-helper/WEB-INF/conf/mod_jk.conf was missing the following two lines: JkFmMount /SuperContainer/* cwpe JkFmMount /SuperContainer cwpe I am guessing that these were removed when using the FileMaker Server Admin Console and running the "Edit Server Deployment", selecting to use FileMaker's built in PHP versus the installed PHP. I am not certain on this but it is the only thing I can think of that may have caused the lines to disappear. Thanks for the help!
  8. I have been using SuperContainer for some time with no troubles. Now my FileMaker databases are not seeing the SuperContainer URL. When I try and access the standard url of 127.0.0.1/SuperContainer using Safari on my web server I get the error: The request URL /SuperContainer was not found on this server. I have validated it is there, as are all of my files (whew). I have checked permissions for the Shared directory with SuperContainer directory in it and I think all looks fine, though I am not sure what they should be. It is running on an Apple Xserve with Server OS 10.5.8. I ran Disk Utility and repaired permissions. I downloaded the latest SC version 2.77 and installed it with the Installer.jar file. I have checked and IWP is working fine. My FileMaker 10 Advanced Server is running on a separate Xserve in the same rack. Anyone have any thoughts on possible problems or testing?
  9. jpeg quality and dimensions

    I can understand the need to do custom work for organizations but I would hope you could add some things like the image info to a future version. It is a very general feature that would benefit everyone.
  10. I am uncertain how far I should try the testing, based on the last post. I have tried to implement it but believe where it is breaking is the following. (I have the first line for reference only). $file = Get (FileName) 1 + Left( EvaluateGroovy( "fmpro.performScript("" & $file & "","Show"); return true;" ); 0)) The second line is the line in the conditional formatting that I need to change. The reason is the filemaker file I am using is hosted on a server. It appears the code above is formatting the path to the local file so it can tell ScriptMaster to run the file's script called "Show". I tried replacing a portion of the text to be something like: EvaluateGroovy("fmpro.performScript( "fmnet:/serveripaddress/fmFileName","Show");return true;);0)) serveripaddress = the IP Address of my FM Adv. Server fmFileName=the hosted FileMaker database Show= the script within my FileMaker database to run I am guessing I have something messed up with the quotes and am not able to find documentation on what EvaluateGroovy is expecting for parameters.
  11. This is a bit mind bending. I see in your example how the Conditional Formatting is using ScriptMaster plugin. I will have to try and dive into it deeper and see if I can apply it to my solution. To summarize, it is basically using a conditional formatting to tell ScriptMaster to run a script. - correct?
  12. Thanks David. I had thought of that as well but it is such a nice feature to be able to just drag and drop. Much easier than having to go through a file tree to locate the file already at your fingertips. Could SuperContainer be enhanced to allow the FM record to be saved upon modification of the web viewer content? This would allow script triggers to then be available.
  13. Thanks for the thought ... I had been thinking the same thing. The problem is FileMaker does not see the web viewer as changing so the un-stored calc using SCGetInfo does not change unless you force FileMaker to record the record by refreshing or clicking outside of any object.
  14. I wanted to have a script trigger launched upon modification of the SuperContainer web viewer. If there was an image in it, it would do one thing. If there was no image in it, it would do another. I have found if I drag a file into the web viewer no script is ever triggered. If I control click on the web viewer and delete an image and then click on the layout, a trigger will activate. Is there any way to make the dragging of an image into the web viewer activate a script or for a script to be activated when deleting an image from the web viewer without clicking on the layout?
  15. So many threads talk about the iwp_home.html file yet I can't find a copy of it. FileMaker docs say it is on the Install CD. I only deal with volume licenses and thus download the install from FileMaker. There appears to be no file called iwp_home.html from the install. I have looked on the server in the /Library/FileMaker Server/Web Publishing/IWP folder and it is empty. Does anyone know where I can find it or get a copy of it?
×