Chris__T
Posts: 339
|
Posted: 06/11/2008, 1:02 PM |
|
Looks like you can only use CCDLookup() to look up one value from a database. I was wondering if there was a workaround or other way to lookup 2 values. Or setup a select query so I can use the results in an if-then statement in the ASP code.
|
|
|
Oper
Posts: 1195
|
Posted: 06/11/2008, 1:16 PM |
|
why not just look for the 2 value? (2 ccdlookup)
also nonesense but you could get 2 value separated by semicolon
result=CCdlookup("Concat(Value1,';',Value2)",................................
what you are trying to acomplish?
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
Chris__T
Posts: 339
|
Posted: 06/11/2008, 1:41 PM |
|
To see if someone in the database has a date of xx/xx/xxxx, then base code off of this result.
If (JoeSmith has a database entry with the date 6/11/08) then
do JoeSmith code;
end if
Something like that.
|
|
|
mrachow
Posts: 509
|
Posted: 06/11/2008, 11:39 PM |
|
You should be able to specify count(*) or simply 1 as column name and EXISTS (your subselect) as where clause and compare the result with 0 in your if clause.
_________________
Best regards,
Michael |
|
|
|