Any SQL gurus here?

What do u need help with ? I am no guru, but i have used it :P
 
is this they new way of actually saying: hey i'm to lazy to google around, but don't want to have anyone point this out so rather say something like HELP PM me ? ;):D
 
Last edited:
lol, no he really has a problem.

basically a field isn't limited in the input characters he can put in, but it looks like the PHP reading it out is trunking it.

That was/is his problem.

Google won't fix
 
What I don't get is why people have to PM him to find out the problem :confused:

This is a public forum, post the problem and give everyone a chance to contribute, isn't that the whole point? :erm:
 
dequadin said:
What I don't get is why people have to PM him to find out the problem :confused:

This is a public forum, post the problem and give everyone a chance to contribute, isn't that the whole point? :erm:
Click to expand...

I agree, it's a bit like starting a new thread saying "Please PM me to find out what this post is about".
 
OK from the limited description i can say that i have had something similar. When a string is written to a SQL Server database with a null char in, some API calls will see the null as the termination of the string and only return everything before the null.

One way to pick this up is to do a normal select in SQL mngt studio (it will terminate after null) count the length and compare that to a len(fieldname) select (it wont terminate).
 
Thanks to all who got back to me. I found out that the issue wasn't the SQL, but rather the site's source files...
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X