Jump to content

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

Recommended Posts

Posted

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

Posted

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>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>

<body>

<table width="100%" height="100%" border="0" align="center">

<tr>

<td align="center" valign="middle"><table width="760" height="420" border="0" align="center" cellpadding="3" cellspacing="0" background="../images/background.jpg">

<tr>

<td height="83" colspan="3">&nbsp;</td>

<td colspan="3">&nbsp;</td>

</tr>

<tr>

<td width="25" height="288" rowspan="8" align="center" valign="middle"><div align="left">

<p align="left">&nbsp;</p>

</div></td>

<td height="95" colspan="2" align="center" valign="top"><p align="right">&nbsp;</p>

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

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

<input type="hidden" name="-db" value="draws.fm5">

<input type="hidden" name="-lay" value="draws">

<input type="hidden" name="-format" value="draws2.2.html">

<input type="hidden" name="-error" value="error.html">

<input type="hidden" name="-op" value="equals">

<input type="text" name="date" value="" size="20">

<input type="submit" name="-find" value="go">

<input type="hidden" name="-find">

</form>

</font></p>

<p align="left"></p>

</td>

<td width="42" rowspan="7">&nbsp;</td>

<td height="95" colspan="2">&nbsp;</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]&lt;[/FMP-LINKPREVIOUS] &nbsp; &nbsp; [FMP-LINKNEXT]&gt;[/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>

<td width="228"><div align="right"></div></td>

<td width="49">&nbsp;</td>

</tr>

<tr>

<td>&nbsp;</td>

<td colspan="2" align="center" valign="middle"><img src="../images/buttonbar.gif" width="306" height="32"></td>

<td colspan="3">&nbsp;</td>

</tr>

</table></td>

</tr>

</table>

</body>

</html>

Posted

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

Posted

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

Posted

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

Posted

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"

<input type="hidden" name="-db" value="draws.fm5">

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

Posted

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

<form action="FMPro" method="post">

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

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

Posted

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!

Posted

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

Posted

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

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

now go get lucky......

Posted

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.

Posted

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!

Posted

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

<a href="http://localhost:81/FMPro?-db=draws.fm5&-lay=draws&-format=assets/pages/draws2.html&-findall">

Good Luck.

Garry

Posted

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:

<a href="http://localhost:81/FMPro?-db=draws.fm5&-lay=draws&-format=draws2.html&-op=eq&date=11/3/2003&-findall">

And this is the code for draws2.html:

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

<html>

<head>

<title>Indoor Soccer</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<STYLE type="text/css"><!--A:hover {color: #006633;}//--></STYLE>

<STYLE type="text/css"><!--A.noline {text decoration: none};//--></STYLE>

<STYLE type="text/css"><!--A:link {text decoration: none} A:visited {text decoration: none} A:active {text decoration: none}--> </STYLE>

</head>

<body>

<table width="100%" height="100%" border="0" align="center">

<tr>

<td align="center" valign="middle"><table width="760" height="420" border="0" align="center" cellpadding="3" background="assets/images/background.jpg">

<tr>

<td height="75" colspan="9">&nbsp;</td>

</tr>

<tr>

<td width="29" height="310" rowspan="8">&nbsp;</td>

<td height="49" colspan="2">&nbsp;</td>

<td width="105">&nbsp;</td>

<td width="22">&nbsp;</td>

<td>&nbsp;</td>

<td>&nbsp;</td>

<td width="46" rowspan="7">&nbsp;</td>

<td width="272">&nbsp;</td>

</tr>

<tr>

<td width="47" height="117" rowspan="6">&nbsp;</td>

<td width="39" align="right" valign="middle"><font size="1" face="Arial, Helvetica, sans-serif"><strong>6pm</strong></font></td>

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

<td width="22" align="center" valign="middle"><strong><font size="1" face="Arial, Helvetica, sans-serif">V</font></strong></td>

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

<td width="15" rowspan="6">&nbsp;</td>

<td width="272">&nbsp;</td>

</tr>

<tr>

<td width="39" align="right" valign="middle"><strong><font size="1" face="Arial, Helvetica, sans-serif">6:30pm</font></strong></td>

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

<td width="22" align="center" valign="middle"><strong><font size="1" face="Arial, Helvetica, sans-serif">V</font></strong></td>

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

<td width="272">&nbsp;</td>

</tr>

<tr>

<td width="39" align="right"><strong><font size="1" face="Arial, Helvetica, sans-serif">7pm</font></strong></td>

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

<td width="22" align="center" valign="middle"><strong><font size="1" face="Arial, Helvetica, sans-serif">V</font></strong></td>

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

<td width="272">&nbsp;</td>

</tr>

<tr>

<td width="39" align="right" valign="middle"><strong><font size="1" face="Arial, Helvetica, sans-serif">7:30pm</font></strong></td>

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

<td width="22" align="center" valign="middle"><strong><font size="1" face="Arial, Helvetica, sans-serif">V</font></strong></td>

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

<td width="272">&nbsp;</td>

</tr>

<tr>

<td width="39" align="right" valign="middle"><strong><font size="1" face="Arial, Helvetica, sans-serif">8pm</font></strong></td>

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

<td width="22" align="center" valign="middle"><strong><font size="1" face="Arial, Helvetica, sans-serif">V</font></strong></td>

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

<td width="272">&nbsp;</td>

</tr>

<tr>

<td width="39" align="right" valign="middle"><strong><font size="1" face="Arial, Helvetica, sans-serif">8:30pm</font></strong></td>

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

<td width="22" align="center" valign="middle"><strong><font size="1" face="Arial, Helvetica, sans-serif">V</font></strong></td>

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

<td width="272">&nbsp;</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>

<td width="272" align="center" valign="bottom"><font color="006633" size="2" face="Arial, Helvetica, sans-serif"><strong><a href="assets/pages/soccer.html">&lt;</a> &nbsp; &nbsp; <a href="home.html">home</a></strong></font></td>

</tr>

<tr>

<td height="51">&nbsp;</td>

<td height="51" colspan="6" align="center" valign="middle"><img src="assets/images/buttonbar.gif" width="306" height="32"></td>

<td height="51">&nbsp;</td>

<td height="51">&nbsp;</td>

</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?

Posted

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

Posted

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

Posted

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

Posted

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.

Posted

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.

Posted

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?

Posted

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

  • 2 weeks later...
Posted

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!

Posted

"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?

This topic is 7921 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.