I believe it ;-) Thanks very much Peter!
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Peter Connell
Sent: Wednesday, December 09, 2009 3:49 PM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] Recursive query - net.data
No.
Surely you would just load the URLNAME column with the value
"V:\2008AP\some_doc_name" instead of just "some_doc_name"
Also, the lines like @DTW_ASSIGN(URLNAME,V_URLNAME) etc do not seem to
have any purpose. ?
Peter
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Don Cavaiani
Sent: Thursday, 10 December 2009 10:34 a.m.
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Recursive query - net.data
Peter,
No the DB2 file is not currently structured as a URL - but I don't see
why I could not do that. I like that idea! Is there a trick to
returning a complete url? Below is what I use now:
select SEARCH as URLNAME, replace(trim(SEARCH),' ',' ') as
READNAME, digits(RECNO) as RECNO FROM qgpl.apinv8
WHERE UPPER(SEARCH) like '%$(partv)%'
ORDER BY SEARCH
for fetch only
%Report{
<HTML>
<body bgcolor="d0d0d0">
<TABLE BORDER = "1">
%{<th align="left">Invoice Identification</th>%}
%{<th align="left">Record No.</th>%}
</tr>
%Row{
@DTW_ASSIGN(URLNAME,V_URLNAME)
@DTW_ASSIGN(READNAME,V_READNAME)
@DTW_ASSIGN(RECNO,V_RECNO)
<TR>
<a href="V:\2008AP\$(V_URLNAME)">$(V_READNAME)</a>
</TR>
%}
</TABLE>
%}
Thanks!
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Peter Connell
Sent: Wednesday, December 09, 2009 1:55 PM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] Recursive query - net.data
Don,
Does that imply that the directory structure might be irrelevant?
I am assuming that you have a DB2 file containing a list of names each
of which is essentially the url for a document that resides in a folder
on a server available as a network drive via Windows Explorer.
You would return the matching url(s) as links on a response page which
would allow the user to simply click to open the document.
Peter
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Don Cavaiani
Sent: Thursday, 10 December 2009 7:56 a.m.
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Recursive query - net.data
Peter,
Exactly - you say that so much better than I. The "index" search (SQL)
is done on the System i, but all of the actual documents are stored on a
windows server.
Don
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Peter Connell
Sent: Wednesday, December 09, 2009 12:09 PM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] Recursive query - net.data
Don,
So you want a web page with an input box which when submitted with a
wildcard type value will cause a directory tree to be searched and
return a list of one or more matching candidates.
Are the folders to be searched on the PC directly or using the same
folders on the IFS?
Peter
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Don Cavaiani
Sent: Wednesday, 9 December 2009 1:39 a.m.
To: web400@xxxxxxxxxxxx
Subject: [WEB400] Recursive query - net.data
I'm curious if there is a way to do the following:
I have a directory structure ( on a PC ) similar to this:
ALL_Documents
Quality Docs
Operations Docs (These are just WORD documents)
Finance Docs
Shipping Docs
etc.
Inside each of the departmental folders, there are many ISO documents
with lengthy names - which we would like to 'search for and call up' by
partial "key" scanning.
I know how to build a macro which would FIRST ask the user to position
to the specific folder they are looking into, and then ask for the
keyword to scan for.
Example:
--------------------
Quality |
Operations |
Finance | User would first be required to highlight which folder
they want to scan.
Shipping |
-------------------
Enter the partial or full keyword to search by:
____________________________________ (then the user would enter in
their "search' keyword.)
The macro would have four separate queries - based on what the user
selected in the 'top' section.
My question is this: Is there some way to eliminate having the user
'choose' which directory they are positioning to, and instead just have
the search for the keyword begin at the ALL_Documents level and
automatically go thru each of the 4 sub-folder levels?
TIA
Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063
"It's amazing what you can accomplish if you don't care who gets the
credit." Harry S. Truman
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
Visit our website www.vedaadvantage.com. It has a new design with
improved navigation and search capabilities; and customer friendly
interface with more relevant insights and solutions to help you make
informed decisions.
########################################################################
#############
This correspondence is for the named person's use only. It may contain
confidential or legally privileged information, or both. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this correspondence in error, please immediately delete
it from your system and notify the sender. You must not disclose, copy
or rely on any part of this correspondence if you are not the intended
recipient.
Any views expressed in this message are those of the individual sender,
except where the sender expressly, and with authority, states them to be
the views of Veda Advantage.
If you need assistance, please contact Veda Advantage on either :-
Australia 1300-921-621 or New Zealand +64 9 367 6200
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
Visit our website www.vedaadvantage.com. It has a new design with
improved navigation and search capabilities; and customer friendly
interface with more relevant insights and solutions to help you make
informed decisions.
########################################################################
#############
This correspondence is for the named person's use only. It may contain
confidential or legally privileged information, or both. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this correspondence in error, please immediately delete
it from your system and notify the sender. You must not disclose, copy
or rely on any part of this correspondence if you are not the intended
recipient.
Any views expressed in this message are those of the individual sender,
except where the sender expressly, and with authority, states them to be
the views of Veda Advantage.
If you need assistance, please contact Veda Advantage on either :-
Australia 1300-921-621 or New Zealand +64 9 367 6200
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
Visit our website www.vedaadvantage.com. It has a new design with
improved navigation and search capabilities; and customer friendly
interface with more relevant insights and solutions to help you make
informed decisions.
########################################################################
#############
This correspondence is for the named person's use only. It may contain
confidential or legally privileged information, or both. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this correspondence in error, please immediately delete
it from your system and notify the sender. You must not disclose, copy
or rely on any part of this correspondence if you are not the intended
recipient.
Any views expressed in this message are those of the individual sender,
except where the sender expressly, and with authority, states them to be
the views of Veda Advantage.
If you need assistance, please contact Veda Advantage on either :-
Australia 1300-921-621 or New Zealand +64 9 367 6200
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
midrange.com
