Re: multiple mysql statements in single php request

2003-07-09 Thread Rick Pasotto
Never mind. I've solved my problem. My create statement had an unquoted date in the select part. It works correctly now. On Wed, Jul 09, 2003 at 03:29:11PM -0400, Rick Pasotto wrote: > Is it possible to issue multiple sql statements in a single php request? > (Probably not since I g

multiple mysql statements in single php request

2003-07-09 Thread Rick Pasotto
ne row of the result set that's wrong. -- "A little inaccuracy sometimes saves tons of explanation." -- H. H. Munro (Saki) Rick Pasotto[EMAIL PROTECTED]http://www.niof.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

left join help

2003-07-09 Thread Rick Pasotto
s saves tons of explanation." -- H. H. Munro (Saki) Rick Pasotto[EMAIL PROTECTED]http://www.niof.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Why "unsigned" doesn't work?

2002-12-29 Thread Rick Pasotto
me text);' -- "All government is, in its essence, organized exploitation, and in virtually all of its existing forms it is the implacable enemy of every industrious and well-disposed man." --- H. L. Mencken Rick Pasotto[EMAIL PROTECTED]http://www.niof.net --

python classes and mysql

2002-08-13 Thread Rick Pasotto
the class which then creates a cursor. 3) The toplevel opens a connection and creates a cursor which is passed to the class. -- "No one can make you feel inferior without your consent." -- Eleanor Roosevelt Rick Pasotto[EMAIL PROTECTED]http://ww

changing column to auto-increment

2002-06-14 Thread Rick Pasotto
is a result of immature technology. Pollution is waste and ignorance." "The faster the economic growth rate, the faster pollution levels decline." --- Greg Rehmke Rick Pasotto[EMAIL PROTECTED]

Re: Date comparisions...

2001-05-02 Thread Rick Pasotto
are neither omniscient nor infallible, they must be free to agree or disagree, to cooperate or to pursue their own independent course, each according to his own rational judgment. Freedom is the fundamental requirement of man's mind." -- Ayn Rand Rick Pasott

Re: newbie question on variable length records.

2001-05-01 Thread Rick Pasotto
request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- "Tyranny is any political system (whether absolute monarchy or fascism or communism) that

Re: complicated query

2001-04-20 Thread Rick Pasotto
last_name = 'crosby', last_name; -- "Moderation in temper is always a virtue; but moderation in principle is always a vice." -- Thomas Paine, _The Rights of Man_ (1791) Rick Pasotto email: [EMAIL PROTECTED] ---

Re: complicated query

2001-04-20 Thread Rick Pasotto
" a > value of 1 and assign all other records a default value of 0. Let's call > the new field "order_1" Then you could construct an ORDER BY clause like: > > ORDER BY order_1, category... You don'

python on windows / mysql on linux

2001-04-05 Thread Rick Pasotto
ges who mean to govern well, but they mean to govern. They promise to be good masters, but they mean to be masters." -- Noah Webster Rick Pasotto email: [EMAIL PROTECTED] - Before posting, pleas

Re: About reserved words: mySQL's dirty little secret

2001-02-04 Thread Rick Pasotto
-- Alexis de Tocqueville Rick Pasotto email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request th

Re: display width in mysqlgui

2001-01-16 Thread Rick Pasotto
On Tue, Jan 16, 2001 at 03:04:23PM +0200, Sinisa Milivojevic wrote: > Gerald L. Clark writes: > > Rick Pasotto wrote: > > > > > > SELECT concat(last_name,", ",first_name) as name from members > > > > > > results in a column that is

Re: display width in mysqlgui

2001-01-15 Thread Rick Pasotto
On Mon, Jan 15, 2001 at 10:39:15AM -0600, Gerald L. Clark wrote: > Rick Pasotto wrote: > > > > SELECT concat(last_name,", ",first_name) as name from members > > > > results in a column that is much wider than necessary. Adding trim() to > > t

display width in mysqlgui

2001-01-15 Thread Rick Pasotto
at men who wish to deal with one another must deal by trade & give value for value." -- Ayn Rand Rick Pasotto email: [EMAIL PROTECTED] - Before posting, please check: http://www.mys