<cfset file
= "FILENAME"> <!--- This is an optional variable
--->
<cfset type="ApplicationType"> <!---This is required
--->
<cfinclude template="\cfcontent\cfcontent.htm">
Do I need to specify a mail server for using CFMail?
Using the CFMail tag does not require a mail server name. Take a look at the example code below.
<cfmail from="webmaster@schang.com"
to="info@schang.com"
subject="example">
Message
</cfmail>
Do you offer ColdFusion RDS?
NO, it is a very high security risk. If you need RDS to develop we suggest you develop on your own test environment and migrate your working code to our servers.
In CFMail do I have to specify a Server?
No, we specify the mail server name on the server level. You can simply omit that attribute.
What about login and password in the CFMail tag?
Again these aren't necessary; just omit these attributes.
I receive the error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
You must specify the login and password in your CFquery tag when accessing a SQL server.
<cfquery USERNAME="username" PASSWORD="password" DATASOURCE="dsnname">
I see a .ldb file with my Access database. What is that?
That is a lock file. The lock file can be removed by following our unlock instructions at the bottom of this page.
I am unable to overwrite my Access Database, why is that?
The database is most likely locked. Follow the instructions at the bottom of this page.
Are session Variables Allowed?
Yes, we are using the default setting of 20 minutes before they expire.
What Version of Cold Fusion are you currently running?
Cold Fusion 5.0 SP2 Enterprise. We also have ColdFusion MX available.
Does Schang Internet Communications Support ColdFusion 5.0?
Yes, we also support ColdFusion MX.
How would I request DataSources' for my database?
Send us an email to support@schang.com and we will setup your datasource.
Do you Support CFX Tags?
We support CFX tags at our discretion. We would need to view the tag and validate it, however there are no guarantees we will be able to install it.
Do you support Custom Tags?
We would be able to move any of your Cold Fusion based and written tags
to the custom tags directory.
What ColdFusion tags are disabled?
CFContent (there is a workaround above), CFRegistry, CFExecute, CFObject are all disabled.
Can I use CFFile and CFDirectory?
Yes you would be able to use these tags within your site.
I would like to upload an updated version of my access database. When I attempt to overwrite the existing database I am unable to. What do I do?
As a normal part of ODBC operation, your database file is locked by the ODBC connection. There is a trick you can use to unlock the database temporarily. You can write a page to query a non-existent column in an existing table in your database. This will temporarily unlock the database so that you can overwrite the file. Since the file will be re-locked quickly, especially if other pages are accessing the database, it is best to rename or delete the old database before uploading the new one. As soon as you upload the new database and run a good query, normal ODBC operation will resume.
There are a few things you can do to maximize the success of the unlock page:
1. Make sure that no other pages are executing queries on the database. If a valid query is run right after your invalid query, the database will be locked again.
2. Since the database can be re-locked quickly, rename the .mdb file as soon as you run the invalid query. Then you can upload the new database and not worry about it locking again before you have a chance.
3. This trick often requires some patience - if it doesn't work at first, try it again a few times. Also, you may want to wait a few minutes and then try. You may want to rename, disable, or move any pages that query the database to prevent them from re-locking it.
4. If all else fails, upload another copy of the database with a different name. Email support@schang.com and we will adjust the DSN.
