Requirements for successfull CDML Search?

January 4, 200125 yr

Could some one please outline the requirements to perform a Search using CDML and listing the results. I have been at this for hours and can't seem to get it working. On the first try it gives me an error 4. All subsequent requests result in an error that says can access "layout24".

User is logging in with a password that has access to entire file.

Database "Job Tracker" has a field "Dept" used in "layout24".

Here is my search form...

-------------

<OPTION SELECTED>equals

<OPTION>not equals

<OPTION>contains

<OPTION>begins with

<OPTION>ends with

</SELECT>

</FORM>

---------

January 4, 200125 yr

Author

OK so I got that working. Now I need to get the Valulist working so users can choose dept from a list. It will not work.

Once the menu loads into IE the initially selected value is [FMP-ValueListItem][/FMP-ValueList] and these are no menu choices.

Hers my code...

---

Dept:

<P>

<select name ="Dept"> [FMP-ValueList: Dept , Dept]

<option selected> [FMP-ValueListItem] [/FMP-ValueList]

</select>

---

Do Ineed to have a layout with the "dept" field in it and do I have to assign the "dept" value list to that field?

Thanks,

G

January 5, 200125 yr

"Do Ineed to have a layout with the "dept" field in it and do I have to assign the "dept" value list to that field?"

Yes.

A word about layouts and the web. Make life simple. Keep layouts to a minimum for the web.

Is your database's valuelist being accessed directly by someone who is authorized to access that layout? Good. Leave it there. Employees love clicking buttons and checking boxes.

You are dealing with a browser solution to the database.

You should consider a main layout which has all the fields used in the database. You can call it main or web or hotdog, doesn't matter. Does not even have to be specially arranged and colored and made pretty. What matters is this is the layout you access from the web. Your valuelists should be displayed in text fields so that the appropriate checkbox or radio button from the employee accessible layout is displayed as text in the web layout.

Remember that through the password feature of the FileMaker

January 5, 200125 yr

Author

My code for the Valuelist has to be wrong. It's not even getting parsed by FMP. It's coming out just like it looks in "Dreamweaver", brackets and all.

Here is my search page...

------

<HTML>

<HEAD>

<TITLE>Search Database Template</TITLE>

</HEAD>

<BODY>

<H2>Sample Search Form</H2>

<P>

<P>

<P>Field Dept<BR>

<OPTION SELECTED>equals

<OPTION>not equals

<OPTION>contains

<OPTION>begins with

<OPTION>ends with

</SELECT>

<P>

<P>Dept:

[FMP-ValueList: Dept]

<OPTION VALUE="[FMP-ValueListItem]">[FMP-ValueListItem]

[/FMP-ValueList:]

</SELECT>

</FORM>

</BODY>

</HTML>

---------

January 5, 200125 yr

Author

I think that the value list along with other tags like "[FMP-ClientType]" don't get proccesed by simply including them in a page and requesting that page via a web browser. Do I need a special action tag to be included in a hyperlink to the search page to get it to parse the FMP tags on that search page before sending the page to the browser? I am missing the big picture!