Re: Non Ascii characters

2001-10-03 Thread Doc Nielsen
hey If the text is supposed to be parsed from a mySQL to a HTML webpage, using € or € should display a € sign. A simple replace would then do the trick. Doc - Original Message - From: "Haapanen, Tom" <[EMAIL PROTECTED]> To: "Mysql@Lists. Mysql. Com" <[EMAI

Re: MySQL + VB problem

2001-08-15 Thread Doc
hey Mariusz what i usually do is like this: Set SQL1 = conn.execute("select * from tbl_blah") Set SQL2 = conn.execute("select count(*) as hops from tbl_pong where row_poof='&SQL1("blah")&'") and so forth - Doc " database sql query tab

Re: NOT DISTINCT, is this possible?

2001-08-15 Thread Doc
til Liste.EOF (basicly C!ASP) Orders = "select Count(*) as orders from O where domain=' List("domain") ' "; Regards, Doc > > > > Incredibly difficult. > > > > select foo,count(*) as cnt from da_table group by foo having cnt >1; > > &g

forgotten password() in table

2001-08-13 Thread Doc
elect User,PASSWORD(Pass) from USERS_table only seems to decrypt it even more. how i do i get mysql to decrypt it? - Doc database sql query table <-- as requested - Before posting, please check: http://www.mysql.com/