from:"Durga_Prasad"

Re: Perl problem

2002-01-01 Thread Durga_Prasad




The $dbh connect code should be like this:
$dbh=DBI-connect(DBI:mysql:datrtabase=radio';host=localhost,root,password,
{RaiseError=1});

If there is an error, you can catch it using, die statement.



  Placed At :


John Mayson [EMAIL PROTECTED] on 01/01/2002 08:24:50 AM

Please respond to [EMAIL PROTECTED]

To:   MySQL List [EMAIL PROTECTED], Central Florida Geeks
  [EMAIL PROTECTED]
cc:(bcc: Durga Prasad/Satyam)

Subject:  Perl problem




I've decided to graduate to the next step and access my mySQL databases with
Perl.  I
am attempting this on a Win2000 machine.

Here's my code...

#!C:/perl/bin/perl.exe -w

use strict;
use CGI qw(:standard);
use DBI;

my $dbh = DBI-connect('Radio', 'root', '');

I get this error message...

Can't locate object method connect via package DBI (perhaps you forgot to
load
DBI?) at C:\Program Files\Apache Group\Apache2\cgi-bin\rdb.pl line 7.

DBI.pm lives under c:\perl\lib which is in my @INC.

Ideas?

John
--
John Mayson   KC4VJO Linux/Perl/HP-UX/ICT
Austin, Texas 78729 30.4560N 97.7851W
[EMAIL PROTECTED] http://www.nyx.net/~jmayson



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Execute Error

2002-01-01 Thread Durga_Prasad




You are executing, $dbobj the database object. You should execute the statement
handle.
The code should be:
$query = SELECT UserID,Name FROM test;
$sdb = $dbobj-prepare($query);
$sdb-execute();





  Placed At :


Clinton Hesse [EMAIL PROTECTED] on 01/01/2002 03:21:15 AM

To:   [EMAIL PROTECTED]
cc:(bcc: Durga Prasad/Satyam)

Subject:  Execute Error




It's funny, i can call method prepare on the database object but not
execute, error on line 3.

1. my $query = SELECT UserID,Name FROM test;
2. my $sdb = $dbobj-prepare($query);
3. $dbobj-execute;

where $dbobj is a reference to the database object

I get error

Can't locate object method execute via package DBI::db (perhaps you
forgot to load DBI::db?)




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Hi. Here is the An-san City of the South Korea.

2001-12-29 Thread Durga_Prasad




Just a thought.
It is a well known fact that MySQL is being used as the backend software for
Yahoo Finance.
However, the response as mentioned in this mail is also typical from a customer
looking at commercial application development.
How can the larger business community perception be changed with regards to
products like MySQL which are better than or atleast comparable to any other
commercial products like say Oracle?
Lets face it, in these times of recession, it is important for the businesses to
reduce costs of automation theough application development.
Using a free software would certainly reduce the costs involved in software. But
is it worth it? What would be the typical percentage of software costs in any
custom application development in relation to the total costs of Hardware,
Software and Development costs?
Anybody care to share their thoughts?
Rgds,
Durga Prasad





  Placed At :




ÀÌ¼º°è [EMAIL PROTECTED] on 12/29/2001 12:48:50 PM

Please respond to ÀÌ¼º°è [EMAIL PROTECTED]

To:   [EMAIL PROTECTED]
cc:(bcc: Durga Prasad/Satyam)

Subject:  Hi.  Here is the An-san City of the South Korea.





Hi.  Here is the An-san City of the South Korea.

We are the company which is developing the programs #8211; ERP(ENTERPRISE
RESOURCE PLANNING) and has been concerned with MY_SQL DATABASE.

Recently, we suggested to the client of Korea that we want to develop the
programs(ERP, MIS, MRP) with adapting your MY_SQL DB, but we are rejected by the
client.  We took the response to the client ,after we discussed the problem with
the client, that if we offer to the client an efficiency test table of MY_SQL
and the rest of data, the client will examine this data.

Thus, we would like to take the data with the following questions from yours.



-  Brief yours and what is your adapted businesses?

-  If the ERP is developed with MY-SQL, is it possible for the ERP to
adapt with MY_SQL ?

-  What is the representative company which is adapted?

-  User number of MY_SQL, speed, efficiency and stability (in the Window
2000 Server and Linux)

-  The price list for the user number (in the case of Window 2000 and
Linux)

-  If the client agrees to our company


?s using your DB, can you
recognize us to the main agency of Korea?



So far, thank you for reading our letter.  We wanna receive your response as
soon as possible.



2001. 12.28

Arcline. Cor.

   A principal administrative officer   Mun-choel
Shin


===


¿ì¸® ÀÎÅÍ³Ý, Daum  http://www.daum.net
- 2002 ´ëÀÔ 1:1»ó´ã,¿ø¼Á¢¼ö,ÇÕ°ÝÀÚ¹ßÇ¥ ¢Ñ http://hmm.daum.net/daeip_0112
- ÀÎÅÍ³Ý¿¡¼ 'ÅäÁ¤ºñ°á' º¸¼¼¿ä~ ¢Ñ http://hmm.daum.net/fortune_0112

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: How can i RollBack or Commit using PHP in MYSQL

2001-12-20 Thread Durga_Prasad




MySQL with MyISAM Tables does not provide the facility of Commit or Rollback.
You need to compile MySQL with InnoDB tables to have above mentioned features.

Check out:
www.innodb.com

regards,
Durga Prasad




  Placed At :


sreedhar [EMAIL PROTECTED] on 12/21/2001 12:05:05 PM

To:   mysql [EMAIL PROTECTED]
cc:(bcc: Durga Prasad/Satyam)

Subject:  How can i RollBack or Commit using PHP in MYSQL




Hi all,

How can i RollBack or Commit using PHP in MYSQL. i have not found any
commands through PHP Doc.

regards,
sreedhar


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Length of columns and attachents as a column...

2001-10-23 Thread Durga_Prasad



  Placed At :  BOM


Durga Prasad@SATYAM
10/23/2001 01:06 PM

Hi all,
Is it possible to have an external file as an attachment in MySQL?
An example would be a .gif, .doc, .ppt, .ram etc.
If there is no way directly have MySQL table to store an attachment, is there
any work around?
Any guidance will be appreciated.
Thanks and Regards,
Durga Prasad



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Basic details...

2001-09-19 Thread Durga_Prasad



  Placed At :  BOM


Durga Prasad@SATYAM
09/20/2001 09:52 AM

Hi,
 iam trying to use mysql as the back end of a web enabled application.
My tables have fields numbering more than 50.
Iam a newbie and so i would like to know if there are any limits on the number
of fields i may have in any single table.
Some other DB's have this problem.
Rgds,
Durga Prasad



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Unable to run Bench Tests...

2001-09-12 Thread Durga_Prasad



  Placed At :  BOM


Durga Prasad@SATYAM
09/12/2001 03:25 PM

Hi all,
I have just installed
MySQL 3.23.42-1.
using MySQL3.23.42-1.i386.rpm.
OS: RH Linux 7.1
glibc:2.2.2.10
gcc: 2.96-81
perl: 5.6.0-12

When i try to install MySQL-bench-3.23.42-1.i386.rpm
using the command: rpm -i MySQL-bench-3.23.42-1.i386.rpm i get the following
error.
error: failed dependencies:
 MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.42-1

This inspite of installing Bundle::DBI as well as Bundle::DBD::mysql
Does any body else has any idea why this is so.
Rgds,
Durga Prasad




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem...

2001-09-12 Thread Durga_Prasad



  Placed At :  BOM


Durga Prasad@SATYAM
09/12/2001 05:10 PM

Hi all,
I have just installed
MySQL 3.23.42-1.
using MySQL3.23.42-1.i386.rpm.
OS: RH Linux 7.1
glibc:2.2.2.10
gcc: 2.96-81
perl: 5.6.0-12

When i try to install MySQL-bench-3.23.42-1.i386.rpm
using the command: rpm -i MySQL-bench-3.23.42-1.i386.rpm i get the following
error.
error: failed dependencies:
 MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.42-1

This inspite of installing Bundle::DBI as well as Bundle::DBD::mysql
Does any body else has any idea why this is so.
Rgds,
Durga Prasad



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Perl problem

Re: Execute Error

Re: Hi. Here is the An-san City of the South Korea.

Re: How can i RollBack or Commit using PHP in MYSQL

Length of columns and attachents as a column...

Basic details...

Unable to run Bench Tests...

Problem...

8 matches

Site Navigation

Mail list logo

Footer information