Webmaster Forum / ColdFusion / Database Access / May 2006

I'm wondering if someone can help me install jTDS into my CFMX 6.1 world.
I copied the jtds-1.2.jar file to the C:\CFusionMX\lib directory.
In the Administrator, I created a new "other" datasource using this  JDBC URL:
jdbc:jtds:sqlserver://127.0.0.1:2195\SQLEXPRESS/TVRCampSQL ...

I have been trying to access exchange contact information by:
1) Linking Outlook Data to an Access MDB
2) Setting up the MDB as a Coldfusion datasource
The problem is, once I move the mdb to the exchange server, the mapi folder

I am using <cfif> to compare two set of time, if there is a match then display
link. I am doing something wrong because it not displaying a link even thought
there is a match. I using Access database, any assistance is greatly
appreciated!

I need to query a protected MDE Access Database, but I cannot select the DB in
the CFMX Admin.
What can I do? and how? Is there an other way to query the DB?
(I know there is a way, via DSN-less connection and java code, but that is not

I have a SQL table that includes 2 NTEXT fields. When I do a cfquery such as
SELECT * FROM MYFILE, I get no value back for these fields. Playing around with
it a bit more, the only way I've been able to get values back is if I list all
the fields (rather than the metacharacter *) ...

Declare
@distributionprice money,
@msrp money,
@wholesalepercent int

I am using Access. I have two tables, Categpries and Items. I have 4 categories
and 11 items. The Categories are referenced through the Items table by their
ID. I want the query to pull only the Categories that have active Items
available. I know that I have 4 active Categories ...

This my first real site outside my testing server.
I loaded all the files on the godaddy.com server with the CFMX7 and I set up
an Access db. when i go to see the pages on the web, I get error page that says
my datasouce can not be found.

I am trying to pull all records that are set for mailing and are from every
state except for Nebraska and some counties in Iowa.   It isn't pulling
correctly.  Any help would be greatly appreciated.
SELECT HS_SATCode.School, HS_SATCode.Add1, HS_SATCode.City, HS_SATCode.State,

I've just upgraded from CF 5.0 to CF MX 7.0. One of my CF scripts that includes
looping through a DB query does not work well anymore. Under CF 5.0 on Win 2K
it worked fine. Now under CF MX 7.0 on Win 2003 it starts off fine (displays
page header) but then seems to timeout and ...

I'm trying to write a SP that ignores a blank parameter in a where clause like
this.
create procedure blah @myvar int  AS
select * from companies

Hi,  I am attempting to do a simple update query using the cfquery tag.  The
code is:
<cfquery datasource="test" name="testers">
update tablename

I'm new to coldfusion, and have run into a problem when trying to insert data
from a basic HTML form into an MS Access database.
The problem is the primary key. When I remove the primary key from the
database, it works fine, but I need it to have one.

hey can anyone help me i keep gettin the message
 "Syntax error in INSERT INTO statement"
when i try to insert users to my database using this code
<!--- insert new customer record --->

I have a field in a database table that contains a comma separated list on
numbers. In my CFQUERY I am attempting to extract records from the database
table where a parsed number is present in the comma separated list. I have
tried the code below, but it is throwing an error.