Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


randyinla last won the day on October 7 2015

randyinla had the most liked content!

Community Reputation

1 Neutral

About randyinla

  • Rank
  • Birthday 10/03/1907

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi, I have a field called 'mytournament1'. I also have a field called 'mytournament1played'. With a form, I create the variable $tournament to bring 'mytournament1' to my results page. $tournament = $_GET['tournament']; I'd like to force the results page to search for the field 'mytournament1played' for each record by using the variable $tournament and combining the word 'played' or the variable $played. $played = 'played'; $tournamentplayed = $tournament . $played; $tournamentplayed2 = $record->getField('$tournamentplayed'); (I want it to deliver) $re
  2. Thanks Doughemi and Webko, I tried both techniques and did not get the results I'm looking for. I don't know if it's possible to do. I'm ranking tennis doubles players, here's a link. http://ssvtennis.com/include-sd-ssvcuprankings.php
  3. Hi, I'd like to creat a sorting order with a $varCount like: 1 1 2 2 3 3 and alternating row colors that will print: pink pink yellow yellow pink pink Here is the kind of coding I'm using that works fine for sequential numbering and odd/even row colors. I appreciate anyone who can help me change these parameters, as I have tried every combination I could think of. Thanks! <?php $row = 0; $varCount = 0; foreach($records as $record) { $varCount = $varCount + 1; if($row % 2 == 0)
  4. Hi Doughemi, I'd like to do a search where the the result doesn't equal something.  My coding is obviously wrong, but hope you get the idea.  All records where myField does not equal '1'


    $myFind->addFindCriterion('myField', '!=1');

    1. doughemi


      I prefer that you ask questions on the forum in the future. That way, others can benefit.

      See this thread.

      I can't tell if the link was included in the previous reply.  It is http://fmforums.com/topic/100786-constrain-find-possible/?do=findComment&comment=458882


  5. Hi, is there any reason my DB crashes web publishing engines? It is a simple database on an FMP12 server. clients generally toggle simple buttons on or off. Is there a function inside the DB itself that I have not turned on or off? Is it a sharing, permissions or admin thing? Is this a problem with other users? I'm new and you guys in this forum have really helped me a lot! Thanks in advance!
  6. I tried the pagination link of yours and It gave me errors, do you know if there's any bugs in it? Any other links on pagination? I'd love to see your module if you dug one up. Thanks!
  7. thanks Webko, that's terrific. you're a champ! How would that work using variables? addFindCriterion('ssvm', '$Num1...$Num2');
  8. Hi, I'm trying to find records with a number field that are greater than or less than 2 numbers, i.e. if I'm looking for the records greater than 115 and less than 120. $myFind->addFindCriterion('ssvm', '>115'); $myFind->addFindCriterion('ssvm', '<120'); do I need $myFind->setLogicalOperator(FILEMAKER_FIND_AND); or am I way off base? Thanks for your advice!
  9. Thanks Doug and Webko, coding works great. Can you recommend a good PHP book or links on the web for filemaker and PHP?
  10. Thanks Webko, how do I change which account I'm logged in under? I guess I need the 'guest' account which has only 'edit and create' privilieges. I don't want my clients deleting anything. I'm looking into the ShowOnWebFlag field for different reasons. I'm trying to find a way to send an email to myself when a client hits a submit button. Thanks!
  11. Hi, I'm doing a newFindAllCommand in a db with 5000 records. I get no results unless I set my $myFind->setRange(0,500); , which only returns the first 500. 500 seems to be a cut-off point for some reason, Is this a thing? Also, I want a varCount that doesn't refresh back to '1' when the next 500 records are displayed, i.e. the next record numbers should say 501, 502... Thanks again!
  12. Hi, I have several fields I'd like to sort that are empty, like Email. Here are 2 snippets of code that are not returning results: $RandyFind->addFindCriterion("Email", ''); or $RandyFind->addFindCriterion("Email", "=="); Any thoughts? Also, is there a way to force null into a field when editing? Thanks a Bunch!!
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.