mavtech
Posts: 133
|
| Posted: 12/02/2004, 1:11 PM |
|
Can someone tell me why this keeps getting a error in 500 in Common.php
$result1 = $currencytest2->Curform->curbox->GetValue();
CCSetSession("CUR1", $result1);
$result = CCDLookUp("rate", "cur", "cur_id=".$result1, $DBInternetDB);
CCSetSession("CUR2", $result);
Paul
|
 |
 |
Martin K.
|
| Posted: 12/02/2004, 11:20 PM |
|
Hello
$result1 = $currencytest2->Curform->curbox->GetValue();
CCSetSession("CUR1", $result1);
global $DBInternetDB;
$result = CCDLookUp("rate", "cur", "cur_id=".$result1, $DBInternetDB);
CCSetSession("CUR2", $result);
By martin
|
|
|
|
Martin K
|
| Posted: 12/02/2004, 11:24 PM |
|
Quote Martin K.:
Hello
$result1 = $currencytest2->Curform->curbox->GetValue();
CCSetSession("CUR1", $result1);
global $DBInternetDB;
$result = CCDLookUp("rate", "cur", "cur_id=".$result1."", $DBInternetDB);
CCSetSession("CUR2", $result);
By martin
|
|
|
|
klwillis
Posts: 428
|
| Posted: 12/03/2004, 7:38 AM |
|
You might want to try this variation of CCDLookUp also:
$result = CCDLookUp("rate", "cur", "cur_id=".$DBInternetDB->ToSQL($result1,ccsInteger), $DBInternetDB);
Quote mavtech:
Can someone tell me why this keeps getting a error in 500 in Common.php
$result1 = $currencytest2->Curform->curbox->GetValue();
CCSetSession("CUR1", $result1);
$result = CCDLookUp("rate", "cur", "cur_id=".$result1, $DBInternetDB);
CCSetSession("CUR2", $result);
Paul
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
|
|
|
Martin K
|
| Posted: 12/03/2004, 11:00 AM |
|
Hello.
Write this:
$result1 = $currencytest2->Curform->curbox->GetValue();
if($result1 <> "") {
CCSetSession("CUR1", $result1);
global $DBInternetDB;
$result = CCDLookUp("rate", "cur", "cur_id=".$result1."", $DBInternetDB);
}
if($result <> "")
CCSetSession("CUR2", $result);
this must happend.
cio martin
|
|
|
|
xtremephp
Posts: 40
|
| Posted: 12/03/2004, 11:49 AM |
|
|
|
|
|
klw
|
| Posted: 12/03/2004, 11:59 AM |
|
Is everything now working for you as expected?
Quote mavtech:
Can someone tell me why this keeps getting a error in 500 in Common.php
$result1 = $currencytest2->Curform->curbox->GetValue();
CCSetSession("CUR1", $result1);
$result = CCDLookUp("rate", "cur", "cur_id=".$result1, $DBInternetDB);
CCSetSession("CUR2", $result);
Paul
|
|
|
|
|
