Re: [PHP-DB] Conection to MS SQL 2000 from PHP in Linux
Few options.. compile using sybase-ct libraries.. or use something like freeTDS, or install odbc support.. I'd look at using freetds first.. On Thu, 7 Aug 2003, Jean Fernando Ortiz wrote: > Hi all! > I need to know how I must connect to MS SQL Server 2000 in a Win 2000 Server > from my Internet Server with Linux, PHP 4.0.4 + Apache 1.3.19. > > Thanks for your help. > > -- > > PEM Jean Fernando Ortiz Arana > Coordinador de TI > Centro Escolar El Roble > APDE - Guatemala > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Sorting issue
Seeing code might help us. Aaron > -Original Message- > From: Jeff [mailto:[EMAIL PROTECTED] > Sent: August 8, 2003 10:44 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Sorting issue > > Why would a mysql db think that 55 was greater than 14000. > > I have several headings that display sql data under them, when you click > on > the heading, it sorts that section (descending/ascending), but it only > seems > to be looking at the first two numbers in the one heading. Is there a > command that forces it to look at the entire record before sorting it? > > Thanks > Jeff > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Sorting issue
Why would a mysql db think that 55 was greater than 14000. I have several headings that display sql data under them, when you click on the heading, it sorts that section (descending/ascending), but it only seems to be looking at the first two numbers in the one heading. Is there a command that forces it to look at the entire record before sorting it? Thanks Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Sorting issue
kwo isn't sorting properly... actually, I need to retest the lsd column too. "John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Jeff wrote: > > >$query = "SELECT kwo, lsd, date, event FROM $gradient_tablename > > $order_by_str $sort_order_str $limit_str"; > > So what column is not sorting correctly? Is the column a INTEGER-type > column or a CHARACTER-type column... > > Again: > "55" > "14000" > 55 < 14000 > > -- > ---John Holmes... > > Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ > > PHP|Architect: A magazine for PHP Professionals www.phparch.com > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Sorting issue
Seems like changing the mixed fields back to VARCHAR worked! Thanks again guys! "David T-G" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Conection to MS SQL 2000 from PHP in Linux
Try reading this on PHP site, documentation here is pretty useful. http://us4.php.net/manual/en/ref.mssql.php Suerte. == "Jean Fernando Ortiz" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi all! > I need to know how I must connect to MS SQL Server 2000 in a Win 2000 Server > from my Internet Server with Linux, PHP 4.0.4 + Apache 1.3.19. > > Thanks for your help. > > -- > > PEM Jean Fernando Ortiz Arana > Coordinador de TI > Centro Escolar El Roble > APDE - Guatemala > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: newbie lost on data import... part 2
jsWalter wrote: This SQL is generated by my script... INSERT INTO cbs_eps ( eps_id , eps_name , eps_num , eps_air_date ) VALUES ( '5','No Hiding Place','5','1974-01-10'); 'eps_id' is generated from the index ($x) of the array loop the others are retrieved from the tab delimted text file When run from the script, the only thing going in is the epd_id! :( All others are either ZERO or empty (defaults) What kind of columns are you inserting these values into? Are you _sure_ this is the query that's being run by your program, i.e. are you printing it out from within your program and not _assuming_ this is the query? -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ PHP|Architect: A magazine for PHP Professionals – www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: newbie lost on data import... part 3
"John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > jsWalter wrote: > > // Spit it out to double check what I've got > > echo '>' . $strDate . '< - >' . $strNum . '< - >' . $strName . '< '; > > So does this echo display anything? It spits out... >1974-01-09< - >4< - >Lost Dog< Just what it is supposed to spit out. > What does the Date class do? A class to ease database work... http://pear.php.net/manual/en/package.database.db.intro-auto.php BTW: A straight SQL call gives the same (lack of) results as well... $strSql = 'INSERT INTO cbs_eps ( eps_id , eps_name , eps_num , eps_air_date ) '; $strSql .= "VALUES ( "; $strSql .= "'" . $x . "'"; // eps_id $strSql .= ",'" . $strName . "'"; // eps_name $strSql .= ",'" . $strNum. "'"; // eps_num $strSql .= ",'" . $strDate . "'"; // eps_air_date $strSql .= ");"; echo $strSql . ''; $objResult = $db->query($strSql); And the SQL generated... INSERT INTO cbs_eps ( eps_id , eps_name , eps_num , eps_air_date ) VALUES ( '4','Lost Dog','102','1974-01-09'); Now, if I paste this into phpmyAdmin it works! :( Walter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php