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!
Recent content by d2g
-
INT MS MYSQL DataTypes
thanks ill check into the above and run some tests. thanks! -
INT MS MYSQL DataTypes
i meant 1234567.8901 above.. I need to be able to store this number in the column as is. Thanks! -
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?
Thanks for the info.. I'll so some hunting and see what i can come up with. thanks again! -
Replace 4 Linksys Home Routers with Cisco?
Hmm. Well I'm all new to the cisco stuff.. I've got an extensive background in programming, web development, system design, and basic networking for small businesses.. So any additional information anyone could provide on where to obtain more information or HOW TO's let me know. I've installed a... -
Replace 4 Linksys Home Routers with Cisco?
Actually.. Rethinking the situation we could do without the diff subnets if we could accomplish the same goals. We have 4 ip address.. certain domains point to certain ip's so as long as the router routed the incoming traffic for the correct ip to the correct server the same subnet would be... -
Replace 4 Linksys Home Routers with Cisco?
Need to continue using different subnets, the servers all all in the same rack and will stay there. The routers are in the rack as well. The rack is connected directly the the internet connection.. Thanks, d2G -
Replace 4 Linksys Home Routers with Cisco?
1. there are 14 servers on the network we estimate about 300 users on at the same time eventually with options to grow. 2. Budget - Whatever it takes to do it right, with options for growth 3. Internet connection is currenly a single 1mbps dsl connection but we will be moving this entire... -
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?
Thanks for the calculations :) Gota love the numbers.. I'll prob go with integer, but i really wanted to know for future reference.. Thanks! -
Whats the largest AutoNumber Type?
Its for a web application that will have several hundred users and everytime they connect the autonumber would increase, so want to make sure the program doesn't expire. -
Whats the largest AutoNumber Type?
Ok, I have it set now to bigint, len = 11, unsigned, auto inc. Thats going to give me a total of 18446744073709551615 available? thanks in advance! D2G -
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
Ok OK, i spoke too soon.. Solved the issue i was having by avoiding the inner join all together and just using a sub query.. Let me know if there is a more efficient way of doing this, but this query worked by allowing me to show only the items that havn't been sold and have atleast 1 stock... -
MSSQL to Mysql COUNT() possible Index Problem
Also wanted to add.. i used the above queries and removed the count() with the distinct i received 328ms and without i received 31 ms.. So it seems there is a problem with combining the distinct innerjoin with the count()thats when everything seems to die.
