I can not confirm this, but it would make sense that this was updated in
4.05. After all, you are only deleting your records, not re-building the
table. The new functionality you describe is also present in SQL Server and
Oracle.
Filter: Mysql , sql , query
Good Luck,
Dennis Salguero
First rule of JavaScriptis you don't talk about JavaScript!
Second rule of JavaScript is you _don't_ talk about JavaScript!
But seriously, remember that JavaScript has very, very few input/output
functions that can be used outside of a browser. There really isn't a way to
create a JavaScript conn
>
> SELECT name, table1.position, table2.position
>
> FROM table1,table2
> WHERE table1.name=table2.name;
>
> Regards,
> Jocelyn
> - Original Message -
> From: "Dennis Salguero" <[EMAIL PROTECTED]>
> To: "Osman Omar" <[EMAIL PROT
>
> SELECT name, table1.position, table2.position
>
> FROM table1,table2
> WHERE table1.name=table2.name;
>
> Regards,
> Jocelyn
> - Original Message -
> From: "Dennis Salguero" <[EMAIL PROTECTED]>
> To: "Osman Omar" <[EMAIL PROT
You might want to add some unique IDs or something else in common to make
this query a bit better, but the following is what you should be doing:
SELECT name, table1.position, table2.position
WHERE table1.name=table2.name
Good Luck!
Dennis
- Original Message -
From: "Osman Omar" <[EMAI
- Original Message -
From: "Paul van Brouwershaven" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, November 16, 2002 8:58 AM
Subject: RE: SQL Query
> I'ts a dump of an other database with more than 4 million records
Yeah, but that still doesn't mean that you can't use the ea
This is an interesting question and I hope you get a lot of responses since
I'm sure that I will only cover a small percentage of what you will actually
need.
The primary thing to remember is that you are moving from what could be
considered a self-contained development environment with a solid GU
You can't decrypt the password from MySQL, instead, you should encrypt the
input from PHP and then do the string comparison.
Good Luck,
Dennis
- Original Message -
From: "Elaine Kwek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 9:27 PM
Subject: password f
It looks like you're missing a comma in your SQL statement in between
placeOfBirth and civilStatus.
Good Luck!
Dennis
- Original Message -
From: "Mylin Campos" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 23, 2002 2:13 AM
Subject: sql problem
>
> Hi all,
>
> I j
Have you tried using a GROUP BY statement - maybe something like:
SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs FROM oceandata
GROUP BY ExpDepDate, ActArrDate, Ref
Good Luck!
Dennis
- Original Message -
From: "Morsky Juha" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday
My question pertains to the implementation of stored procedures in MySQL.
According to the MySQL documentation, this is scheduled for the 4.1 release.
Is this still accurate?
When will we be seeing the first downloads of 4.1 available?
Thanks,
Dennis
***
- Original Message -
From: "John Mayson" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, December 24, 2001 4:40 PM
Subject: How many tables?
> How far should I go with this? Right now when I look at my frequency
table, it's mostly a
> list of numbers. I suppose t
meant as a robust managing or editing tool.
If anyone thinks that they may use a tool like this for MySQL, or want to
request a copy, please e-mail me. Any other thoughts on a "release
structure" are also welcome.
Thanks,
Dennis Salguero
an board - easy to configure and rig to the case), 512Mb RAM and 30 gb
hard-drive - works like a charm.
Good Luck,
Dennis Salguero
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com
-
s.
> Note also that there's a good chance your question has been answered in
the
> past. Please spend a minute or two checking one of the MySQL List
archives,
> eg. the one at the MySQL site (http://lists.mysql.com/).
See above; this archive is a
e
some resources for that already out there.
Good Luck,
Dennis Salguero
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com
-
Before posting, please check:
're much better off
creating two connections rather than having two simulatneous servers.
Good Luck,
Dennis Salguero
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com
--
I'm pretty sure that the "complete" implementation is not done yet, in the
sense that there is no RDI enforcement.
Good Luck,
Dennis
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com
- Original Message -
From: "Sandra Rov
Take a look at:
http://www.mysql.com/doc/M/i/Missing_Foreign_Keys.html
Basically, MySQL does not support foreign keys. Therefore, referrential data
integrity (RDI) is also not available.
Good Luck,
Dennis
**
Beridney Computer Services
http://www.beri
- Original Message -
From: "Deryck Henson" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, September 04, 2001 10:54 AM
Subject: Trouble w/MySQL Server
> Well, I've fixed the problem with mysqld.exe and innodb, but the server
wont
> connect with my ASP pages. Any ideas
- Original Message -
From: "Mike Jackson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Stefan Hinz" <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 1:59 PM
Subject: Re: ldap authentication for mysql
> PHP is not the solution. On the other hand, Zope just might be... I am
> studyi
Naturally, the answer is: it depends.
What is your application supposed to do? What languages are you versed in?
Does your data need to be accessible via the web?
At the very least, you will be needing the ODBC driver for MySQL, MyODBC.
It's available from the MySQL web site. Other than that, ke
Are you looking for:
SELECT table1.name, table2.subject
FROM table1, table2
WHERE table1.id=table2.student_id
Good Luck,
Dennis
**
Beridney Computer Services
http://www.beridney.com
- Original Message -
From: "Jamie Burns" <[EMAIL PROTECTED]>
I prefer to use Auto_Increment for ease of use. In addition, I don't think
that MySQL supports sequences outright (like you may be used to with
Oracle). There are some workarounds availabe within the MySQL manual, do a
search with "sequences".
Good Luck,
Dennis
**
- Original Message -
From: "Jay McGarry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 7:57 AM
Subject: Mysql
> what's the easiest way to transfer a local database to a remote one?
Depends on many factors really. Are you doing this as a one-off thing or
some
You COULD use the ADO data control, but I wouldn't recommend it. There are
still some ADO methods and objects that are not fully supported and you will
most likely generate some strange errors. It may be a pain to do it, but
you'll be better off doing it the "old-fashioned" way with your own
conne
- Original Message -
From: "David Rickerl" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 22, 2001 2:57 PM
Subject: MYODBC & DSN creation
> Have successfully installed MYODBC, driver shows up in Windows Control
> Panel,
I assume that you mean in the Data Sources window/u
- Original Message -
From: "Oliver Hohlfeld" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 8:13 AM
Subject: Converting ACCESS or EXCEL Data to MySQL
> I'm currently working on a bigger Project.
Uh oh, wasn't that the plot to "The Spanish Prisoner" ?? ;-)
>
- Original Message -
From: "Chris Cameron" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 01, 2001 2:27 PM
Subject: Storing Credit Cards
> One of the ideas was to have the users password encrypted as an md5 hash,
> and then to encrypt the users CC with their password. So
- Original Message -
From: "Jason Brunk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 8:18 PM
Subject: Re: Connecting to MySQL w/VB
> i know i am definitly knew at this, but his permissions could be set more
or
> less for read only.
Yes, it's possible that t
- Original Message -
From: "Robert Skinner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 7:44 PM
Subject: Connecting to MySQL w/VB
> I am trying to connect to MySQL using a connection string using VB6. The
> read part is great but I don't seem to be able to
- Original Message -
From: "Charles Henderson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 4:33 PM
Subject: MS IIS web logfiles
> How can I get mySQL to create a table for a IIS web logfile (*.log) ? The
> file is very long (maybe 1 million records +) and t
There are many ways to do this - I'm assuming you want to do this on an
Windows box.
One way is through MyODBC. It's an ODBC driver that you can install on your
server, available from the MySQL web site. From there, all you have to do is
create a new DSN, either through the CF Admin or Windows. Y
Danger, danger! UltraDev code ahead!
First off, do yourself a favor and try to ween yourself off UltraDev and
learn ASP and SQL from a good book and write the code yourself. It will
probably save you many headaches in the future.
I think that your problem might be twofold and they are related.
It depends on what you mean by "without using ODBC".
You CAN connect to a MySQL database without a DSN name, you can just declare
an IP address and a DB name, but I'm pretty sure that this method still uses
the MySQL ODBC driver and it must be installed on the server.
You CAN NOT, as far as I kn
I'll add my two cents along with what everyone else has said because I have
worked with all three.
In short, MySQL works best when you are strictly using ADO and not DAO. On
top of that, it's fast becoming (if it's not already) an ADO world! So, in
the long run you might be better off converting
f the options within the FormatDateTime function
will format the date to the -MM-DD format used by MySQL (and Oracle too,
btw). Therefore, use the following function:
<%
Function MakeDate(strDate)
'Written by Dennis Salguero
If IsDate(strDate) Then
Dim m
Dim d
Dim y
m =
If it's not too late, may I suggest that you re-structure your database
while using normalization & RDB rules???
The database that you are looking for is actually very straight-forward and
I'm sure it's been done many times before. To get you started, think about
how you would see these products
I believe that stored procedures are still on the TODO list, but that might
not fit into your client's plans.
Recall that stored procedures are a form of "compiled" SQL code. Therefore,
if you want, you could take that SQL code, in the stored procedure, and put
it into your VB application and exe
Original Message -
From: "Warren van der Merwe" <[EMAIL PROTECTED]>
Subject: MSACCESS v.s. MYSQL
> I am looking at alternate databases and have been testing with MYSQL for
> some days now. I have noticed a couple distinct differences in some of the
> SQL statements, but have managed to
- Original Message -
From: "Matteo" <[EMAIL PROTECTED]>
Subject: MySQL and MyODBC
> i'm developing a software in V.b.6 based on MySql d.b.
> Early i'll need to create a package in order to install this software.
> So, i need to know if i must to include, into the packege, only d.b.
>
> Is it possible to use ASP with MySQL? I found a link
> in the documentation to
> www.amedea.cz/mysqlx/index.html which was supposed to
> have a downloadable MySQL COM extension but the
> website was not found.
Yes, it's possible to use ASP with MySQL. In a nutshell, you need to make
sure that
- Original Message -
From: "Pat Sherrill" <[EMAIL PROTECTED]>
Sent: Saturday, April 14, 2001 7:34 AM
Subject: Re: ADO RS.Update problem
> Just a quick note about RecordCount. RecordCount only returns the number
of
> records or rows from the recordset that have been 'seen'. Therefore it
Unfortunately, it doesn't seem like all ADO methods and properties and
supported when working with MySQL. Update, as you know, is one of them,
along with others like RecordCount.
I would recommend using a connection object and then passing an SQL
statement to run. If need be, you can add the resu
- Original Message -
From: "Samantha Savvakis" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 12:39 AM
Subject: ADO problem with MYSQL datetime column
> I have a table that I'm querying that has 'datetime' columns. If these
> columns are null or 0 - "00
- Original Message -
From: "Ramasamy Palaniappan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 6:53 AM
Subject: help on mysql tables
> I have created the following table:
>
> create table test(name varchar(10) NOT NULL);
> query is ok
Yes, but notice that yo
Original Message -
From: "Bryan Wheelock" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 5:31 PM
Subject: Is email unique?
> I have been trying to think of naturally occuring unique identifiers that
> people might use on the internet.
> I think that e-mail a
I think that this is highly dependant on the language you are using to
display your results; you would probably get more help if you included that.
Good luck,
Dennis
**'
Beridney Computer Services
[EMAIL PROTECTED]
P: 703-566-3196
http://www.beridney.c
> 1. Can CF work with mySQL via myODBC on win2k?
Of course. That's the beauty of ODBC, as long as your language can call an
ODBC connection (which CF can of course) you can use it.
> 2. Is there a better way to use CF and mySQL?
With what goal in mind? If you're worried about the overhead tha
Actuall, I agree with the earlier post, I did find that sometimes the
download connection to SourceForge quits half-way during the download.
My recommendation would be to try one of the mirror sites and download from
there since I don't think that they use SourceForge.
Good Luck,
Dennis
-
Please check the archive.
I posted a few functions last week that may be of use to you. Don't want to
re-post since your question is slightly OT.
Good luck,
Dennis
***
Beridney Computer Services & Beridney Talent
http://www.beridney.com
-
51 matches
Mail list logo
