| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> heh
<0> it's working right now?
<1> yoursql is, but not ruby on rails
<0> are you outputting data to the user?
<2> ok, does it say that in RoR correctly, too?
<3> Okay, I found it. Didn't know that when only one argument is returned I still have to do a fetch and then use the first argument. Thanx!
<1> yea I'm outputting data to the user
<1> I'm going to try it lowercase
<2> just issue SET NAMES utf8; as the first statement... that's what "yoursql" probably does behind the scenes anyway..
<0> yes but are you specifying the encoding as utf8 in either the content-type header or the meta tag?
<0> i'm saying the browser might be using the wrong character set.
<1> haha
<1> yea
<1> I forgot my meta tag saying utf-8
<1> thanks a lot for putting up with this
<0> that's what gets 'em
<1> haha
<2> bvernt
<4> blah
<0> that happens really often.
<1> well I've never done anything other than the default before
<1> but I think UTF-8 is very good
<1> it's what wikipedia uses
<2> Ken Thompson is my hero
<5> I'm having a problem with constructing a query, is this the rigth place to ask for a little help? (select and joining)
<2> UNIX *and* unicode. talk about genius at work.
<0> sure, if it's a long query or question pastebin it
<0> fyi if you're using apache there's an AddDefaultCharset option
<0> and AddCharset as well
<0> although it's probably smarter to control it in your code
<6> hey all... can someone help me with foreign keys, plz? working on a Ruby app... http://www.projectkir.org/ and the key doesn't seem to be working
<0> are you using innodb?
<6> nod.
<0> what does "doesn't work" mean?
<6> through phpmyadmin...
<5> I have two tables, Users and Seats, I want to get a resultset with Users.Username, Users.SeatNr, Seats.SeatNr, Users.SeatNr refers to Seats.SeatNr . I want a complete list of all SeatNr, with NULL as the value for Username where there is no record the Users that points to it, and the username as value if it does.
<0> you're sure you're using innodb?
<5> not sure it's formulatred very well
<0> :P
<5> -r
<6> gleam - nod. Table: irp_wanteds "InnoDB free: 11264kb"
<0> gurligebis, seats LEFT JOIN users on seats.seatnr=users.seatnr
<0> just making sure:)
<6> gleam - I'd say that's Innodb :-)
<6> gleam -- so I want to link the wanteds.user_id column to users.id ...
<5> okay
<6> I've created an index key for wanteds.user_id... and then I try to make the relation, I get: "No index defined! (user_id)
<5> gleam_, thanks :)
<6> even though I've made this index for field user_id : keyname=fkindex1, type=index, card=1
<0> i've never used phpmyadmin, so i'm not sure how it goes about doing things
<6> oh. what about shell? :p
<0> alter table mytable add foreign key (col) references table (col)
<6> hmm
<6> ok, I'll try
<0> although as you've noted you need the index on col
<7> is magic_quotes good enough protection against injection?
<6> so it would be alter table wanteds add foreign key user_id references users id ?
<0> php.net/mysql_real_escape_string lilkid
<8> Question. I want to order my results alphabetically, but I only want to pull the 35 results that come up the most times. I'm pulling count(t.tag_name) as matches and then doing group by t.tag_name order by matches desc limit 35, but I get groups of alphabetizing tags... like I might get the first 10 as a->z, the another group of 10 a->z kind of thing. Any ideas?
<4> !m lilkid general security
<9> lilkid: (General Security Issues) : http://dev.mysql.com/doc/mysql/en/Security.html
<0> (user_id) and (id)
<0> see if that works
<6> :-)
<7> gleam_:i tried to use that but it stops my script from working
<10> Is it possible to have a query span across schemas?
<0> yes, use the db.table.col format
<0> instead of table.col
<0> or db.table instead of table
<10> great, thanks
<10> just wanted to make sure before I shoot myself in the foot ;)
<0> hehe
<2> you still might, it'll just be a bigger caliber bullet
<2> lilkid: you should also google for "prepared statements" and avoid messing with escaping at all.
<2> lilkid: and/or bind variables
<10> thanks for the advise infi
<10> oh nice. does >=5.x do the cached execution plan?
<0> 4.1+
<6> gleam: syntax issue: "alter table irp_wanteds add foreign key user_id references irp_users.id;" ... I'm going wrong somewhere? :-)
<0> that said
<0> you need the ()
<0> (user_id) irp_users (id)
<6> ooh, duh
Return to
#mysql
or
Go to some related
logs:
dvd bad sectors linux
aim: error while loading shared libraries: libstdc++-libc6.1-1.so.2
banshee crashes on suse 10.1
lucificifus
#php
debian locales conflicts with base-config
navicat Table 'mysql.proc' doesn't exist
suse save configuration yast
#perl
#css
|
|