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
bobberbobber36903435452Did you go to university? <a href=" ">Buy Atrovent Online</a> So I think that Thomson Reuters is smart to suspend the top tier of access to the UMich data, at least until Schneiderman finishes his investigation. The two
GenesisGenesis67169106702I need to charge up my phone price for lexapro Additionally, the screening process has become a bureaucratic nightmare, with applicants waiting as long as a year for the State Department to process pape
JacksonJackson85634531029I'm training to be an engineer <a href=" ">chances conceiving twins 50mg clomid</a> Speaking after he briefed Arab states about the direct peace negotiations, which resumed on July 29 with a goal of reaching an agree
kddsxrjusdmkddsxrjusdm93828555021sAcFEI <a href="">lriulpumikgv</a>, [url=]uvmzqpxmkwxw[/url], [link=]kxkzpmmzleln[/link],
KylieKylie92394771640Why did you come to ? <a href=" ">50mg or 100mg clomid</a> The 19-year-old Spieth tapped in for par on the par-four 18th hole to defeat 2007 Masters champion Zach Johnson, who won the tournament last year, and Canadi
LoganLogan92257287322The National Gallery <a href=" ">arcoxia price</a> In an interview with reporters in London following Manning's conviction on espionage and other charges, Assange said it
MadelynMadelyn66164111710I want to make a withdrawal lexapro sale online Fed Chairman Ben Bernanke said last month that the central bank was likely to start curtailing the bond purchases later this year and would probably bring
MayaMaya98247007021Very Good Site <a href=" ">10mg lipitor every other day ue</a> Fraser & Co estate agency, which sells high numbers of London flats in Asia, says that 90 per cent of the oversea
SamuelSamuel36804376817Could you transfer $1000 from my current account to my deposit account? <a href=" ">875 125 mg augmentin</a> Sanchez had four years of chances and blew it. There’s no indication when he will be
SeanSean74427752830I enjoy travelling <a href=" ">liberty wrist thuoc lipitor 10mgmg potentially evidence</a> "We are especially gratified that this New Jersey federalcourt decision comes less th
(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