RE: search through one/several tables

2005-03-23 Thread Adams, Pat 006
The best I've been able to come up with involves some shell scripting. If you're running Linux, using unpacked MyISAM tables, and have some scripting ability from whatever language you're writing your application in, you can run this in your MySQL directory: strings -f *.MYD | grep search

RE: Lost connection during query when using SSH tunneling

2004-12-10 Thread Adams, Pat 006
-Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 12:08 PM To: [EMAIL PROTECTED] Subject: Lost connection during query when using SSH tunneling So I use Putty to create the SSH tunneler and then connecting to the local port. Now

RE: Lost connection during query when using SSH tunneling

2004-12-10 Thread Adams, Pat 006
-Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 2:17 PM To: Adams, Pat 006; [EMAIL PROTECTED] Subject: RE: Lost connection during query when using SSH tunneling I am not sure of Putty as I am using plink.exe that is the SSH tunneler

RE: Conditonal where

2004-11-15 Thread Adams, Pat 006
-Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: Sunday, November 14, 2004 11:30 AM To: [EMAIL PROTECTED] Subject: Conditonal where ?php $sql .= SELECT PostStart, JobTitle, Industry, LocationState, VendorID FROM VendorJobs; if ($s_Ind){ $sql

RE: SQL Syntax Problem

2004-11-11 Thread Adams, Pat 006
-Original Message- From: David Blomstrom [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 10, 2004 4:08 PM To: [EMAIL PROTECTED] Subject: SQL Syntax Problem $sql = 'SELECT F.IDArea, C.IDArea, C.Name, C.Pop, C.Nationality, C.NationalityPlural, C.NationalityAdjective FROM