Received: from axe.net.au (root@axe.net.au [203.35.182.2]) by hub.org (8.9.1/8.9.1) with ESMTP id CAA11664 for ; Wed, 6 Jan 1999 02:04:20 -0500 (EST) (envelope-from martin@axe.net.au) From: martin@axe.net.au Received: from hatchet (martin@mattock.axe.net.au [203.35.182.4]) by axe.net.au (8.9.2/8.9.2) with SMTP id SAA16837; Wed, 6 Jan 1999 18:04:13 +1100 (EST) Message-Id: <199901060704.SAA16837@axe.net.au> X-Sender: park2@axe.net.au X-Mailer: QUALCOMM Windows Eudora Pro Version 4.0 Date: Wed, 06 Jan 1999 18:01:35 +1100 To: pgsql-sql@postgresql.org Subject: placeholders Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Hi, I am using - Postrges 6.3.2 - DBI 0.93 - DBD-pg 0.73 - Slackware 3.3 Linux I am accessing the database using a perl CGI program. I need to be able to list records from a database in various sort orders. The user needs to be able to select the sort order using a web form. The code I am using which works fine is $sth1 = $dbh->prepare (q { SELECT DISTINCT catalogid, productid, reference, title, dateposted, dateremove, userlastupdate, email, webaddress, phone, details, category FROM product WHERE (( catalogid = 'mp') AND ( category like :1 ) AND ( details like :2 ) AND ( userlastupdate like :3 )) ORDER BY title DESC } ); $counter = 0; $sth1->execute (("$category\%"),("$keywords\%"), ("$postedby\%")) or die "$DBI::errstr\n"; while ( ( $catalogid, $productid, $reference, $title, $dateposted, $dateremove, $userlastupdate, $email, $webaddress, $phone, $details, $category ) = $sth1->fetchrow() ) { $counter = $counter + 1; After this the CGI writes out HTML for each row read. I want to be able to change the code so the field name in the order by clause is variable eg. instead of ORDER BY title DESC I want to say ORDER BY :4 DESC and in the execute statement $sth1->execute (("$category\%"),("$keywords\%"), ("$postedby\%")) add a fourth variable ("$orderby") which will be set to title, dateposted or userlastupdate However if I use ("$orderby") as the fourth variable and set $orderby to title then my trace shows DBI puts 'title' into the SQL SELECT statement not title and I get an invalid syntax error. I need to find a way to stop putting the ' ' around title. Is there any way I can make the order by operand a variable ?? Thanks, Martin Stewart