column exists but unknown

', 'Rich', 'Text in List') latin1_swedish_ci No Text as you can see campaign_id clearly exists in the table Is my table corrupt? Any ideas? Thank you for your help. Richard -- Richard Whitney phpmy...@gmail.com http://phpmydev.com Ofc. 602-288-5340 Ofc. 877-624-6302 Fax. 480-704-4559 You come up

Re: column exists but unknown

Nevermind, the problem was not with the DB :\ On Tue, Mar 3, 2009 at 10:44 AM, Richard Whitney phpmy...@gmail.com wrote: Hello. I am running MySQL 5.0.45 and have the following query and error: SQL query: SELECT SQL_CALC_FOUND_ROWS CONCAT( 'Edit Space' ) AS '', CONCAT( 'Edit Status

Re: results in random order.

Quoting Richard Reina [EMAIL PROTECTED]: I am trying to get this query to randomly pick a record from a table (trans) but it's not working: SELECT ID FROM trans ORDER BY RAND() LIMIT 1; Can anyone let me know what I'm doing wrong and/or how to fix it. Thanks, Richard What error(s) is

Re: insert was working

Gerald! Do you have an auto_increment field? If so, what's it set as? Richard Quoting Gerald Preston [EMAIL PROTECTED]: Hi! I was able to insert data with the following: sub insert_sql { my ( $group_name, $me, $daily, $item, $unit, $qty, $amount, $tax, $total, $DEBUG ) = @_;

Re: Error in Insert on Duplicate Key Update

Quoting sam wun [EMAIL PROTECTED]: HI, the following insert/update produced error. I m using MySQL 5.0. $insert_sql = qq {insert into inventory (prodcode,qty,lastupdatedate,prodname,basename,vendorname,cost) values (?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE

Fwd: Load data infile...

This is using MySQL version 3.23.49 I think I'm bringing this up again but with different errors. This: $sql = LOAD DATA INFILE '$file' REPLACE INTO TABLE `jobs` FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '' LINES TERMINATED BY '\\r\\n'; is getting

Load data infile...

I think I'm bringing this up again but with different errors. This: $sql = LOAD DATA INFILE '$file' REPLACE INTO TABLE `jobs` FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '' LINES TERMINATED BY '\\r\\n'; is getting the error Access denied for user:

Re: AW: [PHP] How to argue with ASP people...

FOAD Quoting Freddie Sorensen [EMAIL PROTECTED]: Tony, Check out ASP.NET and you will want to forget everything about PHP ;-) Freddie -Ursprüngliche Nachricht- Von: mail.pmpa [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 31. Dezember 2004 03:27 An: mysql@lists.mysql.com

SELECT based on TIMESTAMP (DATETIME)

Hello! I need to pull records from the db where the timestamp column (2004-11-01 00:00:00) greater than November 1, 2004 WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) = a.createdate doesn't work DATE_SUB(CURDATE(),INTERVAL 30 DAY) = a.createdate doesn't work a.createdate '2004-11-01 00:00:00'

Re: newbie: relationships between fields

Quoting Christian Kavanagh [EMAIL PROTECTED]: Dear list, I'm hoping to move to MySQL from Access, mostly so I can use my Mac to build databases. So far I've been able to set up MySQL, connect to it, and create databases and tables. Getting to this point has required a paradigm shift or

Re: Problem connecting to MySQL 4.1.7 running on another machine

Quoting Kevin Barry [EMAIL PROTECTED]: I've installed ver 4.1.7 on a brand new Fedora Core 3 server but cannot connect remotely from a Mac OSX machine running Navicat or a Win XP machine running MySQL Admin. I can ping the machine with no problem and have opened the firewall for the 3306

ebay - WOT

My wife has inspired the following: ebay woman! ebay woman! ebay woman, Sunday afternoon ebay woman, Sunday afternoon tops and pants, pots and pans never saw a womanso broke R. Whitney Transcend Development Producing the next phase of your internet presence http://xend.net Premium Quality

next autoindex

Hello! I have situation where I need to find the next autoindex of a table - not just max(field) because the next autoindex may not jive with the number created by max(field) Any ideas? Am I making sense? Thanks! R. Whitney Transcend Development Producing the next phase of your internet

LOAD DATA LOCAL INFILE

Hi! Can someone point me in the right direction? I have this that works in v.4x: $sql = LOAD DATA LOCAL INFILE '$file' REPLACE INTO TABLE `members` FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '' LINES TERMINATED BY '\\r\\n'; When I try it using 3.23.55 I get the

OT - Gmail invite

Could one of you send me an invite to gmail? I screwed mine up by admitting I sold some on ebay. As soon as I did that I stopped getting any mail. You may recall me as [EMAIL PROTECTED] Thanks! R. Whitney Transcend Development Producing the next phase of your internet presence http://xend.net

OT: Gmail

I have 3 invites - anyone interested? -- R. Whitney Transcend Development Producing the next phase of your internet presence http://xend.net Premium Quality Web Hosting http://hosting.xend.net [EMAIL PROTECTED] [EMAIL PROTECTED] 310-943-6498 602-288-5340 The day this country abandons God is the