This may seem obvious or not helpful, but have you tried overwriting with *
attributecollection*? Although it's not shown in the manual for cfquery
(grrr) it should work.
<cfset myParams = {
datasource:#application.alternateDS#,
username:#user#,
password:#pass#
} />
<cfquery attributecollection="#myParams#" >
Select etc...
</cfquery>
Let us know if attribute collection works for you!
Thanks,
Aaron J. White
On Friday, June 7, 2013 12:51:18 PM UTC-5, [email protected] wrote:
>
> Since upgrading from OpenBD 2.0 to OpenBD 3.0 the username and password in
> cfquery no longer override the username and password set in bluedragon.xml.
> Is this a bug or do I need to alter my configuration in some way? Below are
> my datasource and query (scrubbed for security). In 2.0 the query runs as
> "anotheruser" but in 3.0 it runs as "testuser".
>
> My datasource config:
>
> <datasource name="foo">
> <displayname>foo</displayname>
> <password>bar</password>
> <connectionretries>0</connectionretries>
> <sqldelete>true</sqldelete>
> <sqlupdate>true</sqlupdate>
> <username>testuser</username>
> <drivername>com.sybase.jdbc4.jdbc.SybDataSource</drivername>
> <sqlstoredprocedures>true</sqlstoredprocedures>
> <perrequestconnections>false</perrequestconnections>
> <sqlinsert>true</sqlinsert>
> <sqlselect>true</sqlselect>
> <connectiontimeout>120</connectiontimeout>
> <port></port>
> <server></server>
> <databasename></databasename>
> <description></description>
> <connectstring></connectstring>
> <verificationquery>select srvname from sysservers</verificationquery>
> <logintimeout>120</logintimeout>
> <initstring></initstring>
>
> <hoststring>jdbc:sybase:Tds:server.my.domain:5000/master?APPLICATIONNAME=OpenBlueDragon</hoststring>
> <maxconnections>24</maxconnections>
> <name>foo</name>
> </datasource>
>
> My query:
>
> <cfquery name="Authenticate" DATASOURCE="foo" username="anotheruser"
> password="password123" >
> select * from foo_table
> </cfquery>
>
>
--
--
online documentation: http://openbd.org/manual/
http://groups.google.com/group/openbd?hl=en
---
You received this message because you are subscribed to the Google Groups "Open
BlueDragon" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
