is it possible to query a second db from within an existing value list like below? I run into an 102 error format not found.

<option value =

"/fmpro?-db=calendar.fp5&-lay=pressroom&-format=pr results.html&-token=print date&-new">

Pressroom</option>

??

The value list was created to search a scheduling db and works perfectly on its own. The cdml/html for the calendar.fp5 db also works fine on its own. However it would be beneficial to have a common search frame to query both dbs. Calendar.fp5 is stricly for pressroom which is why i've placed the coding at that option value.

The whole html appears below...I've deleted all the extraneous html table/p tags to make it easier to fall.

<form action = "FMPro" method = "post">

<input type = "hidden" name = "-db" value = "Schedule_2002.FP5" />

<input type = "hidden" name = "-lay" value = "all" />

<input type = "hidden" name = "-error" Value = "error.html" />

<input type = "hidden" name = "-sortfield" value = "print date" />

Enter Date

<input type = "text" name = "print date" value = "">

Choose which type of record you wish to view

<select name = "-format" >

<option value = "single_record.html">Full Record</option>

<option value = "multiple_record.html">Master Summary</option>

<option value = "prepress.html">Prepress</option>

<option value = "

"/fmpro?-db=calendar.fp3&-lay=pressroom&-format=pr results.html&-token=print date&-new">

Pressroom</option>

<option value = "distribution.html">Distribution</option>

</select>

<input type = "submit" name = "-find" value = "Enter">

</form>

</html>

any feedback would be greatly appreciated?

cheers

phil courterelle

For this type of thing I use multiple forms and some Javascript to submit the desired one.

All the best.

Garry

Error 102 = Field is missing.

Check that the field names are coreect and the specified layout contains all the fields referenced by the CDML file.

Vaughan, Garry...thanks for the response...much appreciated..

Garry...i've never done any java scripting so that option is not available to me in the short term although I will keep it under consideration...

Vaughn...field names are correct and the layout contains all the fields referenced by the CDML...the error I receive is:

The format file "/fmpro?-db=calendar.fp5&-lay=pressroom&-format=pr results.html&-token=print date&-new" could not be found.

normally the <option value> value tag refers to a html page and it seems that FM considers the url string as a html page. It is not seeing it as a separate request to create a new record in a seaprate db.

I'm thinking that because the option value is part of a -find request that it is processing the -find but not the -new request.

p

Try remove spaces in URL or encode them.

Anatoli...encode how? Raw, HTML ect..?

thanks

p

From FMI CDML database:

Encoding. Use one of the following reserved words:

Raw - Don't perform any encoding

URL - Perform URL encoding

HTML - (default) Perform HTML encoding

I guess URL should help.

Encode them like this:

/fmpro?-db=calendar.fp5&-lay=pressroom&-format=pr%20results.html&-token=print%20date&-new

This may help. Unless the format file is not in the "Web" Directory/Folder! Also, the "-token" assignment looks a bit strange; should it be &-token=[FMP-Field:print date]&?

All the best.

Garry

If you still have a problem, let me know the actual url that causes the error. if it is the result of a submit, let us know what is being submitted.

From your decription of the error, it appears that Web Companion thinks that the URL is actually the path for the format file.

Vaughan,

there are two things being submitted...a -find to scheduling db which is part of the form and a -new to a calendar db which is contained in a url.

I agree WC thinks the URL is the path to the format file and I don't think there is a way around it...

an html value list is part of a -find request to a db called Schedule. The user can enter a project name, print date or insertion date. I'm using a html value list to direct the results to specific html pages for various departments: Prepress, Pressroom, Distribution, Advertising ect. to help tailor the information the user recieves. When the -find request is process through the Schedule db, everything works fine.

What I've added is a url to the Pressroom option in the value list in an attempt to route the -find request to a second db called Calendar. The url is as below...<option value = "

"/fmpro?-db=calendar.fp3&-lay=pressroom&-format=pr results.html&-new">

if I place the same url -new request inside a link (<a href=fmpro?-db=calendar.fp3&-lay=pressroom&-format=pr results.html&-new>, it works fine but I am unable to pass the information contained in the print date field to the calendar db for processing...a damned if I do, damned if I don't kind of thing...

cheers

p

<select name = "-format" >

<option value = "single_record.html">Full Record</option>

<option value = "multiple_record.html">Master Summary</option>

<option value = "prepress.html">Prepress</option>

<option value = "

"/fmpro?-db=calendar.fp3&-lay=pressroom&-format=pr results.html&-token=print date&-new">

Pressroom</option>

<option value = "distribution.html">Distribution</option>

</select>

<input type = "submit" name = "-find" value = "Enter">