Webmaster Forum / ColdFusion / Database Access / September 2007

I've been working with ColdFusion for several years and each job I've
had poses new and interesting challenges.  I've been in my current job
for exactly one week.  I've successfully set up my development
environment on my local machine for two of the applications I've been

My codes:
<cfset
InputFieldsList="BMDDM,BMH,XM,XMPY,KSBH,ZJLX,ZJHM,CSRQ,MZM,XBM,HFM,XYJRM,ZZMMM,J
GSZDM,CSDM,HKSZDM,HKSZDXXDZ,DASZDM,DASZDW,DASZDWDZ,DASZDWYZBM,XXGZDW,XXGZJL,JLCF

I have a data table with columns like below.
I am trying to figure a query or a q of q to get this answer.
I need to know the net change in posper for eac teamid, then sort the results
DESC.

When returning database results to Flex from ColdFusion, what is the best thing
to return?  I can think of 3 possibilities.
-query
-struct

Wondering if anyone can help me.  I created a Coldfusion datasource using a
Microsoft Excel Driver, I uploaded my Excel file and Coldfusion says it is
verified.  The problem is my queries will not output any results.  There are no
errors either.  This coding worked fine when I ...

I always worked with MS ACCESS and now I have to use MS SQL server for my
client's application. my SQL server is using windows authentication, which has
no username/password. is that a problem? I checked everything else. please help.
this is the error I get:

I am using a MySql 5 db successfully transferred from MsSql with the MySql
migration kit. It works just fine with my CF 8 application, except for having
to match the case of table names in all <cfquery> tags. My online host runs
Linux for MySql.

Does coldfusion 5.0 support Oracle 10gR2.

Can anyonep-lease tell me if this is possible?
I would like a % figure to be displayed on my search results page, showing how relevant the results are.
Can anyone please help?
Thankyou

I followed the instruction on :
http://kb.adobe.com/selfservice/viewContent.do?externalId=ded4216b
from tech notes on Adobe site, but still it gives me this error:
Connection verification failed for data source: TH

Over the weekend I had 14000+ errors and the they are all similar and from the
same web page. They somehow had the table names of several database files and
were trying to query the sys tables for information. Below is one example of
the page error.

my code like:
<cfloop from="1" to="#inserteddb.getrecordcount()#" index="x">
<!----
Here make the InsertFieldList and InsertValueList

I have two tables I need to search both based on a startdate and enddate.
I was thinking something like
select *
from customers, booking

i have an msAccess db that i need to move over to msSQL2000 and a numeric field
of part numbers always has 5 digits: example: 12345, 01234, 00123....
in msAccess the field data type is "number" with a format of "00000" which
maintains leading zeros.

I use coldfusion administrator to set the DSN for a SQL 2000 database in local
pc.but I get the error
Connection verification failed for data source: flextest
java.sql.SQLException: [Macromedia][SQLServer JDBC