Save Values with comma separated.

Question

Hi

I have below code . I want if multiple recrods are retreived then email addtress should be stored in var address with comma separated.

var addresses = "[email protected]","[email protected]" ;

String _StrSQL = "SELECT T0.\"Email\" , T0.\"T0.CntctPrsn\" " +
            "FROM \"ATULAYA_NEW_LIVE\".OCPR T0 " +
            "INNER JOIN OVPM T1 ON T0.\"CardCode\" = T1.\"CardCode\"  " +
            "where T1.\"DocEntry\" = 62960";

Thanks

Sophia Carter · Answer

Absolutely! In the provided code snippet, the SQL query retrieves email addresses from a specific database based on certain conditions. If multiple records are retrieved, and you want to store those email addresses in a variable with comma separation, you can adjust your code to concatenate the email addresses accordingly. Here's how you can modify your code to achieve this: String _StrSQL = "SELECT T0.\"Email\" , T0.\"T0.CntctPrsn\" " + "FROM \"ATULAYA_NEW_LIVE\".OCPR T0 " + "INNER JOIN OVPM T1 ON T0.\"CardCode\" = T1.\"CardCode\" " + "where T1.\"DocEntry\" = 62960"; ResultSet rs = stmt.executeQuery(_StrSQL); // Assuming you have a statement object for execution String addresses = ""; // Initialize the variable to store email addresses while (rs.next()) { String email = rs.getString("Email"); addresses += email + ","; // Concatenate the email with a comma separator } // Remove the trailing comma, if any if (addresses.endsWith(",")) { addresses = addresses.substring(0, addresses.length() - 1); } System.out.println("Email Addresses: " + addresses); // Print or use the comma-separated email addresses as needed This modified code snippet will fetch email addresses from the database and store them in the `addresses` variable with comma separation. Additionally, it ensures that there is no trailing comma at the end of the `addresses` string. Feel free to incorporate this logic into your existing codebase. If you have any more questions or need further clarification, please let me know!