when I search, it will tell me how many records exist, but will only print 1 of them, anyone have this problem?
Thanks in advance
Thanks in advance
Jun 20, 2000, 2:26 PM
Veteran / Moderator (8669 posts)
Jun 20, 2000, 2:26 PM
Post #2 of 12
Views: 4272
Jun 20, 2000, 3:10 PM
Novice (17 posts)
Jun 20, 2000, 3:10 PM
Post #3 of 12
Views: 4256
dear JPDENI,
I have installed the filemod and your customization of the output
the the html file is available to see at:
http://www.aliraqi.com/test/iraqihtml.pl.txt
and the cfg
http://www.aliraqi.com/test/iraqimedia.cfg.txt
Many thanks in advance JPdeni!
I have installed the filemod and your customization of the output
the the html file is available to see at:
http://www.aliraqi.com/test/iraqihtml.pl.txt
and the cfg
http://www.aliraqi.com/test/iraqimedia.cfg.txt
Many thanks in advance JPdeni!
Jun 20, 2000, 5:09 PM
Veteran / Moderator (8669 posts)
Jun 20, 2000, 5:09 PM
Post #4 of 12
Views: 4243
I wasn't able to access your html.pl script. I got a "403 Forbidden" error. My guess is that the problem is in that file.
If you rename the file to html_pl.txt, I should be able to access it.
JPD
http://www.jpdeni.com/dbman/
If you rename the file to html_pl.txt, I should be able to access it.
JPD
http://www.jpdeni.com/dbman/
Jun 20, 2000, 10:20 PM
Novice (17 posts)
Jun 20, 2000, 10:20 PM
Post #5 of 12
Views: 4232
Dear JPDENI,
sorry about that ,i thought it would assume its a text file
anyway
ive renamed it iraqihtml.txt
so its available at
www.aliraqi.com/test/iraqihtml.txt
this is very much appreciated
thankyou in advance!
sorry about that ,i thought it would assume its a text file
anyway
ive renamed it iraqihtml.txt
so its available at
www.aliraqi.com/test/iraqihtml.txt
this is very much appreciated
thankyou in advance!
Jun 21, 2000, 12:02 AM
Veteran / Moderator (8669 posts)
Jun 21, 2000, 12:02 AM
Post #6 of 12
Views: 4225
I don't see where you're getting any of the code that is being generated on your site.
Your sub html_view_success has
print "<table><tr>";
LINE: foreach $col (@db_cols) {
if ($db_form_len{$col} == -1) { next LINE; }
elsif ($db_form_len{$col} == -2) {
if ($per_admin) { print "<td><$font>$col</td>"; }
else { next LINE; }
}
else { print "<td><$font>$col</td>"; }
}
print "</tr>";
for (0 .. $numhits - 1) {
&html_record_row (&array_to_hash($_, @hits));
}
print "</table>";
(I reformatted the lines a little bit.)
and your search results page has
<TABLE CELLSPACING=0 CELLPADDING=0 BORDER=0 WIDTH=100%>
<TR> <TD WIDTH=20%>etc.
Your sub html_record_row consists only of
sub html_record_row {
my (%rec) = @_; # Load any defaults to put in the VALUE field.
($db_auto_generate and print &build_html_record_row(%rec) and return);
}
but you have
$db_auto_generate = 0;
in your .cfg file.
Is this the html.pl and .cfg files you are actually using? From what I can see it is impossible to get the results you're getting if you have these files.
JPD
http://www.jpdeni.com/dbman/
Your sub html_view_success has
Code:
print "<table><tr>";
LINE: foreach $col (@db_cols) {
if ($db_form_len{$col} == -1) { next LINE; }
elsif ($db_form_len{$col} == -2) {
if ($per_admin) { print "<td><$font>$col</td>"; }
else { next LINE; }
}
else { print "<td><$font>$col</td>"; }
}
print "</tr>";
for (0 .. $numhits - 1) {
&html_record_row (&array_to_hash($_, @hits));
}
print "</table>";
and your search results page has
Code:
<TABLE CELLSPACING=0 CELLPADDING=0 BORDER=0 WIDTH=100%>
<TR> <TD WIDTH=20%>etc.
Code:
sub html_record_row {
my (%rec) = @_; # Load any defaults to put in the VALUE field.
($db_auto_generate and print &build_html_record_row(%rec) and return);
}
Code:
$db_auto_generate = 0;
Is this the html.pl and .cfg files you are actually using? From what I can see it is impossible to get the results you're getting if you have these files.
JPD
http://www.jpdeni.com/dbman/
Jun 21, 2000, 12:24 AM
Novice (17 posts)
Jun 21, 2000, 12:24 AM
Post #7 of 12
Views: 4244
Dear JPDENI,
Im pretty certain these were the files, if not, ive upped them to the new locations listed
http://www.aliraqi.com/dbman/dbcgi.txt < DB.CGI
http://www.aliraqi.com/dbman/iraqihtml.txt < HTMLFILE
http://www.aliraqi.com/dbman/iraqimediacfg.txt < CFG FILE
http://www.aliraqi.com/dbman/iraqimediadb.txt < DB FILE
to see it in action
http://www.aliraqi.com/system/db.cgi?db=iraqimedia&uid=&view_records=1&ID=*
Thankyou very much for your help!!
Hass!
Im pretty certain these were the files, if not, ive upped them to the new locations listed
http://www.aliraqi.com/dbman/dbcgi.txt < DB.CGI
http://www.aliraqi.com/dbman/iraqihtml.txt < HTMLFILE
http://www.aliraqi.com/dbman/iraqimediacfg.txt < CFG FILE
http://www.aliraqi.com/dbman/iraqimediadb.txt < DB FILE
to see it in action
http://www.aliraqi.com/system/db.cgi?db=iraqimedia&uid=&view_records=1&ID=*
Thankyou very much for your help!!
Hass!
Jun 21, 2000, 1:30 AM
Veteran / Moderator (8669 posts)
Jun 21, 2000, 1:30 AM
Post #8 of 12
Views: 4256
That html.pl file was completely different than the one I looked at before! 
I would like you to set $db_auto_generate=1; in the .cfg file and see if that gives you your records. This will give me some clue as to where to start looking for the problem.
JPD
http://www.jpdeni.com/dbman/
I would like you to set $db_auto_generate=1; in the .cfg file and see if that gives you your records. This will give me some clue as to where to start looking for the problem.
JPD
http://www.jpdeni.com/dbman/
Jun 21, 2000, 2:14 AM
Novice (17 posts)
Jun 21, 2000, 2:14 AM
Post #9 of 12
Views: 4227
ok
http://www.aliraqi.com/system/db.cgi?db=iraqimedia&uid=&view_records=1&ID=*
now autogenerate is on, and it still only displays 1 record
hmmm...
intruiging the veteran!!
http://www.aliraqi.com/system/db.cgi?db=iraqimedia&uid=&view_records=1&ID=*
now autogenerate is on, and it still only displays 1 record
hmmm...
intruiging the veteran!!
Jun 21, 2000, 3:15 AM
Veteran / Moderator (8669 posts)
Jun 21, 2000, 3:15 AM
Post #10 of 12
Views: 4231
You sure are!
You're probably not going to like this, but I want you to save your html.pl and db.cgi files in a safe place and replace them with the completely unmodified files. Keep $db_auto_generate the way it is in your .cfg file.
See what happens. If it still only lists one record, then the problem must be somewhere in your .cfg file.
If you get both records listed, put just your modified db.cgi file back in the directory and try it again. If it only lists one record then, the problem is in your db.cgi file.
If it lists both, put your modified html.pl file back and try once more. If it only lists one, the problem is with your html.pl file. (Are you beginning to see a pattern here?
)
If we can narrow it down to a file that's the problem, it's a lot easier to work out where the problem is.
JPD
http://www.jpdeni.com/dbman/
You're probably not going to like this, but I want you to save your html.pl and db.cgi files in a safe place and replace them with the completely unmodified files. Keep $db_auto_generate the way it is in your .cfg file.
See what happens. If it still only lists one record, then the problem must be somewhere in your .cfg file.
If you get both records listed, put just your modified db.cgi file back in the directory and try it again. If it only lists one record then, the problem is in your db.cgi file.
If it lists both, put your modified html.pl file back and try once more. If it only lists one, the problem is with your html.pl file. (Are you beginning to see a pattern here?
) If we can narrow it down to a file that's the problem, it's a lot easier to work out where the problem is.
JPD
http://www.jpdeni.com/dbman/
Jun 21, 2000, 3:22 AM
Novice (17 posts)
Jun 21, 2000, 3:22 AM
Post #11 of 12
Views: 4227
http://www.aliraqi.com/system/db.cgi?db=iraqimedia&uid=&view_records=1&ID=*
Done, replaced both files, and still same problem
I guess its a problem with the .cfg File Madame?
Done, replaced both files, and still same problem
I guess its a problem with the .cfg File Madame?
Jun 21, 2000, 3:16 PM
Veteran / Moderator (8669 posts)
Jun 21, 2000, 3:16 PM
Post #12 of 12
Views: 4203
Looks like you did some work while I was sleeping. You have all records displayed and you are using your own html.pl file.
Glad you were able to figure it out.
JPD
http://www.jpdeni.com/dbman/
Glad you were able to figure it out.
JPD
http://www.jpdeni.com/dbman/