SQL Statement inside a DreamweaverMX MM:Dataset RSS

• • Reply
  

  Chumley Walr...

  Member

  621 Points

  234 Posts

  SQL Statement inside a DreamweaverMX MM:Dataset

  Mar 23, 2004 06:29 PM|LINK

  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: %> '
• • Reply
  

  DW Engineer

  Member

  420 Points

  84 Posts

  Re: SQL Statement inside a DreamweaverMX MM:Dataset

  Mar 24, 2004 04:55 PM|LINK

  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:
  Russ Helfand
  
  
  Dreamweaver Engineer
  
  
  Macromedia, Inc.