carriage return, php and oracle .. and almost forgot .. line feeds

after five days of patiance, i finally did it. my first php/oracle app, everything went pretty smooth up until the final insert statement. When i inserted data to the table only some of the fields were updated. the data was comming from 4 multiline text boxes, the data was split into many fields(to suite the database design) by return key(chr(13)). and i built the query from this. when i run it throught the webserver it doesnt fill all the fields. but when i print the query on the screen , copy and paste to Hora. it inserts perfectly .

for several days i tried to solve the problem, i just couldnt found any fault with the code or the database server . anyways yesterday i was goin thru ‘ the php.net site .. and there was this forum topic. about the difference between line feeds and carriage returns…. i forgot the simplest of things.(line feeds..) hehe

i did a string replace for line feeds(chr(10)) on the query string and it worked. Even though i have written several queries i havent done any real development on oracle.. all my previous projects were in mysql and ms sql server 2000. so it was a great experiace.