gryphonox Posted April 30, 2003 Posted April 30, 2003 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??
Leb i Sol Posted April 30, 2003 Posted April 30, 2003 hm...it looks like an error on line xyz because of abc that you entered with 123
Garry Claridge Posted May 1, 2003 Posted May 1, 2003 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
gryphonox Posted May 3, 2003 Author Posted May 3, 2003 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"> </td> <td colspan="3"> </td> </tr> <tr> <td width="25" height="288" rowspan="8" align="center" valign="middle"><div align="left"> <p align="left"> </p> </div></td> <td height="95" colspan="2" align="center" valign="top"><p align="right"> </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"> </td> <td height="95" colspan="2"> </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> <td width="228"><div align="right"></div></td> <td width="49"> </td> </tr> <tr> <td> </td> <td colspan="2" align="center" valign="middle"><img src="../images/buttonbar.gif" width="306" height="32"></td> <td colspan="3"> </td> </tr> </table></td> </tr> </table> </body> </html>
Garry Claridge Posted May 3, 2003 Posted May 3, 2003 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
gryphonox Posted May 4, 2003 Author Posted May 4, 2003 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
Leb i Sol Posted May 5, 2003 Posted May 5, 2003 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
Garry Claridge Posted May 5, 2003 Posted May 5, 2003 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.
ErnieG Posted May 6, 2003 Posted May 6, 2003 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
Leb i Sol Posted May 6, 2003 Posted May 6, 2003 you also might 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" 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....
gryphonox Posted May 7, 2003 Author Posted May 7, 2003 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!
Garry Claridge Posted May 7, 2003 Posted May 7, 2003 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
Leb i Sol Posted May 8, 2003 Posted May 8, 2003 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......
Unable Posted May 8, 2003 Posted May 8, 2003 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.
gryphonox Posted May 9, 2003 Author Posted May 9, 2003 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!
Garry Claridge Posted May 9, 2003 Posted May 9, 2003 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
gryphonox Posted May 9, 2003 Author Posted May 9, 2003 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"> </td> </tr> <tr> <td width="29" height="310" rowspan="8"> </td> <td height="49" colspan="2"> </td> <td width="105"> </td> <td width="22"> </td> <td> </td> <td> </td> <td width="46" rowspan="7"> </td> <td width="272"> </td> </tr> <tr> <td width="47" height="117" rowspan="6"> </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"> </td> <td width="272"> </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"> </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"> </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"> </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"> </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"> </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"><</a> <a href="home.html">home</a></strong></font></td> </tr> <tr> <td height="51"> </td> <td height="51" colspan="6" align="center" valign="middle"><img src="assets/images/buttonbar.gif" width="306" height="32"></td> <td height="51"> </td> <td height="51"> </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?
Garry Claridge Posted May 9, 2003 Posted May 9, 2003 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
gryphonox Posted May 12, 2003 Author Posted May 12, 2003 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!!!
Garry Claridge Posted May 12, 2003 Posted May 12, 2003 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
Unable Posted May 13, 2003 Posted May 13, 2003 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.
Leb i Sol Posted May 13, 2003 Posted May 13, 2003 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
Unable Posted May 13, 2003 Posted May 13, 2003 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.
Garry Claridge Posted May 13, 2003 Posted May 13, 2003 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)
Unable Posted May 13, 2003 Posted May 13, 2003 Deep dude. Thnx. (said the blind carpenter as he picked up his hammer and saw)
gryphonox Posted May 13, 2003 Author Posted May 13, 2003 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.
gryphonox Posted May 13, 2003 Author Posted May 13, 2003 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?
Garry Claridge Posted May 13, 2003 Posted May 13, 2003 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
gryphonox Posted May 26, 2003 Author Posted May 26, 2003 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!
Unable Posted May 26, 2003 Posted May 26, 2003 "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?
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now