xtrim Posted June 18, 2003 Posted June 18, 2003 Hi I got : DB_A, DB_B, DB_C . The page is on DB_A The Inline Is from DB_B : [fmp-inlineaction:-db=DB_B.fp5,-lay=main,ID={fmp-field:id},-max=all,-find] [fmp-record] <input type=text name="realation::comments" value="[FMP-Field: realation::comments ]" size=20 maxlength=51> [/fmp-record] [/fmp-inlinneaction] Im trying to save the chenge I made using "-edit" but it wont let me... Why it will let me edit a portal row, but not an inline? and is it possible to edit rows with inline?
Leb i Sol Posted June 18, 2003 Posted June 18, 2003 Inline is used just find records...another page must accept the edit action. Use the form to submit to that action/format page ------------snip-------------------------- [fmp-record] <FORM ACTION="FMPro" METHOD="post" name="EDIT"> <INPUT TYPE="hidden" NAME="-RecID" VALUE="[FMP-currentrecid]"> <INPUT TYPE="hidden" NAME="-db" VALUE="Your_DB.fp5"> <INPUT TYPE="hidden" NAME="-lay" VALUE="your_layout"> <INPUT TYPE="hidden" name="-format" value="Record_Edited.html"> <input type=text name="realation::comments" value="[FMP-Field: realation::comments ]" size=20 maxlength=51> </form> [/fmp-record] ----------------snap-------------- I hope this is what ur looking for.... all the best!
Unable Posted June 18, 2003 Posted June 18, 2003 "Inline is used just find records..." From CDMLRD: "<!-- Log page hits in another database --> [FMP-InlineAction: -db=log.fp5, -lay=web, time="{CurrentTime}", date="{CurrentDate}", page="This page!", browser="{ClientType}", ip="{ClientIP}", -new] [/FMP-InlineRequest]" To edit you will need a META Refresh page. Depending on the edit, you may need two META Refresh pages or one META Refresh with JavaScript. Good luck.
Leb i Sol Posted June 18, 2003 Posted June 18, 2003 "Inline is used just find records"<---in His case... assuming that he wants to be able to edit/update each record individually. Unable ....-new] vs. ...-edit] and "To edit you will need a META Refresh page" -- he said that -edit didn't work for him so refresh wont help him...for log it works fine since all the variables are provided (already exsiting by the fact the user is connected)by a 'server' not pulled from the DB based on filtering/sorting but above all -edit] should have worked to begin with then again... I'm no expert, I'm Willing to Try to help
xtrim Posted June 19, 2003 Author Posted June 19, 2003 Hi I got a bit confused... I have a page (form) with editable inline outputs from a different DataBase. You are telling me that i need another form tag inside the inline tag.... Can you do that? (or I didn't understand... )
Leb i Sol Posted June 19, 2003 Posted June 19, 2003 Xtrim! ---"You are telling me that i need another form tag inside the inline tag" From what you posted: "[fmp-record] <input type=text name="realation::comments" value="[FMP-Field: realation::comments ]" size=20 maxlength=51> [/fmp-record]" looks like you a generating/finding a "list" of records whose output(comments) will be populating values into a form field....well, now, your output will look like this: ----results.html------------ 1.[some comments here] 2.[another comment of differenet record] 3. [then some more] .... .. ---------------------------- so I am guessing that these results would be then changes and submitted with a change (updated/edited) right?! Therefor you need a <form> "arround" the <input type=text name="realation::comments...> </form> to subit the changed. So , yes u do need another form tag that will submit those changed to eg. RecordEdited.html. All the best!
Leb i Sol Posted June 19, 2003 Posted June 19, 2003 sums up to: ------------------- [fmp-inlineaction:-db=DB_B.fp5,-lay=main,ID={fmp-field:id},-max=all,-find] [fmp-record] <FORM ACTION="FMPro" METHOD="post" name="EDIT"> <INPUT TYPE="hidden" NAME="-RecID" VALUE="[FMP-currentrecid]"> <INPUT TYPE="hidden" NAME="-db" VALUE="Your_DB.fp5"> <INPUT TYPE="hidden" NAME="-lay" VALUE="your_layout"> <INPUT TYPE="hidden" name="-format" value="Record_Edited.html"> <input type=text name="realation::comments" value="[FMP-Field: realation::comments ]" size=20 maxlength=51> <input name="-edit" type="submit" value="Update"> <input name="Reset" type="reset" value="Reset"> </form> [/fmp-record] [/fmp-inlinneaction] --------------------------------
xtrim Posted June 19, 2003 Author Posted June 19, 2003 Ok... I tried it but DW4 reports an error when I try to insert another form tag in the page... But the outputs seems fine anyway... only the buttons in the Master form r not working.... Do I have to put a submit button in each record ? Can't I make one submit button for all the records (like portal)? Relevant Parts of my page : <FORM ACTION="FMPro" METHOD="POST"> <P><INPUT TYPE="hidden" NAME="-DB" VALUE="web users"> <INPUT TYPE="hidden" NAME="-Lay" VALUE="WebMain"> <INPUT TYPE="hidden" NAME="-Format" VALUE="unit_slist_reply.htm"> <INPUT TYPE="hidden" NAME="-Error" VALUE="unitlist_error.htm"> <INPUT TYPE="hidden" NAME="-recid" VALUE="[fmp-currentrecid]"> [fmp-inlineaction:-db=units history.fp5,-lay=web,owner1_owner2={fmp-field:username},-max=all,-find] [fmp-record] <FORM ACTION="FMPro" METHOD="post" name="EDIT"> <INPUT TYPE="hidden" NAME="-RecID" VALUE="[FMP-currentrecid]"> <INPUT TYPE="hidden" NAME="-db" VALUE="units history.fp5"> <INPUT TYPE="hidden" NAME="-lay" VALUE="web"> <INPUT TYPE="hidden" name="-format" value="unit_slist_reply.htm"> <input type=text name="comments" value="[FMP-Field:comments ]" size=20 maxlength=51> <input name="-edit" type="submit" value="Update"> <input name="Reset" type="reset" value="Reset"> </form> [/fmp-record][/fmp-inlinneaction] <INPUT TYPE="submit" NAME="-Edit" VALUE="Save Changes"> <INPUT TYPE=reset VALUE="Clear Changes"></center> </FORM>
Leb i Sol Posted June 19, 2003 Posted June 19, 2003 Xtrim: "Do I have to put a submit button in each record ? Can't I make one submit button for all the records (like portal)?" there was a post on this...Update/Edit all records at ones..but this I would not suggest since ur updating many records at oens ur more likely to generate errors in the file. so yes update 1 record at the time...otherwise u will need to look up some JavaScripting about the forms: I thought u wanted just the "units history.fp5" to be updated! where did this come from "<INPUT TYPE="hidden" NAME="-DB" VALUE="web users">" and why u have this entire new form at all? all the best!
xtrim Posted June 19, 2003 Author Posted June 19, 2003 Hi, tnx 4 the quick reply... I just showed you main parts from my page. In the main form I have some fields that are from "Web Users" DB, and in the inline from "Units History". Anyway the main reason I need one button is because the list can be hundreds of records, Plus it is a waste of space.... But from the other hand, portals are much slower then inlines... I have to think about it....
Leb i Sol Posted June 19, 2003 Posted June 19, 2003 "Anyway the main reason I need one button is because the list can be hundreds of records, Plus it is a waste of space.... " waste of space? what space..in HTML..thats no waste...waste is when u wait for 10 minutes for ALL the records to update and then u get the "middle finger" from the FileMaker saying that has been a problem updating records and now u have 1/2 of it updated and other ...Good Knows what happend........that, I would call "waste" If u are concerened with 'the space' and design you can always use a small icon-images for the Submit-Reset buttons. The only waste I could see it the time invested into updating all these records 1 at the time...then again u create them 1at the time soooo... anyway here is something that might be worth reading .: OLD POST :. all the best!
Leb i Sol Posted June 19, 2003 Posted June 19, 2003 there is new post that is barried in long list so here is the extract: --------------------------------------------------- --Here is a way to submit multiple records, check out our article in Plexus Magazine @ http://www.fmwebschool.com/april_may.zip enjoy! -------------------- Stephen Knight FM WebSchool www.fmwebschool.com ------------------------------------------
xtrim Posted June 22, 2003 Author Posted June 22, 2003 Point taken. I guess I'll make it per record then... Tnx agian...
Recommended Posts
This topic is 7895 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