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]>
T
onfusing and doesn't 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 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, Octobe
ment (Try to
do 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&quo
ideas?
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
from an ASP page. 'search' is a variable that
is asigned the value of the query string 'search'
dim search
search = request.querystring("search")
Thanx. I'm hoping to test this on my database soon (the InnoDB)
**
- Deryck Henson
- http://www.comp-
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
, and more! 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-ex
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
**
-
B
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:
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 manu
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: R
How do I count the number 's in each record in a field?
Like this situation:
Johnny has INSERTed data that looks like this:
'Hi mom,
How are you?'
Then he does it again
'Hi mom,
How are you?'
He now wants to count the number of 's in all of the records he has
inserted all together from one
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:
>
First off, the line of code where he has this is wrong::
if (mysql_create_db ($DName, $Link)) {
it should have DBName, not DName. That could be a big issue when executing.
Second, I have no expirience with PHP but am great with ASP and believe that
the term 'echo' would work better than 'print'
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 check
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:
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
- h
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("co
#x27;loyd'
union
...)
repeat to table 15. Since 15 tables have 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:
le_path text, title text, description
text, codeid text, rating int, votes int, views bigint, date_created
datetime, level enum ('all', 'novice', 'intermediate', 'advanced')
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: &qu
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]&
u 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
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
d
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 l
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: "
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
SELEC
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', 'valueforcolumn
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 a
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: <[E
-
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 allofth
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 ?
>
>
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, if
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
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"
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
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:
http://ww
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:
http://www.my
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 S
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 Hens
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)
http://li
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, ple
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 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: We
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
- http://www.comp-u-exchange.com
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;
>
> b
e worked. any suggestions? I want 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
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
Subje
change.com
- 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: R
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 Hens
[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:
http://www.my
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 PRO
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:
x27;", "''") + "' AND Confirmed = TRUE"
CheckUser.CursorType = 0
CheckUser.CursorLocation = 2
CheckUser.LockType = 3
CheckUser.Open
%>
- Deryck H
- http://www.comp-u-exchange.com
----- Original Message -
From: "Dennis Salguero" <[EMAIL PROTECTED]>
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
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
--
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:
http://
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 ale
61 matches
Mail list logo
