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 #128; or euro; 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 [EMAIL PROTECTED] Sent: Wednesday

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 table -- as requested I try to execute mySQL query from VB

Re: NOT DISTINCT, is this possible?

2001-08-15 Thread Doc
!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; ahh, I'd be slapping my forehead right now, except I've never used having Thanks for helping out

forgotten password() in table

2001-08-13 Thread Doc
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/manual.php (the manual) http