Accessing a database via the web--questions 
Author Message
 Accessing a database via the web--questions

Trying to develop a web-accessable database for a university department
I'm workstudying for.  They have me using FMPro because the weird
academia obcession over macs requires any DB's to be cross-platform.
Rant aside, I have to create a database dealing with many aspects and
tasks of the department, and put some of those aspects on the web.
I've become reasonably familiar with FMPro 5 so far, but I'm having
probelms getting it on the web.  I thought to make it simpler I'd use
Claris Homepage (30 day trial) to make it easier, but it hasn't turned
out that way.  First off, it realy sucks when it comes to editing
HTML.  Its about the worst I've seen when it comes to wysiwyg editing.
It did make the work on the database slightly easier, but I do have one
major problem which everything is {*filter*} over.  One part of the
database I'm using now allows people on the web to place their name on
one or more of the mailing lists which the department has.  People on X
mailing list recieve informaiton on X, on Y recieve information on Y,
yadda yadda.  I had set up the FMPro DB with fields for name and
address, and one field per mailing list, limiting entry to a value list
with only one value--a sort of half-assed boolean field.  So the value
list "boolean" has one entry, "Include", and each field can either have
nothing stored in it or "Include" stored in it.  That way, when you
want to print out a specific label list, you only have to search for
records with "Include" in the mailing list's specific field.  Anyhow, I
used Claris Homepage to create all the CDML tags and all the pages, and
eveything worked fine... Except for the value list items.  They are set
up as check boxes, and appear to be done correctly in Claris.  Claris'
wizard set them up, they look correct, yadda yadda.  But when I view
the page through IE 5.0, everything is as it should be on the form, but
for the mailing lists I get:

Philosophy Department Mailing List:
 [FMP-VALUELIST: Philosophy, LIST=Boolean] * [FMP-VALUELISTITEM:
Always, HTML] [/FMP-VALUELIST]

The asterisk represents where the check box is located, and this is
only one example--every other list has the same junk in it.  If I enter
a new label and leave all the check boxes empty, the label record is
entered successfully into the database.  If I check any of the boxes, I
get an error.  I don't know what the hell is wrong with this.  Its like
Claris screwed up in creating the check boxes.  Looking at the code, it
says:

 <TD>
 <P>[FMP-VALUELIST: Philosophy, LIST=Boolean]
 <INPUT TYPE=checkbox NAME="field name here" VALUE="[FMP
ValueListItem]">[FMP-VALUELISTITEM: Always, HTML]
 [/FMP-VALUELIST]</P>
</TD>

Now, if I set the VALUE to be "Include" and ditch all the {*filter*}at the
beginning and end that's bracketed [FMP-VALUELIST... it looks normal,
and works correctly.  But shouldn't it have worked before?  What's the
problem with value lists?  I don't wanna get caught short again later
on!!!  thanks for all the help you send!

Sent via Deja.com http://www.***.com/
Before you buy.



Tue, 10 Sep 2002 03:00:00 GMT
 Accessing a database via the web--questions

Quote:

>  <TD>
>  <P>[FMP-VALUELIST: Philosophy, LIST=Boolean]
>  <INPUT TYPE=checkbox NAME="field name here" VALUE="[FMP
> ValueListItem]">[FMP-VALUELISTITEM: Always, HTML]
>  [/FMP-VALUELIST]</P>
> </TD>

> Now, if I set the VALUE to be "Include" and ditch all the {*filter*}at the
> beginning and end that's bracketed [FMP-VALUELIST... it looks normal,
> and works correctly.  But shouldn't it have worked before?  What's the
> problem with value lists?  I don't wanna get caught short again later
> on!!!  thanks for all the help you send!

I think the problem was with the tag:

[FMP-VALUELISTITEM: Always, HTML]

Which shoulda' been just:

[FMP-VALUELISTITEM]

Therefor the whole code should have been:

<TD>
<P>[FMP-VALUELIST: Philosophy, LIST=Boolean]
<INPUT TYPE=checkbox NAME="field name here" VALUE="[FMP
ValueListItem]">[FMP-VALUELISTITEM]
[/FMP-VALUELIST]</P>
</TD>

It seems to me that FileMaker should just produce as many "CDML plug-in"
tools for the real wysiwyg html programs and forget about Claris home
page.

Nonetheless, don't forget to refer to the cdml reference befor you give
up on those "dynamic" value lists, because it seems check boxes, radio
buttons, lists menus and pop-ups all have there little coding
differences when you're trying to get a Value List out of a database.
But, I have managed to get any of them to work, so it is possible.

CiaO
ZaC



Tue, 10 Sep 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How do I access Oracle9i database via web?

2. Accessing FM database via modem or web

3. Database Access & Maintenance via Web

4. Access Database - update via web?

5. Cannot Access MS Access DB via Web

6. Possibly a very simple question - Access databases via the net

7. web.sql database accesses blocking web connections

8. Accessing SQL 7 (On the web) via Proxy 2.0 and ODBC

9. BLOB access via the web!

10. Accessing SQL Server via the web (http connection)

11. Restricting access to a web page, via user logon credentials

12. timeouts accessing sqlserver via web


 
Powered by phpBB® Forum Software