PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Noelle Schreiber <Noelle dot Schreiber at Central dot Sun dot COM>
Subject: Sybase:DBLib-> SQL output Question
Date: Jun 16 1999 9:34PM

Hello,

I am using Sybase::DBLib to connect to my DB and produce a report based on a SQL 
statement that returns several values (ie, attributes of a help desk request for 
a particular technician)

My question is:	In what format are the SQL results received into my variable (in 	
		the code below: $query)?  Is it a string of text delimited by 		
		spaces?  new lines?


thanks in advance!


noelle

THE START OF MY SCRIPT
-----------------------------
...

while ($login = ) {

        $query = "SELECT       Login.login, Request.submit_time, 			
				Request.close_time, Request.request_id,
                                Task_type.name, Feedback_rating.srv_rating, 		
				Feedback_rating.note,
	                        Feedback_rating.note_ext
                FROM            Login, Request, Task_type, Feedback_rating, 		
				Feedback_rating_note
                WHERE           Login.login = Request.login
                AND             Request.request_id = Feedback_rating.request_id
                AND             Request.tasktype_id = Task_type.tasktype_id
                AND             Request.login = $login
                AND             Request.submit_time BETWEEN CONVERT(DATETIME, 		
				$start_date) AND CONVERT(DATETIME, $end_date)
                ORDER BY        Feedback_rating_note.seqnum;
        $srvdsk_db->dbcmd($query);
        $srvdsk_db->dbsqlexec;
        while ($srvdsk_db->dbresults() !=NO_MORE_RESULTS) {

...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Noelle Schreiber
Email:		noelle.schreiber@central.sun.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~