sql=qq{INSERT INTO titles
(Title,Director,Actor,Genre,Language,CaseNum,Year,Comment)
VALUES
("$Title","$Director","$Actor","$Genre","$Language",$CaseNum,$Year,"$Notes")};
I'm stumped by the 'out of range' error. Anyone shed
d hopefully got a working solution?
If this is going to keep happening every time the server gets updated
then I (and lots of others I assume) will have to find an alternative
way to let my client do backups.
--
Amer Neely - Web Mechanic
w: www.webmechanic.softouch.on.ca/
--
MySQL General Mail
f
'restarting' the service from control panel, I stopped, then started it.
Voila!
--
Amer Neely
w: www.softouch.on.ca/
Perl | MySQL programming for all data entry forms.
"Others make web sites. We make web sites work!"
--
MySQL General Mailing List
For list archives: http
ore.
But now I'm trying to point it to a different data dir. In my.ini I have
datadir="I:/mysql/data/"
which I've also copied to c:\
When I try to restart the service from control panel, it throws an error:
Error 1067. The process terminated unexpectedly.
--
Amer Neely
w
this is a brand new
drive. I have MyODBC Connector 3.51 installed.
Is this a known problem, or am I missing something here. I've had
earlier versions working just fine.
--
Amer Neely
w: www.softouch.on.ca/
Perl | MySQL programming for all data entry forms.
"Others make web sites. We
Paul DuBois wrote:
At 10:14 AM -0400 4/13/07, Amer Neely wrote:
I'm using MySQL 5.0.21 and am trying to find out if it is possible to
overwrite an existing file when using a 'SELECT ... INTO' command from
the command line. Is there another parameter that can do this? I've
not a
TABLE. Perhaps a better Subject should have been 'How to overwrite
existing file with SELECT .. INTO OUTFILE'.
I think I'll end up writing a Perl script to do this.
On Mon, 16 Apr 2007, Amer Neely wrote:
At 08:14 AM 4/13/2007, Amer Neely wrote:
I'm using MySQL 5.0
At 08:14 AM 4/13/2007, Amer Neely wrote:
I'm using MySQL 5.0.21 and am trying to find out if it is possible to overwrite
an existing file when using a 'SELECT ... INTO' command from the command line.
Is there another parameter that can do this? I've looked through the onli
specific help
there.
--
Amer Neely
w: www.softouch.on.ca/
Perl | MySQL programming for all data entry forms.
"We make web sites work!"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this recursion happens multiple
levels.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Amer Neely [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 15, 2007 11:21 PM
To: Daniel Kasak;
Amer Neely wrote:
Daniel Kasak wrote:
Amer Neely wrote:
OK, that makes sense. As far as I know, my connection is still live
- I don't do a disconnect anywhere. So I'm still not sure why I
can't pull the data back out. I do get an error telling me about a
problem with my
Daniel Kasak wrote:
Amer Neely wrote:
OK, that makes sense. As far as I know, my connection is still live -
I don't do a disconnect anywhere. So I'm still not sure why I can't
pull the data back out. I do get an error telling me about a problem
with my statement near wh
Amer Neely wrote:
Daniel Kasak wrote:
Amer Neely wrote:
I'm writing a perl script in which I need to save some session data.
My first attempt is to use a temporary table to store some data.
However, I'm a little unclear as to the lifespan of the temporary
table. My understandi
an idea whether this can even be done, or does calling
another subroutine end the 'session', thus killing the table?
--
Amer Neely
w: www.softouch.on.ca/
b: www.softouch.on.ca/blog/
Perl | MySQL programming for all data entry forms.
"We make web sites work!"
--
MySQL
er = replace( Service_Number, '" . $space_character . "', '' )";
it works! But the *exact* same Perl code running on a Linux client fails
( doesn't update the field anyway ). It defies logic.
Who knows what's going on?
--
Amer Neely
w: ww
a table description and no
errors, I'd say it's OK to delete the func table in the client db. Is
it in all client dbs or just that one? A mysqldump/import could have
been editing and done wrongbut I haven't done an in-place upgrade,
so I can't say for sure what the upgrade mi
s may have something to do with my recent upgrade to 5.0
but I don't see the purpose, especially as it only appears in one of my
client databases.
--
Amer Neely
Home of Spam Catcher
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
Perl | MySQL | CGI programming for all data entry forms.
&q
Thanks to Ing. Edwin Cruz and George Law for pointing me in the right
direction, as previous messages in this thread indicate. phpMyAdmin now
working great with MySQL 5.0.
Have a loot on this:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
try a search for "old_password"
th_type'] = 'config';
I'm not even sure this is a MySQL question, but if someone can provide a
clue for me that would be great.
--
Amer Neely
Home of Spam Catcher
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
Perl | MySQL | CGI programming for all data entry forms.
"We m
n 'Open' because 1694 divides evenly
by 7, whereas 1693 doesn't.
This should do it:
SELECT Open.id, Open.day
FROM Open
LEFT JOIN Close ON Open.id=Close.id AND Open.day=Close.day
WHERE Close.id IS NULL
Regards,
Jeremy
Excellent! Thank you. I had tried a few left joins but none of th
an extra entry in 'Open' because 1694 divides evenly by 7,
whereas 1693 doesn't.
--
Amer Neely, Softouch Information Services
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
201-69471-9.
'MySQL' by Paul DuBois will also give you a good start to RDBMS concepts and
design.
- --
/* All outgoing email scanned by AVG Antivirus */
Amer Neely, Softouch Information Services
Home of Spam Catcher & North Bay Information Technology Networking Group
W: www.s
algorithm is:
// 1) Divide num by what (the base we want to round to. ie .01 for hundredths, 10
for tens)
// 2) Add .5 to num
// 3) Truncate the result (keep the integer part)
// 4) Multiply the result by num
- --
/* All outgoing email scanned by AVG Antivirus */
Amer Neely
a tab delimited file? You should be able to then import that
into MySQL. Or if
not, replace the tabs with pipes?
- --
/* All outgoing email scanned by AVG Antivirus */
Amer Neely, Softouch Information Services
Home of Spam Catcher & North Bay Information Technology Networking Group
W: www.
e the 'load data local' MySQL construct to populate your weather table.
- --
/* All outgoing email scanned by AVG Antivirus */
Amer Neely, Softouch Information Services
Home of Spam Catcher & North Bay Information Technology Networking Group
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
Michael Stassen wrote:
Amer Neely wrote:
Both scripts, which reside in the same directory on the server, are
run through the web browser. And they do access the same database, and
the same tables.
So, same web server, same mysql server, same connection settings. Good.
Does phpmyadmin connect
Michael Stassen wrote:
Amer Neely wrote:
Both scripts, which reside in the same directory on the server, are
run through the web browser. And they do access the same database, and
the same tables.
So, same web server, same mysql server, same connection settings. Good.
Does phpmyadmin connect
Michael Stassen wrote:
Amer Neely wrote:
OK, obviously a bit more background seems to be in order.
My site is hosted but I am not the administrator. I have 2 perl
scripts, behaving as already described. I also have phpMyAdmin access
to my databases. I don't have command line access t
Michael Stassen wrote:
Amer Neely wrote:
Amer Neely wrote:
Brian Reichert wrote:
On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote:
My question is, in my admin script I deleted a record, but it
still shows up using the other script. The admin script shows 102
records and the other
Michael Stassen wrote:
Amer Neely wrote:
Amer Neely wrote:
Brian Reichert wrote:
On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote:
My question is, in my admin script I deleted a record, but it
still shows up using the other script. The admin script shows 102
records and the other
Amer Neely wrote:
Brian Reichert wrote:
On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote:
My question is, in my admin script I deleted a record, but it still
shows up using the other script. The admin script shows 102 records
and the other shows 103. The record does show up in the
Brian Reichert wrote:
On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote:
My question is, in my admin script I deleted a record, but it still shows
up using the other script. The admin script shows 102 records and the
other shows 103. The record does show up in the 'public'
Brian Reichert wrote:
On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote:
My question is, in my admin script I deleted a record, but it still shows
up using the other script. The admin script shows 102 records and the
other shows 103. The record does show up in the 'public'
make sense. Can
someone shed some light on what might be happening here?
MySQL 4.0.20a for Win32
--
/* All outgoing email scanned by AVG Antivirus */
Amer Neely, Softouch Information Services
Home of Spam Catcher & North Bay Information Technology Networking Group
W: www.softouch.on.ca
E: [EMAI
_Members,Member_WebSkills,Web_Skills
WHERE Member_WebSkills.MemberID=NBIT_Members.MemID
AND Member_WebSkills.SkillID = $ThisSkillID2
OR Member_WebSkills.SkillID = 0
AND Visible='Y'
GROUP BY Lastname
});
--
/* All outgoing email scanned by AVG Antivirus /*
Amer Neely, Softouch Information Servi
ide a secure facility
so I haven't messed with SSL for mysql, so for instance it may use a
different port number etc.
Just my 2 cents worth...
Larry
-Original Message-----
From: Amer Neely [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 01, 2004 2:07 PM
To: MySQL
Subject: Remote access FRO
please?
--
All outgoing email scanned by AVG Antivirus
Amer Neely, Softouch Information Services | Home of Spam Catcher &
Research Central.
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
Perl | PHP | MySQL | CGI programming for all data entry forms.
"We make web sites work!"
--
MySQL
ed can be installed locally and there is just so
much more available, being a more mature language.
As far as accessing MySQL I don't see any advantage to using PHP over
Perl - all the same features are available. One thing I don't like about
PHP is having my form variables named af
1-9).
Any time you have more than one value in a field is an idication you
should consider making that field a separate table. In your case I'd
make a new table of 'pieces' and populate it with something that
identifies which client AND project each piece belongs to. Maybe a
]) +
(2 * a[9])
Reduce the sum modulu 11 to obtain integer b (>=1 b <=11)
The check digit is 11 - b
This is an error-detecting algorithm - it won't tell you where the error
is, only that there is one.
--
/* All outgoing email scanned by AVG Antivirus /*
Amer Neely, Softouch Informatio
;>>$0-err.txt");
print STDERR "\n",scalar localtime,"\n";
}
It prints the error file to $0 (the name of the current script) -err.txt
in the same directory as the script, so you don't have to chase it down
in the web server log files. Comment it out whe
mailto:[EMAIL PROTECTED]
> > +27 21 447 7440
> > Jam Warehouse RSA
> > Smart Business Innovation
> > http://www.jamwarehouse.com
> > **
Yes, excellent idea. It's the classic 'linked list' from my old Pascal
days. While playi
,
just by setting up and using appropriate tables. Is there some reason
why this can't be done in your case? Getting disk space is easy with
phpmyadmin, or just do a 'du'.
--
/* All outgoing email scanned by Norton Antivirus 2002 */
Amer Neely, Softouch Information Services
W: www.so
In my previous posting, I misspelled a name:
Paul Dubois should be Paul DuBois.
Sorry about that - I should know by now.
--
/* All outgoing email scanned by Norton Antivirus 2002 */
Amer Neely, Softouch Information Services
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
V: 519.438.5887
Perl | PHP
ialambton.org
Contacts (these only describe contacts)
ID: SAR0260
ContactEmail: [EMAIL PROTECTED]
OrgName1: Ray Beggs
OrgName1Position: Chairman
Blank8:
Blank9:
OrgName2: Norm Lamoureux
OrgName2Position: Database Manager
OrgName3: Sue Wright
OrgName3Position: Secretary (* note that I broke this
ing?
Why not ask your ISP whether MySQL is installed, and if so, use that?
You will need a 'front-end' to access the database once built, written
in PHP or Perl - dead easy. You can even install MySQL at home and then
use PHPMyAdmin to update the web server.
--
/* All outgoing email scan
yourself between each piece of the string.
This isn't really a MySQL question, but a perlish one.
--
/* All outgoing email scanned by Norton Antivirus 2002 */
Amer Neely, Softouch Information Services
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
V: 519.438.5887
Perl | PHP | MySQL | CGI programmin
t;fetchrow_array();
return $age;
}
You have to pass this subroutine 2 arguments when you execute it: $dbh
and $id before it will work.
--
/* All outgoing email scanned by Norton Antivirus 2002 */
Amer Neely, Softouch Information Services
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
V: 519.438.5887
of the table? That's about right,
since after installing phpMyAdmin, it gives me about the same number.
Thanks!
--
/* All outgoing email scanned by Norton Antivirus 2002 */
Amer Neely, Softouch Information Services
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
V: 519.438.5887
Perl | PHP | My
Eric Lamendola wrote:
>
> If you are using PHP,
>
> Then download phpMyAdmin from the website of the same name. It is the best
> PHP/Web based utility for connecting to a MySQL database.
>
> At 12:48 PM 9/11/02 -0400, Amer Neely wrote:
> >Is there a MySQL command
ory on the server, I have to ask my ISP to do a 'du' for me. I
maintain several databases for clients with my ISP, and since I'm paying
for disk space, I'd like to be able to pass that cost on to my clients.
--
/* All outgoing email scanned by Norton Antivirus 2002 */
Amer Neely, S
Michael J.
Hernandez
ISBN: 0-201-69471-9
or
'Data & Databases: Concepts in Practice' by Joe Celko
ISBN: 1-55860-432-4
They have both added much to my understandinf of RDBMs and information
management.
--
/* All outgoing email scanned by Norton Antivirus 2002 */
Amer Neely, Sof
e wondering why I set the Sequence field as a
decimal, it's the only way I could think of to deal with releases
containing more than 1 CD. So, CD1 sequences look like 1.01, 1.02 ...
1.10 and CD2 sequences look like 2.01, 2.02, ... 2.13 and so on.
--
/* All outgoing email scanned by Norton Antivirus
1 | 1 | A|
|705 | 1 | 1 | A|
|709 | 1 | 1 | A|
++++--+
4 rows in set (0.05 sec)
That should get you on your way.
--
/*
x27;s referring to the
client - remember there are 2 things going on. First you have to start
the server (mysqld for example), then you need to start a client (mysql)
to access the server.
--
Amer Neely, Softouch Information Services
Per
:
LOAD DATA LOCAL INFILE "yourfile.txt" INTO TABLE LevelOne FIELDS
TERMINATED BY '\t' LINES TERMINATED BY '\r\n'
This mixup will cause the duplicate key error as well I believe, since
the line pointer is not moving forward in your file.
--
/* All outgoing email scanned b
ardless that I had set it at 1000.
--
/* All outgoing email scanned by Norton Antivirus 2002 */
Amer Neely, Softouch Information Services
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
V: 519.438.5887
Perl | PHP | MySQL | CGI programming for shopping carts, data entry
forms
Paul DuBois wrote:
>
> At 17:53 -0400 5/13/02, Amer Neely wrote:
> >Paul DuBois wrote:
> > > >> >> AN> The values I'm inserting for
> >> >> >> AN> UserID are all 'null' (without quotes).
>
Paul DuBois wrote:
>
> At 17:41 -0400 5/13/02, Amer Neely wrote:
> >Paul DuBois wrote:
> >>
> >> At 15:23 -0400 5/13/02, Amer Neely wrote:
> >> > > Amer,
> >> >> Monday, May 13, 2002, 2:03:28 AM, you wrote:
> >> >>
Curtis Maurand wrote:
>
> How about:
>
> UserID SMALLINT UNSIGNED AUTO_INCREMENT NULL PRIMARY KEY DEFAULT 1000
>
> Curtis
>
Good suggestion. But it too returns 1..7 when I do a 'select userid from
respondents'.
> Amer Neely said:
> >> Amer,
>
Paul DuBois wrote:
>
> At 15:23 -0400 5/13/02, Amer Neely wrote:
> > > Amer,
> >> Monday, May 13, 2002, 2:03:28 AM, you wrote:
> >>
> >> AN> Win/98
> >> AN> MySQL 3.23.46
> >>
> >> AN> I'm trying to use AUTO
'dummy' record starting at 1000, I want MySQL to
do that, like it says in "MySQL" by Paul DuBois [p.94, chap.2.]. Again,
this works in interactive mode, but NOT in batch mode. Can you or
someone explain how this can be done in batch mode?
> AN> The values I'
o errors, but when I populate the table with values (also from a file),
the values for UserID start at 1, not 1000. The values I'm inserting for
UserID are all 'null' (without quotes).
--
/* All outgoing email scanned by Norton Antivirus 2002 */
Amer Neely, Softouch Information Services
quot;MySQL and Perl for the Web" by John Dubois is
excellent.
New Riders ISBN:0-7357-1054-6
--
/* All outgoing email scanned by Norton Antivirus 2002 */
Amer Neely, Softouch Information Services
W: www.softouch.on.ca
E: [EMAIL PROTECTED]
V: 519.438.5887
Perl | PHP | MySQL | CGI programming fo
gt;finish;
> $dbh->disconnect;
>
>
> print <
>
> EoB
> *
>
> Thank you
> Aman
With Perl you have a few options when it comes to quoting strings.
You can 'escape' a set of quotes as a wrapper. (
\"$for
books
order by publisher");
$result=mysql_query($query);
if (!$result) die ("Query 164 failed."); # you can of course do whatever
you like here
for ($i=0; $i <= $PubCount; $i++)
{
while ($records=mysql_fetch_array($result))
{
e above the LIKE statement
> would be: WHERE category LIKE '%|4|%' AND LIKE '%|7|%').
>
One thing you could do is add a little programming to split the entry
into its parts, once retrieved, then run your select on those. But a
better solution would be to re-design your
;SELECT Artist
FROM Artists
WHERE Artist LIKE \"%$InArtist%\" ");
$result=mysql_query($query);
if (!$result)
{
die ("query failed.");
}
$ArtistCount=mysql_num_rows($result);
H
e above the LIKE statement
> would be: WHERE category LIKE '%|4|%' AND LIKE '%|7|%').
>
One thing you could do is add a little programming to split the entry
into its parts, once retrieved, then run your select on those. But a
better solution would be to re-design your
y. Are these your actually working statements, or
just typos. Please use cut/paste if you are giving code to someone to
check for you.
--
Amer Neely [EMAIL PROTECTED]
Softouch Information Services: www.softouch.on.ca/
Perl / PHP / MySQL / CGI programming for shopping carts, data entry
form
> Is this a bug in MySQL 3.23.37? Could it have something to do with my OS
> (OpenBSD 2.9)? Or am I doing something wrong with the statement "update
> time_worked set total = start - finish;"?
Umm. Don't you mean 'finish-start'?
--
Amer Neely [EMAIL PROTEC
t of doing, to kill slow UNIX and DOS programs), that
> terminates the MySQL prompt entirely and I have to log back in.
>
> -Bennett
>
> [EMAIL PROTECTED] http://www.peacefire.org
> (425) 649 9024
>
Use '\c' to clear / cancel the last command. Did you not c
s are going to be variables, try something like:
$last=$dbh->quote("Beck");
$first=$dbh->quote("Jeff");
$query=qq{insert members (last_name,first_name) values ($last,$first);
$result=mysql_query($query);
Another trick I use for debugging is to put the following at the
pache and MySQL servers and it still
breaks every time I try to save query output to a file. Anyone have any
ideas why?
--
Amer Neely [EMAIL PROTECTED]
Softouch Information Services: www.softouch.on.ca/
Perl / PHP / CGI programming for shopping carts, data entry forms.
"We make web
are stored)
> But keep getting the error.
I'm using the same arrangement and found I had to put my data files
under my cgi-bin directory. But when I upload the code to my ISP, they
can be stored in the same directory as the script. This tells me it is
likely a configuration
ample: To round -758.437 to nearest 1/100th
1) -758.437 / 1/100 = -75843.7
2) -75843.7 - .5 = -75844.2
3) int(-75844.2) = -75844
4) -75844 * 1/100 = -758.44
--
Amer Neely [EMAIL PROTECTED]
Softouch Information Services: www.softouch.on.ca/
Perl / PHP / CGI programming for shopping carts, data entry form
u wish, or have HTML
> validator to validate it for you (available at w3c.org)
>
> Good luck
>
> --
> sherzodR
>
> On Mon, 26 Nov 2001, Amer Neely wrote:
>
> >I've read with interest the posts on Netscape not rendering HTML
> >correctly. I can add
y) it will stop partway
through the HTML.
An earlier post mentioned the possibility of the code having NUL
characters in the HTML stream. I'll try to check into that and post the
results. If someone can shed more light on this I know a lot of people
would appreciate it. Thanks in advance.
-
78 matches
Mail list logo
