Re: column exists but unknown

Nevermind, the problem was not with the DB :\ On Tue, Mar 3, 2009 at 10:44 AM, Richard Whitney 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' ) A

column exists but unknown

on Attributes Null Default Extra Action space_id int(10) UNSIGNED No auto_increment scheme_id int(10) UNSIGNED No 0 campaign_id int(10) UNSIGNED No 0 type enum('Text', 'Banner', 'Rich', 'Text in List') latin1_swedish_ci No Text as you can see campaign_id cl

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 > Wha

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, > $D

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 > U

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: '

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

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

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' doe

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 shif

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 presenc

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 foll

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 P

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