Webmaster Forum / ColdFusion / Database Access / October 2006

Hello,
I have a SQL database where there were checkbox values that I now need to
count them in terms of scoring their value.

I have a DB (MS SQL) that has over 300,000 records (and growing) and i would
like to allow paging results on the CF output page but i dont want CF to have
to do all the work. Does anyone have a StoreProcedure for MS SQL to do
recordset paging server side? i have seen some ...

I have a CartWeaver CF site running from an Access database.
Text in the product descriptions lists prices with a £ symbol... works fine.
However, I just tried converting the Access db to mySQL,
and all the £ from the database turned to ? in the browser.

I'm brand-new at a job, and working my way through the CF site, so I apologize
in advance for sounding nebulous.  Everything in the site uses FuseActions and
stored procedures, and then pulls specific query language into those procedures.
I've got a query that's returning the ...

I don't ever recall having problems with this in the past. Have I forgotten
something or has ColdFusion changed with recent versions? I'm simply pulling
data out of my database and wanting to GROUP it by the field "division". Below
is the code that I'm using.

I'm trying to get shipping costs for different weights and zip codes.  I query
one table to get a zone from the user provided zip code.  That works.  I then
want to use that zone to retreive the shipping cost for a specific weight from
another table.  I set the zone as a variable ...

I have a recordset returned from SQL Server 2005 using a stored procedure.  One
of the fields is XML.  When I output that field in my cfm page, all of the XML
tags are gone.  I'm not sure where they're getting lost or how to get them
back.  I need to process that XML using an ...

Anyone have an idea for Free Oracle tools that easy to use?
Regards,
Shaffiq

OK I hope I am going to provide you with enough information to solve this
issue, but if I don't please feel free to post anything you may need and I will
get it for you.
I have a form that we are trying to update a date field in.  However there are

I'm trying to install a mysql5 datasource. I downloaded the connector and set
it up as the technote said. The datasource verified. I run a query that creates
a database which is fine, so my datasource is working. After I try to create a
temporary table and I get "no database ...

I was having a problem getting correct character translations when querying a
non-UTF-8 database from MX7 so I tried to change the connection string and some
other properties of the ODBC driver.  After doing this, I got to the point
where I could not run any queries against the ...

I'm somehow stuck with a LOAD INTO FILE approach to
import CSV text in a Mysql 4.1 database. Everything
works fine when the local CSV file is not on the
server(Debian Sarge + CF MX 7.02). When I try to

When I run the following query, I get a list of the sovbgv_desc but instead of
getting a total count of the rows returned with that, I get an entryfor each
row returned and the dcount is listed as 1 for each row.  Any ideas?
...

How can I create a csv file to pull data from SQL? I thought I had it, but I just got a blank file.
If anyone has an example they can share, I'd appreciate it!
Thanks!

I have a form that is dynamic in that it first asks the user how many entries
they will be making. If the user says 5, an array is created to accomodate that
such as
<cfset SESSION.newarray = structNew(2)>