Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Zoom1234

    install_driver(mysql) failed Error

    Thanks for the input Miller. I have asked my System Admin to check if the library is installed.
  2. Zoom1234

    install_driver(mysql) failed Error

    Hi, I am trying to connect to local mysql server through a perl script but getting following error install_driver(mysql) failed: Can't load '/usr/local/lib/.../mysql/mysql.so' for module DBD::mysql: ld.so.1: perl5.8.0: fatal: libmysqlclient.so.10: open failed: No such file or directory at...
  3. Zoom1234

    update multiple rows having diff condition in one go

    Hi Feherke, Thanks.
  4. Zoom1234

    update multiple rows having diff condition in one go

    Hello, I have to do update operation to the set of records e.g. update tablename set value=100 where id=1; update tablename set value=200 where id=2; update tablename set value=300 where id=3; update tablename set value=400 where id=4; I tried pasting all the statements in query browser but...
  5. Zoom1234

    data populating in only one cell

    Quality help. Thank you all.
  6. Zoom1234

    data populating in only one cell

    Hi jpadie, Yes, basically the script is to generate a report and mail it to the users. So the extra facilities of excel like formulas are not necessary. As you said, I may have issues with line terminsation. Can you please elaborate on how can i avoid that. Thanks
  7. Zoom1234

    data populating in only one cell

    Hi doc / Jpadie, I tried the csv route and it's working fine on my local windows machine. I will be creating the file and sending the file as attachment on Unix server. Will there be any problem becuase of the server change.
  8. Zoom1234

    data populating in only one cell

    Hi doc81, Thanks for the alternative way. I will try that out. But just wondering why the current code is not working, as i have another script (written by someone else) in similar fashion and works well. Hi Jpadie, I will give you the specification. Pushing for home right now :) Again...
  9. Zoom1234

    data populating in only one cell

    Hi All, I am trying to create a spreadsheet though PHP. Tough i am not using any specific library, i am formatting the data first and then writing it into file as text stream. The excel file is getting generated but the data is populating only once cell (left first row), but i want it to be in...
  10. Zoom1234

    backslash gets converted to forward slash

    Hi All, I am trying to give a link in my html document to some document on LAN. Below is the example <a href="\\pathtoLAN\somedocument.zip">click</a> I found that on some PCs the backslash(\) gets converted to forward slash (/) and hence the link does not work properly. Can someone tell me...
  11. Zoom1234

    What version is stored procedure implemented

    Thanks tsuji.
  12. Zoom1234

    What version is stored procedure implemented

    Hi, From what version of MySQL is the stored procedure implemented? Can it be written / executed on MySQL version 4.1.22? Thanks in advance.
  13. Zoom1234

    How to use variables in stored procedure

    Hi Santa, Thanks for the reply. I completely agree with you that One test is worth 100 expert opinions, especially when checking syntax, but the real issue is I don't have oracle installed on my machine right now and I have to send the code to someone else to test. So before sending hime, I...
  14. Zoom1234

    How to use variables in stored procedure

    Hi, I have written a following stored procedure CREATE OR REPLACE PROCEDURE SP_TEST DECLARE tablename VARCHAR2(50) ; id NUMBER ; column1 NUMBER ; column2 VARCHAR2(50) ; column3 DATE ; strencrypt VARCHAR2(50); dateencrypt DATE...
  15. Zoom1234

    how oracle stores the date

    Thanks for the valuable help guys.
  16. Zoom1234

    how oracle stores the date

    Thanks for the replies. So if i want to update in format of dd-mmm-yyyy(1-Jan-1881), then my update statment will be UPDATE my_table SET my_date_column = TO_DATE('1st Jan 1881','dd-mmm-yyyy') WHERE .... Is it right?
  17. Zoom1234

    how oracle stores the date

    Hi, In what format does oracle store the date..(dd/mm/yyyy?). I want to create a table and update the date column to value '1st Jan 1881'. What data type should i define (date or timestamp). Thanks in advance.
  18. Zoom1234

    Retrive and update records in bulk

    Thanks . I will have a look at them. Thanks for your patience and support.
  19. Zoom1234

    Retrive and update records in bulk

    Thanks. Just to know is dynamic query possible in the Version 5.0.37.
  20. Zoom1234

    Retrive and update records in bulk

    Thanks r. I will give update on this.

Part and Inventory Search

Back
Top