Jump to content

Mark Johnson

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Mark Johnson

  • Rank
  1. Well as for moving all the files into separate tables or one solution that would be next to impossible. Not Impossible but next to. It would be extremely time consuming. Its been added to by so many people that its just gotten out of hand but to go and do all that into one solution and all wouldnt be very good. Its all to intertwined together plus we have c# apps that connect to the different solutions that would have to be re programmed to accommodate it. The only reason i was gonna put them into a function is to not use something that can be put into a function if that code is being use
  2. Well the reasoning with the table of logins is its not for internal use its for a client website for our clients to login and we arent talking just a few, were talking about a few 1000 or more. Now granite we only have about 5 or so logging in at any given moment.  Right now we have a .fmp12 file that is slated for IWP in filemaker 12 that is in general just a portal meaning it only has 1 table but references all our other filemaker files via relationships. the reason why its multiple files is this is a database that has been built and added on since filemaker 5 and im the one dealing wi
  3. Im looking at creating a connection class for connecting to the different databases that ill be needing to connect to to query for data and not familiar with classes much but found this one im trying to figure out. How do i get it to work properly and return to me what i need and also that it did connect successfully? as well as being able to use it for other filemaker databases i need to connect to? The connection details below is example but ill connect to logins.fmp12 first to check the users credentials with a table that has their login and password info then if success and they
  4. I have a Searchloads.php file that is showing a lsit of my records im pulling from filemaker. right now its hardcoded to sort records based on two fields. How do i allow the user to sort records based on what they choose in a drop down menu? Or maybe two sort drop down menus? and if the second isnt set then it just works off the first one.
  5. below is some code that i loop through records creating an unordered list. basically a table just in list form. What i want to do is in the url i have a variable being passes called page= and whatever page number i get at that time. I have a css style that when im on a specific page the pagination link that corresponds to that page should be green so i know by looking at pagination links what page im on instead of looking at the url for page number. how do i do that? $n = 1; while ($n <= $totalLinks and $totalLinks > 1) if ($page ==
  6. One more question, how to i write that fmpTrapError2 function to not only go to an error page but also give me a url in a variable that i can echo out to that go back to previous page button so they can click the button and go back if i wanted them to? obviously i have the navigation so they can click whatever but id like to have it just in case.
  7. ok i got it to redirect finally. it was an error on my error.php page with session start etc on top with a redirect back to login which was working correctly. My only issues now is, and i've uploaded the updated pages, is on line 24 or so, theres an fmpTrapError2 function that im passing my own message into along with the error code that doesnt seem to work properly on the error page. Not sure if im doing it right or not in the function. Functions.php error.php login.php
  8. still having issues. I rearranged the getrecords() function to go below the Filemaker::iserror($result) and it doesnt give me the above error but the fmpTraperror or fmptraperror2 not the standard header redirect doesnt go to the error page like its suppose to. fmpTrapError is the standard error function that gives me filemaker's errors but i modified it with fmpTrapError2 to pass my own errors if i want to so if someone can look at that and make sure im doing it right that would be great. error.php login.php Functions.php defines.php
  9. the error i get is Fatal error: Call to undefined method FileMaker_Error::getRecords() in /home/mjohnson/public_html/ergo/login.php on line 101. Yea i have it commented out for now but if i re-enable fmpTrapError($result, "error.php"); function then i get the above if it try to login with the wrong credentials but if i login with correct credentials then it redirects to LoginSuccessfull.php like its suppose to.
  10. Ive attached my code pages. The issue i have is if the login credentials is correct it redirects great but of not then it doesn't work and displays an error of below. Whats goin wrong? I used some of the functions from a plugin that i own to play with and they work just not if its wrong login. login.zip
  11. Ive got a similar issue but ive got a PC running FM server 12 adv on my network and ive got FM go 12 on my ipad connected to the same network via wireless. I add my PC to the list on FM go 12 with its ip address but i can see any of the files on it. All my files i can see if i use open remote on FM Client 12 on any computer on the network running FM client 12 but my ipad wont see them. Even if i try to manually type the name in the field it says host either unavailable or file not found error. windows firewall says its disabled and my antivirus is disabled as well. What can be the issue?
  12. I downloaded a file that uses the reactor plugin. I was looking at the functions of it and was trying to use the slider function for sliding from one record to another via the slider bar. I have the plugin inside of a webviewer and can use the slider and slide from left to right and vice versa but how do you get it to slide from one record to another either on found set or show all records? Also is there anymore detailed documentation that actually shows you how to use the plugins and how to set them up otehr than what little info i found on their website? Mark
  13. One quick question. After you select the items in the portal rows you want and you perform what ever script you need to perform with them, how do you get them to deselect or un highlight?
  14. I have a database that has a table with a list of techs and the contact info for them but also have a seperate table that has a list of all my clients. what i want to do is on the main page of the database that gives me an overview of the client, i have a portal that lists all the techs that are associated with the state that my client is in but i want to be able to have a field calculation that i can do that will show the distance between the location of the tech and the location of the client based on the city and state between each so that i can scroll throught the list and find the techs t
  15. But how do i sum up the monthly premium amount on a weekly basses so i can see how much i am pulling in so far? I need to sum up the monthly premium amount for all records created each week in a weekly column but also sum up the same monthly premium field on a monthly bases. I need to break it down per day, week, month and year. Ive attached a jpg of the layout. the text in red is my notes. I hope this helps some. The monthly summary on the layout now is already done but i tried to figure out what was done and can't. I guess in a nutshell, How do you do a summary for a price field based o
  • Create New...

Important Information

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