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 REPL
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 ins
but I don't know
how 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
---
t;[EMAIL PROTECTED]>
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;
> Integr
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 = artic
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 e
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 e
