FUDforum: comp.lang.php » Putting it all together

Home » Imported messages » comp.lang.php » Putting it all together

Show: Today's Messages :: Polls :: Message Navigator

Re: Storing dates [message #186254 is a reply to message #186252]

Sat, 21 June 2014 21:49

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 6/21/2014 5:33 PM, Tim Streater wrote:
> In article <lo4sa4$h1p$1(at)dont-email(dot)me>, Jerry Stuckle
> <jstucklex(at)attglobal(dot)net> wrote:
>
>> On 6/21/2014 5:06 PM, Tim Streater wrote:
>>> In article <XnsA353998B95688dougmilmaccom(at)78(dot)46(dot)70(dot)116>, Doug Miller
>>> <doug_at_milmac_dot_com(at)example(dot)com> wrote:
>>>> > richard <noreply(at)example(dot)com> wrote in
>>>> news:hzk4wa449wa$(dot)3xtj0jkxz78o$(dot)dlg(at)40tude(dot)net:
>>>> > On Sat, 21 Jun 2014 17:42:29 +0000 (UTC), Doug Miller wrote:
>>>> > >> richard <noreply(at)example(dot)com> wrote in
>>>> >> news:1mddkhwt2mr0v$.1m6eithcu7iod.dlg@ 40tude.net:
>>>> >> >>> As for the date usage on MY database tables, I am only using a
>>>> >>> date as a reference.
>>>> >> >> Patently false, as you have posted questions here asking for
>>>> >> help resolving your problems in sorting by the date.
>>>> >> >>> I really don't give a damn what your philosophy or ideals are
>>>> >>> behind the so called "proper ways" of obtaining a date.
>>>> >> >> Which is exactly *why* you have problems sorting by the date.
>>>> > > The problem with sorting is, it treats any value given as a
>>>> > string, then determines which has the lowest value in total.
>>>>
>>>> Yes, I understand that. That results directly from storing dates as
>>>> strings,
>>>> and is exactly the reason that everyone here has been telling you to
>>>> store your dates in a
>>>> column that has
>>>> the DATE datatype, not CHAR.
>>>> Your refusal to follow that advice -- apparently stemming from your
>>>> inability
>>>> to understand that there even *are* datatypes other than NUMERIC and
>>>> CHAR -- is the entire reason you are having this sorting problem.
>>>> I have a field which contains values like 3.7, 4.2, etc. But when I
>>> defined the field (in SQLite) I made it a TEXT field, forgetting that I
>>> would need to be able to sort on that field.
>>>> My workaround is to convert the string to floating at the time of the
>>> sort. In SQLite I do:
>>>> ... ORDER BY ROUND(myfield,1);
>>>> which works just fine. Richard should look for something similar in
>>> mysql.
>>
>> Why don't you fix your database?
>>
>> The way you're doing it cannot use an index and will call round() for
>> EVERY row in the sort.
>
> I'd have to ask a number of users to convert their data when they next
> upgrade the software. Trouble is in SQLite you can't just redefine a
> table column to be a different type; ALTER TABLE is somewhat limited.
> I'd have to copy the whole table to another, DROP the first one, RENAME
> the new one, VACUUM the database to get its size down. OK, it's doable,
> but I'm replying on less-than-technically-savvy users to run a Terminal
> script on their own machine to effect this change.
>

Or have a script do it for them.

> In my own use of the app, I've got 65 databases that an update script
> would have to find, recursively in an arbitrary folder structure. One
> user has 1000. The recursion part is actually easy, that app already
> does that at startup to verify that the user hasn't moved some
> databases around by hand while the app wasn't running. I just feel a
> shade nervous about distant people (i.e., not me) running a one-off
> script.
>

People do it every day. Just ensure everything is backed up before
doing any conversion.

> In richard's case, it didn't sound like he has a huge number of rows,
> so it struck me that a workaround wouldn't have much of a performance
> impact. In mine, the column in question is unlikely to be a popular one
> for sorting.
>

ANYTHING with richard is a problem.

--
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex(at)attglobal(dot)net
==================

Report message to a moderator

[Message index]

		Putting it all together By: Mr Oldies on Fri, 20 June 2014 14:20
		Re: Putting it all together By: Evan Platt on Fri, 20 June 2014 15:11
		Re: Putting it all together By: Mr Oldies on Fri, 20 June 2014 15:24
		Re: Putting it all together By: Doug Miller on Fri, 20 June 2014 17:15
		Re: Putting it all together By: Evan Platt on Sat, 21 June 2014 03:01
		Re: Putting it all together By: Jrgen Exner on Fri, 20 June 2014 15:21
		Re: Putting it all together By: Norman Peelman on Sat, 21 June 2014 01:06
		Re: Putting it all together By: Denis McMahon on Sat, 21 June 2014 03:02
		Re: Putting it all together By: Denis McMahon on Sat, 21 June 2014 03:09
		Re: Putting it all together By: Jrgen Exner on Sat, 21 June 2014 03:13
		Re: Putting it all together By: Mr Oldies on Sat, 21 June 2014 03:34
		Re: Putting it all together By: Jrgen Exner on Sat, 21 June 2014 03:48
		Re: Putting it all together By: Evan Platt on Sat, 21 June 2014 04:00
		Re: Putting it all together By: Doug Miller on Sat, 21 June 2014 04:22
		Re: Putting it all together By: Jrgen Exner on Sat, 21 June 2014 05:11
		Re: Putting it all together By: Evan Platt on Sat, 21 June 2014 05:39
		Re: Putting it all together By: gordonb.zp2md on Sat, 21 June 2014 09:15
		Storing dates (was: Putting it all together) By: Thomas 'PointedEars' on Sat, 21 June 2014 10:15
		Re: Storing dates By: Mr Oldies on Sat, 21 June 2014 15:10
		Re: Storing dates By: Doug Miller on Sat, 21 June 2014 17:42
		Re: Storing dates By: Mr Oldies on Sat, 21 June 2014 18:28
		Re: Storing dates By: Jrgen Exner on Sat, 21 June 2014 19:04
		Re: Storing dates By: Doug Miller on Sat, 21 June 2014 19:06
		Re: Storing dates By: Tim Streater on Sat, 21 June 2014 21:06
		Re: Storing dates By: Jerry Stuckle on Sat, 21 June 2014 21:09
		Re: Storing dates By: Tim Streater on Sat, 21 June 2014 21:33
		Re: Storing dates By: Jerry Stuckle on Sat, 21 June 2014 21:49
		Re: Storing dates By: Thomas 'PointedEars' on Sun, 22 June 2014 12:38
		Re: Storing dates By: Jrgen Exner on Sat, 21 June 2014 21:31
		Re: Storing dates By: Tim Streater on Sat, 21 June 2014 21:44
		Re: Storing dates By: Thomas 'PointedEars' on Sun, 22 June 2014 12:59
		Re: Storing dates By: Denis McMahon on Sat, 21 June 2014 23:19
		Re: Storing dates By: Arno Welzel on Sun, 22 June 2014 06:53
		Re: Storing dates By: Erick T. Barkhuis on Sun, 22 June 2014 08:03
		Re: Storing dates By: Jerry Stuckle on Sun, 22 June 2014 13:29
		Re: Storing dates By: Erick T. Barkhuis on Sun, 22 June 2014 14:24
		Re: Storing dates By: Jerry Stuckle on Sun, 22 June 2014 14:32
		Re: Storing dates By: Erick T. Barkhuis on Sun, 22 June 2014 14:45
		Re: Storing dates By: Denis McMahon on Sun, 22 June 2014 19:44
		Re: Storing dates By: Jrgen Exner on Sun, 22 June 2014 15:26
		Re: Storing dates By: gordonb.q26od on Sun, 22 June 2014 15:00
		Re: Storing dates By: Arno Welzel on Sun, 22 June 2014 14:47
		Re: Storing dates By: Mr Oldies on Sun, 22 June 2014 17:55
		Re: Storing dates By: Jrgen Exner on Sun, 22 June 2014 19:31
		Re: Storing dates By: Thomas 'PointedEars' on Tue, 24 June 2014 20:27
		Re: Storing dates By: Denis McMahon on Sun, 22 June 2014 19:52
		Re: Storing dates By: Arno Welzel on Sun, 22 June 2014 19:52
		Re: Storing dates By: Mr Oldies on Sun, 22 June 2014 18:05
		Re: Storing dates By: Arno Welzel on Sun, 22 June 2014 19:56
		Re: Storing dates By: Mr Oldies on Mon, 23 June 2014 02:46
		Re: Storing dates By: Arno Welzel on Mon, 23 June 2014 06:11
		Re: Storing dates By: Mr Oldies on Mon, 23 June 2014 06:37
		Re: Storing dates By: Arno Welzel on Mon, 23 June 2014 09:10
		Re: Storing dates By: Evan Platt on Mon, 23 June 2014 13:50
		Re: Storing dates By: Mr Oldies on Mon, 23 June 2014 15:13
		Re: Storing dates By: Evan Platt on Mon, 23 June 2014 16:13
		Re: Storing dates By: Arno Welzel on Mon, 23 June 2014 20:33
		Re: Storing dates By: Mr Oldies on Mon, 23 June 2014 03:04
		Re: Storing dates By: Arno Welzel on Mon, 23 June 2014 06:12
		Re: Storing dates By: Geoff Muldoon on Mon, 23 June 2014 06:45
		Re: Storing dates By: Mr Oldies on Mon, 23 June 2014 11:58
		Re: Storing dates By: Jrgen Exner on Mon, 23 June 2014 16:50
		Re: Storing dates By: Christoph Michael Bec on Mon, 23 June 2014 17:02
		Re: Storing dates By: Geoff Muldoon on Tue, 24 June 2014 02:00
		Re: Storing dates By: Thomas 'PointedEars' on Tue, 24 June 2014 20:38
		Re: Storing dates By: Jrgen Exner on Sun, 22 June 2014 22:30
		Re: Storing dates By: Peter H. Coffin on Mon, 23 June 2014 01:10
		Re: Putting it all together By: Jrgen Exner on Sat, 21 June 2014 10:34
		Re: Putting it all together By: Denis McMahon on Sat, 21 June 2014 10:23
		Re: Putting it all together By: bill on Sat, 21 June 2014 11:03
		Re: Putting it all together By: Denis McMahon on Sat, 21 June 2014 15:11
		Re: Putting it all together By: Peter H. Coffin on Sat, 21 June 2014 15:57
		Re: Putting it all together By: Arno Welzel on Sun, 22 June 2014 06:45

Previous Topic:	str_replace does not like empty quotes
Next Topic:	SplFileObject always returns an extra "last" line -- why?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 21:48:07 GMT 2024

Total time taken to generate the page: 0.04438 seconds