mysql and asp web hosting

dear all, i'm looking for a good service/performance for web hosting which support mysql for database and asp for web programming. would you give me some suggestions to choose the web hosting? thanks a lot cheers, Ivan Paul MySQL,

Re: Output data to file

hi... pls try this... mysql> \T c:\result.txt mysql >select name, email from messages; after command executed... you can use this command to stop print result to file. mysql> \t; mysql> have a nice try :-) Ivan Paul MySQL, Query - Original Message - From: Scott Ha

login root problem

root and user_1. should i give grant privilege to root with all privileges or not? anybody can help me? Sorry for my bad English and thanks for advance Ivan Paul - Before posting, please check: http://www.mysql.com/manual.ph

find record using MYSQL command in ASP

dear all, when i want to find some records in mysql table using ASP script language, i found an error on it. this is error message in my script: Microsoft OLE DB Provider for ODBC Drivers error '80040e29' The rowset cannot scroll backwards /find_record.asp, line 16 and this is my ASP scrip

Re: find record using MYSQL command in ASP

Beste Defrin... thank u very much my friend. it is work! :D Cheers... - Original Message - From: Defryn, Guy <[EMAIL PROTECTED]> To: 'Ivan Paul' <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 10:38 Subject: RE: find record using

problem when try to insert into mysql db using ASP

t;," &rg_no &",'SFP',current_date)" sqltxt = "select * from mmxcd" srctxt = "mmxcd_cd = '" &cd &"'" objrs.open sqltxt, objconn, apkey, aplock objrs.find srctxt if objrs

list some records combo-box in my ASP's script

null have an idea? TIA ivan paul sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROT

about set page size and set line size

hi all, is there any command in mysql prompt for set page size and set line size like SQL*Plus? TIA ivan paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

about set page size and set line size

hi all, is there any command in mysql prompt for set page size and set line size like SQL*Plus? TIA ivan paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

problem between asp and mysql in blob

uot;).ActualSize byte_f = objrs("twmknw_news").GetChunk(blob_size) '===>>> this is line 45 response.ContentType = "plain/html" response.BinaryWrite byte_f response.write "" objrs.movenext wend --- and this is also mysql table stru

problem in mysql - blob data type using asp

uot;).ActualSize byte_f = objrs("twmknw_news").GetChunk(blob_size) '===>>> this is line 45 response.ContentType = "plain/html" response.BinaryWrite byte_f response.write "" objrs.movenext wend --- and this is also mysql table stru

Re: Updating blob from command line

in set (0.00 sec) mysql> insert into tblob -> values('Test', load_file('c:/mysql/betasw.gif')); Query OK, 1 row affected (0.00 sec) mysql> select * from tblob; +---+--+ | title | pic | +---+--+ | Test | NULL | +---+--+ 1

Re: connecting to mysql via ODBC from asp.net

ml" else objrs.close objconn.execute delete_text objconn.close set objrs = nothing set objconn = nothing response.redirect "/source/city/result_city_dele_ok.html" end if cheers, Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com

Re: connecting to mysql via ODBC from asp.net

:-) Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: Jay Fields <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 27, 2002 21:35 Subject: connecting to mysql via ODBC from asp.net > I've i

Re: storing image in the db ????

toby, to store image in mysql database, i usually use blob/mediumblob/longblob data type. what do u mean for images in text? Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: toby gibbson <[EMAIL PROTECTED]> To: &

Re: storing image in the db ????

toby, to store image in mysql database, i usually use blob/mediumblob/longblob data type. what do u mean for images in text? Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: toby gibbson <[EMAIL PROTECTED]> To: &

another field type bigger then varchar

dear all, i want to change my field type from varchar(255) into varchar2(1024) --- (as i use in oracle) can i use this in mysql? anyway i don't wanna use tinyblob/mediumblob... TIA, Ivan Paul SQL, Query - Before po

Re: another field type bigger then varchar

Dear Victoria n Bruce, thanks a lot, it is work better now :-) cheers... Ivan Paul SQL, Query - Original Message - From: Bruce Lee <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 19, 2002 6:13 PM Subject: Re: another field type bigger then va