Hello,
I'm using the Perl DBI to access a MySQL database.
I'm trying to fetch all rows in a integer column. When I manually interact
with MySQL, I get all of the values, whether they're zero or not. But when I
use DBI to do it, it seems to throw out any zero values. e.g.
(apologies for the
On Sun, Apr 22, 2001 at 09:07:38AM -0500, Steve Howard wrote:
first perform the search against the database to see if the string
is unique, then based on the results of that search, call one of two
subroutines within that perl file.
The other frequent solution to this problem is simply to
Peter R. Wood - Lists wrote:
The query in perl dbi:
--snip--
my $assignment_query =
SELECT grade .
FROM student_assignment;
my $sth = $dbh-prepare($assignment_query);
$sth-execute();
my @assignments;
while ( my $grade = $sth-fetchrow() )
{
push(@grades,$grade);
}
print
Thanks loads. I was however lost in the generalized version of the other frequent
solution. A pointer to a specific example on how to set this up would be
helpful. The problem again: Get user input from
a form (DBI/CGI or JSP or servelet) which will be
used as the insert value into a
PKey
just do a DO command with an INSERT query.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 23 April 2001 13:58
To: [EMAIL PROTECTED]
Subject: How to add records to Access
Can anyone tell me how to add records to an MS ACCESS database?
I
How do I get a list of the error codes returned via $DBI::err for
Mysql? I can't find anything in the Mysql docs, and strangely enough
I couldn't get this question answered on the Mysql mailing list
either. Thanks for any pointers.
On Mon, 23 Apr 2001, Thirumalai, Radhika wrote:
Can someone suggest me (any url / reference manual...) where I can find a
working example of the perl module DBIx-XML_RDB? Thanks
It comes with two scripts - sql2xml and xml2sql. They are the best
references it has.
--
Matt/
/||**
- Original Message -
From: Steve Leibel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 23, 2001 3:54 PM
Subject: $DBI::err values?
How do I get a list of the error codes returned via $DBI::err for
Mysql? I can't find anything in the Mysql docs, and strangely enough
I
At 5:41 PM +0200 4/23/01, M.W. Koskamp wrote:
- Original Message -
From: Steve Leibel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 23, 2001 3:54 PM
Subject: $DBI::err values?
How do I get a list of the error codes returned via $DBI::err for
Mysql? I can't find
I think that defining some Oracle triggers on the insertion of that row could
be very helpful to perform some of the actions you pretend.
Greetings,
Quique
Help???
This must be a common thing to do but have not seen an example to
reference.
Must create a web input form
You'd probably be better off using the prepare() and execute() _methods_ as
described in the fine manuals. Run 'perldoc DBI' to see some examples.
Placeholders would also be a good idea to limit the opportunity for
ill-intentioned users to slip and extra SQL statement in on you.
--
Mac :})
** I
I'd greatly appreciate a clue about this problem; I've been wandering about
the mail archives, and don't see mention of a solution.
I've built a non-threaded perl5.6.0, adding -lcl and -lpthread to config.sh,
then built DBI 1.14, then built DBD::Oracle 1.06 with the two patches to the
Makefile
It looks like it cann't find the path to $ORACLE_HOME/lib libraries.
Try setting LD_LIBRARY_PATH... and make sure you have $ORACLE_HOME and
its family of EVs set.
Lincoln
-Original Message-
From: Peterson, Ted [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 3:25 PM
To: '[EMAIL
Ted,
dld.sl is trying to load libwtc8.sl because libclntsh.sl (Oracle's client
library) was linked with it.
My guess is your LD_LIBRARY_PATH isn't set correctly. It should contain
$ORACLE_HOME/lib
Hope this helps,
Mark
Peterson, Ted wrote:
I'd greatly appreciate a clue about this problem;
Hi all,
I'm trying to connect oracle(8.0.3) database via Netscape Enterprise server(3.6) on
solaris 5.7
I able to connect to database from perl program at unix prompt and not from the web
server.
Do I need to do anything at perl program or webserver configuration
log says 'permission
Hi All,
I am using ActiveState Perl on Win2000 environment. I get this error all the
time when I test my script to access an
oracle DB:
Mon Apr 23 17:42:48 2001] C:\mycode\print_invoice3.cgi: (in cleanup) Can't
call method FETCH on an undefined value at
C:/Perl/site/lib/Win32/TieRegistry.pm
Alzabo is a program and a module suite, with two core functions. Its first
use is as a data modelling tool. Through either a schema creation
interface or a perl program, you can create a set of schema, table,
column, etc. objects to represent your data model. Alzabo is also capable
of reverse
Hi,
I am building perl for distribution on several machines and I am having
difficulties in using DBD:Oracle with that build.
I have installed the DBD:oracle after setting up ORACLE_HOME and
LD_LIBRARY_PATH.
make test didn't report any errors. Available_drivers returns Oracle
driver as
The web server runs as user www or nobody (usually), so you must first
change the excution permissions for the script (chmod 755 script_name.cgi)
Also a snippet of your script would be helpful.
Ilya Sterin
-Original Message-
From: Prasanna Gopalakrishna [mailto:[EMAIL PROTECTED]]
Sent:
Also this message does not belong on dbi-dev. Please make sure you post to
correct group for each question. This pertains to dbi lists and any other
lists out there.
Ilya Sterin
-Original Message-
From: Raj Srinivasan [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 7:14 PM
To:
What's the error. It's hard to tell without an error message. Use trace()
at level 2 if you haven't yet.
Ilya Sterin
-Original Message-
From: Raj Srinivasan [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 7:14 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: DBD:Oracle -
Can anyone tell me how to add records to an MS ACCESS database?
I am using Perl/DBI/CGI to access the db.
Any ideas, thanks
Miguel
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
22 matches
Mail list logo