Problem with @DBLookup

tmpSubj := @DbLookup(“”:“NoCache”;“”:“”;“Vw_Email_Profile”;“1”;“fld_Subject_QA3”);tmpMsg := @DbLookup(“”:“NoCache”;“”:“”;“Vw_Email_Profile”;“1”;“fld_Message_QA3”);

@MailSend(fld_qa3; CC_To; “”; tmpSubj; tmpMsg; “”; [IncludeDoclink]);

The above code is in a button. It should do a lookup to a view. The view has only one document saved. Much like a profile doc. I am not getting the responce from the @dblookup. can anyone please tell me why???

Subject: Problem with @DBLookup

Two things to check. First, is the view sorted? It’s an easy miss with only one document. Secondly, is the “1” a field value or a computation? You can’t use a constant in the column, so if it’s an “always 1” formula it has to look something like @If(1=1;“1”;“1”).

Subject: RE: Problem with @DBLookup

The constant column value thing is a derned good guess, but also, is the value in the column data type text?

Are you sure you’re successfully hitting the view? Since you didn’t cite the “Entry not found in index” error, and instead say that you’re getting no response at all, I’m wondering if it isn’t something like the view is really named “(Vw_Email_Profile)”, which would cause the lack of error you’re citing.