Oh! Ok. Thanx! Although I didn't really want to do all of that, I guess
it's the only way. Unless someone has something better.
- Deryck Henson
- http://www.sourcecodecafe.com
- Original Message -
From: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]
To: Deryck Henson [EMAIL
even
explain it fully.
- Deryck Henson
- http://www.sourcecodecafe.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
) to do this and
need to figure out a good way to filter based on separate words (ANY, ALL,
EXACT PHRASE). Is there a way I can do this with mysql or ASP? the pages
are completely in ASP and will have a 4.0 DB soon Thank you everyone. If
this is unclear, please email me in private.
- Deryck
Well, if you mean searching for INFO stored in a DB, just use LIKE syntax or
FULLTEXT index. If you mean searching your site, use the
FileSystemObject(in ASP). Email for details
- Original Message -
From: Chris Blessing [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 18,
?
Thanx.
**
- Deryck Henson
- http://www.comp-u-exchange.com
**
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
shockwave but Java should be fine). Again, if you have any suggestions,
questions or just want to help out, please email me in private. Thanx!
**
- Deryck Henson
- http://www.comp-u-exchange.com
**
- Original Message -
From: Maximiliano Lucius [EMAIL PROTECTED
! Me
and whoever else wants to will plan it, we just need you people to come. It
is a pretty long-shot but we could probaly do it. My Web Server.
**
- Deryck Henson
- http://www.comp-u-exchange.com
existing database, and what it can do for me. Thank you. Also, if anyone
knows a very good search query for this that would be good for a high-end
search engine (google, yahoo, etc), please let me know. Thank You.
**
- Deryck Henson
- http://www.comp-u-exchange.com
= request.querystring(search)
Thanx. I'm hoping to test this on my database soon (the InnoDB)
**
- Deryck Henson
- http://www.comp-u-exchange.com
**
- Original Message -
From: Deryck Henson [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Monday, October 04, 2010 12:23
HI! I am waiting on the official launch of 4 and want to know more about
the union tables. Can someone give me the low down on this? I know I will
need it (I have to combine 15 tables into one big pile of data) so please
help. Thanx!
**
- Deryck Henson
- http://www.comp-u
What will this thing have? i know Union tables will be present :) . What
else? I'm very anctious to get my hands on it. thanx ^_^
**
- Deryck Henson
- http://www.comp-u-exchange.com
**
-
Before
Thanx
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Sunday, September 23, 2001 9:35 PM
Subject: Re: MySQL 4.0
On Sun, Sep 23, 2001 at 07:54:59PM -0500
Sooo, when does this highly anticipated version of mysql get released?
Supposed to have union tables :).
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the
If I want to filter out records when SELECTing from a database, how do I do
it with an
and/or type of statement. Like this:
SELECT * FROM websites WHERE keywords LIKE '%akeyword%' AND/OR description
LIKE '%description%'
I want it to show most relevant (AND) then 2nd to most (OR). Please help.
ASP
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Sunday, September 16, 2001 5:45 PM
Subject: Re: How to count the number of ,br's in multiple records
On Sun
Other than the manual, Sam's Teach Yourself MySQL in 21 Days is a great
book.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: rjtalbo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, September 15, 2001 3:24 PM
Subject: intro mysql book
Subject:
I need to know the type of data to use for me to put in an IP Address. I
tried INT and BIGINT. Neither worked HELP! I need this for my database
bad!
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please
Well, before I asked which joins to use and now I want to know how to use
the LEFT JOINS. They would be quite useful on my site right now. Any help
is appreaciated and dont say to read the manual cause Ive tried that and it
doesnt give a good enough explanation. This will be very helpful when
and
please, if you have an idea of what I mean, please tell me an answer.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Loyd Goodbar [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]
Sent: Thursday, September 13, 2001 6:13 PM
Subject: Re: using LEFT JOINS
On Thu
Dude, I AM going to be inserting data!
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Thursday, September 13, 2001 8:04 PM
Subject: Re: using
bigint, date_created
datetime, level enum ('all', 'novice', 'intermediate', 'advanced')
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Gerald Clark [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Thursday, September 13, 2001 10
the same structure, this will work.
Loyd
On Thu, 13 Sep 2001 20:19:14 -0500, Loyd Goodbar [EMAIL PROTECTED]
wrote:
On Thu, 13 Sep 2001 19:55:11 -0500, Deryck Henson [EMAIL PROTECTED]
wrote:
OK, first of all, brilliant and well thought out. One problem, every one
of
my tables are EXACTLY
OK, well, as you all know, I am using mysql only for ASP Connectivity.
Sooo, this is my question: Every time I try to use this statement to open a
table, it gives me an error::
statement used-
rs.open SELECT username, codeid FROM user_votes where username =
'user', dbconn
if rs.fields(codeid)
This relates to the earlier posts I made about left joins. I was shown how
to do it with a where clause, but now how do I do it WITHOUT one? Like
SELECT * FROM basetable left join 2ndtable on (basetable.*=2ndtable.*)
Something like that... I need help with this as you can see.
- Deryck H
-
Just to join ALL the records from ALL 15 tables together in one big blob of
data and have there be a something that tells me which table each record
comes from.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Deryck Henson [EMAIL PROTECTED]
To: MySQL [EMAIL
are you using something like this? ::
set dbconn = server.createobject(ADODB.Recordset)
dbconn.open dsn=yourdsnname;uid=;pwd=;driver=mysql
sql = SELECT * FROM tablename
recordset.open sql, dbconn
insert = INSERT INTO tablename (column1, column2) VALUES
('valueforcolumn1', 'valueforcolumn2')
OK, well, mysql has LEFT JOINS, right? OK then, in that case, how the heck
do I use them?! I need to join 14 tables (with the exact same structure,
columns) together and view all of there contents with a WHERE clause like
this:
SELECT * FROM t1, t2, t3, t4, t5, etc ORDER BY date DESC
or
Merges wont work because they dont allow inserts. But I'll check out UNION.
Thanx
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Wednesday, September 12, 2001 2
How??? ALTER TABLE table1 RENAME ???
Tried it, dont work.
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
That may be it (dual boot). The virtual drivers for win98 that mySQL uses
probably are only compatible with win98 not 2000. Im probably wrong but
that's the only solution I've got.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Kevin [EMAIL PROTECTED]
To: [EMAIL
Actually, I dont think so but I agree with the last statement. I think Bush
needs to send out EVERY FBI, CIA, etc agent to find out whoever did this, if
they werent on those planes already. Dang, the entire WTC tower. Wait,
BOTH of them. Anyway, this has zippo to do with mySQL bu it still is
No, only Windows 95/98/200/NT
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Doug V [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 09, 2001 4:24 PM
Subject: windows ME
Will mysql run on Microsoft's windows ME operating system ?
-
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]; Webmaster
[EMAIL PROTECTED]
Sent: Sunday, September 09, 2001 4:30 PM
Subject: Re: SELECT * FROM allofthetables
Hi.
It cannot be done with a SQL command, except if the structure
How do I select all of the tables in a database and use a whre clause like
this??::
SELECT * FROM alltables(substitute with command) WHERE User = 'username'
I need this for my site (Code Cafe- Free source code) so that the user can
see all the code he has uploaded. It is done in ASP, but all I
It's about $208.00 in USD or 1725 CNY (Chinese Currency). You can buy it
from anywhere I THINK. You might want to check me on that one. Just buy it
straight from MySQL's website ( http://order.mysql.com ) . And, in my
opinion, I'd just use the free version. Not as much to worry about, but,
I need to make about 15 tables that use the same template as the first one.
Please help.
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
MaybeI guessThere's either too many datatypes or try putting like
this (again, probably wont work)
Auto_Increment=1000, .
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Mysql List [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]
Cc: mysql [EMAIL
I am trying to input some data into the database when all of a
suddenPOOF! This pops up!::
You have an error in your SQL syntax near 'get file scripting object Set
objFileScripting = CreateObject(Scripting.F' at line 1
Is there anything I can doabout this? The 'get file scripting object
I keep on hereing in the manual them talking about some MySQL 4.0. What is
it and how do I get it? If it even exists (which I doubt)
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
That manual is confusing in some parts. Like, how to make an auto_increment
column. how do I anyway? My database table needs it. Thanx
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
Except the problem is, this is done through an Active Server Page (ASP).
The user does the inserting, I just use variables and insert them.
TRANSLATION:: I have no control over what goes in the database until it's
there. So how can it be changed in the connection or sending process?
- Deryck H
Thanx dude. That helped. hey! Dont forget to check out my web site!! I'm
almost done with the source-code upload part.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]
Cc: MySQL [EMAIL
Let me rephrase that checkbox one::
TRUE or FALSE
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Mike Wexler [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Wednesday, September 05, 2001 10:19 PM
Subject: Re: How to do
Thank you to everyone who helped. That enum worked great and right after I
posted I checked the manual again for the columns and got it. Once again,
thanx, and I'll post more here. Anyway, the true false thing was for a
members section of my web site that says that if they confirmed their
I dont know if it's me or what but that Manual is driving me crazy just
searching! I cant find out how to copy a table and rename it at the same
time. pls help
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting,
Try something like putting a peice of code (asuming you are using something
like ASP/PHP)
Session_On_end()
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Claudio Muzzio [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 05, 2001 2:09 PM
Subject:
anyone to be able to
access my database.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Venu [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Wednesday, September 05, 2001 12:12 AM
Subject: RE: What does this error mean
Thnx
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Attila Soki [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 05, 2001 8:42 PM
Subject: Re: What does this error mean??!!
hi,
try to execute this query too:
FLUSH PRIVILEGES;
bye,
ati
How do I::
Add a column
Alter a table to fit a different character lengths (say...unlimited in a 1
column)
or
alter column to accept an unlimited amount of characters
Make a column have a check box instead of characters(VARCHAR...) or date
(DATE)
thanx
- Deryck H
-
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'
CheckUser.CursorLocation = 2
CheckUser.LockType = 3
CheckUser.Open
%
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Dennis Salguero [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]; MySQL
[EMAIL PROTECTED]
Sent: Tuesday, September 04, 2001 1:04 PM
Subject: Re
One problem:: Im new and dont know how to ping there. Help!!!
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Venu [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]; MySQL
[EMAIL PROTECTED]
Sent: Tuesday, September 04, 2001 3:09 PM
Subject: RE: Trouble w
I somehow doubt this will work but try this::
Select * from t1, t2 where...
Yeah, that wont work. i havent tried it but I think it aint gonna help. I
send this anyway just as a what if.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Islam, Sharif [EMAIL
[TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]' to database
'dbasename'
I get this every time I try to connect with mysql.
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
I know that!!! But how do I fix it? On the DSN, I put uid and pwd to blank
because I did the same in the ODBC UserDSN setup window.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Joshua J. Kugler [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]; Deryck
- Original Message -
From: Venu [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]; Joshua J. Kugler
[EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Wednesday, September 05, 2001 12:00 AM
Subject: RE: What does this error mean??!!
)-Original Message-
)From: Deryck Henson
I get this every time I try to start up MySQLD.exe::
Can't initialize InnoDB as 'innodb_data_file_path' is
not set
Someone help. Thnx!
- Deryck H
- http://www.comp-u-exchange.com
=
I love the Screen Savers
__
Do You Yahoo!?
Get email
I get this every time I try to start up MySQLD.exe::
Can't initialize InnoDB as 'innodb_data_file_path' is not set
Someone help. Thnx!
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
After doing that, I try to connect via DSN via ASP but I get this error::
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC]Can't connect to MySQL server on 24.254.141.32(10061)
If someone can help, please do.
- Deryck H
- http://www.comp-u-exchange.com
59 matches
Mail list logo