Will not allow to edit record

[JoeF]

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

[dspires]

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

[JoeF]

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

[yafreax]

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

[JoeF]

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