Mailing List Archive


Back to the month index Back to the list index
bonsai@net5.co.jp
Mon, 9 Sep 1996 14:34:57 +0900 (JST) 

Date: Mon, 9 Sep 1996 14:34:57 +0900 (JST)
From: bonsai@net5.co.jp
Message-Id: <199609090534.OAA08184@sun1.net5.co.jp>
Subject: [mSQL] mSQL/Java Query Exception

My first attempt at using the Java/mSQL programming interface isn't going as
planned.

I execute the following :

  result = msql.Query("insert into cdiusers
                        values (nameval, emailval, usernameval, passwdval,
                                URLval)");

Which appears to be a valid SQL Statement to me, but it throws the exception :

         oops: QUERY: QUERY: :syntax error near "nameval"

The variables I'm trying to insert are strings, and they are being inserted
into character fields within the database. I've stared at it long enough,
maybe I'm just overlooking something obvious ?

  Any hints?

    Byron (a.k.a Bonsai)

    - who thought Java was going to be a problem, not SQL.
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!