Webmaster Forum / ColdFusion / Database Access / June 2005

I execute a <cfquery> statement block, and that works fine. However, I need to
manipulate the return query rows by deleting the ones that do not meet specific
requirements.
Example:

OK I have huge problem with my cfstored proc
I have stored procedure which retrieve lost password when you provide email.
Stored procedure is returning couple of status codes for error 1,2,3 and
everithing works fine when I miss email and cfdump cfstoredproc.satuscode it is

How can I pull table column names? I would like to put then in menu / cfselect statment.
Thanks,
Matthew

I figure if the CF Administrator can create an ODBC connection for CF, and the
Administrator is just a CF application, we, as application developers, should
have access to the tools to also create ODBC connection programatically.
If I'm correct, how would I go about this? I ...

Ok, my server used to do random queries like a demon - refresh the page and
things were different.  Anymore, the randoms just stay the same like the page
or perhaps the query is being cached.  So, please, what have I done?
Save me from myself!

I have a simple form that based on the the two inputs, ExAD_Tracking and
ExAD_DateEntered, will query the database and display the records accordingly.  
This code worked fine in previous versions of ColdFusion, but now after
upgrading to MX7, it is returning an error of Too Few ...

Thanks in advance for any help... I am trying to update form data to a database
from code in the action page code below.. the form is a dual purpose insert/add
form, but i am just working on the update section (when a person already has
data on file)..

I need to connect to 2 dfferent datasources that are in two different servers.
Example:
I need to move data from one table on server 1to a table (whith the same
structure) on server 2.

Sybase is not in the datasource drop down in ColdFusion 7 Standard Edition.  
How do I create a datasoruce using Sybase ASE?  If I choose "other" I see some
choices but have no idea what to fill in the blanks.  Can someone help please?  
And don't tell me the only way is to get ...

I've been working on this intranet data-entry wizard for some time now. Mxstu
has helped me out considerably, as have some other people in the community. I'm
still not done though! : )
To recap once again: There are many tables in the Access database, almost all

Looks like CF7 has a documented 16 character limit on datasource passwords. Our
production server password is 18 characters.
I brought this up on the cftalk mailing list, and the suggestion was made to
try a third party JDBC driver. I tried the Microsoft JDBC driver, as well as

I am trying to update a MS Access database using cfid and cftoken.  What I'd
like to do is have the database update where the cfid is the same as the
'#session.cfid#'.  I've tried and few things, but I have been getting error
messages.  

Do any one know how call Data Transformation Services using coldfusion?I need
to transform a CSV file into a the Database table.Any kind of information or
resourses will be of great help.
thnx in advance.

I thought this would be straightforward but apparently not.  I have a query
that selects a date field from an Oracle table.  I then want a query of queries
to return those rows where the date is between two values represented by form
parameters.

When I run a query the cfoutput on my page are numbers and not the
string/value in my Access database. I used the lookup function in Access to
select the values in other tables to insert into the current field. I think
this may have something to do with it?