CURDATE() has to be selected
SELECT(CURDATE());
--- Bob Showalter <[EMAIL PROTECTED]>
wrote:
> Greenhalgh David wrote:
> > ...
> > Second question. If I use the following:
> >
> > my $query="CURDATE()";
> > my $sth->prepare($query);
> > $sth->execute;
> >
> > I understand that $sth now just conta
The second one. (Except if you delete the largest number(s); they will
be reused.)
Second question. If I use the following:
my $query="CURDATE()";
my $sth->prepare($query);
$sth->execute;
I understand that $sth now just contains the reference to the result
of the query. Where is the value of the q
Greenhalgh David wrote:
> ...
> Second question. If I use the following:
>
> my $query="CURDATE()";
> my $sth->prepare($query);
> $sth->execute;
>
> I understand that $sth now just contains the reference to the result
> of the query. Where is the value of the query (which should be today's
> date
On 6/3/03 at 8:09 PM, [EMAIL PROTECTED] (Greenhalgh David)
wrote:
>
> This is more of a MySQL question than a cgi one,
you can say that again
> Are there any circumstances in which that vacant ID "5" will be
> re-used, or will the ID continue to count up to 255 and then generate
> errors?
The
on do, 27 feb 2003 16:57:59 GMT, Scot Robnett wrote:
> I have a script which is supposed to e-mail a user their
> username/password info as long as their e-mail address is in the
> database. The following code works if the address is in the database
> (it prints the approval page and sends the mai
> Basically, i'm trying to write a little abstraction layer
Someone already did the work for you, check out Class::DBI.
Here is a good article on it, it might be all you need.
http://www.perl.com/pub/a/2002/11/27/classdbi.html
Rob
-Original Message-
From: Peter Kappus [mailto:[EMAIL PRO
> -Original Message-
> From: Sven Bentlage [mailto:root@;svenbentlage.de]
> Sent: Thursday, November 14, 2002 2:43 PM
> To: [EMAIL PROTECTED]
> Subject: DBI / loop
>
>
> Hi everyone!
>
> I have a small problem which should be very easy to solve, but right
> now I just do not understand
I just replaced my actual server with "SMTP_SERVER",.
On Thursday, Nov 14, 2002, at 21:00 Europe/Berlin, Bob Showalter wrote:
-Original Message-
From: Sven Bentlage [mailto:root@;svenbentlage.de]
Sent: Thursday, November 14, 2002 2:43 PM
To: [EMAIL PROTECTED]
Subject: DBI / loop
H
> -Original Message-
> From: Sven Bentlage [mailto:root@;svenbentlage.de]
> Sent: Thursday, November 14, 2002 2:43 PM
> To: [EMAIL PROTECTED]
> Subject: DBI / loop
>
>
> Hi everyone!
>
> I have a small problem which should be very easy to solve, but right
> now I just do not understand
y Jones , "Beginner-CGI (E-mail)" Subject: Re:
>DBI in CGI's Date: Tue, 09 Jul 2002 11:13:19 -0400
>
>i'm not familiar w/ DBI and MySQL, but I do use DBD::Sybase and those
>drivers are on the client. i guess you might need to install the necessary
>MySQL DBI modules on
i'm not familiar w/ DBI and MySQL, but I do use DBD::Sybase and those
drivers are on the client. i guess you might need to install the necessary
MySQL DBI modules on the web server. do a syntax check of your CGI script
with "-c" before running your CGI program, and maybe print out the vars in
Can you telnet or SSH into your server? Do they have the CPAN module
installed? If the answers to those 2 questions are yes, try
perl -MCPAN -e 'install Bundle::DBI'
I don't *think* this module is of the pure perl variety, so my suspicion is
that it has to be installed by whoever is root
There are many possible sources of error. Please include the actual error
you received, and you will get the help you need.
I have posted a few DBI/CGI scripts here
http://www.geocities.com/k2001evad/pindex.html
They are abit crude, but if you have MySql up and running on you machine and
the CGI,
sorry, didn't mention it.
the assignment for the variables has been done above, in the main script.
On Thursday, May 23, 2002, at 02:13 PM, Felix Geerinckx wrote:
> on Thu, 23 May 2002 11:08:22 GMT, [EMAIL PROTECTED] (Sven
> Bentlage) wrote:
>
>> Hi everyone!
>> I'm getting desperate. Can't find
on Thu, 23 May 2002 11:08:22 GMT, [EMAIL PROTECTED] (Sven
Bentlage) wrote:
> Hi everyone!
> I'm getting desperate. Can't find the error in the snibblet of
> code below...to me everything seems to be ok (except bad style
> etc), but the update of the mysql database does not work altought
> the s
sorry bob,
I'm a bt confused here as to what exactly the problem is your experiencing
are you unable to connect to mysql db on winxp running activestates perl?
What error do you get?
I would guess this is the case as your PPM dump didn't seem to show a DBD
for mysql. If this is the case, can you
Hytham,
what happens when you type
PPM
INSTALL DBD-Mysql
joel
-Original Message-
From: Hytham Shehab [mailto:[EMAIL PROTECTED]]
Sent: 18 March 2002 14:52
To: yahoo; [EMAIL PROTECTED]
Subject: Re: dbi module for ActivePerl
hi guys,
when i list the available drivers when useing
hi guys,
when i list the available drivers when useing perl from perl.com, it
gives me the whole drivers as well as mysql, but when i use the activeperl
version, it list the whole but mysql, i search about the dbd of mysql in
activeperl repository, i wasn't lucky, how can i go along with activ
to do?
I think you need to go back to PPM and type "INSTALL DBD-Mysql"
let me know how you get along
joel
-Original Message-
From: Hytham Shehab [mailto:[EMAIL PROTECTED]]
Sent: 17 March 2002 22:12
To: yahoo; [EMAIL PROTECTED]
Subject: Re: dbi module for ActivePerl
thanks joel,
ation issue here.
what happens if you type "SEARCH DBI" from within the PPM? What does it say?
regards
Joel
-Original Message-
From: Octavian Rasnita [mailto:[EMAIL PROTECTED]]
Sent: 17 March 2002 18:33
To: yahoo
Subject: Re: dbi module for ActivePerl
I've tried tha
thanks joel,
but i try to see the available drivers with @x=DBI->available_drivers;
it gives me Example and Proxy, with no sign of MySQL - mysql is installed
and working properly with other version of perl, ie perl from perl.com - so
what is the problem.
thanks in advance.
--
Hytham Shehab
Hytham,
from a command prompt
type
1) PPM
2) INSTALL DBI
it really is that simpe
:-)
regards
Joel
-Original Message-
From: Hytham Shehab [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2002 12:59
To: [EMAIL PROTECTED]
Subject: dbi module for ActivePerl
Hello!,
i use perl from ActivePe
h I could help more,
R.A. Howard
-Original Message-
From: Yegneshwar Virupakshan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 3:53 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: DBI
Robert,
I tried doing exactly what you told and got the following er
Robert,
I tried doing exactly what you told and got the following error:
LoadLibrary("C:\Perl\site\lib\auto\dbd\oracle\oracle.dll") failed.
GetLastError returns 0x0485
What does it mean?
Thanks,
Yegi
--- Robert Howard <[EMAIL PROTECTED]> wrote:
> The .dll file may need to be re-registere
The .dll file may need to be re-registered. Try doing the following, and
adapt for your particular flavor of Windows:
Win9x/NT:
1) Go to Start, Find, Files or Folders.
2) In the Named field, type: regsvr32.exe, Oracle.dll.
3) In the Look In field, make sure it is set to root C:
4) Click Find Now.
In your script, you'll have to use a function to only pull out the time. I'm
only familiar with MySQL, but I've done this many times. You can find
information on Date and Time functions for here -
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
Kolene
Joe Santiago wrote:
> I have a
you should not need a c compiler for make. On windows, however, it is either
nmake or dmake (I've heard of dmake, but never used it. it has always been
nmake for me) You should use PPM, but if you need a module that needs a make
on windows you can just substitute nmake for the word make in the
ins
On Mon, 18 Jun 2001, Kris Cook wrote:
> Actually, I've used make for all sorts of stuff without a C compiler. It's
> amazing what you can automate. Actually, I've even used it as the backbone
> for a QnD (Quick'n'Dirty) system security monitoring package before. I've
> also used it for automat
---
From: "Kris Cook" <[EMAIL PROTECTED]>
To: "'Tim Keefer'" <[EMAIL PROTECTED]>; "Kris Cook"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 8:03 AM
Subject: RE: DBI
> I've tried to follow your suggestion,
[mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 18, 2001 9:44 AM
> To: Kris Cook; [EMAIL PROTECTED]
> Subject: Re: DBI
>
>
> open a command prompt and type "ppm install DBD-ODBC"
> and "ppm install DBI"
>
>
> At 09:43 AM 6/18/2001 -0500, Kris Cook w
riginal Message-
> From: Brett W. McCoy [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 18, 2001 9:51 AM
> To: Kris Cook
> Cc: [EMAIL PROTECTED]
> Subject: Re: DBI
>
>
> On Mon, 18 Jun 2001, Kris Cook wrote:
>
> > I'd like to try using the DBI interface fo
open a command prompt and type "ppm install DBD-ODBC"
and "ppm install DBI"
At 09:43 AM 6/18/2001 -0500, Kris Cook wrote:
>I'd like to try using the DBI interface for database access, but when I
>downloaded it from ActiveState, I fount that I had to have a make utility to
>get it installed. Do
On Mon, 18 Jun 2001, Kris Cook wrote:
> I'd like to try using the DBI interface for database access, but when I
> downloaded it from ActiveState, I fount that I had to have a make utility to
> get it installed. Does anyone know of a free make distribution for Win32
> environments? It HAS to com
--- SAWMaster <[EMAIL PROTECTED]> wrote:
> Can someone clear this up for me?
>
> Is DBI some sort of implementation of Win32::ODBC or is it an entity in and of
>itself?
DBI.pm (DataBase Interface) is a generic wrapper around the various DBD (DataBase
Driver) modules
that are available. DBI i
34 matches
Mail list logo
