Grouping on a "text" field

Results 1 to 2 of 2

Thread: Grouping on a "text" field

  1. #1
    Allan Jagos Guest

    Default Grouping on a "text" field

    I would like to do a SQL query which groups fields and one of the fields I would like to group on is "text" field. I get the following error message: "The text, ntext, and image data types cannot be used in a GROUP BY clause"<BR><BR>So how can i get my "text" field to come through in my query?<BR><BR>Please e-mail me your answer at<BR><BR>Thanks,<BR>Allan Jagos

  2. #2 Guest

    Default RE: Grouping on a

    The message is pretty self-exlanatory. You are obviously using an image field as part of your group by clause. You simply cannot use memos or blobs in a group by. Show the SQL query if you want more help!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts