Re: DELETE with no WHERE clause

[Dennis Salguero]

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

- Original Message -
From: Gordon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 23, 2002 3:21 PM
Subject: DELETE with no WHERE clause


 DID DELETE FROM XXX with no where clause stop acting like truncate in
 4.0.5?

 In 3.23.51 and earlier versions of 4.0.x

 mysql delete from product_order_main;
 GIVES THIS
 Query OK, 0 rows affected (0.10 sec)

 AND RESETS THE AUTOINCREMENT VALUE

 mysql insert into product_order_main values
 (null,'rcl1','hh','ab','pending','yes','20021223',now());
 Query OK, 1 row affected (0.10 sec)

 mysql select * from product_order_main;
 +-+-+-+-+-+-+---
 -+-+
 | ordr_ID | cpny_ID | prod_ID | acct_ID | pord_Status | pord_Active |
 pord_Timestamp | pord_Create |
 +-+-+-+-+-+-+---
 -+-+
 |   1 | rcl1| hh  | ab  | Pending | Yes |
 2002122300 | 2002-12-23 11:14:18 |
 +-+-+-+-+-+-+---
 -+-+
 1 row in set (0.10 sec)

 
 

 USING 4.0.5 I GET

 mysql delete from product_order_main;
 Query OK, 1 row affected (0.00 sec)

 mysql insert into product_order_main values
 (null,'rcl1','hh','ab','pending','yes','20021223',now());
 Query OK, 1 row affected (0.00 sec)

 mysql select * from product_order_main;
 +-+-+-+-+-+-+---
 -+-+
 | ordr_ID | cpny_ID | prod_ID | acct_ID | pord_Status | pord_Active |
 pord_Timestamp | pord_Create |
 +-+-+-+-+-+-+---
 -+-+
 | 225 | rcl1| hh  | ab  | Pending | Yes |
 2002122300 | 2002-12-23 11:19:10 |
 +-+-+-+-+-+-+---
 -+-+
 1 row in set (0.00 sec)



 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Javascript and mySQL

[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 connection object to link to MySQL or any other database
package.

However, there is a way to fake it!

You can utilize JavaScript data arrays to access information that is stored
on your web page. You would use a scripting language like ASP or PHP to
output the array on the page and the access the array elements via
JavaScript. While this raises quite a few issues (I'll leave that exercise
to you), it is a way to access your database information with JavaScript.

Good Luck!

Dennis

Filter: MySQL, SQL, Query


- Original Message -
From: Michael C. Podlesny [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 25, 2002 7:14 PM
Subject: Javascript and mySQL


 Is there anyway to retrieve mySQL data from JavaScript?


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: select from two table

[Dennis Salguero]

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 [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Friday, November 22, 2002 11:14 PM
Subject: select from two table


 I have 2 table with same structure

 table 1 have name and position
 table 2 have name and position

 name in table 1 same as name in table 2 but position in table 1 may not
 same as position in table 2

 how do I get data like this
 what is sql command

 nameposition.table1  position.table2


 thanks



 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: select from two table

[Dennis Salguero]

Doh!

Just when you think you have a softball . . .

Yes, the answer should include the FROM:

SELECT name, table1.position, table2.position
FROM table1,table2
WHERE table1.name=table2.name

Filter: MySQL SQL

- Original Message -
From: Jocelyn Fournier [EMAIL PROTECTED]
To: Dennis Salguero [EMAIL PROTECTED]; Osman Omar
[EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: Saturday, November 23, 2002 11:28 PM
Subject: Re: select from two table


 don't forget

 FROM table1,table2 ;)
 :

 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 PROTECTED]; MySQL
[EMAIL PROTECTED]
 Sent: Saturday, November 23, 2002 1:21 AM
 Subject: Re: select from two table


  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 [EMAIL PROTECTED]
  To: MySQL [EMAIL PROTECTED]
  Sent: Friday, November 22, 2002 11:14 PM
  Subject: select from two table
 
 
   I have 2 table with same structure
  
   table 1 have name and position
   table 2 have name and position
  
   name in table 1 same as name in table 2 but position in table 1 may
not
   same as position in table 2
  
   how do I get data like this
   what is sql command
  
   nameposition.table1  position.table2
  
  
   thanks
  
  
  
   -
   Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
  
   To request this thread, e-mail [EMAIL PROTECTED]
   To unsubscribe, e-mail
  [EMAIL PROTECTED]
   Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
  
  
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 
 




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: select from two table

[Dennis Salguero]

Doh!

Just when you think you have a softball . . .

Yes, the answer should include the FROM:

SELECT name, table1.position, table2.position
FROM table1,table2
WHERE table1.name=table2.name

Filter: MySQL SQL

- Original Message -
From: Jocelyn Fournier [EMAIL PROTECTED]
To: Dennis Salguero [EMAIL PROTECTED]; Osman Omar
[EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: Saturday, November 23, 2002 11:28 PM
Subject: Re: select from two table


 don't forget

 FROM table1,table2 ;)
 :

 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 PROTECTED]; MySQL
[EMAIL PROTECTED]
 Sent: Saturday, November 23, 2002 1:21 AM
 Subject: Re: select from two table


  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 [EMAIL PROTECTED]
  To: MySQL [EMAIL PROTECTED]
  Sent: Friday, November 22, 2002 11:14 PM
  Subject: select from two table
 
 
   I have 2 table with same structure
  
   table 1 have name and position
   table 2 have name and position
  
   name in table 1 same as name in table 2 but position in table 1 may
not
   same as position in table 2
  
   how do I get data like this
   what is sql command
  
   nameposition.table1  position.table2
  
  
   thanks
  
  
  
   -
   Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
  
   To request this thread, e-mail [EMAIL PROTECTED]
   To unsubscribe, e-mail
  [EMAIL PROTECTED]
   Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
  
  
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 
 




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: SQL Query

[Dennis Salguero]

- 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 earlier suggestion.
You should pull the records, split the data based on the comma and then
insert them individually into new fields and then run your query on the new
table.

Good Luck!

Dennis


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Access replacement...

[Dennis Salguero]

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 GUI, to an
enterprise-level database that focuses on performance. So, you will lose
some of the convenient features that Access provides while gaining some of
the performance that Access certainly can _not_ provide. Let's see if we can
hit the main areas you mentioned:

A programming environment;
I will assume that you are referring to a combination of the forms utility
and VBA within Access. You will now have to rely on something like VB to
provide all of the GUIs to your DB-based applications, there's simply no way
around that. While you may have some advanced users that are comfortable
with creating some basic forms and what-not, this will mean almost
absolutely nothing in the MySQL environment.

A database maintenance utility;
A database query tool;
The number of products available runs the gamut and I'm sure that furtere
research will provide a utility you like. However, DB management in Access
and proper DBA management in MySQL are completely different. Access is
somewhat forgiving on sloppy design, but in order to gain the most from
MySQL, it will certainly pay to make sure your DBs are properly normarlized
from the very beginning and all of your data types are as they should be.
This area should be your largest investment, not only in the time to find a
good MySQL management utility, but also in finding and/or training and
proper DBA. Personally, I use Mascon for my MySQL DBs, but again, you should
research this on your own.

As for your advanced Access users, I am afraid that you would have to shut
them out of doing most of the functions that they handle now. When dealing
with enterprise-wide DBs, it might be best to limit the number of DBAs that
have complete premissions to the database.

A report builder
This will almost certainly depend on how complex your reports are. My
experience has been that most intermediate Access users can make the
transition to something like Crystal Reports in a fairly quick time-frame.
However, a bit more of a learning curve may be required for more complex
reports. Also, your queries might need some re-tooling since you would have
to run them through the MyODBC driver. Fortunately, VB and Crystal Reports
integration is quite easy (I belive the same holds for VB.NET) which would
allow you to maintain an all-in-one utility for both manipulatiing your
data and creating reports.

On the other hand, if your reports are not complex at all, then you can
simply rely on something like PHP or ASP and have web-based reports. This
may not always be the best option for all reports, but if you're only
running a few reports and need a cost-effective solution, this may not be so
bad.

Good Luck!

Dennis

FILTER: MySQL , SQL , query, etc

- Original Message -
From: Brad [EMAIL PROTECTED]
To: MySQL mailing List [EMAIL PROTECTED]
Sent: Tuesday, November 05, 2002 9:14 PM
Subject: Access replacement...


I am thinking of a move from a Windows network to Red Hat Linux at my work.
I
am happy with OpenOffice for spreadsheets, word  processing etc but the main
problem is replacing MSAccess.

MySQL provides a replacement for the database component but that still
leaves:

A programming environment;
A database maintenance utility;
A database query tool;
A report builder

Some of our users have had MSAccess training and are quite proficient in
producing simple but usable applications involving:

The creation of a database and tables;
Forms to populate the database;
Queries and reports to display the data.

All this in a graphical interface without needing to know SQL or doing any
serious programming. They would need to be able to continue doing this in
the
new Linux environment - is there a suitable Forms utility?

We also have some serious applications written in MSAccess by outside
professional programmers. This was partly done to allow the simpler changes
(eg reports and screen layouts) to be made by the advanced users in order to
reduce costs and delays. I would assume that a Forms utility would not
provide enough features to be used here. Does this mean that development has
to be done in the opensource equivalent of VB which may shut out the
advanced users from making changes?

Regards,
Brad

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php 

Re: sql problem

[Dennis Salguero]

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 just wanted to know if you guys can help me  out with this error. It's
 actually an sql and jdbc error.

 I have a class called employeeDBUtil. In this class, it has a method
called
 updateEmployee. I wanted to try if the code would work so I created a main
 portion in my class.

 java.sql.SQLException: Syntax error or access violation: You have an error
 in your SQL syntax near 'eMName='Fabio',  bDay = '03-14-63',
 placeOfBirth='manila'  civilStatus= 'married' at line 1
 at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
 at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
 at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)
 at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)
 at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
 at org.gjt.mm.mysql.Statement.executeUpdate(Statement.java:227)
 at org.gjt.mm.mysql.jdbc2.Statement.executeUpdateStatement.java:97)
 at

com.ccp.hrmdpayroll.employee.EmployeeDBUtil.updateEmployee(EmployeeDBUtil.ja
va:161)
 at
com.ccp.hrmdpayroll.employee.EmployeeDBUtil.main(EmployeeDBUtil.java:731)

 Would anyone know how to solve this?

 lyn



 _
 Get faster connections -- switch to MSN Internet Access!
 http://resourcecenter.msn.com/access/plans/default.asp


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Strange problem with MySql IIS ASP

[Dennis Salguero]

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, October 21, 2002 7:39 AM
Subject: Strange problem with MySql  IIS  ASP


Hi All!

I've Select like this:

SELECT ExpDepDate, ActArrDate FROM oceandata

It works beautifully

But When I modify it like this

SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs FROM oceandata

I'll get nothing, just a empty screen with a browser!

I'm using Ultradev to create this and when I test it in Ultradev it works
good, same in MySQL CC Admin. But not on IIS?
ASP look like this:

%@LANGUAGE=VBSCRIPT%
!--#include file=../../Connections/connMyIFDData.asp --
%
set Recordset1 = Server.CreateObject(ADODB.Recordset)
Recordset1.ActiveConnection = MM_connMyIFDData_STRING
Recordset1.Source = SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs
FROM oceandata
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%
%
Dim Repeat1__numRows
Repeat1__numRows = 10
Dim Repeat1__index
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%
html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body bgcolor=#FF text=#00
table width=100% border=0
  %
While ((Repeat1__numRows  0) AND (NOT Recordset1.EOF))
%
  tr
td%=(Recordset1.Fields.Item(ExpDepDate).Value)%/td
td%=(Recordset1.Fields.Item(ActArrDate).Value)%/td
td%=(Recordset1.Fields.Item(Act_Est).Value)%/td
  /tr
  %
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  Recordset1.MoveNext()
Wend
%
/table
/body
/html
%
Recordset1.Close()
%

Any help will be helpfull

Regards
Juha Mörsky


MySQL

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Q: Stored Procedures

[Dennis Salguero]

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
**
Beridney Computer Services
http://www.beridney.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: How many tables?

[Dennis Salguero]

- 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 this is more efficient, but difficult (for me)
to work with.  I'm sure
 once I have a GUI working, it'll be transparent.

 My question is at what point should I stop using these lookup tables?

Well,  you really shouldn't :-). The way you have broken out the data shows
at least some understanding of Normalization rules and you are avoiding
repetitive data,which is good. Yes, it may be a pain to have to create a SQL
statement with a join, but the fact is that you have a one-to-many
relationship here and the use of two tables is perfectly acceptable.

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Ultimate DB Server

[Dennis Salguero]

- Original Message -
From: Todd Williamsen [EMAIL PROTECTED]
To: 'Mike Rogers' [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, October 28, 2001 9:36 AM
Subject: RE: Ultimate DB Server
 Ram plays a big factor in queries, most queries are stored in ram.  Also
 depends on which platform as well.

Agreed, this is especially true when you are talking about a MySQL server
with dual processors, as mentioned in the original post. Some OSs arguably
handle dual processors much better than others, while others don't support
them at all. Hardware can also be critical - dual processors are old-hat
for Intel board manufacturers while AMD is still fairly new to the arena.

Last fully-custom DB server I set-up for MySQL was a dual PIII 800s (on a
Tyan 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


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: shared datafiles.

[Dennis Salguero]

- Original Message -
From: Zachary Denison [EMAIL PROTECTED]
To: MySQL ListServe [EMAIL PROTECTED]
Sent: Sunday, October 21, 2001 11:11 AM
Subject: shared datafiles.

 I know this is probably a recipe for disaster, but
 would I be able to have 2 instances of mysql running,
 both pointing to the same set of datafiles?

 Before you ask, my reasoning for doing this would be
 so that I could get some sort of underlying shared
 mirrored filesystem and this way I could have 2
 read/write copies of mysql running in 2 different locations.

Why not just create two connection objects within your language of choice?
Assuming that your current MySQL server has its own IP address, you can use
an ODBC connection, via the IP, and connect to the same MySQL db from
virtually anywhere. From an efficiency standpoint, you'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


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Absolute beginner moving from Access

[Dennis Salguero]

- Original Message -
From: Bernard Davis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, October 21, 2001 12:50 PM
Subject: Absolute beginner moving from Access


 I've been able to get the basic website working although God
 knows how, but to develop other services on the web site I need to
 be able to work locally on my Win 98 machine.

 I use Dreamweaver Ultradev.  I cannot get any sort of a connection
 locally, using PWS and MySQL server.

And how exactly were you planning to do that? If memory serves me, Ultradev
produces ASP code - is that what you were planning to do? At the very least,
you're going to need an ODBC connection (to your MySQL server) on the same
machine as the PWS server (which I assume you know how to create).

Once the connection is there, you should be able to designate that as your
datasource, from within UltraDev. Realize that UltraDev attempts to make use
of some ADO properties and methods that are not yet supported by MySQL, but
you should be able to create the initial connection fairly easily.

If you need an ASP tutorial, let the list know - I'm sure that there are
some resources for that already out there.

Good Luck,

Dennis Salguero
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Proposed Guidelines for Posting to the MySQL list

[Dennis Salguero]

- Original Message -
From: Robert Alexander [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, October 21, 2001 1:29 PM
Subject: Proposed Guidelines for Posting to the MySQL list


 There's been some discussion recently on the need for a FAQ and posting
 guidelines for the MySQL list. I got to thinking about that... :

That's great! Overall, I think that these guidelines have a lot of merit,
but I can't help but feel that they should be coming more from MySQL AB,
than the list itself. If they have a vision for the resource that the
mailing lists should provide, then its guidelines should come from MySQL AB.

  - Replies are directed to the POSTER and not to the list. This keeps
traffic
and clutter down.

This is one of the few points I disagree with. The archives of this list, if
used properly, is probably one of the best support resources out there right
now. One of the reasons is because there tends to be some back-and-forth
until a correct answer is determined. Following the thread of responses to a
particular query can be of great benefit.

The antithesis of this rule is that individual posters MAY NOT be contacted.
This prevents the experts on the list from being flooded with direct
queries, which does not benefit the list as a whole. I know that when I am
directly contacted, either out of the blue or as a follow-up to an answer,
I encourage the writer to post to the list since providing answers
one-on-one does not benefit the list. Therefore, I would propose that the
guidelines include that all questions  answers (when relevant) remain on
the appropriate MySQL list.

  - Job postings, requests for jobs, sales pitches, etc.
Get permission from the MySQL staff first, or use the appropriate
newsgroup instead.

If I remember correctly, the MySQL lists are open - you do not have to be
a member to post to the list. As long as the lists remain this way, they
will always be open to these kinds of postings, including outright spam.
There is a filter in place, but my understanding is that any letter
beginning with Dear MySQL community:  (or some variation containing
MySQL) will get through. I think you would have to work with the MySQL
staff to really tighten the list to meet stricter requirements.

 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 great resource because all answers stay on the
list - we should definitely try to keep it this way.

Good Luck,

Dennis Salguero
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: foreign key

[Dennis Salguero]

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 Rovena Frigeri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 19, 2001 7:24 PM
Subject: foreign key


hi,

which windows mysql version supports foreign key and its complete
implementation: referential integrity constraint, avoid delete parent key,
etc.?
or
Which foreign key features that has the best windows mysql version?

thanks,

sandra.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: FOREIGN KEY ... ON DELETE CASCADE

[Dennis Salguero]

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.beridney.com

- Original Message -
From: Jeff Tanner [EMAIL PROTECTED]
To: Mysql (E-mail) [EMAIL PROTECTED]
Sent: Tuesday, September 11, 2001 9:13 AM
Subject: FOREIGN KEY ... ON DELETE CASCADE


 Is FOREIGN KEY ... ON DELETE CASCADE operational in mysql?

 If so, I am not observing such. Here is how I am using it:


 CREATE TABLE scheduled_task_list (
schedule_id  CHAR(28) NOT NULL,

  /* keys */
PRIMARY KEY (schedule_id)
 );

 CREATE TABLE scheduled_task_instances (
task_instance_idCHAR(28) NOT NULL,

schedule_id   CHAR(28) NOT NULL,


  /* keys */
PRIMARY KEY (task_instance_id),

  /* constraints */
FOREIGN KEY (schedule_id)
   REFERENCES   scheduled_task_list (schedule_id)
   ON DELETECASCADE
);

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Trouble w/MySQL Server

[Dennis Salguero]

- 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?  Go to my web site and try to log
in
 to get a better understanding of what I mean.  This always comes up::


 Microsoft OLE DB Provider for ODBC Drivers error '80004005'

 [TCX][MyODBC]Can't connect to MySQL server on '24.254.141.32' (10061)

 /members/admin/login-action.asp, line 66

For a problem like this, it never hurts to include the code that the error
is referring to.

Dennis


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ldap authentication for mysql

[Dennis Salguero]

- 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
 studying it right now, and it looks very promising as it can access both
 ldap and mysql.

I think that this would all depend on the language you are working with,
particulary when creating the log-in interface. One of the most elegant
solutions I have seen is to create a stand-alone COM component to interface
with the LDAP server. Its quite simple really, take in the userID and
password and return a negation or access rights - one of the easiest COM
components you'll ever write! Making it a COM component can then let you
work with it in a variety of languages.

Just my two cents,

Dennis
**
Beridney Computer Services
http://www.beridney.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: development tools

[Dennis Salguero]

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, keep in mind that
it's an ADO world and you should be just fine when creating Windows
applications with MySQL.

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com

- Original Message -
From: Christian Hermanus [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 14, 2001 6:07 PM
Subject: development tools


 SORRY FOR ANY CROSS POSTING

 Dear All,

 I have a plan to build a database application using mysql as it database
 engine
 What is the best development tools if I using a Microsoft NT environment.

 I'll be happy if you share your experience

 Regards

 Christian



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: quickie!

[Dennis Salguero]

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]
To: [EMAIL PROTECTED]
Sent: Sunday, August 05, 2001 2:25 PM
Subject: quickie!


hi..

can someone tell me how i get the data from two tables, where table1 will
have one row, and table2 will have many rows?

eg:



table1:

idname

1barney
2fred
3wilma

table2:

idstudent_id subject

11   english
11   cookery
11   maths
11   science
12   woodwork
13   cookery



do i have to use two queries to get all this data out in usable form?

thanks,

jamie.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: sequences or auto_increment column????

[Dennis Salguero]

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
**
Beridney Computer Services
http://www.beridney.com

- Original Message -
From: Siomara Pantarotto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, July 27, 2001 10:04 AM
Subject: sequences or auto_increment column


 Does anybody know which approach is better with mysql:

 Create sequences for tables or an auto_increment columns???

 and why???

 Siomara



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mysql

[Dennis Salguero]

- 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
something that needs to happen on a regular basis? Are you doing this across
platforms or not?

If its a one time thing and you need to do this quickly, you could use a
dump file from one and transfer it to the other.

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Direct access to a mySQL DB via Visual Basic

[Dennis Salguero]

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
connection object and recordset functions.

As for your second issue, you can use a DSN-less connection that should give
you slightly better performance. Take a look at the code shown here:

%
Function Get_Connection()

Set objConn = Server.CreateObject(ADODB.Connection)

objConn.Open uid=root;pwd=;driver={MySQL};server=localhost;database=db

If Err.Number = 0 Then
Get_Connection = True
Else
Get_Connection = False
End If

End Function
%

Of course, realize that this is ASP code, but it certainly provides the
framework for a VB connection.

If anyone is interested, I am willing to send out the VB files I use to
connect to MySQL databases - just send me an e-mail.

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com

- Original Message -
From: Stephen Sherlock [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 23, 2001 9:12 PM
Subject: Direct access to a mySQL DB via Visual Basic


I've been told that it's possible to connect directly to a mySQL DataBase
with Visual Basic, by using the {mySQL} provider within the ADO Data
Control, however, none of the providers on the list include mySQL at all,
and I was wondering if anyone could shed some light on this.

I want to connect to the DB directly rather than through ODBC because the
final project I'm working on will include some hefty processor and memory
usage as it is, and the last thing I need is more resources being taken up
by ODBC.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MYODBC DSN creation

[Dennis Salguero]

- 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/utility. You should verify
that the sample MySQL connection is there too. If it's not there, then you
may have an individual issue with the MyODBC installation process.

 I have exhausted my idea bank on what is happening. Any ideas from anyone
 else
 would be greatly appreciated.

Well, here's one more for you - you can use a DSN-less connection. Take a
look at the function below:

%
Function Get_Connection()

Set objConn = Server.CreateObject(ADODB.Connection)

objConn.Open uid=root;pwd=;driver={MySQL};server=localhost;database=db

If Err.Number = 0 Then
Get_Connection = True
Else
Get_Connection = False
End If

End Function
%

Obviously, this is ASP code, but you get the general idea for a VB
implementation.

Good Luck,

Dennis
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Converting ACCESS or EXCEL Data to MySQL

[Dennis Salguero]

- 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 ?? ;-)

 I'm currently thinking about the easiest way to get data from
 this database and put it online. I could start to develop on
 a little software tool which publicates the data but isn't there
 a easier way ?

How do you want to put this data on the web? Do you want it to be dynamic or
just a static HTML page? It sounds like you're working in a Microsoft shop,
so for dynamic pages, have you considered ASP? The advantage to using ASP,
in your scenario, is that you would only write the ASP code once, the web
page and the HTML for it would be dynamically generated. For creating HTML
pages, you can use everything from the wizards within the Office products to
a custom program in VB (or another language of choice).

 I'm rather new to MySQL and general SQL Technologies, so maybe
 I overlocked something. Yes, I already looked in the user manual
 at www.mysql.com and I read something about ODBC Support, but does
 that also work if the Database Server is lockated somewhere in the
 Internet ?

ODBC really works with anything, that's the whole point of using it. If you
want to connect  your current SQL Server to a web page, you would create an
ODBC connection on the web server (with the SQL Sever IP address  user
info). From there, within your ASP code, you could reference the ODBC
connection, which will pass the information back  forth between the web
page and the database.

Notice that I haven't really mentioned MySQL at all. As much as I like
MySQL, if you already have a SQL Server that can connect to the Internet, I
don't understand the need to use MySQL in this scenario ??? Obviously, if
this is a web page that will see a lot of traffic, or the SQL Server
database is no good or too big, then of course you can still use MySQL in
the same manner mentioned above. Just remember, that you will have to use a
new ODBC driver, MyODBC.

Good Luck,

Dennis
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Storing Credit Cards

[Dennis Salguero]

- 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 we wouldn't
 actually keep anything that could immediatly show credit card numbers on
 the server. The problem this creates is whenever we need to use their
 credit card, the user needs to enter in their password. Which would be
 quite inconvenient as we'd use it in many places (like showing the last 4
 digits to verify it's the right card).

I think a user would much rather enter their credit card information over 
over, rather than their passwords since they can inherently understand the
need for securing their CC. Some developers I know either refuse to store CC
numbers at all or request that the client sign a waiver absolving the
developers of liability in case of a hack. The latter option may be a bit
much, but storing CC numbers overall is really not the ideal situation.

 The only other idea was to just stick them in plain text and keep people
 far away from the MySQL server.

There's no such thing as far away on the Internet :-). If you still want
to explore this, you could invest in something extraordinary like a
SideWinder box, depending on your client  their liability comfort level
(and budget!).

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MS IIS web logfiles

[Dennis Salguero]

- 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 there are 16 space
 separated data fields (17 if you include a autocount as primary key).   I
 know that MS Access has a GUI Wizard that walks you through the conversion
 of text files to an Access table.  Unfortunately, my data is much to large
 for MS Access (or a text reader).  I find no comparable facilitation with
 mySQL.  Any suggestions?

Well, unfortunately that's one of the trade-offs between a database like
Access and something more robust like MySQL. MySQL (and most other large
database packages) do not always have these GUI tools to facilitate
conversions and other operations.

Therefore, perhaps the best long-term solution for your need is to create a
VB program (or the language of your choice) to take a delimited text file
and put it into its own table in MySQL (or any other database really). As
long as you can access the file and know the delimiter (both of which are
possible with IIS log file), then this program should not be difficult to
put together.

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Connecting to MySQL w/VB

[Dennis Salguero]

- 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 add records.  Can anyone
 steer me in the right direction?

A bit more information might help us help you. If you the db reads work
fine, then you at least have the connection made - that's already half-way
there! I have done extensive work with MySQL and VB/VBScript, but if you can
execute a SELECT query (as your e-mail indicates) I don't see how you would
have problems executing an INSERT query (assuming the SQL statement is
valid).

What exactly seems to be the problem?

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Connecting to MySQL w/VB

[Dennis Salguero]

- 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 the permissions are not set properly. However, I was
assuming that, since he had just started working with MySQL, he was using
the root account, unmodified, which would give him complete access. It's
been my experience that it is much easier to work with ASP  MySQL than VB 
MySQL because of the databound objects, and wouldn't be surprised if the
problem that the original poster has does not apply to ASP.

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: CF and MySql?

[Dennis Salguero]

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. You can then
reference this DSN just like you would any other ODBC connection.

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com

- Original Message -
From: Wade DeWerff [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001 11:57 AM
Subject: CF and MySql?


 Can Cold Fusion querys work with MySQL? What would I have to do if
 anything to make it work?

 WD


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Let's try this again..HELP PLEASE

[Dennis Salguero]

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.

1 - The error message that you are getting may indicate that you have a NULL
or empty value for a field that is designated as NOT NULL. This makes sense
because the next problem is . . .

2 - Your INSERT statement is using a SELECT statement to chose VALUES to be
inserted into the table. Since MySQL does not support sub-SELECT statements,
the second part of your query is not returning any values, resulting in the
NULL value error stated above.

Therefore, my recommendation to you is to re-write this SQL statement.
First, you would need to create a recordset that has the values from the
second part of your query. Then, you could use these values to finish off
the SQL statement you currently have. In the end your statement should look
something like the following:

INSERT INTO testScores (**Field names from current SQL statement**)
VALUES (**Values from the recordset obtained from the second part of
existing query**)

(Obviously, I'm paraphrasing here)

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com

- Original Message -
From: Glenn Emery [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, June 02, 2001 8:34 AM
Subject: Let's try this again..HELP PLEASE


I am working with porting an ASP website that connected to an Access
Database to MySQL and am still very new to the Syntax differences.

I've found more than a majority of the site works except one crucial part
that submits the results of a survey into the database and am not sure
*exactly* where the problem lies because I get an error that states
ADODB.Connection.1 error '80004005'
SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near '' at line 1

/profile/chemistrymatch/final.asp, line 633

yet line 633 is different depending on what I open the page up with.When
I open with UltraDev line 633 reads..con.Execute(sql) with word wrap
on and...
'*
' ADD NEW VALUES TO TESTSCORES IN DATABASE
'*

SQL = INSERT INTO testScores (CUSTOMER_ID, creative, creativeDeveloper,
developer, refiner, maximizer, director, persuader, cooperator, analyst,
social, internal, futurist, realist, feeler, thinker, planner, adapter,
values1, values2, values3, values4, values5, values6, values7, values8,
values9, values10, values11, values12, values13, values14, values15,
values16, values17, values18, values19, values20, motivatedRole1,
motivatedRole2, motivatedRole3, MotivatedRole4, motivatedRole5, impactRole1,
impactRole2, impactRole3, impactRole4, tempermentProfile1,
tempermentProfile2, tempermentProfile3, tempermentProfile4,
tempermentProfile5, tempermentProfile6, tempermentProfile7,
tempermentProfile8, tempermentProfile9, tempermentProfile10,
tempermentProfile11, tempermentProfile12, tempermentProfile13,
tempermentProfile14, tempermentProfile15, tempermentProfile16,
undecidedCount3, undecidedCount4, undecidedCount5, undecidedCount6,
customerName, CORPORATE_CUSTOMER_ID) SELECT '  CUSTOMER_ID  ' AS Expr1,
'  creative  ' AS Expr2, '  creativeDeveloper  ' AS Expr3, ' 
developer  ' AS Expr4, '  refiner  ' AS Expr5, '  maximizer  ' AS
Expr6, '  director  ' AS Expr7, '  persuader  ' AS Expr8, ' 
cooperator  ' AS Expr9, '  analyst  ' AS Expr10, '  social  ' AS
Expr11, '  internal  ' AS Expr12, '  futurist  ' AS Expr13, ' 
realist  ' AS Expr14, '  feeler  ' AS Expr15, '  thinker  ' AS
Expr16, '  planner  ' AS Expr17, '  adapter  ' AS Expr18, '  v1 
' AS Expr19, '  v2  ' AS Expr20, '  v3  ' AS Expr21, '  v4  '
AS Expr22, '  v5  ' AS Expr23, '  v6  ' AS Expr24, '  v7  ' AS
Expr25, '  v8  ' AS Expr26, '  v9  ' AS Expr27, '  v10  ' AS
Expr28, '  v11  ' AS Expr29, '  v12  ' AS Expr30, '  v13  ' AS
Expr31, '  v14  ' AS Expr32, '  v15  ' AS Expr33, '  v16  ' AS
Expr34, '  v17  ' AS Expr35, '  v18  ' AS Expr36, '  v19  ' AS
Expr37, '  v20  ' AS Expr38, '  motivatedRole1  ' AS Expr39, ' 
motivatedRole2  ' AS Expr40, '  motivatedRole3  ' AS Expr41, ' 
motivatedRole4  ' AS Expr42, '  motivatedRole5  ' AS Expr43, ' 
impactStyle1  ' AS Expr44, '  impactStyle2  ' AS Expr45, ' 
impactStyle3  ' AS Expr46, '  impactstyle4  ' AS Expr47, ' 
tempermentProfiles(1)  ' AS Expr48, '  tempermentProfiles(2)  ' AS
Expr49, '  tempermentProfiles(3)  ' AS Expr50, ' 
tempermentProfiles(4)  ' AS Expr51, '  tempermentProfiles(5)  ' AS
Expr52, '  tempermentProfiles(6)  ' AS Expr53, ' 
tempermentProfiles(7)  ' AS Expr54, '  tempermentProfiles(8)  ' AS
Expr55, '  tempermentProfiles(9)  ' AS Expr56, ' 
tempermentProfiles(10)  ' AS Expr57, 

Re: VBA/VB DAO/ADO MS Access to MySQL?

[Dennis Salguero]

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 everything to ADO.

As for the databound objects, the answer is: it depends. Some of the
databound objects will work fine, others will produce some of the weirdest
and non-sensical errors you have ever seen :-). I have worked mostly with
the datagrid bound object and found that it was best to ditch it in favor of
re-writing all of the code in ADO. As someone else already stated, the less
complex the application, the better than VB and MySQL will work together.
Otherwise, proceed with caution and get yourself a good ADO reference.

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com

- Original Message -
From: Thompson, Mike [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 10:37 AM
Subject: VBA/VB DAO/ADO MS Access to MySQL?


 Howdy,

 I currently have an application which uses DAO and ADO coding in VBA/VB as
 well as databound objects in VB to access a MS Access database.  Can DAO
and
 ADO in VBA/VB and databound objects in VB be made to work with a MySQL
 database?

 Anybody done this successfully?

 Cheers,



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Help w/MySQL and Dreamweaver Ultradev

[Dennis Salguero]

- Original Message -
From: Daniele Iachini [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 28, 2001 6:50 PM
Subject: Help w/MySQL and Dreamweaver Ultradev


 I'm not able to manage dates correctly in dreamweaver, expecially when a
 form with dates is submitted to update a record.
 The singular -mm-dd format of MySQL in fact is correctly put in
 dd/mm/ (that's ok for my country and is my locale) but when i submit
the
 form, even without changes, it isn't recognised any more by MySQL that
 zeroes the field or tries to read it a non inverted -mm-dd (obviously
 corrupted). Anyone knows a solution or knows the syntax of DoDateTime()
 function that seems to be a possible solution?
 Is there a place in internet where I can find a complete reference of ASP
 command and functions syntax???

I always cringe when I think about the ASP code that is produced by the
Macromedia products. However, this problem can be easily solved with an ASP
function that you can add to your pages (I would recommend putting it in an
include file, but that's just me).

As far as I know, none of 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 = Month(strDate)
d=Day(strDate)
y=Year(strDate)
MakeDate = y  - m  -  d
Else
MakeDate = strDate
End If

End Function
%

As you can see, this function is very straightforward. It simply breaks down
the date you pass into different components and formats it to fit a
-MM-DD format, which is understood by MySQL.

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mysql difficult query. Need help!

[Dennis Salguero]

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 in a catalog:

Item Description: Basic T-Shirt
Available Styles:
Medium - White - 15.99
Medium - Black - 15.99
Large - White - 16.99
Large - Black - 16.99

I can see at least 4 different tables all related to each other in one way
or another. In the end, this will make your queries significantly easier to
formulate and would almost certainly improve your database performance than
with what you currently have.

Good Luck,

Dennis
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com

- Original Message -
From: Weevil [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 24, 2001 4:19 PM
Subject: Mysql difficult query. Need help!


 Hi.

 I'm having some problems with formulating a SELECT statement to do the
 following:

 I have a database with one column of names with certain tags bounded by
 square brackets, and a price column as well. The database looks something
 like this:

 ITEM PRICE

 Shirt [Large] [Polyester] 12.99
 [Small] Pants [CategoryB] 15.99
 Sweater [A GRADE] [Medium] 20.00
 Tie [Large] [CategoryB] 5.99

 Tags (the stuff between the [ and ]) are not standardised and can contain
any
 string. What I want to do is find the total price for each tag and return
the
 whole thing in a report grouped by tag like this:

 ITEM TAG: TOTAL PRICE:
 [Large] 28.98
 [CategoryB] 21.98
 [Medium] 20.00
 [Small] 15.99
 [Polyester] 12.99

 I was using this SQL statement:

 select
 substring(Item,instr(Item,\[\),instr(Item,\]\)-instr(Item,\[\)+1) as
 ItemTag,sum(Price) as TotalPrice from Products group by ItemTag order by
 TotalPrice desc

 As you can see this is rather byzantine and only groups by the first tag
it
 encounters. I wondered if it was possible to apply it for as many tags as
 there are in the item name (as in the example above).

 I hope someone can help, I'm reasonably experienced with MySQL but this
one
 is out of my league.

 Thanks for any assistance you can give.

 --
 Steve Pick
 [EMAIL PROTECTED]

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: How To Port MS SQL Database to MySQL

[Dennis Salguero]

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 execute the SQL statement (with a VB
connection object) in place of calling the stored procedure.

While this does negate the advantage of having a stored procedure, it is one
of the few (if not the only) work-arounds for this problem.

Good Luck,

Dennis
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com

- Original Message -
From: Istiaque Hussain [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 11:39 AM
Subject: How To Port MS SQL Database to MySQL


 Dear Friends ,

   One of our clients wants to port the Database which was originally in MS
SQL , to MY SQL . he main problem we are facing is that how to make previous
stored procedures run . There are a lot in the application . Front end was
in VB .
   We are now into feasibility study . Please give information on that .

   Bablu



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL and MyODBC

[Dennis Salguero]

- 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.
 files and the ODBC or i must the install the complete version of
 MySQL.

I think that all depends on the nature of your application. If you must have
a central database and your VB program acts as a client, then you would only
have to include the ODBC driver. If each copy of your program can act
independently of each other, in other words, if its strictly a desktop
application, then yes, you would have to include a complete copy of MySQL.

 Another little question... If it's necessary only the ODBC, i must install
 them by the set-up downloaded from the site or can i copy and register
 the dll of ODBC?

Well, that's a question that I have wrestled with also. There was a recent
post (on 4/19/01) by one of the MySQL developers (Miguel Angel Solorzano)
that addresses this issue, I would search in the archives for it. I haven't
tried it just yet, but it does seem like a possible solution.

Good Luck,

Dennis
**'
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ADO RS.Update problem

[Dennis Salguero]

- 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 is
 only reliable if you have traversed the entire recordset before calling
it.

That is true in some cases, using MoveLast and then issuing the RecordCount
request does give the most accurate result. However, if I remember
correctly, when working with MySQL and ADO, MoveNext is one of the few
methods that is supported.
Further note that even if all the records are "seen" (by using a loop and
MoveNext), the RecordCount property will still not work. Therefore, the
work-around would require a separate counter with ASP or other language of
choice.

Good luck,

Dennis
**'
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: question about integrating ASP pages

[Dennis Salguero]

 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 you have the MyODBC driver installed on your server and you can
then create a connection object with the DSN name. From there, you will be
able to work with it almost like any other connection  recordset object,
although there are some limitations with a few ADO properties.

PLUG
I wrote a case study for ASPToday that address this very issue (ASP and
MySQL integration). You can check it out at:
http://www.asptoday.com/content/casestudies/20010302.asp
/PLUG

Good luck,

Dennis
**'
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ADO RS.Update problem

[Dennis Salguero]

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 results to a recordset object.
You can write it like the following, where objConn is a ADO connection
object:

%
strSQL = "SELECT * FROM Foo"
objConn.Execute(strSQL)
%

Obviously, the above is ASP syntax, but you get the idea for VB :).

Good luck,

Dennis
**'
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com

- Original Message -
From: "Simon Abolnar" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 14, 2001 4:46 AM
Subject: ADO RS.Update problem


Hello!

I am using mysql with VB ADO under Windows 2000 Proffesional.
I add data with:

RS.Open "Query WHERE 0=1", Cn, , , adCmdText
RS.AddNew
RS.Fields(Cols).Value = xx
.
RS.Update

After RS.Update RS.Fields(Cols).Value is NULL.
If I use Access database, RS.Fields(Cols).Value has value of last inserted
record.

Would you like to tell me, why mysql works in different way and how to solve
this problem to have compatible solution for mysql and Access?

Thanks all!

Simon




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ADO problem with MYSQL datetime column

[Dennis Salguero]

- 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-00 00:00:00", I have problems reading
from
 the ADO recordset.

What kind of problems are you having specifically?

If you already have your data in an ADO recordset, then it is fairly simple
to "massage" the data in any way you want. Have you checked the field with
IsEmpty or IsNull? Using a conditional statement to check for null or empty
values should prevent these dates from passing through to your script.

 I was wondering if this is an ADO issue with the MYSQL column type of
 datetime, or perhaps an issue with the MyODBC driver and ADO ?

If the data is already in the recordset, and the values for the other fields
are correct, then I don't think that it would be an ODBC error. It might
just be a matter of using some further code to verify the data before you
use it in the rest of your scripts.

Good luck,

Dennis
**'
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Is email unique?

[Dennis Salguero]

 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 addresses would be a unique way to indentify an
 individual.
 Only one e-mail can exist per person. Although an email address could
change
 owners for the most part, each e-mail should be unique.
 Am I right?

I believe so. Many sites have started using e-mail addresses as log-in names
because of the same reasons you cited. I don't think that there are many
others that, as you stated, are naturally occuring. You could write a
function to assign unique names to your users, that's not difficult, but
that's a lot harder for a user to remember than their e-mail address.

Good luck,

Dennis
**'
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Cold Fusion

[Dennis Salguero]

 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 that ODBC adds
(as opposed to an OLE connection) CF handles the connection objects much
better than most, so the added overhead is not as bad as it could be.

 3.  Any other gotchas?

I have used MySQL extensively with ASP and there are some limitations with
ADO like the recordcount functions. Since CF doesn't use ADO, I'm sure that
the limitations are different, and there may very well not be ANY, but you
never really know - it's just a matter of experimentation.

Good luck,

Dennis


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Download of MySQL

[Dennis Salguero]

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

- Original Message -
From: "Jon Haworth" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, January 24, 2001 9:34 AM
Subject: RE: Download of MySQL


 Well, it's not me, I found it with no problems.

 1. Click on "Downloads"
 2. Click on the first link under "MySQL database" (helpfully labelled
 "Stable release, recommended")
 3. Select your OS.

 Seems sensible enough.


 Cheers
 Jon



 -Original Message-
 From: Gustav Wiberg [mailto:[EMAIL PROTECTED]]
 Sent: 24 January 2001 14:30
 To: MYSQL List
 Subject: Download of MySQL


 Hi

 Is it just me who thinks it is very difficult to find the right
 download-location for MySQL (when you have Windows 95, or Windows 98) on
the
 mysql.com-site?

 /Gustav Wiberg


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Visual Basic and MySQL?

[Dennis Salguero]

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

- Original Message -
From: "Gustav Wiberg" [EMAIL PROTECTED]
To: "MYSQL List" [EMAIL PROTECTED]
Sent: Wednesday, January 17, 2001 8:22 AM
Subject: Visual Basic and MySQL?


Hi there

I wonder how I step by step, connect to MySQL trhough Visual Basic 5.0?
I'm a newbe in MySQL... but I have knowledge of how to use Access database.

/Gustav Wiberg



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php