Dusty_Rods

Hi Guys, Im sorry to be asking this but im in a bit of a tight squeeze. Ok i have a 3 tables on a mysql database. table 1 - has people table 2 - has images(just the filename the path) table 3 - is the key between them both it uses ID numbers from each of the images and people table.(this is how i associate people with their images) What im looking for is a php script that will allow me to search this setup. i also want an advanced search for instance i might want to search all people that live in England, Ireland and Canada. Anyone ever dealt with this before if someone know where i can get my hands on a script so i can tweak it to work with my setup that would be great. Any questions shout. Thanks again, D

Hi, Im running filmaker server 7. it was running on a OS 10.2.8 server, Recently our hardware guy installed over it OS 10.4.2 server and everything seemed to be working, However now i cannot perform the applescript that used to work fine when the filemaker server was on 10.2.8 Like so set userComp to (do shell script "echo $USER") set fold_path to "Macintosh HD:Users:Shared:Exported images:" tell application "Finder" delete every item of folder fold_path end tell Now it doesnt do a thing , wondering is the upgrade the problem or is there a setting i need to fiddle with somehwere, as always thanks for any help. D

Thank you very much that worked a charm... Dusty

Hi guys, Ok so i have a calculation field called imagedetails that looks at image using the getasText function and this is what is coming up for it. size:184,245 image:6028.jpg imagemac:/6028.jpg So what i want to do is do a search for images that have a bigger height than their width and visa versa. I cant get my head about getting the substring to work as the image height or width may have more that 3 digits.

Hi guys thanks for the feedback however neither of those worked. What i want to happen if the user types in o'malley it goes to --> O'Malley O'malley it goes to --> O'Malley it will capitize the letter before and after the apostrophe. Thanks again guys , D

Hello all, Ok so i have a nice formatting calculation on my surname field. So when you put in smith It will capitize it to read Smith. However being from ireland we have a lot of second names like O'Malley and O'Brien. Now the proper function really doesnt work with this guy for obvious reasons it only caps the first letter when it should do it with the first two letters. My current code: Case ( Login::Formatting = "On" ; Proper(Surname) ; Login::Formatting = "Off"; Surname ) I do it on a global formatting on off field so they can turn it on and off. I have tried to proper the character using leftword and counting in the character but nothing seems to work any advice on this i would be very grateful. Thanks, D

hi guys, I have a checkbox set defined on a field called media. the options are local newspaper local radio National newspaper National radio. I am doing a report and I need to count the number of local media. So i have a summary field that looks at the calculation however i cant seem to get the calculation working. If i use and if statement doesnt that mean it returns only one per record where if both local radio and local newspaper are selected it should return two. Thanks for Looking, D

Hi guys, Attached is a small example of a problem i have. 1) I a repeating field called designation that has a value list entry. I want to be able to validate that no two repeats of designation is the same. Also i need to validate for the record the retail and commission can never be together in the repeating fields. 2) Secoundly if at all possible that if a use picks retail for the designation for the first repeat of designation that the first repeat of sub designation will acquire the the value list of SubDesignation(retail) - VL this can be any number of the repeat. so if designation(3) = "trade" subdesignation(3) will have a pop menu of SubDesignation(trade) - VL I have tried everything to get this to work and i cannot get my head around, It is central to a solution and i dont have the time to rip it out and use portals. Im really desperate any help would be very muchg appriated. Thank yoou for looking D repeatingfield.fp7.zip

Hi transpower and thanks for the reply however there are more than 3 animals there are 10. I cannot change it from a repeating field as it is central the entire solution and i do not have time time to overhaul, so Is there a way to validate repeating field elements? I am currently looking into the valuelistitem function. Yet again thanks for your time. D

Hi guys, I have a repeating field called Type with a repition of 3 i also have another repeating field called sub_type with a repition of 3 both on the same layout. Now what im getting stuck on is : 1 i obviously dont want any of the repeating types to repeat themsleves Example Type (proper validation) dog cat mouse type (Should tip validation calculation) dog dog mouse if the user picks dogs twice i want it to revert back to blank until he/she picks something that doesnt repeat dog. 2. If the user picks dog for the first repition of type (type[0]) i was wondering could i manuplate the pop munu that appears for sub_type (sub_type[0]). Something like (sudocode) if type[0] = "dogs" then sub_type[0] popmenu = dogs popup menu if type[0] = "cats" then sub_type[0] popmenu = cats popup menu if type[0] = "mouse" then sub_type[0] popmenu = mouse popup menu Any assistance/pointers/ridicule weclome. D

Thanks for the response otter. what happens if the user pushes the apple f key does the code still apply?as there are not using a button predefined by me so i cant stop them from getting females back as well? thanks again D

Hi guys, I have a a few small niggly problems that i cant seem to tap on the head. If someone could give me any direction or info on how to overcome it that would be great. 1. how do i turn off return all records(applescript maybe or is there a handy script step) 2. when people search for firstname for example i want to make sure that the gender male is only returned do i use contrain ?? what are the steps about getting this working. has anyone any good examples of a who is logged layout or url to a tutorial i would be very much in your debt. Thanks D

Hi guys hope you are all keeping well - in fm7 mac only enviorment. I have a really silly question _ what are the step to go about getting a value list that will add the users other to the list? So my field Photographer list contains Roy D Merser Billy Bob kelly Other... so if the user inputs david goodspeed in the other box the list from then on will be Roy D Merser Billy Bob kelly david goodspeed Other... I know its not a good idea to have users to do this but this is the only one and its static information anyways thanks for you time any comments suggestion more than welcome.. D

Hi guys thanks for all the input its great really works a charm. here is a newer vesion as b c d were formatted funny last time. fmforums rule. D Middle(Substitute(TrimAll(". "&Substitute ( Input Text ; "." ; ". " );0;0); [". a";". A"];[". b";". B"];[". c";". C"];[". d";". D"]; [". e";". E"];[". f";". F"];[". g";". G"];[". h";". H"]; [". i";". I"];[". j";". J"];[". k";". K"];[". l";". L"]; [". m";". M"];[". n";". N"];[". o";".O"];[". p";". P"]; [". q";". Q"];[". r";". R"];[". s";". S"];[". t";". T"]; [". u";". U"];[". v";". V"];[". w";". W"]; [". x";". X"];[". y";". Y"];[". z";". Z"]);3;10000000)

Hi guys, Has anyone every come accross a formula that will text format a field like so The user inputs: my name is david.i live in a town.Please vist me And the format output from the formula My name is david. I live in a town. Please vist me All i want really is the first letter of every sentence capitalized and there be a space after every . Any help very much appriated. D

thanks for the input h20 , However i seem to be getting a - 10000 error i tried putting it like this tell application "FileMaker Pro" activate do menu menu item 4 of menu 8 of menu 2 end tell even if i take away the tell application lines it wont work I am also doing this as admin so its not a permission error i dont think? Thanks again D

Hi to all hope you are keeping well, using fm7 developing for mac only. Im try just as a nice touch on my admin layout to have a button that automatically opens up the account and privilege window instead of the admin user going to file - define - accounts and privilige . Thanks for looking and hints suggestion or shout at my obvious noobiesness welcome.... d

thanks transpower D

Hi guys, Hope your all doing good im using fm pro 7 and i need to install reports on the database. I have several table all with number and text and the usual db stuff. how do i go about doing the reports is my question. Do i define summary fields within the table itself and then calculate from there or do i define a reports table and look at the other tables and calculate therfore keeping the report central in one place. Any links, tutorials,examples or feedback i would really appriate it.

excellent thanx very much i owe you a pint..

Yet another newbie question Anyways im trying to do something so simple that i cant believe im asking this but for the life of me i cant find it anywhere probably the phasing anways what im trying to do is display the current record number and the total record count on the actual layout i defined a global calculation to hold it and it reads like so : "Record " & Get ( RecordNumber ) & " of " & Get ( TotalRecordCount ) it doesnt seem to work at all for me.... Any help i would be very appriative... D

lee thats great thanks very much your a * D

Hello everyone, Hope everyone is well?. So im developing a db for a client who want to be able to track who does what to what record so at the end of every table i have a calculation called tracking with the following code... tracking & "," & Get ( AccountName ) & "*" & Get ( CurrentDate ) & "*" & Get ( CurrentTime ) I put tracking first so that if someone comes along at a later date it gets added to tracking and doesnt replace it the , seperates the occurances of a change and the * seperate the name date and time. So my question is ... Is there a better way of doing this as i am having difficult getting even this to work also which is the best way to show this data to the client can a portal sort comma delimeted fields? or is there something better i can use... Any help would be very much appriated thanks for reading, D

hi guys thanks for the help ill try it.

Hi , I am trying to get a button that returns to the last layout it does not need to remember the last four layouts just the last one it was on. I am also trying to link to a pdf document through a button im trying OpenURL but to no avail does the pdf document need to be served at the moment im saying openURL pdf_document/about.pdf thanks for your time , DR