Checkboxes

[Pesinos]

I am stumped. I had a web site that was an online registration for workshops being offered. It worked fine last semester so this semester I just changed the information and it now will not work. Whenever I use the CDML like this:[FMP-VALUELIST: PowerPoint, LIST=PowerPoint]

<INPUT TYPE=checkbox NAME=PowerPoint VALUE="[FMP-ValueListItem]"[FMP-ValueListChecked]>[FMP-VALUELISTITEM: Always, HTML]<BR>

[/FMP-VALUELIST]

(that was suggested in an earlier posting) the text appears on the web page. I want the web page to show a checkbox with the information from the value list and instead it shows the CDML with a checkbox. If I remove the CDML I am able to register but only my name and address gets added to the database none of the checkboxes are checked. I know that it is probably something simple but it needs to up and running by tomorrow and I do not have the time to solve it on my own. If anyone can help I would appreciate it. If I need to clarify anything please let me know.

Sherry

[Vaughan]

I'll bet you are viewing the html file directly (like typing-in it's url)... in which case you will see the CDML codes.

Custom format files need to be processed by Web Companion for the CDML to be worked out: use a URL that specifies the db name, layout, format file and an action tag like -view, -findany, -findall or -find.

[Pesinos]

I am not quite sure what you mean. The web site that I am talking about resides in the web folder of FileMaker Pro Unlimited. When I access other search databases from web ages it works fine.

Sherry

[yafreax]

Vaughan is saying that your link that gets you to the page probably looks like this:

<a href="/search.html">or the such. . .

it needs to look like this in order for checkboxes or popups to show correctly:

<a href="/FMPro?-db=database&-lay=layout&-format=search.html&-view">

If you don't use any checkboxes or pull-downs, then the pages will still work like the first link, but i would suggest ALWAYS using the second type link. Good luck

jeremy

[This message has been edited by yafreax (edited February 27, 2001).]

[Pesinos]

Thank you. Now the pages look right. However I now am getting this error message when I try to submit a new record:

New Record Error

There was an error adding a record to the facdev workshops spring01 database. Please check your submission and try again. - [# ERR: 102]

I do not know what to look for in the html. If anyone has any idea....

Thanks again, Sherry

[This message has been edited by Pesinos (edited March 07, 2001).]

[This message has been edited by Pesinos (edited March 07, 2001).]

[This message has been edited by Pesinos (edited March 07, 2001).]

[ivyorg]

Well, IMHO, Error 102 has always indicated that I misspelled a field name in my HTML/CDML code. Go back and verify every field name and that it's spelled exactly the same way as in FMP. Also, it's a good idea not to use spaces and symbols like "&" when defining fields. Just gives another opportunity to make a mistake. I tried out your page, and it's simple enough code, that you should be able to find your answer by proofing your field names.

Bevin

[Pesinos]

I went back and renamed everything and verified all of the spelling. I am still getting the # 102 error.

If you have any other suggests I am all ears. We are getting down to the wire in terms of time.

Could it have something to do with the submit button?:

...Sherry

[This message has been edited by Pesinos (edited March 07, 2001).]

[Pesinos]

Thank you to all of you for your help. I was finally able to make it work. It turned out to be spaces left after a field name. What a mess. Thank goodness that this forum is available.

Sherry

[Anatoli]

Protect your databases!

Hackers are everywhere.

Anatoli

[Pesinos]

Thanks for the warning but a more effective approach would be to explain how to protect the database instead of proving that you are in fact one of those HACKERS. Point taken!!!!

[Keith M. Davie]

I think what was being suggested was that when posting questions such as yours on any Forum, you not post the actual address, but use a substitute, such as the address 127.0.0.1 or leave that out entirely and write ...//fmpro?-db.........

Hackers are everywhere, even on help forums.

Peace

Keith M. Davie

[yafreax]

aye aye aye. . . almost missed an IP address. You really should get in there and edit your post, or maybe a moderater would be so kind to do it for you. BUT YOU really need to put some passwords on those things, even if that means that the people that have to access it put in the password everytime. It's worth it. trust me.

Jeremy

[This message has been edited by yafreax (edited March 07, 2001).]

[Pesinos]

Thank you all. I have taken out the IP address but the next question is this...

The IP address shows up as part of the web site. How can I prevent that?

AND

Do any of you have a suggestion for protecting the database? My databases are search only and entry only. I do not want every user to have a password. I do not know who the users may be if they are registering for a workshop.

My two options seem to be:

FileMaker Pro Access Privileges

or

Web Security Database

Is one better than the other? Any other suggestions???

[Vaughan]

You should have an FMP password on the database as a matter of course. If you are web sharing the databse, there also needs to be a <no password> password defined that allows the web user to access the file: at minimum it's browse and export, plus if the web site allows create, edit and delete it'll have to allow those.

If you use Web Security databases, then the single FMP password is enough. Add an ebtry in thw WS database for the file and give the "All Users" entry the necessary access.

[Anatoli]

Any protection is better than none.

You do not have to share db, you can share-it just over the WebCompanion.

Also some kind of firewall filtering foreign traffic (IP and ports) will protect your databases.

You just left them wide open... I am not hacker, I am just leaving some text on one layout to show that anybody can do damage from......to......