php - Zend DB: null values -

-

i appreciate if 1 explain why query returning null values. this query works fine when use fetchrow() method.

public function getcustomerrowwithaddress($customer_id) {      $select = $this->select()->setintegritycheck(false);      $select->from('irh_tv.irh_site_location sl', array('name location_name', 'start_date', 'end_date', 'service_pack_id', 'stb_id'));     $select->joinleft('irh_tv.irh_customers c', 'c.customer_id = sl.customer_id , c.active = 1 , c.site_id = sl.site_id',          array('customer_id','surname', 'title', 'site_id', 'first_name', 'company', 'business_no', 'home_no', 'mobile_no', 'email', 'address_id'));     $select->joinleft('irh_tv.tv_stb_data tv', 'tv.site_id = sl.site_id , sl.stb_id = tv.id', array('user_id mac_address'));     $select->joinleft('irh_tv.irh_address ad', 'c.address_id = ad.id', array('address_line1', 'address_line2', 'town', 'county', 'country', 'postcode'));     $select->where("sl.customer_id = $customer_id");        //if($_request['d'] == 1) { echo $select; }     _syslog($select);     //$_rows = $this->fetchrow($select);     $_rows = $this->fetchall($select);      return $_rows; }

edit:

i try access rowset so:

    $model      = _getmodel();     $table      = $model->gettable("irh_customers");     $customer_address_row = $table->getcustomerrowwithaddress($id);     //$customer_address_row = $table->getcustomerrowswithaddress($id);     //$this->_row = $customer_address_row ? $customer_address_row : $table->getrowbyid($id);      $row_count = count($customer_address_row);     if($row_count > 0){         ///$rows = $this->_row->toarray();         $this->exists = true;         $this->id = $id;         if($row_count > 1){              //$array = $customer_address_row->toarray();             foreach($customer_address_row->toarray() $row){                  foreach($row $k => $v){                     //if($k != 'stb_id' || $k != 'mac_address'){                         if(!isset($this->k[$k])){                             $this->k[$k] = $v;                         }                     /*}else if($k == 'stb_id'){                         $this->k['stb_id'][] = $v;                     }                     else if($k == 'mac_address'){                         $this->k['mac_address'][] = $v;                     }*/                 }             }         }else{             foreach($customer_address_row->toarray() $k => $v)             {                 _syslog($v);                 $this->k[$k] = $v;             }         }    }

fetchrow() returns object of zend_db_table_row_abstract. fetchall() returns array.


Comments

Post a Comment

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

-
ho can set spacing beween stars? thats ratingbar: ratingbar = (ratingbar) inflater.inflate(r.layout.ratingbar, null); ratingbar.setlayoutparams(new layoutparams(layoutparams.wrap_content, layoutparams.wrap_content)); the layout: <?xml version="1.0" encoding="utf-8"?> <ratingbar xmlns:android="http://schemas.android.com/apk/res/android" style="@style/mystyle" android:layout_alignparentright="true" android:layout_height="19dp" android:layout_width="wrap_content" android:numstars="5"> </ratingbar> the style: <style name="mystyle" parent="@android:style/widget.ratingbar"> <item name="android:progressdrawable">@drawable/android_r2_ratingstar_yellow</item> <item name="android:indeterminatedrawable">@drawable/android_r2_ratingstar_grey</item> </style> thanks, cheers you have
Read more

aspxgridview - Devexpress grid - header filter does not work if column is initially hidden -

-
i'm using devexpress grid , i'm trying 'country' column display header filter properly: <dx:gridviewdatacolumn caption="country" fieldname="countryname" showincustomizationform="true" visible="false"> <settings allowheaderfilter="true"/> </dx:gridviewdatacolumn> if 'country' column set visible='true', header filter displayed should(it shows value option list). however, want 'country' column hidden, available in customization window(like in code above). in case, when column dragged outside customization window , grid , header filter clicked, javascript error encountered: element null element.addeventlistener(eventname, func, true); is known bug? there workarounds? set aspxgridview.settings.showheaderfilterbutton property true resolve problem. the following markup works fine me (i using dxperience 10.1.7): <asp:accessdatasource id="accessda
Read more

c# - How to execute a particular part of code asynchronously in a class -

-
i creating speech recognition engine that's going respond user commands.i have created button enable , disable speech recognition per user convenience.i have used dispose() of speech engine disable speech recoginition.here code private void button1_click(object sender, routedeventargs e) { engineon = !engineon; if (engineon) { speechengine = speech.createspeechengine(); //speech class creates , returns new speech engine. speechengine.audiolevelupdated += new eventhandler<audiolevelupdatedeventargs>(speechengine_audiolevelupdated); // use system's default microphone speechengine.setinputtodefaultaudiodevice(); speechengine.loadgrammar(new dictationgrammar()); // start listening speechengine.recognizeasync(recognizemode.multiple); } else { speechclass.myengine.dispose(); } } but disposal of speech obj
Read more