Acces PM BLOB Value Missing

[jija]

Hello.. I´m trying to get a value from a column that has
the datatype PM (swedish) , I think it´s called BLOB, but
the Value is missing.

i can do like this to get the Value:

recordsetname("columnName").Value

BUT I want to this dynamicly.... like this:

recordsetname(index).Value

When I do this.... the Value is missing....

I have tried this too:

recordsetname(recordsetname(index).Name).Value

But it doesn´t work either.


Please help!
/jija

 

[Van T. Dinh]

Not sure I got the question right but try:

RecordsetName.Fields(YourIndex).Value

--
HTH
Van T. Dinh
MVP (Access)



Hello.. I´m trying to get a value from a column that has
the datatype PM (swedish) , I think it´s called BLOB, but
the Value is missing.

i can do like this to get the Value:

recordsetname("columnName").Value

BUT I want to this dynamicly.... like this:

recordsetname(index).Value

When I do this.... the Value is missing....

I have tried this too:

recordsetname(recordsetname(index).Name).Value

But it doesn´t work either.


Please help!
/jija

 

[Exponent]

I tried the following syntax variations in one of our samples - in every case the image in the binary field
was displayed correctly.

DBPixCtl.Image = rst("Image").Value
DBPixCtl.Image = rst("Image")
DBPixCtl.Image = rst(1).Value
DBPixCtl.Image = rst(1)

Are you sure that your index points at the correct field (zero-based) ?
Are you sure that the value returned is really missing/empty ? (how are you determining this/what are you
trying to do with the data ?)

 

[jija]

I´m sure that the data is NOT empty. And I´m sure that the
Index is pointing to the right position. I´ve tried the
same syntax in Visual Basic... and that works all fine.
But then in ASP (VB Script) it doesnt.... why?

-----Ursprungligt meddelande-----


I tried the following syntax variations in one of our

samples - in every case the image in the binary field

was displayed correctly.

DBPixCtl.Image = rst("Image").Value
DBPixCtl.Image = rst("Image")
DBPixCtl.Image = rst(1).Value
DBPixCtl.Image = rst(1)

Are you sure that your index points at the correct field (zero-based) ?
Are you sure that the value returned is really

missing/empty ? (how are you determining this/what are you