PROTECTED]
To: Curtis Gordon [EMAIL PROTECTED]
Subject: RE: DAYOFYEAR()
Date: Mon, 14 Jan 2002 16:36:07 +1300
Curtis,
This is not a mysql issue ('Error - Perl execution failed')
works fine for me:
my $hashref = $dbh-selectall_hashref(END_SQL);
select DAYOFYEAR('2002-01-14 11:08:40')
END_SQL
Hi! I'm storing a date in this format :
2002-01-13 11:08:40
-mm-dd hh:mm:ss
This is great because it gives me the date and the time, which I need.
I want to compare this date from the database to the current DAYOFYEAR()
but when I do this
select DAYOFYEAR('2002-01-13 11:08:40')
I get this
that on incase anybody else was having similar
trouble.
(C:
From: Curtis Gordon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: DAYOFYEAR()
Date: Mon, 14 Jan 2002 03:24:02 +
Hi! I'm storing a date in this format :
2002-01-13 11:08:40
-mm-dd hh:mm:ss
This is great because it gives me the date
Hi i'm a linux newbie!
I need to create a database that is accessable by everybody but i can't find
an easy to use example of this. I have seen many attempts at it, but none
that say, do this and that, here is an example TAH DAH!.
That is what I need. I have setup a database and that was
Hi everybody, I'm still new to Linux, and mySQL. I have a mySQL db on a
win32 box that I want replicated on my new Linux box. I have managed to do a
mySQLdump on the win32 box and have successfully relocated the db to the
Linux box, I could though, only do it if I was logged into mySQL as root
Hi, I have just setup a dedicated linux/php/mysql dev box in my office and I
am gearing up to move my databases from a windows box to the linux box.
There are a couple of things I would like to be clear on before I start.
1) when I am logged into linux as user1 and I create a database, does
Thank you Eric and Mike, I really appreciate the help!
From: Mike(mickalo)Blezien [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Curtis Gordon [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: just moved from windows to linux mysql
Date: Thu, 06 Dec 2001 13:50:52 -0600
Just to add a few
Hi again, thank you to all that helped me out with my last query.
I'm on a linux box now (YIPEE) I have created a database, and I have
actually managed to load data in that I backed up from a win32 based mysql
database (I'm toally pumped at this point), I set some permissions on the
dir
: 847.867.9427
-Original Message-
From: Curtis Gordon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 6:06 PM
To: [EMAIL PROTECTED]
Subject: i own it but i can't use it %$#$@
Hi again, thank you to all that helped me out with my last query. I'm
on a linux box now (YIPEE) I have
cause that error in linux? (off topic I know, sorry)
From: Todd Williamsen [EMAIL PROTECTED]
To: 'Curtis Gordon' [EMAIL PROTECTED]
Subject: RE: i own it but i can't use it %$#$@
Date: Thu, 6 Dec 2001 20:34:27 -0600
What do you mean demo If you are demostrating a front end then it
doesn't matter
Thank you for the tip Johnny, I'll copy that code to a snippet and use that
from now on.
(C:
From: Johnny Withers [EMAIL PROTECTED]
To: 'Curtis Gordon' [EMAIL PROTECTED]
Subject: RE: persistant insert trouble
Date: Tue, 30 Oct 2001 08:04:58 -0600
Next time, instead of banging your head
INSERT INTO duser (username, upass, fname, lname, hphone, haddress, hcity,
hstate, hcountry, hemail, utype) VALUES
('$username','$upass'.'$fname','$lname','$hphone','$haddress','$hcity','$hstate','$hcountry','$hemail','$utype')
this is an insert statement that works fine in the console, but
Michael Stassen I owe you my sanity!!!
THANK YOU THANK YOU THANK YOU!!!
(my wife is laughing at me for being such a dork)
I really appreciate your help thank you very much.
From: Michael Stassen [EMAIL PROTECTED]
To: Curtis Gordon [EMAIL PROTECTED]
Subject: Re: persistant insert trouble
Date
Hello, I am attempting to insert user information into a mysql db, I am
using php4 and the lastest win32 distribution of mysql. I don't get an error
when I try the insert, but the data is not saved. I can create tables just
fine. Also when I enter the same information in the console it insert
Thanks Jim! That didn't even occur to me! Now I looking all through the
mysql folder and I can't find a single log file, where are they kept on a
win32 machine? Do you know?
From: jim barchuk [EMAIL PROTECTED]
To: Curtis Gordon [EMAIL PROTECTED]
Subject: Re: insert trouble
Date: Sat, 27 Oct
hi Jim, I am finding a TON of errors like this one..
[Sat Oct 27 01:14:57 2001] [error] [client **.***.***.**] File does not
exist: c:/phpweb/scripts/..%5c/winnt/system32/cmd.exe
I am not on a winnt system though, I'm running winME here at home. It looks
to me like somebody is trying to
omg!
code red!!
I JUST installed apache and mysql the other day because my host went down
and I didn't want to miss out on dev time!
Is is possible that the downloads i grabbed were already infected?
_
Get your FREE download of MSN
17 matches
Mail list logo