lamh56
Posts: 5
|
| Posted: 05/24/2007, 8:08 PM |
|
Hello,
I cannot get CCDLookUp works, always get the error:
------------------------ERROR-------------------------------------------------
Source: CCDLookUp function
Command Text: SELECT dept_dsc FROM departments WHERE dept_id=1
Error description: No value given for one or more required parameters. (Microsoft JET Database Engine)
------------------------------------------------------------------------------------
My code is as below:
------------------------CODE-------------------------------------------------
dept_dsc_tmp =CCDLookUp("dept_dsc","departments",_
"dept_id=" & DBitjob.ToSQL(assets.using_by_dept.value,ccsInteger),DBitjob)
----------------------------------------------------------------------------------
Could some one please help? I use CC Studio, ASP on a Windows 2000 Server.
Thanks,
Lam
|
 |
 |
kevind
Posts: 251
|
| Posted: 06/14/2007, 6:12 PM |
|
You didn't mention if it is MS Access or SQL Server.
When I get those weird Parameter missing messages, I drop the command into a Query and run it in the database, I usually I'll get better error msgs back that way.
Also, i've had some browsers give different error msgs in such situations that point to where the problem lies.
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
mljonzs
Posts: 124
|
| Posted: 06/15/2007, 10:29 AM |
|
I agree with the post above by kevind. Usually, just putting the query directly into SQL will show/help you figure out what any other required parameter might be.
Good luck!
_________________
What does not begin WITH God, will end in failure!
|
|
|
|
|
