[FX.php List] MySQL and FX.php help needed - MORE INFO AGAIN

[Marisa Smith]

One more update on this -

I figured out a workaround for the -edit issue for now - I just added  
another call to find the record I just edited using the primary key.

I also figured out a workaroud for the -new issue - I'm returning  
mysql_insert_id() after I create the record and then using that to  
load the newly created record.

So I can at least roll this out to the client today as planned.  It  
would still be awesome if FX returned the data so that I don't have  
to use different code for FM vs. MySQL.

Thanks in advance for your help on this!

Marisa

On Aug 15, 2007, at 3:38 PM, Marisa Smith wrote:

> Hi Chris-
>
> Thanks for taking a look at this.  Not sure if this is a hint or  
> not, but if I echo back $theResult on line 875 of FX.php it comes  
> up as "1" instead of Resource id #xxx like it does on the other  
> types of actions.
>
> I noticed in the PhP documentation that it says this about the  
> mysql_query() function:
>
> 	For other type of SQL statements, UPDATE, DELETE, DROP, etc,  
> mysql_query() returns TRUE on success or FALSE on error.
>
> So I wonder if you need to generate a select statement to go find  
> the updated row via the recID (data key) and feed that back to  
> return data?
>
> I know just enough to be dangerous so I don't want to attempt this  
> myself....
>
> - Marisa
>
> On Aug 15, 2007, at 2:35 PM, Chris Hansen wrote:
>
>> Marisa,
>>
>> My guess is that this may be an FX.php bug, but I won't have time  
>> to look until this evening.  Best,
>>
>> --Chris Hansen
>>   FileMaker 8 Certified Developer
>>   FileMaker 7 Certified Developer
>>   Creator of FX.php
>>   "The best way from FileMaker to the Web."
>>   www.iViking.org
>>
>>
>> On Aug 15, 2007, at 11:48 AM, Marisa Smith wrote:
>>
>>> I also discovered this seems to happen not only with editing a  
>>> record, but also after creating a new record or deleting a record/ 
>>> row.  In each case, I get the 2 warnings referenced below, and  
>>> there is nothing in the ['data'] array coming back from FX.   In  
>>> all cases, the records get created, deleted, and edited in the  
>>> MySQL database as expected, so I'm kind of stumped.
>>>
>>> Thanks.
>>>
>>>
>>> On Aug 15, 2007, at 1:21 PM, Marisa Smith wrote:
>>>
>>>> I'm using FX.php with MySQL for the first time.   I'm having  
>>>> trouble with editing a record and returning data from FX.   The  
>>>> record in MySQL *IS* edited appropriately, but the ['data']  
>>>> array being returned is empty.  I'm also getting these 2 errors:
>>>>
>>>>
>>>> Warning: mysql_affected_rows(): supplied argument is not a valid  
>>>> MySQL-Link resource in /Library/WebServer/Documents/brainstem/FX/ 
>>>> FX.php on line 881
>>>>
>>>> Warning: mysql_fetch_assoc(): supplied argument is not a valid  
>>>> MySQL result resource in /Library/WebServer/Documents/brainstem/ 
>>>> FX/FX.php on line 887
>>>>
>>>> I tried explicitly setting the $returnedDataArray to true when I  
>>>> call FMEdit('true', 'full'); but it's still not returning  
>>>> anything.   Any ideas would be greatly appreciated!
>>>>
>>>> FYI:  Here is the query being sent in by FX:
>>>>
>>>>
>>>> UPDATE Cases SET PhoneCallerLastName = 'Smith',  
>>>> PhoneCallerNumber = '(734) 555-1212', PhoneCallDate =  
>>>> '2007-08-10', PhoneCallLogDate = '2007-08-12',  
>>>> PhoneCallerFirstName = 'Fred', TrackingItemDetails = 'Test  
>>>> details again.', RecipientContactKey = '13' WHERE key_ = '42';
>>>>
>>>> Sorry if I'm not explaining this well.
>>>>
>>>>
>>>>
>>>> Thanks.
>>>> ------------------------------------------------------------------- 
>>>> -
>>>> Marisa Smith, Partner
>>>> DataSmith Consulting
>>>> - a Division of The Whole Brain Group, LLC
>>>>
>>>> P.O. Box 8275
>>>> Ann Arbor, MI 48107
>>>> 734.929.0431 - phone
>>>> 734.929.0058 - fax
>>>> marisa at datasmithconsulting.net
>>>> www.datasmithconsulting.net
>>>> _______________________________________________
>>>> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070816/a49662ee/attachment.html