We have Perl substitute like this on many of our web queries into our Oracle db. -----Original Message----- From: Greg Jetter [mailto:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 11:31 To: Francesco Scaglioni; [EMAIL PROTECTED] Subject: Re: ? embed scalars in the sql On Monday 25 June 2001 06:59, Francesco Scaglioni wrote: > Hi, > > Is it possible to embed a scalar into the sql such that the value of > the scalar could represent a column name to report or a value to > select by > > eg something to mean the following > > select $column_name from test where $another_column_name = > $column_value > > or even better: > > count rows where $column_name = $column_name_value and $another_column > = $another_column_value > > > If I am making myself clear? > > TIA yes you can , I belive that Perl will do the subitution befor executing the line of code. If your going to work with data bases and sql use the "DMI .pm" and the approait database driver and it's a snap to work with a data base. Greg > > Francesco
