Jump to content

Requirements for successfull CDML Search?


This topic is 8600 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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...

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

<FORM ACTION="FMPro" METHOD="post">

<INPUT TYPE="hidden" NAME="-db"VALUE="Job_Tracker">

<INPUT TYPE="hidden" NAME="-lay" VALUE="Layout24">

<INPUT TYPE="hidden" NAME="-format" VALUE="listView.html">

<P><SELECT NAME="-op">

<OPTION SELECTED>equals

<OPTION>not equals

<OPTION>contains

<OPTION>begins with

<OPTION>ends with

</SELECT>

<P><INPUT TYPE="text" NAME="Dept" VALUE="" SIZE=30>

<P><INPUT TYPE="submit" NAME="-find" VALUE="Start Search">

<P><INPUT TYPE="reset" VALUE="Clear Form">

</FORM>

---------

Link to comment
Share on other sites

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

Link to comment
Share on other sites

"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

Link to comment
Share on other sites

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><FORM ACTION="FMPro" METHOD="post">

<P><INPUT TYPE="hidden" NAME="-db" VALUE="Job_Tracker">

<P>

<INPUT TYPE="hidden" NAME="-lay" VALUE="layout24">

<P>

<INPUT TYPE="hidden" NAME="-format" VALUE="thisweekView.html">

<P>Field Dept<BR>

<P><SELECT NAME="-op">

<OPTION SELECTED>equals

<OPTION>not equals

<OPTION>contains

<OPTION>begins with

<OPTION>ends with

</SELECT>

<P>

<INPUT TYPE="text" NAME="Dept" VALUE="" SIZE=30>

<P>Dept:

<SELECT NAME="Dept">

<OPTION VALUE="Choose Dept" SELECTED>

[FMP-ValueList: Dept]

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

[/FMP-ValueList:]

</SELECT>

<P><INPUT TYPE="submit" NAME="-find" VALUE="Start Search">

<P><INPUT TYPE="reset" VALUE="Clear Form">

</FORM>

</BODY>

</HTML>

---------

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

This topic is 8600 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.