Re: [PHP-DB] Fwd: Fw: alert..alert..alert.. DANGEROUS VIRUS......
Addressed to: "deepak s" <[EMAIL PROTECTED]> [EMAIL PROTECTED] ** Reply to note from "deepak s" <[EMAIL PROTECTED]> Sat, 13 Jan 2001 04:41:54 - > A new virus has just been discovered that has been classified by >Microsoft ( www.microsoft.com ) and by McAfee (www.mcafee.com) > as the You should check your sources before you post such messages to the mailing list. (or anyone else for that matter.) I did. There is no mention of this on the CNN web site listed in the message. I would expect it to be home page news, but I also did a search on 'computer virus'. The latest entry was January 3. Same for Microsoft. I tried to look at the McAfee site, but they won't let you hit the site without Javascript enabled, and I don't care to view their site that bad. The Symantec web site (Norton Anti-Virus) shows no new virus discoveries since November 2000. (http://www.symantec.com/avcenter/) Unless you can show some actual links to stories about this new virus I'm going to have to file it under Hoax. The key words are "Please email this to all your friends." I've still never seen this in ANY message that deserved to be forwarded to _anyone_ at all. Do you realy think slipping an email to a few friends and asking them to forward it would be the best way to publish this information if it was real? Rick Widmer Internet Marketing Specialists http://www.developersdesk.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Fwd: Fw: alert..alert..alert.. DANGEROUS VIRUS......
Addressed to: "deepak s" <[EMAIL PROTECTED]> [EMAIL PROTECTED] ** Reply to note from "deepak s" <[EMAIL PROTECTED]> Sat, 13 Jan 2001 04:41:54 - > A new virus has just been discovered that has been > classified by Microsoft ( www.microsoft.com ) and by McAfee > (www.mcafee.com) as the... Rick Widmer Internet Marketing Specialists http://www.developersdesk.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Fwd: Fw: alert..alert..alert.. DANGEROUS VIRUS......
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Friday, January 12, 2001 5:29 PM Subject: alert..alert..alert.. DANGEROUS VIRUS.. > >Dear esteemed customer, > > A new virus has just been discovered that has been classified by >Microsoft ( www.microsoft.com ) and by McAfee (www.mcafee.com) as the most >destructive ever! This virus was discovered yesterday afternoon by McAfee and >no vaccine has yet been developed. This virus simply destroys sector Zero from >the hard disk, where vital information for its functioning are stored. This >virus acts in the following manner: It sends itself automatically to all >contacts on your list with the title "A Virtual Card for You". As soon as the >supposed virtual card is opened,the computer freezes so that the user has to >reboot. When the ctrl+alt+del keys or the reset button are pressed, the virus >destroys Sector Zero, thus permanently destroying the hard disk. Yesterday in >just a few hours this virus caused panic in New York, according to news >broadcast by CNN (www.cnn.com). This alert was received by an employee of >Microsoft itself. So don't open any mails with subject "A Virtual Card for >You". As soon as you get the mail, delete it. Please pass on this mail to all >your friends. > > > >Regards > >Helpdesk, >Internet Division >Goa Telecom. >Telephone Exchange >Altinho,Panaji. >--- >Telephone bills can be paid in any branch of Syndicate Bank in Goa , across the >counter. >--- - >HDFC BANK account holders can pay their bills through Internet/ATM/Phone banking > Facility >--- - >Email : [EMAIL PROTECTED] >Tel.no : 1600338333,0832-23,43 >Fax: 0832-229922. >--- - > Bharat Sanchar Nigam Limited >--- -- > _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: [PHP] Re: [PHP-DB] Easy MySQL question
At 10:10 AM -0500 1/12/01, Leonard T. Harris wrote: >What's wrong with > >$number=mysql_num_rows($result); >echo "The total number of rows is $number"; Primarily that mysql_num_rows() tells you how many rows are in the result set, which for the query in question, is 1. The *content* of that row is how many rows are in the table. > > >- Original Message - >From: Julie Meloni <[EMAIL PROTECTED]> >To: Paulson, Joseph V. "Jay" <[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Thursday, January 11, 2001 11:17 AM >Subject: [PHP] Re: [PHP-DB] Easy MySQL question > > >> Paulson, Joseph V. \"Jay\" wrote: >> >> > Hello everyone-- >> > I've got a easy question that I can't seem to answer for myself. I'm >> > running a query in MySQL and want to know how many entries are in a >table >> > and then echo that out onto a page. I thought this would be easy but I >> > don't know why it's not working. Anyway, here's what I am doing: >> > >> > (open db connection) >> > >> > $query = "SELECT count(*) FROM Movie"; >> > $result = mysql_query($sql, $dbLink); >> > $myrow = mysql_result($result); >> > echo $myrow; >> > >> > > $myrow = mysql_result($result,0,"count(*)"); -- Paul DuBois, [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] backdoor in InterBase
* Borland Interbase Server Contains Backdoor Account http://www.windowsitsecurity.com/articles/index.cfm?articleID=16566 fixes for Windows, Linux, Solaris, HP-UX and SCO available at http://www.borland.com/interbase/downloads/patches.html Cynic: A member of a group of ancient Greek philosophers who taught that virtue constitutes happiness and that self control is the essential part of virtue. [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Problem with oci8
Hi Mateus, this is not really true. As you mentioned libclntsh is linked with pthread and so must be apache. first, add the oracle lib path to ld.so.conf and run ldconfig. now try the following for apache: LDFLAGS=-lpthread ./configure \ --prefix=/usr/local/apache \ --enable-module=so and for php4: ./configure \ --with-apxs=/usr/local/apachebin/apxs \ --with-oci8 \ --with-pthread with any additional options. furthermore it can be necessary to export some of the following environment vars in your apachectl: ORACLE_HOME ORA_NLS33 LD_PRELOAD (for libclnsh) refer to http://www.php.net/manual/ref.oci8.php or ask me if you like --Victor > Hi, > > I'm trying to run php4 with support to oci8 (Oracle 8.1.6 - Linux) and >apache aborts. > > I read in the FAQ that if MySql libs are linked with pthread, pthread >should be removed from mysql libs to apache get started. > > The lib clntsh (from Oracle) is also linked with pthreads, but, of course, >is not possible, at least for me, to recompile Oracle. > > Suggestions? > > Thanks for your help. > >Mateus Cordeiro Inssa >- >Linux User: 76186 Kernel: 2.2.17-14cl >ICQ (Licq): 15243895 >- >[EMAIL PROTECTED] >[EMAIL PROTECTED] > >Tue Jan 2 20:23:27 EST 2001 > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Username/Password retrieval
Is the following statement the best way to handle a username/password validation $username and $password are form fields $result=""; $result= mysql_query (" Select password from ACCT_TBLE where (ACCT_NUM = '$username' and PASSWORD='$password')"); Now my question is will result be equal to "" if the query statement doesn't return any data? thanks randy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] sybase_get_last_message() patch for Sybase CT
Hello. sybase module exports a handy function called sybase_get_last_message(). we used to use it. but then we had to switch to sybase_ct module and it doesn't have it. the attached patch should fix it. please consider adding it. Jan -- Jan Fedaktalk:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Linux - the ultimate NT Service Pack. diff -uNr php-4.0.3pl1/ext/sybase_ct/php_sybase_ct.c php-4.0.3pl1-patched/ext/sybase_ct/php_sybase_ct.c --- php-4.0.3pl1/ext/sybase_ct/php_sybase_ct.c Fri Jan 5 12:18:26 2001 +++ php-4.0.3pl1-patched/ext/sybase_ct/php_sybase_ct.c Fri Jan 5 12:15:20 2001 @@ -39,6 +39,7 @@ PHP_FE(sybase_select_db,NULL) PHP_FE(sybase_query,NULL) PHP_FE(sybase_free_result, NULL) + PHP_FE(sybase_get_last_message, NULL) PHP_FE(sybase_num_rows, NULL) PHP_FE(sybase_num_fields, NULL) PHP_FE(sybase_fetch_row,NULL) @@ -57,6 +58,7 @@ PHP_FALIAS(mssql_select_db, sybase_select_db, NULL) PHP_FALIAS(mssql_query, sybase_query, NULL) PHP_FALIAS(mssql_free_result, sybase_free_result, NULL) + PHP_FALIAS(mssql_get_last_message, sybase_get_last_message,NULL) PHP_FALIAS(mssql_num_rows, sybase_num_rows, NULL) PHP_FALIAS(mssql_num_fields,sybase_num_fields, NULL) PHP_FALIAS(mssql_fetch_row, sybase_fetch_row, NULL) @@ -194,6 +196,9 @@ if (CS_SEVERITY(errmsg->msgnumber) >= SybCtG(min_client_severity)) { php_error(E_WARNING, "Sybase: Client message: %s (severity %d)", errmsg->msgstring, CS_SEVERITY(errmsg->msgnumber)); } + STR_FREE(SybCtG(server_message)); + SybCtG(server_message) = estrdup(errmsg->msgstring); + /* If this is a timeout message, return CS_FAIL to cancel the * operation and mark the connection as dead. @@ -218,6 +223,8 @@ php_error(E_WARNING, "Sybase: Server message: %s (severity %d, procedure %s)", srvmsg->text, srvmsg->severity, ((srvmsg->proclen>0) ? srvmsg->proc : "N/A")); } + STR_FREE(SybCtG(server_message)); + SybCtG(server_message) = estrdup(srvmsg->text); /* If this is a deadlock message, set the connection's deadlock flag * so we will retry the request. Sorry about the bare constant here, @@ -338,7 +345,7 @@ SybCtG(default_link)=-1; SybCtG(num_links) = SybCtG(num_persistent); SybCtG(appname) = estrndup("PHP 4.0", 7); - SybCtG(server_message) = NULL; + SybCtG(server_message) = empty_string; return SUCCESS; } @@ -360,9 +367,7 @@ SybCtLS_FETCH(); efree(SybCtG(appname)); - if (SybCtG(server_message)) { - efree(SybCtG(server_message)); - } + STR_FREE(SybCtG(server_message)); return SUCCESS; } @@ -1221,6 +1226,16 @@ RETURN_TRUE; } +/* }}} */ + +/* {{{ proto string sybase_get_last_message(void) + Returns the last message from server (over min_message_severity) */ +PHP_FUNCTION(sybase_get_last_message) +{ + SybCtLS_FETCH(); + + RETURN_STRING(SybCtG(server_message),1); +} /* }}} */ /* {{{ proto int sybase_num_rows(int result) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Date Control Problem
Try SELECT * from Test where due_date >= now(); -Jim - Original Message - From: "Ian" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 11, 2001 8:59 PM Subject: [PHP-DB] Date Control Problem > Dear Sir / Madam, > > Case 1: > My database, > Table name -> Test. > Field name -> due_date. > > Let say, > due_date = 2001-01-01. > > Now, I would like to display all data from Test table where my due_date is > before the current date. I tried the below SQL statement but it didn't work, > SELECT * from Test where due_date >= curdate(); > My display result should be zero. > Any good solutions or suggestions for Case 1? > > > Case 2: > My database, > Table name -> Test. > Fields name -> posting_date, and expired_day. > > Let say, > posting_date = 2000-12-20 > expired_days = 14 days > > So my due date is 2001-01-02(from my own calculation). Same as case 1, I > would like to display all data from Test table where expired_day plus > posting_date is before the current date. > My display result should be zero. > Any good solutions or suggestions for Case 2? > > Thanks in advance. > > > Best Regards, > Ian. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: AW: [PHP-DB] "delete" working erratically on ODBC
On 12 Jan 2001, at 16:43, Michael Rudel wrote: > try to COMMIT after your first DELETE and then start the Second one and so > on. > > Hope 'tll work. > Hi Mike... Yes, I've tried, same result. If I put the two delete in two different transaction block the second delete is still ignored. If I put a commit in the middle without opening a transaction block it complains an error, and I think this is correct behaviour. Thanks, Lebe wohl! /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ Fabrizio Ermini Alternate E-mail: C.so Umberto, 7 [EMAIL PROTECTED] loc. Meleto Valdarno Mail on GSM: (keep it short!) 52020 Cavriglia (AR) [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
AW: [PHP-DB] "delete" working erratically on ODBC
Ciao Fabrizio, try to COMMIT after your first DELETE and then start the Second one and so on. Hope 'tll work. Greetinx, Mike (Germany) -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 12. Januar 2001 16:39 An: [EMAIL PROTECTED] Betreff: [PHP-DB] "delete" working erratically on ODBC Hi All! I've a encountered a baffling problem in one project of mine. It's a data entry application build to work as a "stand-alone" app - it's all on a PC, built on Win98, PWS, PHP 4.0.3, and access 2000 as DB, accessed (pun not intended!) thru ODBC. I wished to delete all rows from a couple of tables, to start filling them anew. So I issued the following commands: [...] if (!isset($conn)) { $statusOpen=DB_Open(&$conn,$dbName); } if(!$statusOpen) die ("error in DB ".$dbName); $ji=odbc_exec($conn,"DELETE FROM table1"); echo "->$ji<-"; $ji=odbc_exec($conn,"DELETE FROM table2"); echo "->$ji<-"; [...] The two "echo"s are for debug purposes, obviously. Actually, no error condition is returned. On screen I see that both echo print a valid result ID. But the second DELETE is NOT executed! All rows all still there, after the execution. If I change the order of the query, i.e. [...] $ji=odbc_exec($conn,"DELETE FROM table2"); echo "->$ji<-"; $ji=odbc_exec($conn,"DELETE FROM table1"); echo "->$ji<-"; [...] Data in table2 are deleted, and data in table1 are still there! Even If I put some other query in the middle, it appears that only the first "DELETE" is really executed, while the other is silently ignored. Somebody has a clue on what's happening??? TIA, bye! /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ Fabrizio Ermini Alternate E-mail: C.so Umberto, 7 [EMAIL PROTECTED] loc. Meleto Valdarno Mail on GSM: (keep it short!) 52020 Cavriglia (AR) [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] "delete" working erratically on ODBC
Hi All! I've a encountered a baffling problem in one project of mine. It's a data entry application build to work as a "stand-alone" app - it's all on a PC, built on Win98, PWS, PHP 4.0.3, and access 2000 as DB, accessed (pun not intended!) thru ODBC. I wished to delete all rows from a couple of tables, to start filling them anew. So I issued the following commands: [...] if (!isset($conn)) { $statusOpen=DB_Open(&$conn,$dbName); } if(!$statusOpen) die ("error in DB ".$dbName); $ji=odbc_exec($conn,"DELETE FROM table1"); echo "->$ji<-"; $ji=odbc_exec($conn,"DELETE FROM table2"); echo "->$ji<-"; [...] The two "echo"s are for debug purposes, obviously. Actually, no error condition is returned. On screen I see that both echo print a valid result ID. But the second DELETE is NOT executed! All rows all still there, after the execution. If I change the order of the query, i.e. [...] $ji=odbc_exec($conn,"DELETE FROM table2"); echo "->$ji<-"; $ji=odbc_exec($conn,"DELETE FROM table1"); echo "->$ji<-"; [...] Data in table2 are deleted, and data in table1 are still there! Even If I put some other query in the middle, it appears that only the first "DELETE" is really executed, while the other is silently ignored. Somebody has a clue on what's happening??? TIA, bye! /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ Fabrizio Ermini Alternate E-mail: C.so Umberto, 7 [EMAIL PROTECTED] loc. Meleto Valdarno Mail on GSM: (keep it short!) 52020 Cavriglia (AR) [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Problem with LONG TEXT fields (ODBC-MS SQL 7)
"Sanders, Nicholas" wrote: > php.ini needs to be in c:\winnt > it is there. Johny. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Problem with LONG TEXT fields (ODBC-MS SQL 7)
php.ini needs to be in c:\winnt -Original Message- From: Jonathan Kazmierczak [mailto:[EMAIL PROTECTED]] Sent: 12 January 2001 15:18 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Problem with LONG TEXT fields (ODBC-MS SQL 7) Andreas Karajannis wrote: > > I change config value uodbc.defaultrl from 4096 to 8192, but it don't > > give any effect. > > Please make shure that PHP really "sees" your change. > You can verify the value that PHP uses by writing a file with just a call to > phpinfo(), this prints out a page with the current configuration. Thanx for your sugestion! I call this function and this shows, that any changes of php.ini file doesn't give any effect! I don't know, why. I've php.ini in my system directory and php4isapi engine in php directory on other drive. I don't understand it. Johny. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Problem with LONG TEXT fields (ODBC-MS SQL 7)
Andreas Karajannis wrote: > > I change config value uodbc.defaultrl from 4096 to 8192, but it don't > > give any effect. > > Please make shure that PHP really "sees" your change. > You can verify the value that PHP uses by writing a file with just a call to > phpinfo(), this prints out a page with the current configuration. Thanx for your sugestion! I call this function and this shows, that any changes of php.ini file doesn't give any effect! I don't know, why. I've php.ini in my system directory and php4isapi engine in php directory on other drive. I don't understand it. Johny. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: [PHP] Re: [PHP-DB] Easy MySQL question
What's wrong with $number=mysql_num_rows($result); echo "The total number of rows is $number"; - Original Message - From: Julie Meloni <[EMAIL PROTECTED]> To: Paulson, Joseph V. "Jay" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 11, 2001 11:17 AM Subject: [PHP] Re: [PHP-DB] Easy MySQL question > Paulson, Joseph V. \"Jay\" wrote: > > > Hello everyone-- > > I've got a easy question that I can't seem to answer for myself. I'm > > running a query in MySQL and want to know how many entries are in a table > > and then echo that out onto a page. I thought this would be easy but I > > don't know why it's not working. Anyway, here's what I am doing: > > > > (open db connection) > > > > $query = "SELECT count(*) FROM Movie"; > > $result = mysql_query($sql, $dbLink); > > $myrow = mysql_result($result); > > echo $myrow; > > > > $myrow = mysql_result($result,0,"count(*)"); > > > > -- > ++ > | Julie Meloni ([EMAIL PROTECTED]) | > | Tech. Director, i2i Interactive (www.i2ii.com) | > || > | "PHP Essentials" & "PHP Fast & Easy" | > |http://www.thickbook.com/ | > ++ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Problem with LONG TEXT fields (ODBC-MS SQL 7)
> I have one row, in which long text field takes about 5100 bytes. PHP > can't print page with this text, but don't give me any error messages > (other texts, < 4096, are printed correctly). Printing this row work > correctly in ASP. > I change config value uodbc.defaultrl from 4096 to 8192, but it don't > give any effect. > Please make shure that PHP really "sees" your change. You can verify the value that PHP uses by writing a file with just a call to phpinfo(), this prints out a page with the current configuration. -Andreas -- Andreas Karajannis mediaworx berlin AG Fon (0 30) 2 75 80 - 266 Fax (0 30) 2 75 80 - 200 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Problem with LONG TEXT fields (ODBC-MS SQL 7)
Hi! I've problem with print long texts. I have DB on MS SQL 7 and I use ODBC to connect with DB. I have one row, in which long text field takes about 5100 bytes. PHP can't print page with this text, but don't give me any error messages (other texts, < 4096, are printed correctly). Printing this row work correctly in ASP. I change config value uodbc.defaultrl from 4096 to 8192, but it don't give any effect. What have I to do for correct printing this field ? Johny. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Query Access DB by date
Oops. Seems to work when I put the pound sign in the front and back of the date :-) Thanks. John > >When I try to query an Acess database for a particular date I get ODBC > >errors indicating I'm screwing up the call. Can anyone give me an example of > >a select on a date field. Quotes make it think it is a string. No quotes > >make it think it is a number. The pound sign just says it doesn't know what > >I'm asking for. I'm confused. Thanks. > > The pound sign is correct. If your query doesn't work with the pound > sign, then the problem is elsewhere. Post an example of your code. > > Bob Hall > > Know thyself? Absurd direction! > Bubbles bear no introspection. -Khushhal Khan Khatak > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Text Control.
Ian wrote: > Dear Sir / Madam, > > Problem :- > Data from HTML WRAP="virtual"> is likes, > This is a testing messages:- > 1. MSG A. > 2. MSG B. > 3. MSG C. > > So, I insert $test into MYSQL database. After that, I login into MYSQL and > select the test field, the display is same as above. But, when I used PHP > coding to select the test field and display it in HTML page, output likes, > This is a testing messages:- 1. MSG A. 2. MSG B. 3. MSG C. > > How to display $test in the requested format? > > Thanks in advance. > > Best Regards, > Ian. > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] You could try using the nl2br function, thus converting all newline characters to tags. http://uk.php.net/manual/function.nl2br.php -- Simon Pospisil Mail: [EMAIL PROTECTED] Web EngineerWeb: http://www.fastsearch.com/ Fast Web Media Ltd. Phone: +44 (0) 161 835 3444 Suite 1202, Sunlight House Quay Street Fax: +44 (0) 161 835 3488 Manchester, England M3 3JZ Try FAST Search: http://www.alltheweb.com
Re: [PHP-DB] Text Control.
Hi Ian, Have you tried to use the nl2br-function, which converts (OS) newline breaks, to HTML-tags? You can find an exact description in the php doc. Bye, Jochen -Original Message- From: "Ian" <[EMAIL PROTECTED]> Date: Fri, 12 Jan 2001 13:53:02 +0800 Subject: [PHP-DB] Text Control. > Dear Sir / Madam, > > Problem :- > Data from HTML WRAP="virtual"> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]