RE: recommended books for web app.

Peter, If you put any in your email reply - none came through. Kerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 August 2004 05:21 To: [EMAIL PROTECTED] Subject: Re: recommended books for web app. -- MySQL General Mailing List For list archives:

Re: recommended books for web app.

Kerry, At 08:09 AM 8/12/2004, you wrote: I am looking to port an app from an existing web environment to MySQL. The requirement is relatively easy. The Tables are read only and the data is to be only accessed via login password. The login will give a limited view of records based on a

Can't start mysql server automatically

I configured MySQL to start automatically on a Sun Ultra10 running Solaris 9 as per the installation instructions installing the following scripts/links: - /etc/init.d/mysql - /etc/rc3.d/S99mysql - /etc/rc0.d/K01mysql The MySQL daemon however failed to start at system startup. The .err log

RE: recommended books for web app.

Thanks Mike, your recommendations are very much noted. Kerry -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: 15 August 2004 17:22 To: [EMAIL PROTECTED] Subject: Re: recommended books for web app. Kerry, At 08:09 AM 8/12/2004, you wrote: I am looking to port an app from

Re: Cannot be null problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Schalk Neethling wrote: | When sending form data via a form I get the following SQL error | | ERROR:-- SQLException - Message: The url cannot be null | SQLState: 08001 | ErrorCode :0 | | What does this mean? The row url, is not set to be not

Re: Can't start mysql server automatically

Well, clearly LD_LIBRARY_PATH isn't set at startup. That's one of the reasons LD_LIBRARY_PATH isn't really the Solaris way, and is not recommended. With a proper setup, you should never need LD_LIBRARY_PATH in Solaris. In any version of Solaris, you can build with -R /usr/local/lib to

ASP Connection to Mysql fails

I have an ASP application running on a server with a mysql DB, everything works great. I connect using localhost, no problems. I have a second mysql DB on another server. I connect to it via the odbc Data Source Administrator from the web server with no problems. When I try to connect from an

RE: ASP Connection to Mysql fails

Ignore the sentence that starts Remember... When I telnet to port 3307 on the DB server from the web server I get the version, a few characters of garbage and it disconnects. Paul -Original Message- From: Paul Stearns [EMAIL PROTECTED];] Sent: 8/15/2004 6:01:59 PM To: [EMAIL

Re: ASP Connection to Mysql fails

If I understand you correctly, you can connect to both mysql servers from localhost, but not to one from the other. To mysql, a user is a combination of user and connecting host, so I think your problem translates as you can connect as [EMAIL PROTECTED], but you cannot connect as [EMAIL

RE: Re: ASP Connection to Mysql fails

Actually I can connect from the web server to the DB server using DSN (the odbc tool under windows). What I cannot do is connect from ASP in the same way. I have a work around, but I still would like to determine what the problem is with a DSNless connection. The work around is to use a DSN

Count of two fields

select ListName, count(*), sum(Info is not null) from ListTable group by ListName = Original Message Follows = From: John Berman [EMAIL PROTECTED] Subject: Count of two fields Wonder if you can help I have a table with a number of fields but the List Name Member Info Ever member

Count even when empty

SELECT dbo.lists_.Name_, COUNT(dbo.members_.EmailAddr_) AS nojgid FROM dbo.lists_ INNER JOIN dbo.topics_ ON dbo.lists_.Topic_ = dbo.topics_.Title_ LEFT JOIN dbo.members_ ON dbo.members_.List_ = dbo.lists_.Name_ GROUP BY dbo.lists_.Name_, The first inner join gives you a

DESCRRIBE ALL TABLES

Dear friends, I have a database spec, I have pasted details from command prompt, to see structure of table I use following commands. use spec show tables describe account The last command displays the structure of table, Now can you guide me to a command, where in I can see structure of all

Re: DESCRRIBE ALL TABLES

[EMAIL PROTECTED] wrote: snip! some command like describe all tables so that i can see structure of all tables in database. I use a script to do this, if it's a help you are welcome to it: http://paradigmb.com/describe_MySQL.htm It produces a html page showing the database structure (all

RE: ASP Connection to Mysql fails

Armando: I tried the fully qualified domain name 'computer.domain.root', I also tried the IP address. Both worked on the odbc test, but not on the connect string. I have already gone the DSN route and it works, but it bugs me that the DSNless method doesn't work. My current hypothesis is that

Re: ASP Connection to Mysql fails

Then I misunderstood you. Sorry. Just to be certain, you are using the same user and password in both cases, right? Beyond that, I have no idea. ASP is really not my area. Perhaps someone else will have an answer. Michael Paul Stearns wrote: Actually I can connect from the web server to the

4.X binary for FC2?

Hi, I just tried to install the 4.0 binary compiled with the Intel compiler on Fedora Core 2 (FC2). I wasn't able to get it running. When I tried to start it, I got the error: Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! I discovered that this is a

Re: Kernel panic when mysql stop command issued

On Sat, Aug 14, 2004 at 03:01:06PM -0700, Demetrios Stavrinos wrote: Kernel panic: Fatal exception in interrupt...In Interrupt handler - not syncing message appears when the mysql-max stop is issued. Other than that everything works. I changed hardware (everything new) and re-installed Linux