CDML nightmares!!!

April 30, 200322 yr

Can anyone help me?

I can't seem to get my code to work - it searches & retrieves data but it won't display in the designated fields....

Would anyone be able to look at my code & tell me what's going on??

April 30, 200322 yr

hm...it looks like an error on line xyz because of abc that you entered with 123

May 1, 200322 yr

Two problems can occur:

1. The fields are not on the named Layout

or

2. HTML Comments are used around cdml

Copy and paste your page and we can check line xyz

All the best.

Garry

May 3, 200322 yr

Author

Ok... here goes! Thanx guys! I really appreciate your help!

The page was created in Dreamweaver but the form was written by hand - am not about to insert something I don't know what it's code does so have to do it the hard way....

Not only does it not bring the info up, but the code is viewable when I first view the page... How do I get around this?

Cheers!

__________________________________________________________________

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>Indoor Soccer</title>

</head>

<body>

<tr>

<tr>

</tr>

<tr>

</div></td>

<p align="left"><font color="006633" size="2" face="Arial, Helvetica, sans-serif">match

date: <form action="FMPro" method="get"

</form>

</font></p>

</td>

</tr>

<tr>

<td width="185" height="24" align="center" valign="top"><font face="arial, helvetica, sans-serif" size="1" color="#333333">[FMP-Field:team1]</font> </td>

<td width="195" align="center" valign="top"><font face="arial, helvetica, sans-serif" size="1" color="#333333">[FMP-Field:team2]</font></td>

<td colspan="2" rowspan="6" align="center" valign="bottom"><div align="center"><font color="006633" size="5" face="Arial, Helvetica, sans-serif"></font></div> <font color="006633" size="5" face="Arial, Helvetica, sans-serif"><strong>[FMP-LINKPREVIOUS]<[/FMP-LINKPREVIOUS]     [FMP-LINKNEXT]>[/FMP-LINKNEXT]</strong></font></td>

</tr>

<tr>

<td height="24" align="center" valign="top"><font face="arial, helvetica, sans-serif" size="1" color="#333333">[FMP-Field:team3]</font> </td>

<td width="195" align="center" valign="top"><font face="arial, helvetica, sans-serif" size="1" color="#333333">[FMP-Field:team4]</font></td>

</tr>

<tr>

<td height="24" align="center" valign="top"><font face="arial, helvetica, sans-serif" size="1" color="#333333">[FMP-Field:team5]</font></td>

<td width="195" align="center" valign="top"><font face="arial, helvetica, sans-serif" size="1" color="#333333">[FMP-Field:team6]</font></td>

</tr>

<tr>

<td height="21" align="center" valign="top"><font face="arial, helvetica, sans-serif" size="1" color="#333333">[FMP-Field:team7]</font> </td>

<td width="195" align="center" valign="top"><font face="arial, helvetica, sans-serif" size="1" color="#333333">[FMP-Field:team8]</font></td>

</tr>

<tr>

<td height="20" align="center" valign="top"><font face="arial, helvetica, sans-serif" size="1" color="#333333">[FMP-Field:team9]</font></td>

<td width="195" align="center" valign="top"><font face="arial, helvetica, sans-serif" size="1" color="#333333">[FMP-Field:team10]</font></td>

</tr>

<tr>

<td height="215" align="center" valign="top"><font face="arial, helvetica, sans-serif" size="1" color="#333333">[FMP-Field:team11]</font></td>

<td width="195" align="center" valign="top"><font face="arial, helvetica, sans-serif" size="1" color="#333333">[FMP-Field:team12]</font></td>

</tr>

<tr>

<td height="63" colspan="3" align="center" valign="top"><div align="right"><font color="006633" size="1" face="Arial, Helvetica, sans-serif">For

more information about a sport, draws and ladders click

below:</font></div></td>

</tr>

<tr>

</tr>

</table></td>

</tr>

</table>

</body>

</html>

May 3, 200322 yr

Are you saying that this sort of code is visable on the page:

[FMP-LINKPREVIOUS]<[/FMP-LINKPREVIOUS]  [FMP-LINKNEXT]>[/FMP-LINKNEXT]



[FMP-Field:team3]

If so, it means that the page has not been called through WebConpanion.



The page will need to be called by either a Form or URL though WebCompanion. For example:

http://myaddress:myport/FMPro?-db=mydatabase.fp5&-Lay=mylayout&-format=thepage.html&-findall

Hope this helps.

Garry

May 4, 200322 yr

Author

Thanx so much Garry!

But where exactly do I specify that code? Because I'm looking at it through localhost at the moment, & I have the file in Filemaker's Web folder the URL addy is: http://localhost:81/draws2.2.html

Where do I insert the code to make it recognise that it should be sourcing a database?

Also, I have been trying to email you, but I get rejected everytime....

Cheers

May 5, 200322 yr

as much as I can see you are missing [FMP-Record] tag that defines the set of records.

So the general syntax would be:

[FMP-Record]

[FMP-Field: Field_name1]

[FMP-Field: Field_name2]

[/FMP-Record]

This tag would "repeat" (in ASP RepeatRegion) all the records found! It also repeats anything within the tag..such html tags <td> or <tr>....I assume would aim to repeat a row in a table so watch out for that!

Hope it helps

May 5, 200322 yr

Re: URL addy is: http://localhost:81/draws2.2.html

Where do I insert the code

It would look something like this:

http://localhost:81/FMPro?-db=draws.fm5&-lay=draws&-format=draws2.2.html&-findall

All the best.

Garry

p.s. Remove the "_removefirst_" from the email address.

May 6, 200322 yr

OK, I'm sure it can't be this easy. But I notice a missing closing bracket in the form action tag (after "get"):

match date: <form action="FMPro" method="get"

And now I'm curious about the "get". I'm brand new to CDML, and every template or reference I've seen uses "post" for method. A question for the rest of you: What should I know that I don't? Thank you.

Ernie

May 6, 200322 yr

you also might want to "post" your info to the results page

for more info on GET vs. POST talk to the "monkey"

http://hotwired.lycos.com/webmonkey/99/30/index4a_page3.html?tw=authoring

also for general HTML question I would suggest you use "The Reference Books for any Programmer"...... some also call it a search engine http://www.google.com

but it is a lot more....

May 7, 200322 yr

Author

It might be because I'm frazzled or I really have no idea what I'm doing at all.... But do I name my file that code? Or where abouts in the html do I specify it?

& thankyou ErnieG & Leb I Sol - I assumed that 'get' would actually get the info & 'post' was to post something up like this....

I most certainly think I've bitten off more than I can chew here! !!!

Can anyone post some code for a page that is similar & works so that I can see what it is supposed to look like? The only code I've seen has had links that have all the FM specs in them - not the entire page....

I'm stuck!

May 7, 200322 yr

You can try this for a Format file (call it drawstest.html):

<html>



<head></head>



<body>The List<br>



[FMP-Record]



[FMP-Field:team1]<br>



[/FMP-Record]



</body>



</html>

You will need to access this Format file with this URL:

http://localhost:81/FMPro?-db=draws.fm5&-lay=draws&-format=drawstest.html&-findall

Good Luck.

Garry

May 8, 200322 yr

gryphonox

Get the CDML reference DB and there you will have some templates that are realatively easy to digest and understand....they truly start from 1 field search. They are worth the time if you would like to really learn...if you want the quick & dirty then u'r on the mercy of forum_people

...don't worry it will settle in after a while...just look at my 1st posts

now go get lucky......

May 8, 200322 yr

You can also look in the Sample Files forum. There you will find a few threads which offer free downloads of working solutions to specific problems. However, even if the problem is not something you are facing, you will find the code such as for a form and a link. Treat the downloads as you would anything in development. Using localhost, you may or may not need to designate the port (e.g. Garry's: "http://localhost:81/FMPro?...").

Good luck. But most of all, have fun. Remember, if it were that easy, your boss would do it.

May 9, 200322 yr

Author

Ok peoples! I think I'm finally understanding the whole concept now.... I have proposed a new idea so instead of having a form for people to look up dates I have a list of links... Now Explorer can't find my format file!

The link code is <a href="http://localhost:81/FMPro?-db=draws.fm5&-lay=draws&-format=draws2.html&-findall"> (still viewing in localhost at the moment)...

Now by my understanding it is saying that Explorer has to go to Filemaker, find the info contained in database 'draws.fm5', use layout 'draws' which has the specific info set out on it & find all results to do with that page.... What is the rest of the code?

Someone pointed out that I need something like "&-Error=errorpage&-op&mark=ok" or something.... What are the specifics for a string that's looking up say the 11/03/2003?

Also, the draws2.html page is contained within a pages folder, in an assests folder in the Filemaker Web folder.... do I need to bring it to the top level? Or will it find it buried in there?

This is good! I'm finally getting the hang of stuff! Thankyou all!

May 9, 200322 yr

Re: he draws2.html page is contained within a pages folder, in an assests folder in the Filemaker Web folder.... do I need to bring it to the top level?

You can have it there however, you will have to tell Explorer/Fm where it is; e.g.:

Good Luck.

Garry

May 9, 200322 yr

Author

Ok we're there & it does the same thing again - thinks about it but doesn't put anything in the place holders....

This is the link I've got on my splash page to find the data that matches the date 11/3/2003:

And this is the code for draws2.html:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>Indoor Soccer</title>

</head>

<body>

<tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td width="105" align="center" valign="middle"><font color="333333" size="1" face="Arial, Helvetica, sans-serif">[FMP-Field:team1]</font></td>

<td width="111" align="center" valign="middle"><font color="333333" size="1" face="Arial, Helvetica, sans-serif">[FMP-Field:team2]</font></td>

</tr>

<tr>

<td align="center" valign="middle"><font color="333333" size="1" face="Arial, Helvetica, sans-serif">[FMP-Field:team3]</font></td>

<td width="111" align="center" valign="middle"><font color="333333" size="1" face="Arial, Helvetica, sans-serif">[FMP-Field:team4]</font></td>

</tr>

<tr>

<td align="center" valign="middle"><font color="333333" size="1" face="Arial, Helvetica, sans-serif">[FMP-Field:team5]</font></td>

<td width="111" align="center" valign="middle"><font color="333333" size="1" face="Arial, Helvetica, sans-serif">[FMP-Field:team6]</font></td>

</tr>

<tr>

<td align="center" valign="middle"><font color="333333" size="1" face="Arial, Helvetica, sans-serif">[FMP-Field:team7]</font></td>

<td width="111" align="center" valign="middle"><font color="333333" size="1" face="Arial, Helvetica, sans-serif">[FMP-Field:team8]</font></td>

</tr>

<tr>

<td align="center" valign="middle"><font color="333333" size="1" face="Arial, Helvetica, sans-serif">[FMP-Field:team9]</font></td>

<td width="111" align="center" valign="middle"><font color="333333" size="1" face="Arial, Helvetica, sans-serif">[FMP-Field:team10]</font></td>

</tr>

<tr>

<td align="center" valign="middle"><font color="333333" size="1" face="Arial, Helvetica, sans-serif">[FMP-Field:team11]</font></td>

<td width="111" align="center" valign="middle"><font color="333333" size="1" face="Arial, Helvetica, sans-serif">[FMP-Field:team12]</font></td>

</tr>

<tr>

<td height="23" colspan="7" align="right" valign="bottom"><font color="006633" size="1" face="Arial, Helvetica, sans-serif"> For

more information about a sport, draws and ladders click below:</font></td>

</tr>

<tr>

</tr>

</table></td>

</tr>

</table>

</body>

</html>

______________________________

I tried it with the page on the top level of the Web folder & it likes it, but the results aren't posting up....

Also, my code to have links without lines under them isn't working - I'm using the same code (colours altered) from some previous pages I've done & it works there but not here...

Can anyone spot where I'm going wrong?

May 9, 200322 yr

Change this:

eq&date=11/3/2003&-findall

to

eq&date=11/3/2003&-find

Are the fields "team1" through to "team12" on the Layout "draws"?

Maybe create a very simple page for testing. Something like this:

<html>

<head><head>

<body>Data<br>

[FMP-Field:team1]

</body>

</html>

And use a URL like this:

href="http://localhost:81/FMPro?-db=draws.fm5&-lay=draws&-format=drawstest.html&-findany

From there you can test the functionality of the process. I do this when I start an application. You can then swap the Format files once you are happy that the process is working.

Good Luck.

Garry

May 12, 200322 yr

Author

Still not working... even with the test page. Would it be because I'm viewing in localhost? I also hadn't thought about it, but my password (set on my database as an exercise) comes up when it goes to process the command... even though I've got it set to view and edit all regions in FM, would that effect anything coming up?

I'm highly confused because I have tried all suggestions but to no avail... I'm starting to wonder if it's my computer!!!

May 12, 200322 yr

Using localhost is fine. I would be suspicious of "Access Privileges". Try a test database with no restrictions at all.

You could even try this test:

http://localhost:81/FMPro?-dbnames

This will give you a listing of the open databases if WebCompanion is working.

What type of errors do you receive?

Good Luck.

Garry

May 13, 200322 yr

Garry, I've noticed on a couple of occasions that your reference uses ...localhost:81/... I suppose there is a reason for this (I use http://localhost/default.htm as access for development purposes). Can you please tell me why you direct to port 81? Thank you.

May 13, 200322 yr

Unable:

if u use the same machine for R&D you will run into problemms when looking into other sites that run on the port 80 (especially IIS) and also

.... you do not want to put a "neon sign" above you bed that spells out "My Jewls, Money and other valuable crap are Here -->"

the same concept...port 80 commonly used port 81 is not

ops...or maybe I should let Garry responmd to this one

May 13, 200322 yr

Leb i Sol, if I "use the same machine for R&D ..." as I use for : what :

If I work off-line in development, what is the problem if later I go on-line when not in development? Machines serving solutions are dedicated (at least they should be).

So I fail to see the problems to which you refer. Please enlighten me. I'm a teetering fool, really, and miss a lot.

May 13, 200322 yr

It is the port gryphonox is using.

All the best.

Garry

p.s. I use 1154 (it is a number I can remember for various reasons)

May 13, 200322 yr

Deep dude. Thnx.

(said the blind carpenter as he picked up his hammer and saw)

May 13, 200322 yr

some one had a bad day...

May 13, 200322 yr

Author

No errors received - info is just not displaying. It actually links to the designated page, it's just that nothing replaces the [FMP-Field] placeholders. Database is restriction free & web companion seems to be working ("0draws.fm5" came up on a blank page so I assume it's working...). What else might it be?

Oh & Unable - I'm using port 81 because the server that I'm first putting the database up on is actually a university server & so for admin purposes and ease of identification I had to specify a different port from the norm to keep me seperate from the students for them - it'll be moved elsewhere later.

May 13, 200322 yr

Author

Actually, now that I think of it... I did have one error originally - it was saying it couldn't find the database with an extension of fp5. I think it specified fm5 so I changes the extension on my file....

Would that do anything significant?

May 13, 200322 yr

Re: I think it specified fm5

Along as the whole name (including the suffix) is the same as what you specify with "-db".

Re: info is just not displaying

Are those fields/info on the Layout specified with "-lay". Not having them on that Layout will cause that type of problem.

All the best.

Garry

May 26, 200322 yr

Author

A big thanx to everyone for all your help!

In the end it just wasn't working & was becoming a bit of a hassle so the powers that be decided that it wasn't worth the time & effort at the present moment... maybe sometime in the future...

Thanks to all!

May 26, 200322 yr

"Not only does it not bring the info up, but the code is viewable when I first view the page... How do I get around this?"

You then posted your code for the page. Below the </form> are references to {FMP-Field: Team1] etc. What I don't understand about all this is what action was taken on the preceeding page which would cause these fields to be displayed?