Use different Querystring based on session value

[robbie59]

I have an existing query as follows:

SELECT state, JobNumber, DictatorName, DictatorID, AssignTranID, dtComplete, dtAtTran, JobLength, lExtraStatus, iPriorityLevel
FROM Dictations
WHERE DictatorName like 'vardictator' AND state Like 'varradio' and AssignTranID like 'vartran'

Vartran's parameter value is the session value I would like to use a listmenu by the name of tranid as the vartran parameter if the session value is % if anything other than % is the session value I would like to just use the session value as the parameter.

this may be easy but it has me stumped...

Thanks for any help

If knowledge were power I would be a AAA battery!

 

[jemminger]

assuming your session value is stored as "vartran" then:

dim sTran, sql

if session("vartran") = "%" then
	sTran = request("tranid")
else
	sTran = session("vartran")
end if

sql = "SELECT state, JobNumber, DictatorName, DictatorID, AssignTranID," &_
	" dtComplete, dtAtTran, JobLength, lExtraStatus, iPriorityLevel" &_
	" FROM Dictations" &_
	" WHERE DictatorName LIKE 'vardictator' AND state LIKE 'varradio'" &_
	" AND AssignTranID LIKE '" & sTran & "'

=========================================================
-jeff

http://www.jeffemminger.com

try { succeed(); } catch(E) { tryAgain(); }

 

[robbie59]

The session is (Session("Accesslevel&quot)

I use dreamweaver and vartran is a variable and the runtime value is currently set to (Session("Accesslevel&quot) I basically don't want to use (Session("Accesslevel&quot) as the runtime value if the session value is % I want to use tranid as the runtime value if it is %


Thanks for the help

If knowledge were power I would be a AAA battery!

 

[foxbox]

if rtrim(session("Accesslevel")) = "%" then
    sTran = request.form("tranid")
else
    sTran = session("vartran")
end if

rest the same.

IMHO it is a little strange to see a SQL statement with a field LIKE 'value'; isn't it the same as field = 'value'? But it is a nice trick for the last part:
" AND AssignTranID LIKE '" & sTran & "'
The alternative is

sql = "SELECT state, JobNumber, DictatorName, " &_
"DictatorID, AssignTranID, dtComplete, dtAtTran, " &_
"JobLength,lExtraStatus, iPriorityLevel " &_
"FROM Dictations " &_
"WHERE DictatorName = 'vardictator' " &_
"AND state = 'varradio'" 

if sTran <> &quot;%&quot; then
    sql = sql & &quot; AND AssignTranID = '&quot; & sTran & &quot;'
end if

hth,
Foxbox

 

[robbie59]

I am using dreamweaver,s recordset builder screen so where do I put the code or what portion of code goes where or should I make this a stored procedure and call it

If knowledge were power I would be a AAA battery!