Re: Periods in Column name

In article <[EMAIL PROTECTED]>, Ron Thompson <[EMAIL PROTECTED]> writes: > I seem to have an issue with select-ing a column by name if it has > more than one period in the name. One period works fine and I can do > something like: > my $upd_def = "10.3" . "_def"; >

RE: Periods in Column name

Ron Thompson [mailto:[EMAIL PROTECTED] wrote: > I'm seriously considering removing the > periods from my column names, but I'm kinda stubborn. FWIW, that's what I would recommend. Using special characters (such as period or space) in object names just adds unnecessary complications. Ronald

Re: Periods in Column name

Hooray for backticks! Hehe... for the life of me I couldn't find anywhere on mysql.org how periods were used, but now it all makes sense, and using the backticks I got it all smoothed out. I'm seriously considering removing the periods from my column names, but I'm kinda stubborn. Thanks all f

Re: Periods in Column name

On Tue, 23 Nov 2004, Ron Thompson wrote: > Date: Tue, 23 Nov 2004 09:43:27 -0800 > From: Ron Thompson <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Periods in Column name > > I seem to have an issue with select-ing a column by name if it has more > than o

RE: Periods in Column name

at do you have to do to get it to work from the command line? -Original Message- From: Ron Thompson [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 23, 2004 12:43 PM To: [EMAIL PROTECTED] Subject: Periods in Column name I seem to have an issue with select-ing a column by name if it ha

Periods in Column name

I seem to have an issue with select-ing a column by name if it has more than one period in the name. One period works fine and I can do something like: my $upd_def = "10.3" . "_def"; my $getdefers = $dbh->prepare("SELECT $upd_def FROM macs WHERE ipaddress = ?");

Re: ORA-904 "invalid column name": wrong error message?

Andy, thanks a lot for this hint and that you really took the time to go through my lengthy posting! You were absolutely right, after I corrected the insert statement the error went away just like that! Andy Hassall wrote: You have ARTIKEL in the insert statement, but ARTIKELNUMMER in the table

RE: ORA-904 "invalid column name": wrong error message?

ROTECTED]> / Space: disk usage analysis tool <http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space> > -Original Message- > From: Dr. Frank Ullrich [mailto:[EMAIL PROTECTED] > Sent: 03 August 2004 08:21 > To: [EMAIL PROTECTED] > Subject: ORA-

ORA-904 "invalid column name": wrong error message?

Hi, I've got a mysterious problem with Oracle-DBD (v. 1.12) and DBI 1.32 against an Oracle 8.1.7.3 database. An execute fails with ORA-904 ("invalid column name") although the column names are correct and the prepare (it's an INSERT s

Re: column name

I wasn't using $hash_ref but I am using it now.It provides column name as key. Thanks !!! Jie "Kokarski, Anton" wrote: > if you are using method $hash_ref = $sth->fetchrow_hashref; then it should > be easy > > Anton > > -Original Message- > F

Re: column name

jie zhang writes: > Hi, > > I am writing a script which constructs dynamic query. I can't hard code > column names. > e.g. select * from $table; Is it possible to print out column names > from database through dbi ? Look at the "NAME" statement handle attribute in the DBI manual. Micha

RE: column name

if you are using method $hash_ref = $sth->fetchrow_hashref; then it should be easy Anton -Original Message- From: jie zhang [mailto:[EMAIL PROTECTED]] Sent: Friday, February 01, 2002 4:58 PM To: [EMAIL PROTECTED] Subject: column name Hi, I am writing a script which constructs dyna

column name

Hi, I am writing a script which constructs dynamic query. I can't hard code column names. e.g. select * from $table; Is it possible to print out column names from database through dbi ? Thanks in advance, Jie