Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Alphabet Search Not Working

Quote Reply
Alphabet Search Not Working
Hello
I have added the following code to the html_home part of my user friendly HTML.pl, but it is still not returning the records containing the first alphabet, even though it is in the database. Please can anyone help.
Below is the code

$i = 65;
print "<TABLE><TR>";
while ( $i < 91 ) {
print qq|<TD><PRE><BIG><A HREF="$db_script_link_url&Company_Name=^|;
print chr($i);
print qq|&re=on&view_records=1"><B>|;
print chr($i);
print qq|</B></A></BIG></PRE></TD>\n|;
$i++;
}
print "</TR></TABLE>";
.
The url to the database is http://www.bizsuccess.co.uk/cgi-bizSuccess/dbman/db.cgi
and the username/password is bizSuccess/gateway

Ade

Quote Reply
Re: Alphabet Search Not Working In reply to
$i needs to be localized by putting my before it.

Code:

my $i = 65;


Regards,

Eliot Lee
Quote Reply
Re: Alphabet Search Not Working In reply to
Thanks. I have added my to it, but it is still not working.