 | | | Perl | | Hi!
I have a "SQL query construction " question that I hope someone can help
me with. After comparing a bunch of DNA fragments (see name below) with
a larger reference sequence I get a ordered list raHello all
I have a problem
I have 2 tables on MySQL in the first one call patentes I just need to get
the patente 's number that 's a field call pat
So I do a query like this one
On Sat 2007-11-10 at 13 13 -0600 Randy Kobes wrote
> On Sat 10 Nov 2007 Daniel Kasak wrote
>
> > Does anyone know where I can get a PPM package of the current series of
> > DBD mysql from?
> Hi
I have the problem that with
my $sth $dbh- >prepare($procedure)
the two parameters are passed to $para1 and $para2 procedure CALL
p1(10 12) is passed to MySql
and with
my $sth $dbh- >preparOn Sat 10 Nov 2007 Daniel Kasak wrote
> Does anyone know where I can get a PPM package of the current series of
> DBD mysql from?
We have one in our http //theoryx5.uwinnipeg.ca/ppms/
repositoryI 'm trying to execute an SP that returns a recordset and I 'm getting an
error about not being able to return a resultset from the current
context ( or something like that ). I 've seen this error befoHi. In the second one ur passing an anonymous hash to the prepare()
function. It needs to be a scalar like in ur first example. So just
get rid of the {} 's and it should work assuming $procedure eqHello
I try to read a stored procedure p1 from a table listproc in database test_texte and use it after giving a value to her parameters in an other database.
#/usr/bin/perl
use strict
use warningsThank you for the detailed explanation.
I did look at the mysql date formats but since i had some of my dates already in a mm/dd/yyyy format i wanted to keep it the same way.
But i see the advantagUPDATE tableA
SET sdate '2007-1-1 '
WHERE c 1
Reformat your date to the ones MySQL accepts.
"Although MySQL tries to interpret values in several formats dates
always must be given in year-mHI
I am having trouble inserting date into my table (Mysql)
my sql statement looks like this...
Example
update tableA set sdate '1/1/2007 ' where c 1
That doesnt do anything. I see there are diHi
Wagner Chris (GEAE CBTS) wrote
> Greetings all. I 've run into something annoying that doesn 't seem to be
> in the MySQL manual. I have fields of type varchar that contain null
> characters Greetings all. I 've run into something annoying that doesn 't seem to be
in the MySQL manual. I have fields of type varchar that contain null
characters chr(0). I need to find these for error reporOn Sep 19 2007 12 19pm John Trammel wrote
> I don 't understand the behavior of the original script it looks like
> the INSERT from the child process gets queued up by MySQL and the
> killing "warning " not error ) Kind of like ignoring when Mom used to warn about
running outside without a coat.
Jim Wright wrote
> At this point the only other issue I 'm having is that my socket for
>At this point the only other issue I 'm having is that my socket for
mysql isn 't being created in /tmp which is probably something I
messed up in reinstalling things. Now that I know this error is aThose warnings are not the problem - ignore them they are xs oddities
that I nor others have been able to make go away in the source.
What is the error you have upon "make test " ?
Jim Wright wroteI 've been beating my head against this one for a few days I 've found
nothing via google that has been of any help.
Machine is a Mac Mini Intel core duo build 5.0.45 of mysql
installed. I tried thActually this was a bug in 5.0.22 client showing empty strings as NULL.
----
Larry Low
4150 N Drinkwater Blvd. 5th Floor
Scottsdale AZ 85251
Office 480.385.7045
E-mail llow@(protected) '
TeleNevermind it seems the thold_hi field is a VARCHAR and the program filling
it is putting in the string NULL.
----
Larry Low
4150 N Drinkwater Blvd. 5th Floor
Scottsdale AZ 85251
Office 480.385.70I am unable to figure out why but NULL values which from what I read should
be undefined are being defined. See the example below for the column
thold_hi which shows as NULL in the database but the r
Hi Forum
We have Active State Perl 5.8.8 and now we are trying to connect to
MySQl Database via SolidDB Engine
For this we downloaded the DBD mysql from CPAN after downloading it
we didI am working on getting data from a DBF and saving it on a CSV file and then
putting it on MySql
The program work great when it is only one but now I need to make the
program go look to a CSV file
Yes I did I am using DBI to connect to my database o)
Thanks
-----Mensaje original-----
De Selke Gisbert W. [mailto Gisbert.Selke@(protected)]
Enviado el Viernes 19 de Octubre de 2007 09 > -----Urspr?ngliche Nachricht-----
> Von Armando Gomez [mailto armando.gomez@(protected)]
> Gesendet Freitag 19. Oktober 2007 15 55
> I have a question I am working on a project that require do
> sHello all!!!
I have a question I am working on a project that require do some access to a
MySql database one of those queries that is very simple something like this
SELECT * FROM pat
Hi
I 'm having problems with bind_param on particular machines. They have
DBI v1.48 and DBD mysql v4.005 installed.
We are using the second form of bind_param shown in the DBI man page
$rc Ah next time include all the code!
--- Douglas Brantz <brantzdr@(protected) > wrote
> Got it worked out - thanks - it was in another part of the code -
>
> $CGI POST_MAX 1024 * 2
> Get_NamesGot it worked out - thanks - it was in another part of the code -
$CGI POST_MAX 1024 * 2
Get_Names()
sub Get_Names{
my $counter 0
my $full_name
my $file_name
foreach $full_name (@(protected)){You certainly could use rename. You would have to use it after because the file would have to
exist first to be able to rename it.
Greg
--- Douglas Brantz <brantzdr@(protected) > wrote
> Should I u |
|
|
