RonB
|
| Posted: 06/07/2002, 6:15 AM |
|
Hi,
Why does->
global $medewerkers;
global $DBConnection2;
$medew=$medewerkers->id1->Value;
$sql="select email from employees where id1=" .$medew;
$my_result=CCGetDBValue($sql,$DBConnection2);
$medewerkers->Label1->setvalue($my_result);
work
and is ->
global $medewerkers;
global $DBConnection2;
$sql="select email from employees where id1="
..CCToSQL($medewerkers->id1->Value,ccsInteger);
$my_result=CCGetDBValue($sql,$DBConnection2);
$medewerkers->Label1->setvalue($my_result);
giving me a member function on a non object error?
I'm trying to get the habg of this OOP php programming
Ron
|
|
|
 |
Dave Rexel
|
| Posted: 06/07/2002, 6:55 AM |
|
Hi Ron
Here's a solution I got at the support-web
--------------
Dave,
please use following code in events to look up table value:
1.
global $<form_name>;
$new_obj = new clsDB<connection_name>();
$sql = "select category_desc from categories where category_id=".
CCToSQL($<form_name>->item_id->Value, "Number");
$myLookup = CCGetDBValue($sql, $new_obj);
$<form_name>-><field_name>->SetValue($myLookup);
OR
2.
global $<form_name>;
$new_obj = new clsDB<connection_name>();
$res = CCDLookUp("lookup_field_name", "table_name",
"id=".CCToSQL($<form_name>->item_id->Value, "Number"), $new_obj);
$<form_name>-><field_name>->SetValue();
Regards,
Helen
-----------
Seems you have to declare the connection as an new object before using it.
Worked perfectly.
Hope this helps,
Dave
"RonB" <r.borkent@123chello.nl> wrote in message
news:adqblp$lmc$1@news.codecharge.com...
> Hi,
>
> Why does->
> global $medewerkers;
> global $DBConnection2;
> $medew=$medewerkers->id1->Value;
> $sql="select email from employees where id1=" .$medew;
> $my_result=CCGetDBValue($sql,$DBConnection2);
> $medewerkers->Label1->setvalue($my_result);
>
> work
>
> and is ->
> global $medewerkers;
> global $DBConnection2;
> $sql="select email from employees where id1="
> .CCToSQL($medewerkers->id1->Value,ccsInteger);
> $my_result=CCGetDBValue($sql,$DBConnection2);
> $medewerkers->Label1->setvalue($my_result);
>
> giving me a member function on a non object error?
>
> I'm trying to get the habg of this OOP php programming
>
> Ron
>
>
>
|
|
|
|
|
