Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Difficulty in reading LONG-, MEDIUM- and TINYTEXT data types
Hi I´m having difficulty in getting a recordset to read NULL values from MySQL´s LONG-, MEDIUM- and TINYTEXT data types. All other data types seems to work but these throws an '80020009' error. Strange thing is, that when I run the same code on another machine, it works fine. Both computers are... -
FLOAT problem
Thanks for your reply! I´m sorry about the confusion, I did not write the complete code. I use it because i call several tables with identical column names. Like this.... myTable1.myValue AS myVal1 , myTable2.myValue AS myVal2 -
FLOAT problem
Hi! I´m running ASP and MySQL where I´m using the datatype FLOAT. When I submit a value, for example myValue=’50.5’ it works fine and when I check the value in the database it is 50.5 But then, when I try to print this on a .asp page - using SELECT myValue AS nVal – RS(“nVal”) I get the... -
constraint in mySQL
Hi Isn´t this constraints working in mySQL? query = "CREATE TABLE Employee ("; query += " EmployeeID INT AUTO_INCREMENT PRIMARY KEY "; query += " , CivicNr CHAR(11) UNIQUE NOT NULL "; query += " , Name VARCHAR(50) NOT NULL "; query +=...
