How to populate a field using DLookup

CodeCharge Studio

Visual Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> ASP

How to populate a field using DLookup

Author

Message

Bret

Posted: 12/07/2004, 12:11 PM

I am a new user to CodeCharge and am having trouble populating a field using DLookup. I got the correct value (verified with a Response.Write) but when I try to set the field value I get errors.

EmployeeName.Value = CStr(CCDLookUp("EmployeeName","Master","formid = 1",DBConnection1))

I get the following error

Error Type:  
Microsoft VBScript runtime (0x800A01F4)  
Variable is undefined: 'EmployeeName'  
/Test/CheckList_events.asp, line 11

Fieldname = EmployeeName, Form = Form1, Page = CheckList

I have tried adding the CheckList., CheckList.Form1., ME., anything that corresponds to the examples in the help file -- but no luck.

Would someone volunteer to mentor me a little?

Thanks!

peterr

Posts: 5971

Posted: 12/07/2004, 12:55 PM

Bret,
Take a look at http://docs.codecharge.com/studio/html/ProgrammingTechn...ntrolValue.html

You can refer to "EmployeeName" only if it is a control all by itself, outside of a form. If it's inside a form then you need to use the syntax FormName.ControlName.Value. In your case probably "Form1.EmployeeName.Value = ..."
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com

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