I tried using the straight php code:
$resultID = mysql_query("SELECT * FROM dailypays");
for ($x= 0; $x < mysql_num_rows($resultID); $x++)
{
$row = mysql_fetch_assoc($resultID);
...
$this->set('row',$row);
-----------------
this produced the same results. This (other than the $this->set() )
did not use any cakePHP
Any answers anybody?
On Sep 29, 12:48 am, Conrad <[EMAIL PROTECTED]> wrote:
> Deleted tmp (cache/models - only files there) and swiched debug to 2.
> No difference noted.
> Conrad
>
> On Sep 29, 12:10 am, AD7six <[EMAIL PROTECTED]> wrote:
>
> > On Sep 29, 6:57 am, Conrad <[EMAIL PROTECTED]> wrote:
>
> > > I have a table that is filled by program. This table contains field
> > > named "check_num" that contains data in the table, but is not being
> > > read out.
>
> > > $result = $this->Dailypay->findAll();
>
> > > $this->set('row',$result);
>
> > > This returns the following: (only one record displayed)
> > > Array
> > > (
> > > [0] => Array
> > > (
> > > [Dailypay] => Array
> > > (
> > > [id] => 82
> > > [patient_id] => 10
> > > [lname] => Rodrigues
> > > [fname] => Moma
> > > [add1] => 1234 112th At
> > > [add2] =>
> > > [add3] =>
> > > [city] => Tacoma
> > > [state] => WA
> > > [zip] => 98387
> > > [phone] => 253-802-4512
> > > [provider_name] => Family Medical Clinic - Logan
> > > [provider_id] => 10
> > > [mrn] => 1853249
> > > [b_name] => Left Bank of the River
> > > [b_city] => Tacoma
> > > [b_state] => WA
> > > [routing] => 125108159
> > > [account] => 1234589
> > > [payment] => 75.00
> > > [fee] => 3.75
> > > [balance] => 0.00
> > > [check_num] => <========
> > > Notice NOT in Array
> > > [last_pay_date] => 0000-00-00
> > > [fee_type] => 0
> > > )
>
> > > Data from the table, dumped as a yaml (again only one record shown)
> > > 1:
> > > id: 82
> > > patient_id: 10
> > > lname: Rodrigues
> > > fname: Moma
> > > add1: 1234 112th At
> > > add2:
> > > add3:
> > > city: Tacoma
> > > state: WA
> > > zip: 98387
> > > phone: 253-802-4512
> > > provider_name: Family Medical Clinic - Logan
> > > provider_id: 10
> > > mrn: 1853249
> > > b_name: Left Bank of the River
> > > b_city: Tacoma
> > > b_state: WA
> > > routing: 125108159
> > > account: 1234589
> > > payment: 75.00
> > > fee: 3.75
> > > balance: 0.00
> > > check_num: EZ10082 <========== Notice, in Table
> > > last_pay_date: 2007-09-28
> > > fee_type: 0
>
> > > Note: There is data in check_num, but it is not being read by
> > > "$result = $this->Dailypay->findAll();"
>
> > > Anybody any ideas?
>
> > Delete your tmp files (not folders) or switch debug to >0 temporarily.
>
> > hth,
>
> > AD
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
