\

-----Original Message-----
From: Margaret Fisk [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 3:00 PM
To: [EMAIL PROTECTED]
Subject: Basic Java question about Quotation Marks


Hi everyone,

I've got a basic question about quotation marks that I can't figure out.

I'm trying to pass an array as a string argument to an SQL query.

I have an array that identifies a user and their associated area, both by
Strings as the identifier.

I need to end up with a String that contains all the associated areas in
double quotes, separated by commas.

i.e.

Array
        0               1
        User1   homework
        User2   Gym
        User3   Math
        User1 Science
        User2   English
        User1   Chess Club

Using a for loop, I collect all the array[1] values associated with User1
and put them into a string

areas=areas+',"'array[i][1];

What I need is "homework","Science","Chess Club" to be used in an in
statement for the sql query.

I tried to use single quotes to prompt Java to ignore the double quote
character (it works in Perl) but it still gives me compilation errors.

Does someone have an approach that works?

Thanks,
Margaret

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

Reply via email to