pass SQL to variable

When defining a recordset and writing a SQL statement in the advanced dialog
in DMX, is there a way to pass the SQL statement to a variable? If so, how?
Thanks.
-D-

I thought my previous question might be unclear. So, to re-phrase my
question, does DMX have the capability to define a variable like:

Dim strSQL

and set the variable equal to a SQL statement?

Dim strSQL = "SELECT field1 From tbl1 Where Record1 = '" &
Session("Record1") & "';"

I haven't been able to figure this out in DMX? Is there a way to do this?
Thanks for any input.
-D-



"-D-" <noone (AT) nospam (DOT) com> wrote

When defining a recordset and writing a SQL statement in the advanced
dialog
in DMX, is there a way to pass the SQL statement to a variable? If so,
how?
Thanks.
-D-

Open the page up in code view. You can sling that SQL string around wherever you want it.
Ex:

Dim myVar
myVar = recorset.Source

Same answer-- you can do anything you want in code view. Just don't expect the UI to do it for you.

Thanks for the reply. I was trying to see if there was a way to use the DMX
interface to write the SQL to a variable, but it appears from your answer that
I would just write the statement directly into the code.

Or, is it possible to write a new server behavior as listed in the server
behavior panel? And then insert the statement into the code that way?

-D-

I know you can write your own server behaviors, but I've never done it. I
assume you can make your server behaviors do anything you want, including
storing the SQL statement in a variable before using it. After all, MMs server
behaviors create variables for each parameter, so why not?

I'll bet writing your own server behavior is the way to go.