[FX.php List] Different results on 2 installations of same DB and
sctipt
Vision Computer Consulting
info at visioncomputerconsulting.com
Sat Apr 28 15:59:38 MDT 2007
DEBUG gives me the following, but not sure what it is telling me:
XML Parsing Error: no element found
Location: http://Admin:@192.168.0.101/fmi/xml/FMPXMLRESULT.xml?-
db=RAM.fp7&-lay=shopping&-
max=50&warranty_type=basic&session=6c368bc448ee873637176e63e1fd62b3&-
find
Line Number 1, Column 2273:<?xml version="1.0" encoding="UTF-8"
standalone="no"?><!DOCTYPE FMPXMLRESULT PUBLIC "-//FMI//DTD
FMPXMLRESULT//EN" "/fmi/xml/FMPXMLRESULT.dtd"><FMPXMLRESULT
xmlns="http://www.filemaker.com/fmpxmlresult"><ERRORCODE>0</
ERRORCODE><PRODUCT BUILD="11/14/2005" NAME="FileMaker Web Publishing
Engine" VERSION="8.0.2.65"/><DATABASE DATEFORMAT="MM/dd/yyyy"
LAYOUT="shopping" NAME="RAM.fp7" RECORDS="11" TIMEFORMAT="HH:mm:ss"/
><METADATA><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="id"
TYPE="NUMBER"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="session"
TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="warranty_type"
TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="warrantyID"
TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="quantity"
TYPE="NUMBER"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="timestamp"
TYPE="TIMESTAMP"/><FIELD EMPTYOK="YES" MAXREPEAT="1"
NAME="warranties_new::id" TYPE="TEXT"/><FIELD EMPTYOK="YES"
MAXREPEAT="1" NAME="warranties_new::cat" TYPE="TEXT"/><FIELD
EMPTYOK="YES" MAXREPEAT="1" NAME="warranties_new::name" TYPE="TEXT"/
><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="warranties_new::name_sub"
TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1"
NAME="warranties_new::order" TYPE="NUMBER"/><FIELD EMPTYOK="YES"
MAXREPEAT="1" NAME="warranties_new::price" TYPE="NUMBER"/><FIELD
EMPTYOK="YES" MAXREPEAT="1" NAME="warranties_new::online_discount"
TYPE="NUMBER"/><FIELD EMPTYOK="YES" MAXREPEAT="1"
NAME="warranties_new::trade_price" TYPE="NUMBER"/><FIELD
EMPTYOK="YES" MAXREPEAT="1" NAME="warranties_new::trade_discount"
TYPE="NUMBER"/><FIELD EMPTYOK="YES" MAXREPEAT="1"
NAME="warranties_new::discount" TYPE="TEXT"/><FIELD EMPTYOK="YES"
MAXREPEAT="1" NAME="property_info::confirmation_number" TYPE="TEXT"/
></METADATA><RESULTSET FOUND="2"><ROW MODID="0"
RECORDID="175"><COL><DATA>174</DATA></
COL><COL><DATA>6c368bc448ee873637176e63e1fd62b3</DATA></
COL><COL><DATA>basic</DATA></COL><COL><DATA>sfrhw</DATA></
COL><COL><DATA>1</DATA></COL><COL><DATA>04/28/2007 14:48:20</DATA></
COL><COL><DATA>sfrhw</DATA></COL><COL><DATA>basic</DATA></
COL><COL><DATA>Single Family Residence</DATA></COL><COL><DATA></
DATA></COL><COL><DATA>1</DATA></COL><COL><DATA>255</DATA></
COL><COL><DATA>10</DATA></COL><COL><DATA>40</DATA></COL><COL><DATA>0</
DATA></COL><COL><DATA>yes</DATA></COL>
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----------------------
On Apr 28, 2007, at 12:36 PM, Jonathan Schwartz wrote:
> Can you turn on DEBUG to see what the actual query looks like on
> succesfull queries vs non-succsessful queries?
>
>
> define("DEBUG", true);
>
> Jonathan
>
>
>
>> Error code come back the first time as 401 (to be expected), but
>> then the error code doesn't show up on subsequent finds on the cart.
>>
>> On Apr 28, 2007, at 12:19 PM, Bob Patin wrote:
>>
>>> So other finds work on the web?
>>>
>>> Did you try returning the error code? $findResult['errorCode']
>>>
>>>
>>> On Apr 28, 2007, at 2:14 PM, Vision Computer Consulting wrote:
>>>
>>>> I am getting data on some cases. I am populating page content
>>>> from the db and that works. What is not working is finding
>>>> recording in my shopping cart records. I can search the db
>>>> manually and find the record I am looking for, but not through
>>>> FX. That is the only part that doesn't work. Other Finds work.
>>>>
>>>>
>>>
>>> _______________________________________________
>>> 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
>
>
> --
> Jonathan Schwartz
> Exit 445 Group
> jonathan at exit445.com
> http://www.exit445.com
> 415-381-1852
> FileMaker 8 Certified Developer
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070428/d01105c8/attachment.html
More information about the FX.php_List
mailing list