Mike
|
| Posted: 06/21/2002, 4:47 AM |
|
Can anyone tell me what's wrong with the code below?
SELECT tasks.priority_id, tasks.status_id, tasks.task_name, tasks.assigned_by, tasks.assigned_to
FROM tasks
WHERE tasks.assigned_by = " & session("UserID") & " OR tasks.assigned_to = " & session("UserID") & ";
Or has someone another idea to get the same result?
Using CC and ASP
Thanks in advance
|
|
|
 |
Nicole
|
| Posted: 06/24/2002, 2:23 AM |
|
Mike,
posted sql should work. I suppose you're using it on SQL tab and get error during design time. It happens because when using custom sql CC connects to db and custom sql is executed in order to get field names. But once you have included asp code into sql it won't work as sql.
The workaround is to locate Where clause in Where field, not in SQL field.
|
|
|
|
|
