limit number of returns

CodeCharge Studio

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

limit number of returns

Author

Message

thomas

Posted: 01/31/2002, 4:40 PM

How can i limit my number of returns with dlookup ?

Nicole

Posted: 02/01/2002, 12:42 AM

Thomas,
dlookup() function always returns the one value of one field only. If there're several records in recordset the first only will be used to return result.

thomas

Posted: 02/03/2002, 12:43 AM

Hi,

to speed up my select step, i made index fields regarding to the select step and at the end of the select step i say "LIMIT 1"

thomas

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login