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

Andrew Denman adenman at tmea.org
Thu Apr 5 09:42:02 MDT 2007


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



More information about the FX.php_List mailing list