Archive for April, 2008
Lonak, The Logistics Portal for Turkey
After a long coding period, we have published the http://www.lonak.com ; basically it has directories for exporters, importers, logistics companies and the applications that give opportunities them to contact each other and trade. Lonak has nearly 1.000 logistics company members and approx. 25.000 exporters. I hope we will be one of the largest e-trade portals […]
Using MySQL Connection in ASP
Use the code given below to establish a successful connection to MySQL via your ASP page.
<%
Set Conn = Server.CreateObject(”ADODB.Connection”)
Conn.Open “Driver={MySQL Odbc 3.51 Driver}; Server=localhost; uid=myLogin; pwd=myPass; database=myDB; option=3; port=3306;”
Set rsmyTable = Conn.Execute(”SELECT * From myTable”)
%>
ASP’s Request Object
The Request Object receives the values that the client’s browser passed to the server during an HTTP request.
When you surf to an address that begins with HTTP, the server you’re visiting treats that as an “HTTP request”; you are in fact “requesting” that a particular web page is displayed to you. The same […]
Using Subqueries in MySQL
What is a Subquery?
A subquery is, in essence, a SELECT statement that is most often used as part of another SELECT statement, but could also be used with an INSERT, UPDATE, or DELETE and other statements. Subqueries are used in order to achieve very complex searches and complex reports, as well as for various optimizations. […]
Deleting Duplicate Records in MySQL
The command given below will check the columns written in brackets and delete duplicate records.
ALTER IGNORE TABLE mytable ADD UNIQUE KEY ( field1, field2,… ) ;
Mariami Abduselişi
Using Cookies in ASP
A web site might have had a thousand visitors, but for all the web site coordinator could know, every visit might have been made by the same visitor! Cookies were introduced as a method of identifying and marking each different visitor to a web site.
Cookies are text files written by the client browser, containing information […]
ASP Syntax Errors
Syntax errors occur wherever your script contains statements that do not follow the pre-defined rules for that language. Note that this type of error should be caught during development. JScript contains 32 syntax errors, listed below:
Number
Hexadecimal
Description
1001
800A03E9
Out of memory
1002
800A03EA
Syntax error
1003
800A03EB
Expected ‘:’
1004
800A03EC
Expected ‘;’
1005
800A03ED
Expected ‘(’
1006
800A03EE
Expected ‘)’
1007
800A03EF
Expected ‘]’
1008
800A03F0
Expected ‘{’
1009
800A03F1
Expected ‘}’
1010
800A03F2
Expected identifier
1011
800A03F3
Expected ‘=’
1012
800A03F4
Expected ‘/’
1013
800A03F5
Invalid number
1014
800A03F6
Invalid character
1015
800A03F7
Unterminated string constant
1016
800A03F8
Unterminated comment
Number
Hexadecimal
Description
1018
800A03FA
‘return’ statement […]
ASP Runtime Errors
Runtime errors occur wherever your script attempts to perform an invalid action. Note that the vast majority of these errors should be caught during the debugging and testing stage. JScript contains 76 runtime errors, listed below:
Number
Hexadecimal
Description
5
800A0005
Invalid procedure call or argument
6
800A0006
Overflow
7
800A0007
Out of memory
9
800A0009
Subscript out of range
Number
Hexadecimal
Description
10
800A000A
This array is fixed or temporarily locked
11
800A000B
Division by zero
13
800A000D
Type mismatch
14
800A000E
Out of […]
ASP Error Codes Summary
For errors that involve a failure within the ASP DLL, the following are the common error codes that are returned. These are the codes you’ll find in the ASPCode property of the ASPError object when an error of this type occurs:
Error Code
Error Message and Extended Information
ASP 0100
Out of memory. (Unable to allocate the […]