Tuong Do
|
| Posted: 07/29/2002, 9:22 PM |
|
Can someone please tell me what wrong with this code?
How should I declare a varibles of type ADODB?
Function EMP_TEMP_Button1_OnClick() 'EMP_TEMP_Button1_OnClick @14-789F0312
'Custom Code @15-73254650
Dim test
test = CCExecSQL("insert into emp (emp_id,org_name) values (1,'Xyz')",
NEST2,false)
' -------------------------
' Write your own code here.
' -------------------------
'End Custom Code
End Function 'Close EMP_TEMP_Button1_OnClick @14-54C34B28
And the Error is
Technical Information (for support personnel)
a.. Error Type:
Microsoft VBScript runtime (0x800A01F4)
Variable is undefined: 'NEST2'
/nest2/EMP_TEMP_staff2_events.asp, line 12
b.. Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
c.. Page:
POST 99 bytes to /nest2/EMP_TEMP_staff2.asp
d.. POST
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 07/30/2002, 6:12 AM |
|
Most probably if your connection is named nest2 ,
connection variable is named DBnest2
--
Alex,
Support Engineer
CodeCharge Team
"Tuong Do" <tuongdo@somewhere.onerath> wrote in message
news:ai549e$pqd$1@news.codecharge.com...
> Can someone please tell me what wrong with this code?
> How should I declare a varibles of type ADODB?
>
>
>
> Function EMP_TEMP_Button1_OnClick() 'EMP_TEMP_Button1_OnClick @14-789F0312
>
> 'Custom Code @15-73254650
> Dim test
> test = CCExecSQL("insert into emp (emp_id,org_name) values (1,'Xyz')",
> NEST2,false)
>
> ' -------------------------
> ' Write your own code here.
> ' -------------------------
> 'End Custom Code
>
> End Function 'Close EMP_TEMP_Button1_OnClick @14-54C34B28
>
>
> And the Error is
> Technical Information (for support personnel)
>
> a.. Error Type:
> Microsoft VBScript runtime (0x800A01F4)
> Variable is undefined: 'NEST2'
> /nest2/EMP_TEMP_staff2_events.asp, line 12
>
>
> b.. Browser Type:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
>
> c.. Page:
> POST 99 bytes to /nest2/EMP_TEMP_staff2.asp
>
> d.. POST
>
>
>
|
|
|
|
|
