Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan : Installation :

Modifying records

Aug 13, 1999, 11:00 AM
rayramon
Novice (39 posts)
Aug 13, 1999, 11:00 AM
Post #1 of 8
Views: 2390
Shortcut
Quote Reply
Modifying records
For some reason I can't modify records. I put in a query, say "king" then I get results with the radio buttons. I click on a button and select modify record then get this error:

Error: Unable to Modify Record

There were problems modifying the record: unable to find record/no record specified:
Please fix any errors and submit the record again.

However, I have specified a record by clicking on the radio button?

http://unuona.hypermart.net/cgi-bin/dbman/db.cgi?db=onadb

I put in pw and user name gossamer - you can view and modify these records if you want to test it out...









[This message has been edited by rayramon (edited August 13, 1999).]
Aug 13, 1999, 11:14 AM
Eliot
Deleted
Aug 13, 1999, 11:14 AM
Post #2 of 8
Views: 2261
Shortcut
Quote Reply
Re: Modifying records In reply to
One thing that I noticed is that you have a very unique ID system. May be that is the source of the problem.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us
Aug 13, 1999, 11:30 AM
JPDeni
Veteran / Moderator (8669 posts)
Aug 13, 1999, 11:30 AM
Post #3 of 8
Views: 2271
Shortcut
Quote Reply
Re: Modifying records In reply to
Did you import your data from another database that has quotes around each of the field values? I'm pretty sure that's your problem. Try opening your .db file in a text editor and deleting all of the " characters. (You can easily do it with a search-and-replace process.)

Your quotation marks are interfering with the form tags in the modify form.


------------------
JPD


PS. The fact that you imported your database instead of using DBMan to add the records is also the reason you had problem with your commas. If you add records directly through DBMan, you won't have the same problem.



[This message has been edited by JPDeni (edited August 13, 1999).]
Sep 30, 1999, 2:48 AM
ianan
New User (3 posts)
Sep 30, 1999, 2:48 AM
Post #4 of 8
Views: 2263
Shortcut
Quote Reply
Re: Modifying records In reply to
Hi there -

I have just spent the last couple of days really trying to learn this prog and on the whole, it is brilliant- much nicer interface than using Visual InterDev on my intranet.

One problem though - I have also been getting the same error message as described above. At one point I DID try importing data from elsewhere but now I am getting after having created a brand new default.db file and just entering 2 entries of my own in there. Now when I try and select one of the records, I get a screen which has "concatenated" the data together so it shows the information from both records in one...(?)

e.g.

Error: Unable to Modify Record

There were problems modifying the record: unable to find record/no record specified:
Please fix any errors and submit the record again.

ID:1~~5
Title:Complete Reference to HTML~~Active Server Pages 2
Author:Powell~~Fedorov
Date:1999~~1999
Publisher:McGraw Hill~~Wrox
File:00~~00
Stack:00~~00
Shelf:00~~00
Obtained:1999~~1998

Any ideas would be appreciated.

Thanks -

------------------
_________________________
I A N
H e r t f o r d , U K

[This message has been edited by ianan (edited September 30, 1999).]
Sep 30, 1999, 4:37 AM
Eliot
Deleted
Sep 30, 1999, 4:37 AM
Post #5 of 8
Views: 2267
Shortcut
Quote Reply
Re: Modifying records In reply to
Please save the following files:

html.pl
default.cfg

as text files, like the following:

html.txt
default.txt

and place them in a publicly accessible web directory.

Then let us know the URL where we can view these files.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us
Oct 1, 1999, 8:30 AM
JPDeni
Veteran / Moderator (8669 posts)
Oct 1, 1999, 8:30 AM
Post #6 of 8
Views: 2277
Shortcut
Quote Reply
Re: Modifying records In reply to
For some reason, you are getting two sets of fields in your form. Is there a way that I can see your database in action?


------------------
JPD





Oct 1, 1999, 8:37 AM
JPDeni
Veteran / Moderator (8669 posts)
Oct 1, 1999, 8:37 AM
Post #7 of 8
Views: 2259
Shortcut
Quote Reply
Re: Modifying records In reply to
I just looked at your html.pl file again and I see a problem with sub html_record. You shouldn't have the form tags in there. It should be:

Code:
sub html_record {
# --------------------------------------------------------
# How a record will be displayed. This is used primarily in
# returning search results and how it is formatted. The record to
# be displayed will be in the %rec hash.

my (%rec) = @_; # Load any defaults to put in the VALUE field.
($db_auto_generate and print &build_html_record(%rec) and return);

my $font_color = 'Font face="Verdana, Arial, Helvetica" Size=2 Color=#003399';
my $font = 'Font face="Verdana, Arial, Helvetica" Size=2';

print qq|
<TABLE WIDTH="450" CELLPADDING=0 CELLSPACING=0 BORDER=1 BGCOLOR="#FFFFCC">
<tr><td align="center"><img src=http://solis/images/intranetbuttons/librarycatalogue.gif>
<TR><TD ALIGN="Right" VALIGN="TOP" WIDTH="150"><$font>Title:</FONT></TD>
<TD VALIGN="TOP" WIDTH="475">&nbsp;$rec{'Title'}</TD></TR>
<TR><TD ALIGN="Right" VALIGN="TOP" WIDTH="150"><$font>Author:</FONT></TD>
<TD VALIGN="TOP" WIDTH="475">&nbsp;$rec{'Author'}</TD></TR>
<TR><TD ALIGN="Right" VALIGN="TOP" WIDTH="150"><$font>Date:</FONT></TD>
<TD VALIGN="TOP" WIDTH="475">&nbsp;$rec{'Date'}</TD></TR>
<TR><TD ALIGN="Right" VALIGN="TOP" WIDTH="150"><$font>Publisher:</FONT></TD>
<TD VALIGN="TOP" WIDTH="475">&nbsp;$rec{'Publisher'}</TD></TR>|;
if ($per_admin) {
print qq|
<TR><TD ALIGN="Right" VALIGN="TOP" WIDTH="150"><$font>File:</FONT></TD>
<TD VALIGN="TOP" WIDTH="475">&nbsp;$rec{'File'}</TD></TR>
<TR><TD ALIGN="Right" VALIGN="TOP" WIDTH="150"><$font>Stack:</FONT></TD>
<TD VALIGN="TOP" WIDTH="475">&nbsp;$rec{'Stack'}</TD></TR>
<TR><TD ALIGN="Right" VALIGN="TOP" WIDTH="150"><$font>Shelf:</FONT></TD>
<TD VALIGN="TOP" WIDTH="475">&nbsp;$rec{'Shelf'}</TD></TR>
<TR><TD ALIGN="Right" VALIGN="TOP" WIDTH="150"><$font>Obtained:</FONT></TD>
<TD VALIGN="TOP" WIDTH="475">&nbsp;$rec{'Obtained'}</TD></TR>|;
}
</TABLE>
}


------------------
JPD





Oct 1, 1999, 9:59 AM
ianan
New User (3 posts)
Oct 1, 1999, 9:59 AM
Post #8 of 8
Views: 2265
Shortcut
Quote Reply
Re: Modifying records In reply to
I have posted the two text files to the following URL directory:

http://ianan.tripod.com/

I hope this is OK. I have actually removed the "list all" option from the modify options at present so that users do not try to use it and then get the error.

Many thanks for your speedy response.

------------------
_________________________
I A N
H e r t f o r d , U K

[This message has been edited by ianan (edited October 01, 1999).]