"No Database Selected" error - only one .asp page affected

This is quite odd. I have five .asp pages all using the exact same connection code. For some reason, one of the pages is getting a "No Database Selected" error, yet the other four are not, which leads me to believe my DSN config works fine. Below are the details. Getting the following error:

Re: not quite sure, mysql C programming

Christian Parpart <[EMAIL PROTECTED]> wrote on 08/26/2005 05:13:21 PM: > Hi all, > > before I gonna spam you with mysql questions regarding the official > libmysqlclient C API, I'd really like to know wether I've finally > found the right list for this. > > Is this? If not, please point me to

RE: Union vs OR

"Gordon Bruce" <[EMAIL PROTECTED]> wrote on 08/26/2005 05:04:17 PM: > It's getting late on Friday, but couldn't you build a table with all of > the parameter combinations and then just join against that table? > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > S

not quite sure, mysql C programming

Hi all, before I gonna spam you with mysql questions regarding the official libmysqlclient C API, I'd really like to know wether I've finally found the right list for this. Is this? If not, please point me to the right direction :) Thanks in advance, Christian Parpart. pgp1f8WwwavWL.pgp Desc

RE: Union vs OR

It's getting late on Friday, but couldn't you build a table with all of the parameter combinations and then just join against that table? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 4:25 PM To: mysql@lists.mysql.com Subject: Union vs

Union vs OR

I have a table that holds attributes for users. This is the structure: TABLE properties ( id int(11) NOT NULL, userid int(11) NOT NULL, attrType int(11) NOT NULL, attrValue text NOT NULL, FULLTEXT KEY propValue (propValue) ) TYPE=MyISAM; The table is used to find people based on criteri

Re: confirm subscribe to mysql@lists.mysql.com

On Friday 26 August 2005 22:17, [EMAIL PROTECTED] wrote: > To confirm that you would like > > [EMAIL PROTECTED] > > added to the mysql mailing list, please click on > the following link: > > http://lists.mysql.com/s/mysql/430f78eb4e4f3860/trapni=gentoo.org > > This confirmation serves two purpo

Innodb TableSpace Free and Total Size

Using SQL : SHOW TABLE STATUS, we could see Innodb free size from inno db table's comment. Is there any SQL to know total tablespace size allocated? -- Regards, Ady Wicaksono HP: +628562208680 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: InnoDB: Error: tablespace size stored in header is 640000 pages, but the sum of data file sizes is 1056000 pages

Reply by me. How stupid i'm :( I've finished this warning error problem by adding 4 files --> 3 file each 3 Gbyte and 1 file 500Mbyte Thx mr. heiiki :D Sorry Ady Wicaksono wrote: |Dear All, As subject, Actually i've been ever meet this case when i see : InnoDB: Error: tablespace size

InnoDB: Error: tablespace size stored in header is 640000 pages, but the sum of data file sizes is 1056000 pages

|Dear All, As subject, Actually i've been ever meet this case when i see : InnoDB: Error: tablespace size stored in header is 877184 pages, but InnoDB: the sum of data file sizes is 953856 pages And Mr. Heikki tell me to do these steps: (953856 - 877184) / 64 = 1198 MB 1) Stop the mysqld ser

Re: Compare two tables

Alfredo, If you are using MySQL 5.02 or later, here is an information_schema query that will list table structure _differences_. The idea is to group the UNION of rows in information_schema.columns for the two tables on all information_schema.columns columns, then use HAVING to pick only thos

Re: SELECT ... JOIN with NULL values

Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/26/2005 02:30:08 PM: > [EMAIL PROTECTED] wrote: > > Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/26/2005 02:08:50 PM: > > > > > >>Hi list, > >> > >>I have a query like this (the original is very big and names of > >>columns/tables are in portuguese)

Re: SELECT ... JOIN with NULL values

Sorry for replying to mysqlf, but it really solved the problem: there were another JOIN that had to be transformed to a LEFT JOIN. Thanks. Nuno Pereira wrote: [EMAIL PROTECTED] wrote: Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/26/2005 02:08:50 PM: Hi list, I have a query like this (th

Re: SELECT ... JOIN with NULL values

[EMAIL PROTECTED] wrote: Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/26/2005 02:08:50 PM: Hi list, I have a query like this (the original is very big and names of columns/tables are in portuguese): SELECT * FROM tbl1 t JOIN tbl2 u ON (t.id_tbl2=u.id) For a schema like this: CREATE TABLE

Re: Storing underscores ( _ ) in database tables

--- [EMAIL PROTECTED] wrote: > Please, please! read up on normalization. The way I > would probably handle > this design issue is by creating a separate table of > taxonomic names (I > know this is very different than my previous advice > but I have had longer > to think about it). OK, I'll ha

Re: SELECT ... JOIN with NULL values

Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/26/2005 02:08:50 PM: > Hi list, > > I have a query like this (the original is very big and names of > columns/tables are in portuguese): > > SELECT * FROM tbl1 t JOIN tbl2 u ON (t.id_tbl2=u.id) > > For a schema like this: > > CREATE TABLE tbl2 ( >

SELECT ... JOIN with NULL values

Hi list, I have a query like this (the original is very big and names of columns/tables are in portuguese): SELECT * FROM tbl1 t JOIN tbl2 u ON (t.id_tbl2=u.id) For a schema like this: CREATE TABLE tbl2 ( id INT NOT NULL auto_increment PRIMARY KEY, data_col2 int NOT NULL ) ENGINE=InnoDB; CR

Re: AES_DECRYPT output

Hello. How does your application connect to MySQL server (MyODBC or Connector/Net)? What versions of MySQL Server and Connector do you use? "M DR" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm currently using AES Encryption to encrypt some of my data (using it in a > ASP.NET application)

Re: Welsh language support

Hello. Have a look here: http://dev.mysql.com/doc/mysql/en/adding-character-set.html >I've been trying to look at the possibilities of adding Welsh language >support to mysql, >both as support for latin8 and a Welsh collation. > > Is anyone else working on something similar who could

Re: Compare two tables

> > You could check the table DDL. > > > > Or use a third party tool, like Database Workbench, that can do this for > > you and even generator a change script. Check www.upscene.com > > > > With regards, > > > > Martijn Tonies > > Hmmm. No Linux version. Thank you anyway. Nope, indeed. Se

Re: Per-thread memory use question

On Fri, Aug 26, 2005 at 10:39:16AM +0300, Gleb Paharenko wrote: > Hello. > > Have a look here: > > http://dev.mysql.com/doc/mysql/en/memory-use.html Hi, I had looked there, and other pages like it, but haven't found anything that says specifically whether threads free the memory as soon as th

Re: create "serial number" by select

Gyurasits Zoltán wrote: Hi, Yes! And the "SELECT" contain some table! SELECT (??) FROM table1 INNER JOIN table2 I have a problem with the follow solution: SET @count:=0; SELECT @count:[EMAIL PROTECTED] AS `count`, `value` FROM `table`; I can't execute more select in my system. (Del

Re: Compare two tables

El Viernes, 26 de Agosto de 2005 08:56, Gordon Bruce escribió: > If you have the 5.0.x version of MySQL then INFROMATION SCHEMA can give > you what you want. i.e. > > SELECT a.*, b.* > FROM INFORMATION_SCHEMA.COLUMNS AS a >INNER JOIN _SCHEMA.COLUMNS AS b >ON (a.column_name

Re: Compare two tables

On Fri, 2005-08-26 at 09:14 -0600, Alfredo Cole wrote: > El Viernes, 26 de Agosto de 2005 08:16, Martijn Tonies escribió: > > > > You could check the table DDL. > > > > Or use a third party tool, like Database Workbench, that can do this for > > you and even generator a change script. Check ww

Re: Compare two tables

El Viernes, 26 de Agosto de 2005 08:16, Martijn Tonies escribió: > > You could check the table DDL. > > Or use a third party tool, like Database Workbench, that can do this for > you and even generator a change script. Check www.upscene.com > > With regards, > > Martijn Tonies Hmmm. No L

RE: Compare two tables

If you have the 5.0.x version of MySQL then INFROMATION SCHEMA can give you what you want. i.e. SELECT a.*, b.* FROM INFORMATION_SCHEMA.COLUMNS AS a INNER JOIN _SCHEMA.COLUMNS AS b ON (a.column_name = b.column_name) WHERE a.TABLE_NAME = 'foo_1' AND b.TABLE_NAME = 'foo

Re: Compare two tables

Hi, > I need to compare the structure of two tables (fields, field types, field > lengths, indices, etc.) to determine if they have the same schema, even if > the fields may be in a different order. Is there a command in mysql that will > do this? This will be used to determine if the tables are b

Re: Compare two tables

Alfredo Cole <[EMAIL PROTECTED]> wrote on 08/26/2005 10:07:30 AM: > Hi: > > I need to compare the structure of two tables (fields, field types, field > lengths, indices, etc.) to determine if they have the same schema, even if > the fields may be in a different order. Is there a command in my

Re: Storing underscores ( _ ) in database tables

David Blomstrom <[EMAIL PROTECTED]> wrote on 08/26/2005 01:32:08 AM: > (Sorry if this is a repeat; I think my first post > didn't go through.) > > I'm still stuck on the problem I asked about a day or > two ago. I'm working on a page at > http://www.geozoo.org/stacks/ that draws data from a > ta

Compare two tables

Hi: I need to compare the structure of two tables (fields, field types, field lengths, indices, etc.) to determine if they have the same schema, even if the fields may be in a different order. Is there a command in mysql that will do this? This will be used to determine if the tables are basica

AES_DECRYPT output

Hi, I'm currently using AES Encryption to encrypt some of my data (using it in a ASP.NET application). As this is all text strings, I was wondering if there is a possibility to automatically have the output in the ASP.NET String format instead of the system.byte[] format, so I won't have to fo

Welsh language support

Hi there. I've been trying to look at the possibilities of adding Welsh language support to mysql, both as support for latin8 and a Welsh collation. Is anyone else working on something similar who could possibly offer some pointers, or is there a good description of the format of the collatio

Re: Per-thread memory use question

Hello. Have a look here: http://dev.mysql.com/doc/mysql/en/memory-use.html Pete Harlan <[EMAIL PROTECTED]> wrote: > Hi, > > This formula shows up in a few places (this is from > ): > >min_memory_needed = global_buffer

Re: Storing underscores ( _ ) in database tables

David Blomstrom wrote: I'm still stuck on the problem I asked about a day or two ago. I'm working on a page at http://www.geozoo.org/stacks/ that draws data from a table that lists animal taxons (orders, families, species, etc.) in a child-parent relationship. It works exactly the way it should