« resizing in photoshop
paddy power the punter’s pal »

mm:dataset not well formed errors

if you are using dreamweaver mx to code asp.net applications you will probably be using a lot of mm:dataset tags. if you ever need to edit the commandtext attribute of the mm:dataset tag, you may well see the charming error message “The server tag is not well formed”.

one possible reason for this error is the presence of single quotes in your query. for example, the following code will not work:

CommandText=’<%# “SELECT substring(description, 0, CHARINDEX(’ ‘, description, 200)) as intro FROM products” %>’

luckily there is an easy way to get rid of this error. simply remove the outer single quotes surrounding the attribute:

CommandText=<%# “SELECT substring(description, 0, CHARINDEX(’ ‘, description, 200)) as intro FROM products” %>

This entry was posted on Wednesday, May 19th, 2004 at 10:49 pm and is filed under .net. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

12 Responses to “mm:dataset not well formed errors”

  1. Mornington Says:
    March 10th, 2005 at 7:25 am

    Wow! This tip is amazing. I was almost ready to abandon using the MM:DataSet altogether (and hand coding it). Whew! It was so hard to find info or documentation on how to alter their tags!

    (I guess Dreamweaver does this so that it will be harder for hackers to enter single quotes into querries because of injection attacks? Who knows…)

  2. Mornington Says:
    March 10th, 2005 at 7:27 am

    BTW, while posting here I got this error :)
    Use of uninitialized value in substitution (s///) at plugins/Blacklist/lib/Blacklist/App.pm line 44.

  3. janine Says:
    March 10th, 2005 at 9:00 am

    hi mornington,

    thanks for letting me know about this. your comment got through ok but was not instantly approved due to how old this post was. my anti-spam plugin clearly needs some tweaking to stop the pesky error messages though!

  4. Mornington Says:
    March 12th, 2005 at 12:06 pm

    The post might be old, but who would have thought that almost a year later this tip would still be helping total strangers! Cool! ;)

  5. janine Says:
    March 12th, 2005 at 12:25 pm

    ah, it’s not that deep an insight or anything but thanks for saying thanks :) it’s nice that almost a year later someone left a comment to say i helped a little :)

  6. Robin Sengupta Says:
    January 27th, 2006 at 3:52 pm

    The solution helped me too - VisualStudio 2005 - Jan2006. Thanks

  7. philip Says:
    April 15th, 2006 at 8:28 am

    you just made me a VERY happy man. HOURS and HOURS of frustration due to stupid little single quotes… who’da thunk? :D

  8. Gary from Galway Says:
    June 22nd, 2007 at 12:31 pm

    I like it thanks

  9. Adam - London Says:
    September 5th, 2007 at 2:36 pm

    Awesome…sorted me out a treat!

  10. JM Says:
    February 5th, 2008 at 12:17 pm

    This same error will happen if you have runat=”server” inside a comment.

  11. CM Says:
    July 22nd, 2008 at 3:43 pm

    Thanks a lot JM……. Ur tip saved my soul…

  12. Flyte Says:
    July 24th, 2008 at 11:08 am

    This helped me as well .. VS 2008 - July 08!!

    :D

Leave a Reply