Hi all,
I'm getting this error with MyODBC v2.50 and v3.51. I'm running MySQL v4.06:
Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'open'
/mshe/gallery/picture.asp, line 45
The code for that area is:
strConn = "DSN=binaryio;"
Set objConn = Server.CreateObject("ADODB.Con
Hello all,
Why can I not create a File DSN using MyODBC 2.50.39 on Windows 2000?
I have installed MySQL v3.23.52-max-nt and MyODBC 2.50.39 on a Windows 2000
machine. While I can create both System and User DSNs, I cannot create a
File DSN. When I try I get the error message "File Data Source w
On Fri 2002-12-27 at 23:45:25 -0800, [EMAIL PROTECTED] wrote:
>
> for some reason i have a page in asp just showing code and no actual
> visual data. any ideas ?
Ask in a Microsoft / ASP related forum?
I do not see how your question has anything to do with MySQL, so it's
off-topic here. This lis
At 18:38 -0800 12/27/02, Arun Kumar wrote:
Dear All,
I have a table 'X', I want to display the record
in this table 'X' which has occupied the maximum
number of bytes, i.e i want a query/queries to
display the record with maximum size. I would also
like to print the
record size as well.
Any
At 16:44 -0800 12/27/02, Matt Solnit wrote:
===
Bug report -- MySQL v4.06, binary distribution
===
--
Machine specs:
--
Compaq Presario desktop
512 MB RAM
Windows XP Professional SP1
-
Hi.
On Fri 2002-12-27 at 17:19:26 -0800, [EMAIL PROTECTED] wrote:
> I looked through the documentation, but I couldn't find anything relevant
> to this, so here goes...
>
> I have MySQL with databases running on a Solaris machine, and MySQL with
> different databases running on an Irix machine.
sql,query,queries,smallint
for some reason i have a page in asp just showing code and no actual visual
data. any ideas ?
plz
Charles
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://l
ok, just answering my own question here.
found it.
"describe " contains "auto_increment" in the "extra" column,
which gives me what I want.
sql,query
- Original Message -
From: "Greg Matthews" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, December 28, 2002 8:34 AM
Subject:
In the last episode (Dec 27), John Coder said:
>
>
> Hi all,
>
> I am kinda of a beginner in this mysql thing, so please excuse the dumb
> and amateur question:
>
> i have a table with several date fields: day, month, year, hour, minute
> and i need to order them by a specific
Hi all,
I am kinda of a beginner in this mysql thing, so please excuse the dumb
and amateur question:
i have a table with several date fields: day, month, year, hour, minute
and i need to order them by a specific "string that includes them, like
this:
"year/mont
Hi all,
I am kinda of a beginner in this mysql thing, so please excuse the dumb
and amateur question:
i have a table with several date fields: day, month, year, hour, minute
and i need to order them by a specific "string that includes them, like this:
"year/month/day - hour/minute"
basi
Dear All,
I have a table 'X', I want to display the record
in this table 'X' which has occupied the maximum
number of bytes, i.e i want a query/queries to
display the record with maximum size. I would also
like to print the
record size as well.
Any help in this front would be great.
Arun
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I have, with the generous help of Michael Babcock, worked out what I
think is a reasonable way to protect the credit card numbers in my
database from improper access. Basically, only the server (better yet,
some other server) can access th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
What's the best way to change your database schema around if you have
data in it? How do you know when to simply ALTER TABLE and when to dump
the whole thing (perhaps doing specific SELECTs to spit out the data
you'd like to have in the en
I looked through the documentation, but I couldn't find anything relevant
to this, so here goes...
I have MySQL with databases running on a Solaris machine, and MySQL with
different databases running on an Irix machine. I want to integrate some
of the databases from the Solaris machine into th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I'm working up the schema for my application and, as you can imagine,
starting over and reloading numerous times :-) In fact, I intend for the
script to be an install script, run on a new installation of the software
to set things up.
The
===
Bug report -- MySQL v4.06, binary distribution
===
--
Machine specs:
--
Compaq Presario desktop
512 MB RAM
Windows XP Professional SP1
Problem description:
sql, query, mysql,"I'm a lumberjack and I'm ok" for he spam police.
Has anyone been successful in signing up for the certification exam?
I've entered dates going up to Jume 30,2003 to schedule an exam and all
I get back is exam not available.
John
---
What language are you using to pull the data? ASP? PHP? VB?
At 11:23 PM 12/26/2002 -0800, tan tan wrote:
Hi,
Is anyone know how to view image that is stored in
mysql as binary format to
a browser ?
Thank you.
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage :
At 22:34 +0100 12/27/02, Martin Skjöldebrand wrote:
Sorry for this newbie question (my MySQL-book is at work).
I want my ID field to start with value 1000 and (preferably)
auto-increment to 2000 is this possible to specify in my table somehow?
This question is ambiguous. Do you mean that you wa
On 27 Dec 2002, at 16:54, Fernando Grijalba wrote:
> I believe it is
>
> CREATE TABLE{
> id AUTOINCREMENT=1000,
> fld TYPE
> }
Where did you see anything like that in the documentation?
I believe what Martin wants is something like
ALTER TABLE table_name AUTO_INCREMENT = 1000;
[Filter
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg Matthews wrote:
All,
I'd like to be able to query MySql using the JDBC driver to determine which
tables have auto incremented columns.
In MSSQL I can retrieve data from the syscolumns and sysobjects tables to
find out which columns are IDENTITY
fre 2002-12-27 klockan 22.34 skrev Martin Skjöldebrand:
> Sorry for this newbie question (my MySQL-book is at work).
> I want my ID field to start with value 1000 and (preferably)
> auto-increment to 2000 is this possible to specify in my table somehow?
> (I know auto-increment, just how do I set t
I believe it is
CREATE TABLE{
id AUTOINCREMENT=1000,
fld TYPE
}
HTH
JFernando
** sql **
-Original Message-
From: Martin Skjöldebrand [mailto:[EMAIL PROTECTED]]
Sent: December 27, 2002 16:34
To: MySQL epostlista
Subject: start value in table
Sorry for this newbie question (my MySQL
All,
I'd like to be able to query MySql using the JDBC driver to determine which
tables have auto incremented columns.
In MSSQL I can retrieve data from the syscolumns and sysobjects tables to
find out which columns are IDENTITY columns, but have had no luck trying to
do something similar in MySq
Hello All,
This mail list is about my last hope as I tried everything I could possibly
find online related to this problem and I've had no luck (it doesn't appear
to be the GLib problem that everyone keeps talking about).
Machine Specifics:
Web Server (dedicated):
P4 2gHz with 2gig memory
RedHat
Sorry for this newbie question (my MySQL-book is at work).
I want my ID field to start with value 1000 and (preferably)
auto-increment to 2000 is this possible to specify in my table somehow?
(I know auto-increment, just how do I set the starting value).
What would the appropriate SQL-sentence to u
Hey there,
Does anyone know why a query would take a very long time (>15 minutes) from
my CGI script, yet takes less than a second if I cut-and-paste into my
console?
The query itself amounts to this:
SELECT ((a.PRECIP>(0.00*AVG(b.PRECIP/100, a.DATE
FROM clim_data AS a
LEFT JOIN clim_data as
Hello,
I'm a new user to MySql and I've just starting to download and install
MySql.
I've a question:
Does each version of MySql has binary AND src version for installation ?
I've been to http://www.mysql.com/downloads/ for MySQL 4.0.7 and I found
binary version only.
Does the majority of MySq
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.7, a new version of the popular Open Source Database, has been
released. It is now available in source and binary form for a number of
platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
Around the tim
Well, I decided to stop being a moron and think inside the box and figured
out that it was the total and utter lack of keys and indexes on the newly
created MySQL tables which caused the execution time problem. So, the
problem turned out to be, "I'm a moron."
Thanks everyone who replied!
Here's
On Fri, 27 Dec 2002 13:11:42 -0500, Asendorf, John wrote:
>SELECT Dealers.*, SQRT(POW((2285-Zips.North),2)+POW((4760-Zips.West),2)) AS
>Distance
>FROM Dealers
>INNER JOIN Zips ON Dealers.Zip = Zips.Zip
>ORDER BY POW((2285-Zips.North),2)+POW((4760-Zips.West)),2)
Off the top of my head have
ÄãÏàÐÅÂð£¿ÔÚÎÒÃÇÃÀºÃÉú»îµÄÉí±ß£¬Õý·¢Éú×ÅÁîÈË´¥Ä¿¾ªÐÄ£¬²Ò²»È̶õÄʼþ£¡
ÎÒÃÇ˵¿´µ½µÄÊÇ£º2700¶à¿ÚÀ§¿àµÄÅ©Ãñ£¬ÕýÔÚÉúËÀÏßÉϼèÄѵÄÕõÔú×Å£¡£¡
ÎÒ´ú±í2700¶à¿ÚÎÞ¹¼ÎÞÖúµÄËûÃÇ£º¿ÒÇóÉÆÁ¼µÄÄú£¬¿´ÍêÕâ·âÕæʵµÄÓʼþ£¡
µØµã£ººÓ±±Ê¡±£¶¨ÊÐÐÂÊÐÇø¸»²ýÏç´ó×£Ôó´å
ºÓ±±Ê¡±£¶¨Êи»²ýÏç Ï絳ίÊé¼Ç--Àîºé¸Õ
´ó×£Ôó´
I'm trying to get results back from an sql query in the easiest way to
handle in my script.
table 'categories' and table 'restcat' (restaurant categories).
I'd like to construct a query where I can look up a specific restaurant
id, yet somehow related it to the categories table so that instea
OK, I've figured out how to fix the SQL (was searching for "equations" and
"calculations" when I should have been looking for "math" in the docs!)...
but now it takes EONS longer than the Jet calculations...
SELECT Dealers.*, SQRT(POW((2285-Zips.North),2)+POW((4760-Zips.West),2)) AS
Distance
FROM
At 14:56 +0200 12/27/02, Patrascu Eugeniu wrote:
Hi,
I have a problem calculating birthdays in sql. Here goes my setup:
I have a database that contains the bithdays of a number of people,
and I want to know when there birthday is to congratulate them.
The thing is that I want to now that a day
Hi,
I think you can try to use TO_DAYS() function;
eg:
select TO_DAYS('2002-12-28')-TO_DAYS(NOW());
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
On 27 Dec 2002, at 1:04, Peter D Bethke wrote:
> My table "matchups" has columns for team1_id, team2_id, team1_score and
> team2_score.
>
> I can write a simple calculation using the api I use (Lasso - similar in
> function to php) and display the results programmatically in the html
> output, no
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Sun, 22 Dec 2002 [EMAIL PROTECTED] wrote:
> >Description:
> The unpacked source differs from the source tree after a
> ./configure && make && make distclean. This should be considered
> as Makefile bug, as e.g. package mainta
Hi,
I think you can try to use TO_DAYS() function;
eg:
select TO_DAYS('2002-12-28')-TO_DAYS(NOW());
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
On fredag, dec 27, 2002, at 16:19 Europe/Copenhagen, Paul DuBois wrote:
At 15:18 +0100 12/27/02, Jonas C. Voss wrote:
Actually, I tried a plethora of formats including the following:
1139
113900
1.139,00
1,139.00
1139,00
1139.00
But MySQL interprets them all as 1.13.
Based on that last stat
I'm attempting to convert an application from ASP/Access to PHP/MySQL My
problem is in the SQL conversion.
The SQL determines distance between two zip codes:
This is the Access original:
SELECT Dealers.*, ((2285-Zips.North)^2+(4760-Zips.West)^2)^.5 AS Distance
FROM Dealers INNER JOIN Zips ON De
At 15:18 +0100 12/27/02, Jonas C. Voss wrote:
Hi all,
I have a text-file containing products and their prices for a small
shop. I upload and insert the text-file into a MySQL table using the
LOAD DATA LOCAL INFILE command, and it really works a treat.
My problem is that when inserting prices o
Hi,
Sorry I didn't check in the pdf. Thanks guys.
By the way, I found there is an article from
www.onlamp.com/lpt/a/a370 it uses the php to do the
same thing.
Thanks once again.
Tan Tan
--- Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 0:43 -0800 12/27/02, tan tan wrote:
> >Hi Paul
> >I went to the
Since 4.03 version under windows XP with SP1 (today I am using 4.0.7
max-nt) , on a slave host, when I stopped the service Mysql, via MYSQLADMIN
the semaphore became yellow instead red. The only solution is shutdown the
pc. Also when I run the command slave stop the process hang and not became
i
On Fri, 27 Dec 2002 07:15:01 -0600, Paul DuBois wrote:
>At 0:43 -0800 12/27/02, tan tan wrote:
>>Hi Paul
>>I went to the site and I can't look for the page.
>>If you dont' mind to get the the exact url.
>>Thanks.
>
>Odd. Anyone else out there have trouble with that URL?
>
>http://www.kitebird.com
Chung,
> Warning: thr_alarm queue is full
> What's this? Is it serious problem?
Looking for "thr_alarm" in the MySQL Manual, I find this:
If mysqld is compiled with -DUSE_ALARM_THREAD, a dedicated thread that
handles alarms is created. This is only used on some systems where
there are problem
9:15 AM
Friday
12/27/2002
I'm trying to connect an VB-6.0 application to a remote MysQL DB and
am running into difficulty. In particular I get an: 'Runtime error
3709': Connection cannot be used to perform operation. It may be
closed or invalid in this context.' I'm certain the conne
Hi all,
I have a text-file containing products and their prices for a small
shop. I upload and insert the text-file into a MySQL table using the
LOAD DATA LOCAL INFILE command, and it really works a treat.
My problem is that when inserting prices of more than one thousand, the
field it gets in
Not tested. You should have table "dates" with columns "email" and
"birthday". "birthday" is in format "27 December"
#!/bin/sh
dbname="birthday"
dbhost="localhost"
dbuser="alpha"
dbpass="beta"
persons=`mysql -h$dbhost -u$dbuser -p$dbpass $dbname --execute="select
email from dates where date_for
At 0:43 -0800 12/27/02, tan tan wrote:
Hi Paul
I went to the site and I can't look for the page.
If you dont' mind to get the the exact url.
Thanks.
Odd. Anyone else out there have trouble with that URL?
http://www.kitebird.com/mysql-perl/downloads.php
http://www.kitebird.com/mysql-perl/webdb/
Hi!
Buildmaster Lenz Grimmer of MySQL AB informed me that the last changeset in
4.0.7 was from Dec 20th, 2002.
That means that InnoDB-4.0.7 is essentially the same as InnoDB-4.0.6, and
the changes listed below will only appear in MySQL-4.0.8!
I apologize for the confusion. It was my error not to
Hi,
I have a problem calculating birthdays in sql. Here goes my setup:
I have a database that contains the bithdays of a number of people, and
I want to know when there birthday is to congratulate them.
The thing is that I want to now that a day before their birthday.
Therefore I need a way to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello tan,
Friday, December 27, 2002, 8:43:25 AM, you wrote:
> Hi Paul
> I went to the site and I can't look for the page.
> If you dont' mind to get the the exact url.
> Thanks.
you don't find it because it's an pdf file
http://www.kitebird.com/my
What I really want is to replicate data from a database (MySQL) into another
(MS SQL Server).
- Mensagem original -
De: Kevin Wise [SMTP:[EMAIL PROTECTED]]
Enviada em: quinta-feira, 26 de dezembro de 2002 19:43
Para: Micheli
This is a PHP question.
Visit:
http://www.php.net/manual/en/function.mysql-connect.php
for more information about the function mysql_connect.
Or:
http://www.php.net/links.php
To find some tutorials to get you going.
You really should upgrade to a newer release of PHP.
Have fun,
B.
-Oo
Sir,
I am facing problem in one function , actually in my table
there is two field: id, and password and I am checking the id
field for any user who is added to the friendlist of another user,
like in yahoo messenger.
MYSQL *conn;
MYSQL_RES *res_ptr;
MYSQL_ROW sqlrow;
FILE *fp;
/**
Segun el manual de mysql, en los archivos de distribución debe existir un
txt 'Docs/mysqld_error.txt' con un detalle de la lista de mensajes de error.
En mis archivos de distribución no he sido capaz de hallar dicho fichero.
Alguien que lo tenga seria tan amable de enviarmelo?
Gracias
___
Hi Paul
I went to the site and I can't look for the page.
If you dont' mind to get the the exact url.
Thanks.
--- Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 23:23 -0800 12/26/02, tan tan wrote:
> >Hi,
> >
> >Is anyone know how to view image that is stored in
> >mysql as binary format to
> >a brow
At 23:23 -0800 12/26/02, tan tan wrote:
Hi,
Is anyone know how to view image that is stored in
mysql as binary format to
a browser ?
Thank you.
Once you pull your image data from MySQL (I assume you're using some
kind of script for this), then you do this the same way you'd do it
if MySQL were
60 matches
Mail list logo
