= or != when you use SQL patterns; use the LIKE or NOT LIKE
comparison operators instead." In your case you can use "=" or like
without any wildcards.
2. [EMAIL PROTECTED] if you are with mySQL. they answer this type of
question everyday even if it's in the FM. You can use a mailinglist for
your database or for general SQL.
Etienne
--
Etienne Marcotte
Specifications Management - Quality Control
Imperial Tobacco Ltd. - Montreal (Qc) Canada
514.932.6161 x.4001
ess=$dataarr[3];
> $zipcode=$dataarr[4];
> $town=$dataarr[5];
> $telefoon=$dataarr[6];
> $email=$dataarr[7];
>
> $dbh->disconect;
>
>
> Thanks in advance, you can also mail me.
>
> Erik van Huijgevoort
> Holland
> [EMAIL PROTECTED]
--
Etienne Marcotte
Specifications Management - Quality Control
Imperial Tobacco Ltd. - Montreal (Qc) Canada
514.932.6161 x.4001
http://lists.cpan.org/
Etienne
[EMAIL PROTECTED] wrote:
>
> I recall a message was posted that listed a variety of mailing lists from
> beginner, to CGI, DBI, etc. I have lost my bookmarks, apologize for
> making someone repost.
>
> PG
--
Etienne Marcotte
Specifi
there's nobody watching,
> It's gotta come from the heart if you want it to work.
>
> Every program is a part of some other program, and rarely fits.
--
Etienne Marcotte
Specifications Management - Quality Control
Imperial Tobacco Ltd. - Montreal (Qc) Canada
514.932.6161 x.4001
sustain as a
> result of software viruses. You should perform your own virus checks before
> opening the attachment.
--
Etienne Marcotte
Specifications Management - Quality Control
Imperial Tobacco Ltd. - Montreal (Qc) Canada
514.932.6161 x.4001
Read the O'Reilly book on DBI and you should be pretty set to go.
There is a section on mySQL syntax in it, but it's the same as in the
www docs.
As for mySQL syntax, the mySQL (huge) book by Paul Dubois is IMO the
best one to learn the SQL for mySQL...
Etienne
W P wrote:
>
> is there a beginn
> my %groups;
> while (my $hashref = $sth->fetchrow_hashref) {
> push @{$groups{$hashref->{group_num}}}, $hashref;
> }
>
> then later...
>
> foreach my $group_number (keys %groups) {
> delete $groups{$group_number} unless group_is_OK($groups{$group_number});
> }
I don't understand why you
I run a database with a lot of tables used only to reference two other tables.
Sometimes they use a couple other fields also.
After some testing, I preferred to use multiple selects (one per relationship
table) since the result of the query was getting way to huge when having 4-5
relationship tab
Did you try the quote() ?
Etienne
[EMAIL PROTECTED] wrote:
> > Thanks for the reply,
> >
> > It still does not like the
> >
> > username@'%'
> >
> > Can this be done?
> > again here is the full command that works from the command line :
> >
> > grant usage, SELECT, INSERT, UPDATE, DELETE, CREAT
repare(<<'eof');
>SELECT
> ParamName, ParamValue
>FROM
> Config
> eof
>
> $sel->execute();
>
> while (@data=$sel->fetchrow_array()) {
>print "@data\n";
> }
>
> #---
>
>
:55:57 -0400, Etienne Marcotte wrote:
>
> >I made an access DB, created an ODBC DNS with windows 2000 utility
> >(altough I'm not sure I did everything correctly)
> >
> >When I try the connect string:
> >
> >dbi:ODBC:driver=Microsoft Access Driver (*.m
WOW!
it's as simple as that!!!
I lost countless hours yesterday trying to solve this:-)
Thanks a lot for this
Etienne
Bart Lateur wrote:
> On Tue, 23 Oct 2001 10:55:57 -0400, Etienne Marcotte wrote:
>
> >I made an access DB, created an ODBC DNS with windows 2000 utility
&g
I read on the web that I'm far from being the only one with this
problem, and I can't find a good solution for the problem.
I made an access DB, created an ODBC DNS with windows 2000 utility
(altough I'm not sure I did everything correctly)
When I try the connect string:
dbi:ODBC:driver=Microso
13 matches
Mail list logo