On Mon, 10 Mar 2003 08:40:39 +0200, Victor A. Rodriguez wrote:
Hi all,
Hi Victor
I'm looking for database browsing modules that allow to edit and
delete and
modify and ... records. I just found one module in SourceForge
called
DBIx::Browse (at http://dbix-browse.sourceforge.net there's a very
On Mon, 10 Mar 2003 08:40:39 +0200, Victor A. Rodriguez wrote:
Hi all,
Hi Victor, again
See also DBIx::Simple. It, too, is a very clever module.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 10/03/2003
http://savage.net.au/index.html
Try either:
(near the top of the script, after the connect)
$dbh-{odbc_default_bind_type} = 12 # SQL_VARCHAR
(then the database will do the conversion from type to type for you,
DBD::ODBC will tell the database that it's SQL_VARCHAR)
i have tested this and haven't changed anything inside the
On Mon, Mar 10, 2003 at 12:26:51AM -0800, Victor A. Rodriguez wrote:
I run through the same problem a few days ago, and I
just fetched all the rows in a hash with
fetchall_arrayref, finish()ed the query and performed
a do() again.
If you fetch all the rows you should not need to call
Hi all,
I am trying to know how I can use bind array. I am having Perl version 5.6 and i am
working in windows 2k.
what I tried is as follows.
$sth = $g_dbh-prepare(q{
BEGIN
test_1.P1(
?,
?,
?,
?);
END;
});
$sth-bind_param_array(1,[EMAIL PROTECTED]);
$sth-bind_param_array(2,[EMAIL
Try either:
(near the top of the script, after the connect)
$dbh-{odbc_default_bind_type} = 12 # SQL_VARCHAR (then the
database
will do the conversion from type to type for you, DBD::ODBC
will tell
the database that it's SQL_VARCHAR)
i have tested this and haven't changed
Since you know how your table is structured :
$query =INSERT INTO stuff VALUES(NULL,$num,\'$character\');
Or if you wanted to do it dynamically :
$query = INSERT INTO stuff VALUES(;
if($data =~ m/^\d+$/) { $query .= $data\, ; }
else { $query .= \'$data\'\, ; }
DMuey
-Original
On Mon, 10 Mar 2003 08:18:31 -0600 Dan Muey [EMAIL PROTECTED] wrote:
Since you know how your table is structured :
$query =INSERT INTO stuff VALUES(NULL,$num,\'$character\');
Or if you wanted to do it dynamically :
$query = INSERT INTO stuff VALUES(;
if($data =~ m/^\d+$/) { $query .=
On Mon, 10 Mar 2003 08:18:31 -0600 Dan Muey
[EMAIL PROTECTED] wrote:
Since you know how your table is structured :
$query =INSERT INTO stuff VALUES(NULL,$num,\'$character\');
Or if you wanted to do it dynamically :
$query = INSERT INTO stuff VALUES(;
if($data =~ m/^\d+$/)
I found an answer to my problem regarding the use of
mysql_read_default_file and my perl script crashing. According to:
http://www.rosat.mpe-garching.mpg.de/mailing-lists/dbi/2002-06/msg00159.html
and a page referenced therein, MySQL v3.23.49 contains the problem
and v3.23.50 fixed it.
Dan Muey [EMAIL PROTECTED] wrote:
On Mon, 10 Mar 2003 08:18:31 -0600 Dan Muey
[EMAIL PROTECTED] wrote:
Since you know how your table is structured :
$query =INSERT INTO stuff VALUES(NULL,$num,\'$character\');
Or if you wanted to do it dynamically :
$query =
There won't be any ['] (read that as reg. expression) inside the fields
so that's not a problem. All I need to do is decide whether to
single-quote the variable based on its data-type. Also this will just
be a select statement.
On Mon, 2003-03-10 at 09:39, Dan Muey wrote:
On Mon, 10 Mar
Are you not listening to these people giving you helpful advice? Use
the placeholders. I gaurantee you will be glad you did. C'mon man!!!
Embrace the change.
Rob Benton wrote:
There won't be any ['] (read that as reg. expression) inside the fields
so that's not a problem. All I need to do
Here, I'll try and be more helpful than berating. I'm sorry I'm having
a bad day. The code below is not totally complete. Some error
handling needs to be added for sure. I would consider this to be psuedo
code simply because I did not check my work for syntax. I think it
fairly accruate
hi Jeff
i've created a reduced .cgi (see attached - please don't hurt me about
this...). i'm currently out of office and have no MsSQL next to me.
1. create a Table Test1,
2. create TypeName - varchar - NOT NULL - Primary
3. create ProvLevel1 - money - default 0.00
4. create ProvLevel2 - money -
On WinNT (service pack 6) I've installed:
ActiveState Perl 5.8 (805)
DBI 1.32 and DBD Oracle 1.12 from the ppd's at http://xmlproj.com/PPM/
When running a test connection script (see below) I get Error while
trying to retrieve test for error ORA-06401
I'm running against Oracle 8i (8.1.7). When
ok - i have tested with mssql from remote - and the error is there.
Alex
Thanks for posting the answer for the archives.
Tim.
On Mon, Mar 10, 2003 at 04:54:00PM +, Greg Thompson wrote:
I found an answer to my problem regarding the use of
mysql_read_default_file and my perl script crashing. According to:
OK I see what you're doing. What I would need to do is just
tweak that a little. I would need something like:
foearch ($cgi-param() ) {
foreach $p(@params) {
if(param($p) ...) {
$dbh-(param($p));
To do param() instead of $cgi-param() you may need to do
use CGI
On 10 Mar 2003 14:34:28 -0600 Rob Benton [EMAIL PROTECTED] wrote:
OK I see what you're doing. What I would need to do is just tweak that
a little. I would need something like:
foearch ($cgi-param() ) {
if ( some test on the type here ) {
$dbh-quote($_);
}
foreach ( $cgi-param() ) {
push @cols, $_;
push @vals, $cgi - param( $_ );
}
my $sql = INSERT INTO table ( . join( , , @cols ) . )\n .
VALUES ( . join( , , map { ? } @cols ) . );
Seeing all that 'line noise' makes me think we need a neater way.
Personally I'd have written
On Mon, 10 Mar 2003 22:15:35 + Tim Bunce [EMAIL PROTECTED] wrote:
But imagine the DBI provided these two functions:
sub comma_separated_values { join , , @_ }
sub comma_separated_placeholders { join , , (?) x @_ }
you could then write the statement like this:
separated
my $sql = qq{
Tim Bunce wrote:
On Tue, Mar 04, 2003 at 09:32:27AM -0800, Jeff Zucker wrote:
Or run this command
perl -MSQL::Statement=
Hmm, what am I missing? That doesn't work for me
From memory... it needs a non-lexical $VERSION and (I think) to be
a subclass of Exporter.
Hmm, that's right. If I
foreach ( $cgi-param() ) {
push @cols, $_;
push @vals, $cgi - param( $_ );
}
my $sql = INSERT INTO table ( . join( , , @cols ) . )\n .
VALUES ( . join( , , map { ? } @cols ) . );
Seeing all that 'line noise' makes me think we need a neater way.
Personally I'd have
On Mon, Mar 10, 2003 at 05:56:49PM -0500, Paul Boutros wrote:
foreach ( $cgi-param() ) {
push @cols, $_;
push @vals, $cgi - param( $_ );
}
my $sql = INSERT INTO table ( . join( , , @cols ) . )\n .
VALUES ( . join( , , map { ? } @cols ) . );
Seeing all that
On Mon, 10 Mar 2003, Jeffrey Baker wrote:
On Mon, Mar 10, 2003 at 05:56:49PM -0500, Paul Boutros wrote:
foreach ( $cgi-param() ) {
push @cols, $_;
push @vals, $cgi - param( $_ );
}
my $sql = INSERT INTO table ( . join( , , @cols ) . )\n .
VALUES ( . join( ,
On Mon, Mar 10, 2003 at 02:39:36PM -0800, Jeff Zucker wrote:
Tim Bunce wrote:
On Tue, Mar 04, 2003 at 09:32:27AM -0800, Jeff Zucker wrote:
Or run this command
perl -MSQL::Statement=
Hmm, what am I missing? That doesn't work for me
From memory... it needs a non-lexical
Paul Boutros wrote:
my $sql = qq{
INSERT INTO table
( ${\comma_separated_values(@col)} )
VALUES ( ${\comma_separated_placeholders(@col)} )
};
I'm not sure I like this, but if it is to be used, a better name might
be comma_list which is the BNF short notation for all comma separated
Has anyone else run into this problem? I understand why it's happneing (I
think), I just can't figure why no-one else has reported it and/or it hasn't
already been fixed... maybe I'm missing something obvious; if so please
enlighten me.
It looks like pg_atoi trying to parse a string as a
I am using Perl 5.6.1, DBI 1.32 and DBD::Oracle 1.12. I have decided to upgrade to DBI
1.35 BEFORE reporting a problem I am having.
I built DBI 1.35 with no problems. Then I tried to rebuild DBD::Oracle 1.12.
1) compile warning:
cc -c -I/opt/oracle/product/8.1.6/rdbms/demo
I am calling bind_param like this:
$sth-bind_param($col_idx,
$value,
{TYPE = DBI::SQL_VARCHAR});
for a column defined as varchar(8), not null
When $value == ' ' (one space) or $value
On Mon, 10 Mar 2003 22:55:26 -0500 Matthew O. Persico [EMAIL PROTECTED] wrote:
Conclusion: somewhere in bind_param or whatever it is that it
invokes, trailing blanks are being stripped before the call to the OCI.
I was able to get around this by using
$sth-bind_param($col_idx,
$value,
Ivan Rodriguez Aguilar wrote:
Hello can somebody compile successfully
DBI::DBD for informix 9.30.FC1
ESQL/C version 9.51 and Client SDK 2.70 ??
i can compile successfully the DBI module
on solaris 8 for this informix's version
but the DBD module can't compile
Interpreting slightly - you have
33 matches
Mail list logo