Yup...
you were right Josh....
But actually I have defined that column as 'text' and not 'BLOB'.. But,
I wrote a small script to write query on that column and I was able to
see that.. So, my confusion has gone now..
The reason why I was wondering is, I had one application in which I am
using 'text' column and when I check that column on command prompt I am
able to see contents for that.. So, I was like, why its working for that
and not for this..
But oh well..
Thanks again...
Niral
[EMAIL PROTECTED] wrote:
>
> In a message dated 6/1/2000 10:59:48 AM Eastern Daylight Time,
> [EMAIL PROTECTED] writes:
>
> > Now, I am successfully able to run the script and generate sessionID and
> > store that sessionID in MySQL database table.. But column 'a_session' is
> > always empty!! Following is my code.. When I ran this code first time, I
> > thought, I will have value of '$name' in column 'a_session' but I was
> > wrong!! I mean I am in impression that, in MySQL datastore we can store
> > all information about session for a particular sessionID. But it's not
> > the case.. Whereas if I run the sample example which uses
> > Apache::Session::File, I can see value of '$name' in the actual session
> > file!!! So, Can somebody clear my doubts here??
> >
> > Thanks in advance..
>
> If you followed the perldocs, you also made a_session a BLOB.
> You won't be able to see the contens of the BLOB doing a
> simple select from a command line SQL interface. A BLOB is
> binary data.
>
> Plus, it has three columns, not two as you say...
> id varchar(16)
> length int(11)
> a_session blob
>
> -Josh Narins
