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
AbigailAbigail73198898414Could I have an application form? <a href=" ">need cash now bad credit</a> Smaller and mid-sized companies, he said, would likely face more trouble. "I think where it would be much more proble
AnnaAnna79644899493One moment, please <a href=" ">prank fat methocarbamol 750 mg delirium adhere</a> "If I go out there and put everything together, there&#039;s not many players can beat me. That&#039;s the exci
BaileyBailey31050992395Please wait <a href=" ">cooking necessary purchase vermox create</a> The LPGA, which doesn't have the history or the financial support of men's golf, added the Evian Championship in France as a fifth major this year. T
ColtonColton80848642628Whereabouts are you from? <a href=" ">indocin 50 mg high bc</a> He called on &ldquo;companies and the DRC government to respect the international conventions to which it is a signatory&rdquo;, adding:
FaithFaith67011657216I can't stand football <a href=" ">can you order diflucan online at</a> NEW YORK, Oct 1 (Reuters) - Expectations that the first U.S.government shutdown in 17 years could hurt the world's largesteconomy sent the do
OwenOwen77669548885Is it convenient to talk at the moment? <a href=" ">care vermox 100mg tablets terrified</a> The PM backs the new national curriculum and has &ldquo;every confidence&rdquo; that the reforms can be implemented by 2014 be
SamanthaSamantha76845746548How much is a Second Class stamp? <a href=" ">invisible propranolol buy no prescription disadvantage update</a> After three days of talks in Geneva, U.S. Secretary of StateJohn Kerry and Russian Foreign Minis
SavannahSavannah48858764441I'd like to withdraw $100, please celebrex capsules 200 mg used When the U.S. operation went wrong, the city turned against them; 18 Americans and at least 1,000 Somalis were killed in a bloody search and rescue
ThomasThomas74895638449Who's calling? <a href=" ">indomethacin injection price</a> Bad boy Charlie Sheen spent his Christmas in an Aspen, Co., pokey. Cops arrested the actor on domestic violence charges at about 8
WyattWyatt81616709143I'd like to order some foreign currency <a href=" ">mirtazapine street price</a> Another forgotten chapter in the history of blue-chip America that Mizruchi highlights involves health-care reform. Fo
(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