Jump to URL...

Hey All,
I have a report that tells the user all of the applied published fixes
that are out there. The report has an ODBC connect to a .txt file on a
defferent server. That is finally working great (i hate permissions
:)). Now I have to take the Fix_nbr field (which is a calculated field)
and add a hyperlink to it. User is to click on the fix number in the
report and it should go to the defferent server and pick up the HTM
file about that particular fix number and display it to the user. What
happens is when I click on the fix number, the sign in box for the
defferent server comes up, I sign in...then I get "Page Cannot be
Found...HTTP Error 404 - File or directory not found."
The expression below is what I am using and I have tried different
variations of this.
="http://cmbsssharrisdev/Fixes/Applied - Published/" &
Fields!Fix_Nbr.Value & ".htm"
Anyone have any suggestions of why this might be happening, any help
would be great!
I have to have this done by EOD tomorrow.
Thanks in advance!!!!
KerrieCheck in the IIS logs of the different server and see what URL you are
actually attempting to view. Could it be that you need to put %20 in for the
spaces in the url?
"Kerrie" wrote:
> Hey All,
> I have a report that tells the user all of the applied published fixes
> that are out there. The report has an ODBC connect to a .txt file on a
> defferent server. That is finally working great (i hate permissions
> :)). Now I have to take the Fix_nbr field (which is a calculated field)
> and add a hyperlink to it. User is to click on the fix number in the
> report and it should go to the defferent server and pick up the HTM
> file about that particular fix number and display it to the user. What
> happens is when I click on the fix number, the sign in box for the
> defferent server comes up, I sign in...then I get "Page Cannot be
> Found...HTTP Error 404 - File or directory not found."
> The expression below is what I am using and I have tried different
> variations of this.
> ="http://cmbsssharrisdev/Fixes/Applied - Published/" &
> Fields!Fix_Nbr.Value & ".htm"
> Anyone have any suggestions of why this might be happening, any help
> would be great!
> I have to have this done by EOD tomorrow.
> Thanks in advance!!!!
> Kerrie
>|||I tried what you have suggested and it did not help. Any other
suggestions?
Do you think maybe that it is a HTM file i am trying to get from a
shared folder from a different server?
lsmithmier wrote:
> Check in the IIS logs of the different server and see what URL you are
> actually attempting to view. Could it be that you need to put %20 in for the
> spaces in the url?
> "Kerrie" wrote:
> > Hey All,
> >
> > I have a report that tells the user all of the applied published fixes
> > that are out there. The report has an ODBC connect to a .txt file on a
> > defferent server. That is finally working great (i hate permissions
> > :)). Now I have to take the Fix_nbr field (which is a calculated field)
> > and add a hyperlink to it. User is to click on the fix number in the
> > report and it should go to the defferent server and pick up the HTM
> > file about that particular fix number and display it to the user. What
> > happens is when I click on the fix number, the sign in box for the
> > defferent server comes up, I sign in...then I get "Page Cannot be
> > Found...HTTP Error 404 - File or directory not found."
> >
> > The expression below is what I am using and I have tried different
> > variations of this.
> >
> > ="http://cmbsssharrisdev/Fixes/Applied - Published/" &
> > Fields!Fix_Nbr.Value & ".htm"
> >
> > Anyone have any suggestions of why this might be happening, any help
> > would be great!
> > I have to have this done by EOD tomorrow.
> >
> > Thanks in advance!!!!
> > Kerrie
> >
> >|||NEVERMIND...I GOT IT WORKING! The directory was not regisiter through
IIS!!!
THANKS SO MUCH FOR THE SUGGESTION!
Kerrie wrote:
> I tried what you have suggested and it did not help. Any other
> suggestions?
> Do you think maybe that it is a HTM file i am trying to get from a
> shared folder from a different server?
>
> lsmithmier wrote:
> > Check in the IIS logs of the different server and see what URL you are
> > actually attempting to view. Could it be that you need to put %20 in for the
> > spaces in the url?
> >
> > "Kerrie" wrote:
> >
> > > Hey All,
> > >
> > > I have a report that tells the user all of the applied published fixes
> > > that are out there. The report has an ODBC connect to a .txt file on a
> > > defferent server. That is finally working great (i hate permissions
> > > :)). Now I have to take the Fix_nbr field (which is a calculated field)
> > > and add a hyperlink to it. User is to click on the fix number in the
> > > report and it should go to the defferent server and pick up the HTM
> > > file about that particular fix number and display it to the user. What
> > > happens is when I click on the fix number, the sign in box for the
> > > defferent server comes up, I sign in...then I get "Page Cannot be
> > > Found...HTTP Error 404 - File or directory not found."
> > >
> > > The expression below is what I am using and I have tried different
> > > variations of this.
> > >
> > > ="http://cmbsssharrisdev/Fixes/Applied - Published/" &
> > > Fields!Fix_Nbr.Value & ".htm"
> > >
> > > Anyone have any suggestions of why this might be happening, any help
> > > would be great!
> > > I have to have this done by EOD tomorrow.
> > >
> > > Thanks in advance!!!!
> > > Kerrie
> > >
> > >

JOIN queries ?

Hi,

Can you give the equivalent query for the following Oracle query :

SELECT col2, col3 FROM submission,
lkup so
WHERE so.txt (+) = TRIM(col2)
AND so.pid (+) = 'SO'
AND so.cde (+) = 'RW'

In the above query a constant value is used in JOIN, so I am not aware of how to use the JOIN clause for the above constant value ( 'SO' , 'RW' )

Upto my knowledge about JOIN query equivalents :

Oracle query :-

select *from test1 a, test2 b where a.sno(+) = b.col

Equivalent SQL Server query :-

select *from test1 a JOIN test2 b on a.sno = b.col

Hope the above is correct. Here my doubt is, if in the above query, b.col is replaced by a constant value say 'abcd' , then what will be the table name used in right of the JOIN clause. Or any other equivalent for this is available ?

Eg :-

Oracle query :-

select *from test1 a, test2 b where a.sno(+) = 'abcd'

Thanks,
SamHi Sam,

the syntax used by Oracle with "(+)" in the WHERE-clause is equivalent to an OUTER JOIN in SQL Server and DB2.

The example you mentioned should be a LEFT OUTER JOIN, but I'm always a bit confused when using OUTER JOINS in Oracle, so I may be wrong :-)

You can lookup Oracle syntax at http://tahiti.oracle.com
Carsten|||Hi, OK, it is RIGHT JOIN, but my requirement is different, Please go through my posting once again. Thanks for your information.|||SELECT col2, col3 FROM submission,
lkup so
WHERE so.txt (+) = TRIM(col2)
AND so.pid (+) = 'SO'
AND so.cde (+) = 'RW'

SELECT col2, col3 FROM submission
Right Outer Join lkup so
On so.txt = LTRIM(RTRIM(col2)) AND so.pid = 'SO' AND so.cde = 'RW'

JOIN queries

Hi,

Can you give the equivalent query for the following Oracle query :

SELECT col2, col3 FROM submission,
lkup so
WHERE so.txt (+) = TRIM(col2)
AND so.pid (+) = 'SO'
AND so.cde (+) = 'RW'

In the above query a constant value is used in JOIN, so I am not aware of how to use the JOIN clause for the above constant value ( 'SO' , 'RW' )

Upto my knowledge about JOIN query equivalents :

Oracle query :-

select *from test1 a, test2 b where a.sno(+) = b.col

Equivalent SQL Server query :-

select *from test1 a RIGHT JOIN test2 b on a.sno = b.col

Hope the above is correct. Here my doubt is, if in the above query, b.col is replaced by a constant value say 'abcd' , then what will be the table name used in right of the JOIN clause. Or any other equivalent for this is available ?

Eg :-

Oracle query :-

select *from test1 a, test2 b where a.sno(+) = 'abcd'

Thanks,
SamSam,

The(+) is an outter join right?

How can you do an outter join to a literal?