Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Will not allow to edit record

Featured Replies

  • Newbies

I have no idea what is wrong with one of my databases, i use it online to gather peoples information, then you can view the information, edit it, or delete it, real basic, i have three databases like this, two work, but one isnt, when i go to browse all of the records in this one database the first field shows up but then there is a ] after the field, i cant edit the record, but i CAN delete it, there is nothing wrong with the code that i can find, does anyone have any clues as to where i should look?? thanks so much in advance!

Joe

I would look at the code and the web security database. If you'll post your CDML here, you'll 'help the helpers'.

  • Author
  • Newbies

It cant be the security, and it lets me delete the records, just cant update, and i would post the code, but im not sure what part is giving me the problem, its just weird, whenever i retrieve a record i get a ] after the first field, even though there is nothing wrong with the code, and if you look at the actual record in the database it dosent have the ]

Thanks again for any help...

Some one once great said:

What you "know" just ain't so.

Well, as to what part of the code is giving you the problem, well, start by posting all parts necessary to make the form work (the hidden format, db, etc, tags.) and also post the stuff around the part where you are getting the ]. If you have ANY javascripts those might be useful for someone (not me) to check them out as well.

If we don't see the code, then we might as well just say "well, just fix the problems" and that's about as useful as we could be, unless by some chance there is absolutely nothing wrong with the code and / or security and it has happened to someone else as well. And that will happen around here every-now-and then

I know that sometimes i need someone else to look at what i'm doing because i need the fresh eyes. Maybe you're just missing it, maybe not, maybe it is a freak thing.

Jeremy

  • Author
  • Newbies

well, here is the code...where else in the security could i look, everything looks ok to me, and ive looked a million times...

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

<input type="hidden" name="-db" value="bookrequest"><input type="hidden" name="-lay" value="webbook"><input type="hidden" name="-format" value="editresp.html"><input type="hidden" name="-error" value="error.html"><input type="hidden" name="-recid" value="[FMP-currentrecid]">

<center>

<p><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" size="4" color="blue"><b>

<table border="0" cellpadding="0" cellspacing="2" width="600">

<tr>

<td>

<center>

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" size="4" color="blue"><b><img height="215" width="304" src="home.gif"></b></font>

<p><b><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" size="4" color="black">Edit/Delete Information</font></b></p>

<p><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">

<table border="0" cellpadding="0" cellspacing="6">

<tr>

<td>

<div align="right">

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="#cc0000">*</font><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">First Name:</font></div>

</td>

<td><input type="text" name="FirstName" size="24" value="[FMP-Field:FirstName]"></td>

</tr>

<tr>

<td>

<div align="right">

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="#cc0000">*</font><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">Last Name:</font></div>

</td>

<td><input type="text" name="LastName" size="24" value="[FMP-Field:LastName]"></td>

</tr>

<tr>

<td>

<div align="right">

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">Address or Campus Department:</font></div>

</td>

<td><input type="text" name="Address" size="24" value="[FMP-Field:Address]"></td>

</tr>

<tr>

<td>

<div align="right">

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="#cc0000">*</font><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">Phone:</font></div>

</td>

<td><input type="text" name="Phone" size="24" value="[FMP-Field:Phone]"></td>

</tr>

<tr>

<td>

<div align="right">

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">Email:</font></div>

</td>

<td><input type="text" name="Email" size="24" value="[FMP-Field:Email]"></td>

</tr>

<tr>

<td colspan="2"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="#cc0000">*</font><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">Did you check Clues for this item?</font><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="white"> </font><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><input type="text" value="[FMP-Field:Clues]" name="PList" size="24"></font></td>

</tr>

<tr>

<td>

<div align="right">

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">Author</font><font color="black">:</font></div>

</td>

<td><input type="text" name="Author" size="24" value="[FMP-Field:Author]"></td>

</tr>

<tr>

<td>

<div align="right">

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="#cc0000">*</font><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">Title:</font></div>

</td>

<td><input type="text" name="TitleOfArticle" size="24" value="[FMP-Field:Title]"></td>

</tr>

<tr>

<td>

<div align="right">

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="#cc0000">*</font><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">ISBN:</font></div>

</td>

<td><input type="text" name="TitleOfPeriodical" size="24" value="[FMP-Field:ISBN]"></td>

</tr>

<tr>

<td>

<div align="right">

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">Publisher:</font></div>

</td>

<td><input type="text" name="DateOfPeriodical" size="24" value="[FMP-Field:Publisher]"></td>

</tr>

<tr>

<td>

<div align="right">

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">Year Published:</font></div>

</td>

<td><input type="text" name="Volume" size="24" value="[FMP-Field:YearPublished]"></td>

</tr>

<tr>

<td>

<div align="right">

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">Edition:</font></div>

</td>

<td><input type="text" name="Issue" size="24" value="[FMP-Field:Edition]"></td>

</tr>

<tr>

<td>

<div align="right">

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">Place of Publication:</font></div>

</td>

<td><input type="text" name="Inclusive" size="24" value="[FMP-Field:PlaceOfPub]"></td>

</tr>

<tr>

<td>

<div align="right">

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="#cc0000">*</font><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="black">No longer useful after:</font></div>

</td>

<td><input type="text" name="NoLonger" size="24" value="[FMP-Field:NoLonger]"></td>

</tr>

<tr>

<td>

<div align="right">

<font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="red"><b>Status:</b></font></div>

</td>

<td><input type="text" value="[FMP-Field:Status]" name="Status" size="24"></td>

</tr>

<tr>

<td colspan="2">

<center>

<input type="submit" name="-edit" value="Update"><input type="submit" name="-delete" value="Delete this Record"></center>

blah blah

</form>

well thats all of it, sorry its alot, but i had to change around the font colors a bunch of times because the supervisor has no idea what he wants, gotta love em...

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.