|
 |
asp_web_howto thread: Two Questions...
Message #1 by "D a v i d" <registerukh@h...> on Tue, 30 Oct 2001 11:51:15 -0600
|
|
This time I have two questions:
1. We are migrating from Sybase 11 to Oracle 8 database and to this effect
my boss using Oracle tools, created the tables and copied the data from
Sybase to Oracle. The ASP code base remains the same.
Now the problem is say I have this ASP code...
"If objRS.Fields("numericfield") = 0 Then "
works well against Sybase but does not work againt Oracle and gives the
following error
Microsoft VBScript runtime error '800a000d'
Type mismatch
/asdf.asp, line 68
but when I use CInt(objRS.Fields("numericfield")) then the code works in
Oracle. Now my question is why the conversion is required. Did we miss some
aspect while migrating data to Oracle because the number field value in
Oracle needs explicit conversion in ASP code. And this is occuring only for
number datatypes.
I can do this (Cint thing) manually in one or two programs but there are
something like 110 programs and zillion places these number fields are used.
Any help or suggestions will really help me.
2. Do we have any tools to concatenate two or more PDF files to make a
master PDF file using VB or ASP on WindowsNT O/S? I need to provide this
functionality on web site.
Any help will be highly appreciated as I am stuck with no light in sight.
Thanks
Message #2 by Roger Balliger <Roger@i...> on Tue, 30 Oct 2001 10:14:45 -0800
|
|
Not sure on Q1 - but sounds like a data type conversion problem. Your Oracle
dbase could be a text type for that field or the numeric type isn't
recognized.
Q2 - are you referring to PDF as Portable Document Format (Adobe Acrobat)?
Roger
-----Original Message-----
From: D a v i d [mailto:registerukh@h...]
Sent: Tuesday, October 30, 2001 9:51 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Two Questions...
This time I have two questions:
1. We are migrating from Sybase 11 to Oracle 8 database and to this effect
my boss using Oracle tools, created the tables and copied the data from
Sybase to Oracle. The ASP code base remains the same.
Now the problem is say I have this ASP code...
"If objRS.Fields("numericfield") = 0 Then "
works well against Sybase but does not work againt Oracle and gives the
following error
Microsoft VBScript runtime error '800a000d'
Type mismatch
/asdf.asp, line 68
but when I use CInt(objRS.Fields("numericfield")) then the code works in
Oracle. Now my question is why the conversion is required. Did we miss some
aspect while migrating data to Oracle because the number field value in
Oracle needs explicit conversion in ASP code. And this is occuring only for
number datatypes.
I can do this (Cint thing) manually in one or two programs but there are
something like 110 programs and zillion places these number fields are used.
Any help or suggestions will really help me.
2. Do we have any tools to concatenate two or more PDF files to make a
master PDF file using VB or ASP on WindowsNT O/S? I need to provide this
functionality on web site.
Any help will be highly appreciated as I am stuck with no light in sight.
Thanks
Message #3 by Mark Eckeard <meckeard2000@y...> on Tue, 30 Oct 2001 10:19:39 -0800 (PST)
|
|
David,
In regards to number 1, my company had the same
problem when converting from SQL Server to Oracle.
I am not sure, but I think there is some inherent
feature between SQL Server & ASP (both being MS
products) that makes the data type transfer easy. The
same is not so for Oracle.
What did we do? We had to go thru our ENTIRE site and
explicitly convert most data types.
Mark
--- D a v i d <registerukh@h...> wrote:
> This time I have two questions:
>
> 1. We are migrating from Sybase 11 to Oracle 8
> database and to this effect
> my boss using Oracle tools, created the tables and
> copied the data from
> Sybase to Oracle. The ASP code base remains the
> same.
>
> Now the problem is say I have this ASP code...
>
> "If objRS.Fields("numericfield") = 0 Then "
>
> works well against Sybase but does not work againt
> Oracle and gives the
> following error
>
>
> Microsoft VBScript runtime error '800a000d'
> Type mismatch
>
> /asdf.asp, line 68
>
>
> but when I use CInt(objRS.Fields("numericfield"))
> then the code works in
> Oracle. Now my question is why the conversion is
> required. Did we miss some
> aspect while migrating data to Oracle because the
> number field value in
> Oracle needs explicit conversion in ASP code. And
> this is occuring only for
> number datatypes.
> I can do this (Cint thing) manually in one or two
> programs but there are
> something like 110 programs and zillion places these
> number fields are used.
>
> Any help or suggestions will really help me.
>
>
> 2. Do we have any tools to concatenate two or more
> PDF files to make a
> master PDF file using VB or ASP on WindowsNT O/S? I
> need to provide this
> functionality on web site.
>
> Any help will be highly appreciated as I am stuck
> with no light in sight.
>
> Thanks
Message #4 by "D a v i d" <registerukh@h...> on Tue, 30 Oct 2001 14:03:52 -0600
|
|
Thanks Mark and Roger...
About Q2 - Yes, it is PDF (Portable Document Format)
>From: Roger Balliger <Roger@i...>
>Reply-To: "ASP Web HowTo" <asp_web_howto@p...>
>To: "ASP Web HowTo" <asp_web_howto@p...>
>Subject: [asp_web_howto] RE: Two Questions...
>Date: Tue, 30 Oct 2001 10:14:45 -0800
>
>Not sure on Q1 - but sounds like a data type conversion problem. Your
>Oracle
>dbase could be a text type for that field or the numeric type isn't
>recognized.
>
>Q2 - are you referring to PDF as Portable Document Format (Adobe Acrobat)?
>
>Roger
>
>-----Original Message-----
>From: D a v i d [mailto:registerukh@h...]
>Sent: Tuesday, October 30, 2001 9:51 AM
>To: ASP Web HowTo
>Subject: [asp_web_howto] Two Questions...
>
>
>This time I have two questions:
>
>1. We are migrating from Sybase 11 to Oracle 8 database and to this effect
>my boss using Oracle tools, created the tables and copied the data from
>Sybase to Oracle. The ASP code base remains the same.
>
>Now the problem is say I have this ASP code...
>
>"If objRS.Fields("numericfield") = 0 Then "
>
>works well against Sybase but does not work againt Oracle and gives the
>following error
>
>
>Microsoft VBScript runtime error '800a000d'
>Type mismatch
>
>/asdf.asp, line 68
>
>
>but when I use CInt(objRS.Fields("numericfield")) then the code works in
>Oracle. Now my question is why the conversion is required. Did we miss some
>aspect while migrating data to Oracle because the number field value in
>Oracle needs explicit conversion in ASP code. And this is occuring only for
>number datatypes.
>I can do this (Cint thing) manually in one or two programs but there are
>something like 110 programs and zillion places these number fields are
>used.
>
>Any help or suggestions will really help me.
>
>
>2. Do we have any tools to concatenate two or more PDF files to make a
>master PDF file using VB or ASP on WindowsNT O/S? I need to provide this
>functionality on web site.
>
>Any help will be highly appreciated as I am stuck with no light in sight.
>
>Thanks
Message #5 by "Andrew Haslett" <scooter@p...> on Wed, 31 Oct 2001 09:38:09 +1030
|
|
This may help you with number 2: http://www.15seconds.com/issue/990902.htm
Cheers,
Andrew
-----Original Message-----
From: D a v i d [mailto:registerukh@h...]
Sent: Wednesday, 31 October 2001 4:21 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Two Questions...
This time I have two questions:
1. We are migrating from Sybase 11 to Oracle 8 database and to this effect
my boss using Oracle tools, created the tables and copied the data from
Sybase to Oracle. The ASP code base remains the same.
Now the problem is say I have this ASP code...
"If objRS.Fields("numericfield") = 0 Then "
works well against Sybase but does not work againt Oracle and gives the
following error
Microsoft VBScript runtime error '800a000d'
Type mismatch
/asdf.asp, line 68
but when I use CInt(objRS.Fields("numericfield")) then the code works in
Oracle. Now my question is why the conversion is required. Did we miss some
aspect while migrating data to Oracle because the number field value in
Oracle needs explicit conversion in ASP code. And this is occuring only for
number datatypes.
I can do this (Cint thing) manually in one or two programs but there are
something like 110 programs and zillion places these number fields are used.
Any help or suggestions will really help me.
2. Do we have any tools to concatenate two or more PDF files to make a
master PDF file using VB or ASP on WindowsNT O/S? I need to provide this
functionality on web site.
Any help will be highly appreciated as I am stuck with no light in sight.
Thanks
|
|
|
View Cart
