Alpha Video Training
Results 1 to 2 of 2

Thread: Error expanding Grid Part template: Column not found while getting result set data co

  1. #1
    Member
    Real Name
    Roelof
    Join Date
    Jul 2008
    Location
    Seattle, WA
    Posts
    763

    Post Error expanding Grid Part template: Column not found while getting result set data co

    I have build a brand new grid and re-created the SQL statement, but I keep having this error:"Error expanding Grid Part template: Column not found while getting result set data column."
    - Rebooted the system
    - Started a whole new website

    When I try the SQL statement in the Query builder it works great. The fields show up in the fields part but as soon as I run the grid the above error comes up.
    In Live preview just the error comes up in Working preview that attached error comes up.

    Anybody can give some input in this error?

  2. #2
    Member
    Real Name
    Roelof
    Join Date
    Jul 2008
    Location
    Seattle, WA
    Posts
    763

    Default Re: Error expanding Grid Part template: Column not found while getting result set dat

    I found the error.
    The count(*) in SQL did not create a variable. I thought that the alias was enough but after I picket a field count(<fieldname>), it worked

Similar Threads

  1. Web Project Problem - Error expanding Grid Part template: Variable "Fld_last_update"
    By TZarcone in forum Application Server Version 10 - Web/Browser Applications
    Replies: 6
    Last Post: 06-02-2010, 04:42 PM
  2. Error upon autosubmit of search part in grid
    By envisionsolutions in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 06-02-2010, 01:01 AM
  3. Error expanding Grid Part Template: Not an open table
    By Eric Johnson in forum Application Server Version 10 - Web/Browser Applications
    Replies: 3
    Last Post: 02-04-2010, 11:46 AM
  4. Set a default value in a search part dropdown on a grid
    By den1s in forum Application Server Version 9 - Web/Browser Applications
    Replies: 3
    Last Post: 08-28-2009, 03:39 AM

Bookmarks

Posting Permissions

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