Hello everybody...
I have a table with 3 columns (companyno, discountgroup, discount) it can
look like this
companyno, discountgroup, discount
12345,1,10
12345,2,20
12345,3,0
98765,1,15
98765,2,10
Can I use the
I'm using MySQL from ASP pages, I use MyODBC 3.50 and have a problem with a
query. If I type the query directly in mysql it works OK but from ASP pages
I get an error.
I'm trying to use a multiline query separated by ; like this
query1;query2;
If I do like this
query1;
execute
query2;
execute
I have a problem that i don't know if mysql can solve, my customer wants the
date format to be
YYWWD (year,week, day of week)
Its no problem with geting a date from the database in this format typing
select DATE_FORMAT('020515', '%y%v%w');
Now to the problem, is there any way I can make an
to set these options.
So far my Database is pretty small with just 20 tables but it will grow fast and i
want to use the best connection from start.
Anybody have any ideas?
Regards Mattias Persson
-
Before posting, please check
]
To: Mattias Persson [EMAIL PROTECTED]
Cc: MySQL List [EMAIL PROTECTED]
Sent: Monday, December 31, 2001 4:46 AM
Subject: Re: OleDB
This works for me...
var connectionString = Provider=MySqlProv;
Integrated Security='';
Password=1234abcd;
User ID=root;
Location=localhost;
Extended Properties
Anyone know how to write a connectionstring for the OleDB in ASP. I get all
different kinds of errors when i try to do this.
I write
rsDB.ActiveConnection =Provider=MySQLProv; Data
Source=server=localhost;DB=test
but it don't work
I have two tables, one for the articles and one with orderrows. When I update the
price in the article table i want to make a query to update the price in orderrows on
all rows with a certain orderstatus.
I can't figure out how to write this query...
I tried
UPDATE orderrows SET price =
My query:
SELECT vgrupp, type, count(*) FROM main GROUP BY vgrupp, type
I have a problem with MySQL and a query. If I type the Query in a program with direct
db connect, in my case EMS Mysql manager, everything works OK but when I use it from
an ASP page it don't. I don't get any matches, it
My query:
SELECT vgrupp, type, count(*) FROM main GROUP BY vgrupp, type
I have a problem with MySQL and a query. If I type the Query in a program with direct
db connect, in my case EMS Mysql manager, everything works OK but when I use it from
an ASP page it don't. I don't get any matches, it