Re: [PHP-DB] Text corruption when storing to MySql

2004-10-20 Thread Roger Spears
Gaby T. wrote: I am running into a problem where as I want to store test form a text field to a database (MySql in this case, sql type text). Apparently, if people are cutting and pasting text from another document (typically MS WORD) into the textfield, the text gets only partially saved. I am

Re: [PHP-DB] Text corruption when storing to MySql

2004-10-20 Thread Roger Spears
I missed a variable in my previous postshould have been this: $submitted_text = $_POST['textFromForm']; function clean_ms_word($submitted_text) { $crap =

Re: [PHP-DB] password generator

2003-12-10 Thread Roger Spears
Here's one I've used recently with success http://www.devhood.com/tools/tool_details.aspx?tool_id=784 Thanks, Roger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] OCIBindByName Help Needed

2003-10-20 Thread Roger Spears
Hello, I've been working on this all day. I'm trying to insert some text ($essay) into a CLOB field (essay) in my table (clob_test). Can someone please tell me why the following PHP code returns ORA-01036: illegal variable name/number? Better yet, please tell me how to fix it?? $DB_Resource

[PHP-DB] ORA-01704: string literal too long AND PHP/PEAR

2003-10-17 Thread Roger Spears
Ok all of you Oracle experts out there, I've had one heck of a day wrestling with this oracle stuff. My experience with Oracle is turning into a greek tragedy. I'm using PHP/PEAR to execute my queries on an oracle table. I'm trying to store very long pieces of text into a CLOB field.

[PHP-DB] What is this Mealer Deamon message?

2003-10-17 Thread Roger Spears
I sent a post earlier..and got this in reply... Hi. This is the qmail-send program at pb1.pair.com. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. [EMAIL PROTECTED]: This message is looping: it

[PHP-DB] Oracle Auto_Increment Error

2003-10-14 Thread Roger Spears
Hello, BACKGROUND: I'm able to create tables in oracle, populate fields in oracle tables, select, retrieve and update fields in oracle. So I know my connection code is working. PROBLEM: I'm working with PHP and PEAR and I'm trying to create an auto_increment field in an oracle database

[PHP-DB] 'while' not picking up on first DB record

2003-09-17 Thread Roger Spears
Hello, Can anyone from the lists please tell me why this bit of code is not picking up on the first record in the database? If the 'id' I'm looking for is '1' it doesn't populate the _SESSION variables. Any 'id' greater then '1' will populate the _SESSION variables. $q = SELECT * FROM

[PHP-DB] SOLVED= 'while' not picking up on first DB record

2003-09-17 Thread Roger Spears
I'm sorry for the double post. Other then letting both lists know this was solved, it won't happen again. Sorry. Thank you for the solution! I new it was simple. I've been staring at it too long. Fresh eyes always helps! Thanks again, Roger You are making the fetch twice, and not using

[PHP-DB] Oracle and PHP

2003-08-22 Thread Roger Spears
Hello, I was wondering if there are any PHP people out there that are really into using Oracle databases? I've always used mysql but now I find myself in a situation that requires the use of an Oracle database. I've printed out the information posted by Thies C. Arntzen titled Making

[PHP-DB] test, please delete

2003-08-14 Thread Roger Spears
test, please delete -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php