D
dlongnecker
Guest
On the coldfusion DSN advanced connection settings, I can add one setting, but I can't add two.
This will work: zeroDateTimeBehavior=convertToNull
But if I try to add another one, seperated by a semicolon, it doesn't recognize the semicolon as the break and complains:
zeroDateTimeBehavior=convertToNull;zeroDateTimeBehavior=convertToNull;
java.sql.SQLException: The connection property 'zeroDateTimeBehavior' only accepts values of the form: 'exception', 'round' or 'convertToNull'. The value 'convertToNull; zeroDateTimeBehavior=convertToNull;' is not in this set.
Is there a way to add multiple connection strings?
This will work: zeroDateTimeBehavior=convertToNull
But if I try to add another one, seperated by a semicolon, it doesn't recognize the semicolon as the break and complains:
zeroDateTimeBehavior=convertToNull;zeroDateTimeBehavior=convertToNull;
java.sql.SQLException: The connection property 'zeroDateTimeBehavior' only accepts values of the form: 'exception', 'round' or 'convertToNull'. The value 'convertToNull; zeroDateTimeBehavior=convertToNull;' is not in this set.
Is there a way to add multiple connection strings?