One of my fields has had a collection of line breaks inserted in between
first and second names. I think I have solved the problem but I now need to
remove all of the line breaks that have been inserted so far.
I could query the db then use CF to replace chr(13) & chr(10) with " ", but
is there a
: MySQL Question
I could be wrong (morning caffeine hasn't kicked in) but IIRC, you can't
set a length on TEXT. You can only set a length on varchar, nvarchar,
char, etc. If you try to set a length on a TEXT field, it tries to
revert it to a varchar(?), which is limited.
That said, you
I don't think you specifiy the Length for a text field.
It gets as big as it needs to in blocks of (8K?).
Jerry Johnson
Web Developer
Dolan Media Company
>>> [EMAIL PROTECTED] 01/12/05 10:14AM >>>
I am using MySQL and one of the tables I created has a COMMENTS
field (TEXT) and want to set the
I could be wrong (morning caffeine hasn't kicked in) but IIRC, you can't
set a length on TEXT. You can only set a length on varchar, nvarchar,
char, etc. If you try to set a length on a TEXT field, it tries to
revert it to a varchar(?), which is limited.
That said, you can always programatica
I am using MySQL and one of the tables I created has a COMMENTS
field (TEXT) and want to set the length of it to 4000.
I am using the latest NaviCat 6.1 and I get the error that:
4000 is not a valid value for field 'Length'. The allowed range is 0 to
255.
Correct me if I am wrong, for TEXT da
Adkins, Randy wrote:
> Does anyone know the proper default value for a DateTime
> Field in mySQL?
A default representing the time the record was inserted is not going to happen.
If you have the latest release *and* you use the timestamp datatype you might
be able to create something that looks s
My bet would be casting issues.
the datetime field takes [what?] as a valid value.
the now() function returns [what?] as its value.
Do these two match? Do you need to use the dateFormat function to cast the
now() function return into something the datetime default will like?
My mySQL skills are
?
-Original Message-
From: JediHomer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 04, 2005 11:32 AM
To: CF-Community
Subject: Re: MySQL question
Try wrapping it in a CreateODBCDateTime(Now()) or lookup the format of
the field on the mySQL site and DateFormat() or see if mySQL has an
inbuilt
http://simon.incutio.com/archive/2003/07/11/storingDatesInMySQL
On Tue, 04 Jan 2005 11:32:10 -0500, Ben Doom <[EMAIL PROTECTED]> wrote:
> Sorry, misread your question.
>
> Ben Doom wrote:
> > IIRC, it's easiest to pass it as "-mm-dd hh:mm:ss".
> >
> > --Ben
> >
> > Adkins, Randy wrote:
> >
>
Sorry, misread your question.
Ben Doom wrote:
> IIRC, it's easiest to pass it as "-mm-dd hh:mm:ss".
>
> --Ben
>
> Adkins, Randy wrote:
>
>>Does anyone know the proper default value for a DateTime
>>Field in mySQL?
>>
>>I tried using Now() and it converts it to: 0:00:00 0:00:00
>>Which is il
Try wrapping it in a CreateODBCDateTime(Now()) or lookup the format of
the field on the mySQL site and DateFormat() or see if mySQL has an
inbuilt version of Now() if all you are going to store is now()
HTH
On Tue, 4 Jan 2005 11:19:06 -0500, Adkins, Randy <[EMAIL PROTECTED]> wrote:
> Does anyone
IIRC, it's easiest to pass it as "-mm-dd hh:mm:ss".
--Ben
Adkins, Randy wrote:
> Does anyone know the proper default value for a DateTime
> Field in mySQL?
>
> I tried using Now() and it converts it to: 0:00:00 0:00:00
> Which is illegal value or call or something like that.
>
> I want tha
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
NOW()
(Which is either a string or a number depending on context)
mysql> SELECT NOW();
-> '1997-12-15 23:50:26'
mysql> SELECT NOW() + 0;
-> 19971215235026
Jerry Johnson
Web Developer
Dolan Media Company
>>> [EMAI
Does anyone know the proper default value for a DateTime
Field in mySQL?
I tried using Now() and it converts it to: 0:00:00 0:00:00
Which is illegal value or call or something like that.
I want that to be triggered as the default datetime when
A record is added to the table rather than setting t
Bill Wheatley wrote:
> What in mysql is like SQL where you can do
>
> update blah
> set blah=2
> where blah=2
>
> if @@ROWCOUNT = 0
That is not SQL but some propietary idiosyncracy. In MySQL you would use ON DUPLICATE KEY UPDATE (which is another propietary idiosyncracy). In SQL you would use ME
What in mysql is like SQL where you can do
update blah
set blah=2
where blah=2
if @@ROWCOUNT = 0
insert into blah()
anything in mysql that does that
William Wheatley
Coldfusion Guru
Do not meddle in the affairs of dragons,
for you are crunchy and taste good with ketchup.
[Todays Threads
16 matches
Mail list logo