I need to have sql statements that are predicated on the value of a pre-initialised variable, with the sql statements being housed in DxMX's Dataset blocks. I cannot seem to initialize a variable outside the Dataset blocks, and then add that variable to the
sql statement in the CommandText: %> '
Hmmmm. There may be a couple of problems with the way that you are attempting to do this... I don't think that you can put binding expressions inside other runtime blocks: %> In any case this seems problematic to use since the outer block of code is actually
executed after the binding expression using in the second dataset that wants to use X in your example. So I wouldn't suggest you do it this way. Instead, you can consider a couple of alternatives. First, you might try something much simpler like this:
Chumley Walr...
Member
621 Points
234 Posts
SQL Statement inside a DreamweaverMX MM:Dataset
Mar 23, 2004 06:29 PM|LINK
DW Engineer
Member
420 Points
84 Posts
Re: SQL Statement inside a DreamweaverMX MM:Dataset
Mar 24, 2004 04:55 PM|LINK
Dreamweaver Engineer
Macromedia, Inc.