[PHP] Re: PHP + MSSQL Problem
Alaor Barroso wrote: It looks like PHP can't communicate with MSSQL but it connect! Strange... What server platform are you using? If you are on *nix you will need to install freetds and then build php with freetds support before you can use mssql with it. Under a windows server platform this may not be necessary, I have never tried on windows. - Ben -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: php/mssql character limit?
I posted this message the other day, and no one has responded. I'm replying to it to refresh it in the list. I guess if no one responds or helps me out this time, then I'll just forget about it and let my client go unhappy. ;-) Seriously, if anyone can help me out, I would be much appreciative. Ben Ramsey wrote: Anyone know of any kind of character limit in php or mssql (yes, Microsoft SQL Server) for entering long text into a text column (of around 4,055 characters in length--that's where it's cutting off)? -- Regards, Ben Ramsey http://benramsey.com http://www.phpcommunity.org/wiki/People/BenRamsey -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: php/mssql character limit?
are you using a 'Text' or a 'varchar' column type? I guess the max size for varchars is 4000; text should be larger vincent -Original Message- From: Ben Ramsey [mailto:[EMAIL PROTECTED] Sent: lundi 8 mars 2004 17:30 To: [EMAIL PROTECTED] Subject: [PHP] Re: php/mssql character limit? I posted this message the other day, and no one has responded. I'm replying to it to refresh it in the list. I guess if no one responds or helps me out this time, then I'll just forget about it and let my client go unhappy. ;-) Seriously, if anyone can help me out, I would be much appreciative. Ben Ramsey wrote: Anyone know of any kind of character limit in php or mssql (yes, Microsoft SQL Server) for entering long text into a text column (of around 4,055 characters in length--that's where it's cutting off)? -- Regards, Ben Ramsey http://benramsey.com http://www.phpcommunity.org/wiki/People/BenRamsey -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: php/mssql character limit?
I am using a text column type. I had always though that the max size for varchars was 255. Vincent DUPONT wrote: are you using a 'Text' or a 'varchar' column type? I guess the max size for varchars is 4000; text should be larger -- Regards, Ben Ramsey http://benramsey.com http://www.phpcommunity.org/wiki/People/BenRamsey -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: php/mssql character limit?
VARCHAR limit is 255 :) mysql.com has great documentation. Jason Vincent DUPONT [EMAIL PROTECTED] wrote: are you using a 'Text' or a 'varchar' column type? I guess the max size for varchars is 4000; text should be larger vincent -Original Message- From: Ben Ramsey [mailto:[EMAIL PROTECTED] Sent: lundi 8 mars 2004 17:30 To: [EMAIL PROTECTED] Subject: [PHP] Re: php/mssql character limit? I posted this message the other day, and no one has responded. I'm replying to it to refresh it in the list. I guess if no one responds or helps me out this time, then I'll just forget about it and let my client go unhappy. ;-) Seriously, if anyone can help me out, I would be much appreciative. Ben Ramsey wrote: Anyone know of any kind of character limit in php or mssql (yes, Microsoft SQL Server) for entering long text into a text column (of around 4,055 characters in length--that's where it's cutting off)? -- Regards, Ben Ramsey http://benramsey.com http://www.phpcommunity.org/wiki/People/BenRamsey -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: php/mssql character limit?
Is it mY SQL or MS SQL we are talking about? -Original Message- From: Jason Davidson [mailto:[EMAIL PROTECTED] Sent: lundi 8 mars 2004 17:42 To: [EMAIL PROTECTED] Subject: RE: [PHP] Re: php/mssql character limit? VARCHAR limit is 255 :) mysql.com has great documentation. Jason Vincent DUPONT [EMAIL PROTECTED] wrote: are you using a 'Text' or a 'varchar' column type? I guess the max size for varchars is 4000; text should be larger vincent -Original Message- From: Ben Ramsey [mailto:[EMAIL PROTECTED] Sent: lundi 8 mars 2004 17:30 To: [EMAIL PROTECTED] Subject: [PHP] Re: php/mssql character limit? I posted this message the other day, and no one has responded. I'm replying to it to refresh it in the list. I guess if no one responds or helps me out this time, then I'll just forget about it and let my client go unhappy. ;-) Seriously, if anyone can help me out, I would be much appreciative. Ben Ramsey wrote: Anyone know of any kind of character limit in php or mssql (yes, Microsoft SQL Server) for entering long text into a text column (of around 4,055 characters in length--that's where it's cutting off)? -- Regards, Ben Ramsey http://benramsey.com http://www.phpcommunity.org/wiki/People/BenRamsey -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: php/mssql character limit?
Coarse, i see after i post that you are talking about MSSql.. and not mysql.. i may have posted a little to quickly.. sorry. Jason Jason Davidson [EMAIL PROTECTED] wrote: VARCHAR limit is 255 :) mysql.com has great documentation. Jason Vincent DUPONT [EMAIL PROTECTED] wrote: are you using a 'Text' or a 'varchar' column type? I guess the max size for varchars is 4000; text should be larger vincent -Original Message- From: Ben Ramsey [mailto:[EMAIL PROTECTED] Sent: lundi 8 mars 2004 17:30 To: [EMAIL PROTECTED] Subject: [PHP] Re: php/mssql character limit? I posted this message the other day, and no one has responded. I'm replying to it to refresh it in the list. I guess if no one responds or helps me out this time, then I'll just forget about it and let my client go unhappy. ;-) Seriously, if anyone can help me out, I would be much appreciative. Ben Ramsey wrote: Anyone know of any kind of character limit in php or mssql (yes, Microsoft SQL Server) for entering long text into a text column (of around 4,055 characters in length--that's where it's cutting off)? -- Regards, Ben Ramsey http://benramsey.com http://www.phpcommunity.org/wiki/People/BenRamsey -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: php/mssql character limit?
Hi Ben, The setting in the php.ini is; mssql.textlimit = 4096 Reset that value to what you want. I have mine set to 400. Valid range 0 - 2147483647 alex hogan -Original Message- From: Ben Ramsey [mailto:[EMAIL PROTECTED] Sent: Monday, March 08, 2004 10:30 AM To: [EMAIL PROTECTED] Subject: [PHP] Re: php/mssql character limit? I posted this message the other day, and no one has responded. I'm replying to it to refresh it in the list. I guess if no one responds or helps me out this time, then I'll just forget about it and let my client go unhappy. ;-) Seriously, if anyone can help me out, I would be much appreciative. Ben Ramsey wrote: Anyone know of any kind of character limit in php or mssql (yes, Microsoft SQL Server) for entering long text into a text column (of around 4,055 characters in length--that's where it's cutting off)? -- Regards, Ben Ramsey http://benramsey.com http://www.phpcommunity.org/wiki/People/BenRamsey -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ** The contents of this e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. The views stated herein do not necessarily represent the view of the company. If you are not the intended recipient of this e-mail you may not copy, forward, disclose, or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please e-mail the sender. **
Re: [PHP] Re: php/mssql character limit?
That's precisely what I was looking for, Alex! I must have overlooked it when skimming through php.ini. Thanks! Alex Hogan wrote: Hi Ben, The setting in the php.ini is; mssql.textlimit = 4096 Reset that value to what you want. I have mine set to 400. Valid range 0 - 2147483647 alex hogan -- Regards, Ben Ramsey http://benramsey.com http://www.phpcommunity.org/wiki/People/BenRamsey -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: php/mssql character limit?
Ben Ramsey wrote: Anyone know of any kind of character limit in php or mssql (yes, Microsoft SQL Server) for entering long text into a text column (of around 4,055 characters in length--that's where it's cutting off)? Have a look in php.ini - IIRC there are 2 options that affect this. -- Stuart -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: PHP - mssql
I doubt msSQL differs from MySQL -- $link = mssql_connect( $host, $user, $pass ) or die( Can't connect to the DB! ); mssql_select_db( $dbname, $link ) or die( Can't select database ); $query = SELECT * FROM members WHERE user='$user' AND pass='$pass';; $result = mssql_query( $query, $link ); if(!mssql_num_rows( $result )){ die( Username/Password no good ); } else{ die( Everything is okay! ); } like i said, i think all the mysql functions in php have a mssql equiv. -- like mssql_num_rows(). -Joe Chris [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi. I have a table that contains lots of names in mssql. and i want to make a page where each of theese individuals can login with that spesific username and password. So my question is : what is the proper (best) command to use for sending and returning the info? ?PHP $link = mssql_connect($hostname,$username,$password); $dblink = mssql_select_db($dbname, $link); if ( $link $dblink ) { $query = select * from members where user = '$user' and pass = '$pass'; $result = mssql_query( $query ); if ( $result ) echo correct login; else echo wrong login; } ? This is not working... i have tried everything i can think of that can work but with no luck. So if someone have a solution for me... i would apriciate it :) (and yes i do have defined all the vars in the script they are just not that important here) -Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php