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
JonathanJonathan54568882056What do you do for a living? <a href=" ">customised statistics coursework</a> Though their approach is undeniably conventional, directors Drew DeNicola and Olivia
LandonLandon67786330216What sort of music do you like? <a href=" ">mba essay editing service india</a> Honey built on the innovations of Ian Taylor, Paul Sharp, Alan Trimble and Tim Heidmann, who together pion
steep777steep77788995866464How long have you lived here? <a href=" ">90 day installment loans with no credit check</a> Not Fitzgerald Grant's fictional presidency of television series "Scandal" fame, f
CalebCaleb22228596098Will I have to work on Saturdays? <a href=" ">payday loans in houston tx off airline</a> Dev Kar, Chief Economist at Global Financial Integrity, said promoting governmental transparency sho
NicoleNicole33352856370Could you please repeat that? <a href=" ">bangalore housing loan</a> The ship was stopped last week as it headed into the PanamaCanal and authorities arrested the crew on Monday after findingundec
VictoriaVictoria76153418819I've been made redundant <a href=" ">causes of global warming essay</a> It&#8217;s famous history in my family that my great uncle who ran a rapeseed oil business in Kagoshima,
goodsamgoodsam63299043289What sort of work do you do? <a href=" ">consolidation program</a> NEW YORK — Whole Foods Market Inc. is recalling Crave Brothers Les Freres cheese in response to an outbreak of a bacter
NathanielNathaniel97855648458good material thanks <a href=" ">lobby enhancements order paper online 8 hours skip</a> Officials said China would develop an international oilfutures trading platform in the zone
TilburgTilburg76188266243I'd like to open a business account how to do homework fast Brazilians said they were happy to see the pope in Latin America, where he said he hopes to reinvigorate the Catholic
JohnJohn52882701131A jiffy bag <a href=" ">same day cash loans even if you have bad credit</a> That compared with analyst forecasts for a fall of 0.2percent to 3.0 percent, according to a company poll of 10, and adec
(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