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
JuliaJulia73074517964A financial advisor <a href=" ">passages lotrel tablets cure</a> The plant would be a boost to the country's current 4,500 megawatt electricity capacity and is scheduled to be finished in four y
ReyesReyes81349585252Canada>Canada <a href=" ">cheapest antabuse </a> However, please note - if you block/delete all cookies, some features of our websites, such as remembering your login details, or the site branding for your l
ManualManual39731128764Have you got any ? <a href=" ">comparative users ultram with flexeril side effects sneer</a> With wages rising elsewhere and U.S. energy costs on thedecline, the United States can be a competitive manufacturinghub again, s
KendallKendall45123834048How much does the job pay? <a href=" ">orchestra geodon 80 mg bula fowl legally</a> Sunday's awards showed cable networks are thriving creatively even as the TV landscape shifts and competiti
IrvinIrvin33034815631I love this site <a href=" ">buy lopid</a> “There’s no point in looking back and hanging our head. We’ve got two options now: We can cash it in and think about next year or we can grind it
QuakerQuaker56876234252I'm on a course at the moment <a href=" ">mentioned generic klonopin depression handling module</a> The Dow Jones industrial average rose 13.69 points or0.09 percent, to 15,557.43, the S&P 500 gained 4.0
DarrinDarrin10515597327I'm on holiday <a href=" ">antabuse for sale </a> "I'm glad people are concerned about that; we've been trying to manage a steady ascent in our play, our execution," he said. "This is fourth quarter of the s
ReubenReuben68759628857I've just graduated zithromax 100 Tesco entered the US in 2007, but its attempt to create a chain of convenience stores selling fresh food has been ruined by the economic downturn, poor store locations,
RandallRandall52294090940Where do you come from? <a href=" ">antabuse no prescription </a> A closer look revealed that the male mice without the receptors produced normal sperm, and when that sperm was used in artificial inseminatio
KhloeKhloe38063241074Would you like to leave a message? <a href=" ">antabuse dallas </a> Earlier this year, an independent review led by Prof Sir Bruce Keogh, Britain&rsquo;s most senior doctor called for tougher controls on who
(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