Learn new Get simpler Do more

[RED COLOR] #FFF7F7 #FEF8F8 #FDF9F9 #FCF9F9 #FFECEC #FCEEEE #FAF1F1 #F9F2F2 #FFCCCC #F8D2D2 #F2D9D9 #EFDCDC #FF9999 #F2A6A6 #E5B2B2 #DEB8B8 #FF6666 #EC7979 #D88C8C #CE9595 #FF3333 #E54C4C #CC6666 #BF7373 #FF0000 #DF2020 #BF4040 #AF5050 #E60000 #C91D1D #AC3939 #9D4747 #CC0000 #B21919 #993333 #8C4040 #B30000 #9C1616 #862D2D #7B3838 #990000 #861313 #722626 #682F2F #660000 #590D0D #4C1919 #451F1F #4..

In order to connect to MySQL database from ASP you need to install MySQL ODBC connector. You can download the MySQL driver from the URL below http://dev.mysql.com/downloads/connector/odbc/ 1. Use System DSN Open Data Sources(ODBC) and add System DNS Dim adoConn Set adoConn = Server.CreateObject(“ADODB.Connection”) adoConn.Open “DSN=TestODBC;Uid=UserID;Pwd=Password;” If adoConn.errors.count = 0 t..

In this article, I'll show you the fastest and easiest way to parse a string into separate columns. The best part is, this technique doesn't require any formulas. The numbers and some barcode labels were combined into a single string. [How To] 1. Select the range of data that you want to convert. 2. On the Data menu, click Text to Columns. 3. In Step 1 of the convert Text to Columns Wizard, clic..

In classic asp, it is impossible to initiate an array without specifying the size of the array. So, it has to resize array dynamically. Specially, it couldn’t expect how many size need to initiate array when you get the data from db or file. 1. Use Preserve keyword Dim arr_od_no() ReDim arr_od_no(-1) Do While objRs_01.eof = false ReDim Preserve arr_od_no(UBound(arr_od_no) + 1) arr_od_no(UBound(a..