asp displaying long raw field

6 Mar 2005 5:27 PM

Bob Bob

Hi All,

I have an Oracle database which has a field LONG RAW type to store text
files. I'm trying to display the output of this field in ASP but I'm
having
problems.

I've gone through many different approaches but they either do nothing
or do
the following;

I've tried doing response.binarywrite(rs("data_object")) and I get
something
like below

?<?S¿O?A?~·Ç?¸?ä?R~?m$!»?Ä?!S?Z ?÷Ð?#Å1ì
{
»3ëÌÛc-4Úhac±ÑhaIâß`¬5±ÔÊØ[Û:»ìý@*d6ïÍ{ûÍ÷¾÷æè?ä¤?«6÷u?Tx.s"íSaSý?óºDn
ï+Kìïzü@'6ºM??è¥Ô0Ù._
..
?úM®AÁ"!Ò?1Ë&OûTJâÐSàþ??M×¦U^§&oM?>¼ëØ,?-?!VI?(.?£Ö?i?#D×3îP?¹X´`¤?³io'N
¢G~cl
P?«Ä3;'´ûð?4 z?ñij1?aé?i?0Öuí*' ÅGÁ
ò?;äb?O?¹??_ÆNÖ,,<®euA?@¦µ?Å³zJ?"áê_Z?ª+#1?=¦ §?r½ß?~?ßþs??y"z.Ä'~Ð
Aef{õ(Xº?ñê;èSß,Ú9"ìÌÂ\?2ÖH7?R?SÑYïÞÿ~òl^fO ¹&ñB?
?îä.þ??O^N??<×'Sú?ÈÙ¤ì¼ò³?Zq¡í^LÂÅ¶¯©ðlW8';'òZ?ûíÕÃÇ<?2?dM?±I@ì¤%¶

>ehÂõ?kT? · ºe,Dul«knîì)ÈÅ"j¼´P´?Z«J?^|¹ûvXNy²òS×ü???t?>_YïyóúÆ¶â?

êO²zm×#Z?C'? ¥fs¥z"éè !??Å?§S?Â?ãxÉ¸%¸Æ".Ï¨?×«-{®*×X¥¤N.4J^ÄnÄ
Ô?E&¯MÎL!ô-WÖCÎ$jYWh-ÿ © T Ò.özs® ªND??ér¦ÞÎDJ`º~O?¦g.U)Ý¶6§ç""sej»qò
s\FÓ'ÿ?^öbäO?

The data type is adLongVarBinary and ive seen some sites suggest binary
to
multibyte but I have no idea how to do that or if its on the write
lines.
Does anyone have any ideas?

Many many many thanks in advance :o)
Bob

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

6 Mar 2005 5:55 PM

Bob Barrows [MVP]

Bob Bob wrote:

> Hi All,
>
> I have an Oracle database which has a field LONG RAW type to store

Yes, we read that the first time you posted it! We even saw it when you
posted it last week. You got some suggestions ten, as I recall. Why not
continue the conversation by adding new information in the original thread?

Reposting it every few hours will not make it more likely to be answered. On
the contrary, it will make it more likely that you will be ignored.

There are many reasons for not getting answers to your questions. The one
that applied to this one (at least for me) was the "I don't know" reason. I
rarely use binary fields in SQL Server, and I've never used Oracle. You
might try an ADO or Oracle newsgroup.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

6 Mar 2005 7:15 PM

bob

Opps, I've been having problems with none of the messages I posted showing
up in outlook express.
I had to rebuild my pc a couple of weeks ago and I thought that I had some
setting wrong, so I did a resend but still no joy. Thats why I tried
sending the question via http://www.developersdex.com

Apologies to all for there been several repeats. I wonder if it was because
of the binary data example in the email which was why It didnt show up and
any replies?
Hopefully this will come up and I can try those examples that I have found
to the replies on http://www.developersdex.com.

Many thanks for all your replies, hopefully one of them will work :o)

Show quote

"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:e%23ToyWnIFHA.236@TK2MSFTNGP14.phx.gbl...
> Bob Bob wrote:
>> Hi All,
>>
>> I have an Oracle database which has a field LONG RAW type to store
>
> Yes, we read that the first time you posted it! We even saw it when you
> posted it last week. You got some suggestions ten, as I recall. Why not
> continue the conversation by adding new information in the original
> thread?
>
> Reposting it every few hours will not make it more likely to be answered.
> On the contrary, it will make it more likely that you will be ignored.
>
> There are many reasons for not getting answers to your questions. The one
> that applied to this one (at least for me) was the "I don't know" reason.
> I rarely use binary fields in SQL Server, and I've never used Oracle. You
> might try an ADO or Oracle newsgroup.
>
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>

6 Mar 2005 9:42 PM

Adrienne

Gazing into my crystal ball I observed "bob" <bob@nospam.com> writing in
news:d0fkt9$7kc$1@hercules.btinternet.com:

> Opps, I've been having problems with none of the messages I posted
> showing up in outlook express.
> I had to rebuild my pc a couple of weeks ago and I thought that I had
> some setting wrong, so I did a resend but still no joy. Thats why I
> tried sending the question via http://www.developersdex.com
>
>

My suggestion to you is to get a better news reader. I like XNews -
<http://xnews.newsguy.com/>.

You can also use Google Groups to see if a particular message has been
posted/replied to.

--
Adrienne Boswell
http://www.cavalcade-of-coding.info
Please respond to the group so others can share