Jump to content

Will not allow to edit record


JoeF
 Share

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

Recommended Posts

  • 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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7450 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
 Share

×
×
  • Create New...

Important Information

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