[FX.php List] foundcount: -1
David Ness
dness at bondedbuilders.com
Fri Apr 6 07:18:37 MDT 2007
I have thought for awhile now that -1 for foundcount was typical. I
always check to see if (foundcount < 1) rather than (if foundcount = 0)
to determine if no records were returned by a query.
--
David Ness,
Database Systems Programmer
Bonded Builders Warranty Group
1500 Kings Highway
Port Charlotte, FL 33980
800.749.0381 x3123 (National Toll Free)
941.255.3274 x3123 (Local)
-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Alex Gates
Sent: Friday, April 06, 2007 9:09 AM
To: 'FX.php Discussion List'
Subject: [FX.php List] foundcount: -1
Hi everyone:
I'm trying my hand at installing FileMaker Server 8 advanced using IIS
on XP Pro.
Have any of you ever gotten a foundcount of -1 on a simple query test
using fx.php?
Here is my returned array:
Array ( [data] => Array ( ) [linkNext] => [linkPrevious] => [foundCount]
=> -1 [fields] => Array ( ) [URL] =>
http://****:****@localhost:80/fmi/xml/FMPXMLRESULT.xml?-db=Web_Cookbook_
Dev2.fp7&-lay=Login&-max=50&-findany [query] => [errorCode] => No Action
Taken [valueLists] => Array ( ) ) foundcount: -1
Any suggestions?
Alex
-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Gjermund
Gusland Thorsen
Sent: Thursday, April 05, 2007 5:09 PM
To: adenman at tmea.org; FX.php Discussion List
Subject: Re: [FX.php List] New to FX: A few basic questions
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
>
_______________________________________________
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