Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: philip mikal <philipm at nafohq dot hp dot com>
Subject: Re: help with inserting text
Date: Feb 18 1998 7:06PM


Thanks for the response.  When I use the following subroutine to insert 
my data, I get errors regarding syntax errors, that seem to be caused by 
characters such as ("',@).  I'm sure I'm just forgetting something.



open (LINKS, "") || &CgiDie ("I am sorry, but I was
	not able to open the link database.   The value I have is Would you please check the path and the permission.");

while ()
	($link_title, $id, $unique_id, $link_url, $link_description, $author_email, $author_name) = split (/\|/, $_);
	$select = "insert into link_table values ($link_title, $id, $unique_id, $link_url, $link_description)";
	$select = "insert into link_owners_table values ($unique_id, `$author_name`, `$author_email')";
close (LINKS);

>      If your text strings aren't a great deal longer than you have here, 
>      then using dbwritetext is overkill and probably slower.  It's 
>      definitely more complicated.  That particular function is meant for 
>      dealing with large text strings.  
>      For data of the variety you have here, simply use a basic insert 
>      statement, which can populate text datatype columns just like any 
>      other, and can handle data up to approx. 128k.
>      Good luck,
>      Tim Green                              
>      Administrative Solutions Group
>      "An ADP/Mercer Alliance"
> ______________________________ Reply Separator _________________________________
> Subject: help with inserting text
> Author: at uucp
> Date:    2/17/98 6:44 PM
> Hello:
> I am a bit confused on how one inserts text into Sybase using DBlib. I have 
> data that I am trying to load into my database that looks like:
> µ-ziq|24|129||"America's premiere
>  electronic label, Astralwerks Records, presents the µ-ziq"|astralwerks@car
> I am taking this data from a text file, spliting it apart (pipe delimited, "|") 
> into variables and attempting to insert it into my database.  All my columns 
> are text datatypes except for two, integers, which in the above example, would 
> be "24" and "129".
> I believe I am to use dbwritetext, but I do not understand it properly. The 
> examples in the man pages are confusing to me, e.g., how does one determine 
> the column number.
> If anyone could explain how to accomplish this, it would be greatly 
> appreciated.
> Regards,
> Philip