Complex conditional insert

2003-11-04 Thread Matt Young
d four separate case statements for each succeeding column) or CASE @type WHEN "equity" THEN [do this complete INSERT statement WHEN "equity" THEN [do this different INSERT statement WHEN "equity" THEN [do this INSERT statement or none of the above Matt Young E

New combined MySql and Html development platform

2003-10-23 Thread Matt Young
of c code. To gain access to the development environment, click Develop on the left from of the opening page. Matt Young Everyday Software -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Multiple sql lines in command line tool

2003-10-15 Thread Matt Young
queries on one line. I wonder what the catch is. I have gotten the embedded application running, instead of pipes. And I evidently lose the ability to submitt multiple sql statements. I wonder how I can obtain that capability back. Matt Young -- MySQL General Mailing List For list archives

Big time newbie question on embedded linking

2003-10-14 Thread Matt Young
I have both the standard and source mysql, and I am attempting a link with a simple program that calles mysql_server_init and mysql_server_end. I have tried various library call outs to find these two calls in both the standard and source mysql directories. I have not located these in any of th

Missing library named 'z' ??

2003-10-13 Thread Matt Young
The manual says: " For example, if the library is installed in `/usr/local/mysql/lib', use -L/usr/local/mysql/lib -lmysqlclient -lz on the link command. " But I found no z library? Matt Young -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

More on Uscript

2003-10-13 Thread Matt Young
similiar capability announced by IBM for DB2. Matt Young [EMAIL PROTECTED] Saratoga, CA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Detecting error when no data is served

2003-10-13 Thread Matt Young
I am running mysql through a pipe with flags -s -n -R -r which works fine except a pipe read hangs when there is no data for a query. I tried many things, nothing works. Running on Linux with version 3.23,53 Thanks Matt Young -- MySQL General Mailing List For list archives: http

U Script, a lightweigt middleware for MySQL

2003-09-25 Thread Matt Young
Uscript Some months ago I developed a lightweight middle layer between MySql and the web. The purpose was experimentation with web programming without the complexity of a standard middleware layer. I will describe the system to you, and make the source available if anyone wants to experiment w

What terminates a query?

2002-12-23 Thread Matt Young
My sql command pipes its result to a perl program (in batch mode) . but the perl program has no waf to tell when the query is finished. HTTP uses a blank line to signal the end. but there is no such thing for mysql. - Before po