werner schoenfeldinger
|
Posted: 04/12/2001, 4:58 AM |
|
I am trying to implement the following Query into a CC-Grid:
SELECT t2.fID AS fID,
t2.fTitle AS fTitle,
t2.fAbstract AS fAbstract,
t2.fDate AS fDate,
t2.fContact AS fContact,
t2.fDeadline AS fDeadline
FROM t42Event t2
WHERE NOT EXISTS (SELECT a.fEvent AS qEvID FROM tAttendance a WHERE
a.fContact=" & GetParam("UserID") & "
If entered in Use SQL Query --> Error from ODBC
If the Where portion (NOT EXISTS ....) entered in the WHERE Textbox, it
doesn't do it.....
Any hints how to do it without custom coding?
thanx
-schoenf
|
|
|
Alexey Alexapolsky
|
Posted: 04/12/2001, 6:48 AM |
|
Use "Where" textbox.
GetParam won't give you session id.
it's for http params only , while userid is a session parameter.
In asp use session("UserID")
In PHP use get_session("userid")
--
Regards,
Alexey
CodeCharge Support
werner schoenfeldinger <schoenf@chello.at> wrote in message
news:9b4591$vrf$1@mail.tankhill.com...
> I am trying to implement the following Query into a CC-Grid:
>
> SELECT t2.fID AS fID,
> t2.fTitle AS fTitle,
> t2.fAbstract AS fAbstract,
> t2.fDate AS fDate,
> t2.fContact AS fContact,
> t2.fDeadline AS fDeadline
> FROM t42Event t2
> WHERE NOT EXISTS (SELECT a.fEvent AS qEvID FROM tAttendance a WHERE
> a.fContact=" & GetParam("UserID") & "
>
> If entered in Use SQL Query --> Error from ODBC
> If the Where portion (NOT EXISTS ....) entered in the WHERE Textbox, it
> doesn't do it.....
>
> Any hints how to do it without custom coding?
>
> thanx
> -schoenf
>
>
|
|
|
|