CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> ASP

 Dlookup problem

Print topic Send  topic

Author Message
ReneS

Posts: 225
Posted: 10/02/2009, 10:19 AM

Hi,

I am having trouble with constructing this through the "add action".
SoortGroep.sgp_MedewerkerLCGewijzigd.Value = CCDLookUp("med_LC","Medewerker","med_ID=" & DBKBSSTCONN.ToSQL(CCGetUserID(),ccsInteger), DBKBSSTCONN)

In the "events tab" of my record form
using "server > before insert > add action > DLookup"
What do I need to type in there to get the above statement?
So:
Expression
Domain
Criteria
Connection
Convert result to
Type of target
Target

Tried a lot of differend things but I never succeed...

Thanks for helping,

Rene
View profile  Send private message
jjrjr1


Posts: 942
Posted: 10/03/2009, 3:35 PM

Hi

Expression = DataField Name
Domain = Your database table
Criteria = the selection or WHERE statement for selecting your records
Connection = The name of the DB Connection to Use. (this is a dropdown selection)
Convert result to = Your choice text, int, float.. etc (also a drop down)
Type of target = Type of varaiable you want the result to appear in, Variable, Cookie, Session, Page Component. (also a drop Down)
Target = Name of the target variable, control, etc.


_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com
View profile  Send private message

Add new topic Subscribe to topic   


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

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.