text string by
putting apostrophe's in etc.. I know the deleteheadline variable has a
numerical value because I response.write the variable before the error
occurs. Any help you be greatly appreciated.
Thanks,
Dave Carter
Chief Web Archit
Are there any online resources out there for uploading files and storing
them as BLOB objects in mySQL?
I'm using VBScript.
Thanks,
Dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
htt
LOL!!!
-Original Message-
From: Dan Harrington [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 11:47 AM
To: Wee Chua; PHP (E-mail); MySQL (E-mail)
Subject: RE: [PHP] Email Software
try http://www.spamcop.net, they are experts in it.
> -Original Message-
>
The Best:
By Dave Carter
SELECT * FROM tbl_experience
WHERE knowledge like '%SQL%'
ORDER BY least_expense
GROUP BY by no_equal;
Result: MySQL
Ok so it's a little hokey, but it was the best I could after the conversion
project I just got out of, thank god for MySQL.
Dave C
Access and MS-SQL Server have a method called @@IDENTITY used in retrieving
the last inserted ID of a recordset. Is mySQL ok with that command. I
suppose I could try it, but I'm interested in views etc. also.
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
: Thursday, September 06, 2001 5:04 PM
To: Dave Carter; [EMAIL PROTECTED]
Subject: Re: Last Inserted Record Question
LAST_INSERT_ID() is similar. It will give you the value for autoincrement
fields. Note that this is connection dependent ( so your last_insert_id() is
not the same as my last_insert_i
I use ASP and mySQL. I love it!
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.net
717.464.2970
-Original Message-
From: L_U_I_Z [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 4:08 PM
To: [EMAIL PROTECTED]
Subject: ASP & MySQL
I've been scouting around for hosts that offer both W2k/NT support as well
as mySQL, but I haven't been able round up one! is there a good reason for
this? It seems to me that the hosting public is just not educated that mySQL
even can run on NT.
Thoughts?
Dave Carter
Chief Web
I'm working a project with the same exact scenario right now. My ver. of
mySQL is 3.23.xx and my client's is 3.22.xx. there table sturcturing is ISAM
and mine is myISAM. The only I've been able to transfer succesfully is by
dumping all the data and re-importing on the clients end.
-Original M
correct me if I'm mistaken, but I believe the latest version of mysql is
3.23.38
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 1:04 PM
To: [EMAIL PROTECTED]
Subject: MySQL 4.0 FULLTEXT SPEED
Hi Everyone,
I
not there
hence the error. Check to make sure any auto-increment data is inserting
like it should.
my (2cents(US)) (2.5 cents(UK)) (.9 cents(CA)) (God only know how many
pesos, rubbles, yen, or euros)
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.
o get into the
db. I took "%" to mean from ANY host??? Am I mistaken or is this a bug?
Version mysql : 3.22.33
Linux Version : Cobalt 6.0 (RH 6.0)
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.
ection = Conn_STRING
This assumes VBScript
On an off note, I suggest you make the connection string an include file, so
that if the name changes or the pw changes or whatever, you will not have to
change every page in your site.
Hope this helps you,
Dave Carter
Chief Web Architect
Accelerated Busine
According to Chili's website they do support 3.23
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-Original Message-
From: Putri Alam [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 18, 2001 10:46 AM
To: '[EMAIL PROTECTED
hat
aren't already in a table, without calling the table first? Can this be done
in SQL?
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-
Before posting, please
Well I was hoping to be able to do it in SQL, however I do know it can be
accomplished in the middleware. I am seriously considering it as my deadline
is approaching quickly
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-Original
t the update clause, but I find the
documentation not satisfying. Can I use all these clasues in an update sql
statement, assuming 3.22.32 on RH 6.2
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464
Using temp table... thanks I don't understand why this isn't legitimate
SQL however. I would think that it should be supported
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-Original Message-
From: Don Read [mai
www.accessmysql.com
I use it when doing conversions
free download too
Cost ya 30 dollars US not get annoying messages every 5 or 10 minutes
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-Original Message-
From: Mitchell
When I execute this in mysql it works fine, but when I execute it on a web
page it gives a "Not Unique table/alias 'sporttable'
I would expect errors if 'playerpayment' was in my FROM clause but as you
can see it is not.
Note my example:
INSERT INTO playerpayment ( Family_ID, Player_ID, Player_
I need to generate a RANDOM UNIQUE number for every new record. Is there an
easy way to accomplish this inside of mySQL.
TIA
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
(mail filter bologna: sql,database,query
my experience with web hosts is that they usually give you one database per
domain name hosted. So you likely CAN'T create another db that you can
administer in this fashion.
bummer,
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464
This does not return any results
SELECT LAST_INSERT_ID() FROM tablename;
there is an indexed, auto-incrementing field in the table, but it refuses to
show any results. I don't understand the manual's text, so any help would be
appreciated.
Dave Carter
Chief Web Architect
A
So in my insert into select, I would just add another Select Like
this:
INSERT INTO tablename (field1,field2,field3)
SELECT table2.field1, table2.field2, table2.field3
FROM table2
SELECT LAST_INSERT_ID();
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http
UID is the unique ID number. Can you see a flaw in
this logic?
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 4:25 PM
To: Dave Carter
Is there a way inside of mysql to force the case of data being inserted into
the database???
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-
Before posting, please
ayertable WHERE
playertable.Family_ID = familytable.fid AND playertable.SportRegistered =
'0' GROUP BY fid ORDER BY Family_Last_Name ASC;
This works fine, but I also want to show Families with NO matching records
in the player field, which the above statement does not do.
TIA,
Dave C
27 matches
Mail list logo
