Skip to main content
A
Anonymous
October 31, 2009
Answered

Connection String - Coldfusion Administrator

  • October 31, 2009
  • 2 replies
  • 1816 views

Is it possible to have more than one connection string parameter setup in CF8????

CF Admin only lets me do one or the other but not both.  I need to set both of the following...

jdbcCompliantTruncation=false

zeroDateTimeBehavior=convertToNull

I tried many options.  Finally CF8 Admin let me do this... connectstring="jdbcCompliantTruncation=false;zeroDateTimeBehavior=convertToNull" but it didn't fix the error in my app.

I can pick the error I like better but that is hardly a solution.  Can someone please help???

    This topic has been closed for replies.
    Correct answer -__cfSearching__-

    connectstring="jdbcCompliantTruncation=false;zeroDateTimeBehavior=convertToNull

    Did you try separating the parameters with an "&", like in a URL?

    jdbcCompliantTruncation=false&zeroDateTimeBehavior=convertToNull

    I can pick the error I like better but that is hardly a

    solution. 

    Ah. The not-so-popular eenie meenie miney moe method of constructing connection strings.

    2 replies

    A
    Adam Cameron.
    Inspiring
    October 31, 2009

    What do you mean by "CF Admin only lets me do one or the other but not both".  How does it manifest not "letting you" do it?

    Using semicolons to delimit the params should work.

    --

    Adam

    -
    -__cfSearching__-Correct answer
    Inspiring
    October 31, 2009

    connectstring="jdbcCompliantTruncation=false;zeroDateTimeBehavior=convertToNull

    Did you try separating the parameters with an "&", like in a URL?

    jdbcCompliantTruncation=false&zeroDateTimeBehavior=convertToNull

    I can pick the error I like better but that is hardly a

    solution. 

    Ah. The not-so-popular eenie meenie miney moe method of constructing connection strings.

    A
    Anonymous
    October 31, 2009

    I guess I should have thought of & since i use it everyday in my cf code.

    Thanks cfsearching!

    Semicolon does not work by the way...

    A
    Adam Cameron.
    Inspiring
    October 31, 2009

    Semicolon does not work by the way...

    Hmmm.  I was about to say "use ampersands, because it follows standard URL conventions", but began to doublt myself (it's not something I need to do very often, so was not prepared to rely on memory alone).  All the docs I googled up were suggesting semi-colons, so I went with the flow.

    I should have backed myself.

    Sorry for the bum steer.

    --

    Adam

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices