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

[Marisa Smith]

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

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