IT Monkey:   Click Here to Help Me Build the Agenda for Upcoming Cireson Webinars!

SQL Widget - Column Alias

Jamie_EsquivelJamie_Esquivel Customer IT Monkey ✭
Looks like when adding new pages with a SQL widget, it won't allow column aliases with spaces in them. Is this a known bug?

Comments

  • Jamie_EsquivelJamie_Esquivel Customer IT Monkey ✭
    To clarify, this is the column alias in the actual SQL query. Example 'Affected Department' won't work but 'AffectedDepartment' will work
  • Geoff_RossGeoff_Ross Cireson Consultant Super IT Monkey ✭✭✭✭✭
    Hi Jamie, I think putting the alias in [] will work.
  • Jamie_EsquivelJamie_Esquivel Customer IT Monkey ✭
    I tried that but when I use the brackets the query will return 0 rows. Geoff_Ross said:
    Hi Jamie, I think putting the alias in [] will work.

Sign In or Register to comment.