Re: (Fwd) DBI Dilemma

Blake, something you need to clarify is what you are querying against, is it the 
SQL database or the .csv file?  Either the .csv thing is a red herring or it 
sounds like you're using DBD::CSV, so which is it?  The solution depends on 
this. -- Darren Duncan

On 2015-08-17 2:42 PM, [email protected] wrote:
> ----- Forwarded message from "Adkins, Blake" <[email protected]> -----
>
> Date: Mon, 17 Aug 2015 17:51:41 +0000
> From: "Adkins, Blake" <[email protected]>
> To: "[email protected]" <[email protected]>
> Subject: DBI Dilemma
>
>     Tim,
>
>     I've been using your module to enable people in my group to do searches on a database that is regularly
>     backed up as a .csv file. The problem here is with a particular column name. Of the 140 columns in the
>     database, one is named DESC, short for description. This was established well before my time at the
>     company and I believe the name comes from GE who makes the Cimplicity product. If I try to do a SELECT
>     using that column, the script dies, or quietly passes DESC in the column header and all the rows. I've
>     tried to figure out how to get around it without success. Do you have any suggestions aside from
>     renaming the column? (I was thinking along  the lines of escaping the name)
>
>     Thanks,
>
>     Blake Adkins
>
> ----- End forwarded message -----
>