It works fine for me in Oracle. <cfquery name="QMyQuery" datasource="" username="" password=""> SELECT * FROM SomeTable </cfquery>
returned the correct results; in this case the username and password are saved in the DSN. Just to test, I then did this: <cfset MyUName = ""> <cfset MyPW = ""> <cfquery name="QMyQuery" datasource="MYDSNHERE" username="#MyUName#" password="#MyPW#"> SELECT * FROM SomeTable </cfquery> which worked as well. So you are able to do what I did - add dbusername and dbpassword properties to the ini file and make them part of the instance data. On 7/14/06, Raymond Camden <[EMAIL PROTECTED]> wrote: > No. Reason being, if I remember right, you can't do username="". If > I'm wrong, I could add that post release. > > On 7/13/06, James Holmes <[EMAIL PROTECTED]> wrote: > > Since that release is coming soon, I'll wait. > > > > One thing I had to do in 5.0 was a global search/replace to add > > username and password attributes to the cfquery tags. Will this change > > in 5.1? > > > > On 7/14/06, Raymond Camden <[EMAIL PROTECTED]> wrote: > > > In the 5.1 release, Ive abstracted out the textarea call in the > > > editor. This will make it easier to use TinyMCE, or KTML, or whatever, > > > as it's just one file with a textarea (basically). You can get this > > > release from www.blogcfc.com and the Subversion service, but the > > > documentation has NOT been updated yet. Anyway, glad you like it. > > > > > > On 7/13/06, James Holmes <[EMAIL PROTECTED]> wrote: > > > > After having played with BlogCFC for the last hour, I have to say it's > > > > great. > > > > > > > > Thanks again Ray for all your work in helping to bring decent open > > > > source CF to the community. > > > > > > > > All it needs now is TinyMCE in the editor ;-) I'll add this myself. > > > > -- > > CFAJAX docs and other useful articles: > > http://www.bifrost.com.au/blog/ > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246542 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
