pass a variable using aspx

[HollyylloH]

I am using the DRW to create a frontend to my SQL database. I need to pass a
variable as criteria for the underlying sql query. I am looking for some
assistance for the best posable approach.

Here is what I have: a user signs in using a username that is also the value
that the database needs to use to query the results. So then if the user
signs on as MyUserName then the resulting query results should include only
ID=MyUserName

I could create a different DRW section for each user and use a SQL View
rather than a table to accomplish this but this would be labor intensive. Is
there a way to create a variable and set the value?

Thanks

 

[ConnerS]

I am pretty novice myself, but no one else has answered, so I thought I would
try.

Step 3 of database Results wizard, use more options > criteria > Add > field
with ID and value ID.

Once you have your Database results region, highlight the colum value you
want to pass and insert hyperlink. Set the file name you are going to, and
use the parameter button from the insert hyperlink window. Under Query
string, choose Add, and then pull down the ID for the value.

I think you can also use cookies, but I haven't figured them out yet.