Hi

In my result set i have one column of (mysql type longtext) which i
cannot read from my vbscript

myRecordSet.Fields.Item(col).value is Null

although the watch point on the resultset shows the right text string
stored in the database.

Any ideas?

Best regards
Hannes

If the watch is getting data, then there is data. Yo may have a lot of white
character yo are not seeing. Try adding this line of code

msgbox("The length of the cell is : "len(myRecordSet.Fields.Item(col).value))

Another possiblity is the object is not text but some sort of picture?

"hheckner" wrote:

> Hi
>
> In my result set i have one column of (mysql type longtext) which i
> cannot read from my vbscript
>
> myRecordSet.Fields.Item(col).value is Null
>
> although the watch point on the resultset shows the right text string
> stored in the database.
>
> Any ideas?
>
> Best regards
> Hannes
>

In your connection string - what driver are you specifying?

If you're using out of the box ODBC longtext won't be supported.

On 7 Apr., 21:47, "gimme_this_gimme_t...@yahoo.com"
<gimme_this_gimme_t...@yahoo.com> wrote:
> In your connection string - what driver are you specifying?
>
> If you're using out of the box ODBClongtextwon't be supported.

Hi,

we use the following connection string:
oConn.Open "DRIVER={MySQL ODBC 5.1 Driver};SERVER=" & curPreset.host &
";USER=" & user & ";PASSWORD=" & password & ";database=" &
curPreset.db & ";"

Any alternatives?

Thanks
Hannes

On 7 Apr., 20:00, joel <j...@discussions.microsoft.com> wrote:
> If the watch is getting data, then there is data. *Yo may have a lot ofwhite
> character yo are not seeing. *Try adding this line of code
>
> msgbox("The length of the cell is : "len(myRecordSet.Fields.Item(col).value))
>
> Another possiblity is the object is not text but some sort of picture?
>
> "hheckner" wrote:
> > Hi
>
> > In my result set i have one column of (mysqltypelongtext) which i
> > cannot read from my vbscript
>
> > myRecordSet.Fields.Item(col).value is Null
>
> > although the watch point on the resultset shows the right text string
> > stored in the database.
>
> > Any ideas?
>
> > Best regards
> > Hannes

No there is text in there. No pictures.
Funny thing is that we can see the text string in the debugger, but we
cannot get it work in the script.

5.1 is fairly recent.

It's likely that the value must be read as a stream.

I googled and found this link.

Try something like this:

http://www.aspfree.com/c/a/Database/...ream-Object/2/