MySQL question

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

RE: MySQL Question

: 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

Re: MySQL Question

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

Re: 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 can always programatica

MySQL Question

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

Re: MySQL question

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

RE: MySQL question

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

RE: MySQL question

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

Re: MySQL question

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

Re: MySQL question

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

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

Re: MySQL question

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

Re: MySQL question

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

MySQL question

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

Re: MYSQL question

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

MYSQL question

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