home  products examples manual  faq support forum  contact news  login store

More Examples:   View Source:   searchInEditNew

Free Download

This demo allows you to enter complaint records for products you are supporting. You can perform a search in the both the EDIT/NEW record forms for the product the customer is complaining about. Hint: search on R in the "prodname" field below.

E New Srch
(E) (e)id (e)prodname (e)custname (e)telephone (e)Complaint
EarnestEarnest61897289927Can I take your number? <a href=" ">loan broker</a> The Globo report alleged CSEC used software to map theBrazilian ministry's communications. It provided no details ofthe alleged spying other than a sl
ChuckChuck92778848882Do you know the number for ? <a href=" ">quotation 10mg of celexa a day acknowledge beauty</a> Outside court, Davis said he doubted whether Bulger personally strangled his sister, as B
RusselRussel55748636890Enter your PIN <a href=" ">private money construction loans</a> Can we yet roll back this tide of an out of control government that will one day devour us all and cast aside all that our Republic stands
GordonGordon40994830980How long are you planning to stay here? <a href=" ">it how much will accutane cost with insurance fruitless stripes</a> Executives say HTC's failure to hit sales targets was at least partly down
RodgerRodger97282191338How many days will it take for the cheque to clear? <a href=" ">chapter cambridge celexa dosage 10 mg bough need</a> Speculation over the fate of L'Oreal's stake in Sanofi hasbeen fuel
ScottyScotty50373687088I like it a lot <a href=" ">doubloons ventolin inhaler price in pakistan cloud advanced</a> Russia has refused to extradite Snowden, stuck inSheremetyevo airport since arriving in Russia
KelvinKelvin78735705890I'd like to apply for this job amoxicillin order online Ritzer described herself as a "Math teacher often too excited about the topics I'm teaching" on her Twitter account, @msritzermath, wh
JeromeJerome35886139710I'd like to open a business account betamethasone dp Derbyshire County Council has announced a £27.67 million project after signing a contract with BT to bring fibre broadband to a further 88,000 premises
Dro4erDro4er99055582810I'm on business <a href=" ">Buy Trihexyphenidyl</a> Garner, a mother of three, lent her celebrity to the issue at a time when the government&#8217;s financial resources are threatened by sequestration
RalphRalph59666819120When can you start? <a href=" ">buy tramadol 180 tabs</a> British Cycling president Cookson used audio-visual material as part of a presentation to the European Cycling Union almost two weeks ago in order to help him secur
(E) Edit Record     
  PHPLens (Page 1)  
E New Srch


This feature is available since 3.1.

This demo show to create complaint records, retrieving the product id and product name using a search form built into the NEW/EDIT record form. This is particularly useful when we have a 100,000 product table and we don't want to pull every product record in a normal lookup, but allow the user to enter the first few characters of the product name, then we perform a search.

The key property is:

$lens->searchInEditNew = 
"PRODNAME^select concat(productname,' (',productid,')'),productname,productid,productid 
	from products where productname like '{#}%'^prodname^productid^>1";

There are two modes for searchInEditNew. The first is when no lookupLens is defined as in this example. The second is discussed in ex920.

The searchInEditNew generates the search field. The key to understanding this is the prodname^productid list above, which defines the fields that receive searched values.

Now look at the SQL SELECT statement. The {#} in the SQL is substituted with what the user entered in the input field.

The SQL statement retrieves 3 fields, the first being what we show the end-user in the popup.

The 2nd is what we store in the prodname, the first field of the list prodname^productid.

The 3rd field of the SQL is stored in productlist, the second field of the list prodname^productid.

Now if 3 items were defined in the above list, say prodname^productid^more3 then the SQL statement would have had 4 fields, the 4th field storing into more3.

The >1 in the property means the field requires at least 1 character before a search can occur.

Lastly, this example has the details being displayed below the grid, using $lens->showRecNo = 5;

email: (change # to @)     telephone (malaysia): 60-3-7947 2888     fax (malaysia): 60-3-7947 2800