Ask a Question related to Coldfusion Database Access, Design and Development.
-
wins1 #1
DSN-less code?
I am new to CF and am doing some hands on exercises on accessing an Access mdb
file using CFML. I have had to first set up a Datasource in the CF
Administrator before I can use <cfquery datasournce="db name">. Is there a way
to have a DSN-less coding in CF like what you have in ASP, without having to
set up the datasource in the Administrator? If so how is this done in
ColdFusion? Thanks.
wins1 Guest
-
Why doesn't the Code Completion occur in FlexBuilder IDEwhen source code is in an external file?
I am seperating my .as from the MXML by using the following in my file.mxml: <mx:Script source="file.as"> When I edit file.as, the code... -
How would I include the Open Browser code into this lineof code?
Hello and thankyou in advance: I have an ASP page linked to my database and I want to apply the Open Browser behaviour to the code. I have tried... -
Custom control fires event but ignores some code in the code behind file
I do not quite understand the question. I will merely point out that most programming problems happen for a reason. Code works the way it is... -
Custom tool warning: DiscoCodeGenerator unable to initialize code generator. No code generated.
I created a brand new WebService (HelloWorld) and when I attempt to add this WebService to a WindowsForm project I get the following error message in... -
Security problem with Managed Code calling Unmanaged Code in a Web Page
Hello, I have a web page which contains an ActiveX control (unmanaged) and a Windows Forms User Control (managed). Both reside on a web page and... -
JMGibson3 #2
Re: DSN-less code?
Assuming MX7, short answer is no. Long answer is you can create one
on-the-fly, but it's not DSN-less. The DSN actually exists and can be seen
from the Administrator. For interrogating DB's I've attached some code I use
to continually overlay one I call dynDB. I suppose you could figure out how to
Delete it afterwards, but still strictly-speaking it's not DSN-less.
<!--- The gyrations here are insane.
When we login to the administrator the security cookie will be
changed and stop working. We have to temporarily change to a
fake session, let administrator do it's thing and then change
back. Fortunately none of the original Session values or
Session cookies are lost with this method.
--->
<cfset varAppName = Application.applicationname>
<cfset varDBFreeForm = Session.DBFreeForm>
<CFAPPLICATION NAME="retain_real_app"
SESSIONMANAGEMENT="Yes"
loginstorage="cookie">
<cfinvoke component="CFIDE.adminapi.administrator" method="login">
<cfinvokeargument name="adminPassword" value="sappi"/>
</cfinvoke>
<cfinvoke component="CFIDE.adminapi.datasource" method="setMSAccessUnicode">
<cfinvokeargument name="name" value="DynDB"/>
<cfinvokeargument name="DatabaseFile" value="#varDBFreeForm#"/>
<cfinvokeargument name="driver" value="MSAccessJet"/>
<cfinvokeargument name="class" value="com.inzoom.jdbcado.Driver"/>
<cfinvokeargument name="pooling" value="no"/>
<cfinvokeargument name="username" value=""/>
<cfinvokeargument name="password" value="">
</cfinvoke>
<cfinvoke component="CFIDE.adminapi.administrator" method="logout">
</cfinvoke>
<CFAPPLICATION NAME="#varAppName#"
SESSIONMANAGEMENT="Yes"
loginstorage="cookie">
<CFQUERY NAME="GetListEntries" datasource="DynDB">
SELECT Type,
Flags,
Name,
CStr(DateUpdate) as strDateUpdate
FROM MSysObjects
WHERE Type <> 2 AND
Type <> 3 AND
Type <> 8 AND
Type <> -32757 AND
Type <> -32758 AND
Left(Name,1) <> '~' AND
Left(Name,4) <> 'MSys'
ORDER BY #varSortBy#
</CFQUERY>
JMGibson3 Guest



Reply With Quote

