fmwebschool.com
Top Experts [learn more]Top 4-10
webko

9743 K
bandmandq

2458 K
Genx

1525 K
4. tcmeyers
5. kbata
6. Martie
7. Hammerton
8. rrenfrow
9. bneeman
10. plegler
Welcome, Guest. Please login or register.
March 02, 2015, 08:36:52 PM

Login with username, password and session length
Search:     Advanced search
Welcome to the FileMaker Web Masters Exchange.  If you have any questions about how to use this forum, please watch the getting started movie at:
http://www.fmwebschool.com/movies/forum1/forum1.html
27858 Posts in 6162 Topics by 1525 Members
Latest Member: alkyred
* Home Help Search Calendar Login Register
+  fmwebschool.com
|-+  Recent Posts
Pages: [1] 2 3 ... 10

 1 
 on: Today at 06:27:05 AM 
Started by gwjo - Last post by gwjo
I'm struggling to get a new connection with table based login to work:
I've set up the site without any problems, gone to add FMStudio Pro connection with table based login and I get as far as selecting the database of interest. It finds the database, the test says the connection was made successfully, it gives the login page as login.php but no layouts in the pulldown menu (and also thus no user name or password fields).
Any suggestions on what I might have missed or what I can check gratefully received!
Regards,
George

 2 
 on: February 15, 2015, 03:48:16 AM 
Started by cooldude - Last post by kimosabi
Did this ever get solved?  I am having a similar problem with IIS on server 2008 R2 sp1.  I can actually write php code by hand using the fmstudio pro class and have it return results but not have all the automated things work.  I do believe this to be a permission issue in IIS but I have compared the settings on this new server to another one that I had been upgrading versions on over the years and did not see where the discrepancy exists. I can keep hand-coding but it sure would be nice to be able to use the features of fmstudio pro that we paid for.

 3 
 on: January 29, 2015, 05:59:05 PM 
Started by cooldude - Last post by cooldude
ok getting somewhere...

I see that I can use this
$emp_result->getRecords();

with sort like below...


and this gets me 1 field sorted - NICE...

Q: but how do I sort on 2 or more fields with this or another php command?


 <?php
         

 // sort by last name
 usort($emp_result->getRecords(),
 function ($a, $b) {
     return strcmp(
         $a->getField(‘LastName’),
         $b->getField('LastName')
     );
 });
 
 ?>


 4 
 on: January 29, 2015, 03:38:32 PM 
Started by cooldude - Last post by cooldude
Hi - not really knowing what I am doing here - but when I did a --- print_r($test_result->getRecords());


it shows what is below....

Q: any idea how to POST PROCESS SORT THIS --- $test_result->getRecords() or just --- $test_result Huh

---


Array (
  • => FileMaker_Record Object ( [_impl] => FileMaker_Record_Implementation Object (
  • [_fields] => Array ( [Date Entered] => Array (
  • => 05/05/1997 ) [Date Mod] => Array (
  • => 06/05/2008 ) [Name] => Array (
  • => xxx ) [SAP_ID] => Array (
  • => 17 ) [Address] => Array (
  • => xxx ) [City] => Array (
  • => Bakersfield ) [State] => Array (
  • => Ca. ) [Zip] => Array (
  • => 93301 ) [First] => Array (
  • => ) [Last] => Array (
  • => ) ) [V5e7ec2d5] => Array ( ) [_recordId] => 17 [_modificationId] => 3 [_layout] => FileMaker_Layout Object ( [_impl] => FileMaker_Layout_Implementation Object ( [_fm] => FileMaker_Implementation Object ( [V73ee434e] => Array ( [charset] => utf-8 [locale] => en [logLevel] => 3 [hostspec] => xxx [recordClass] => FileMaker_Record [prevalidate] => [database] => page1


etc.

 5 
 on: January 29, 2015, 01:48:39 PM 
Started by cooldude - Last post by cooldude
? HOW DO I SORT THESE RESULTS ?

ANOTHER METHOD - but needs SORTING!!!


Q: How do I sort this special query?

here's another way I got the combined result....

----------



I needed to do a special fmstudio query


- needed complex search so I did this

- basic fmstudio query finds just one person id (which will not fail) do not need this data - just for not fail

- RAN SCRIPT like this - gets complex query fine... ---  $emp_find->SetScript('script1','=='.$params_here);

--then had  this but SORT does NOT WORK ........
$emp_find->addSortRule('lastname',1,FILEMAKER_SORT_ASCEND);



– so my results loop ok -  BUT NO SORT!

- i even tried putting a sort step in the FM script

- no sort seems to work

- I even looked into post process resorting the results after getting the query (array_multisort Huh?) but can't seem to get it working....



Q: How do I fix this issue and get the results to sort how I need them??


 6 
 on: January 29, 2015, 01:45:26 PM 
Started by cooldude - Last post by cooldude
You do two queries, and then combine the data arrays after (assuming they are using the same fields...), and then display the combined set

Thanks much webko

sounds good - a few questions

I'm confused by fmstudio query items

my query called = emp
and query 2 = emp2...

------------------


1 - $emp_result = $emp_find->execute();

2 -  $emp_row = current($emp_result->getRecords());

then I loop through like this on ....

<?php foreach($emp1_result->getRecords() as $emp1_row){ ?>
display here…
<?php } ?>

Q: so what method do I use to COMBIME THEM both emp1 and emp2?

Q: THEN what function do I use to SORT the final array?

these =  array_merge() to merge both arrays ---- and usort() for sorting the merged array?


not sure how to set this up....


Thanks in advance for you're help

 7 
 on: January 26, 2015, 09:30:16 PM 
Started by cooldude - Last post by webko
You do two queries, and then combine the data arrays after (assuming they are using the same fields...), and then display the combined set

 8 
 on: January 23, 2015, 01:28:53 PM 
Started by cooldude - Last post by cooldude
Thanks for you help jmrusch.

 9 
 on: January 23, 2015, 01:27:31 PM 
Started by cooldude - Last post by cooldude
Make the size of the found set 1, or do a foreach that only allows 1 loop.


So simple - thanks webco!!!

 10 
 on: January 23, 2015, 01:26:35 PM 
Started by cooldude - Last post by cooldude
Hi all,

I need to do a simple but double query like

1 - find recordset 1
2 - expand found set with additional find

- then have that show as just one combined query to display on web with fmstudio

EX:

1 find this - people from CA
2 ADDITIONAL expand found set people from AZ and last name JONES (what ever)

easy to do in filemaker - how do you do this with fmstudio?


ALSO - maybe I can run a script along with the query ? but what would be the best way to set this up and use this?


Thanks - dave














Pages: [1] 2 3 ... 10
Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!