Search results for query: *

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

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...

Hi Feherke, Thanks.

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...

Quality help. Thank you all.

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

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.

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...

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...

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...

Thanks tsuji.

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.

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...

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...

Thanks for the valuable help guys.

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?

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.

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

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

Thanks r. I will give update on this.