iansilv
Jun 9, 2009, 11:19 PM
Hey At&t-
I heard you were having some problems with the opt out codes in the database for everyone's account who has an iPhone to use MMS- ok here is what you can do to fix it:
In your account database, there is a table somewhere with the code in a field for Opt out. If you are using SQL manager just double click on the database name, and click the little plus "+" sign to expand all the table names. It's probably like "TXTACCOUNTTYPES" or something. All you gotta do is have one of your programmers write a sql script to go in to that table and for all the users with iphones and have it DELETE the opt out code in that field. Its a process kinda like a nuclear-powered find / replace in excel but with the replacing being done with blank space.
One of your IT guys can probably do this- he can login from anywhere. If you can't find anyone in your IT dept., try elance.com- I bet you could have some guys out of India or Malaysia that could write it up for like 50 bucks. Put it up for bid- seriously- dude like 2 hours your have 50 people that cna do the job.
But hurry! I gotta buttload of baby pics I want to mms to some friends.
Anyway, send me a PM if you run in to problems. Or you can google "Find Replace data fields in SQL" or something- the info is out there.
L8 ATT.
I heard you were having some problems with the opt out codes in the database for everyone's account who has an iPhone to use MMS- ok here is what you can do to fix it:
In your account database, there is a table somewhere with the code in a field for Opt out. If you are using SQL manager just double click on the database name, and click the little plus "+" sign to expand all the table names. It's probably like "TXTACCOUNTTYPES" or something. All you gotta do is have one of your programmers write a sql script to go in to that table and for all the users with iphones and have it DELETE the opt out code in that field. Its a process kinda like a nuclear-powered find / replace in excel but with the replacing being done with blank space.
One of your IT guys can probably do this- he can login from anywhere. If you can't find anyone in your IT dept., try elance.com- I bet you could have some guys out of India or Malaysia that could write it up for like 50 bucks. Put it up for bid- seriously- dude like 2 hours your have 50 people that cna do the job.
But hurry! I gotta buttload of baby pics I want to mms to some friends.
Anyway, send me a PM if you run in to problems. Or you can google "Find Replace data fields in SQL" or something- the info is out there.
L8 ATT.
