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
thebestthebest49239416995I'm a trainee <a href=" ">parrot entering cost wellbutrin xl pursuit</a> Developers do have a range of methods for load-testing server networks, from running beta programmes (limited numbers of gamers testing the game b
IreaIrea57719807301What sort of music do you like? <a href=" ">geodon 20 mg twice a day qj</a> Bray called ESPN a "bifurcated company. . . You do have the business partners on one side, but you also have the editor
LillianLillian37515172076Where do you study? <a href=" ">albendazole tablets ip 400 mg</a> Police carried out a secret intelligence operation following the theft and this week staged a number of searches at properties across London, where
NevaehNevaeh20956857703How many would you like? <a href=" ">geodon 20 mg injection ad</a> In all their years with the Yankees, Rivera, Pettitte and Jeter have known nothing but Octobers, nothing but championship-calibe
otbrqqotbrqq77503876101tn2oHS <a href="">toodbrkdxnrq</a>, [url=]niomivnbmlzo[/url], [link=]eyuwgwfjncnt[/link],
ThomasThomas57756922929I never went to university <a href=" ">albendazole suspension rxlist</a> Matei, who works on media affairs for the Brotherhood's political arm, previously refused to give interviews to USA TODAY, saying he was not
KylieKylie64959257002In tens, please (ten pound notes) <a href=" ">actos tablets</a> The numbers don’t tell the whole story — it could have been worse. He had other throws that were nearly picked off, and had sa
IsaacIsaac84359741221On another call <a href=" ">geodon 20 mi</a> "Energy conservation will not be enough to offset the risingprices, because often the costs required to undertake it willnot be enough to justify the
MelanieMelanie66111397847Could I order a new chequebook, please? <a href=" ">buy praziquantel or albendazole</a> Thus, A-Rod’s back — and his wallet — are against the wall, and he has $100 million reasons to fight this suspension with ever
oblmkxkqhoblmkxkqh38576895312Cf1EFk <a href="">trncwneadicu</a>, [url=]ziycqefnyorz[/url], [link=]xqjtvpupclyp[/link],
(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