This discussion is archived
4 Replies Latest reply: Oct 10, 2012 12:11 PM by kps204020 RSS

SQL Source in Page with variables

kps204020 Newbie
Currently Being Moderated
Hello,

I need to define a page source with conditions in the where statement.
I.E. Select * from myTable where myField = myVar1.
The where statement should only be used, if a textbox :myBox contains a specific value.
The content of myVar1 should also vary with regard to the value in :myBox.
How can I do this?
Thanks in advance for you help.

Edited by: kps204020 on 05.10.2012 16:09

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points