Webmaster Forum / ColdFusion / Database Access / May 2007

I have a pretty straigtforward form being used both for Insert *and* for
Update, using variables for the formfield data. The table is 'tblPeople' and it
has typical Lastname, Firstname, email, password, LevelID (a number), comments,
ExpiryDate, Created, LastUpdated. They are all ...

Good Morning,  I'm currently migrating to ColdFusion MX 7 Standard from CF5
Enterprise. I don't have the Oracle ODBC included with MX7 so I set up the
JDBC.  I was successfully able to create the database and veirfy it.  
Now I need to move all of my code to the new server.  I ...

I'm unable to connect to database thru cold fusion. it sometiems give me an
error that your uname is undefined , soemtimes it gives ur index page not found
so i created index page also but still im unable to connect to database n
update my records..plz help me out..im a fresher ...

Does anyone know how to generate XML from a database via a SQL query? I'm using Dreamweaver and coldfusion.
Thanks in advance!

When I enter .50 on the form the results in the database is 1.00.  If I change
1.00 to 2.00 the change is sent to the database. The problem seems to be that
the database is rounding the field.  For this particular application the user
needs to be able to enter amounts as small as ...

I am using CF MX7 and needing to connect to a client db in mySQL 5.  I
configured the datasource in the CF Administrator using the included MySQL
(3.x) driver and it gives status OK.  Cool.  Then, in Dreamweaver in my
Databases panel, the new datasource is visible, but gives me a ...

I have spent the last 2 days trying to solve this on my own but have been
unsuccesful.
I am running XP Pro on my desktop and am trying to connect Coldfusion MX to
SQL Server 2005 Northwind database. Both programs are installed on the same

ColdFusionMX7 & SQL server 2005 running on T60p IBM Thinkpad under Windows XP
sp2....after ensuring sql confiq allows TCP/IP and mixed auth chosen...Unable
to create datasource in Admin to SQL 2005 database, returning error:  "No
LoginModules configured for JDBC_Driver_1"

Here is the jest of what I want to do
<cfset commitit = yes>
<cftransaction action=begin>
 <cftry>

I have a main query that does a decode on a field so that it sorts starting
with KG then 01,02,03,04,05
When I then pull the QofQ it spits back the results as 01,02,03,04,05,KG.  Is
there a way around that?

I'm using CF6.1, trying to submit data to a SQL-Server SP where one of the
params requires an INT datatype.
The submitted data (using GET) is indeed an int (in my case, the number 7),
but it's regarded as a string.

I can't seem to connect to RDS on my new computer. Here's my setup:
Windows Vista Business
I installed CFMX 7.02.
Eclipse 3.2.1

I'm using a mySQL database on a hosting server - mydaddy.com.  I've called
their tech support, they say I can have my database store the client variables,
and they won't set it up for me, that I need to use scripts to do it.
I've created CGLOBAL to be...

I have an application used for entering news release information into a
database.  The person who is responsible for the new releases used to send me
the information in a Word document and I would copy and paste it into an html
page.  

I have to look for similar spellings of words within a description field of
many characters.
I know how to use t-sql DIFFERENCE when matching word-for-word:
select from oneWordField where DIFFERENCE( oneWordField, @mySearchTerm ) >= 3