sybperl-l Archive

From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: how to use ct_sql
Date: Sep 30 1998 8:28PM

Nathan Pilatzke writes:
 > I'm a new Sybperl user and I'm having problems using ct_sql.
 > 
 > I have a command in my CGI script that looks like:
 > @results = $dbh->ct_sql("select " .
 >                             "* " .
 >                         "from " .
 >                             "unjust, decisions " .
 >                         "where " .
 >                             "Lsep_ref_no='788-3B-10218' and " .
 >                             "Lsep_ref_no=Lsep_ref_no_2 and " .
 >                             "Decision_no=1");
 > 
 > This command works, but I want to return an arrary of hash references.  I
 > read the documentation and tried this for the last line:
 >                             "Decision_no=1", ,1);
 > and:
 >                             "Decision_no=1", ,CS_TRUE);

You want:

@results = $dbh->ct_sql($sql, undef, CS_TRUE);

Michael
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@mbay.net       -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com