Gossamer Forum: General: Databases and SQL: AdLength = 28

Feb 25, 2003, 7:57 AM

Andy

Veteran / Moderator (17297 posts)

Feb 25, 2003, 7:57 AM

Post #1 of 6

Shortcut

AdLength = 28

Can anyone see why this wouldn't return a result?

UPDATE lsql_Links SET isValidated = 'No' WHERE Mod_Date = '2003-01-28' AND AdLength = 28

I've tried taking out the 'AND AdLength = 28, and it works fine (returns one affected row) ... it seems to be the AdLength = .. part thats screwing it up Unsure

I've tried changing it to;

AdLength = '28'
and
AdLength = "28"

Can anyone see why this wont work? I've been staring and playing with it for ages...and its quite honestly just pissing me off Frown

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Feb 25, 2003, 7:58 AM

Andy

Veteran / Moderator (17297 posts)

Feb 25, 2003, 7:58 AM

Post #2 of 6

Shortcut

Re: [Andy] AdLength = 28 In reply to

Oh, and in the table, the AdLength field does exist...and there is a link in there with Mod_Date => '2003-01-28' and AdLength => 28. Before anyone asks me to check the DB Tongue

Cheers

Andy (mod)
andy@ultranerds.co.uk

Feb 25, 2003, 8:00 AM

Paul

Veteran (19537 posts)

Feb 25, 2003, 8:00 AM

Post #3 of 6

Shortcut

Re: [Andy] AdLength = 28 In reply to

I don't see a reason for it not to work as long as the Mod_Date and AdLength values are correct.

Make sure you don't have any blank spaces or anything.

Feb 25, 2003, 8:09 AM

Andy

Veteran / Moderator (17297 posts)

Feb 25, 2003, 8:09 AM

Post #4 of 6

Shortcut

Re: [Paul] AdLength = 28 In reply to

Thats what I thought....its really weird Unsure

DB Dump gives;

CREATE TABLE lsql_Links (
ID int(10) unsigned DEFAULT '' NOT NULL auto_increment,
Title varchar(100) DEFAULT '' NOT NULL ,
LinkOwner varchar(50) DEFAULT 'admin' NOT NULL ,
Add_Date date DEFAULT '0000-00-00' NOT NULL ,
Mod_Date date DEFAULT '0000-00-00' NOT NULL ,
Description text ,
Contact_Name varchar(255) ,
Contact_Email varchar(255) ,
Hits int(11) DEFAULT '0' NOT NULL ,
isNew enum('No','Yes') DEFAULT 'No' NOT NULL ,
isChanged enum('No','Yes') DEFAULT 'No' NOT NULL ,
isPopular enum('No','Yes') DEFAULT 'No' NOT NULL ,
isValidated enum('No','Yes') DEFAULT 'Yes' NOT NULL ,
Rating float(12,2) DEFAULT '0.00' NOT NULL ,
Votes smallint(5) unsigned DEFAULT '0' NOT NULL ,
Status smallint(6) DEFAULT '0' NOT NULL ,
Date_Checked datetime DEFAULT '0000-00-00 00:00:00' ,
Timestmp timestamp(14) ,
Phone varchar(100) DEFAULT '(Area Code)' NOT NULL ,
Recommended int(11) ,
URL text ,
AdLength int(11) DEFAULT '14' ,
AlertMessage varchar(255) DEFAULT 'NotSent' ,
PRIMARY KEY (ID),
KEY userndx (LinkOwner),
KEY popndx (isPopular),
KEY stndx (Status),
KEY newndx (isNew),
KEY valndx (isValidated),
KEY Phone_idx (Phone)
);

INSERT INTO lsql_Links VALUES('53','test advert','admin','2003-02-25','2003-01-28','wdterjt','fwrwer test','webmaster@ace-installer.com','0','Yes','No','No','No','0.00','0','0','2003-02-25 09:31:59','20030225100412','(3435) 34535345','0','','28','NotSent');

Notice fields 5 and 22 are the ones in question.

Thanks for the reply Smile