SPUG: perl - sql - text datafield
Ben Reser
ben at reser.org
Fri Oct 19 12:20:34 CDT 2001
On Fri, Oct 19, 2001 at 09:24:17AM -0700, Martin Korb wrote:
>
> I am writing a cgi program which queries a database table. One of the
> columns has data-type of text (meaning it exceeds 256 bytes). I am
> trying to display the content of all the columns on a page as cells of
> a table (this is the easy part). I am just not able to display the
> content of the column whose data-type is text. I know the content is
> actually stored as a pointer to the content in the database table, but
> I am not at all sure how do get out.
>
> Do I need to loop over the content and just advance the pointer to
> point to next 256 bytes or what....?
I believe the answer is dependent on the database driver you are using
and as a result the database itself that you are connecting to. It
would at least help me try to answer your question is you told us that.
--
Ben Reser <ben at reser.org>
http://ben.reser.org
"To fight and conquer in all our battles is not supreme excellence.
Supreme excellence consists in breaking the enemy's resistance without
fighting." -Chinese philosopher Sun Tzu
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
POST TO: spug-list at pm.org PROBLEMS: owner-spug-list at pm.org
Subscriptions; Email to majordomo at pm.org: ACTION LIST EMAIL
Replace ACTION by subscribe or unsubscribe, EMAIL by your Email-address
For daily traffic, use spug-list for LIST ; for weekly, spug-list-digest
Seattle Perl Users Group (SPUG) Home Page: http://zipcon.net/spug/
More information about the spug-list
mailing list