Author Topic: Field names in mysqli  (Read 2737 times)

robgell

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 3
    • View Profile
Field names in mysqli
« on: April 15, 2014, 09:37:34 pm »
I am fairly new to paramquery pro, but I have a working solution.

Here is the situation: I have an existing internal system utilising a number of components on an existing database.

There are a number of reports and other information interfaces, all working nicely but needing a facelift. Which is where paramquery comes in.

A lot of the data interfaces use filters. Got my operator grid working nicely, looking all pretty. But - the filters would not work for 5 fields.

On further examination, I realised that the five fields in question actually have numbers in them. (Addr1, Addr2, Addr3 etc).

As a controlled test, I changed the names of the tables to AddrOne, AddrTwo etc, and the filter started to work. Obviously because I have lots of reports and enquiry screens built on lots of sql statements, permanently renaming the fields to remove the numbers is not possible.

Why is this happening? Is there an easy solution, or is this a bug?

I am using a LAMP.

Thanks.

Rob

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6297
    • View Profile
Re: Field names in mysqli
« Reply #1 on: April 15, 2014, 11:55:55 pm »
If you are doing remote filtering or remote sorting, you need to update ColumnHelper -> isValidColumn function to allow for digits in field names.
« Last Edit: April 16, 2014, 12:00:26 am by paramquery »

robgell

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Field names in mysqli
« Reply #2 on: April 19, 2014, 04:17:08 pm »
Ah, yes. Thank you.

 ;D