Jump to content

Chris Scalzi

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Chris Scalzi

  • Rank
  • Birthday 10/30/1980

Profile Information

  • Gender
  • Location
    Queens, NY
  • Interests
    Photography & Technology.

    But mostly coffee. ALL, of the coffee.

    My photography company:

Contact Methods

  • Website URL
  • Skype

Recent Profile Visitors

2,873 profile views
  1. Sorry, i typed sort by accident , I meant search. I think I've realized that the problem has nothing to do with Virtual Lists and is entirely a question on how to search for data that is within a portal.
  2. There are some great examples in here, and yes they are all searchable. If the data was in a portal the only way I can think of searching it would be to define a portal filter by a variable and then have it sort by that field.
  3. Thanks for this example file Bruce! I must admit I'm still deconstructing it. I notice that you are using field repetitions instead of a variable array, is there a benefit to this method or is this just another way of doing it?
  4. When I wrote "eSQL" I was referring to the ExecuteSQL function which I am using to gather my data for the Virtual List. Thinking about it further the biggest issue I am having is that my Virtual List is within a Portal and I need to be able to search the Portal. I am thinking this is more of a Portal searching issue than a Virtual List issue. Does that make sense?
  5. I'm not sure if this has been answered before but I'm trying to figure out if there is any way of making a virtual list searchable. I can create buttons that will modify the eSQL search and add parameters to the search in a fairly complex way but I'm talking about just hitting the search button and searching within the table. I know that calculation fields cannot be searched, I have also attempted to make a text field with a calculated result with full indexing and it seems to still not be working. Any thoughts?
  6. @BruceR I just referenced this post for a project I'm working on. Great stuff, and thanks!
  7. If the open script doesn't run on this particular solution more than just the names would get messed up. I have a variety of variables and settings that are grabbed for the database session that are necessary for the core functionality for the solution. The names are in two places: 1. The OS X Open Directory server where you could only log in as Full Name or Short Name. That is secured by physically being locked in a server cabinet, then software locked on the local level and on the OD level for Server Account access. Various groups in the OD are linked to the filemaker pro security group
  8. I realize this topic was nearly two years about now but I came accross this problem and at the very least found a solution that I was happy with for consistently reporting what the username was. Since the other way of authenticating was the long name in the Open directory the way to differentiate them was always that one contained a space between the first and last name and the other ( the short name ) had no spaces. So I did indeed "register" each user with my database by way of adding the short name to their individual record within the database and then called it up on the database open
  9. Interesting. This sounds like it might be the solution. I will work to implement this and let you know how it goes. Thank you so much for you advice on this!
  10. It is simply easier for the schools administration to keep track of it starting from 1 each year. The numbers would quickly go into the thousands and get annoying to track from them. It's hard to explain because I'd have to go into the lottery process for how children are chosen which is also prioritized by sibling, district, etc. Yes there is another table that contains the lottery info for that year and grade. Example "2014-2015-k" for the kindergarten lottery for this upcoming school year.
  11. I'm not completely certain if this is the right section for this problem / question. I have a situation where I need to make sure that a field in one of my tables has a unique number under certain circumstances. I have student information system which has a lottery module I built so that they can manage student applications for the coming year. Each student once entered into the database is assigned a lottery number and associated with a specific lottery which is associated with the school year and the grade they are applying for. When each student is entered they are given a lottery numbe
  12. Back from outer space (Florida), and ready to code.

  13. Thanks Dan! I ended up adding your suggestion as well as quoting the values of my variables and double checking my white space. My final code ended up being: Let ( [ x = "1"; y = "2013"; $query = " SELECT "_pkLotteryRecordID" FROM Lottery WHERE LotteryGrade = ? AND LotteryYearOnly = ? "; $result = ExecuteSQL ( $query ; "" ; "" ; x ; y ) ]; $result )
  14. I have a question which might just come down to improper syntax. I'm giving my first attempt at using the ExecuteSQL command and I've gone through some of the primers (specifically the one by Beverly) but I am having trouble with what seems like a basic query. I'm attempting to find the primary key of my record in a table using two fields and their data. Here's what I got: Let ( [ x = 1; y = 2013; $query = " SELECT _pkLotteryRecordID FROM Lottery WHERE LotteryGrade = ? AND LotterYearOnly = ? " ; $result = ExecuteSQL ( "$query"; "" ; "" ; x ; y )
  15. This place rocks, so glad I found it!

  • Create New...

Important Information

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