Webmaster Forum / ColdFusion / Database Access / July 2008

I am not quite sure how to ask this, but...
We have a CF Server on an intranet server and a CF Server on our WWW server.  
Question:  Can Cold Fusion push out data internally to the WWW somehow.  For
example, if someone input information on a form and hit submit where the

Recently we've begun migrating some sites to ColdFusion 8 from earlier versions
of ColdFusion.  We've found the following quirk when inserting data into an SQL
database.
<cfset value = "Two single quotes '' and one single quote ' in the same line

I'm trying to create a very basic data grid using CF8, but it shows no rows
every time.  I know the query works on it's own.  What am I missing?
<!---survey.cfc--->
<cffunction name="getSurvey" access="remote" returntype="struct">

I seem to have a problem with getting XML out of Coldfusion. I am using a
access database, which I can get the XML out of directly. However when I run
the query through coldfusion I get the following error.
"An error occured while Parsing an XML document.  

Hi, I'm executing a CFLDAP query to retrieve accounts that are set to expire
and/or have a specific phrase in the Notes field.  That part works fine.
I now want to query that cfldap result using a conditional select.  Something
like this:

Referring to this thread
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56335#305025
I wanted to pass a value to a dynamic select box (in a url), so I changed this:
<option value="'#SITEID#'" selected=#sid#>

I'm having quite a bit of trouble connecting to a local MS SQL database I've
created. I have a fresh install of CF8 dev version, and am using the MS SQL
2000 eval version. I can connect to a remote SQL DB just fine, the problem
comes when I try to login to a local DB. This is the ...

i want to insert mutiple rolls  into  mysql.
the number of values that will be inserted is unknown becuase it is generated
from a database.
example

My last post might have been a bit vauge, here goes round 2:
- I have CF8 installed and working great on a RHEL5 server
- How do I enable ODBC through the Data Source option?  
Thank you,

I have the following as a query on my web page:
SELECT cast(CHG_ACTUAL_AMT as char) as Amount, CHG_TRAN_CD as trans ,
CHG_SEQ_NBR as seq, CHG_DT_OF_SERVICE as DOS, CHG_POST_DT as PST,
CHG_CURRENT_FC as fc, CHG_PERF_DEPT_CD AS dept, CHG_PERF_PHYS_NBR as phys,

I am returning a result set from y SQL Stored Procedure to a CFC. I just
noticed something strange with some of the values being returned.
When I run the query in a T-SQL window, I get the following result:
Value

I've seen this question asked before, but I've never seen it answered
satisfactorily.  I'd like to be able to give my users the ability to create
"how-to" articles on the fly.  Actually, it's pretty much one user (it's an
in-house project), but this one user is a doozy.  If I ...

I want to experience mssql-what version do i need to download-i'm a complete beginner on this one, thanks? Also is the datasource a nightmare to setup like mysql?!!

I am having a problem connecting to the remote database using datasource from
server 1 to server 2. I am running 2 Linux servers with PostgreSQL database. I
am able to connect from server 2 to server 1 but not the other way around. I
have checked the connection and I am able to ...

Can anyone recommend a strategy for sharing SQL Server data with a client?  We
do not want to give them access through enterprise manager but we do want them
to be able to use their own report writing tools to access our data.  Thanks