Hi - complete newbie here again,

I have just tried constructing a very basic custom web page to search and read data off a single database shared from another computer (I am starting simple!). I thought it was all OK, but when I tried to seach from my HTML page, I got an error message telling me that the layout was not found. However, the database I am trying to read only has the one layout? So I am stuck. Can anyone help?

Nancy

Spelling problem? Syntax problem?

Post the code from your search.htm.

Here is my code for search.htm. I used another custom published page as my model and saved it to the Web Folder of FM 6.0.

Nancy

search.txt

First, Alisons db_mockup.fp5. Try instead either Alisons_db_mockup.fp5 or Alisonsdb_mockup.fp5. Same with any fields and layouts with spaces.

Next, the -LOP=And is the default and is not required. Omit it. If you must use it (and you don't need to) you should also enclose the And in quotes. Same with your fields TopicID, etc.Consistency of quote usage is beneficial from my experience.

Many suggest fewer than 50 with the -max, its a matter of speed for the client. Testing will tell you if you should reduce the display to say 20 found.

Your search is complex involving three fields: TopicID, title, and coordinator value (rename that without the space). Start with a simple search on one field. When that works, add the others.

Also, when you add the others, do you want the search performed on all three fields or will data in just one be sufficient to satisfy your design? I don't care, but you do.

Don't be in any rush to figure out all this. Figure out good design first. Good design is the answer for all developers.

Thank you,

I tried removing the space in the name of the database and it worked! Thanks also for the rest of the advice - I have now spent some time with pen and paper sketching what I want the final version to achieve.

Slow and steady....

Nancy