This topic is locked

Master Table Data

8/11/2009 10:14:13 AM
ASPRunnerPro General questions
N
NigelEtienne author

I am trying to show the Master Table data on the print page and have used the following code:

str = "select FullName from AUD_USERS where StaffNumber='" & Session(strTableName & "_masterkey1") & "'"

and get a Data type mismatch in criteria expression. error
if I change the code to be :

str = "select FullName from AUD_USERS where StaffNumber=200073"

I get the correct name displayed
Any ideas how to just pick up master table data on a print page?

J
Jane 8/12/2009

Hi,
please check my changes below:

str = "select FullName from AUD_USERS where StaffNumber=" & Session(strTableName & "_masterkey1") & ""

N
NigelEtienne author 8/14/2009

Hi,

please check my changes below:


Many thanks - now works.