Webmaster Forum / ColdFusion / Database Access / July 2008

I'm a little confused about using cfqueryparam:
I know the defualt CFSQLTYPE is CF_SQL_CHAR. Most of my fields are nvarchar,
so would I HAVE to use CF_SQL_VARCHAR? Or would CF_SQL_CHAR work as well?

I can't connect to the DataSource I created in ColdFusion ... I am using CF
ODBC Socket to get to a valid ODBC datasource (this same datasource is used by
other applications, and it works fine).  The error I am getting is
=====error message====

I have table of courses and another table called courseSession, the course
session table contains the courseID of courses that occur more than once
throughout the year, to save repeating data, such as course title, description
etc.

Can someone explain this ( Select TOP 40  * ) in plain english ?
SELECT     TOP 40  *, convert(varchar, CreateDate, 101) AS ShortDate

have an access database with all the fields but PRICE (which is defined as
currency) as text and when I submit the values from my form I receive an error
(error information is attached in code section). What is it I am doing wrong?
CODE:

Trying to create a new table bringing in all the records from 3 old tables. All
three old tables have common foreign key fields.
I'm not sure how the syntax would look like, but something like:
<cfquery name="qCreateTable"  datasource="somedb">

Ok I successfully populated my new table with data from another table.
Now, I need to add additional data to the new (multiple) records  (UPDATE)  
from yet another table.
I know how to kick off an update action for one record using a passed key

I have seen references that it is possible but have not seen an example of a
good way of defining a datasource outside of the coldfusion administrator.
So security over the application data could be increase.

Hi all,
Can someone explain this to me in plain english? The line ' WHERE 1 = 2 '
I am new to these concepts...
<cfquery name="getTeam" datasource="#application.DSN#">

Probably missing something basic here, but I'm trying to move all the data
from an old table to a new one using
<cfquery name="insertdata" datasource="somedatasource">
INSERT INTO vendor_new

I have an existing query, and would like to limit the results according to
whether one of the fields (which is an optional field in a form) has a value.
I've been looking through some similar threads here and came up with the
following;

I have a CF6 application that is running well.  However, I'm in the process of
upgrading to CF8, and some of the code no longer works.  I've scoured the
documentation and haven't found information on the replacement code.
My old code gets a datasource, acquires a database ...

Can anyone translate this (Invalid =  0) into plain english ?
SELECT    EID, Value = SUM(Value), Invalid =  0
        FROM

I'm very new to this. I can view my web site on my system fine. I purchased a
site through GoDaddy and uploaded my site. I get an error message and they say
that the database out there is fine.
Error Message:

i am working on a project and i  founnd my self in a setuation where 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.