cornwell
|
| Posted: 05/09/2002, 8:17 PM |
|
I need to use a a session tracker in a listbox to show only the choices
appropriate for the user's work department.
In the List tab, Lookup SQL textarea I write
......
SELECT [DivId],[DivAbbrev] FROM Divisions WHERE Divid = " & Session("DivId")
....
which fails because the CC generator wraps quote marks around both ends
making it into this
....
"SELECT [DivId],[DivAbbrev] FROM Divisions WHERE Divid = " &
Session("DivId")"
....
I dont need the quote mark at the end of the string.
How to write this is so it generates properly??
TIA
Cornwell
|
|
|
 |
cornwell
|
| Posted: 05/09/2002, 8:42 PM |
|
It might help to know....
That's for ASP and templates,
DivId is numeric.
TIA
|
|
|
|
kmcook
|
| Posted: 05/09/2002, 9:05 PM |
|
You're almost there...
just add this to your line
~~
& "
~~
and it should work.
"cornwell" <keijen@ozemail.com.au> wrote in message
news:abfe3m$ot0$1@news.codecharge.com...
> I need to use a a session tracker in a listbox to show only the choices
> appropriate for the user's work department.
>
> In the List tab, Lookup SQL textarea I write
> .....
> SELECT [DivId],[DivAbbrev] FROM Divisions WHERE Divid = " &
Session("DivId")
> ...
> which fails because the CC generator wraps quote marks around both ends
> making it into this
> ...
> "SELECT [DivId],[DivAbbrev] FROM Divisions WHERE Divid = " &
> Session("DivId")"
> ...
> I dont need the quote mark at the end of the string.
>
> How to write this is so it generates properly??
>
> TIA
>
> Cornwell
>
>
|
|
|
|
|
