[FX.php List] New to FX: A few basic questions

Thu Apr 5 16:08:31 MDT 2007

If you need OLAP features you have to use layouts as cubes.

ggt667

On 4/5/07, Andrew Denman <adenman at tmea.org> wrote:
> 2. Is data entry FM session based or transaction based?
>
> If you're asking the question I think you are, the answer is that it is
> transaction based.  Each find, add, edit, and delete you make through FX.php
> is completely separate from each other.
>
> Andrew Denman
> TMEA IT Administrator
> 1-888-318-TMEA x109
> Fax: (512) 451-9213
> www.tmea.org
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Vision Computer
> Consulting
> Sent: Thursday, April 05, 2007 1:19 AM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] New to FX: A few basic questions
>
> Excuse me. I left something out of the question. I meant to say:
>
> > I have worked extensively with PHP session variables and yes they
> > work great. Are you talking about PHP sessions and not FMP sessions?
> Doesn't the add,update, delete look like a transaction to FM even
> when it is done within a PHP session?
>
>
> On Apr 4, 2007, at 11:09 PM, Vision Computer Consulting wrote:
>
> > I have worked with extensively with PHP session variables. Are you
> > talking about PHP sessions and FMP sessions?
> >
> > On Apr 4, 2007, at 7:31 PM, Bob Patin wrote:
> >
> >> I second others' advice not to use scripts if at all possible with
> >> PHP. So far I've been able to do some fairly complex things with
> >> PHP without any scripting; between the wealth of PHP scripts and
> >> functions available on the web, and PHP's flexibility when
> >> compared to CDML or Lasso, I think you'll quickly find it to be
> >> much easier to work with.
> >>
> >> Look into session variables; they're immensely valuable and very
> >> easy to use; not having to deal with tokens as I did with CDML was
> >> such a relief!
> >>
> >> Have fun!
> >>
> >> Bob Patin
> >> Longterm Solutions
> >> bob at longtermsolutions.com
> >> 615-333-6858
> >> http://www.longtermsolutions.com
> >>
> >>   CONTACT US VIA INSTANT MESSAGING:
> >>      AIM or iChat: longterm1954
> >>      Yahoo: longterm_solutions
> >>      MSN: tech at longtermsolutions.com
> >>      ICQ: 159333060
> >>
> >>
> >> On Apr 4, 2007, at 8:11 PM, Vision Computer Consulting wrote:
> >>
> >>> Thank you Kevin and Alex for your help.
> >>>
> >>> Here is a link to FM error codes,
> >>> http://www.briandunning.com/error-codes/?source=FileMaker
> >>>
> >>> Stephen Calia
> >>> Vision Computer Consulting
> >>> info at visioncomputerconsulting.com
> >>>
> >>>
> >>> On Apr 4, 2007, at 5:49 PM, Kevin Futter wrote:
> >>>
> >>>> On 5/4/07 10:09 AM, "Alex Gates" <alex at gandrpublishing.com> wrote:
> >>>>
> >>>>> Hi Stephen-
> >>>>>
> >>>>> I can only help with one of your questions as I'm relatively
> >>>>> new to this
> >>>>> as well.
> >>>>>
> >>>>> The answer to 1 is yes.  The field that you are retrieving data
> >>>>> from has
> >>>>> to be on the layout you specify.
> >>>>>
> >>>>> Sorry I can't help with anything else -
> >>>>>
> >>>>> Alex
> >>>>>
> >>>>> Vision Computer Consulting wrote:
> >>>>>> 1. I was a lasso programmer who has been doing PHP/MySQL for
> >>>>>> the last 4
> >>>>>> years, but I remember that we created a layout that had all
> >>>>>> fields on it
> >>>>>> to make them accessible to lasso. What I have noticed is that,
> >>>>>> unless
> >>>>>> the related field is on the layout you are accessing, data in
> >>>>>> that field
> >>>>>> can't be retrieved. I know that in recent versions of
> >>>>>> Filemaker one can
> >>>>>> grab data from many layers of related layouts.
> >>>>>>
> >>>>>> That is a long way of asking whether the field you are
> >>>>>> retrieving data
> >>>>>> from has to be on the layout you specify in SetDBData?
> >>>>>>
> >>>>>> 2. Is data entry FM session based or transaction based?
> >>>>>>
> >>>>>> 3. I am using PHP to do data validation (especially  date and
> >>>>>> time). Any
> >>>>>> hints on how to format date and time in such a way that FM
> >>>>>> won't throw
> >>>>>> and error? How do I setup Filemaker to best accept date and time
> >>>>>> information?
> >>>>>>
> >>>>>> 4. Is it a good idea to run FM scripts from FX? If so, any
> >>>>>> suggestions
> >>>>>> on when it might appropriate to use FX to run an FM script?
> >>>>>>
> >>>>>> Thank you in advance for your help.
> >>>>>>
> >>>>>> Stephen Calia
> >>>>
> >>>> 1. Alex is right - all fields (and value lists) you need must be
> >>>> on the
> >>>> layout you specify.
> >>>>
> >>>> 2. I'm not sure - I assume it's transacted-based, but that's
> >>>> just an
> >>>> educated guess.
> >>>>
> >>>> 3. Normally FM accepts dates separated only by periods (.) or
> >>>> forward-slashes (/). IIRC, anything else is invalid for a
> >>>> FileMaker date -
> >>>> off the top of my head mind. Your safest be is just to make sure
> >>>> that any
> >>>> dates you submit to FM are formatted that way. Remember,
> >>>> everything you pass
> >>>> to FM (or *any* database) via the web is a string, FM makes it
> >>>> into whatever
> >>>> data type is specified by the target field definition, as long
> >>>> as it
> >>>> qualifies.
> >>>>
> >>>> 4. No, it's best to avoid running internal FM scripts from the
> >>>> web, for a
> >>>> variety of reasons - they can compromise security, there can be
> >>>> data sync
> >>>> issues, they can be expensive server-side and slow down the
> >>>> transaction
> >>>> queue, etc. I've done it, but only as a last resort.
> >>>>
> >>>>
> >>>> --
> >>>> Kevin Futter
> >>>> Webmaster, St. Bernard's College
> >>>> http://www.sbc.melb.catholic.edu.au/
> >>>>
> >>>>
> >>>>
> >>>> ###################################################################
> >>>> ##################
> >>>> This e-mail message has been scanned for Viruses and Content and
> >>>> cleared
> >>>> by MailMarshal
> >>>> ###################################################################
> >>>> ##################
> >>>>
> >>>> This e-mail and any attachments may be confidential. You must
> >>>> not disclose or use the information in this e-mail if you are
> >>>> not the intended recipient. If you have received this e-mail in
> >>>> error, please notify us immediately and delete the e-mail and
> >>>> all copies. The College does not guarantee that this e-mail is
> >>>> virus or error free.  The attached files are provided and may
> >>>> only be used on the basis that the user assumes all
> >>>> responsibility for any loss, damage or consequence resulting
> >>>> directly or indirectly from the use of the attached files,
> >>>> whether caused by the negligence of the sender or not. The
> >>>> content and opinions in this e-mail are not necessarily those of
> >>>> the College.
> >>>>
> >>>> _______________________________________________
> >>>> FX.php_List mailing list
> >>>> FX.php_List at mail.iviking.org
> >>>> http://www.iviking.org/mailman/listinfo/fx.php_list
> >>>>
> >>>
> >>>
> >>>
> >>>
> >>> _______________________________________________
> >>> FX.php_List mailing list
> >>> FX.php_List at mail.iviking.org
> >>> http://www.iviking.org/mailman/listinfo/fx.php_list
> >>
> >> _______________________________________________
> >> FX.php_List mailing list
> >> FX.php_List at mail.iviking.org
> >> http://www.iviking.org/mailman/listinfo/fx.php_list
> >>
> >
> > _______________________________________________
> > FX.php_List mailing list
> > FX.php_List at mail.iviking.org
> > http://www.iviking.org/mailman/listinfo/fx.php_list
> >
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>