Search results for query: *

thanks ill check into the above and run some tests. thanks!

i meant 1234567.8901 above.. I need to be able to store this number in the column as is. Thanks!

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

Thanks for the info.. I'll so some hunting and see what i can come up with. thanks again!

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...

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...

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

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...

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...

Thanks for the calculations :) Gota love the numbers.. I'll prob go with integer, but i really wanted to know for future reference.. Thanks!

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.

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

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

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...

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.

I used SQLPorter from realsoftstudio (google them) to migrate my data from MS SQL 2000 to MySql. it did a great job but now we are in the process of adapting our sql queries which unfortunately don’t always work the same using ms sql and mysql. Mysql has a different syntax for a few things and...

The iteminformation table contains the description of the item, then the itemlocation table contains a row for each piece of stock for that item. If I dont use distinct the query returns a row for each piece of stock not just 1 for each item if im using the inner join. If I take out the inner...

Whoops, the correct sql that isn't working is this, forgot some info on the above (Notice the count() AS statement) SELECT DISTINCT iteminformation.slotid1, iteminformation.slotid2, iteminformation.slotid6, iteminformation.defaultpic, iteminformation.itemnumber...

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...

Wow! Thanks! I got it all figured out now.. thats the solution i was looking for! THANKS AGAIN! D2G