| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> muffler mu(umlaut)ller, mx systems, mysql
<0> or latin1_german2_ci
<1> wtf are you guys blabbing about
<1> you should be able to do ORDER BY <expression>
<0> what's the default?
<0> latin1?
<1> where <expression> is a field, or a function, or a bunch of functions
<2> yeah latin1_german1_ci
<2> latin1 is default
<1> it's just not going to be entirely efficeient because mysql won't have an index on that value
<3> groogs: and you can, but what expression would efficiently make the strings comparable as design_chick desires?
<1> Two-Bits: well it depends on the rules design_chick has for sorting
<2> SELECT X FROM T ORDER BY X COLLATE collation_name;
<2> let me try and set collation language
<1> theres no magic solution here ,you have to explicity tell the computer what to do
<2> :P
<3> groogs: (s)he already stated them. next to u for example
<3> that and to ignore spaces
<1> what next to u?
<3> SELECT fld1, fld2, fld3, replace(fld3, ' ', '') as sfld FROM mytable ORDER BY sfld COLLATE latin1_german1_ci
<3> give that a shot design_chick
<3> groogs: u-umlaut
<3> the u with two dots above it
<1> oh
<1> ok, so ORDER BY UCASE(REPLACE(sfld, ' ', '')) COLLATE whatever
<2> if i add 'COLLATE latin1_german1_ci' to my query i just get a mysql error - any ideas - how should the syntax look because i copied it off that site and it aint working
<1> what version of mysql?
<2> MySQL 4.0.17
<1> whats the error?
<1> and query
<1> the other way to do it that would make selects a lot faster is to add another field called like, name_sort and index it
<1> and always set name_sort to be the value of name, minus spaces, uppercased, and with all the weird u o etc characters converted to just u and o
<1> but it's error prone, as if you edit data outside of your app, the fields might not match
<1> if you were using 5.x you could do it with triggers
<2> yeah entries are going to be added and deleted by third party so that is not suitable
<2> $query_Recordset1 = sprintf("SELECT id, alpha, `First Name`, `Last Name`, SC, `Phone Number`, Chambers FROM members WHERE alpha = '%s' ORDER BY `Last Name` COLLATE latin1_german2_ci", $colname_Recordset1);
<2> and here is the error: http://www.capebar.co.za/members/browse/browse.php?alpha=m
<4> damn... just made more changes to my requirements document. it's up to 10 pages now.
<2> it's got to be to do with collation
<2> here is supposedly i guide, but i can't get it to work
<2> here is my SQL query
<2> http://pastebin.com/556703
<5> jesus christ i hate installing gentoo
<5> now i cant get my frigging network configged
<6> gentoo is easy
<5> ubuntu couldnt auto configure it last night ont his machine either
<5> debian's net install did fine though
<5> ;/
<6> wtf do you need 3 distros for
<5> easy??? this is my 4th attempt at it and this time i cant even get my network configured!
<5> ;/
<3> design_chick: what version of mysql?
<5> i dont
<5> i gave up on each of them
<2> MySQL 4.0.17
<6> why are you giving up? you just need to learn how to use them
<5> debian was goin good but it was raping my connection, it being satelite and all
<5> and ubuntu couldnt auto configure the network plus i have ubuntu on 2 machines allready and wanted something different.
<5> so now im 'attempting' gentoo again but it doesnt seem to be going well.
<6> what can you not figure out with gentoo?
<0> **** gentoo
<0> debian or suse!
<5> i would prefer debian
<5> <333 aptitude
<2> aaaaaaaaaaaaa
<2> help?
<5> imma order the dvd set tomorrow so i dont have to spend week downloading it
<5> at 168mn every 4 hours
<5> pfft
<6> does satellite really **** that bad?
<0> heh. if i wanted to download linux, i'd do it at work
<3> no idea design_chick
<5> mb*
<0> i downloaded openoffice and java sdk in 1 minute total
<5> follower: yea, i can only download 168mb every 4 hours and then i get dialup speed
<0> which is like 300mb
<5> evulish: download and burn me the debian dvd's then
<6> that ****s
<0> $50.
<5> i can order for less than 5
<5> lol
<5> but i gotta wait until tomorrow
<5> ;/
<3> it seems collate should work, even for that version. but in either case, i'd suggest upgrading your mysql anyway
<1> ansimation: do you do any ssh over satellite?
<5> gentoo looks nice but i can never ****ing get it to work for me
<5> i dont know why
<5> ;/
<5> groogs: yea
<6> dude, just tell me what you cant figure out in gentoo and ill tell you how to make it work
<1> ansimation: how's it work? two-way satellite or the dialup hybrid kind (do they still have that?) ?
<5> 2 way
<5> follower: configuring eth0 to reach my network for starters.
<6> edit /etc/conf.d/net
<5> so i can ssh and work from this box and let wigga have his monitor, mouse, and keyboard back
<5> ;/
<0> does your network card work?
<5> ya
<5> ill try eth1, hold up
<6> i thought the install instructions were pretty damn details myself
<6> detailed
<0> how does your network ***ign ip addresses?
<0> dhcp?
<5> yea
<0> install dhcpcd
<0> done!
<5> but they change frequently. 1 minute wiggas box will be .103 and the next it'll be .101
<5> not too frequently but it seems like atleast oce or twice a day
<0> you know what ****s about firefox
<1> ansimation: what ***igns the address?
<7> take sup too much resources
<0> their search doesn't search in textareas
<1> sounds like two DHCP servers
<5> too few arguments
<8> does php4isapi.dll *have* to be in c:\winnt ?
<8> installing w/ IIS 5
<5> groogs: truthfully, i dont know. i just plugged in my router and went from there.
<1> ansimation: anything else on the net that might have dhcp?
<6> i bet hell never figure it out with 3 different people telling him different things
<5> heh
<8> anyone ever installed php on iis?
<5> just my one router + 3 pc's and a 1u server
<8> does the unix server have dhcp running?
<5> the server is the one im workin on
<8> ah
<5> hrmm, i put the debian net install cd back in and it cant auto configure the network either
<5> it worked fine last night
<5> wtf...
<1> check your router, usually theres a way to view dhcp tables
<1> sounds weird though
<5> sad part is the 2 eth's are onboard
<5> mother ****er
<5> grr
<5> wtf
<5> i use wiggas network cable and it works
<5> dammit
<9> hi, how do i read a linefrom a file? i read that fread gets n bytes from the file... how do i read line per line? im trying to copy a log to a mysql database, so id like to read each line, split it and insert the fields in a table
<0> @file
<10> (PHP 3, PHP 4, PHP 5)
<10> array file ( string filename [, int use_include_path [, resource context]] )
<10> Reads entire file into an array
<10> http://www.php.net/file
<0> or just use mysql's LOAD INFILE feature
<9> mod_spox: a 50 Mb file into an array could be ram killer
<0> how often do you plan on running it?
<9> once a day
<9> evulish, im testing load infile... which line delimiter you think i should use? \n? \r? its a maillog file
<0> uh
<0> depends on what delimiter is there
Return to
#php
or
Go to some related
logs:
#allnitecafe
#kl
linux cdrw finalize
#allnitecafe
#india
dalnet baklava
#chat-world
#india
#chat-world
dazzal dunia
|
|