RoyBaird
Posts: 115
|
| Posted: 09/24/2006, 9:58 PM |
|
I have an encrypted field I pass in the url from the "add" page to the "list" page. I need to do a lookup on the database to get the real value for the Grid list. I have no problem in the Record page, but I don't know what the object is in the Grid. Here is the Record custom code: This works perfect.
Dim URL_name
Dim Lookup_name
URL_name = CCGetParam("Name", Empty)
Lookup_name = CCDLookUp("Name", "AS_team", "Encrypt=" &_
DBConnection1.ToSQL(URL_name, ccsText), DBConnection1)
Tasks.Name.Value=Lookup_name <----- what should this be????
Thanks!!!
_________________
Roy |
 |
 |
Oper
Posts: 1195
|
| Posted: 09/26/2006, 10:56 AM |
|
Lookup_name (only, that the name of teh variable receiving the value)
but maybe your script i teh problem cuas ei gest the Encrypt value is alphanumeric?
Lookup_name = CCDLookUp("Name", "AS_team", "Encrypt=" &_
DBConnection1.ToSQL(URL_name, ccsText), DBConnection1)
you will need to add apsotrophe to the Search
Encript= SingleAptropheHere " &
DBConnection1.ToSQL(URL_name, ccsText) & " SingleAptropheHere "
Substitued the word SingleAptrophehere for '
maybe
Let me know.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
