Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: JimJx
- Order by date
-
Case sensitivity
Since the DB already has the first letter of all of the keywords capitalized, I went with UCFIRST Not an ideal solution, but I will have to live with it for now..... -
Case sensitivity
No need to apologize.... You are just covering all of the bases. But that still begs the question: What is going on here? Have I stumbled across a bug or what??? -
Case sensitivity
CREATE TABLE `valley` (\n `Category` varchar(25) NOT NULL default '',\n `Name` varchar(50) NOT NULL default '',\n `Description` varchar(250) default NULL,\n `Contact` varchar(30) NOT NULL default '',\n `Phone` varchar(10) NOT NULL default '',\n `Fax` varchar(10) default NULL,\n `Address`... -
Case sensitivity
Honestly, I don't remember where I got that create table from, it has been a while.... But, I integrated your suggestions into the table. Actually, I deleted the table and recreated it. I was hoping that that would get rid of the case sensitiveness... No joy.... Anyway, here is the way that... -
-
Case sensitivity
CREATE TABLE valley ( `Category` VARCHAR(25) not null , `Name` VARCHAR(50) not null , `Description` TEXT , `Contact` VARCHAR(20) not null , `Phone` TEXT(10) not null , `Fax` TEXT(10) , `Address` VARCHAR(25) , `City` VARCHAR(25) , `State` VARCHAR(2) , `ZipCode` MEDIUMINT , `Email` VARCHAR(50) ... -
Case sensitivity
Hi all, I know that searches in MySQL are supposed to be case insensitive so this is driving me nutz... Quick run down... 1 table, 13 columns. Columns 1 - 12 are type text collation is latin1_swedish_ci Column 13 Set to mediumint autoincrement, primary key collation is... -
SELECT 2 columns?
When I use that snippet of code, I will get any matches from 'keywords' but nothing from category, even though I know there is a category with the var in it.... Example: If the form passes 'auto' and I have an entry in keywords for 'auto dealers' and a category for 'auto repair', I will get the... -
SELECT 2 columns?
From me, of course! :) Just means not working correctly. An old fighter pilot term that meant they hadn't spotted the enemy even though they were told the enemy was around..... -
SELECT 2 columns?
Hi all, I have what I hope is a simple question.... I have a table with several columns, the 2 I am concerned with at the moment are Category and Keywords. I need to search both of these columns for a word or short phrase that I get from a form. For example, the search can be 'Antiques' or... -
-
Table columns in CGI
One more thing..... I am pulling the data from the db and getting it into 2 columns. But, the data is turning out like this: Notice the double entries.... I am using the routine from above with some minor changes.... for (my $i = 0; $i < $per_page && $i < @{$tbl_ref}-1; $i++) { # get... -
Can't use an undefined value as an ARRAY reference at search.cgi line
Yes, the complete code for that line is FROM valley where name REGEXP '^[[:digit:]]' So I have the complete query as $query = sprintf ( "SELECT name, address, city, phone FROM valley where name REGEXP '^[[:digit:]]' ORDER BY name LIMIT %d,%d", $start - 1, $per_page + 1)... -
Can't use an undefined value as an ARRAY reference at search.cgi line
Good catch on the eq, I completely blew that one.... And this is MySQL, so the regex command is REGEXP '^[[:digit:]]' to match any number. Thanks for the help guys, greatly appreciated. Jim -
Can't use an undefined value as an ARRAY reference at search.cgi line
Hi all, I have what seems to me to be a strange problem.... I have the script below: <code> if ($type eq 'alpha') { $query = sprintf ( "SELECT name, address, city, phone FROM valley where name like '$search%' ORDER BY name LIMIT... -
Select #s
Hi all, I have what I hope is an easy question, but I could not find the answer anywhere in the docs.... I have a select statement: SELECT name, address, city, phone FROM valley WHERE name LIKE '$search%' ORDER BY name LIMIT %d,%d Some of the entries in the name field in the DB begin with... -
Table columns in CGI
That was it Kevin! Thank you very much, have a star! :-) Really appreciate the help. Jim -
Table columns in CGI
Thanks for the replies guys! Chris, I know how to do what you proposed but it just isn't right in this situation. But thanks for taking the time to reply. Kevin, I think your solution will work, but I have a question.... After trying to integrate it into my script it still only pulls one... -
Table columns in CGI
Sorry about that... Produces 1 column, in the style of: field1 field2 fiels3 field4 field5 field6 fiels7 field8 field9 field10 fiels11 field12 What I would like is something more along the lines of field1 field5 field2 field6 field3 field7 field4 field8 field9 field10 field11...
