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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
INT MS MYSQL DataTypes
I'm trying to get a grasp on mysql data types. have this number 1234567.8900 What do i set mysql column too in order to store this number. Using INT(11) this number is stored as 1.23456e+06 and is pulled out in my script as 1234570.00 thanks in advance! D2G -
Replace 4 Linksys Home Routers with Cisco?
We currently have 4 linksys home routers running, I would like to know what would be the best solution for upgrading these to a single rack mount solution? Here is more network information. each router is assigned its own static ip address. Router 1 connects to a single 24 port switch via 1... -
Whats the largest AutoNumber Type?
I need to know what to assign my autonumber column in my table. I need a datatype that can count to an almost unlimited amount.. In mysql what is the data type i should use for this autonumber field? And what will be its maximum limit. thanks! D2G -
MSSQL to Mysql COUNT() possible Index Problem
Well we are week 3 in our conversion to mysql from mssql. This one we had to rewrite the mssql version to mysql. We are having issues with a few count statments. this one works fine. and returns results right away. SELECT DISTINCT iteminformation.slotid1, iteminformation.slotid2... -
Insert Multiple Identical Rows
Is it possible to insert multiple identical rows using a single query without using a loop to build this query. for example: sqlselected = 0 Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "DSN="& websitedsn oConn.CursorLocation = 3 strSQL = "INSERT INTO testtable (testvar)... -
Determine if SQL update really updated ASP
Hello, I'm sure this is a simple one.. Ive done alot with record sets but we are rewriting some code to make it more efficient and we are replacing our old code with single SQL Update statments. In this following example how would I determine if a record was updated or not. Using ASP Set oConn... -
MSSQL -> MYSQL Method
I have an sql query that worked on MS SQL 2000.. I need to know what the mysql version needs to look like.. the MS sql query is as such: Select CARTS.CARTNUMBER, CARTS.UNITPRICE, QUANTITY = (Select SUM(numitems) from selitems where SELITEMS.CARTNUMBER = CARTS.CARTNUMBER) basicly thats an...
